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.OKS_IMPORT_POST_INSERT dependencies on FND_GLOBAL

Line 33: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;

29: --========================================================================
30: -- PRIVATE CONSTANTS AND VARIABLES
31: --========================================================================
32: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'oks.plsql.import.' || G_PKG_NAME;
33: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
34: G_MODULE_HEAD CONSTANT VARCHAR2(60) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
35: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
36: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
37: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);

Line 262: ,FND_GLOBAL.USER_ID CREATED_BY

258: ,OLSTG.END_DATE LIN_END_DT
259: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
260: ,1 OBJECT_VERSION_NUMBER
261: ,null REQUEST_ID -- need to confirm
262: ,FND_GLOBAL.USER_ID CREATED_BY
263: ,SYSDATE CREATION_DATE
264: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
265: ,SYSDATE LAST_UPDATE_DATE
266: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 264: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

260: ,1 OBJECT_VERSION_NUMBER
261: ,null REQUEST_ID -- need to confirm
262: ,FND_GLOBAL.USER_ID CREATED_BY
263: ,SYSDATE CREATION_DATE
264: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
265: ,SYSDATE LAST_UPDATE_DATE
266: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
267: ,bip.tce_code tce_code /*Added for bug:9019205*/
268: ,bip.quantity quantity

Line 266: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

262: ,FND_GLOBAL.USER_ID CREATED_BY
263: ,SYSDATE CREATION_DATE
264: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
265: ,SYSDATE LAST_UPDATE_DATE
266: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
267: ,bip.tce_code tce_code /*Added for bug:9019205*/
268: ,bip.quantity quantity
269: FROM OKS_INT_LINE_STG_TEMP OLSTG
270: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 431: ,FND_GLOBAL.USER_ID CREATED_BY

427: ELSE NULL
428: END) DATE_COMPLETED
429: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
430: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
431: ,FND_GLOBAL.USER_ID CREATED_BY
432: ,SYSDATE CREATION_DATE
433: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
434: ,SYSDATE LAST_UPDATE_DATE
435: ,INNER_Q1.CLE_ID CLE_ID

Line 433: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

429: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
430: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
431: ,FND_GLOBAL.USER_ID CREATED_BY
432: ,SYSDATE CREATION_DATE
433: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
434: ,SYSDATE LAST_UPDATE_DATE
435: ,INNER_Q1.CLE_ID CLE_ID
436: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
437: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 729: ,FND_GLOBAL.USER_ID CREATED_BY

725: WHEN OLSTG.FIRST_BILL_UPTO_DATE IS NOT NULL AND (OLSTG.LAST_BILL_FROM_DATE -1 ) < OLSTG.END_DATE THEN 3
726: END) NUM_STREAMS
727: ,1 OBJECT_VERSION_NUMBER
728: ,null REQUEST_ID
729: ,FND_GLOBAL.USER_ID CREATED_BY
730: ,SYSDATE CREATION_DATE
731: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
732: ,SYSDATE LAST_UPDATE_DATE
733: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 731: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

727: ,1 OBJECT_VERSION_NUMBER
728: ,null REQUEST_ID
729: ,FND_GLOBAL.USER_ID CREATED_BY
730: ,SYSDATE CREATION_DATE
731: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
732: ,SYSDATE LAST_UPDATE_DATE
733: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
734: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
735: ,OLSTG.BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD

Line 733: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

729: ,FND_GLOBAL.USER_ID CREATED_BY
730: ,SYSDATE CREATION_DATE
731: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
732: ,SYSDATE LAST_UPDATE_DATE
733: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
734: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
735: ,OLSTG.BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD
736: ,OLSTG.BILLING_INTERVAL_DURATION BILLING_INTERVAL_DURATION
737: ,OLSTG.RECUR_BILL_OCCURANCES RECUR_BILL_OCCURANCES

Line 962: ,FND_GLOBAL.USER_ID CREATED_BY

958: ELSE NULL
959: END) DATE_COMPLETED
960: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
961: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
962: ,FND_GLOBAL.USER_ID CREATED_BY
963: ,SYSDATE CREATION_DATE
964: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
965: ,SYSDATE LAST_UPDATE_DATE
966: ,INNER_Q1.CLE_ID CLE_ID

Line 964: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

960: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
961: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
962: ,FND_GLOBAL.USER_ID CREATED_BY
963: ,SYSDATE CREATION_DATE
964: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
965: ,SYSDATE LAST_UPDATE_DATE
966: ,INNER_Q1.CLE_ID CLE_ID
967: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
968: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 1228: ,FND_GLOBAL.USER_ID CREATED_BY

1224: ,(OLSTG.END_DATE - OLSTG.START_DATE)+1 NO_OF_DAYS
1225: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
1226: ,1 OBJECT_VERSION_NUMBER
1227: ,NULL REQUEST_ID -- need to confirm
1228: ,FND_GLOBAL.USER_ID CREATED_BY
1229: ,SYSDATE CREATION_DATE
1230: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1231: ,SYSDATE LAST_UPDATE_DATE
1232: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1230: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1226: ,1 OBJECT_VERSION_NUMBER
1227: ,NULL REQUEST_ID -- need to confirm
1228: ,FND_GLOBAL.USER_ID CREATED_BY
1229: ,SYSDATE CREATION_DATE
1230: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1231: ,SYSDATE LAST_UPDATE_DATE
1232: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1233: ,bip.tce_code tce_code
1234: ,bip.quantity quantity /*Added for bug:9019205*/

Line 1232: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1228: ,FND_GLOBAL.USER_ID CREATED_BY
1229: ,SYSDATE CREATION_DATE
1230: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1231: ,SYSDATE LAST_UPDATE_DATE
1232: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1233: ,bip.tce_code tce_code
1234: ,bip.quantity quantity /*Added for bug:9019205*/
1235: FROM OKS_INT_LINE_STG_TEMP OLSTG
1236: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 1387: ,FND_GLOBAL.USER_ID CREATED_BY

1383: ELSE NULL
1384: END) DATE_COMPLETED
1385: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1386: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1387: ,FND_GLOBAL.USER_ID CREATED_BY
1388: ,SYSDATE CREATION_DATE
1389: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1390: ,SYSDATE LAST_UPDATE_DATE
1391: ,INNER_Q1.CLE_ID CLE_ID

Line 1389: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1385: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1386: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1387: ,FND_GLOBAL.USER_ID CREATED_BY
1388: ,SYSDATE CREATION_DATE
1389: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1390: ,SYSDATE LAST_UPDATE_DATE
1391: ,INNER_Q1.CLE_ID CLE_ID
1392: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
1393: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 1661: ,FND_GLOBAL.USER_ID CREATED_BY

1657: WHEN OLSTG.FIRST_BILL_UPTO_DATE IS NOT NULL AND (OLSTG.LAST_BILL_FROM_DATE -1 ) < OLSTG.END_DATE THEN 3
1658: END) NUM_STREAMS
1659: ,1 OBJECT_VERSION_NUMBER
1660: ,null REQUEST_ID
1661: ,FND_GLOBAL.USER_ID CREATED_BY
1662: ,SYSDATE CREATION_DATE
1663: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1664: ,SYSDATE LAST_UPDATE_DATE
1665: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1663: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1659: ,1 OBJECT_VERSION_NUMBER
1660: ,null REQUEST_ID
1661: ,FND_GLOBAL.USER_ID CREATED_BY
1662: ,SYSDATE CREATION_DATE
1663: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1664: ,SYSDATE LAST_UPDATE_DATE
1665: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1666: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
1667: ,OLSTG.BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD

Line 1665: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1661: ,FND_GLOBAL.USER_ID CREATED_BY
1662: ,SYSDATE CREATION_DATE
1663: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1664: ,SYSDATE LAST_UPDATE_DATE
1665: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1666: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
1667: ,OLSTG.BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD
1668: ,OLSTG.BILLING_INTERVAL_DURATION BILLING_INTERVAL_DURATION
1669: ,OLSTG.RECUR_BILL_OCCURANCES RECUR_BILL_OCCURANCES

Line 1896: ,FND_GLOBAL.USER_ID CREATED_BY

1892: ELSE NULL
1893: END) DATE_COMPLETED
1894: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1895: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1896: ,FND_GLOBAL.USER_ID CREATED_BY
1897: ,SYSDATE CREATION_DATE
1898: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1899: ,SYSDATE LAST_UPDATE_DATE
1900: ,INNER_Q1.CLE_ID CLE_ID

Line 1898: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1894: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1895: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1896: ,FND_GLOBAL.USER_ID CREATED_BY
1897: ,SYSDATE CREATION_DATE
1898: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1899: ,SYSDATE LAST_UPDATE_DATE
1900: ,INNER_Q1.CLE_ID CLE_ID
1901: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
1902: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 2171: ,FND_GLOBAL.USER_ID CREATED_BY

2167: ,(OLSTG.END_DATE - OLSTG.START_DATE)+1 NO_OF_DAYS
2168: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
2169: ,1 OBJECT_VERSION_NUMBER
2170: ,null REQUEST_ID -- need to confirm
2171: ,FND_GLOBAL.USER_ID CREATED_BY
2172: ,SYSDATE CREATION_DATE
2173: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2174: ,SYSDATE LAST_UPDATE_DATE
2175: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 2173: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2169: ,1 OBJECT_VERSION_NUMBER
2170: ,null REQUEST_ID -- need to confirm
2171: ,FND_GLOBAL.USER_ID CREATED_BY
2172: ,SYSDATE CREATION_DATE
2173: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2174: ,SYSDATE LAST_UPDATE_DATE
2175: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2176: ,bip.tce_code tce_code
2177: ,bip.quantity quantity /*Added for bug:9019205*/

Line 2175: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

2171: ,FND_GLOBAL.USER_ID CREATED_BY
2172: ,SYSDATE CREATION_DATE
2173: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2174: ,SYSDATE LAST_UPDATE_DATE
2175: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
2176: ,bip.tce_code tce_code
2177: ,bip.quantity quantity /*Added for bug:9019205*/
2178: FROM OKS_INT_LINE_STG_TEMP OLSTG
2179: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 2313: ,FND_GLOBAL.USER_ID CREATED_BY

2309: END) DATE_COMPLETED
2310:
2311: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
2312: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
2313: ,FND_GLOBAL.USER_ID CREATED_BY
2314: ,SYSDATE CREATION_DATE
2315: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2316: ,SYSDATE LAST_UPDATE_DATE
2317: ,INNER_Q1.CLE_ID CLE_ID

Line 2315: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

2311: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
2312: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
2313: ,FND_GLOBAL.USER_ID CREATED_BY
2314: ,SYSDATE CREATION_DATE
2315: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
2316: ,SYSDATE LAST_UPDATE_DATE
2317: ,INNER_Q1.CLE_ID CLE_ID
2318: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
2319: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 2763: , p_created_by => FND_GLOBAL.USER_ID

2759: , p_entered_by => l_cur_hdr_notes_txn_tab(i).entered_by
2760: , p_entered_date => l_cur_hdr_notes_txn_tab(i).entered_date
2761: , x_jtf_note_id => l_jtf_note_id
2762: , p_creation_date => SYSDATE
2763: , p_created_by => FND_GLOBAL.USER_ID
2764: , p_last_update_date => SYSDATE
2765: , p_last_updated_by => FND_GLOBAL.USER_ID
2766: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2767: , p_attribute1 => NULL

Line 2765: , p_last_updated_by => FND_GLOBAL.USER_ID

2761: , x_jtf_note_id => l_jtf_note_id
2762: , p_creation_date => SYSDATE
2763: , p_created_by => FND_GLOBAL.USER_ID
2764: , p_last_update_date => SYSDATE
2765: , p_last_updated_by => FND_GLOBAL.USER_ID
2766: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2767: , p_attribute1 => NULL
2768: , p_attribute2 => NULL
2769: , p_attribute3 => NULL

Line 2766: , p_last_update_login => FND_GLOBAL.LOGIN_ID

2762: , p_creation_date => SYSDATE
2763: , p_created_by => FND_GLOBAL.USER_ID
2764: , p_last_update_date => SYSDATE
2765: , p_last_updated_by => FND_GLOBAL.USER_ID
2766: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2767: , p_attribute1 => NULL
2768: , p_attribute2 => NULL
2769: , p_attribute3 => NULL
2770: , p_attribute4 => NULL

Line 2840: , p_created_by => FND_GLOBAL.USER_ID

2836: , p_entered_by => l_cur_line_notes_txn_tab(i).entered_by
2837: , p_entered_date => l_cur_line_notes_txn_tab(i).entered_date
2838: , x_jtf_note_id => l_jtf_note_id
2839: , p_creation_date => SYSDATE
2840: , p_created_by => FND_GLOBAL.USER_ID
2841: , p_last_update_date => SYSDATE
2842: , p_last_updated_by => FND_GLOBAL.USER_ID
2843: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2844: , p_attribute1 => NULL

Line 2842: , p_last_updated_by => FND_GLOBAL.USER_ID

2838: , x_jtf_note_id => l_jtf_note_id
2839: , p_creation_date => SYSDATE
2840: , p_created_by => FND_GLOBAL.USER_ID
2841: , p_last_update_date => SYSDATE
2842: , p_last_updated_by => FND_GLOBAL.USER_ID
2843: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2844: , p_attribute1 => NULL
2845: , p_attribute2 => NULL
2846: , p_attribute3 => NULL

Line 2843: , p_last_update_login => FND_GLOBAL.LOGIN_ID

2839: , p_creation_date => SYSDATE
2840: , p_created_by => FND_GLOBAL.USER_ID
2841: , p_last_update_date => SYSDATE
2842: , p_last_updated_by => FND_GLOBAL.USER_ID
2843: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2844: , p_attribute1 => NULL
2845: , p_attribute2 => NULL
2846: , p_attribute3 => NULL
2847: , p_attribute4 => NULL