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 1119: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;

1115: l_req_counter NUMBER;
1116:
1117: -- Bug 4546873
1118: -- Org Id and standard who columns
1119: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
1120: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1121: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1122: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1123: l_org_id okl_parallel_processes.org_id%type;

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

1116:
1117: -- Bug 4546873
1118: -- Org Id and standard who columns
1119: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
1120: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1121: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1122: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1123: l_org_id okl_parallel_processes.org_id%type;
1124:

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

1117: -- Bug 4546873
1118: -- Org Id and standard who columns
1119: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
1120: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1121: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1122: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1123: l_org_id okl_parallel_processes.org_id%type;
1124:
1125: --

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

1118: -- Org Id and standard who columns
1119: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
1120: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1121: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1122: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1123: l_org_id okl_parallel_processes.org_id%type;
1124:
1125: --
1126: cursor parent_sts_csr(p_request_id NUMBER) IS

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

2087:
2088: -- DB generated sequence number for the Consolidated Invoice
2089: PRINT_TO_LOG( '====> Generating Cons Bill SEQUENCE');
2090: g_cnr_tbl(g_header_counter).creation_date := SYSDATE;
2091: g_cnr_tbl(g_header_counter).created_by := Fnd_Global.USER_ID;
2092: g_cnr_tbl(g_header_counter).last_update_date := SYSDATE;
2093: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2094: g_cnr_tbl(g_header_counter).object_version_number := 1;
2095: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;

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

2089: PRINT_TO_LOG( '====> Generating Cons Bill SEQUENCE');
2090: g_cnr_tbl(g_header_counter).creation_date := SYSDATE;
2091: g_cnr_tbl(g_header_counter).created_by := Fnd_Global.USER_ID;
2092: g_cnr_tbl(g_header_counter).last_update_date := SYSDATE;
2093: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2094: g_cnr_tbl(g_header_counter).object_version_number := 1;
2095: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2096: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2097: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;

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

2091: g_cnr_tbl(g_header_counter).created_by := Fnd_Global.USER_ID;
2092: g_cnr_tbl(g_header_counter).last_update_date := SYSDATE;
2093: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2094: g_cnr_tbl(g_header_counter).object_version_number := 1;
2095: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2096: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2097: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2098: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2099: g_cnr_tbl(g_header_counter).program_update_date := SYSDATE;

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

2092: g_cnr_tbl(g_header_counter).last_update_date := SYSDATE;
2093: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2094: g_cnr_tbl(g_header_counter).object_version_number := 1;
2095: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2096: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2097: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2098: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2099: g_cnr_tbl(g_header_counter).program_update_date := SYSDATE;
2100: end if;

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

2093: g_cnr_tbl(g_header_counter).last_updated_by := Fnd_Global.USER_ID;
2094: g_cnr_tbl(g_header_counter).object_version_number := 1;
2095: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2096: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2097: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2098: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2099: g_cnr_tbl(g_header_counter).program_update_date := SYSDATE;
2100: end if;
2101:

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

2094: g_cnr_tbl(g_header_counter).object_version_number := 1;
2095: g_cnr_tbl(g_header_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2096: g_cnr_tbl(g_header_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2097: g_cnr_tbl(g_header_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2098: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2099: g_cnr_tbl(g_header_counter).program_update_date := SYSDATE;
2100: end if;
2101:
2102: PRINT_TO_LOG( '====> Cons Bill Number: '||g_cnr_tbl(g_header_counter).consolidated_invoice_number);

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

2304: g_lln_tbl(g_line_counter).cnr_id := p_cnr_id;
2305: g_lln_tbl(g_line_counter).ilt_id := p_ilt_id;
2306: g_lln_tbl(g_line_counter).line_type := SUBSTR(p_line_type,1,50);
2307: g_lln_tbl(g_line_counter).creation_date := SYSDATE;
2308: g_lln_tbl(g_line_counter).created_by := Fnd_Global.USER_ID;
2309: g_lln_tbl(g_line_counter).last_update_date := SYSDATE;
2310: g_lln_tbl(g_line_counter).last_updated_by := Fnd_Global.USER_ID;
2311: g_lln_tbl(g_line_counter).object_version_number := 1;
2312: g_lln_tbl(g_line_counter).request_id := Fnd_Global.CONC_REQUEST_ID;

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

2306: g_lln_tbl(g_line_counter).line_type := SUBSTR(p_line_type,1,50);
2307: g_lln_tbl(g_line_counter).creation_date := SYSDATE;
2308: g_lln_tbl(g_line_counter).created_by := Fnd_Global.USER_ID;
2309: g_lln_tbl(g_line_counter).last_update_date := SYSDATE;
2310: g_lln_tbl(g_line_counter).last_updated_by := Fnd_Global.USER_ID;
2311: g_lln_tbl(g_line_counter).object_version_number := 1;
2312: g_lln_tbl(g_line_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2313: g_lln_tbl(g_line_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2314:

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

2308: g_lln_tbl(g_line_counter).created_by := Fnd_Global.USER_ID;
2309: g_lln_tbl(g_line_counter).last_update_date := SYSDATE;
2310: g_lln_tbl(g_line_counter).last_updated_by := Fnd_Global.USER_ID;
2311: g_lln_tbl(g_line_counter).object_version_number := 1;
2312: g_lln_tbl(g_line_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2313: g_lln_tbl(g_line_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2314:
2315: -- stmathew added on 07/20/2005
2316: g_lln_tbl(g_line_counter).amount := 0;

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

2309: g_lln_tbl(g_line_counter).last_update_date := SYSDATE;
2310: g_lln_tbl(g_line_counter).last_updated_by := Fnd_Global.USER_ID;
2311: g_lln_tbl(g_line_counter).object_version_number := 1;
2312: g_lln_tbl(g_line_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2313: g_lln_tbl(g_line_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2314:
2315: -- stmathew added on 07/20/2005
2316: g_lln_tbl(g_line_counter).amount := 0;
2317: -- end

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

2315: -- stmathew added on 07/20/2005
2316: g_lln_tbl(g_line_counter).amount := 0;
2317: -- end
2318:
2319: g_lln_tbl(g_line_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2320: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2321: g_lln_tbl(g_line_counter).program_update_date := SYSDATE;
2322: end if;
2323:

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

2316: g_lln_tbl(g_line_counter).amount := 0;
2317: -- end
2318:
2319: g_lln_tbl(g_line_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2320: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2321: g_lln_tbl(g_line_counter).program_update_date := SYSDATE;
2322: end if;
2323:
2324: PRINT_TO_LOG( '*** LINE RECORD CREATION FOR : ***');

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

2478: g_cnr_tl_tbl(tl_count).id := g_cnr_tbl(z).id;
2479: g_cnr_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
2480: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
2481: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
2482: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
2483: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
2484: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2485: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
2486: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

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

2480: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
2481: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
2482: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
2483: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
2484: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2485: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
2486: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2487: tl_count := tl_count + 1;
2488: END LOOP; -- languages loop

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

2482: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
2483: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
2484: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2485: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
2486: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2487: tl_count := tl_count + 1;
2488: END LOOP; -- languages loop
2489:
2490: -- invoice messaging processing

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

2651: g_lln_tl_tbl(tl_count).id := g_lln_tbl(x).id;
2652: g_lln_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
2653: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
2654: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
2655: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
2656: g_lln_tl_tbl(tl_count).creation_date := sysdate;
2657: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2658: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
2659: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

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

2653: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
2654: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
2655: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
2656: g_lln_tl_tbl(tl_count).creation_date := sysdate;
2657: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2658: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
2659: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2660: tl_count := tl_count + 1;
2661: END LOOP; -- languages loop

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

2655: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
2656: g_lln_tl_tbl(tl_count).creation_date := sysdate;
2657: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2658: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
2659: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2660: tl_count := tl_count + 1;
2661: END LOOP; -- languages loop
2662: end loop;
2663:

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

2737: g_lsm_tl_tbl(tl_count).id := g_lsm_tbl(y).id;
2738: g_lsm_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
2739: g_lsm_tl_tbl(tl_count).source_lang := USERENV('LANG');
2740: g_lsm_tl_tbl(tl_count).sfwt_flag := 'N';
2741: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
2742: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
2743: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2744: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
2745: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

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

2739: g_lsm_tl_tbl(tl_count).source_lang := USERENV('LANG');
2740: g_lsm_tl_tbl(tl_count).sfwt_flag := 'N';
2741: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
2742: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
2743: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2744: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
2745: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2746: tl_count := tl_count + 1;
2747: END LOOP; -- languages loop

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

2741: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
2742: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
2743: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
2744: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
2745: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
2746: tl_count := tl_count + 1;
2747: END LOOP; -- languages loop
2748: end loop;
2749:

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

2855: g_lsm_tbl(g_stream_counter).AMOUNT := p_amount;
2856: g_lsm_tbl(g_stream_counter).SEL_ID := p_sel_id;
2857: g_lsm_tbl(g_stream_counter).receivables_invoice_id := -99999;
2858: g_lsm_tbl(g_stream_counter).creation_date := (SYSDATE);
2859: g_lsm_tbl(g_stream_counter).created_by := Fnd_Global.USER_ID;
2860: g_lsm_tbl(g_stream_counter).last_update_date := (SYSDATE);
2861: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2862: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2863: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;

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

2857: g_lsm_tbl(g_stream_counter).receivables_invoice_id := -99999;
2858: g_lsm_tbl(g_stream_counter).creation_date := (SYSDATE);
2859: g_lsm_tbl(g_stream_counter).created_by := Fnd_Global.USER_ID;
2860: g_lsm_tbl(g_stream_counter).last_update_date := (SYSDATE);
2861: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2862: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2863: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2864: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2865: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;

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

2859: g_lsm_tbl(g_stream_counter).created_by := Fnd_Global.USER_ID;
2860: g_lsm_tbl(g_stream_counter).last_update_date := (SYSDATE);
2861: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2862: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2863: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2864: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2865: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2866: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2867: g_lsm_tbl(g_stream_counter).program_update_date := (SYSDATE);

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

2860: g_lsm_tbl(g_stream_counter).last_update_date := (SYSDATE);
2861: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2862: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2863: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2864: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2865: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2866: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2867: g_lsm_tbl(g_stream_counter).program_update_date := (SYSDATE);
2868: end if;

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

2861: g_lsm_tbl(g_stream_counter).last_updated_by := Fnd_Global.USER_ID;
2862: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2863: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2864: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2865: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2866: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2867: g_lsm_tbl(g_stream_counter).program_update_date := (SYSDATE);
2868: end if;
2869: PRINT_TO_LOG( '*** STREAM RECORD CREATION FOR : ***');

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

2862: g_lsm_tbl(g_stream_counter).object_version_number := 1;
2863: g_lsm_tbl(g_stream_counter).request_id := Fnd_Global.CONC_REQUEST_ID;
2864: g_lsm_tbl(g_stream_counter).program_application_id := Fnd_Global.PROG_APPL_ID;
2865: g_lsm_tbl(g_stream_counter).program_id := Fnd_Global.CONC_PROGRAM_ID;
2866: if Fnd_Global.CONC_REQUEST_ID <> -1 then
2867: g_lsm_tbl(g_stream_counter).program_update_date := (SYSDATE);
2868: end if;
2869: PRINT_TO_LOG( '*** STREAM RECORD CREATION FOR : ***');
2870: PRINT_TO_LOG( '*** ++++++++++++++++++++++++++++ ***');

Line 2918: last_updated_by = fnd_global.user_id,

2914: update okl_ext_sell_invs_b
2915: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
2916: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
2917: last_update_date = sysdate,
2918: last_updated_by = fnd_global.user_id,
2919: last_update_login = fnd_global.login_id
2920: where id = g_xsi_tbl(indx).id;
2921: end loop;
2922: EXCEPTION

Line 2919: last_update_login = fnd_global.login_id

2915: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
2916: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
2917: last_update_date = sysdate,
2918: last_updated_by = fnd_global.user_id,
2919: last_update_login = fnd_global.login_id
2920: where id = g_xsi_tbl(indx).id;
2921: end loop;
2922: EXCEPTION
2923: WHEN OTHERS THEN

Line 2943: last_updated_by = fnd_global.user_id,

2939: update okl_xtl_sell_invs_b
2940: set lsm_id = g_xls_tbl(s).lsm_id,
2941: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
2942: last_update_date = sysdate,
2943: last_updated_by = fnd_global.user_id,
2944: last_update_login = fnd_global.login_id
2945: where id = g_xls_tbl(s).id;
2946: end loop;
2947: EXCEPTION

Line 2944: last_update_login = fnd_global.login_id

2940: set lsm_id = g_xls_tbl(s).lsm_id,
2941: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
2942: last_update_date = sysdate,
2943: last_updated_by = fnd_global.user_id,
2944: last_update_login = fnd_global.login_id
2945: where id = g_xls_tbl(s).id;
2946: end loop;
2947: EXCEPTION
2948: WHEN OTHERS THEN

Line 2969: last_updated_by = fnd_global.user_id,

2965: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
2966: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
2967: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
2968: last_update_date = sysdate,
2969: last_updated_by = fnd_global.user_id,
2970: last_update_login = fnd_global.login_id
2971: where id = g_xsi_tl_tbl(u).id;
2972: end loop;
2973: EXCEPTION

Line 2970: last_update_login = fnd_global.login_id

2966: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
2967: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
2968: last_update_date = sysdate,
2969: last_updated_by = fnd_global.user_id,
2970: last_update_login = fnd_global.login_id
2971: where id = g_xsi_tl_tbl(u).id;
2972: end loop;
2973: EXCEPTION
2974: WHEN OTHERS THEN

Line 2997: last_updated_by = fnd_global.user_id,

2993: xtrx_asset = g_xls_tl_tbl(t).xtrx_asset,
2994: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
2995: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
2996: last_update_date = sysdate,
2997: last_updated_by = fnd_global.user_id,
2998: last_update_login = fnd_global.login_id
2999: where id = g_xls_tl_tbl(t).id;
3000: end loop;
3001: EXCEPTION

Line 2998: last_update_login = fnd_global.login_id

2994: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
2995: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
2996: last_update_date = sysdate,
2997: last_updated_by = fnd_global.user_id,
2998: last_update_login = fnd_global.login_id
2999: where id = g_xls_tl_tbl(t).id;
3000: end loop;
3001: EXCEPTION
3002: WHEN OTHERS THEN

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

4075: l_request_id NUMBER;
4076:
4077: CURSOR req_id_csr IS
4078: SELECT
4079: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
4080: FROM dual;
4081:
4082: ------------------------------------------------------------
4083: -- Operating Unit

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

4238: g_cnr_tl_tbl(tl_count).id := g_cnr_tbl(z).id;
4239: g_cnr_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4240: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
4241: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
4242: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4243: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4244: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4245: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4246: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

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

4240: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
4241: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
4242: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4243: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4244: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4245: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4246: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4247: tl_count := tl_count + 1;
4248: END LOOP; -- languages loop

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

4242: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4243: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4244: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4245: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4246: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4247: tl_count := tl_count + 1;
4248: END LOOP; -- languages loop
4249: -- invoice messaging processing
4250: if g_inv_msg = 'TRUE' then

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

4383: g_lln_tl_tbl(tl_count).id := g_lln_tbl(x).id;
4384: g_lln_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4385: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
4386: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
4387: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4388: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4389: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4390: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4391: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

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

4385: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
4386: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
4387: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4388: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4389: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4390: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4391: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4392: tl_count := tl_count + 1;
4393: END LOOP; -- languages loop

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

4387: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4388: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4389: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4390: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4391: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4392: tl_count := tl_count + 1;
4393: END LOOP; -- languages loop
4394: end loop;
4395:

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

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

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

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

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

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

Line 4555: last_updated_by = fnd_global.user_id,

4551: update okl_ext_sell_invs_b
4552: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
4553: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
4554: last_update_date = sysdate,
4555: last_updated_by = fnd_global.user_id,
4556: last_update_login = fnd_global.login_id
4557: where id = g_xsi_tbl(indx).id;
4558: end loop;
4559: commit;

Line 4556: last_update_login = fnd_global.login_id

4552: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
4553: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
4554: last_update_date = sysdate,
4555: last_updated_by = fnd_global.user_id,
4556: last_update_login = fnd_global.login_id
4557: where id = g_xsi_tbl(indx).id;
4558: end loop;
4559: commit;
4560: -- flush table

Line 4581: last_updated_by = fnd_global.user_id,

4577: update okl_xtl_sell_invs_b
4578: set lsm_id = g_xls_tbl(s).lsm_id,
4579: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
4580: last_update_date = sysdate,
4581: last_updated_by = fnd_global.user_id,
4582: last_update_login = fnd_global.login_id
4583: where id = g_xls_tbl(s).id;
4584: end loop;
4585: commit;

Line 4582: last_update_login = fnd_global.login_id

4578: set lsm_id = g_xls_tbl(s).lsm_id,
4579: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
4580: last_update_date = sysdate,
4581: last_updated_by = fnd_global.user_id,
4582: last_update_login = fnd_global.login_id
4583: where id = g_xls_tbl(s).id;
4584: end loop;
4585: commit;
4586: -- flush table

Line 4608: last_updated_by = fnd_global.user_id,

4604: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
4605: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
4606: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
4607: last_update_date = sysdate,
4608: last_updated_by = fnd_global.user_id,
4609: last_update_login = fnd_global.login_id
4610: where id = g_xsi_tl_tbl(u).id;
4611: end loop;
4612: commit;

Line 4609: last_update_login = fnd_global.login_id

4605: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
4606: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
4607: last_update_date = sysdate,
4608: last_updated_by = fnd_global.user_id,
4609: last_update_login = fnd_global.login_id
4610: where id = g_xsi_tl_tbl(u).id;
4611: end loop;
4612: commit;
4613: -- flush table

Line 4636: last_updated_by = fnd_global.user_id,

4632: xtrx_asset = g_xls_tl_tbl(t).xtrx_asset,
4633: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
4634: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
4635: last_update_date = sysdate,
4636: last_updated_by = fnd_global.user_id,
4637: last_update_login = fnd_global.login_id
4638: where id = g_xls_tl_tbl(t).id;
4639: end loop;
4640: commit;

Line 4637: last_update_login = fnd_global.login_id

4633: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
4634: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
4635: last_update_date = sysdate,
4636: last_updated_by = fnd_global.user_id,
4637: last_update_login = fnd_global.login_id
4638: where id = g_xls_tl_tbl(t).id;
4639: end loop;
4640: commit;
4641: -- flush table

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

4747: g_cnr_tl_tbl(tl_count).id := g_cnr_tbl(z).id;
4748: g_cnr_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4749: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
4750: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
4751: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4752: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4753: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4754: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4755: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

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

4749: g_cnr_tl_tbl(tl_count).source_lang := USERENV('LANG');
4750: g_cnr_tl_tbl(tl_count).sfwt_flag := 'N';
4751: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4752: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4753: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4754: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4755: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4756: tl_count := tl_count + 1;
4757: END LOOP; -- languages code

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

4751: g_cnr_tl_tbl(tl_count).created_by := fnd_global.user_id;
4752: g_cnr_tl_tbl(tl_count).creation_date := sysdate;
4753: g_cnr_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4754: g_cnr_tl_tbl(tl_count).last_update_date := sysdate;
4755: g_cnr_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4756: tl_count := tl_count + 1;
4757: END LOOP; -- languages code
4758: -- invoice messaging processing
4759: if g_inv_msg = 'TRUE' then

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

4890: g_lln_tl_tbl(tl_count).id := g_lln_tbl(x).id;
4891: g_lln_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4892: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
4893: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
4894: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4895: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4896: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4897: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4898: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

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

4892: g_lln_tl_tbl(tl_count).source_lang := USERENV('LANG');
4893: g_lln_tl_tbl(tl_count).sfwt_flag := 'N';
4894: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4895: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4896: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4897: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4898: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4899: tl_count := tl_count + 1;
4900: END LOOP; -- languages loop

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

4894: g_lln_tl_tbl(tl_count).created_by := fnd_global.user_id;
4895: g_lln_tl_tbl(tl_count).creation_date := sysdate;
4896: g_lln_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4897: g_lln_tl_tbl(tl_count).last_update_date := sysdate;
4898: g_lln_tl_tbl(tl_count).last_update_login := fnd_global.login_id;
4899: tl_count := tl_count + 1;
4900: END LOOP; -- languages loop
4901: end loop;
4902:

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

4952: g_lsm_tl_tbl(tl_count).id := g_lsm_tbl(y).id;
4953: g_lsm_tl_tbl(tl_count).language := l_lang_tbl(lang_count).language_code;
4954: g_lsm_tl_tbl(tl_count).source_lang := USERENV('LANG');
4955: g_lsm_tl_tbl(tl_count).sfwt_flag := 'N';
4956: g_lsm_tl_tbl(tl_count).created_by := fnd_global.user_id;
4957: g_lsm_tl_tbl(tl_count).creation_date := sysdate;
4958: g_lsm_tl_tbl(tl_count).last_updated_by := fnd_global.user_id;
4959: g_lsm_tl_tbl(tl_count).last_update_date := sysdate;
4960: g_lsm_tl_tbl(tl_count).last_update_login := fnd_global.login_id;

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

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

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

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

Line 5059: last_updated_by = fnd_global.user_id,

5055: update okl_ext_sell_invs_b
5056: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
5057: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
5058: last_update_date = sysdate,
5059: last_updated_by = fnd_global.user_id,
5060: last_update_login = fnd_global.login_id
5061: where id = g_xsi_tbl(indx).id;
5062: end loop;
5063: commit;

Line 5060: last_update_login = fnd_global.login_id

5056: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
5057: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
5058: last_update_date = sysdate,
5059: last_updated_by = fnd_global.user_id,
5060: last_update_login = fnd_global.login_id
5061: where id = g_xsi_tbl(indx).id;
5062: end loop;
5063: commit;
5064: -- flush table

Line 5086: last_updated_by = fnd_global.user_id,

5082: update okl_xtl_sell_invs_b
5083: set lsm_id = g_xls_tbl(s).lsm_id,
5084: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
5085: last_update_date = sysdate,
5086: last_updated_by = fnd_global.user_id,
5087: last_update_login = fnd_global.login_id
5088: where id = g_xls_tbl(s).id;
5089: end loop;
5090: commit;

Line 5087: last_update_login = fnd_global.login_id

5083: set lsm_id = g_xls_tbl(s).lsm_id,
5084: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
5085: last_update_date = sysdate,
5086: last_updated_by = fnd_global.user_id,
5087: last_update_login = fnd_global.login_id
5088: where id = g_xls_tbl(s).id;
5089: end loop;
5090: commit;
5091: -- flush table

Line 5113: last_updated_by = fnd_global.user_id,

5109: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
5110: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
5111: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
5112: last_update_date = sysdate,
5113: last_updated_by = fnd_global.user_id,
5114: last_update_login = fnd_global.login_id
5115: where id = g_xsi_tl_tbl(u).id;
5116: end loop;
5117: commit;

Line 5114: last_update_login = fnd_global.login_id

5110: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
5111: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
5112: last_update_date = sysdate,
5113: last_updated_by = fnd_global.user_id,
5114: last_update_login = fnd_global.login_id
5115: where id = g_xsi_tl_tbl(u).id;
5116: end loop;
5117: commit;
5118: -- flush table

Line 5141: last_updated_by = fnd_global.user_id,

5137: xtrx_asset = g_xls_tl_tbl(t).xtrx_asset,
5138: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
5139: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
5140: last_update_date = sysdate,
5141: last_updated_by = fnd_global.user_id,
5142: last_update_login = fnd_global.login_id
5143: where id = g_xls_tl_tbl(t).id;
5144: end loop;
5145: commit;

Line 5142: last_update_login = fnd_global.login_id

5138: xtrx_stream_type = g_xls_tl_tbl(t).xtrx_stream_type,
5139: xtrx_stream_group = g_xls_tl_tbl(t).xtrx_stream_group,
5140: last_update_date = sysdate,
5141: last_updated_by = fnd_global.user_id,
5142: last_update_login = fnd_global.login_id
5143: where id = g_xls_tl_tbl(t).id;
5144: end loop;
5145: commit;
5146: -- flush table