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_CSP_INV_LOC_ASS_ACC_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

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

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSP_INV_LOC_ASS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_INV_LOC_ASSIGNMENTS');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENTS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENT_ID';
10: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
11: g_debug_level NUMBER; -- debug level

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

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSP_INV_LOC_ASS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_INV_LOC_ASSIGNMENTS');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENTS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENT_ID';
10: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
11: g_debug_level NUMBER; -- debug level
12:

Line 21: FROM CSP_INV_LOC_ASSIGNMENTS

17: RETURN BOOLEAN
18: IS
19: CURSOR c_csp_inv_loc_assignment (b_csp_inv_loc_assignment_id NUMBER) IS
20: SELECT *
21: FROM CSP_INV_LOC_ASSIGNMENTS
22: WHERE CSP_INV_LOC_ASSIGNMENT_ID = b_csp_inv_loc_assignment_id;
23: r_csp_inv_loc_assignment c_csp_inv_loc_assignment%ROWTYPE;
24:
25: l_return_value BOOLEAN := FALSE;

Line 243: FROM CSP_INV_LOC_ASSIGNMENTS

239: RETURN BOOLEAN
240: IS
241: CURSOR c_retreive_org_name(b_loc_assignment_id NUMBER) IS
242: SELECT organization_id, subinventory_code
243: FROM CSP_INV_LOC_ASSIGNMENTS
244: WHERE csp_inv_loc_assignment_id = b_loc_assignment_id;
245:
246: r_retreive_org_name c_retreive_org_name%ROWTYPE;
247:

Line 314: FROM CSP_INV_LOC_ASSIGNMENTS

310: IS
311:
312: CURSOR c_retreive_org_name(b_loc_assignment_id NUMBER) IS
313: SELECT organization_id, subinventory_code
314: FROM CSP_INV_LOC_ASSIGNMENTS
315: WHERE csp_inv_loc_assignment_id = b_loc_assignment_id;
316:
317: r_retreive_org_name c_retreive_org_name%ROWTYPE;
318:

Line 383: FROM csp_inv_loc_assignments

379: l_csp_inv_loc_assignment_id NUMBER;
380: l_dummy BOOLEAN;
381: CURSOR c_resource( b_csp_inv_loc_assignment_id NUMBER ) IS
382: SELECT resource_id
383: FROM csp_inv_loc_assignments
384: WHERE csp_inv_loc_assignment_id = b_csp_inv_loc_assignment_id;
385: l_enabled_flag VARCHAR2(30);
386: BEGIN
387: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );

Line 404: l_csp_inv_loc_assignment_id := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;

400: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
401: END IF;
402:
403: /*** get assignment record details from public API ***/
404: l_csp_inv_loc_assignment_id := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;
405:
406: OPEN c_resource( l_csp_inv_loc_assignment_id );
407: FETCH c_resource INTO l_resource_id;
408: IF c_resource%FOUND THEN

Line 457: FROM csp_inv_loc_assignments -- don't use synonym as that one filters on OWNER records

453: )
454: IS
455: CURSOR c_csp_inv_loc_assignment( b_csp_inv_loc_ass_id NUMBER ) IS
456: SELECT resource_id
457: FROM csp_inv_loc_assignments -- don't use synonym as that one filters on OWNER records
458: WHERE csp_inv_loc_assignment_id = b_csp_inv_loc_ass_id;
459:
460: r_csp_inv_loc_assignment c_csp_inv_loc_assignment%ROWTYPE;
461: l_csp_inv_loc_assignment NUMBER;

Line 470: l_csp_inv_loc_assignment := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;

466: x_return_status := FND_API.G_RET_STS_SUCCESS;
467: RETURN;
468: END IF;
469: /*** get assignment record details from public API ***/
470: l_csp_inv_loc_assignment := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;
471:
472: /*** get debug level ***/
473: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
474:

Line 520: FROM CSP_INV_LOC_ASSIGNMENTS

516: )
517: IS
518: CURSOR c_retreive_org_name(b_loc_assignment_id NUMBER) IS
519: SELECT organization_id, subinventory_code
520: FROM CSP_INV_LOC_ASSIGNMENTS
521: WHERE csp_inv_loc_assignment_id = b_loc_assignment_id;
522:
523: r_retreive_org_name c_retreive_org_name%ROWTYPE;
524:

Line 533: FROM csp_inv_loc_assignments -- don't use synonym as that one filters on OWNER records

529: l_acc_id NUMBER;
530:
531: CURSOR c_csp_inv_loc_assignment( b_csp_inv_loc_ass_id NUMBER ) IS
532: SELECT resource_id
533: FROM csp_inv_loc_assignments -- don't use synonym as that one filters on OWNER records
534: WHERE csp_inv_loc_assignment_id = b_csp_inv_loc_ass_id;
535:
536: r_csp_inv_loc_assignment c_csp_inv_loc_assignment%ROWTYPE;
537:

Line 557: l_csp_inv_loc_assignment := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;

553: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
554: END IF;
555:
556: /*** get assignment record details from public API ***/
557: l_csp_inv_loc_assignment := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;
558:
559: /*** retrieve 'new' resource_id for task assignment ***/
560: OPEN c_csp_inv_loc_assignment(l_csp_inv_loc_assignment);
561: FETCH c_csp_inv_loc_assignment INTO r_csp_inv_loc_assignment;

Line 677: l_csp_inv_loc_assignment := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;

673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674: RETURN;
675: END IF;
676: /*** get assignment record details from public API ***/
677: l_csp_inv_loc_assignment := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;
678: l_resource_id := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.RESOURCE_ID;
679:
680: /*** get debug level ***/
681: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 678: l_resource_id := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.RESOURCE_ID;

674: RETURN;
675: END IF;
676: /*** get assignment record details from public API ***/
677: l_csp_inv_loc_assignment := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID;
678: l_resource_id := CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.RESOURCE_ID;
679:
680: /*** get debug level ***/
681: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
682:

Line 808: FROM CSP_INV_LOC_ASSIGNMENTS

804: IS
805:
806: CURSOR c_csp_inv_loc_assignment (b_resource_id NUMBER) IS
807: SELECT *
808: FROM CSP_INV_LOC_ASSIGNMENTS
809: WHERE RESOURCE_ID = b_resource_id
810: AND RESOURCE_TYPE = 'RS_EMPLOYEE' ;
811:
812: r_csp_inv_loc_assignment c_csp_inv_loc_assignment%ROWTYPE;