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.OKS_MASS_UPDATE_PVT dependencies on FND_GLOBAL

Line 261: fnd_global.user_id,

257: l_oper_instance_id,
258: l_cop_id,
259: 'PROCESSED',
260: 1,
261: fnd_global.user_id,
262: sysdate,
263: fnd_global.user_id,
264: sysdate,
265: fnd_global.user_id,

Line 263: fnd_global.user_id,

259: 'PROCESSED',
260: 1,
261: fnd_global.user_id,
262: sysdate,
263: fnd_global.user_id,
264: sysdate,
265: fnd_global.user_id,
266: null,
267: p_target_chr_id,

Line 265: fnd_global.user_id,

261: fnd_global.user_id,
262: sysdate,
263: fnd_global.user_id,
264: sysdate,
265: fnd_global.user_id,
266: null,
267: p_target_chr_id,
268: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
269: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

Line 268: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

264: sysdate,
265: fnd_global.user_id,
266: null,
267: p_target_chr_id,
268: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
269: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
270: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
271: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
272: null,

Line 269: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

265: fnd_global.user_id,
266: null,
267: p_target_chr_id,
268: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
269: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
270: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
271: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
272: null,
273: null,

Line 270: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

266: null,
267: p_target_chr_id,
268: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
269: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
270: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
271: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
272: null,
273: null,
274: null,

Line 271: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

267: p_target_chr_id,
268: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
269: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
270: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
271: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
272: null,
273: null,
274: null,
275: p_batch_id

Line 319: fnd_global.user_id,

315: p_source_chr_id,
316: p_target_line_id,
317: p_source_line_id,
318: 1,
319: fnd_global.user_id,
320: sysdate,
321: fnd_global.user_id,
322: sysdate,
323: fnd_global.user_id,

Line 321: fnd_global.user_id,

317: p_source_line_id,
318: 1,
319: fnd_global.user_id,
320: sysdate,
321: fnd_global.user_id,
322: sysdate,
323: fnd_global.user_id,
324: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
325: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

Line 323: fnd_global.user_id,

319: fnd_global.user_id,
320: sysdate,
321: fnd_global.user_id,
322: sysdate,
323: fnd_global.user_id,
324: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
325: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
326: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
327: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

Line 324: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

320: sysdate,
321: fnd_global.user_id,
322: sysdate,
323: fnd_global.user_id,
324: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
325: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
326: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
327: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
328: null);

Line 325: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

321: fnd_global.user_id,
322: sysdate,
323: fnd_global.user_id,
324: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
325: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
326: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
327: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
328: null);
329:

Line 326: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

322: sysdate,
323: fnd_global.user_id,
324: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
325: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
326: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
327: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
328: null);
329:
330:

Line 327: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

323: fnd_global.user_id,
324: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
325: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
326: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
327: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
328: null);
329:
330:
331: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 374: fnd_global.user_id,

370: p_source_chr_id,
371: Null,
372: Null,
373: 1,
374: fnd_global.user_id,
375: sysdate,
376: fnd_global.user_id,
377: sysdate,
378: fnd_global.user_id,

Line 376: fnd_global.user_id,

372: Null,
373: 1,
374: fnd_global.user_id,
375: sysdate,
376: fnd_global.user_id,
377: sysdate,
378: fnd_global.user_id,
379: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
380: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

Line 378: fnd_global.user_id,

374: fnd_global.user_id,
375: sysdate,
376: fnd_global.user_id,
377: sysdate,
378: fnd_global.user_id,
379: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
380: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
381: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
382: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

Line 379: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

375: sysdate,
376: fnd_global.user_id,
377: sysdate,
378: fnd_global.user_id,
379: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
380: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
381: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
382: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
383: null);

Line 380: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

376: fnd_global.user_id,
377: sysdate,
378: fnd_global.user_id,
379: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
380: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
381: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
382: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
383: null);
384:

Line 381: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

377: sysdate,
378: fnd_global.user_id,
379: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
380: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
381: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
382: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
383: null);
384:
385:

Line 382: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

378: fnd_global.user_id,
379: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
380: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
381: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
382: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
383: null);
384:
385:
386: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1159: p_entered_by => fnd_global.user_id,

1155: p_notes => p_note,
1156: p_notes_detail => NULL,
1157: p_note_status => 'I',
1158: p_note_type => NULL, --- What should be the note type
1159: p_entered_by => fnd_global.user_id,
1160: p_entered_date => SYSDATE,
1161: x_jtf_note_id => l_jtf_note_id,
1162: p_creation_date => SYSDATE,
1163: p_created_by => fnd_global.user_id,

Line 1163: p_created_by => fnd_global.user_id,

1159: p_entered_by => fnd_global.user_id,
1160: p_entered_date => SYSDATE,
1161: x_jtf_note_id => l_jtf_note_id,
1162: p_creation_date => SYSDATE,
1163: p_created_by => fnd_global.user_id,
1164: p_last_update_date => SYSDATE,
1165: p_last_updated_by => fnd_global.user_id,
1166: p_last_update_login => fnd_global.login_id,
1167: p_attribute1 => NULL,

Line 1165: p_last_updated_by => fnd_global.user_id,

1161: x_jtf_note_id => l_jtf_note_id,
1162: p_creation_date => SYSDATE,
1163: p_created_by => fnd_global.user_id,
1164: p_last_update_date => SYSDATE,
1165: p_last_updated_by => fnd_global.user_id,
1166: p_last_update_login => fnd_global.login_id,
1167: p_attribute1 => NULL,
1168: p_attribute2 => NULL,
1169: p_attribute3 => NULL,

Line 1166: p_last_update_login => fnd_global.login_id,

1162: p_creation_date => SYSDATE,
1163: p_created_by => fnd_global.user_id,
1164: p_last_update_date => SYSDATE,
1165: p_last_updated_by => fnd_global.user_id,
1166: p_last_update_login => fnd_global.login_id,
1167: p_attribute1 => NULL,
1168: p_attribute2 => NULL,
1169: p_attribute3 => NULL,
1170: p_attribute4 => NULL,

Line 1478: OR user_id = fnd_global.user_id;

1474: SELECT 'x'
1475: FROM okc_k_groups_b
1476: WHERE ID = p_group_id
1477: AND public_yn = 'Y'
1478: OR user_id = fnd_global.user_id;
1479: BEGIN
1480: x_return_status := okc_api.g_ret_sts_success;
1481:
1482: IF ( p_group_id <> okc_api.g_miss_num

Line 2385: l_chrv_tbl_in (i).created_by := fnd_global.user_id;

2381: l_chrv_tbl_in (i).attribute15 := '';
2382: l_chrv_tbl_in (i).renewal_type_code := '';
2383: l_chrv_tbl_in (i).renewal_notify_to := NULL;
2384: l_chrv_tbl_in (i).renewal_end_date := NULL;
2385: l_chrv_tbl_in (i).created_by := fnd_global.user_id;
2386: l_chrv_tbl_in (i).creation_date := SYSDATE;
2387: l_chrv_tbl_in (i).last_updated_by := fnd_global.user_id;
2388: l_chrv_tbl_in (i).last_update_date := SYSDATE;
2389: l_chrv_tbl_in (i).last_update_login := fnd_global.login_id;

Line 2387: l_chrv_tbl_in (i).last_updated_by := fnd_global.user_id;

2383: l_chrv_tbl_in (i).renewal_notify_to := NULL;
2384: l_chrv_tbl_in (i).renewal_end_date := NULL;
2385: l_chrv_tbl_in (i).created_by := fnd_global.user_id;
2386: l_chrv_tbl_in (i).creation_date := SYSDATE;
2387: l_chrv_tbl_in (i).last_updated_by := fnd_global.user_id;
2388: l_chrv_tbl_in (i).last_update_date := SYSDATE;
2389: l_chrv_tbl_in (i).last_update_login := fnd_global.login_id;
2390: l_chrv_tbl_in (i).cust_acct_id := NULL;
2391: l_chrv_tbl_in (i).payment_instruction_type := '';

Line 2389: l_chrv_tbl_in (i).last_update_login := fnd_global.login_id;

2385: l_chrv_tbl_in (i).created_by := fnd_global.user_id;
2386: l_chrv_tbl_in (i).creation_date := SYSDATE;
2387: l_chrv_tbl_in (i).last_updated_by := fnd_global.user_id;
2388: l_chrv_tbl_in (i).last_update_date := SYSDATE;
2389: l_chrv_tbl_in (i).last_update_login := fnd_global.login_id;
2390: l_chrv_tbl_in (i).cust_acct_id := NULL;
2391: l_chrv_tbl_in (i).payment_instruction_type := '';
2392:
2393: IF p_batch_rules.bill_address_id Is Not Null Then

Line 2465: l_cpsv_tbl_in (i).user_id := fnd_global.user_id;

2461:
2462: l_cpsv_tbl_in (i).ID := okc_p_util.raw_to_number (SYS_GUID ());
2463: l_cpsv_tbl_in (i).chr_id := hdr_id (i);
2464: l_cpsv_tbl_in (i).pdf_id := setup_attr.pdf_id;
2465: l_cpsv_tbl_in (i).user_id := fnd_global.user_id;
2466: l_cpsv_tbl_in (i).created_by := fnd_global.user_id;
2467: l_cpsv_tbl_in (i).creation_date := SYSDATE;
2468: l_cpsv_tbl_in (i).last_updated_by := fnd_global.user_id;
2469: l_cpsv_tbl_in (i).last_update_date := SYSDATE;

Line 2466: l_cpsv_tbl_in (i).created_by := fnd_global.user_id;

2462: l_cpsv_tbl_in (i).ID := okc_p_util.raw_to_number (SYS_GUID ());
2463: l_cpsv_tbl_in (i).chr_id := hdr_id (i);
2464: l_cpsv_tbl_in (i).pdf_id := setup_attr.pdf_id;
2465: l_cpsv_tbl_in (i).user_id := fnd_global.user_id;
2466: l_cpsv_tbl_in (i).created_by := fnd_global.user_id;
2467: l_cpsv_tbl_in (i).creation_date := SYSDATE;
2468: l_cpsv_tbl_in (i).last_updated_by := fnd_global.user_id;
2469: l_cpsv_tbl_in (i).last_update_date := SYSDATE;
2470: l_cpsv_tbl_in (i).object_version_number := 1;

Line 2468: l_cpsv_tbl_in (i).last_updated_by := fnd_global.user_id;

2464: l_cpsv_tbl_in (i).pdf_id := setup_attr.pdf_id;
2465: l_cpsv_tbl_in (i).user_id := fnd_global.user_id;
2466: l_cpsv_tbl_in (i).created_by := fnd_global.user_id;
2467: l_cpsv_tbl_in (i).creation_date := SYSDATE;
2468: l_cpsv_tbl_in (i).last_updated_by := fnd_global.user_id;
2469: l_cpsv_tbl_in (i).last_update_date := SYSDATE;
2470: l_cpsv_tbl_in (i).object_version_number := 1;
2471: l_cpsv_tbl_in (i).crt_id := NULL;
2472: l_cpsv_tbl_in (i).process_id := NULL;

Line 2490: l_cpsv_tbl_in (i).last_update_login := fnd_global.login_id;

2486: l_cpsv_tbl_in (i).attribute12 := '';
2487: l_cpsv_tbl_in (i).attribute13 := '';
2488: l_cpsv_tbl_in (i).attribute14 := '';
2489: l_cpsv_tbl_in (i).attribute15 := '';
2490: l_cpsv_tbl_in (i).last_update_login := fnd_global.login_id;
2491: END IF;
2492: -- create contract group
2493: IF setup_attr.cgp_new_id IS NOT NULL
2494: THEN

Line 2508: l_cgcv_tbl_in (i).created_by := fnd_global.user_id;

2504: l_cgcv_tbl_in (i).cgp_parent_id := setup_attr.cgp_new_id;
2505: l_cgcv_tbl_in (i).included_chr_id := hdr_id (i);
2506: l_cgcv_tbl_in (i).object_version_number := 1;
2507: l_cgcv_tbl_in (i).scs_code := hdr_scs_code (i);
2508: l_cgcv_tbl_in (i).created_by := fnd_global.user_id;
2509: l_cgcv_tbl_in (i).creation_date := SYSDATE;
2510: l_cgcv_tbl_in (i).last_updated_by := fnd_global.user_id;
2511: l_cgcv_tbl_in (i).last_update_date := SYSDATE;
2512: l_cgcv_tbl_in (i).last_update_login := fnd_global.login_id;

Line 2510: l_cgcv_tbl_in (i).last_updated_by := fnd_global.user_id;

2506: l_cgcv_tbl_in (i).object_version_number := 1;
2507: l_cgcv_tbl_in (i).scs_code := hdr_scs_code (i);
2508: l_cgcv_tbl_in (i).created_by := fnd_global.user_id;
2509: l_cgcv_tbl_in (i).creation_date := SYSDATE;
2510: l_cgcv_tbl_in (i).last_updated_by := fnd_global.user_id;
2511: l_cgcv_tbl_in (i).last_update_date := SYSDATE;
2512: l_cgcv_tbl_in (i).last_update_login := fnd_global.login_id;
2513: END IF;
2514:

Line 2512: l_cgcv_tbl_in (i).last_update_login := fnd_global.login_id;

2508: l_cgcv_tbl_in (i).created_by := fnd_global.user_id;
2509: l_cgcv_tbl_in (i).creation_date := SYSDATE;
2510: l_cgcv_tbl_in (i).last_updated_by := fnd_global.user_id;
2511: l_cgcv_tbl_in (i).last_update_date := SYSDATE;
2512: l_cgcv_tbl_in (i).last_update_login := fnd_global.login_id;
2513: END IF;
2514:
2515: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2516: THEN

Line 2565: l_cpl_tbl_in (j).created_by := fnd_global.user_id;

2561: l_cpl_tbl_in (j).attribute12 := '';
2562: l_cpl_tbl_in (j).attribute13 := '';
2563: l_cpl_tbl_in (j).attribute14 := '';
2564: l_cpl_tbl_in (j).attribute15 := '';
2565: l_cpl_tbl_in (j).created_by := fnd_global.user_id;
2566: l_cpl_tbl_in (j).creation_date := SYSDATE;
2567: l_cpl_tbl_in (j).last_updated_by := fnd_global.user_id;
2568: l_cpl_tbl_in (j).last_update_date := SYSDATE;
2569: l_cpl_tbl_in (j).last_update_login := fnd_global.login_id;

Line 2567: l_cpl_tbl_in (j).last_updated_by := fnd_global.user_id;

2563: l_cpl_tbl_in (j).attribute14 := '';
2564: l_cpl_tbl_in (j).attribute15 := '';
2565: l_cpl_tbl_in (j).created_by := fnd_global.user_id;
2566: l_cpl_tbl_in (j).creation_date := SYSDATE;
2567: l_cpl_tbl_in (j).last_updated_by := fnd_global.user_id;
2568: l_cpl_tbl_in (j).last_update_date := SYSDATE;
2569: l_cpl_tbl_in (j).last_update_login := fnd_global.login_id;
2570: If l_lse_id <> 14 Then
2571: If NVL(fnd_profile.value('OKS_USE_JTF'),'NO') = 'YES' Then

Line 2569: l_cpl_tbl_in (j).last_update_login := fnd_global.login_id;

2565: l_cpl_tbl_in (j).created_by := fnd_global.user_id;
2566: l_cpl_tbl_in (j).creation_date := SYSDATE;
2567: l_cpl_tbl_in (j).last_updated_by := fnd_global.user_id;
2568: l_cpl_tbl_in (j).last_update_date := SYSDATE;
2569: l_cpl_tbl_in (j).last_update_login := fnd_global.login_id;
2570: If l_lse_id <> 14 Then
2571: If NVL(fnd_profile.value('OKS_USE_JTF'),'NO') = 'YES' Then
2572:
2573: --Vendor Contact Derived from territory Setup

Line 2683: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;

2679: l_ctcv_tbl_in (k).attribute12 := '';
2680: l_ctcv_tbl_in (k).attribute13 := '';
2681: l_ctcv_tbl_in (k).attribute14 := '';
2682: l_ctcv_tbl_in (k).attribute15 := '';
2683: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2684: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2685: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2686: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2687: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;

Line 2685: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;

2681: l_ctcv_tbl_in (k).attribute14 := '';
2682: l_ctcv_tbl_in (k).attribute15 := '';
2683: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2684: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2685: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2686: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2687: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2688: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2689: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);

Line 2687: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;

2683: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2684: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2685: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2686: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2687: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2688: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2689: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);
2690:
2691:

Line 2740: l_cpl_tbl_in (j + 1).created_by := fnd_global.user_id;

2736: l_cpl_tbl_in (j + 1).attribute12 := '';
2737: l_cpl_tbl_in (j + 1).attribute13 := '';
2738: l_cpl_tbl_in (j + 1).attribute14 := '';
2739: l_cpl_tbl_in (j + 1).attribute15 := '';
2740: l_cpl_tbl_in (j + 1).created_by := fnd_global.user_id;
2741: l_cpl_tbl_in (j + 1).creation_date := SYSDATE;
2742: l_cpl_tbl_in (j + 1).last_updated_by := fnd_global.user_id;
2743: l_cpl_tbl_in (j + 1).last_update_date := SYSDATE;
2744: l_cpl_tbl_in (j + 1).last_update_login := fnd_global.login_id;

Line 2742: l_cpl_tbl_in (j + 1).last_updated_by := fnd_global.user_id;

2738: l_cpl_tbl_in (j + 1).attribute14 := '';
2739: l_cpl_tbl_in (j + 1).attribute15 := '';
2740: l_cpl_tbl_in (j + 1).created_by := fnd_global.user_id;
2741: l_cpl_tbl_in (j + 1).creation_date := SYSDATE;
2742: l_cpl_tbl_in (j + 1).last_updated_by := fnd_global.user_id;
2743: l_cpl_tbl_in (j + 1).last_update_date := SYSDATE;
2744: l_cpl_tbl_in (j + 1).last_update_login := fnd_global.login_id;
2745:
2746: IF p_batch_rules.bill_contact_id IS NOT NULL

Line 2744: l_cpl_tbl_in (j + 1).last_update_login := fnd_global.login_id;

2740: l_cpl_tbl_in (j + 1).created_by := fnd_global.user_id;
2741: l_cpl_tbl_in (j + 1).creation_date := SYSDATE;
2742: l_cpl_tbl_in (j + 1).last_updated_by := fnd_global.user_id;
2743: l_cpl_tbl_in (j + 1).last_update_date := SYSDATE;
2744: l_cpl_tbl_in (j + 1).last_update_login := fnd_global.login_id;
2745:
2746: IF p_batch_rules.bill_contact_id IS NOT NULL
2747: THEN
2748: IF check_acct_not_related(p_batch_rules.new_party_id,

Line 2801: l_cpl_tbl_in (j + 2).created_by := fnd_global.user_id;

2797: l_cpl_tbl_in (j + 2).attribute12 := '';
2798: l_cpl_tbl_in (j + 2).attribute13 := '';
2799: l_cpl_tbl_in (j + 2).attribute14 := '';
2800: l_cpl_tbl_in (j + 2).attribute15 := '';
2801: l_cpl_tbl_in (j + 2).created_by := fnd_global.user_id;
2802: l_cpl_tbl_in (j + 2).creation_date := SYSDATE;
2803: l_cpl_tbl_in (j + 2).last_updated_by := fnd_global.user_id;
2804: l_cpl_tbl_in (j + 2).last_update_date := SYSDATE;
2805: l_cpl_tbl_in (j + 2).last_update_login := fnd_global.login_id;

Line 2803: l_cpl_tbl_in (j + 2).last_updated_by := fnd_global.user_id;

2799: l_cpl_tbl_in (j + 2).attribute14 := '';
2800: l_cpl_tbl_in (j + 2).attribute15 := '';
2801: l_cpl_tbl_in (j + 2).created_by := fnd_global.user_id;
2802: l_cpl_tbl_in (j + 2).creation_date := SYSDATE;
2803: l_cpl_tbl_in (j + 2).last_updated_by := fnd_global.user_id;
2804: l_cpl_tbl_in (j + 2).last_update_date := SYSDATE;
2805: l_cpl_tbl_in (j + 2).last_update_login := fnd_global.login_id;
2806:
2807:

Line 2805: l_cpl_tbl_in (j + 2).last_update_login := fnd_global.login_id;

2801: l_cpl_tbl_in (j + 2).created_by := fnd_global.user_id;
2802: l_cpl_tbl_in (j + 2).creation_date := SYSDATE;
2803: l_cpl_tbl_in (j + 2).last_updated_by := fnd_global.user_id;
2804: l_cpl_tbl_in (j + 2).last_update_date := SYSDATE;
2805: l_cpl_tbl_in (j + 2).last_update_login := fnd_global.login_id;
2806:
2807:
2808: l_ctcv_tbl_in (k).ID := okc_p_util.raw_to_number (SYS_GUID ());
2809: l_ctcv_tbl_in (k).object_version_number := 1;

Line 2836: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;

2832: l_ctcv_tbl_in (k).attribute12 := '';
2833: l_ctcv_tbl_in (k).attribute13 := '';
2834: l_ctcv_tbl_in (k).attribute14 := '';
2835: l_ctcv_tbl_in (k).attribute15 := '';
2836: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2837: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2838: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2839: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2840: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;

Line 2838: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;

2834: l_ctcv_tbl_in (k).attribute14 := '';
2835: l_ctcv_tbl_in (k).attribute15 := '';
2836: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2837: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2838: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2839: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2840: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2841: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2842: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);

Line 2840: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;

2836: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2837: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2838: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2839: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2840: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2841: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2842: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);
2843: j := j + 3;
2844: ELSE

Line 2880: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;

2876: l_ctcv_tbl_in (k).attribute12 := '';
2877: l_ctcv_tbl_in (k).attribute13 := '';
2878: l_ctcv_tbl_in (k).attribute14 := '';
2879: l_ctcv_tbl_in (k).attribute15 := '';
2880: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2881: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2882: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2883: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2884: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;

Line 2882: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;

2878: l_ctcv_tbl_in (k).attribute14 := '';
2879: l_ctcv_tbl_in (k).attribute15 := '';
2880: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2881: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2882: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2883: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2884: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2885: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2886: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);

Line 2884: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;

2880: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2881: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2882: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2883: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2884: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2885: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2886: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);
2887: K := K + 1;
2888: j := j + 2;

Line 2964: fnd_global.user_id,

2960: hdr_sum_trx (i),
2961: 1,
2962: hdr_period_start(i),
2963: hdr_period_type(i),
2964: fnd_global.user_id,
2965: sysdate,
2966: fnd_global.user_id,
2967: sysdate,
2968: fnd_global.login_id,

Line 2966: fnd_global.user_id,

2962: hdr_period_start(i),
2963: hdr_period_type(i),
2964: fnd_global.user_id,
2965: sysdate,
2966: fnd_global.user_id,
2967: sysdate,
2968: fnd_global.login_id,
2969: renewal_status(i),
2970: price_uom(i));

Line 2968: fnd_global.login_id,

2964: fnd_global.user_id,
2965: sysdate,
2966: fnd_global.user_id,
2967: sysdate,
2968: fnd_global.login_id,
2969: renewal_status(i),
2970: price_uom(i));
2971:
2972: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks header table records sucessfully');

Line 3134: fnd_global.user_id,

3130: groupid (i),
3131: resource_id (i),
3132: access_level (i),
3133: 1,
3134: fnd_global.user_id,
3135: SYSDATE,
3136: fnd_global.user_id,
3137: SYSDATE,
3138: fnd_global.user_id

Line 3136: fnd_global.user_id,

3132: access_level (i),
3133: 1,
3134: fnd_global.user_id,
3135: SYSDATE,
3136: fnd_global.user_id,
3137: SYSDATE,
3138: fnd_global.user_id
3139: );
3140: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');

Line 3138: fnd_global.user_id

3134: fnd_global.user_id,
3135: SYSDATE,
3136: fnd_global.user_id,
3137: SYSDATE,
3138: fnd_global.user_id
3139: );
3140: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');
3141:
3142: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 3189: fnd_global.user_id,

3185: ctc_id (i),
3186: sales_credit_type_id1 (i),
3187: '#',
3188: 1,
3189: fnd_global.user_id,
3190: SYSDATE,
3191: fnd_global.user_id,
3192: SYSDATE
3193: );

Line 3191: fnd_global.user_id,

3187: '#',
3188: 1,
3189: fnd_global.user_id,
3190: SYSDATE,
3191: fnd_global.user_id,
3192: SYSDATE
3193: );
3194: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3195:

Line 3464: fnd_global.user_id,

3460: -- DECODE(line_sts(i),'ENTERED',get_status_code('ENTERED'),p_batch_rules.contract_status)),
3461: lse_id (i),
3462: 'N',
3463: 1,
3464: fnd_global.user_id,
3465: SYSDATE,
3466: fnd_global.user_id,
3467: SYSDATE,
3468: 0,

Line 3466: fnd_global.user_id,

3462: 'N',
3463: 1,
3464: fnd_global.user_id,
3465: SYSDATE,
3466: fnd_global.user_id,
3467: SYSDATE,
3468: 0,
3469: 'N',
3470: 0,

Line 3472: fnd_global.user_id,

3468: 0,
3469: 'N',
3470: 0,
3471: srv_curr (i),
3472: fnd_global.user_id,
3473: new_sdt (i),
3474: new_edt (i),
3475: srv_pl (i),
3476:

Line 3531: fnd_global.user_id,

3527: okc_util.get_userenv_lang,
3528: 'N',
3529: null,
3530: null,
3531: fnd_global.user_id,
3532: SYSDATE,
3533: fnd_global.user_id,
3534: SYSDATE,
3535: fnd_global.user_id

Line 3533: fnd_global.user_id,

3529: null,
3530: null,
3531: fnd_global.user_id,
3532: SYSDATE,
3533: fnd_global.user_id,
3534: SYSDATE,
3535: fnd_global.user_id
3536: );
3537: END LOOP;

Line 3535: fnd_global.user_id

3531: fnd_global.user_id,
3532: SYSDATE,
3533: fnd_global.user_id,
3534: SYSDATE,
3535: fnd_global.user_id
3536: );
3537: END LOOP;
3538: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc tl table records sucessfully');
3539:

Line 3587: fnd_global.user_id,

3583: uom_code (i),
3584: 'N',
3585: number_of_items (i),
3586: 1,
3587: fnd_global.user_id,
3588: SYSDATE,
3589: fnd_global.user_id,
3590: SYSDATE,
3591: fnd_global.login_id,

Line 3589: fnd_global.user_id,

3585: number_of_items (i),
3586: 1,
3587: fnd_global.user_id,
3588: SYSDATE,
3589: fnd_global.user_id,
3590: SYSDATE,
3591: fnd_global.login_id,
3592: NULL,
3593: NULL,

Line 3591: fnd_global.login_id,

3587: fnd_global.user_id,
3588: SYSDATE,
3589: fnd_global.user_id,
3590: SYSDATE,
3591: fnd_global.login_id,
3592: NULL,
3593: NULL,
3594: NULL,
3595: NULL,

Line 3634: fnd_global.user_id,

3630: contract_id (i),
3631: p_batch_rules.accounting_rule,
3632: tax_code (i),
3633: 1,
3634: fnd_global.user_id,
3635: SYSDATE,
3636: fnd_global.user_id,
3637: SYSDATE,
3638: fnd_global.login_id,

Line 3636: fnd_global.user_id,

3632: tax_code (i),
3633: 1,
3634: fnd_global.user_id,
3635: SYSDATE,
3636: fnd_global.user_id,
3637: SYSDATE,
3638: fnd_global.login_id,
3639: coverage_id (i),
3640: stand_cov_yn (i),

Line 3638: fnd_global.login_id,

3634: fnd_global.user_id,
3635: SYSDATE,
3636: fnd_global.user_id,
3637: SYSDATE,
3638: fnd_global.login_id,
3639: coverage_id (i),
3640: stand_cov_yn (i),
3641: price_uom(i)
3642: );

Line 3674: fnd_global.user_id,

3670: okc_util.g_language_code (lang_i),
3671: okc_util.get_userenv_lang,
3672: 'N',
3673: (substr(srv_inv_text(i),1,instr(srv_inv_text(i),':',1,1))|| new_sdt (i)||' - '|| new_edt (i)),
3674: fnd_global.user_id,
3675: SYSDATE,
3676: fnd_global.user_id,
3677: SYSDATE,
3678: fnd_global.user_id

Line 3676: fnd_global.user_id,

3672: 'N',
3673: (substr(srv_inv_text(i),1,instr(srv_inv_text(i),':',1,1))|| new_sdt (i)||' - '|| new_edt (i)),
3674: fnd_global.user_id,
3675: SYSDATE,
3676: fnd_global.user_id,
3677: SYSDATE,
3678: fnd_global.user_id
3679: );
3680: END LOOP;

Line 3678: fnd_global.user_id

3674: fnd_global.user_id,
3675: SYSDATE,
3676: fnd_global.user_id,
3677: SYSDATE,
3678: fnd_global.user_id
3679: );
3680: END LOOP;
3681:
3682: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks tl table records sucessfully');

Line 3728: fnd_global.user_id,

3724: ctc_id (i),
3725: sales_credit_type_id1 (i),
3726: '#',
3727: 1,
3728: fnd_global.user_id,
3729: SYSDATE,
3730: fnd_global.user_id,
3731: SYSDATE
3732: );

Line 3730: fnd_global.user_id,

3726: '#',
3727: 1,
3728: fnd_global.user_id,
3729: SYSDATE,
3730: fnd_global.user_id,
3731: SYSDATE
3732: );
3733: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3734:

Line 3964: fnd_global.user_id,

3960: -- DECODE(subline_sts(i),'ENTERED',get_status_code('ENTERED'),p_batch_rules.contract_status)),
3961: lse_id (i),
3962: 'N',
3963: 1,
3964: fnd_global.user_id,
3965: SYSDATE,
3966: fnd_global.user_id,
3967: SYSDATE,
3968: NVL(price_negotiated (i),0), -- price_negotiated

Line 3966: fnd_global.user_id,

3962: 'N',
3963: 1,
3964: fnd_global.user_id,
3965: SYSDATE,
3966: fnd_global.user_id,
3967: SYSDATE,
3968: NVL(price_negotiated (i),0), -- price_negotiated
3969: 'Y',
3970: NVL(unit_price (i),0), -- unit price

Line 3972: fnd_global.user_id,

3968: NVL(price_negotiated (i),0), -- price_negotiated
3969: 'Y',
3970: NVL(unit_price (i),0), -- unit price
3971: subline_curr (i),
3972: fnd_global.user_id,
3973: subline_sdate (i),
3974: subline_edate (i),
3975: renewal_type (i),
3976: Oks_setup_util_pub.Get_Annualized_Factor(subline_sdate (i),

Line 4014: fnd_global.user_id,

4010: okc_util.get_userenv_lang,
4011: 'N',
4012: null,
4013: null,
4014: fnd_global.user_id,
4015: SYSDATE,
4016: fnd_global.user_id,
4017: SYSDATE,
4018: fnd_global.user_id

Line 4016: fnd_global.user_id,

4012: null,
4013: null,
4014: fnd_global.user_id,
4015: SYSDATE,
4016: fnd_global.user_id,
4017: SYSDATE,
4018: fnd_global.user_id
4019: );
4020: END LOOP;

Line 4018: fnd_global.user_id

4014: fnd_global.user_id,
4015: SYSDATE,
4016: fnd_global.user_id,
4017: SYSDATE,
4018: fnd_global.user_id
4019: );
4020: END LOOP;
4021: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line tl table records sucessfully');
4022:

Line 4070: fnd_global.user_id,

4066: uom_code (i),
4067: 'N',
4068: number_of_items (i),
4069: 1,
4070: fnd_global.user_id,
4071: SYSDATE,
4072: fnd_global.user_id,
4073: SYSDATE,
4074: fnd_global.user_id,

Line 4072: fnd_global.user_id,

4068: number_of_items (i),
4069: 1,
4070: fnd_global.user_id,
4071: SYSDATE,
4072: fnd_global.user_id,
4073: SYSDATE,
4074: fnd_global.user_id,
4075: NULL,
4076: NULL,

Line 4074: fnd_global.user_id,

4070: fnd_global.user_id,
4071: SYSDATE,
4072: fnd_global.user_id,
4073: SYSDATE,
4074: fnd_global.user_id,
4075: NULL,
4076: NULL,
4077: NULL,
4078: NULL,

Line 4117: fnd_global.user_id,

4113: price_uom(i),
4114: toplvl_price(i),
4115: toplvl_uom(i),
4116: 1,
4117: fnd_global.user_id,
4118: SYSDATE,
4119: fnd_global.user_id,
4120: SYSDATE,
4121: fnd_global.user_id

Line 4119: fnd_global.user_id,

4115: toplvl_uom(i),
4116: 1,
4117: fnd_global.user_id,
4118: SYSDATE,
4119: fnd_global.user_id,
4120: SYSDATE,
4121: fnd_global.user_id
4122: );
4123: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');

Line 4121: fnd_global.user_id

4117: fnd_global.user_id,
4118: SYSDATE,
4119: fnd_global.user_id,
4120: SYSDATE,
4121: fnd_global.user_id
4122: );
4123: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
4124:
4125: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 4155: fnd_global.user_id,

4151: okc_util.get_userenv_lang,
4152: 'N',
4153: 'Subline created from transfers',
4154: (substr(sl_inv_text(i),1,instr(sl_inv_text(i),':',1,3))||subline_sdate(i)||' - '|| subline_edate(i)),
4155: fnd_global.user_id,
4156: SYSDATE,
4157: fnd_global.user_id,
4158: SYSDATE,
4159: fnd_global.user_id

Line 4157: fnd_global.user_id,

4153: 'Subline created from transfers',
4154: (substr(sl_inv_text(i),1,instr(sl_inv_text(i),':',1,3))||subline_sdate(i)||' - '|| subline_edate(i)),
4155: fnd_global.user_id,
4156: SYSDATE,
4157: fnd_global.user_id,
4158: SYSDATE,
4159: fnd_global.user_id
4160: );
4161: END LOOP;

Line 4159: fnd_global.user_id

4155: fnd_global.user_id,
4156: SYSDATE,
4157: fnd_global.user_id,
4158: SYSDATE,
4159: fnd_global.user_id
4160: );
4161: END LOOP;
4162:
4163: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line tl table records sucessfully');

Line 5297: p_entered_by => fnd_global.user_id,

5293: p_notes => l_notes_tbl (m).notes,
5294: p_notes_detail => l_notes_tbl (m).notes_detail,
5295: p_note_status => l_notes_tbl (m).note_status,
5296: p_note_type => l_notes_tbl (m).note_type,
5297: p_entered_by => fnd_global.user_id,
5298: p_entered_date => SYSDATE,
5299: x_jtf_note_id => l_jtf_note_id,
5300: p_creation_date => SYSDATE,
5301: p_created_by => fnd_global.user_id,

Line 5301: p_created_by => fnd_global.user_id,

5297: p_entered_by => fnd_global.user_id,
5298: p_entered_date => SYSDATE,
5299: x_jtf_note_id => l_jtf_note_id,
5300: p_creation_date => SYSDATE,
5301: p_created_by => fnd_global.user_id,
5302: p_last_update_date => SYSDATE,
5303: p_last_updated_by => fnd_global.user_id,
5304: p_last_update_login => fnd_global.login_id,
5305: p_attribute1 => NULL,

Line 5303: p_last_updated_by => fnd_global.user_id,

5299: x_jtf_note_id => l_jtf_note_id,
5300: p_creation_date => SYSDATE,
5301: p_created_by => fnd_global.user_id,
5302: p_last_update_date => SYSDATE,
5303: p_last_updated_by => fnd_global.user_id,
5304: p_last_update_login => fnd_global.login_id,
5305: p_attribute1 => NULL,
5306: p_attribute2 => NULL,
5307: p_attribute3 => NULL,

Line 5304: p_last_update_login => fnd_global.login_id,

5300: p_creation_date => SYSDATE,
5301: p_created_by => fnd_global.user_id,
5302: p_last_update_date => SYSDATE,
5303: p_last_updated_by => fnd_global.user_id,
5304: p_last_update_login => fnd_global.login_id,
5305: p_attribute1 => NULL,
5306: p_attribute2 => NULL,
5307: p_attribute3 => NULL,
5308: p_attribute4 => NULL,

Line 7198: fnd_global.user_id,

7194: 'TRF',
7195: a.transaction_date,
7196: b.instance_number,
7197: NULL, -- parameter
7198: fnd_global.user_id,
7199: SYSDATE,
7200: fnd_global.user_id,
7201: SYSDATE,
7202: fnd_global.login_id,

Line 7200: fnd_global.user_id,

7196: b.instance_number,
7197: NULL, -- parameter
7198: fnd_global.user_id,
7199: SYSDATE,
7200: fnd_global.user_id,
7201: SYSDATE,
7202: fnd_global.login_id,
7203: p_batch_id
7204: FROM oks_instance_temp a,

Line 7202: fnd_global.login_id,

7198: fnd_global.user_id,
7199: SYSDATE,
7200: fnd_global.user_id,
7201: SYSDATE,
7202: fnd_global.login_id,
7203: p_batch_id
7204: FROM oks_instance_temp a,
7205: csi_item_instances b
7206: WHERE a.old_customer_product_id = b.instance_id);

Line 7292: fnd_global.user_id,

7288: hdr_sts (i),
7289: hdr.sts_code,
7290: lines_b.date_terminated, -- subline_date_terminated,
7291: 1,
7292: fnd_global.user_id,
7293: SYSDATE,
7294: fnd_global.user_id,
7295: SYSDATE,
7296: fnd_global.login_id,

Line 7294: fnd_global.user_id,

7290: lines_b.date_terminated, -- subline_date_terminated,
7291: 1,
7292: fnd_global.user_id,
7293: SYSDATE,
7294: fnd_global.user_id,
7295: SYSDATE,
7296: fnd_global.login_id,
7297: lines_b.date_cancelled, --Date cancelled,
7298: 'TERM'

Line 7296: fnd_global.login_id,

7292: fnd_global.user_id,
7293: SYSDATE,
7294: fnd_global.user_id,
7295: SYSDATE,
7296: fnd_global.login_id,
7297: lines_b.date_cancelled, --Date cancelled,
7298: 'TERM'
7299: from oks_instance_history ins_hist,
7300: Okc_k_lines_b lines_b,

Line 7724: fnd_global.user_id,

7720: 'TRF',
7721: a.transaction_date,
7722: b.instance_number,
7723: NULL, -- parameter
7724: fnd_global.user_id,
7725: SYSDATE,
7726: fnd_global.user_id,
7727: SYSDATE,
7728: fnd_global.login_id,

Line 7726: fnd_global.user_id,

7722: b.instance_number,
7723: NULL, -- parameter
7724: fnd_global.user_id,
7725: SYSDATE,
7726: fnd_global.user_id,
7727: SYSDATE,
7728: fnd_global.login_id,
7729: p_batch_id
7730: FROM oks_instance_temp a,

Line 7728: fnd_global.login_id,

7724: fnd_global.user_id,
7725: SYSDATE,
7726: fnd_global.user_id,
7727: SYSDATE,
7728: fnd_global.login_id,
7729: p_batch_id
7730: FROM oks_instance_temp a,
7731: csi_item_instances b
7732: WHERE a.old_customer_product_id = b.instance_id);

Line 7813: fnd_global.user_id,

7809: hdr_sts (i),
7810: hdr.sts_code,
7811: line.date_terminated, -- subline_date_terminated,
7812: 1,
7813: fnd_global.user_id,
7814: SYSDATE,
7815: fnd_global.user_id,
7816: SYSDATE,
7817: fnd_global.login_id,

Line 7815: fnd_global.user_id,

7811: line.date_terminated, -- subline_date_terminated,
7812: 1,
7813: fnd_global.user_id,
7814: SYSDATE,
7815: fnd_global.user_id,
7816: SYSDATE,
7817: fnd_global.login_id,
7818: line.date_cancelled --Date cancelled
7819: from Oks_instance_history inshist, Okc_k_lines_b line

Line 7817: fnd_global.login_id,

7813: fnd_global.user_id,
7814: SYSDATE,
7815: fnd_global.user_id,
7816: SYSDATE,
7817: fnd_global.login_id,
7818: line.date_cancelled --Date cancelled
7819: from Oks_instance_history inshist, Okc_k_lines_b line
7820: ,okc_k_headers_all_b hdr
7821: Where inshist.instance_id = custprod_id(i)

Line 7916: fnd_global.user_id,

7912: hdr_sts (i),
7913: hdr.sts_code,--new_k_status (i),
7914: NULL, -- subline_date_terminated,
7915: 1,
7916: fnd_global.user_id,
7917: SYSDATE,
7918: fnd_global.user_id,
7919: SYSDATE,
7920: fnd_global.login_id

Line 7918: fnd_global.user_id,

7914: NULL, -- subline_date_terminated,
7915: 1,
7916: fnd_global.user_id,
7917: SYSDATE,
7918: fnd_global.user_id,
7919: SYSDATE,
7920: fnd_global.login_id
7921: from Oks_instance_history inshist
7922: , okc_k_headers_all_b hdr

Line 7920: fnd_global.login_id

7916: fnd_global.user_id,
7917: SYSDATE,
7918: fnd_global.user_id,
7919: SYSDATE,
7920: fnd_global.login_id
7921: from Oks_instance_history inshist
7922: , okc_k_headers_all_b hdr
7923: , okc_k_lines_b line
7924: , okc_k_lines_b subline

Line 8039: last_updated_by = fnd_global.user_id,

8035: UPDATE okc_k_lines_b
8036: SET start_date = idc_date (i),
8037: end_date = new_edt (i),
8038: sts_code = get_status (idc_date (i), new_edt (i)),
8039: last_updated_by = fnd_global.user_id,
8040: last_update_date = SYSDATE,
8041: last_update_login = fnd_global.login_id
8042: WHERE ID = subline_id(i)
8043: And (trunc(nvl(sr_date(i),idc_date(i))) >= trunc(idc_date(i))

Line 8041: last_update_login = fnd_global.login_id

8037: end_date = new_edt (i),
8038: sts_code = get_status (idc_date (i), new_edt (i)),
8039: last_updated_by = fnd_global.user_id,
8040: last_update_date = SYSDATE,
8041: last_update_login = fnd_global.login_id
8042: WHERE ID = subline_id(i)
8043: And (trunc(nvl(sr_date(i),idc_date(i))) >= trunc(idc_date(i))
8044: And TRUNC(nvl(sr_date(i),new_edt(i))) <= TRUNC(new_edt(i)));
8045:

Line 8056: last_updated_by = fnd_global.user_id,

8052: IF sub_line_id.COUNT > 0 THEN -- Added for Bug#14183916
8053: Forall i in 1..sub_line_id.count
8054: UPDATE oks_k_lines_tl klt
8055: SET invoice_text = inv_text(i),
8056: last_updated_by = fnd_global.user_id,
8057: last_update_date = SYSDATE,
8058: last_update_login = fnd_global.login_id
8059: WHERE id = (select id from oks_k_lines_b
8060: where cle_id = sub_line_id(i))

Line 8058: last_update_login = fnd_global.login_id

8054: UPDATE oks_k_lines_tl klt
8055: SET invoice_text = inv_text(i),
8056: last_updated_by = fnd_global.user_id,
8057: last_update_date = SYSDATE,
8058: last_update_login = fnd_global.login_id
8059: WHERE id = (select id from oks_k_lines_b
8060: where cle_id = sub_line_id(i))
8061: AND klt.language = USERENV('LANG');
8062: END IF; --Added for Bug#14183916

Line 8078: last_updated_by = fnd_global.user_id,

8074: UPDATE okc_k_lines_b
8075: SET start_date = line_new_Sdate (i),
8076: end_date = line_new_edate (i),
8077: sts_code = get_status (line_new_Sdate(i), line_new_edate(i)),
8078: last_updated_by = fnd_global.user_id,
8079: last_update_date = SYSDATE,
8080: last_update_login = fnd_global.login_id
8081: --invoice_text = inv_text(i)
8082: WHERE ID = top_line_id(i);

Line 8080: last_update_login = fnd_global.login_id

8076: end_date = line_new_edate (i),
8077: sts_code = get_status (line_new_Sdate(i), line_new_edate(i)),
8078: last_updated_by = fnd_global.user_id,
8079: last_update_date = SYSDATE,
8080: last_update_login = fnd_global.login_id
8081: --invoice_text = inv_text(i)
8082: WHERE ID = top_line_id(i);
8083:
8084: Top_line_id.delete;

Line 8095: last_updated_by = fnd_global.user_id,

8091:
8092: Forall i in 1..top_line_id.count
8093: UPDATE oks_k_lines_tl
8094: SET invoice_text = inv_text(i),
8095: last_updated_by = fnd_global.user_id,
8096: last_update_date = SYSDATE,
8097: last_update_login = fnd_global.login_id
8098: WHERE id = (select id from oks_k_lines_b
8099: where cle_id = top_line_id(i));

Line 8097: last_update_login = fnd_global.login_id

8093: UPDATE oks_k_lines_tl
8094: SET invoice_text = inv_text(i),
8095: last_updated_by = fnd_global.user_id,
8096: last_update_date = SYSDATE,
8097: last_update_login = fnd_global.login_id
8098: WHERE id = (select id from oks_k_lines_b
8099: where cle_id = top_line_id(i));
8100: -- Update Header dates
8101: header_id.delete;

Line 8114: last_updated_by = fnd_global.user_id,

8110: UPDATE okc_k_headers_all_b
8111: SET start_date = Hdr_new_Sdate(i),
8112: end_date = Hdr_new_edate(i),
8113: sts_code = get_status (Hdr_new_Sdate(i), Hdr_new_edate(i)),
8114: last_updated_by = fnd_global.user_id,
8115: last_update_date = SYSDATE,
8116: last_update_login = fnd_global.login_id
8117: WHERE ID = header_id(i);
8118:

Line 8116: last_update_login = fnd_global.login_id

8112: end_date = Hdr_new_edate(i),
8113: sts_code = get_status (Hdr_new_Sdate(i), Hdr_new_edate(i)),
8114: last_updated_by = fnd_global.user_id,
8115: last_update_date = SYSDATE,
8116: last_update_login = fnd_global.login_id
8117: WHERE ID = header_id(i);
8118:
8119:
8120: --Update status in contacts table

Line 8148: , fnd_global.user_id

8144: SELECT max(chr_id ),
8145: max(major_version) major_version,
8146: max(minor_version) minor_version,
8147: max(object_version_number) object_version_number
8148: , fnd_global.user_id
8149: , SYSDATE
8150: , fnd_global.user_id
8151: , SYSDATE
8152: , fnd_global.login_id

Line 8150: , fnd_global.user_id

8146: max(minor_version) minor_version,
8147: max(object_version_number) object_version_number
8148: , fnd_global.user_id
8149: , SYSDATE
8150: , fnd_global.user_id
8151: , SYSDATE
8152: , fnd_global.login_id
8153: FROM OKC_K_VERS_NUMBERS
8154: WHERE chr_id = header_id(i)

Line 8152: , fnd_global.login_id

8148: , fnd_global.user_id
8149: , SYSDATE
8150: , fnd_global.user_id
8151: , SYSDATE
8152: , fnd_global.login_id
8153: FROM OKC_K_VERS_NUMBERS
8154: WHERE chr_id = header_id(i)
8155: );
8156: End If;

Line 8162: last_updated_by = fnd_global.user_id,

8158: FORALL i IN 1 .. header_id.COUNT
8159: UPDATE OKC_K_VERS_NUMBERS
8160: SET minor_version = minor_version+1,
8161: object_version_number = object_version_number+1,
8162: last_updated_by = fnd_global.user_id,
8163: last_update_date = SYSDATE,
8164: last_update_login = fnd_global.login_id
8165: WHERE chr_ID = header_id(i);
8166:

Line 8164: last_update_login = fnd_global.login_id

8160: SET minor_version = minor_version+1,
8161: object_version_number = object_version_number+1,
8162: last_updated_by = fnd_global.user_id,
8163: last_update_date = SYSDATE,
8164: last_update_login = fnd_global.login_id
8165: WHERE chr_ID = header_id(i);
8166:
8167: -- Update coverage effectivity
8168: FOR i in 1..top_line_id.count

Line 8223: fnd_global.user_id,

8219: 'IDC',
8220: transaction_date (1),
8221: b.instance_number,
8222: NULL, -- parameter
8223: fnd_global.user_id,
8224: SYSDATE,
8225: fnd_global.user_id,
8226: SYSDATE,
8227: fnd_global.login_id,

Line 8225: fnd_global.user_id,

8221: b.instance_number,
8222: NULL, -- parameter
8223: fnd_global.user_id,
8224: SYSDATE,
8225: fnd_global.user_id,
8226: SYSDATE,
8227: fnd_global.login_id,
8228: p_batch_id
8229: FROM oks_instance_k_dtls_temp a,

Line 8227: fnd_global.login_id,

8223: fnd_global.user_id,
8224: SYSDATE,
8225: fnd_global.user_id,
8226: SYSDATE,
8227: fnd_global.login_id,
8228: p_batch_id
8229: FROM oks_instance_k_dtls_temp a,
8230: csi_item_instances b
8231: WHERE a.instance_id = b.instance_id);

Line 8311: fnd_global.user_id,

8307: hdr_sts (i),
8308: hdr.sts_code,
8309: null, -- subline_date_terminated,
8310: 1,
8311: fnd_global.user_id,
8312: SYSDATE,
8313: fnd_global.user_id,
8314: SYSDATE,
8315: fnd_global.login_id,

Line 8313: fnd_global.user_id,

8309: null, -- subline_date_terminated,
8310: 1,
8311: fnd_global.user_id,
8312: SYSDATE,
8313: fnd_global.user_id,
8314: SYSDATE,
8315: fnd_global.login_id,
8316: null
8317: FROM oks_instance_history a, Okc_k_headers_all_b hdr

Line 8315: fnd_global.login_id,

8311: fnd_global.user_id,
8312: SYSDATE,
8313: fnd_global.user_id,
8314: SYSDATE,
8315: fnd_global.login_id,
8316: null
8317: FROM oks_instance_history a, Okc_k_headers_all_b hdr
8318: , okc_k_lines_b line
8319: , okc_k_lines_b subline

Line 8558: fnd_global.user_id,

8554: 'TRM',
8555: transaction_date (1),
8556: b.instance_number,
8557: NULL, -- parameter
8558: fnd_global.user_id,
8559: SYSDATE,
8560: fnd_global.user_id,
8561: SYSDATE,
8562: fnd_global.login_id,

Line 8560: fnd_global.user_id,

8556: b.instance_number,
8557: NULL, -- parameter
8558: fnd_global.user_id,
8559: SYSDATE,
8560: fnd_global.user_id,
8561: SYSDATE,
8562: fnd_global.login_id,
8563: p_batch_id
8564: FROM oks_instance_temp a,

Line 8562: fnd_global.login_id,

8558: fnd_global.user_id,
8559: SYSDATE,
8560: fnd_global.user_id,
8561: SYSDATE,
8562: fnd_global.login_id,
8563: p_batch_id
8564: FROM oks_instance_temp a,
8565: csi_item_instances b
8566: WHERE a.old_customer_product_id = b.instance_id);

Line 8646: fnd_global.user_id,

8642: hdr_sts (i),
8643: hdr.sts_code,
8644: line.date_terminated, -- subline_date_terminated,
8645: 1,
8646: fnd_global.user_id,
8647: SYSDATE,
8648: fnd_global.user_id,
8649: SYSDATE,
8650: fnd_global.login_id,

Line 8648: fnd_global.user_id,

8644: line.date_terminated, -- subline_date_terminated,
8645: 1,
8646: fnd_global.user_id,
8647: SYSDATE,
8648: fnd_global.user_id,
8649: SYSDATE,
8650: fnd_global.login_id,
8651: line.date_cancelled
8652: FROM oks_instance_history a,

Line 8650: fnd_global.login_id,

8646: fnd_global.user_id,
8647: SYSDATE,
8648: fnd_global.user_id,
8649: SYSDATE,
8650: fnd_global.login_id,
8651: line.date_cancelled
8652: FROM oks_instance_history a,
8653: Okc_k_lines_b line,
8654: Okc_k_headers_all_b hdr