APPS.CSP_PICK_UTILS dependencies on CSP_PICK_UTILS

Line 1: Package Body CSP_PICK_UTILS AS

1: Package Body CSP_PICK_UTILS AS
2: /*$Header: cspgtpub.pls 120.7.12020000.14 2013/01/22 10:39:51 rrajain ship $*/
3: --
4: --
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PICK_UTILS';

2: /*$Header: cspgtpub.pls 120.7.12020000.14 2013/01/22 10:39:51 rrajain ship $*/
3: --
4: --
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PICK_UTILS';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspgtpub.pls';
8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
10: G_MIN_QUANTITY NUMBER := 0;

Line 37: CSP_PICK_UTILS.GL_ORG_ID := P_ORG_ID;

33:
34:
35: PROCEDURE CSP_ASSIGN_GLOBAL_ORG_ID (P_ORG_ID NUMBER) is
36: begin
37: CSP_PICK_UTILS.GL_ORG_ID := P_ORG_ID;
38: End CSP_ASSIGN_GLOBAL_ORG_ID;
39:
40: function CSP_GLOBAL_ORG_ID return number is
41: begin

Line 2423: csp_pick_utils.get_object_name(cr.resource_type_code,cr.resource_id);

2419: G_RESOURCE_CODE := G_RESOURCE_CODE||fnd_global.local_chr(127)||
2420: cr.resource_type_code||cr.resource_id;
2421: G_RESOURCE_NAME :=
2422: G_RESOURCE_NAME||fnd_global.local_chr(127)||
2423: csp_pick_utils.get_object_name(cr.resource_type_code,cr.resource_id);
2424: else
2425: G_RESOURCE_CODE := cr.resource_type_code||cr.resource_id;
2426: G_RESOURCE_NAME :=
2427: csp_pick_utils.get_object_name(cr.resource_type_code,cr.resource_id);

Line 2427: csp_pick_utils.get_object_name(cr.resource_type_code,cr.resource_id);

2423: csp_pick_utils.get_object_name(cr.resource_type_code,cr.resource_id);
2424: else
2425: G_RESOURCE_CODE := cr.resource_type_code||cr.resource_id;
2426: G_RESOURCE_NAME :=
2427: csp_pick_utils.get_object_name(cr.resource_type_code,cr.resource_id);
2428: end if;
2429: G_SCHED_TRAVEL_DISTANCE := nvl(G_SCHED_TRAVEL_DISTANCE,0) +
2430: cr.sched_travel_distance;
2431: G_ACTUAL_TRAVEL_DISTANCE := nvl(G_ACTUAL_TRAVEL_DISTANCE,0) +