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 26: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;

22: --========================================================================
23: -- PRIVATE CONSTANTS AND VARIABLES
24: --========================================================================
25: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'oks.plsql.import.' || G_PKG_NAME;
26: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
27: G_MODULE_HEAD CONSTANT VARCHAR2(60) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
28: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);

Line 243: ,FND_GLOBAL.USER_ID CREATED_BY

239: ,OLSTG.END_DATE LIN_END_DT
240: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
241: ,1 OBJECT_VERSION_NUMBER
242: ,null REQUEST_ID -- need to confirm
243: ,FND_GLOBAL.USER_ID CREATED_BY
244: ,SYSDATE CREATION_DATE
245: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
246: ,SYSDATE LAST_UPDATE_DATE
247: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 245: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

241: ,1 OBJECT_VERSION_NUMBER
242: ,null REQUEST_ID -- need to confirm
243: ,FND_GLOBAL.USER_ID CREATED_BY
244: ,SYSDATE CREATION_DATE
245: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
246: ,SYSDATE LAST_UPDATE_DATE
247: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
248:
249: FROM OKS_INT_LINE_STG_TEMP OLSTG

Line 247: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

243: ,FND_GLOBAL.USER_ID CREATED_BY
244: ,SYSDATE CREATION_DATE
245: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
246: ,SYSDATE LAST_UPDATE_DATE
247: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
248:
249: FROM OKS_INT_LINE_STG_TEMP OLSTG
250: ,OKS_INT_HEADER_STG_TEMP HDRSTG
251: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 380: ,FND_GLOBAL.USER_ID CREATED_BY

376: ELSE NULL
377: END) DATE_COMPLETED
378: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
379: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
380: ,FND_GLOBAL.USER_ID CREATED_BY
381: ,SYSDATE CREATION_DATE
382: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
383: ,SYSDATE LAST_UPDATE_DATE
384: ,INNER_Q1.CLE_ID CLE_ID

Line 382: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

378: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
379: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
380: ,FND_GLOBAL.USER_ID CREATED_BY
381: ,SYSDATE CREATION_DATE
382: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
383: ,SYSDATE LAST_UPDATE_DATE
384: ,INNER_Q1.CLE_ID CLE_ID
385: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
386: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 625: ,FND_GLOBAL.USER_ID CREATED_BY

621: WHEN OLSTG.FIRST_BILL_UPTO_DATE IS NOT NULL AND (OLSTG.LAST_BILL_FROM_DATE -1 ) < OLSTG.END_DATE THEN 3
622: END) NUM_STREAMS
623: ,1 OBJECT_VERSION_NUMBER
624: ,null REQUEST_ID
625: ,FND_GLOBAL.USER_ID CREATED_BY
626: ,SYSDATE CREATION_DATE
627: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
628: ,SYSDATE LAST_UPDATE_DATE
629: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 627: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

623: ,1 OBJECT_VERSION_NUMBER
624: ,null REQUEST_ID
625: ,FND_GLOBAL.USER_ID CREATED_BY
626: ,SYSDATE CREATION_DATE
627: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
628: ,SYSDATE LAST_UPDATE_DATE
629: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
630: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
631: ,OLSTG.BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD

Line 629: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

625: ,FND_GLOBAL.USER_ID CREATED_BY
626: ,SYSDATE CREATION_DATE
627: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
628: ,SYSDATE LAST_UPDATE_DATE
629: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
630: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
631: ,OLSTG.BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD
632: ,OLSTG.BILLING_INTERVAL_DURATION BILLING_INTERVAL_DURATION
633: ,OLSTG.RECUR_BILL_OCCURANCES RECUR_BILL_OCCURANCES

Line 815: ,FND_GLOBAL.USER_ID CREATED_BY

811: ELSE NULL
812: END) DATE_COMPLETED
813: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
814: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
815: ,FND_GLOBAL.USER_ID CREATED_BY
816: ,SYSDATE CREATION_DATE
817: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
818: ,SYSDATE LAST_UPDATE_DATE
819: ,INNER_Q1.CLE_ID CLE_ID

Line 817: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

813: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
814: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
815: ,FND_GLOBAL.USER_ID CREATED_BY
816: ,SYSDATE CREATION_DATE
817: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
818: ,SYSDATE LAST_UPDATE_DATE
819: ,INNER_Q1.CLE_ID CLE_ID
820: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
821: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 1038: ,FND_GLOBAL.USER_ID CREATED_BY

1034: ,(OLSTG.END_DATE - OLSTG.START_DATE)+1 NO_OF_DAYS
1035: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
1036: ,1 OBJECT_VERSION_NUMBER
1037: ,NULL REQUEST_ID -- need to confirm
1038: ,FND_GLOBAL.USER_ID CREATED_BY
1039: ,SYSDATE CREATION_DATE
1040: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1041: ,SYSDATE LAST_UPDATE_DATE
1042: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1040: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1036: ,1 OBJECT_VERSION_NUMBER
1037: ,NULL REQUEST_ID -- need to confirm
1038: ,FND_GLOBAL.USER_ID CREATED_BY
1039: ,SYSDATE CREATION_DATE
1040: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1041: ,SYSDATE LAST_UPDATE_DATE
1042: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1043:
1044: FROM OKS_INT_LINE_STG_TEMP OLSTG

Line 1042: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1038: ,FND_GLOBAL.USER_ID CREATED_BY
1039: ,SYSDATE CREATION_DATE
1040: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1041: ,SYSDATE LAST_UPDATE_DATE
1042: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1043:
1044: FROM OKS_INT_LINE_STG_TEMP OLSTG
1045: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1046: ,OKC_K_HEADERS_ALL_B OKCHDRB

Line 1167: ,FND_GLOBAL.USER_ID CREATED_BY

1163: ELSE NULL
1164: END) DATE_COMPLETED
1165: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1166: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1167: ,FND_GLOBAL.USER_ID CREATED_BY
1168: ,SYSDATE CREATION_DATE
1169: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1170: ,SYSDATE LAST_UPDATE_DATE
1171: ,INNER_Q1.CLE_ID CLE_ID

Line 1169: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1165: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1166: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1167: ,FND_GLOBAL.USER_ID CREATED_BY
1168: ,SYSDATE CREATION_DATE
1169: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1170: ,SYSDATE LAST_UPDATE_DATE
1171: ,INNER_Q1.CLE_ID CLE_ID
1172: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
1173: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 1411: ,FND_GLOBAL.USER_ID CREATED_BY

1407: WHEN OLSTG.FIRST_BILL_UPTO_DATE IS NOT NULL AND (OLSTG.LAST_BILL_FROM_DATE -1 ) < OLSTG.END_DATE THEN 3
1408: END) NUM_STREAMS
1409: ,1 OBJECT_VERSION_NUMBER
1410: ,null REQUEST_ID
1411: ,FND_GLOBAL.USER_ID CREATED_BY
1412: ,SYSDATE CREATION_DATE
1413: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1414: ,SYSDATE LAST_UPDATE_DATE
1415: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1413: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1409: ,1 OBJECT_VERSION_NUMBER
1410: ,null REQUEST_ID
1411: ,FND_GLOBAL.USER_ID CREATED_BY
1412: ,SYSDATE CREATION_DATE
1413: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1414: ,SYSDATE LAST_UPDATE_DATE
1415: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1416: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
1417: ,OLSTG.BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD

Line 1415: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1411: ,FND_GLOBAL.USER_ID CREATED_BY
1412: ,SYSDATE CREATION_DATE
1413: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1414: ,SYSDATE LAST_UPDATE_DATE
1415: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1416: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
1417: ,OLSTG.BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD
1418: ,OLSTG.BILLING_INTERVAL_DURATION BILLING_INTERVAL_DURATION
1419: ,OLSTG.RECUR_BILL_OCCURANCES RECUR_BILL_OCCURANCES

Line 1603: ,FND_GLOBAL.USER_ID CREATED_BY

1599: ELSE NULL
1600: END) DATE_COMPLETED
1601: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1602: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1603: ,FND_GLOBAL.USER_ID CREATED_BY
1604: ,SYSDATE CREATION_DATE
1605: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1606: ,SYSDATE LAST_UPDATE_DATE
1607: ,INNER_Q1.CLE_ID CLE_ID

Line 1605: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1601: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1602: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1603: ,FND_GLOBAL.USER_ID CREATED_BY
1604: ,SYSDATE CREATION_DATE
1605: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1606: ,SYSDATE LAST_UPDATE_DATE
1607: ,INNER_Q1.CLE_ID CLE_ID
1608: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
1609: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 1835: ,FND_GLOBAL.USER_ID CREATED_BY

1831: ,(OLSTG.END_DATE - OLSTG.START_DATE)+1 NO_OF_DAYS
1832: ,OLSTG.LAST_BILL_FROM_DATE LAST_BILL_FROM_DATE
1833: ,1 OBJECT_VERSION_NUMBER
1834: ,null REQUEST_ID -- need to confirm
1835: ,FND_GLOBAL.USER_ID CREATED_BY
1836: ,SYSDATE CREATION_DATE
1837: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1838: ,SYSDATE LAST_UPDATE_DATE
1839: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

Line 1837: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1833: ,1 OBJECT_VERSION_NUMBER
1834: ,null REQUEST_ID -- need to confirm
1835: ,FND_GLOBAL.USER_ID CREATED_BY
1836: ,SYSDATE CREATION_DATE
1837: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1838: ,SYSDATE LAST_UPDATE_DATE
1839: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1840: FROM OKS_INT_LINE_STG_TEMP OLSTG
1841: ,OKS_INT_HEADER_STG_TEMP HDRSTG

Line 1839: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN

1835: ,FND_GLOBAL.USER_ID CREATED_BY
1836: ,SYSDATE CREATION_DATE
1837: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1838: ,SYSDATE LAST_UPDATE_DATE
1839: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
1840: FROM OKS_INT_LINE_STG_TEMP OLSTG
1841: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1842: ,OKC_K_HEADERS_ALL_B OKCHDRB
1843: ,OKC_K_LINES_B OKCLINB_LINE

Line 1946: ,FND_GLOBAL.USER_ID CREATED_BY

1942: END) DATE_COMPLETED
1943:
1944: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1945: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1946: ,FND_GLOBAL.USER_ID CREATED_BY
1947: ,SYSDATE CREATION_DATE
1948: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1949: ,SYSDATE LAST_UPDATE_DATE
1950: ,INNER_Q1.CLE_ID CLE_ID

Line 1948: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY

1944: ,INNER_Q1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
1945: ,INNER_Q1.OKS_STRM_LVL_ID RUL_ID
1946: ,FND_GLOBAL.USER_ID CREATED_BY
1947: ,SYSDATE CREATION_DATE
1948: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1949: ,SYSDATE LAST_UPDATE_DATE
1950: ,INNER_Q1.CLE_ID CLE_ID
1951: ,INNER_Q1.DNZ_CHR_ID DNZ_CHR_ID
1952: ,INNER_Q1.PARENT_CLE_ID PARENT_CLE_ID

Line 2365: , p_created_by => FND_GLOBAL.USER_ID

2361: , p_entered_by => l_cur_hdr_notes_txn_tab(i).entered_by
2362: , p_entered_date => l_cur_hdr_notes_txn_tab(i).entered_date
2363: , x_jtf_note_id => l_jtf_note_id
2364: , p_creation_date => SYSDATE
2365: , p_created_by => FND_GLOBAL.USER_ID
2366: , p_last_update_date => SYSDATE
2367: , p_last_updated_by => FND_GLOBAL.USER_ID
2368: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2369: , p_attribute1 => NULL

Line 2367: , p_last_updated_by => FND_GLOBAL.USER_ID

2363: , x_jtf_note_id => l_jtf_note_id
2364: , p_creation_date => SYSDATE
2365: , p_created_by => FND_GLOBAL.USER_ID
2366: , p_last_update_date => SYSDATE
2367: , p_last_updated_by => FND_GLOBAL.USER_ID
2368: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2369: , p_attribute1 => NULL
2370: , p_attribute2 => NULL
2371: , p_attribute3 => NULL

Line 2368: , p_last_update_login => FND_GLOBAL.LOGIN_ID

2364: , p_creation_date => SYSDATE
2365: , p_created_by => FND_GLOBAL.USER_ID
2366: , p_last_update_date => SYSDATE
2367: , p_last_updated_by => FND_GLOBAL.USER_ID
2368: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2369: , p_attribute1 => NULL
2370: , p_attribute2 => NULL
2371: , p_attribute3 => NULL
2372: , p_attribute4 => NULL

Line 2442: , p_created_by => FND_GLOBAL.USER_ID

2438: , p_entered_by => l_cur_line_notes_txn_tab(i).entered_by
2439: , p_entered_date => l_cur_line_notes_txn_tab(i).entered_date
2440: , x_jtf_note_id => l_jtf_note_id
2441: , p_creation_date => SYSDATE
2442: , p_created_by => FND_GLOBAL.USER_ID
2443: , p_last_update_date => SYSDATE
2444: , p_last_updated_by => FND_GLOBAL.USER_ID
2445: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2446: , p_attribute1 => NULL

Line 2444: , p_last_updated_by => FND_GLOBAL.USER_ID

2440: , x_jtf_note_id => l_jtf_note_id
2441: , p_creation_date => SYSDATE
2442: , p_created_by => FND_GLOBAL.USER_ID
2443: , p_last_update_date => SYSDATE
2444: , p_last_updated_by => FND_GLOBAL.USER_ID
2445: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2446: , p_attribute1 => NULL
2447: , p_attribute2 => NULL
2448: , p_attribute3 => NULL

Line 2445: , p_last_update_login => FND_GLOBAL.LOGIN_ID

2441: , p_creation_date => SYSDATE
2442: , p_created_by => FND_GLOBAL.USER_ID
2443: , p_last_update_date => SYSDATE
2444: , p_last_updated_by => FND_GLOBAL.USER_ID
2445: , p_last_update_login => FND_GLOBAL.LOGIN_ID
2446: , p_attribute1 => NULL
2447: , p_attribute2 => NULL
2448: , p_attribute3 => NULL
2449: , p_attribute4 => NULL