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_STREAM_BILLING_PVT dependencies on FND_GLOBAL

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

573:
574: -- ----------------------
575: -- Std Who columns
576: -- ----------------------
577: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
578: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
579: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
580: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
581: -- End Bug 4520466

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

574: -- ----------------------
575: -- Std Who columns
576: -- ----------------------
577: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
578: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
579: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
580: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
581: -- End Bug 4520466
582:

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

575: -- Std Who columns
576: -- ----------------------
577: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
578: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
579: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
580: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
581: -- End Bug 4520466
582:
583: ---- Added by Vpanwar --- Code for new accounting API uptake

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

576: -- ----------------------
577: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
578: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
579: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
580: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
581: -- End Bug 4520466
582:
583: ---- Added by Vpanwar --- Code for new accounting API uptake
584: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;

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

629: -- Initialize request/program variables
630: --------------------------------------------
631: BEGIN
632: SELECT
633: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
634: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
635: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
636: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
637: INTO

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

630: --------------------------------------------
631: BEGIN
632: SELECT
633: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
634: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
635: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
636: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
637: INTO
638: l_request_id,

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

631: BEGIN
632: SELECT
633: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
634: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
635: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
636: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
637: INTO
638: l_request_id,
639: l_program_application_id,

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

632: SELECT
633: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
634: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
635: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
636: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
637: INTO
638: l_request_id,
639: l_program_application_id,
640: l_program_id,

Line 1002: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG 14742784 change starts here

998: IF sel_id_tbl.COUNT > 0 THEN
999: FORALL indx IN sel_id_tbl.FIRST..sel_id_tbl.LAST
1000: UPDATE okl_strm_elements
1001: SET date_billed = SYSDATE
1002: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG 14742784 change starts here
1003: ,last_update_date = sysdate
1004: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG 14742784 change ends here
1005: WHERE id = sel_id_tbl(indx);
1006: END IF;

Line 1004: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG 14742784 change ends here

1000: UPDATE okl_strm_elements
1001: SET date_billed = SYSDATE
1002: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG 14742784 change starts here
1003: ,last_update_date = sysdate
1004: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG 14742784 change ends here
1005: WHERE id = sel_id_tbl(indx);
1006: END IF;
1007:
1008: -- Start Bug 4520466 stmathew update okl_k_control

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

1702: l_ext_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;
1703:
1704: BEGIN
1705: SELECT
1706: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1707: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1708: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1709: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1710: INTO

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

1703:
1704: BEGIN
1705: SELECT
1706: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1707: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1708: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1709: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1710: INTO
1711: l_request_id,

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

1704: BEGIN
1705: SELECT
1706: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1707: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1708: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1709: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1710: INTO
1711: l_request_id,
1712: l_program_application_id,

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

1705: SELECT
1706: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1707: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1708: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1709: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1710: INTO
1711: l_request_id,
1712: l_program_application_id,
1713: l_program_id,

Line 1995: tai_tbl(l_tai_cnt).CREATED_BY := Fnd_Global.USER_ID;

1991: ---------------------------------------------
1992: -- Other Mandatory Columns
1993: ---------------------------------------------
1994: tai_tbl(l_tai_cnt).CREATION_DATE := SYSDATE;
1995: tai_tbl(l_tai_cnt).CREATED_BY := Fnd_Global.USER_ID;
1996: tai_tbl(l_tai_cnt).LAST_UPDATE_DATE := SYSDATE;
1997: tai_tbl(l_tai_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1998: tai_tbl(l_tai_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1999: tai_tbl(l_tai_cnt).OBJECT_VERSION_NUMBER := 1;

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

1993: ---------------------------------------------
1994: tai_tbl(l_tai_cnt).CREATION_DATE := SYSDATE;
1995: tai_tbl(l_tai_cnt).CREATED_BY := Fnd_Global.USER_ID;
1996: tai_tbl(l_tai_cnt).LAST_UPDATE_DATE := SYSDATE;
1997: tai_tbl(l_tai_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1998: tai_tbl(l_tai_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1999: tai_tbl(l_tai_cnt).OBJECT_VERSION_NUMBER := 1;
2000: l_header_id := Okc_P_Util.raw_to_number(sys_guid());
2001: tai_tbl(l_tai_cnt).ID := l_header_id;

Line 1998: tai_tbl(l_tai_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

1994: tai_tbl(l_tai_cnt).CREATION_DATE := SYSDATE;
1995: tai_tbl(l_tai_cnt).CREATED_BY := Fnd_Global.USER_ID;
1996: tai_tbl(l_tai_cnt).LAST_UPDATE_DATE := SYSDATE;
1997: tai_tbl(l_tai_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
1998: tai_tbl(l_tai_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1999: tai_tbl(l_tai_cnt).OBJECT_VERSION_NUMBER := 1;
2000: l_header_id := Okc_P_Util.raw_to_number(sys_guid());
2001: tai_tbl(l_tai_cnt).ID := l_header_id;
2002: tai_tbl(l_tai_cnt).trx_number := SUBSTR(TO_CHAR(l_header_id),-6);

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

2020: taitl_tbl(l_taitl_cnt).SFWT_FLAG := 'N';
2021: taitl_tbl(l_taitl_cnt).DESCRIPTION := l_def_desc;
2022:
2023: taitl_tbl(l_taitl_cnt).CREATION_DATE := SYSDATE;
2024: taitl_tbl(l_taitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2025: taitl_tbl(l_taitl_cnt).LAST_UPDATE_DATE := SYSDATE;
2026: taitl_tbl(l_taitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2027: taitl_tbl(l_taitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2028:

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

2022:
2023: taitl_tbl(l_taitl_cnt).CREATION_DATE := SYSDATE;
2024: taitl_tbl(l_taitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2025: taitl_tbl(l_taitl_cnt).LAST_UPDATE_DATE := SYSDATE;
2026: taitl_tbl(l_taitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2027: taitl_tbl(l_taitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2028:
2029: l_taitl_cnt := l_taitl_cnt + 1;
2030: END LOOP;

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

2023: taitl_tbl(l_taitl_cnt).CREATION_DATE := SYSDATE;
2024: taitl_tbl(l_taitl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2025: taitl_tbl(l_taitl_cnt).LAST_UPDATE_DATE := SYSDATE;
2026: taitl_tbl(l_taitl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2027: taitl_tbl(l_taitl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2028:
2029: l_taitl_cnt := l_taitl_cnt + 1;
2030: END LOOP;
2031: ------------------------------------------------

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

2184: til_tbl(l_til_cnt).ID := l_line_id;
2185:
2186: til_tbl(l_til_cnt).OBJECT_VERSION_NUMBER := 1;
2187: til_tbl(l_til_cnt).CREATION_DATE := SYSDATE;
2188: til_tbl(l_til_cnt).CREATED_BY := Fnd_Global.USER_ID;
2189: til_tbl(l_til_cnt).LAST_UPDATE_DATE := SYSDATE;
2190: til_tbl(l_til_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2191: til_tbl(l_til_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2192:

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

2186: til_tbl(l_til_cnt).OBJECT_VERSION_NUMBER := 1;
2187: til_tbl(l_til_cnt).CREATION_DATE := SYSDATE;
2188: til_tbl(l_til_cnt).CREATED_BY := Fnd_Global.USER_ID;
2189: til_tbl(l_til_cnt).LAST_UPDATE_DATE := SYSDATE;
2190: til_tbl(l_til_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2191: til_tbl(l_til_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2192:
2193: til_tbl(l_til_cnt).request_id := l_request_id;
2194: til_tbl(l_til_cnt).program_application_id := l_program_application_id;

Line 2191: til_tbl(l_til_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2187: til_tbl(l_til_cnt).CREATION_DATE := SYSDATE;
2188: til_tbl(l_til_cnt).CREATED_BY := Fnd_Global.USER_ID;
2189: til_tbl(l_til_cnt).LAST_UPDATE_DATE := SYSDATE;
2190: til_tbl(l_til_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2191: til_tbl(l_til_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2192:
2193: til_tbl(l_til_cnt).request_id := l_request_id;
2194: til_tbl(l_til_cnt).program_application_id := l_program_application_id;
2195: til_tbl(l_til_cnt).program_id := l_program_id;

Line 2210: tiltl_tbl(l_tiltl_cnt).CREATED_BY := Fnd_Global.USER_ID;

2206: tiltl_tbl(l_tiltl_cnt).SFWT_FLAG := 'N';
2207: tiltl_tbl(l_tiltl_cnt).DESCRIPTION := l_def_desc;
2208:
2209: tiltl_tbl(l_tiltl_cnt).CREATION_DATE := SYSDATE;
2210: tiltl_tbl(l_tiltl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2211: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_DATE := SYSDATE;
2212: tiltl_tbl(l_tiltl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2213: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2214:

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

2208:
2209: tiltl_tbl(l_tiltl_cnt).CREATION_DATE := SYSDATE;
2210: tiltl_tbl(l_tiltl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2211: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_DATE := SYSDATE;
2212: tiltl_tbl(l_tiltl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2213: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2214:
2215: l_tiltl_cnt := l_tiltl_cnt + 1;
2216: END LOOP;

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

2209: tiltl_tbl(l_tiltl_cnt).CREATION_DATE := SYSDATE;
2210: tiltl_tbl(l_tiltl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2211: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_DATE := SYSDATE;
2212: tiltl_tbl(l_tiltl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2213: tiltl_tbl(l_tiltl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2214:
2215: l_tiltl_cnt := l_tiltl_cnt + 1;
2216: END LOOP;
2217:

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

2276: --cklee: start 3/16/07
2277: tld_tbl(l_tld_cnt).ID := l_tld_id;
2278: tld_tbl(l_tld_cnt).OBJECT_VERSION_NUMBER := 1;
2279: tld_tbl(l_tld_cnt).CREATION_DATE := SYSDATE;
2280: tld_tbl(l_tld_cnt).CREATED_BY := Fnd_Global.USER_ID;
2281: tld_tbl(l_tld_cnt).LAST_UPDATE_DATE := SYSDATE;
2282: tld_tbl(l_tld_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2283: tld_tbl(l_tld_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2284:

Line 2282: tld_tbl(l_tld_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;

2278: tld_tbl(l_tld_cnt).OBJECT_VERSION_NUMBER := 1;
2279: tld_tbl(l_tld_cnt).CREATION_DATE := SYSDATE;
2280: tld_tbl(l_tld_cnt).CREATED_BY := Fnd_Global.USER_ID;
2281: tld_tbl(l_tld_cnt).LAST_UPDATE_DATE := SYSDATE;
2282: tld_tbl(l_tld_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2283: tld_tbl(l_tld_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2284:
2285: tld_tbl(l_tld_cnt).request_id := l_request_id;
2286: tld_tbl(l_tld_cnt).program_application_id := l_program_application_id;

Line 2283: tld_tbl(l_tld_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2279: tld_tbl(l_tld_cnt).CREATION_DATE := SYSDATE;
2280: tld_tbl(l_tld_cnt).CREATED_BY := Fnd_Global.USER_ID;
2281: tld_tbl(l_tld_cnt).LAST_UPDATE_DATE := SYSDATE;
2282: tld_tbl(l_tld_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2283: tld_tbl(l_tld_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2284:
2285: tld_tbl(l_tld_cnt).request_id := l_request_id;
2286: tld_tbl(l_tld_cnt).program_application_id := l_program_application_id;
2287: tld_tbl(l_tld_cnt).program_id := l_program_id;

Line 2304: tldtl_tbl(l_tldtl_cnt).CREATED_BY := Fnd_Global.USER_ID;

2300: tldtl_tbl(l_tldtl_cnt).SFWT_FLAG := 'N';
2301: tldtl_tbl(l_tldtl_cnt).DESCRIPTION := p_bill_tbl(k).sty_name;
2302:
2303: tldtl_tbl(l_tldtl_cnt).CREATION_DATE := SYSDATE;
2304: tldtl_tbl(l_tldtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2305: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2306: tldtl_tbl(l_tldtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2307: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2308:

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

2302:
2303: tldtl_tbl(l_tldtl_cnt).CREATION_DATE := SYSDATE;
2304: tldtl_tbl(l_tldtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2305: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2306: tldtl_tbl(l_tldtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2307: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2308:
2309: l_tldtl_cnt := l_tldtl_cnt + 1;
2310: END LOOP;

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

2303: tldtl_tbl(l_tldtl_cnt).CREATION_DATE := SYSDATE;
2304: tldtl_tbl(l_tldtl_cnt).CREATED_BY := Fnd_Global.USER_ID;
2305: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_DATE := SYSDATE;
2306: tldtl_tbl(l_tldtl_cnt).LAST_UPDATED_BY := Fnd_Global.USER_ID;
2307: tldtl_tbl(l_tldtl_cnt).LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2308:
2309: l_tldtl_cnt := l_tldtl_cnt + 1;
2310: END LOOP;
2311:

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

3792: --Bug 7584183-Added by kkorrapo
3793: l_request_id NUMBER := -1;
3794: CURSOR req_id_csr IS
3795: SELECT
3796: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
3797: FROM dual;
3798: --Bug 7584183-Addition end
3799:
3800: BEGIN