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

Line 89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;

85: l_khr_id number;
86: l_next_bill_date date;
87:
88: -- Org Id and standard who columns
89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
93:

Line 90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;

86: l_next_bill_date date;
87:
88: -- Org Id and standard who columns
89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
93:
94: begin

Line 91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;

87:
88: -- Org Id and standard who columns
89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
93:
94: begin
95:

Line 92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

88: -- Org Id and standard who columns
89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
93:
94: begin
95:
96: if p_khr_id is null then

Line 173: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;

169: l_prep_cnt NUMBER;
170:
171: -- Bug 4546873
172: -- Org Id and standard who columns
173: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
174: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
175: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
176: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
177: l_org_id okl_parallel_processes.org_id%type;

Line 174: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;

170:
171: -- Bug 4546873
172: -- Org Id and standard who columns
173: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
174: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
175: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
176: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
177: l_org_id okl_parallel_processes.org_id%type;
178: -- End Bug 4546873

Line 175: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;

171: -- Bug 4546873
172: -- Org Id and standard who columns
173: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
174: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
175: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
176: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
177: l_org_id okl_parallel_processes.org_id%type;
178: -- End Bug 4546873
179:

Line 176: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

172: -- Org Id and standard who columns
173: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
174: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
175: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
176: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
177: l_org_id okl_parallel_processes.org_id%type;
178: -- End Bug 4546873
179:
180: -- Print variables

Line 1156: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;

1152: l_req_counter NUMBER;
1153:
1154: -- Bug 4546873
1155: -- Org Id and standard who columns
1156: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
1157: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1158: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1159: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1160: l_org_id okl_parallel_processes.org_id%type;

Line 1157: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;

1153:
1154: -- Bug 4546873
1155: -- Org Id and standard who columns
1156: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
1157: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1158: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1159: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1160: l_org_id okl_parallel_processes.org_id%type;
1161:

Line 1158: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;

1154: -- Bug 4546873
1155: -- Org Id and standard who columns
1156: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
1157: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1158: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1159: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1160: l_org_id okl_parallel_processes.org_id%type;
1161:
1162: --

Line 1159: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

1155: -- Org Id and standard who columns
1156: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
1157: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1158: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1159: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1160: l_org_id okl_parallel_processes.org_id%type;
1161:
1162: --
1163: cursor parent_sts_csr(p_request_id NUMBER) IS

Line 2155: g_cnr_tbl(g_header_counter).created_by := Fnd_Global.USER_ID;

2151:
2152: -- DB generated sequence number for the Consolidated Invoice
2153: PRINT_TO_LOG( '====> Generating Cons Bill SEQUENCE');
2154: g_cnr_tbl(g_header_counter).creation_date := SYSDATE;
2155: g_cnr_tbl(g_header_counter).created_by := Fnd_Global.USER_ID;
2156: g_cnr_tbl(g_header_counter).last_update_date := SYSDATE;
2157: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2158: g_cnr_tbl(g_header_counter).object_version_number := 1;
2159: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;

Line 2157: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;

2153: PRINT_TO_LOG( '====> Generating Cons Bill SEQUENCE');
2154: g_cnr_tbl(g_header_counter).creation_date := SYSDATE;
2155: g_cnr_tbl(g_header_counter).created_by := Fnd_Global.USER_ID;
2156: g_cnr_tbl(g_header_counter).last_update_date := SYSDATE;
2157: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2158: g_cnr_tbl(g_header_counter).object_version_number := 1;
2159: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2160: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2161: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;

Line 2159: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;

2155: g_cnr_tbl(g_header_counter).created_by := Fnd_Global.USER_ID;
2156: g_cnr_tbl(g_header_counter).last_update_date := SYSDATE;
2157: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2158: g_cnr_tbl(g_header_counter).object_version_number := 1;
2159: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2160: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2161: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2162: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2163: g_cnr_tbl(g_header_counter).program_update_date := SYSDATE;

Line 2160: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;

2156: g_cnr_tbl(g_header_counter).last_update_date := SYSDATE;
2157: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2158: g_cnr_tbl(g_header_counter).object_version_number := 1;
2159: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2160: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2161: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2162: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2163: g_cnr_tbl(g_header_counter).program_update_date := SYSDATE;
2164: end if;

Line 2161: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;

2157: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2158: g_cnr_tbl(g_header_counter).object_version_number := 1;
2159: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2160: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2161: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2162: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2163: g_cnr_tbl(g_header_counter).program_update_date := SYSDATE;
2164: end if;
2165:

Line 2162: if Fnd_Global.CONC_REQUEST_ID <> -1 then

2158: g_cnr_tbl(g_header_counter).object_version_number := 1;
2159: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2160: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2161: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2162: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2163: g_cnr_tbl(g_header_counter).program_update_date := SYSDATE;
2164: end if;
2165:
2166: PRINT_TO_LOG( '====> Cons Bill Number: '||g_cnr_tbl(g_header_counter).consolidated_invoice_number);

Line 2372: g_lln_tbl(g_line_counter).created_by := Fnd_Global.USER_ID;

2368: g_lln_tbl(g_line_counter).cnr_id := p_cnr_id;
2369: g_lln_tbl(g_line_counter).ilt_id := p_ilt_id;
2370: g_lln_tbl(g_line_counter).line_type := SUBSTR(p_line_type,1,50);
2371: g_lln_tbl(g_line_counter).creation_date := SYSDATE;
2372: g_lln_tbl(g_line_counter).created_by := Fnd_Global.USER_ID;
2373: g_lln_tbl(g_line_counter).last_update_date := SYSDATE;
2374: g_lln_tbl(g_line_counter).last_updated_by := Fnd_Global.USER_ID;
2375: g_lln_tbl(g_line_counter).object_version_number := 1;
2376: g_lln_tbl(g_line_counter).request_id := Fnd_Global.CONC_REQUEST_ID;

Line 2374: g_lln_tbl(g_line_counter).last_updated_by := Fnd_Global.USER_ID;

2370: g_lln_tbl(g_line_counter).line_type := SUBSTR(p_line_type,1,50);
2371: g_lln_tbl(g_line_counter).creation_date := SYSDATE;
2372: g_lln_tbl(g_line_counter).created_by := Fnd_Global.USER_ID;
2373: g_lln_tbl(g_line_counter).last_update_date := SYSDATE;
2374: g_lln_tbl(g_line_counter).last_updated_by := Fnd_Global.USER_ID;
2375: g_lln_tbl(g_line_counter).object_version_number := 1;
2376: g_lln_tbl(g_line_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2377: g_lln_tbl(g_line_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2378:

Line 2376: g_lln_tbl(g_line_counter).request_id := Fnd_Global.CONC_REQUEST_ID;

2372: g_lln_tbl(g_line_counter).created_by := Fnd_Global.USER_ID;
2373: g_lln_tbl(g_line_counter).last_update_date := SYSDATE;
2374: g_lln_tbl(g_line_counter).last_updated_by := Fnd_Global.USER_ID;
2375: g_lln_tbl(g_line_counter).object_version_number := 1;
2376: g_lln_tbl(g_line_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2377: g_lln_tbl(g_line_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2378:
2379: -- stmathew added on 07/20/2005
2380: g_lln_tbl(g_line_counter).amount := 0;

Line 2377: g_lln_tbl(g_line_counter).program_application_id := Fnd_Global.PROG_APPL_ID;

2373: g_lln_tbl(g_line_counter).last_update_date := SYSDATE;
2374: g_lln_tbl(g_line_counter).last_updated_by := Fnd_Global.USER_ID;
2375: g_lln_tbl(g_line_counter).object_version_number := 1;
2376: g_lln_tbl(g_line_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2377: g_lln_tbl(g_line_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2378:
2379: -- stmathew added on 07/20/2005
2380: g_lln_tbl(g_line_counter).amount := 0;
2381: -- end

Line 2383: g_lln_tbl(g_line_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;

2379: -- stmathew added on 07/20/2005
2380: g_lln_tbl(g_line_counter).amount := 0;
2381: -- end
2382:
2383: g_lln_tbl(g_line_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2384: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2385: g_lln_tbl(g_line_counter).program_update_date := SYSDATE;
2386: end if;
2387:

Line 2384: if Fnd_Global.CONC_REQUEST_ID <> -1 then

2380: g_lln_tbl(g_line_counter).amount := 0;
2381: -- end
2382:
2383: g_lln_tbl(g_line_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2384: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2385: g_lln_tbl(g_line_counter).program_update_date := SYSDATE;
2386: end if;
2387:
2388: PRINT_TO_LOG( '*** LINE RECORD CREATION FOR : ***');

Line 2546: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;

2542: g_cnr_tl_tbl(tl_count).id := g_cnr_tbl(z).id;
2543: g_cnr_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
2544: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
2545: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
2546: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
2547: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
2548: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2549: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
2550: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

Line 2548: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;

2544: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
2545: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
2546: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
2547: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
2548: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2549: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
2550: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2551: tl_count := tl_count + 1;
2552: END LOOP; -- languages loop

Line 2550: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

2546: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
2547: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
2548: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2549: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
2550: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2551: tl_count := tl_count + 1;
2552: END LOOP; -- languages loop
2553:
2554: -- invoice messaging processing

Line 2719: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;

2715: g_lln_tl_tbl(tl_count).id := g_lln_tbl(x).id;
2716: g_lln_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
2717: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
2718: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
2719: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
2720: g_lln_tl_tbl(tl_count).creation_date := sysdate;
2721: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2722: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
2723: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

Line 2721: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;

2717: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
2718: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
2719: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
2720: g_lln_tl_tbl(tl_count).creation_date := sysdate;
2721: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2722: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
2723: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2724: tl_count := tl_count + 1;
2725: END LOOP; -- languages loop

Line 2723: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

2719: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
2720: g_lln_tl_tbl(tl_count).creation_date := sysdate;
2721: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2722: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
2723: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2724: tl_count := tl_count + 1;
2725: END LOOP; -- languages loop
2726: end loop;
2727:

Line 2805: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;

2801: g_lsm_tl_tbl(tl_count).id := g_lsm_tbl(y).id;
2802: g_lsm_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
2803: g_lsm_tl_tbl(tl_count).source_lang := USERENV('LANG');
2804: g_lsm_tl_tbl(tl_count).sfwt_flag := 'N';
2805: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
2806: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
2807: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2808: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
2809: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

Line 2807: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;

2803: g_lsm_tl_tbl(tl_count).source_lang := USERENV('LANG');
2804: g_lsm_tl_tbl(tl_count).sfwt_flag := 'N';
2805: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
2806: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
2807: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2808: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
2809: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2810: tl_count := tl_count + 1;
2811: END LOOP; -- languages loop

Line 2809: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

2805: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
2806: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
2807: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2808: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
2809: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2810: tl_count := tl_count + 1;
2811: END LOOP; -- languages loop
2812: end loop;
2813:

Line 2923: g_lsm_tbl(g_stream_counter).created_by := Fnd_Global.USER_ID;

2919: g_lsm_tbl(g_stream_counter).AMOUNT := p_amount;
2920: g_lsm_tbl(g_stream_counter).SEL_ID := p_sel_id;
2921: g_lsm_tbl(g_stream_counter).receivables_invoice_id := -99999;
2922: g_lsm_tbl(g_stream_counter).creation_date := (SYSDATE);
2923: g_lsm_tbl(g_stream_counter).created_by := Fnd_Global.USER_ID;
2924: g_lsm_tbl(g_stream_counter).last_update_date := (SYSDATE);
2925: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2926: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2927: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;

Line 2925: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;

2921: g_lsm_tbl(g_stream_counter).receivables_invoice_id := -99999;
2922: g_lsm_tbl(g_stream_counter).creation_date := (SYSDATE);
2923: g_lsm_tbl(g_stream_counter).created_by := Fnd_Global.USER_ID;
2924: g_lsm_tbl(g_stream_counter).last_update_date := (SYSDATE);
2925: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2926: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2927: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2928: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2929: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;

Line 2927: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;

2923: g_lsm_tbl(g_stream_counter).created_by := Fnd_Global.USER_ID;
2924: g_lsm_tbl(g_stream_counter).last_update_date := (SYSDATE);
2925: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2926: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2927: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2928: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2929: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2930: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2931: g_lsm_tbl(g_stream_counter).program_update_date := (SYSDATE);

Line 2928: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;

2924: g_lsm_tbl(g_stream_counter).last_update_date := (SYSDATE);
2925: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2926: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2927: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2928: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2929: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2930: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2931: g_lsm_tbl(g_stream_counter).program_update_date := (SYSDATE);
2932: end if;

Line 2929: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;

2925: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2926: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2927: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2928: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2929: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2930: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2931: g_lsm_tbl(g_stream_counter).program_update_date := (SYSDATE);
2932: end if;
2933: PRINT_TO_LOG( '*** STREAM RECORD CREATION FOR : ***');

Line 2930: if Fnd_Global.CONC_REQUEST_ID <> -1 then

2926: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2927: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2928: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2929: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2930: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2931: g_lsm_tbl(g_stream_counter).program_update_date := (SYSDATE);
2932: end if;
2933: PRINT_TO_LOG( '*** STREAM RECORD CREATION FOR : ***');
2934: PRINT_TO_LOG( '*** ++++++++++++++++++++++++++++ ***');

Line 2982: last_updated_by = fnd_global.user_id,

2978: update okl_ext_sell_invs_b
2979: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
2980: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
2981: last_update_date = sysdate,
2982: last_updated_by = fnd_global.user_id,
2983: last_update_login = fnd_global.login_id
2984: where id = g_xsi_tbl(indx).id;
2985: end loop;
2986: EXCEPTION

Line 2983: last_update_login = fnd_global.login_id

2979: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
2980: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
2981: last_update_date = sysdate,
2982: last_updated_by = fnd_global.user_id,
2983: last_update_login = fnd_global.login_id
2984: where id = g_xsi_tbl(indx).id;
2985: end loop;
2986: EXCEPTION
2987: WHEN OTHERS THEN

Line 3007: last_updated_by = fnd_global.user_id,

3003: update okl_xtl_sell_invs_b
3004: set lsm_id = g_xls_tbl(s).lsm_id,
3005: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
3006: last_update_date = sysdate,
3007: last_updated_by = fnd_global.user_id,
3008: last_update_login = fnd_global.login_id
3009: where id = g_xls_tbl(s).id;
3010: end loop;
3011: EXCEPTION

Line 3008: last_update_login = fnd_global.login_id

3004: set lsm_id = g_xls_tbl(s).lsm_id,
3005: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
3006: last_update_date = sysdate,
3007: last_updated_by = fnd_global.user_id,
3008: last_update_login = fnd_global.login_id
3009: where id = g_xls_tbl(s).id;
3010: end loop;
3011: EXCEPTION
3012: WHEN OTHERS THEN

Line 3033: last_updated_by = fnd_global.user_id,

3029: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
3030: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
3031: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
3032: last_update_date = sysdate,
3033: last_updated_by = fnd_global.user_id,
3034: last_update_login = fnd_global.login_id
3035: where id = g_xsi_tl_tbl(u).id;
3036: end loop;
3037: EXCEPTION

Line 3034: last_update_login = fnd_global.login_id

3030: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
3031: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
3032: last_update_date = sysdate,
3033: last_updated_by = fnd_global.user_id,
3034: last_update_login = fnd_global.login_id
3035: where id = g_xsi_tl_tbl(u).id;
3036: end loop;
3037: EXCEPTION
3038: WHEN OTHERS THEN

Line 3061: last_updated_by = fnd_global.user_id,

3057: xtrx_asset = g_xls_tl_tbl(t).xtrx_asset,
3058: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
3059: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
3060: last_update_date = sysdate,
3061: last_updated_by = fnd_global.user_id,
3062: last_update_login = fnd_global.login_id
3063: where id = g_xls_tl_tbl(t).id;
3064: end loop;
3065: EXCEPTION

Line 3062: last_update_login = fnd_global.login_id

3058: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
3059: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
3060: last_update_date = sysdate,
3061: last_updated_by = fnd_global.user_id,
3062: last_update_login = fnd_global.login_id
3063: where id = g_xls_tl_tbl(t).id;
3064: end loop;
3065: EXCEPTION
3066: WHEN OTHERS THEN

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

4139: l_request_id NUMBER;
4140:
4141: CURSOR req_id_csr IS
4142: SELECT
4143: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
4144: FROM dual;
4145:
4146: ------------------------------------------------------------
4147: -- Operating Unit

Line 4306: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;

4302: g_cnr_tl_tbl(tl_count).id := g_cnr_tbl(z).id;
4303: g_cnr_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4304: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
4305: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
4306: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4307: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4308: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4309: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4310: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

Line 4308: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;

4304: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
4305: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
4306: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4307: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4308: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4309: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4310: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4311: tl_count := tl_count + 1;
4312: END LOOP; -- languages loop

Line 4310: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

4306: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4307: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4308: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4309: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4310: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4311: tl_count := tl_count + 1;
4312: END LOOP; -- languages loop
4313: -- invoice messaging processing
4314: if g_inv_msg = 'TRUE' then

Line 4451: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;

4447: g_lln_tl_tbl(tl_count).id := g_lln_tbl(x).id;
4448: g_lln_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4449: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
4450: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
4451: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4452: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4453: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4454: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4455: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

Line 4453: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;

4449: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
4450: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
4451: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4452: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4453: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4454: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4455: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4456: tl_count := tl_count + 1;
4457: END LOOP; -- languages loop

Line 4455: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

4451: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4452: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4453: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4454: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4455: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4456: tl_count := tl_count + 1;
4457: END LOOP; -- languages loop
4458: end loop;
4459:

Line 4514: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;

4510: g_lsm_tl_tbl(tl_count).id := g_lsm_tbl(y).id;
4511: g_lsm_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4512: g_lsm_tl_tbl(tl_count).source_lang := USERENV('LANG');
4513: g_lsm_tl_tbl(tl_count).sfwt_flag := 'N';
4514: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
4515: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
4516: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4517: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
4518: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

Line 4516: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;

4512: g_lsm_tl_tbl(tl_count).source_lang := USERENV('LANG');
4513: g_lsm_tl_tbl(tl_count).sfwt_flag := 'N';
4514: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
4515: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
4516: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4517: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
4518: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4519: tl_count := tl_count + 1;
4520: END LOOP; -- languages loop

Line 4518: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

4514: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
4515: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
4516: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4517: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
4518: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4519: tl_count := tl_count + 1;
4520: END LOOP; -- languages loop
4521: end loop;
4522:

Line 4619: last_updated_by = fnd_global.user_id,

4615: update okl_ext_sell_invs_b
4616: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
4617: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
4618: last_update_date = sysdate,
4619: last_updated_by = fnd_global.user_id,
4620: last_update_login = fnd_global.login_id
4621: where id = g_xsi_tbl(indx).id;
4622: end loop;
4623: commit;

Line 4620: last_update_login = fnd_global.login_id

4616: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
4617: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
4618: last_update_date = sysdate,
4619: last_updated_by = fnd_global.user_id,
4620: last_update_login = fnd_global.login_id
4621: where id = g_xsi_tbl(indx).id;
4622: end loop;
4623: commit;
4624: -- flush table

Line 4645: last_updated_by = fnd_global.user_id,

4641: update okl_xtl_sell_invs_b
4642: set lsm_id = g_xls_tbl(s).lsm_id,
4643: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
4644: last_update_date = sysdate,
4645: last_updated_by = fnd_global.user_id,
4646: last_update_login = fnd_global.login_id
4647: where id = g_xls_tbl(s).id;
4648: end loop;
4649: commit;

Line 4646: last_update_login = fnd_global.login_id

4642: set lsm_id = g_xls_tbl(s).lsm_id,
4643: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
4644: last_update_date = sysdate,
4645: last_updated_by = fnd_global.user_id,
4646: last_update_login = fnd_global.login_id
4647: where id = g_xls_tbl(s).id;
4648: end loop;
4649: commit;
4650: -- flush table

Line 4672: last_updated_by = fnd_global.user_id,

4668: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
4669: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
4670: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
4671: last_update_date = sysdate,
4672: last_updated_by = fnd_global.user_id,
4673: last_update_login = fnd_global.login_id
4674: where id = g_xsi_tl_tbl(u).id;
4675: end loop;
4676: commit;

Line 4673: last_update_login = fnd_global.login_id

4669: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
4670: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
4671: last_update_date = sysdate,
4672: last_updated_by = fnd_global.user_id,
4673: last_update_login = fnd_global.login_id
4674: where id = g_xsi_tl_tbl(u).id;
4675: end loop;
4676: commit;
4677: -- flush table

Line 4700: last_updated_by = fnd_global.user_id,

4696: xtrx_asset = g_xls_tl_tbl(t).xtrx_asset,
4697: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
4698: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
4699: last_update_date = sysdate,
4700: last_updated_by = fnd_global.user_id,
4701: last_update_login = fnd_global.login_id
4702: where id = g_xls_tl_tbl(t).id;
4703: end loop;
4704: commit;

Line 4701: last_update_login = fnd_global.login_id

4697: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
4698: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
4699: last_update_date = sysdate,
4700: last_updated_by = fnd_global.user_id,
4701: last_update_login = fnd_global.login_id
4702: where id = g_xls_tl_tbl(t).id;
4703: end loop;
4704: commit;
4705: -- flush table

Line 4815: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;

4811: g_cnr_tl_tbl(tl_count).id := g_cnr_tbl(z).id;
4812: g_cnr_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4813: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
4814: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
4815: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4816: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4817: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4818: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4819: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

Line 4817: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;

4813: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
4814: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
4815: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4816: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4817: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4818: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4819: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4820: tl_count := tl_count + 1;
4821: END LOOP; -- languages code

Line 4819: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

4815: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4816: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4817: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4818: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4819: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4820: tl_count := tl_count + 1;
4821: END LOOP; -- languages code
4822: -- invoice messaging processing
4823: if g_inv_msg = 'TRUE' then

Line 4958: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;

4954: g_lln_tl_tbl(tl_count).id := g_lln_tbl(x).id;
4955: g_lln_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4956: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
4957: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
4958: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4959: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4960: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4961: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4962: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

Line 4960: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;

4956: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
4957: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
4958: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4959: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4960: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4961: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4962: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4963: tl_count := tl_count + 1;
4964: END LOOP; -- languages loop

Line 4962: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

4958: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4959: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4960: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4961: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4962: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4963: tl_count := tl_count + 1;
4964: END LOOP; -- languages loop
4965: end loop;
4966:

Line 5020: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;

5016: g_lsm_tl_tbl(tl_count).id := g_lsm_tbl(y).id;
5017: g_lsm_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
5018: g_lsm_tl_tbl(tl_count).source_lang := USERENV('LANG');
5019: g_lsm_tl_tbl(tl_count).sfwt_flag := 'N';
5020: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
5021: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
5022: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
5023: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
5024: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

Line 5022: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;

5018: g_lsm_tl_tbl(tl_count).source_lang := USERENV('LANG');
5019: g_lsm_tl_tbl(tl_count).sfwt_flag := 'N';
5020: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
5021: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
5022: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
5023: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
5024: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
5025: tl_count := tl_count + 1;
5026: END LOOP; -- languages loop

Line 5024: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

5020: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
5021: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
5022: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
5023: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
5024: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
5025: tl_count := tl_count + 1;
5026: END LOOP; -- languages loop
5027: end loop;
5028:

Line 5123: last_updated_by = fnd_global.user_id,

5119: update okl_ext_sell_invs_b
5120: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
5121: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
5122: last_update_date = sysdate,
5123: last_updated_by = fnd_global.user_id,
5124: last_update_login = fnd_global.login_id
5125: where id = g_xsi_tbl(indx).id;
5126: end loop;
5127: commit;

Line 5124: last_update_login = fnd_global.login_id

5120: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
5121: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
5122: last_update_date = sysdate,
5123: last_updated_by = fnd_global.user_id,
5124: last_update_login = fnd_global.login_id
5125: where id = g_xsi_tbl(indx).id;
5126: end loop;
5127: commit;
5128: -- flush table

Line 5150: last_updated_by = fnd_global.user_id,

5146: update okl_xtl_sell_invs_b
5147: set lsm_id = g_xls_tbl(s).lsm_id,
5148: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
5149: last_update_date = sysdate,
5150: last_updated_by = fnd_global.user_id,
5151: last_update_login = fnd_global.login_id
5152: where id = g_xls_tbl(s).id;
5153: end loop;
5154: commit;

Line 5151: last_update_login = fnd_global.login_id

5147: set lsm_id = g_xls_tbl(s).lsm_id,
5148: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
5149: last_update_date = sysdate,
5150: last_updated_by = fnd_global.user_id,
5151: last_update_login = fnd_global.login_id
5152: where id = g_xls_tbl(s).id;
5153: end loop;
5154: commit;
5155: -- flush table

Line 5177: last_updated_by = fnd_global.user_id,

5173: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
5174: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
5175: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
5176: last_update_date = sysdate,
5177: last_updated_by = fnd_global.user_id,
5178: last_update_login = fnd_global.login_id
5179: where id = g_xsi_tl_tbl(u).id;
5180: end loop;
5181: commit;

Line 5178: last_update_login = fnd_global.login_id

5174: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
5175: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
5176: last_update_date = sysdate,
5177: last_updated_by = fnd_global.user_id,
5178: last_update_login = fnd_global.login_id
5179: where id = g_xsi_tl_tbl(u).id;
5180: end loop;
5181: commit;
5182: -- flush table

Line 5205: last_updated_by = fnd_global.user_id,

5201: xtrx_asset = g_xls_tl_tbl(t).xtrx_asset,
5202: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
5203: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
5204: last_update_date = sysdate,
5205: last_updated_by = fnd_global.user_id,
5206: last_update_login = fnd_global.login_id
5207: where id = g_xls_tl_tbl(t).id;
5208: end loop;
5209: commit;

Line 5206: last_update_login = fnd_global.login_id

5202: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
5203: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
5204: last_update_date = sysdate,
5205: last_updated_by = fnd_global.user_id,
5206: last_update_login = fnd_global.login_id
5207: where id = g_xls_tl_tbl(t).id;
5208: end loop;
5209: commit;
5210: -- flush table