APPS.FTE_REGION_ZONE_LOADER dependencies on FND_GLOBAL

Line 21: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;

17: -- PROCESS_REGION --
18: -------------------------------------------------------------------------- --
19:
20: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_REGION_ZONE_LOADER';
21: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
22:
23: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
24:
25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 495: FND_GLOBAL.USER_ID,

491: p_parent_region_id,
492: p_supplier_id,
493: l_zone_flag,
494: SYSDATE,
495: FND_GLOBAL.USER_ID,
496: SYSDATE,
497: FND_GLOBAL.USER_ID,
498: l_postal_code_from,
499: l_postal_code_to);

Line 497: FND_GLOBAL.USER_ID,

493: l_zone_flag,
494: SYSDATE,
495: FND_GLOBAL.USER_ID,
496: SYSDATE,
497: FND_GLOBAL.USER_ID,
498: l_postal_code_from,
499: l_postal_code_to);
500:
501: IF (SQL%ROWCOUNT < 0) THEN

Line 788: FND_GLOBAL.USER_ID,

784: -1,
785: L_COUNTRY_CODE(i),
786: L_STATE_CODE(i),
787: L_CITY_CODE(i),
788: FND_GLOBAL.USER_ID,
789: SYSDATE,
790: FND_GLOBAL.USER_ID,
791: SYSDATE,
792: FND_GLOBAL.USER_ID,

Line 790: FND_GLOBAL.USER_ID,

786: L_STATE_CODE(i),
787: L_CITY_CODE(i),
788: FND_GLOBAL.USER_ID,
789: SYSDATE,
790: FND_GLOBAL.USER_ID,
791: SYSDATE,
792: FND_GLOBAL.USER_ID,
793: NULL);
794:

Line 792: FND_GLOBAL.USER_ID,

788: FND_GLOBAL.USER_ID,
789: SYSDATE,
790: FND_GLOBAL.USER_ID,
791: SYSDATE,
792: FND_GLOBAL.USER_ID,
793: NULL);
794:
795: FORALL i in L_REGION_ID.FIRST..L_REGION_ID.LAST
796:

Line 818: FND_GLOBAL.USER_ID,

814: L_STATE(i),
815: L_CITY(i),
816: L_POSTAL_CODE_FROM(i),
817: L_POSTAL_CODE_TO(i),
818: FND_GLOBAL.USER_ID,
819: SYSDATE,
820: FND_GLOBAL.USER_ID,
821: SYSDATE,
822: FND_GLOBAL.USER_ID);

Line 820: FND_GLOBAL.USER_ID,

816: L_POSTAL_CODE_FROM(i),
817: L_POSTAL_CODE_TO(i),
818: FND_GLOBAL.USER_ID,
819: SYSDATE,
820: FND_GLOBAL.USER_ID,
821: SYSDATE,
822: FND_GLOBAL.USER_ID);
823:
824: l_request_id := FND_REQUEST.SUBMIT_REQUEST(application => 'WSH',

Line 822: FND_GLOBAL.USER_ID);

818: FND_GLOBAL.USER_ID,
819: SYSDATE,
820: FND_GLOBAL.USER_ID,
821: SYSDATE,
822: FND_GLOBAL.USER_ID);
823:
824: l_request_id := FND_REQUEST.SUBMIT_REQUEST(application => 'WSH',
825: program => 'WSHRGINT',
826: description => null,