DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_PKG dependencies on FND_GLOBAL

Line 2586: l_request_id NUMBER := FND_GLOBAL.conc_request_id;

2582: l_start_rowid ROWID;
2583: l_end_rowid ROWID;
2584: l_rows_processed NUMBER;
2585:
2586: l_request_id NUMBER := FND_GLOBAL.conc_request_id;
2587: l_restart BOOLEAN := FALSE;
2588:
2589: TYPE LineList IS TABLE OF VARCHAR2(25);
2590: linetype LineList := LineList('ITEM', 'ERV', 'IPV', 'TAX', 'TERV', 'TIPV');

Line 2630: FND_GLOBAL.User_ID,

2626: sysdate,
2627: NULL,
2628: p_parent_request_id,
2629: sysdate,
2630: FND_GLOBAL.User_ID,
2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),

Line 2631: FND_GLOBAL.User_ID,

2627: NULL,
2628: p_parent_request_id,
2629: sysdate,
2630: FND_GLOBAL.User_ID,
2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2635: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),

Line 2633: FND_GLOBAL.Login_ID,

2629: sysdate,
2630: FND_GLOBAL.User_ID,
2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2635: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2636: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2637:

Line 2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),

2630: FND_GLOBAL.User_ID,
2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2635: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2636: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2637:
2638:

Line 2635: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),

2631: FND_GLOBAL.User_ID,
2632: sysdate,
2633: FND_GLOBAL.Login_ID,
2634: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.prog_appl_id, NULL),
2635: DECODE(p_upgrade_mode, 'PRE-UPGRADE', FND_GLOBAL.conc_program_id, NULL),
2636: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2637:
2638:
2639: FORALL i IN linetype.FIRST..linetype.LAST

Line 2791: g_parent_request_id := FND_GLOBAL.conc_request_id;

2787:
2788: g_batch_size := p_batch_size;
2789: g_num_workers := p_num_workers;
2790: g_debug_flag := p_debug_flag;
2791: g_parent_request_id := FND_GLOBAL.conc_request_id;
2792: g_upgrade_mode := p_upgrade_mode;
2793:
2794:
2795: l_debug_info := 'Inside Transaction_Upgrade_Main procedure';

Line 2871: FND_GLOBAL.User_ID,

2867: p_upgrade_mode,
2868: sysdate,
2869: NULL,
2870: sysdate,
2871: FND_GLOBAL.User_ID,
2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,

Line 2872: FND_GLOBAL.User_ID,

2868: sysdate,
2869: NULL,
2870: sysdate,
2871: FND_GLOBAL.User_ID,
2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,

Line 2874: FND_GLOBAL.Login_ID,

2870: sysdate,
2871: FND_GLOBAL.User_ID,
2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,
2877: FND_GLOBAL.conc_request_id);
2878:

Line 2875: FND_GLOBAL.prog_appl_id,

2871: FND_GLOBAL.User_ID,
2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,
2877: FND_GLOBAL.conc_request_id);
2878:
2879: END IF;

Line 2876: FND_GLOBAL.conc_program_id,

2872: FND_GLOBAL.User_ID,
2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,
2877: FND_GLOBAL.conc_request_id);
2878:
2879: END IF;
2880:

Line 2877: FND_GLOBAL.conc_request_id);

2873: sysdate,
2874: FND_GLOBAL.Login_ID,
2875: FND_GLOBAL.prog_appl_id,
2876: FND_GLOBAL.conc_program_id,
2877: FND_GLOBAL.conc_request_id);
2878:
2879: END IF;
2880:
2881:

Line 3029: AND request_id = FND_GLOBAL.conc_request_id;

3025:
3026: UPDATE ap_invoices_upg_control
3027: SET end_date = sysdate
3028: WHERE module_name = 'TRANSACTION_UPGRADE_MAIN'
3029: AND request_id = FND_GLOBAL.conc_request_id;
3030:
3031: END IF;
3032:
3033: ELSE