DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on CSF_DEBRIEF_PVT

Line 1: PACKAGE BODY CSF_DEBRIEF_PVT as

1: PACKAGE BODY CSF_DEBRIEF_PVT as
2: /* $Header: csfvdbfb.pls 120.67.12020000.4 2013/04/09 09:41:05 shadas ship $ */
3:
4: -- Start of Comments
5: -- Package name : CSF_DEBRIEF_PVT

Line 5: -- Package name : CSF_DEBRIEF_PVT

1: PACKAGE BODY CSF_DEBRIEF_PVT as
2: /* $Header: csfvdbfb.pls 120.67.12020000.4 2013/04/09 09:41:05 shadas ship $ */
3:
4: -- Start of Comments
5: -- Package name : CSF_DEBRIEF_PVT
6: -- Purpose :
7: -- History :
8: -- NOTE :
9: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_PVT';

7: -- History :
8: -- NOTE :
9: -- End of Comments
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csfvdbfb.pls';
13:
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 23: 'csf.plsql.csf_debrief_pvt.'||p_procedure,

19: procedure log(p_procedure in varchar2,p_message in varchar2) as
20: begin
21: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
22: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
23: 'csf.plsql.csf_debrief_pvt.'||p_procedure,
24: p_message);
25: end if;
26: end;
27:

Line 417: /*CSF_DEBRIEF_PVT.Create_Interaction (P_Api_Version_Number =>1.0,

413: );
414:
415: --Virendra Singh 03/28/2000 commented out
416: -- create Interaction 04/06/2000
417: /*CSF_DEBRIEF_PVT.Create_Interaction (P_Api_Version_Number =>1.0,
418: P_Init_Msg_List =>FND_API.G_FALSE,
419: P_Commit =>FND_API.G_FALSE,
420: P_TASK_ASSIGNMENT_ID =>P_DEBRIEF_REC.TASK_ASSIGNMENT_ID,
421: P_DEBRIEF_HEADER_ID =>l_debrief_header_id,

Line 437: CSF_DEBRIEF_PVT.Create_debrief_lines(

433: fetch c_source_object_type_code into l_source_object_type_code;
434: close c_source_object_type_code;
435:
436: IF P_DEBRIEF_LINE_TBL.count > 0 then
437: CSF_DEBRIEF_PVT.Create_debrief_lines(
438: P_Api_Version_Number => 1.0 ,
439: P_Init_Msg_List => FND_API.G_FALSE,
440: P_Commit => FND_API.G_FALSE,
441: P_Upd_tskassgnstatus => NULL,

Line 527: l_ref_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;

523: l_api_version_number CONSTANT NUMBER := 1.0;
524:
525: -- Local Variables
526:
527: l_ref_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;
528: l_tar_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type := p_debrief_rec;
529: l_rowid ROWID;
530: x_row_id varchar2(100) := null;
531: l_task_assignment_id number;

Line 528: l_tar_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type := p_debrief_rec;

524:
525: -- Local Variables
526:
527: l_ref_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type;
528: l_tar_DEBRIEF_rec CSF_DEBRIEF_PVT.DEBRIEF_Rec_Type := p_debrief_rec;
529: l_rowid ROWID;
530: x_row_id varchar2(100) := null;
531: l_task_assignment_id number;
532: l_assignment_status_id number;

Line 1903: l_debrief_line_rec CSF_DEBRIEF_PVT.DEBRIEF_LINE_REC_TYPE;

1899:
1900: l_api_name CONSTANT VARCHAR2(30) := 'Update_debrief_line';
1901: l_api_version_number CONSTANT NUMBER := 1.0;
1902: -- Local Variables
1903: l_debrief_line_rec CSF_DEBRIEF_PVT.DEBRIEF_LINE_REC_TYPE;
1904: z_debrief_line_number number;
1905: z_start_date date;
1906: z_end_date date;
1907: z_debrief_header_id number;

Line 4398: END CSF_DEBRIEF_PVT;

4394: end if;
4395: return l_serial_control;
4396: end;
4397:
4398: END CSF_DEBRIEF_PVT;
4399: