This discussion is archived
0 Replies Latest reply: Dec 13, 2009 7:53 PM by 729456 RSS

does anyone have example of csf_debrief_pub.create_debrief

729456 Newbie
Currently Being Moderated
field service gurus,

i need to create field service de-brief header and lines (labor, material and expense). i found that "csf_debrief_pub.create_debrief" api will create both de-brief headers and lines.

i have following queries -

1. does anyone have example of csf_debrief_pub.create_debrief api - creating de-brief header and lines (labor, material and expenses)

2. i need to create 4 de-brief lines - 1 for labor, 2 for material and 1 for expense. do i just create one record in "p_debrief_line_tbl" input parameter of csf_debrief_pub.create_debrief api ? or i need to create 4 records in in "p_debrief_line_tbl" input parameter of csf_debrief_pub.create_debrief ?

the api is shown below -

csf_debrief_pub.create_debrief (
p_api_version_number,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit      IN VARCHAR2 := FND_API.G_FALSE,
p_debrief_rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,     DEFAULT G_MISS_DEBRIEF_LINE_tbl, -- 1 record here or 4 records here ? for 4 de-brief lines - 1 for labor, 2 for material and 1 for expense
x_debrief_header_id OUT NOCOPY NUMBER,
x_return_status      OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data      OUT NOCOPY VARCHAR2
);

much thanx.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points