DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on FND_GLOBAL

Line 518: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;

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

Line 519: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;

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:

Line 520: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;

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

Line 521: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

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;

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

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

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

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,

Line 576: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_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,

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

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,

Line 1635: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_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

Line 1636: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_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
1640: l_request_id,

Line 1637: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_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,

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

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,

Line 1823: tai_tbl(l_tai_cnt).CREATED_BY := Fnd_Global.USER_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;

Line 1825: tai_tbl(l_tai_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

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;

Line 1826: tai_tbl(l_tai_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_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);

Line 1852: taitl_tbl(l_taitl_cnt).CREATED_BY := Fnd_Global.USER_ID;

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:

Line 1854: taitl_tbl(l_taitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

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;

Line 1855: taitl_tbl(l_taitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

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: ------------------------------------------------

Line 2014: til_tbl(l_til_cnt).CREATED_BY := Fnd_Global.USER_ID;

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:

Line 2016: til_tbl(l_til_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

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;

Line 2017: til_tbl(l_til_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_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;

Line 2036: tiltl_tbl(l_tiltl_cnt).CREATED_BY := Fnd_Global.USER_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:

Line 2038: tiltl_tbl(l_tiltl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

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;

Line 2039: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

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:

Line 2106: tld_tbl(l_tld_cnt).CREATED_BY := Fnd_Global.USER_ID;

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:

Line 2108: tld_tbl(l_tld_cnt).LAST_UPDATED_BY := Fnd_Global.USER_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:
2111: tld_tbl(l_tld_cnt).request_id := l_request_id;
2112: tld_tbl(l_tld_cnt).program_application_id := l_program_application_id;

Line 2109: tld_tbl(l_tld_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_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;

Line 2130: tldtl_tbl(l_tldtl_cnt).CREATED_BY := Fnd_Global.USER_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:

Line 2132: tldtl_tbl(l_tldtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

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;

Line 2133: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

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:

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

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