514:
515: -- ----------------------
516: -- Std Who columns
517: -- ----------------------
518: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
519: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
520: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
521: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
522: -- End Bug 4520466
515: -- ----------------------
516: -- Std Who columns
517: -- ----------------------
518: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
519: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
520: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
521: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
522: -- End Bug 4520466
523:
516: -- Std Who columns
517: -- ----------------------
518: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
519: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
520: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
521: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
522: -- End Bug 4520466
523:
524: ---- Added by Vpanwar --- Code for new accounting API uptake
517: -- ----------------------
518: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
519: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
520: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
521: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
522: -- End Bug 4520466
523:
524: ---- Added by Vpanwar --- Code for new accounting API uptake
525: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
570: -- Initialize request/program variables
571: --------------------------------------------
572: BEGIN
573: SELECT
574: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
575: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
576: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
577: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
578: INTO
571: --------------------------------------------
572: BEGIN
573: SELECT
574: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
575: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
576: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
577: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
578: INTO
579: l_request_id,
572: BEGIN
573: SELECT
574: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
575: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
576: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
577: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
578: INTO
579: l_request_id,
580: l_program_application_id,
573: SELECT
574: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
575: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
576: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
577: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
578: INTO
579: l_request_id,
580: l_program_application_id,
581: l_program_id,
1631: l_ext_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;
1632:
1633: BEGIN
1634: SELECT
1635: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1636: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1637: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1638: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1639: INTO
1632:
1633: BEGIN
1634: SELECT
1635: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1636: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1637: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1638: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1639: INTO
1640: l_request_id,
1633: BEGIN
1634: SELECT
1635: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1636: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1637: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1638: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1639: INTO
1640: l_request_id,
1641: l_program_application_id,
1634: SELECT
1635: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1636: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1637: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1638: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1639: INTO
1640: l_request_id,
1641: l_program_application_id,
1642: l_program_id,
1819: ---------------------------------------------
1820: -- Other Mandatory Columns
1821: ---------------------------------------------
1822: tai_tbl(l_tai_cnt).CREATION_DATE := SYSDATE;
1823: tai_tbl(l_tai_cnt).CREATED_BY := Fnd_Global.USER_ID;
1824: tai_tbl(l_tai_cnt).LAST_UPDATE_DATE := SYSDATE;
1825: tai_tbl(l_tai_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1826: tai_tbl(l_tai_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1827: tai_tbl(l_tai_cnt).OBJECT_VERSION_NUMBER := 1;
1821: ---------------------------------------------
1822: tai_tbl(l_tai_cnt).CREATION_DATE := SYSDATE;
1823: tai_tbl(l_tai_cnt).CREATED_BY := Fnd_Global.USER_ID;
1824: tai_tbl(l_tai_cnt).LAST_UPDATE_DATE := SYSDATE;
1825: tai_tbl(l_tai_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1826: tai_tbl(l_tai_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1827: tai_tbl(l_tai_cnt).OBJECT_VERSION_NUMBER := 1;
1828: l_header_id := Okc_P_Util.raw_to_number(sys_guid());
1829: tai_tbl(l_tai_cnt).ID := l_header_id;
1822: tai_tbl(l_tai_cnt).CREATION_DATE := SYSDATE;
1823: tai_tbl(l_tai_cnt).CREATED_BY := Fnd_Global.USER_ID;
1824: tai_tbl(l_tai_cnt).LAST_UPDATE_DATE := SYSDATE;
1825: tai_tbl(l_tai_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1826: tai_tbl(l_tai_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1827: tai_tbl(l_tai_cnt).OBJECT_VERSION_NUMBER := 1;
1828: l_header_id := Okc_P_Util.raw_to_number(sys_guid());
1829: tai_tbl(l_tai_cnt).ID := l_header_id;
1830: tai_tbl(l_tai_cnt).trx_number := SUBSTR(TO_CHAR(l_header_id),-6);
1848: taitl_tbl(l_taitl_cnt).SFWT_FLAG := 'N';
1849: taitl_tbl(l_taitl_cnt).DESCRIPTION := l_def_desc;
1850:
1851: taitl_tbl(l_taitl_cnt).CREATION_DATE := SYSDATE;
1852: taitl_tbl(l_taitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
1853: taitl_tbl(l_taitl_cnt).LAST_UPDATE_DATE := SYSDATE;
1854: taitl_tbl(l_taitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1855: taitl_tbl(l_taitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1856:
1850:
1851: taitl_tbl(l_taitl_cnt).CREATION_DATE := SYSDATE;
1852: taitl_tbl(l_taitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
1853: taitl_tbl(l_taitl_cnt).LAST_UPDATE_DATE := SYSDATE;
1854: taitl_tbl(l_taitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1855: taitl_tbl(l_taitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1856:
1857: l_taitl_cnt := l_taitl_cnt + 1;
1858: END LOOP;
1851: taitl_tbl(l_taitl_cnt).CREATION_DATE := SYSDATE;
1852: taitl_tbl(l_taitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
1853: taitl_tbl(l_taitl_cnt).LAST_UPDATE_DATE := SYSDATE;
1854: taitl_tbl(l_taitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1855: taitl_tbl(l_taitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1856:
1857: l_taitl_cnt := l_taitl_cnt + 1;
1858: END LOOP;
1859: ------------------------------------------------
2010: til_tbl(l_til_cnt).ID := l_line_id;
2011:
2012: til_tbl(l_til_cnt).OBJECT_VERSION_NUMBER := 1;
2013: til_tbl(l_til_cnt).CREATION_DATE := SYSDATE;
2014: til_tbl(l_til_cnt).CREATED_BY := Fnd_Global.USER_ID;
2015: til_tbl(l_til_cnt).LAST_UPDATE_DATE := SYSDATE;
2016: til_tbl(l_til_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2017: til_tbl(l_til_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2018:
2012: til_tbl(l_til_cnt).OBJECT_VERSION_NUMBER := 1;
2013: til_tbl(l_til_cnt).CREATION_DATE := SYSDATE;
2014: til_tbl(l_til_cnt).CREATED_BY := Fnd_Global.USER_ID;
2015: til_tbl(l_til_cnt).LAST_UPDATE_DATE := SYSDATE;
2016: til_tbl(l_til_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2017: til_tbl(l_til_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2018:
2019: til_tbl(l_til_cnt).request_id := l_request_id;
2020: til_tbl(l_til_cnt).program_application_id := l_program_application_id;
2013: til_tbl(l_til_cnt).CREATION_DATE := SYSDATE;
2014: til_tbl(l_til_cnt).CREATED_BY := Fnd_Global.USER_ID;
2015: til_tbl(l_til_cnt).LAST_UPDATE_DATE := SYSDATE;
2016: til_tbl(l_til_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2017: til_tbl(l_til_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2018:
2019: til_tbl(l_til_cnt).request_id := l_request_id;
2020: til_tbl(l_til_cnt).program_application_id := l_program_application_id;
2021: til_tbl(l_til_cnt).program_id := l_program_id;
2032: tiltl_tbl(l_tiltl_cnt).SFWT_FLAG := 'N';
2033: tiltl_tbl(l_tiltl_cnt).DESCRIPTION := l_def_desc;
2034:
2035: tiltl_tbl(l_tiltl_cnt).CREATION_DATE := SYSDATE;
2036: tiltl_tbl(l_tiltl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2037: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_DATE := SYSDATE;
2038: tiltl_tbl(l_tiltl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2039: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2040:
2034:
2035: tiltl_tbl(l_tiltl_cnt).CREATION_DATE := SYSDATE;
2036: tiltl_tbl(l_tiltl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2037: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_DATE := SYSDATE;
2038: tiltl_tbl(l_tiltl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2039: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2040:
2041: l_tiltl_cnt := l_tiltl_cnt + 1;
2042: END LOOP;
2035: tiltl_tbl(l_tiltl_cnt).CREATION_DATE := SYSDATE;
2036: tiltl_tbl(l_tiltl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2037: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_DATE := SYSDATE;
2038: tiltl_tbl(l_tiltl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2039: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2040:
2041: l_tiltl_cnt := l_tiltl_cnt + 1;
2042: END LOOP;
2043:
2102: --cklee: start 3/16/07
2103: tld_tbl(l_tld_cnt).ID := l_tld_id;
2104: tld_tbl(l_tld_cnt).OBJECT_VERSION_NUMBER := 1;
2105: tld_tbl(l_tld_cnt).CREATION_DATE := SYSDATE;
2106: tld_tbl(l_tld_cnt).CREATED_BY := Fnd_Global.USER_ID;
2107: tld_tbl(l_tld_cnt).LAST_UPDATE_DATE := SYSDATE;
2108: tld_tbl(l_tld_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2109: tld_tbl(l_tld_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2110:
2104: tld_tbl(l_tld_cnt).OBJECT_VERSION_NUMBER := 1;
2105: tld_tbl(l_tld_cnt).CREATION_DATE := SYSDATE;
2106: tld_tbl(l_tld_cnt).CREATED_BY := Fnd_Global.USER_ID;
2107: tld_tbl(l_tld_cnt).LAST_UPDATE_DATE := SYSDATE;
2108: tld_tbl(l_tld_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2109: tld_tbl(l_tld_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2110:
2111: tld_tbl(l_tld_cnt).request_id := l_request_id;
2112: tld_tbl(l_tld_cnt).program_application_id := l_program_application_id;
2105: tld_tbl(l_tld_cnt).CREATION_DATE := SYSDATE;
2106: tld_tbl(l_tld_cnt).CREATED_BY := Fnd_Global.USER_ID;
2107: tld_tbl(l_tld_cnt).LAST_UPDATE_DATE := SYSDATE;
2108: tld_tbl(l_tld_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2109: tld_tbl(l_tld_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2110:
2111: tld_tbl(l_tld_cnt).request_id := l_request_id;
2112: tld_tbl(l_tld_cnt).program_application_id := l_program_application_id;
2113: tld_tbl(l_tld_cnt).program_id := l_program_id;
2126: tldtl_tbl(l_tldtl_cnt).SFWT_FLAG := 'N';
2127: tldtl_tbl(l_tldtl_cnt).DESCRIPTION := p_bill_tbl(k).sty_name;
2128:
2129: tldtl_tbl(l_tldtl_cnt).CREATION_DATE := SYSDATE;
2130: tldtl_tbl(l_tldtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2131: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2132: tldtl_tbl(l_tldtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2133: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2134:
2128:
2129: tldtl_tbl(l_tldtl_cnt).CREATION_DATE := SYSDATE;
2130: tldtl_tbl(l_tldtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2131: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2132: tldtl_tbl(l_tldtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2133: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2134:
2135: l_tldtl_cnt := l_tldtl_cnt + 1;
2136: END LOOP;
2129: tldtl_tbl(l_tldtl_cnt).CREATION_DATE := SYSDATE;
2130: tldtl_tbl(l_tldtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2131: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2132: tldtl_tbl(l_tldtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2133: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2134:
2135: l_tldtl_cnt := l_tldtl_cnt + 1;
2136: END LOOP;
2137:
3602: --Bug 7584183-Added by kkorrapo
3603: l_request_id NUMBER := -1;
3604: CURSOR req_id_csr IS
3605: SELECT
3606: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
3607: FROM dual;
3608: --Bug 7584183-Addition end
3609:
3610: BEGIN