APPS.CSF_DEBRIEF_PUB dependencies on CSF_DEBRIEF_PVT

Line 15: x_pvt_Debrief_rec OUT NOCOPY CSF_DEBRIEF_PVT.Debrief_REC_TYPE

11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csfpdbfb.pls';
12:
13: PROCEDURE Convert_Debrief_Value_To_Id (
14: p_Debrief_rec IN Debrief_REC_TYPE,
15: x_pvt_Debrief_rec OUT NOCOPY CSF_DEBRIEF_PVT.Debrief_REC_TYPE
16: )
17: IS
18: l_any_errors BOOLEAN := FALSE;
19: l_return_status VARCHAR2(1);

Line 25: l_pvt_Debrief_rec csf_debrief_pvt.Debrief_REC_TYPE;

21: l_val varchar2(30);
22: l_id NUMBER;
23: l_status_code VARCHAR2(30) := NULL;
24:
25: l_pvt_Debrief_rec csf_debrief_pvt.Debrief_REC_TYPE;
26:
27: BEGIN
28: -- Now copy the rest of the columns to the private record
29:

Line 265: x_pvt_DEBRIEF_LINE_tbl OUT NOCOPY CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type

261: ****************************/
262:
263: PROCEDURE Conv_DEBRIEF_LINE_ValToId(
264: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_Type,
265: x_pvt_DEBRIEF_LINE_tbl OUT NOCOPY CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type
266: )
267: IS
268: l_any_errors BOOLEAN := FALSE;
269: l_any_row_errors BOOLEAN := FALSE;

Line 273: l_pvt_debrief_line_rec CSF_DEBRIEF_PVT.debrief_line_rec_type;

269: l_any_row_errors BOOLEAN := FALSE;
270: l_return_status VARCHAR2(1);
271: l_dummy_description VARCHAR2(30);
272: l_pub_debrief_line_rec debrief_line_rec_type;
273: l_pvt_debrief_line_rec CSF_DEBRIEF_PVT.debrief_line_rec_type;
274: lx_pvt_debrief_line_tbl CSF_DEBRIEF_PVT.debrief_line_tbl_type;
275: l_count NUMBER := p_debrief_line_tbl.count;
276: p_debrief_line_rec debrief_line_rec_type;
277: x_return_status VARCHAR2(1);

Line 274: lx_pvt_debrief_line_tbl CSF_DEBRIEF_PVT.debrief_line_tbl_type;

270: l_return_status VARCHAR2(1);
271: l_dummy_description VARCHAR2(30);
272: l_pub_debrief_line_rec debrief_line_rec_type;
273: l_pvt_debrief_line_rec CSF_DEBRIEF_PVT.debrief_line_rec_type;
274: lx_pvt_debrief_line_tbl CSF_DEBRIEF_PVT.debrief_line_tbl_type;
275: l_count NUMBER := p_debrief_line_tbl.count;
276: p_debrief_line_rec debrief_line_rec_type;
277: x_return_status VARCHAR2(1);
278: x_msg_data VARCHAR2(2000);

Line 425: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;

421: )
422: IS
423: l_api_name CONSTANT VARCHAR2(30) := 'Create_debrief';
424: l_api_version_number CONSTANT NUMBER := 1.0;
425: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;
426: l_count CONSTANT NUMBER := p_debrief_line_tbl.count;
427: p_debrief_line_rec DEBRIEF_LINE_REC_TYPE;
428: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_Tbl_Type;
429: x_debrief_line_id NUMBER;

Line 428: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_Tbl_Type;

424: l_api_version_number CONSTANT NUMBER := 1.0;
425: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;
426: l_count CONSTANT NUMBER := p_debrief_line_tbl.count;
427: p_debrief_line_rec DEBRIEF_LINE_REC_TYPE;
428: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_Tbl_Type;
429: x_debrief_line_id NUMBER;
430: l_return_status VARCHAR2(1);
431: BEGIN
432: SAVEPOINT CREATE_DEBRIEF_PUB;

Line 466: CSF_DEBRIEF_PVT.Create_debrief(

462: x_pvt_DEBRIEF_LINE_tbl => l_pvt_DEBRIEF_LINE_tbl
463: );
464:
465: -- Calling Private package: Create_DEBRIEF
466: CSF_DEBRIEF_PVT.Create_debrief(
467: P_Api_Version_Number => 1.0,
468: P_Init_Msg_List => FND_API.G_FALSE,
469: P_Commit => FND_API.G_FALSE,
470: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 729: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;

725: )
726: IS
727: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief';
728: l_api_version_number CONSTANT NUMBER := 1.0;
729: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;
730: BEGIN
731: -- Standard Start of API savepoint
732: SAVEPOINT UPDATE_DEBRIEF_PUB;
733: -- Standard call to check for call compatibility.

Line 759: CSF_DEBRIEF_PVT.Update_debrief(

755: p_DEBRIEF_rec => p_DEBRIEF_rec,
756: x_pvt_DEBRIEF_rec => l_pvt_DEBRIEF_rec
757: );
758:
759: CSF_DEBRIEF_PVT.Update_debrief(
760: P_Api_Version_Number => 1.0,
761: P_Init_Msg_List => FND_API.G_FALSE,
762: P_Commit => p_commit,
763: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 835: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;

831: )
832: IS
833: l_api_name CONSTANT VARCHAR2(30) := 'Create_debrief_lines';
834: l_api_version_number CONSTANT NUMBER := 1.0;
835: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;
836:
837: BEGIN
838:
839: -- Standard Start of API savepoint

Line 869: CSF_debrief_PVT.Create_debrief_lines(

865: );
866:
867: -- Calling Private package: Create_DEBRIEF_LINE
868: --dbms_output.put_line('l_pvt_DEBRIEF_LINE_tbl(1).usage_type :: '||l_pvt_DEBRIEF_LINE_tbl(1).usage_type);
869: CSF_debrief_PVT.Create_debrief_lines(
870: P_Api_Version_Number => 1.0,
871: P_Init_Msg_List => FND_API.G_FALSE,
872: P_Commit => FND_API.G_FALSE,
873: P_Upd_tskassgnstatus => P_Upd_tskassgnstatus,

Line 952: l_pvt_DEBRIEF_LINE_rec CSF_DEBRIEF_PVT.DEBRIEF_LINE_Rec_Type;

948: )
949: IS
950: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief_line';
951: l_api_version_number CONSTANT NUMBER := 1.0;
952: l_pvt_DEBRIEF_LINE_rec CSF_DEBRIEF_PVT.DEBRIEF_LINE_Rec_Type;
953: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;
954: p_DEBRIEF_LINE_tbl DEBRIEF_LINE_TBL_Type;
955: BEGIN
956: -- Standard Start of API savepoint

Line 953: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;

949: IS
950: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief_line';
951: l_api_version_number CONSTANT NUMBER := 1.0;
952: l_pvt_DEBRIEF_LINE_rec CSF_DEBRIEF_PVT.DEBRIEF_LINE_Rec_Type;
953: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;
954: p_DEBRIEF_LINE_tbl DEBRIEF_LINE_TBL_Type;
955: BEGIN
956: -- Standard Start of API savepoint
957: SAVEPOINT UPDATE_DEBRIEF_LINE_PUB;

Line 993: CSF_DEBRIEF_PVT.Update_debrief_line(

989: );
990:
991: -- dbms_output.put_line ( 'step 1 PUB');
992:
993: CSF_DEBRIEF_PVT.Update_debrief_line(
994: P_Api_Version_Number => 1.0,
995: P_Init_Msg_List => FND_API.G_FALSE,
996: P_Commit => p_commit,
997: P_Upd_tskassgnstatus => P_Upd_tskassgnstatus ,