eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_CSF_DEBRIEF_LINE_ACC_PKG dependencies on CSF_DEBRIEF_LINES

Line 5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSF_DEBRIEF_LINES_ACC';

1: PACKAGE BODY CSL_CSF_DEBRIEF_LINE_ACC_PKG AS
2: /* $Header: csldbacb.pls 120.0 2005/05/25 11:04:53 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSF_DEBRIEF_LINES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSF_DEBRIEF_LINES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_LINE_ID';

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSF_DEBRIEF_LINES');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSF_DEBRIEF_LINES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSF_DEBRIEF_LINES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_LINE_ID';
10: g_pre_replicate BOOLEAN;
11:

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES';

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

Line 20: FROM csf_debrief_lines

16: IS
17: SELECT inventory_item_id
18: , NVL( NVL(issuing_inventory_org_id, receiving_inventory_org_id)
19: , FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')) AS organization_id
20: FROM csf_debrief_lines
21: WHERE debrief_line_id = b_debrief_line_id;
22: g_pre_update_rec c_update_cache_rec%ROWTYPE;
23:
24: /*** Public Function that returns the debrief header id ***/

Line 32: FROM CSF_DEBRIEF_LINES

28: RETURN NUMBER
29: IS
30: CURSOR c_debrief_line (b_debrief_line_id NUMBER) IS
31: SELECT debrief_header_id
32: FROM CSF_DEBRIEF_LINES
33: WHERE debrief_line_id = b_debrief_line_id;
34: r_debrief_line c_debrief_line%ROWTYPE;
35:
36: BEGIN

Line 86: FROM CSF_DEBRIEF_LINES

82: RETURN BOOLEAN
83: IS
84: CURSOR c_debrief_line (b_debrief_line_id NUMBER) IS
85: SELECT *
86: FROM CSF_DEBRIEF_LINES
87: WHERE debrief_line_id = b_debrief_line_id;
88: r_debrief_line c_debrief_line%ROWTYPE;
89:
90: BEGIN

Line 270: FROM csf_debrief_lines

266: IS
267: SELECT inventory_item_id
268: , NVL( NVL(issuing_inventory_org_id, receiving_inventory_org_id)
269: , FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')) AS organization_id
270: FROM csf_debrief_lines
271: WHERE debrief_line_id = b_debrief_line_id;
272: r_debrief_line c_debrief_line%ROWTYPE;
273:
274: l_debrief_header_id NUMBER;

Line 345: FROM CSF_DEBRIEF_HEADERS CDH, CSF_DEBRIEF_LINES CDL

341: )
342: IS
343: CURSOR c_debrief_line (b_task_assignment_id NUMBER) IS
344: SELECT CDL.debrief_line_id
345: FROM CSF_DEBRIEF_HEADERS CDH, CSF_DEBRIEF_LINES CDL
346: WHERE CDH.task_assignment_id = b_task_assignment_id
347: AND CDH.debrief_header_id = CDL.debrief_header_id;
348: r_debrief_line c_debrief_line%ROWTYPE;
349:

Line 405: FROM csf_debrief_lines

401: IS
402: SELECT inventory_item_id
403: , NVL( NVL(issuing_inventory_org_id, receiving_inventory_org_id)
404: , FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')) AS organization_id
405: FROM csf_debrief_lines
406: WHERE debrief_line_id = b_debrief_line_id;
407: r_debrief_line c_debrief_line%ROWTYPE;
408:
409: l_debrief_header_id NUMBER;

Line 472: FROM CSF_DEBRIEF_HEADERS CDH, CSF_DEBRIEF_LINES CDL

468: )
469: IS
470: CURSOR c_debrief_line (b_task_assignment_id NUMBER) IS
471: SELECT CDL.debrief_line_id
472: FROM CSF_DEBRIEF_HEADERS CDH, CSF_DEBRIEF_LINES CDL
473: WHERE CDH.task_assignment_id = b_task_assignment_id
474: AND CDH.debrief_header_id = CDL.debrief_header_id;
475: r_debrief_line c_debrief_line%ROWTYPE;
476:

Line 519: , csf_debrief_lines dbl

515: IS
516: SELECT resource_id
517: FROM jtf_task_assignments jta
518: , csf_debrief_headers dbh
519: , csf_debrief_lines dbl
520: WHERE jta.task_assignment_id = dbh.task_assignment_id
521: AND dbh.debrief_header_id = dbl.debrief_header_id
522: AND dbl.debrief_line_id = b_debrief_line_id;
523: r_resource c_resource%ROWTYPE;

Line 583: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

579: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
580: END IF;
581:
582: /*** get debrief record details from public API ***/
583: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
584: l_resource_id := Get_Resource_Id( l_debrief_line_id );
585:
586: /*** is resource a mobile user? ***/
587: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN

Line 660: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

656: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
657: END IF;
658:
659: /*** get debrief_line record details from public API ***/
660: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
661: l_resource_id := Get_Resource_Id( l_debrief_line_id );
662:
663: /*** Check if debrief_line before update matches criteria ***/
664: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN

Line 748: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

744: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
745: END IF;
746:
747: /*** get debrief_line record details from public API ***/
748: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
749: l_resource_id := Get_Resource_Id( l_debrief_line_id );
750:
751: /*** Check if debrief_line after update matches criteria ***/
752: l_replicate := FALSE;

Line 910: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

906: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
907: END IF;
908:
909: /*** Get debrief line record details from public API and then get the resource id ***/
910: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
911: l_resource_id := Get_Resource_Id( l_debrief_line_id );
912:
913: /*** Delete debrief line from ACC table. This also deletes its Debrief Header ***/
914: Post_Delete_Child ( l_debrief_line_id