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 415: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;

411: )
412: IS
413: l_api_name CONSTANT VARCHAR2(30) := 'Create_debrief';
414: l_api_version_number CONSTANT NUMBER := 1.0;
415: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;
416: l_count CONSTANT NUMBER := p_debrief_line_tbl.count;
417: p_debrief_line_rec DEBRIEF_LINE_REC_TYPE;
418: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_Tbl_Type;
419: x_debrief_line_id NUMBER;

Line 418: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_Tbl_Type;

414: l_api_version_number CONSTANT NUMBER := 1.0;
415: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;
416: l_count CONSTANT NUMBER := p_debrief_line_tbl.count;
417: p_debrief_line_rec DEBRIEF_LINE_REC_TYPE;
418: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_Tbl_Type;
419: x_debrief_line_id NUMBER;
420: l_return_status VARCHAR2(1);
421: BEGIN
422: SAVEPOINT CREATE_DEBRIEF_PUB;

Line 456: CSF_DEBRIEF_PVT.Create_debrief(

452: x_pvt_DEBRIEF_LINE_tbl => l_pvt_DEBRIEF_LINE_tbl
453: );
454:
455: -- Calling Private package: Create_DEBRIEF
456: CSF_DEBRIEF_PVT.Create_debrief(
457: P_Api_Version_Number => 1.0,
458: P_Init_Msg_List => FND_API.G_FALSE,
459: P_Commit => FND_API.G_FALSE,
460: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 532: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;

528: )
529: IS
530: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief';
531: l_api_version_number CONSTANT NUMBER := 1.0;
532: l_pvt_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;
533: BEGIN
534: -- Standard Start of API savepoint
535: SAVEPOINT UPDATE_DEBRIEF_PUB;
536:

Line 563: CSF_DEBRIEF_PVT.Update_debrief(

559: p_DEBRIEF_rec => p_DEBRIEF_rec,
560: x_pvt_DEBRIEF_rec => l_pvt_DEBRIEF_rec
561: );
562:
563: CSF_DEBRIEF_PVT.Update_debrief(
564: P_Api_Version_Number => 1.0,
565: P_Init_Msg_List => FND_API.G_FALSE,
566: P_Commit => p_commit,
567: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 639: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;

635: )
636: IS
637: l_api_name CONSTANT VARCHAR2(30) := 'Create_debrief_lines';
638: l_api_version_number CONSTANT NUMBER := 1.0;
639: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;
640:
641: BEGIN
642:
643: -- Standard Start of API savepoint

Line 673: CSF_debrief_PVT.Create_debrief_lines(

669: );
670:
671: -- Calling Private package: Create_DEBRIEF_LINE
672:
673: CSF_debrief_PVT.Create_debrief_lines(
674: P_Api_Version_Number => 1.0,
675: P_Init_Msg_List => FND_API.G_FALSE,
676: P_Commit => FND_API.G_FALSE,
677: P_Upd_tskassgnstatus => P_Upd_tskassgnstatus,

Line 752: l_pvt_DEBRIEF_LINE_rec CSF_DEBRIEF_PVT.DEBRIEF_LINE_Rec_Type;

748: )
749: IS
750: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief_line';
751: l_api_version_number CONSTANT NUMBER := 1.0;
752: l_pvt_DEBRIEF_LINE_rec CSF_DEBRIEF_PVT.DEBRIEF_LINE_Rec_Type;
753: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;
754: p_DEBRIEF_LINE_tbl DEBRIEF_LINE_TBL_Type;
755: BEGIN
756: -- Standard Start of API savepoint

Line 753: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;

749: IS
750: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief_line';
751: l_api_version_number CONSTANT NUMBER := 1.0;
752: l_pvt_DEBRIEF_LINE_rec CSF_DEBRIEF_PVT.DEBRIEF_LINE_Rec_Type;
753: l_pvt_DEBRIEF_LINE_tbl CSF_DEBRIEF_PVT.DEBRIEF_LINE_tbl_Type;
754: p_DEBRIEF_LINE_tbl DEBRIEF_LINE_TBL_Type;
755: BEGIN
756: -- Standard Start of API savepoint
757: SAVEPOINT UPDATE_DEBRIEF_LINE_PUB;

Line 793: CSF_DEBRIEF_PVT.Update_debrief_line(

789: );
790:
791: -- dbms_output.put_line ( 'step 1 PUB');
792:
793: CSF_DEBRIEF_PVT.Update_debrief_line(
794: P_Api_Version_Number => 1.0,
795: P_Init_Msg_List => FND_API.G_FALSE,
796: P_Commit => p_commit,
797: P_Upd_tskassgnstatus => P_Upd_tskassgnstatus ,