APPS.CSL_CSF_DEBRIEF_HDR_ACC_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 6: := 'JTM_CSF_DEBRIEF_HEADERS_ACC';

2: /* $Header: csldhacb.pls 115.8 2003/08/28 10:15:24 vekrishn ship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30)
6: := 'JTM_CSF_DEBRIEF_HEADERS_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSF_DEBRIEF_HEADERS');
9: g_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_HEADERS';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_HEADER_ID';

Line 8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSF_DEBRIEF_HEADERS');

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30)
6: := 'JTM_CSF_DEBRIEF_HEADERS_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSF_DEBRIEF_HEADERS');
9: g_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_HEADERS';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_HEADER_ID';
11:
12: g_debug_level NUMBER; -- debug level

Line 9: g_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_HEADERS';

5: g_acc_table_name CONSTANT VARCHAR2(30)
6: := 'JTM_CSF_DEBRIEF_HEADERS_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSF_DEBRIEF_HEADERS');
9: g_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_HEADERS';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_HEADER_ID';
11:
12: g_debug_level NUMBER; -- debug level
13:

Line 25: , csf_debrief_headers dbh

21: CURSOR c_resource ( b_debrief_header_id NUMBER)
22: IS
23: SELECT resource_id
24: FROM jtf_task_assignments jta
25: , csf_debrief_headers dbh
26: WHERE jta.task_assignment_id = dbh.task_assignment_id
27: AND dbh.debrief_header_id = b_debrief_header_id;
28: r_resource c_resource%ROWTYPE;
29: BEGIN

Line 63: FROM CSF_DEBRIEF_HEADERS

59: RETURN BOOLEAN
60: IS
61: CURSOR c_debrief_header (b_debrief_header_id NUMBER) IS
62: SELECT *
63: FROM CSF_DEBRIEF_HEADERS
64: WHERE debrief_header_id = b_debrief_header_id;
65: r_debrief_header c_debrief_header%ROWTYPE;
66:
67: BEGIN

Line 427: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;

423: x_return_status out NOCOPY varchar2
424: ) IS
425:
426: l_enabled_flag VARCHAR2(30);
427: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
428: l_resource_id NUMBER;
429: l_replicate BOOLEAN;
430:
431: BEGIN

Line 446: CSF_DEBRIEF_Headers_PKG.user_hooks_rec.debrief_header_id;

442: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
443:
444: /*** get debrief_header record details from public API ***/
445: l_debrief_header_id :=
446: CSF_DEBRIEF_Headers_PKG.user_hooks_rec.debrief_header_id;
447: l_resource_id := Get_Resource_Id( l_debrief_header_id );
448:
449: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
450: jtm_message_log_pkg.Log_Msg