DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on FND_GLOBAL

Line 31: G_CARRIAGE_RETURN VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);

27:
28: -----------------------------------------------------------------------
29: -- These are the Constants to generate a New Line Character. --
30: -----------------------------------------------------------------------
31: G_CARRIAGE_RETURN VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);
32: G_LINE_FEED VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
33: -- Following prints ^M characters in the log file.
34: -- G_NEWLINE VARCHAR2(2) := G_CARRIAGE_RETURN || G_LINE_FEED; --(carriage-return/line-feed)
35: G_NEWLINE VARCHAR2(2) := G_LINE_FEED;

Line 32: G_LINE_FEED VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);

28: -----------------------------------------------------------------------
29: -- These are the Constants to generate a New Line Character. --
30: -----------------------------------------------------------------------
31: G_CARRIAGE_RETURN VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);
32: G_LINE_FEED VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
33: -- Following prints ^M characters in the log file.
34: -- G_NEWLINE VARCHAR2(2) := G_CARRIAGE_RETURN || G_LINE_FEED; --(carriage-return/line-feed)
35: G_NEWLINE VARCHAR2(2) := G_LINE_FEED;
36:

Line 343: -- the values are chosen from the FND_GLOBALS

339:
340: PROCEDURE SetGobals IS
341: BEGIN
342: -----------------------------------------------------------------------
343: -- the values are chosen from the FND_GLOBALS
344: -----------------------------------------------------------------------
345: G_USER_ID := NVL(FND_GLOBAL.user_id,-1);
346: G_LOGIN_ID := NVL(FND_GLOBAL.login_id,-1);
347: G_PROG_APPID := NVL(FND_GLOBAL.prog_appl_id,-1);

Line 345: G_USER_ID := NVL(FND_GLOBAL.user_id,-1);

341: BEGIN
342: -----------------------------------------------------------------------
343: -- the values are chosen from the FND_GLOBALS
344: -----------------------------------------------------------------------
345: G_USER_ID := NVL(FND_GLOBAL.user_id,-1);
346: G_LOGIN_ID := NVL(FND_GLOBAL.login_id,-1);
347: G_PROG_APPID := NVL(FND_GLOBAL.prog_appl_id,-1);
348: G_PROG_ID := NVL(FND_GLOBAL.conc_program_id,-1);
349: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id,-1);

Line 346: G_LOGIN_ID := NVL(FND_GLOBAL.login_id,-1);

342: -----------------------------------------------------------------------
343: -- the values are chosen from the FND_GLOBALS
344: -----------------------------------------------------------------------
345: G_USER_ID := NVL(FND_GLOBAL.user_id,-1);
346: G_LOGIN_ID := NVL(FND_GLOBAL.login_id,-1);
347: G_PROG_APPID := NVL(FND_GLOBAL.prog_appl_id,-1);
348: G_PROG_ID := NVL(FND_GLOBAL.conc_program_id,-1);
349: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id,-1);
350: END;

Line 347: G_PROG_APPID := NVL(FND_GLOBAL.prog_appl_id,-1);

343: -- the values are chosen from the FND_GLOBALS
344: -----------------------------------------------------------------------
345: G_USER_ID := NVL(FND_GLOBAL.user_id,-1);
346: G_LOGIN_ID := NVL(FND_GLOBAL.login_id,-1);
347: G_PROG_APPID := NVL(FND_GLOBAL.prog_appl_id,-1);
348: G_PROG_ID := NVL(FND_GLOBAL.conc_program_id,-1);
349: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id,-1);
350: END;
351:

Line 348: G_PROG_ID := NVL(FND_GLOBAL.conc_program_id,-1);

344: -----------------------------------------------------------------------
345: G_USER_ID := NVL(FND_GLOBAL.user_id,-1);
346: G_LOGIN_ID := NVL(FND_GLOBAL.login_id,-1);
347: G_PROG_APPID := NVL(FND_GLOBAL.prog_appl_id,-1);
348: G_PROG_ID := NVL(FND_GLOBAL.conc_program_id,-1);
349: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id,-1);
350: END;
351:
352: ----------------------------------------------------------

Line 349: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id,-1);

345: G_USER_ID := NVL(FND_GLOBAL.user_id,-1);
346: G_LOGIN_ID := NVL(FND_GLOBAL.login_id,-1);
347: G_PROG_APPID := NVL(FND_GLOBAL.prog_appl_id,-1);
348: G_PROG_ID := NVL(FND_GLOBAL.conc_program_id,-1);
349: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id,-1);
350: END;
351:
352: ----------------------------------------------------------
353: -- Internal procedure to open Debug Session. --

Line 6049: WHERE request_id = FND_GLOBAL.conc_request_id;

6045:
6046: CURSOR c_mtl_intf_err_row_exists IS
6047: SELECT 'x'
6048: FROM mtl_interface_errors
6049: WHERE request_id = FND_GLOBAL.conc_request_id;
6050:
6051:
6052: --Long Dynamic SQL String
6053: l_dyn_sql VARCHAR2(10000);