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

Line 355: last_updated_by = Fnd_Global.USER_ID,

351: FORALL indx IN tai_id_tbl.FIRST..tai_id_tbl.LAST
352: UPDATE okl_trx_ar_invoices_b
353: SET trx_status_code = 'PROCESSED',
354: last_update_date = SYSDATE,
355: last_updated_by = Fnd_Global.USER_ID,
356: last_update_login = Fnd_Global.LOGIN_ID
357: WHERE ID = tai_id_tbl(indx);
358:
359: COMMIT;

Line 356: last_update_login = Fnd_Global.LOGIN_ID

352: UPDATE okl_trx_ar_invoices_b
353: SET trx_status_code = 'PROCESSED',
354: last_update_date = SYSDATE,
355: last_updated_by = Fnd_Global.USER_ID,
356: last_update_login = Fnd_Global.LOGIN_ID
357: WHERE ID = tai_id_tbl(indx);
358:
359: COMMIT;
360: Fnd_File.PUT_LINE (Fnd_File.LOG, 'BULK Status updated!');

Line 854: SELECT decode(fnd_global.conc_request_id, -1, NULL, fnd_global.conc_request_id)

850: -- ------------------------------------------------
851: l_request_id NUMBER;
852:
853: CURSOR req_id_csr IS
854: SELECT decode(fnd_global.conc_request_id, -1, NULL, fnd_global.conc_request_id)
855: FROM dual;
856:
857: ------------------------------------------------------------
858: -- Operating Unit

Line 1026: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

1022:
1023: ELSE -- p_end_of_records = 'N'
1024: BEGIN
1025: SELECT
1026: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1027: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1028: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1029: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1030: INTO

Line 1027: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

1023: ELSE -- p_end_of_records = 'N'
1024: BEGIN
1025: SELECT
1026: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1027: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1028: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1029: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1030: INTO
1031: l_request_id,

Line 1028: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

1024: BEGIN
1025: SELECT
1026: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1027: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1028: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1029: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1030: INTO
1031: l_request_id,
1032: l_program_application_id,

Line 1029: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)

1025: SELECT
1026: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1027: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1028: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1029: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1030: INTO
1031: l_request_id,
1032: l_program_application_id,
1033: l_program_id,

Line 1591: xsi_tbl(l_xsi_cnt).CREATED_BY := Fnd_Global.USER_ID;

1587: l_xsi_id := Okc_P_Util.raw_to_number(sys_guid());
1588: xsi_tbl(l_xsi_cnt).ID := l_xsi_id;
1589: xsi_tbl(l_xsi_cnt).OBJECT_VERSION_NUMBER := 1;
1590: xsi_tbl(l_xsi_cnt).CREATION_DATE := SYSDATE;
1591: xsi_tbl(l_xsi_cnt).CREATED_BY := Fnd_Global.USER_ID;
1592: xsi_tbl(l_xsi_cnt).LAST_UPDATE_DATE := SYSDATE;
1593: xsi_tbl(l_xsi_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1594: xsi_tbl(l_xsi_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1595:

Line 1593: xsi_tbl(l_xsi_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

1589: xsi_tbl(l_xsi_cnt).OBJECT_VERSION_NUMBER := 1;
1590: xsi_tbl(l_xsi_cnt).CREATION_DATE := SYSDATE;
1591: xsi_tbl(l_xsi_cnt).CREATED_BY := Fnd_Global.USER_ID;
1592: xsi_tbl(l_xsi_cnt).LAST_UPDATE_DATE := SYSDATE;
1593: xsi_tbl(l_xsi_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1594: xsi_tbl(l_xsi_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1595:
1596: xsi_tbl(l_xsi_cnt).request_id := l_request_id;
1597: xsi_tbl(l_xsi_cnt).program_application_id := l_program_application_id;

Line 1594: xsi_tbl(l_xsi_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1590: xsi_tbl(l_xsi_cnt).CREATION_DATE := SYSDATE;
1591: xsi_tbl(l_xsi_cnt).CREATED_BY := Fnd_Global.USER_ID;
1592: xsi_tbl(l_xsi_cnt).LAST_UPDATE_DATE := SYSDATE;
1593: xsi_tbl(l_xsi_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1594: xsi_tbl(l_xsi_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1595:
1596: xsi_tbl(l_xsi_cnt).request_id := l_request_id;
1597: xsi_tbl(l_xsi_cnt).program_application_id := l_program_application_id;
1598: xsi_tbl(l_xsi_cnt).program_id := l_program_id;

Line 1621: xsitl_tbl(l_xsitl_cnt).CREATED_BY := Fnd_Global.USER_ID;

1617: xsitl_tbl(l_xsitl_cnt).SFWT_FLAG := 'N';
1618: --xsitl_tbl(l_xsitl_cnt).DESCRIPTION := l_def_desc;
1619:
1620: xsitl_tbl(l_xsitl_cnt).CREATION_DATE := SYSDATE;
1621: xsitl_tbl(l_xsitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
1622: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_DATE := SYSDATE;
1623: xsitl_tbl(l_xsitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1624: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1625:

Line 1623: xsitl_tbl(l_xsitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

1619:
1620: xsitl_tbl(l_xsitl_cnt).CREATION_DATE := SYSDATE;
1621: xsitl_tbl(l_xsitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
1622: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_DATE := SYSDATE;
1623: xsitl_tbl(l_xsitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1624: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1625:
1626: END LOOP;
1627:

Line 1624: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1620: xsitl_tbl(l_xsitl_cnt).CREATION_DATE := SYSDATE;
1621: xsitl_tbl(l_xsitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
1622: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_DATE := SYSDATE;
1623: xsitl_tbl(l_xsitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1624: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1625:
1626: END LOOP;
1627:
1628: -- end copy from g

Line 1737: xls_tbl(l_xls_cnt).CREATED_BY := Fnd_Global.USER_ID;

1733: l_xls_id := Okc_P_Util.raw_to_number(sys_guid());
1734: xls_tbl(l_xls_cnt).ID := l_xls_id;
1735: xls_tbl(l_xls_cnt).OBJECT_VERSION_NUMBER := 1;
1736: xls_tbl(l_xls_cnt).CREATION_DATE := SYSDATE;
1737: xls_tbl(l_xls_cnt).CREATED_BY := Fnd_Global.USER_ID;
1738: xls_tbl(l_xls_cnt).LAST_UPDATE_DATE := SYSDATE;
1739: xls_tbl(l_xls_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1740: xls_tbl(l_xls_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1741:

Line 1739: xls_tbl(l_xls_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

1735: xls_tbl(l_xls_cnt).OBJECT_VERSION_NUMBER := 1;
1736: xls_tbl(l_xls_cnt).CREATION_DATE := SYSDATE;
1737: xls_tbl(l_xls_cnt).CREATED_BY := Fnd_Global.USER_ID;
1738: xls_tbl(l_xls_cnt).LAST_UPDATE_DATE := SYSDATE;
1739: xls_tbl(l_xls_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1740: xls_tbl(l_xls_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1741:
1742: xls_tbl(l_xls_cnt).request_id := l_request_id;
1743: xls_tbl(l_xls_cnt).program_application_id := l_program_application_id;

Line 1740: xls_tbl(l_xls_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1736: xls_tbl(l_xls_cnt).CREATION_DATE := SYSDATE;
1737: xls_tbl(l_xls_cnt).CREATED_BY := Fnd_Global.USER_ID;
1738: xls_tbl(l_xls_cnt).LAST_UPDATE_DATE := SYSDATE;
1739: xls_tbl(l_xls_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1740: xls_tbl(l_xls_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1741:
1742: xls_tbl(l_xls_cnt).request_id := l_request_id;
1743: xls_tbl(l_xls_cnt).program_application_id := l_program_application_id;
1744: xls_tbl(l_xls_cnt).program_id := l_program_id;

Line 1765: xlstl_tbl(l_xlstl_cnt).CREATED_BY := Fnd_Global.USER_ID;

1761: xlstl_tbl(l_xlstl_cnt).XTRX_STREAM_GROUP := NULL;
1762: xlstl_tbl(l_xlstl_cnt).XTRX_STREAM_TYPE := NULL;
1763:
1764: xlstl_tbl(l_xlstl_cnt).CREATION_DATE := SYSDATE;
1765: xlstl_tbl(l_xlstl_cnt).CREATED_BY := Fnd_Global.USER_ID;
1766: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_DATE := SYSDATE;
1767: xlstl_tbl(l_xlstl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1768: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1769:

Line 1767: xlstl_tbl(l_xlstl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

1763:
1764: xlstl_tbl(l_xlstl_cnt).CREATION_DATE := SYSDATE;
1765: xlstl_tbl(l_xlstl_cnt).CREATED_BY := Fnd_Global.USER_ID;
1766: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_DATE := SYSDATE;
1767: xlstl_tbl(l_xlstl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1768: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1769:
1770: END LOOP;
1771:

Line 1768: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1764: xlstl_tbl(l_xlstl_cnt).CREATION_DATE := SYSDATE;
1765: xlstl_tbl(l_xlstl_cnt).CREATED_BY := Fnd_Global.USER_ID;
1766: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_DATE := SYSDATE;
1767: xlstl_tbl(l_xlstl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1768: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1769:
1770: END LOOP;
1771:
1772: --end copy from g

Line 2009: esd_tbl(l_esd_cnt).CREATED_BY := Fnd_Global.USER_ID;

2005: esd_tbl(l_esd_cnt).OBJECT_VERSION_NUMBER := 1;
2006:
2007: esd_tbl(l_esd_cnt).ORG_ID := NULL;
2008: esd_tbl(l_esd_cnt).CREATION_DATE := SYSDATE;
2009: esd_tbl(l_esd_cnt).CREATED_BY := Fnd_Global.USER_ID;
2010: esd_tbl(l_esd_cnt).LAST_UPDATE_DATE := SYSDATE;
2011: esd_tbl(l_esd_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2012: esd_tbl(l_esd_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2013:

Line 2011: esd_tbl(l_esd_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

2007: esd_tbl(l_esd_cnt).ORG_ID := NULL;
2008: esd_tbl(l_esd_cnt).CREATION_DATE := SYSDATE;
2009: esd_tbl(l_esd_cnt).CREATED_BY := Fnd_Global.USER_ID;
2010: esd_tbl(l_esd_cnt).LAST_UPDATE_DATE := SYSDATE;
2011: esd_tbl(l_esd_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2012: esd_tbl(l_esd_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2013:
2014: esd_tbl(l_esd_cnt).request_id := l_request_id;
2015: esd_tbl(l_esd_cnt).program_application_id := l_program_application_id;

Line 2012: esd_tbl(l_esd_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2008: esd_tbl(l_esd_cnt).CREATION_DATE := SYSDATE;
2009: esd_tbl(l_esd_cnt).CREATED_BY := Fnd_Global.USER_ID;
2010: esd_tbl(l_esd_cnt).LAST_UPDATE_DATE := SYSDATE;
2011: esd_tbl(l_esd_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2012: esd_tbl(l_esd_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2013:
2014: esd_tbl(l_esd_cnt).request_id := l_request_id;
2015: esd_tbl(l_esd_cnt).program_application_id := l_program_application_id;
2016: esd_tbl(l_esd_cnt).program_id := l_program_id;

Line 2030: esdtl_tbl(l_esdtl_cnt).CREATED_BY := Fnd_Global.USER_ID;

2026: esdtl_tbl(l_esdtl_cnt).SOURCE_LANG := USERENV('LANG');
2027: esdtl_tbl(l_esdtl_cnt).SFWT_FLAG := 'N';
2028:
2029: esdtl_tbl(l_esdtl_cnt).CREATION_DATE := SYSDATE;
2030: esdtl_tbl(l_esdtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2031: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2032: esdtl_tbl(l_esdtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2033: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2034:

Line 2032: esdtl_tbl(l_esdtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

2028:
2029: esdtl_tbl(l_esdtl_cnt).CREATION_DATE := SYSDATE;
2030: esdtl_tbl(l_esdtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2031: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2032: esdtl_tbl(l_esdtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2033: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2034:
2035: END LOOP;
2036: END IF;

Line 2033: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2029: esdtl_tbl(l_esdtl_cnt).CREATION_DATE := SYSDATE;
2030: esdtl_tbl(l_esdtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2031: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2032: esdtl_tbl(l_esdtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2033: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2034:
2035: END LOOP;
2036: END IF;
2037: END LOOP; --loop through acc_dtls_rec

Line 2677: xsi_tbl(l_xsi_cnt).CREATED_BY := Fnd_Global.USER_ID;

2673: l_xsi_id := Okc_P_Util.raw_to_number(sys_guid());
2674: xsi_tbl(l_xsi_cnt).ID := l_xsi_id;
2675: xsi_tbl(l_xsi_cnt).OBJECT_VERSION_NUMBER := 1;
2676: xsi_tbl(l_xsi_cnt).CREATION_DATE := SYSDATE;
2677: xsi_tbl(l_xsi_cnt).CREATED_BY := Fnd_Global.USER_ID;
2678: xsi_tbl(l_xsi_cnt).LAST_UPDATE_DATE := SYSDATE;
2679: xsi_tbl(l_xsi_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2680: xsi_tbl(l_xsi_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2681:

Line 2679: xsi_tbl(l_xsi_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

2675: xsi_tbl(l_xsi_cnt).OBJECT_VERSION_NUMBER := 1;
2676: xsi_tbl(l_xsi_cnt).CREATION_DATE := SYSDATE;
2677: xsi_tbl(l_xsi_cnt).CREATED_BY := Fnd_Global.USER_ID;
2678: xsi_tbl(l_xsi_cnt).LAST_UPDATE_DATE := SYSDATE;
2679: xsi_tbl(l_xsi_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2680: xsi_tbl(l_xsi_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2681:
2682: xsi_tbl(l_xsi_cnt).request_id := l_request_id;
2683: xsi_tbl(l_xsi_cnt).program_application_id := l_program_application_id;

Line 2680: xsi_tbl(l_xsi_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2676: xsi_tbl(l_xsi_cnt).CREATION_DATE := SYSDATE;
2677: xsi_tbl(l_xsi_cnt).CREATED_BY := Fnd_Global.USER_ID;
2678: xsi_tbl(l_xsi_cnt).LAST_UPDATE_DATE := SYSDATE;
2679: xsi_tbl(l_xsi_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2680: xsi_tbl(l_xsi_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2681:
2682: xsi_tbl(l_xsi_cnt).request_id := l_request_id;
2683: xsi_tbl(l_xsi_cnt).program_application_id := l_program_application_id;
2684: xsi_tbl(l_xsi_cnt).program_id := l_program_id;

Line 2711: xsitl_tbl(l_xsitl_cnt).CREATED_BY := Fnd_Global.USER_ID;

2707: xsitl_tbl(l_xsitl_cnt).SFWT_FLAG := 'N';
2708: --xsitl_tbl(l_xsitl_cnt).DESCRIPTION := l_def_desc;
2709:
2710: xsitl_tbl(l_xsitl_cnt).CREATION_DATE := SYSDATE;
2711: xsitl_tbl(l_xsitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2712: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_DATE := SYSDATE;
2713: xsitl_tbl(l_xsitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2714: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2715:

Line 2713: xsitl_tbl(l_xsitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

2709:
2710: xsitl_tbl(l_xsitl_cnt).CREATION_DATE := SYSDATE;
2711: xsitl_tbl(l_xsitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2712: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_DATE := SYSDATE;
2713: xsitl_tbl(l_xsitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2714: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2715:
2716: END LOOP;
2717: --PRINT_TO_LOG('TBL2 after populateing xsi tbl ');

Line 2714: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2710: xsitl_tbl(l_xsitl_cnt).CREATION_DATE := SYSDATE;
2711: xsitl_tbl(l_xsitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2712: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_DATE := SYSDATE;
2713: xsitl_tbl(l_xsitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2714: xsitl_tbl(l_xsitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2715:
2716: END LOOP;
2717: --PRINT_TO_LOG('TBL2 after populateing xsi tbl ');
2718:

Line 2818: xls_tbl(l_xls_cnt).CREATED_BY := Fnd_Global.USER_ID;

2814: l_xls_id := Okc_P_Util.raw_to_number(sys_guid());
2815: xls_tbl(l_xls_cnt).ID := l_xls_id;
2816: xls_tbl(l_xls_cnt).OBJECT_VERSION_NUMBER := 1;
2817: xls_tbl(l_xls_cnt).CREATION_DATE := SYSDATE;
2818: xls_tbl(l_xls_cnt).CREATED_BY := Fnd_Global.USER_ID;
2819: xls_tbl(l_xls_cnt).LAST_UPDATE_DATE := SYSDATE;
2820: xls_tbl(l_xls_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2821: xls_tbl(l_xls_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2822:

Line 2820: xls_tbl(l_xls_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

2816: xls_tbl(l_xls_cnt).OBJECT_VERSION_NUMBER := 1;
2817: xls_tbl(l_xls_cnt).CREATION_DATE := SYSDATE;
2818: xls_tbl(l_xls_cnt).CREATED_BY := Fnd_Global.USER_ID;
2819: xls_tbl(l_xls_cnt).LAST_UPDATE_DATE := SYSDATE;
2820: xls_tbl(l_xls_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2821: xls_tbl(l_xls_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2822:
2823: xls_tbl(l_xls_cnt).request_id := l_request_id;
2824: xls_tbl(l_xls_cnt).program_application_id := l_program_application_id;

Line 2821: xls_tbl(l_xls_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2817: xls_tbl(l_xls_cnt).CREATION_DATE := SYSDATE;
2818: xls_tbl(l_xls_cnt).CREATED_BY := Fnd_Global.USER_ID;
2819: xls_tbl(l_xls_cnt).LAST_UPDATE_DATE := SYSDATE;
2820: xls_tbl(l_xls_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2821: xls_tbl(l_xls_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2822:
2823: xls_tbl(l_xls_cnt).request_id := l_request_id;
2824: xls_tbl(l_xls_cnt).program_application_id := l_program_application_id;
2825: xls_tbl(l_xls_cnt).program_id := l_program_id;

Line 2847: xlstl_tbl(l_xlstl_cnt).CREATED_BY := Fnd_Global.USER_ID;

2843: xlstl_tbl(l_xlstl_cnt).XTRX_STREAM_GROUP := NULL;
2844: xlstl_tbl(l_xlstl_cnt).XTRX_STREAM_TYPE := NULL;
2845:
2846: xlstl_tbl(l_xlstl_cnt).CREATION_DATE := SYSDATE;
2847: xlstl_tbl(l_xlstl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2848: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_DATE := SYSDATE;
2849: xlstl_tbl(l_xlstl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2850: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2851:

Line 2849: xlstl_tbl(l_xlstl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

2845:
2846: xlstl_tbl(l_xlstl_cnt).CREATION_DATE := SYSDATE;
2847: xlstl_tbl(l_xlstl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2848: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_DATE := SYSDATE;
2849: xlstl_tbl(l_xlstl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2850: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2851:
2852: END LOOP;
2853: --PRINT_TO_LOG('TBL2 after populateing xls tbl ');

Line 2850: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2846: xlstl_tbl(l_xlstl_cnt).CREATION_DATE := SYSDATE;
2847: xlstl_tbl(l_xlstl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2848: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_DATE := SYSDATE;
2849: xlstl_tbl(l_xlstl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2850: xlstl_tbl(l_xlstl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2851:
2852: END LOOP;
2853: --PRINT_TO_LOG('TBL2 after populateing xls tbl ');
2854:

Line 2957: esd_tbl(l_esd_cnt).CREATED_BY := Fnd_Global.USER_ID;

2953: esd_tbl(l_esd_cnt).OBJECT_VERSION_NUMBER := 1;
2954:
2955: esd_tbl(l_esd_cnt).ORG_ID := NULL;
2956: esd_tbl(l_esd_cnt).CREATION_DATE := SYSDATE;
2957: esd_tbl(l_esd_cnt).CREATED_BY := Fnd_Global.USER_ID;
2958: esd_tbl(l_esd_cnt).LAST_UPDATE_DATE := SYSDATE;
2959: esd_tbl(l_esd_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2960: esd_tbl(l_esd_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2961:

Line 2959: esd_tbl(l_esd_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

2955: esd_tbl(l_esd_cnt).ORG_ID := NULL;
2956: esd_tbl(l_esd_cnt).CREATION_DATE := SYSDATE;
2957: esd_tbl(l_esd_cnt).CREATED_BY := Fnd_Global.USER_ID;
2958: esd_tbl(l_esd_cnt).LAST_UPDATE_DATE := SYSDATE;
2959: esd_tbl(l_esd_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2960: esd_tbl(l_esd_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2961:
2962: esd_tbl(l_esd_cnt).request_id := l_request_id;
2963: esd_tbl(l_esd_cnt).program_application_id := l_program_application_id;

Line 2960: esd_tbl(l_esd_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2956: esd_tbl(l_esd_cnt).CREATION_DATE := SYSDATE;
2957: esd_tbl(l_esd_cnt).CREATED_BY := Fnd_Global.USER_ID;
2958: esd_tbl(l_esd_cnt).LAST_UPDATE_DATE := SYSDATE;
2959: esd_tbl(l_esd_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2960: esd_tbl(l_esd_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2961:
2962: esd_tbl(l_esd_cnt).request_id := l_request_id;
2963: esd_tbl(l_esd_cnt).program_application_id := l_program_application_id;
2964: esd_tbl(l_esd_cnt).program_id := l_program_id;

Line 2977: esdtl_tbl(l_esdtl_cnt).CREATED_BY := Fnd_Global.USER_ID;

2973: esdtl_tbl(l_esdtl_cnt).SOURCE_LANG := USERENV('LANG');
2974: esdtl_tbl(l_esdtl_cnt).SFWT_FLAG := 'N';
2975:
2976: esdtl_tbl(l_esdtl_cnt).CREATION_DATE := SYSDATE;
2977: esdtl_tbl(l_esdtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2978: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2979: esdtl_tbl(l_esdtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2980: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2981:

Line 2979: esdtl_tbl(l_esdtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

2975:
2976: esdtl_tbl(l_esdtl_cnt).CREATION_DATE := SYSDATE;
2977: esdtl_tbl(l_esdtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2978: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2979: esdtl_tbl(l_esdtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2980: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2981:
2982: END LOOP;
2983: --PRINT_TO_LOG('TBL2 after populateing l_esd_tbl');

Line 2980: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2976: esdtl_tbl(l_esdtl_cnt).CREATION_DATE := SYSDATE;
2977: esdtl_tbl(l_esdtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2978: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2979: esdtl_tbl(l_esdtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2980: esdtl_tbl(l_esdtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2981:
2982: END LOOP;
2983: --PRINT_TO_LOG('TBL2 after populateing l_esd_tbl');
2984: END IF;

Line 3473: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)

3469: l_request_id NUMBER;
3470:
3471: CURSOR req_id_csr IS
3472: SELECT
3473: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
3474: FROM dual;
3475:
3476:
3477: CURSOR xsi_cnt_succ_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS