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 1155: p_entered_by => fnd_global.user_id,

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

Line 1159: p_created_by => fnd_global.user_id,

1155: p_entered_by => fnd_global.user_id,
1156: p_entered_date => SYSDATE,
1157: x_jtf_note_id => l_jtf_note_id,
1158: p_creation_date => SYSDATE,
1159: p_created_by => fnd_global.user_id,
1160: p_last_update_date => SYSDATE,
1161: p_last_updated_by => fnd_global.user_id,
1162: p_last_update_login => fnd_global.login_id,
1163: p_attribute1 => NULL,

Line 1161: p_last_updated_by => fnd_global.user_id,

1157: x_jtf_note_id => l_jtf_note_id,
1158: p_creation_date => SYSDATE,
1159: p_created_by => fnd_global.user_id,
1160: p_last_update_date => SYSDATE,
1161: p_last_updated_by => fnd_global.user_id,
1162: p_last_update_login => fnd_global.login_id,
1163: p_attribute1 => NULL,
1164: p_attribute2 => NULL,
1165: p_attribute3 => NULL,

Line 1162: p_last_update_login => fnd_global.login_id,

1158: p_creation_date => SYSDATE,
1159: p_created_by => fnd_global.user_id,
1160: p_last_update_date => SYSDATE,
1161: p_last_updated_by => fnd_global.user_id,
1162: p_last_update_login => fnd_global.login_id,
1163: p_attribute1 => NULL,
1164: p_attribute2 => NULL,
1165: p_attribute3 => NULL,
1166: p_attribute4 => NULL,

Line 1474: OR user_id = fnd_global.user_id;

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

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

2376: l_chrv_tbl_in (i).attribute15 := '';
2377: l_chrv_tbl_in (i).renewal_type_code := '';
2378: l_chrv_tbl_in (i).renewal_notify_to := NULL;
2379: l_chrv_tbl_in (i).renewal_end_date := NULL;
2380: l_chrv_tbl_in (i).created_by := fnd_global.user_id;
2381: l_chrv_tbl_in (i).creation_date := SYSDATE;
2382: l_chrv_tbl_in (i).last_updated_by := fnd_global.user_id;
2383: l_chrv_tbl_in (i).last_update_date := SYSDATE;
2384: l_chrv_tbl_in (i).last_update_login := fnd_global.login_id;

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

2378: l_chrv_tbl_in (i).renewal_notify_to := NULL;
2379: l_chrv_tbl_in (i).renewal_end_date := NULL;
2380: l_chrv_tbl_in (i).created_by := fnd_global.user_id;
2381: l_chrv_tbl_in (i).creation_date := SYSDATE;
2382: l_chrv_tbl_in (i).last_updated_by := fnd_global.user_id;
2383: l_chrv_tbl_in (i).last_update_date := SYSDATE;
2384: l_chrv_tbl_in (i).last_update_login := fnd_global.login_id;
2385: l_chrv_tbl_in (i).cust_acct_id := NULL;
2386: l_chrv_tbl_in (i).payment_instruction_type := '';

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

2380: l_chrv_tbl_in (i).created_by := fnd_global.user_id;
2381: l_chrv_tbl_in (i).creation_date := SYSDATE;
2382: l_chrv_tbl_in (i).last_updated_by := fnd_global.user_id;
2383: l_chrv_tbl_in (i).last_update_date := SYSDATE;
2384: l_chrv_tbl_in (i).last_update_login := fnd_global.login_id;
2385: l_chrv_tbl_in (i).cust_acct_id := NULL;
2386: l_chrv_tbl_in (i).payment_instruction_type := '';
2387:
2388: IF p_batch_rules.bill_address_id Is Not Null Then

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

2456:
2457: l_cpsv_tbl_in (i).ID := okc_p_util.raw_to_number (SYS_GUID ());
2458: l_cpsv_tbl_in (i).chr_id := hdr_id (i);
2459: l_cpsv_tbl_in (i).pdf_id := setup_attr.pdf_id;
2460: l_cpsv_tbl_in (i).user_id := fnd_global.user_id;
2461: l_cpsv_tbl_in (i).created_by := fnd_global.user_id;
2462: l_cpsv_tbl_in (i).creation_date := SYSDATE;
2463: l_cpsv_tbl_in (i).last_updated_by := fnd_global.user_id;
2464: l_cpsv_tbl_in (i).last_update_date := SYSDATE;

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

2457: l_cpsv_tbl_in (i).ID := okc_p_util.raw_to_number (SYS_GUID ());
2458: l_cpsv_tbl_in (i).chr_id := hdr_id (i);
2459: l_cpsv_tbl_in (i).pdf_id := setup_attr.pdf_id;
2460: l_cpsv_tbl_in (i).user_id := fnd_global.user_id;
2461: l_cpsv_tbl_in (i).created_by := fnd_global.user_id;
2462: l_cpsv_tbl_in (i).creation_date := SYSDATE;
2463: l_cpsv_tbl_in (i).last_updated_by := fnd_global.user_id;
2464: l_cpsv_tbl_in (i).last_update_date := SYSDATE;
2465: l_cpsv_tbl_in (i).object_version_number := 1;

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

2459: l_cpsv_tbl_in (i).pdf_id := setup_attr.pdf_id;
2460: l_cpsv_tbl_in (i).user_id := fnd_global.user_id;
2461: l_cpsv_tbl_in (i).created_by := fnd_global.user_id;
2462: l_cpsv_tbl_in (i).creation_date := SYSDATE;
2463: l_cpsv_tbl_in (i).last_updated_by := fnd_global.user_id;
2464: l_cpsv_tbl_in (i).last_update_date := SYSDATE;
2465: l_cpsv_tbl_in (i).object_version_number := 1;
2466: l_cpsv_tbl_in (i).crt_id := NULL;
2467: l_cpsv_tbl_in (i).process_id := NULL;

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

2481: l_cpsv_tbl_in (i).attribute12 := '';
2482: l_cpsv_tbl_in (i).attribute13 := '';
2483: l_cpsv_tbl_in (i).attribute14 := '';
2484: l_cpsv_tbl_in (i).attribute15 := '';
2485: l_cpsv_tbl_in (i).last_update_login := fnd_global.login_id;
2486: END IF;
2487: -- create contract group
2488: IF setup_attr.cgp_new_id IS NOT NULL
2489: THEN

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

2499: l_cgcv_tbl_in (i).cgp_parent_id := setup_attr.cgp_new_id;
2500: l_cgcv_tbl_in (i).included_chr_id := hdr_id (i);
2501: l_cgcv_tbl_in (i).object_version_number := 1;
2502: l_cgcv_tbl_in (i).scs_code := hdr_scs_code (i);
2503: l_cgcv_tbl_in (i).created_by := fnd_global.user_id;
2504: l_cgcv_tbl_in (i).creation_date := SYSDATE;
2505: l_cgcv_tbl_in (i).last_updated_by := fnd_global.user_id;
2506: l_cgcv_tbl_in (i).last_update_date := SYSDATE;
2507: l_cgcv_tbl_in (i).last_update_login := fnd_global.login_id;

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

2501: l_cgcv_tbl_in (i).object_version_number := 1;
2502: l_cgcv_tbl_in (i).scs_code := hdr_scs_code (i);
2503: l_cgcv_tbl_in (i).created_by := fnd_global.user_id;
2504: l_cgcv_tbl_in (i).creation_date := SYSDATE;
2505: l_cgcv_tbl_in (i).last_updated_by := fnd_global.user_id;
2506: l_cgcv_tbl_in (i).last_update_date := SYSDATE;
2507: l_cgcv_tbl_in (i).last_update_login := fnd_global.login_id;
2508: END IF;
2509:

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

2503: l_cgcv_tbl_in (i).created_by := fnd_global.user_id;
2504: l_cgcv_tbl_in (i).creation_date := SYSDATE;
2505: l_cgcv_tbl_in (i).last_updated_by := fnd_global.user_id;
2506: l_cgcv_tbl_in (i).last_update_date := SYSDATE;
2507: l_cgcv_tbl_in (i).last_update_login := fnd_global.login_id;
2508: END IF;
2509:
2510: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2511: THEN

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

2556: l_cpl_tbl_in (j).attribute12 := '';
2557: l_cpl_tbl_in (j).attribute13 := '';
2558: l_cpl_tbl_in (j).attribute14 := '';
2559: l_cpl_tbl_in (j).attribute15 := '';
2560: l_cpl_tbl_in (j).created_by := fnd_global.user_id;
2561: l_cpl_tbl_in (j).creation_date := SYSDATE;
2562: l_cpl_tbl_in (j).last_updated_by := fnd_global.user_id;
2563: l_cpl_tbl_in (j).last_update_date := SYSDATE;
2564: l_cpl_tbl_in (j).last_update_login := fnd_global.login_id;

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

2558: l_cpl_tbl_in (j).attribute14 := '';
2559: l_cpl_tbl_in (j).attribute15 := '';
2560: l_cpl_tbl_in (j).created_by := fnd_global.user_id;
2561: l_cpl_tbl_in (j).creation_date := SYSDATE;
2562: l_cpl_tbl_in (j).last_updated_by := fnd_global.user_id;
2563: l_cpl_tbl_in (j).last_update_date := SYSDATE;
2564: l_cpl_tbl_in (j).last_update_login := fnd_global.login_id;
2565: If l_lse_id <> 14 Then
2566: If NVL(fnd_profile.value('OKS_USE_JTF'),'NO') = 'YES' Then

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

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

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

2674: l_ctcv_tbl_in (k).attribute12 := '';
2675: l_ctcv_tbl_in (k).attribute13 := '';
2676: l_ctcv_tbl_in (k).attribute14 := '';
2677: l_ctcv_tbl_in (k).attribute15 := '';
2678: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2679: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2680: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2681: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2682: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;

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

2676: l_ctcv_tbl_in (k).attribute14 := '';
2677: l_ctcv_tbl_in (k).attribute15 := '';
2678: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2679: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2680: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2681: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2682: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2683: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2684: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);

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

2678: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2679: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2680: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2681: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2682: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2683: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2684: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);
2685:
2686:

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

2731: l_cpl_tbl_in (j + 1).attribute12 := '';
2732: l_cpl_tbl_in (j + 1).attribute13 := '';
2733: l_cpl_tbl_in (j + 1).attribute14 := '';
2734: l_cpl_tbl_in (j + 1).attribute15 := '';
2735: l_cpl_tbl_in (j + 1).created_by := fnd_global.user_id;
2736: l_cpl_tbl_in (j + 1).creation_date := SYSDATE;
2737: l_cpl_tbl_in (j + 1).last_updated_by := fnd_global.user_id;
2738: l_cpl_tbl_in (j + 1).last_update_date := SYSDATE;
2739: l_cpl_tbl_in (j + 1).last_update_login := fnd_global.login_id;

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

2733: l_cpl_tbl_in (j + 1).attribute14 := '';
2734: l_cpl_tbl_in (j + 1).attribute15 := '';
2735: l_cpl_tbl_in (j + 1).created_by := fnd_global.user_id;
2736: l_cpl_tbl_in (j + 1).creation_date := SYSDATE;
2737: l_cpl_tbl_in (j + 1).last_updated_by := fnd_global.user_id;
2738: l_cpl_tbl_in (j + 1).last_update_date := SYSDATE;
2739: l_cpl_tbl_in (j + 1).last_update_login := fnd_global.login_id;
2740:
2741: IF p_batch_rules.bill_contact_id IS NOT NULL

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

2735: l_cpl_tbl_in (j + 1).created_by := fnd_global.user_id;
2736: l_cpl_tbl_in (j + 1).creation_date := SYSDATE;
2737: l_cpl_tbl_in (j + 1).last_updated_by := fnd_global.user_id;
2738: l_cpl_tbl_in (j + 1).last_update_date := SYSDATE;
2739: l_cpl_tbl_in (j + 1).last_update_login := fnd_global.login_id;
2740:
2741: IF p_batch_rules.bill_contact_id IS NOT NULL
2742: THEN
2743: IF check_acct_not_related(p_batch_rules.new_party_id,

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

2792: l_cpl_tbl_in (j + 2).attribute12 := '';
2793: l_cpl_tbl_in (j + 2).attribute13 := '';
2794: l_cpl_tbl_in (j + 2).attribute14 := '';
2795: l_cpl_tbl_in (j + 2).attribute15 := '';
2796: l_cpl_tbl_in (j + 2).created_by := fnd_global.user_id;
2797: l_cpl_tbl_in (j + 2).creation_date := SYSDATE;
2798: l_cpl_tbl_in (j + 2).last_updated_by := fnd_global.user_id;
2799: l_cpl_tbl_in (j + 2).last_update_date := SYSDATE;
2800: l_cpl_tbl_in (j + 2).last_update_login := fnd_global.login_id;

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

2794: l_cpl_tbl_in (j + 2).attribute14 := '';
2795: l_cpl_tbl_in (j + 2).attribute15 := '';
2796: l_cpl_tbl_in (j + 2).created_by := fnd_global.user_id;
2797: l_cpl_tbl_in (j + 2).creation_date := SYSDATE;
2798: l_cpl_tbl_in (j + 2).last_updated_by := fnd_global.user_id;
2799: l_cpl_tbl_in (j + 2).last_update_date := SYSDATE;
2800: l_cpl_tbl_in (j + 2).last_update_login := fnd_global.login_id;
2801:
2802:

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

2796: l_cpl_tbl_in (j + 2).created_by := fnd_global.user_id;
2797: l_cpl_tbl_in (j + 2).creation_date := SYSDATE;
2798: l_cpl_tbl_in (j + 2).last_updated_by := fnd_global.user_id;
2799: l_cpl_tbl_in (j + 2).last_update_date := SYSDATE;
2800: l_cpl_tbl_in (j + 2).last_update_login := fnd_global.login_id;
2801:
2802:
2803: l_ctcv_tbl_in (k).ID := okc_p_util.raw_to_number (SYS_GUID ());
2804: l_ctcv_tbl_in (k).object_version_number := 1;

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

2827: l_ctcv_tbl_in (k).attribute12 := '';
2828: l_ctcv_tbl_in (k).attribute13 := '';
2829: l_ctcv_tbl_in (k).attribute14 := '';
2830: l_ctcv_tbl_in (k).attribute15 := '';
2831: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2832: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2833: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2834: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2835: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;

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

2829: l_ctcv_tbl_in (k).attribute14 := '';
2830: l_ctcv_tbl_in (k).attribute15 := '';
2831: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2832: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2833: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2834: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2835: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2836: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2837: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);

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

2831: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2832: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2833: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2834: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2835: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2836: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2837: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);
2838: j := j + 3;
2839: ELSE

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

2871: l_ctcv_tbl_in (k).attribute12 := '';
2872: l_ctcv_tbl_in (k).attribute13 := '';
2873: l_ctcv_tbl_in (k).attribute14 := '';
2874: l_ctcv_tbl_in (k).attribute15 := '';
2875: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2876: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2877: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2878: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2879: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;

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

2873: l_ctcv_tbl_in (k).attribute14 := '';
2874: l_ctcv_tbl_in (k).attribute15 := '';
2875: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2876: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2877: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2878: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2879: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2880: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2881: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);

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

2875: l_ctcv_tbl_in (k).created_by := fnd_global.user_id;
2876: l_ctcv_tbl_in (k).creation_date := SYSDATE;
2877: l_ctcv_tbl_in (k).last_updated_by := fnd_global.user_id;
2878: l_ctcv_tbl_in (k).last_update_date := SYSDATE;
2879: l_ctcv_tbl_in (k).last_update_login := fnd_global.login_id;
2880: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2881: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);
2882: K := K + 1;
2883: j := j + 2;

Line 2959: fnd_global.user_id,

2955: hdr_sum_trx (i),
2956: 1,
2957: hdr_period_start(i),
2958: hdr_period_type(i),
2959: fnd_global.user_id,
2960: sysdate,
2961: fnd_global.user_id,
2962: sysdate,
2963: fnd_global.login_id,

Line 2961: fnd_global.user_id,

2957: hdr_period_start(i),
2958: hdr_period_type(i),
2959: fnd_global.user_id,
2960: sysdate,
2961: fnd_global.user_id,
2962: sysdate,
2963: fnd_global.login_id,
2964: renewal_status(i),
2965: price_uom(i));

Line 2963: fnd_global.login_id,

2959: fnd_global.user_id,
2960: sysdate,
2961: fnd_global.user_id,
2962: sysdate,
2963: fnd_global.login_id,
2964: renewal_status(i),
2965: price_uom(i));
2966:
2967: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks header table records sucessfully');

Line 3129: fnd_global.user_id,

3125: groupid (i),
3126: resource_id (i),
3127: access_level (i),
3128: 1,
3129: fnd_global.user_id,
3130: SYSDATE,
3131: fnd_global.user_id,
3132: SYSDATE,
3133: fnd_global.user_id

Line 3131: fnd_global.user_id,

3127: access_level (i),
3128: 1,
3129: fnd_global.user_id,
3130: SYSDATE,
3131: fnd_global.user_id,
3132: SYSDATE,
3133: fnd_global.user_id
3134: );
3135: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');

Line 3133: fnd_global.user_id

3129: fnd_global.user_id,
3130: SYSDATE,
3131: fnd_global.user_id,
3132: SYSDATE,
3133: fnd_global.user_id
3134: );
3135: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');
3136:
3137: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 3184: fnd_global.user_id,

3180: ctc_id (i),
3181: sales_credit_type_id1 (i),
3182: '#',
3183: 1,
3184: fnd_global.user_id,
3185: SYSDATE,
3186: fnd_global.user_id,
3187: SYSDATE
3188: );

Line 3186: fnd_global.user_id,

3182: '#',
3183: 1,
3184: fnd_global.user_id,
3185: SYSDATE,
3186: fnd_global.user_id,
3187: SYSDATE
3188: );
3189: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3190:

Line 3459: fnd_global.user_id,

3455: -- DECODE(line_sts(i),'ENTERED',get_status_code('ENTERED'),p_batch_rules.contract_status)),
3456: lse_id (i),
3457: 'N',
3458: 1,
3459: fnd_global.user_id,
3460: SYSDATE,
3461: fnd_global.user_id,
3462: SYSDATE,
3463: 0,

Line 3461: fnd_global.user_id,

3457: 'N',
3458: 1,
3459: fnd_global.user_id,
3460: SYSDATE,
3461: fnd_global.user_id,
3462: SYSDATE,
3463: 0,
3464: 'N',
3465: 0,

Line 3467: fnd_global.user_id,

3463: 0,
3464: 'N',
3465: 0,
3466: srv_curr (i),
3467: fnd_global.user_id,
3468: new_sdt (i),
3469: new_edt (i),
3470: srv_pl (i),
3471:

Line 3526: fnd_global.user_id,

3522: okc_util.get_userenv_lang,
3523: 'N',
3524: null,
3525: null,
3526: fnd_global.user_id,
3527: SYSDATE,
3528: fnd_global.user_id,
3529: SYSDATE,
3530: fnd_global.user_id

Line 3528: fnd_global.user_id,

3524: null,
3525: null,
3526: fnd_global.user_id,
3527: SYSDATE,
3528: fnd_global.user_id,
3529: SYSDATE,
3530: fnd_global.user_id
3531: );
3532: END LOOP;

Line 3530: fnd_global.user_id

3526: fnd_global.user_id,
3527: SYSDATE,
3528: fnd_global.user_id,
3529: SYSDATE,
3530: fnd_global.user_id
3531: );
3532: END LOOP;
3533: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc tl table records sucessfully');
3534:

Line 3582: fnd_global.user_id,

3578: uom_code (i),
3579: 'N',
3580: number_of_items (i),
3581: 1,
3582: fnd_global.user_id,
3583: SYSDATE,
3584: fnd_global.user_id,
3585: SYSDATE,
3586: fnd_global.login_id,

Line 3584: fnd_global.user_id,

3580: number_of_items (i),
3581: 1,
3582: fnd_global.user_id,
3583: SYSDATE,
3584: fnd_global.user_id,
3585: SYSDATE,
3586: fnd_global.login_id,
3587: NULL,
3588: NULL,

Line 3586: fnd_global.login_id,

3582: fnd_global.user_id,
3583: SYSDATE,
3584: fnd_global.user_id,
3585: SYSDATE,
3586: fnd_global.login_id,
3587: NULL,
3588: NULL,
3589: NULL,
3590: NULL,

Line 3629: fnd_global.user_id,

3625: contract_id (i),
3626: p_batch_rules.accounting_rule,
3627: tax_code (i),
3628: 1,
3629: fnd_global.user_id,
3630: SYSDATE,
3631: fnd_global.user_id,
3632: SYSDATE,
3633: fnd_global.login_id,

Line 3631: fnd_global.user_id,

3627: tax_code (i),
3628: 1,
3629: fnd_global.user_id,
3630: SYSDATE,
3631: fnd_global.user_id,
3632: SYSDATE,
3633: fnd_global.login_id,
3634: coverage_id (i),
3635: stand_cov_yn (i),

Line 3633: fnd_global.login_id,

3629: fnd_global.user_id,
3630: SYSDATE,
3631: fnd_global.user_id,
3632: SYSDATE,
3633: fnd_global.login_id,
3634: coverage_id (i),
3635: stand_cov_yn (i),
3636: price_uom(i)
3637: );

Line 3669: fnd_global.user_id,

3665: okc_util.g_language_code (lang_i),
3666: okc_util.get_userenv_lang,
3667: 'N',
3668: (substr(srv_inv_text(i),1,instr(srv_inv_text(i),':',1,1))|| new_sdt (i)||' - '|| new_edt (i)),
3669: fnd_global.user_id,
3670: SYSDATE,
3671: fnd_global.user_id,
3672: SYSDATE,
3673: fnd_global.user_id

Line 3671: fnd_global.user_id,

3667: 'N',
3668: (substr(srv_inv_text(i),1,instr(srv_inv_text(i),':',1,1))|| new_sdt (i)||' - '|| new_edt (i)),
3669: fnd_global.user_id,
3670: SYSDATE,
3671: fnd_global.user_id,
3672: SYSDATE,
3673: fnd_global.user_id
3674: );
3675: END LOOP;

Line 3673: fnd_global.user_id

3669: fnd_global.user_id,
3670: SYSDATE,
3671: fnd_global.user_id,
3672: SYSDATE,
3673: fnd_global.user_id
3674: );
3675: END LOOP;
3676:
3677: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks tl table records sucessfully');

Line 3723: fnd_global.user_id,

3719: ctc_id (i),
3720: sales_credit_type_id1 (i),
3721: '#',
3722: 1,
3723: fnd_global.user_id,
3724: SYSDATE,
3725: fnd_global.user_id,
3726: SYSDATE
3727: );

Line 3725: fnd_global.user_id,

3721: '#',
3722: 1,
3723: fnd_global.user_id,
3724: SYSDATE,
3725: fnd_global.user_id,
3726: SYSDATE
3727: );
3728: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3729:

Line 3959: fnd_global.user_id,

3955: -- DECODE(subline_sts(i),'ENTERED',get_status_code('ENTERED'),p_batch_rules.contract_status)),
3956: lse_id (i),
3957: 'N',
3958: 1,
3959: fnd_global.user_id,
3960: SYSDATE,
3961: fnd_global.user_id,
3962: SYSDATE,
3963: NVL(price_negotiated (i),0), -- price_negotiated

Line 3961: fnd_global.user_id,

3957: 'N',
3958: 1,
3959: fnd_global.user_id,
3960: SYSDATE,
3961: fnd_global.user_id,
3962: SYSDATE,
3963: NVL(price_negotiated (i),0), -- price_negotiated
3964: 'Y',
3965: NVL(unit_price (i),0), -- unit price

Line 3967: fnd_global.user_id,

3963: NVL(price_negotiated (i),0), -- price_negotiated
3964: 'Y',
3965: NVL(unit_price (i),0), -- unit price
3966: subline_curr (i),
3967: fnd_global.user_id,
3968: subline_sdate (i),
3969: subline_edate (i),
3970: renewal_type (i),
3971: Oks_setup_util_pub.Get_Annualized_Factor(subline_sdate (i),

Line 4009: fnd_global.user_id,

4005: okc_util.get_userenv_lang,
4006: 'N',
4007: null,
4008: null,
4009: fnd_global.user_id,
4010: SYSDATE,
4011: fnd_global.user_id,
4012: SYSDATE,
4013: fnd_global.user_id

Line 4011: fnd_global.user_id,

4007: null,
4008: null,
4009: fnd_global.user_id,
4010: SYSDATE,
4011: fnd_global.user_id,
4012: SYSDATE,
4013: fnd_global.user_id
4014: );
4015: END LOOP;

Line 4013: fnd_global.user_id

4009: fnd_global.user_id,
4010: SYSDATE,
4011: fnd_global.user_id,
4012: SYSDATE,
4013: fnd_global.user_id
4014: );
4015: END LOOP;
4016: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line tl table records sucessfully');
4017:

Line 4065: fnd_global.user_id,

4061: uom_code (i),
4062: 'N',
4063: number_of_items (i),
4064: 1,
4065: fnd_global.user_id,
4066: SYSDATE,
4067: fnd_global.user_id,
4068: SYSDATE,
4069: fnd_global.user_id,

Line 4067: fnd_global.user_id,

4063: number_of_items (i),
4064: 1,
4065: fnd_global.user_id,
4066: SYSDATE,
4067: fnd_global.user_id,
4068: SYSDATE,
4069: fnd_global.user_id,
4070: NULL,
4071: NULL,

Line 4069: fnd_global.user_id,

4065: fnd_global.user_id,
4066: SYSDATE,
4067: fnd_global.user_id,
4068: SYSDATE,
4069: fnd_global.user_id,
4070: NULL,
4071: NULL,
4072: NULL,
4073: NULL,

Line 4112: fnd_global.user_id,

4108: price_uom(i),
4109: toplvl_price(i),
4110: toplvl_uom(i),
4111: 1,
4112: fnd_global.user_id,
4113: SYSDATE,
4114: fnd_global.user_id,
4115: SYSDATE,
4116: fnd_global.user_id

Line 4114: fnd_global.user_id,

4110: toplvl_uom(i),
4111: 1,
4112: fnd_global.user_id,
4113: SYSDATE,
4114: fnd_global.user_id,
4115: SYSDATE,
4116: fnd_global.user_id
4117: );
4118: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');

Line 4116: fnd_global.user_id

4112: fnd_global.user_id,
4113: SYSDATE,
4114: fnd_global.user_id,
4115: SYSDATE,
4116: fnd_global.user_id
4117: );
4118: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
4119:
4120: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 4150: fnd_global.user_id,

4146: okc_util.get_userenv_lang,
4147: 'N',
4148: 'Subline created from transfers',
4149: (substr(sl_inv_text(i),1,instr(sl_inv_text(i),':',1,3))||subline_sdate(i)||' - '|| subline_edate(i)),
4150: fnd_global.user_id,
4151: SYSDATE,
4152: fnd_global.user_id,
4153: SYSDATE,
4154: fnd_global.user_id

Line 4152: fnd_global.user_id,

4148: 'Subline created from transfers',
4149: (substr(sl_inv_text(i),1,instr(sl_inv_text(i),':',1,3))||subline_sdate(i)||' - '|| subline_edate(i)),
4150: fnd_global.user_id,
4151: SYSDATE,
4152: fnd_global.user_id,
4153: SYSDATE,
4154: fnd_global.user_id
4155: );
4156: END LOOP;

Line 4154: fnd_global.user_id

4150: fnd_global.user_id,
4151: SYSDATE,
4152: fnd_global.user_id,
4153: SYSDATE,
4154: fnd_global.user_id
4155: );
4156: END LOOP;
4157:
4158: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line tl table records sucessfully');

Line 5282: p_entered_by => fnd_global.user_id,

5278: p_notes => l_notes_tbl (m).notes,
5279: p_notes_detail => l_notes_tbl (m).notes_detail,
5280: p_note_status => l_notes_tbl (m).note_status,
5281: p_note_type => l_notes_tbl (m).note_type,
5282: p_entered_by => fnd_global.user_id,
5283: p_entered_date => SYSDATE,
5284: x_jtf_note_id => l_jtf_note_id,
5285: p_creation_date => SYSDATE,
5286: p_created_by => fnd_global.user_id,

Line 5286: p_created_by => fnd_global.user_id,

5282: p_entered_by => fnd_global.user_id,
5283: p_entered_date => SYSDATE,
5284: x_jtf_note_id => l_jtf_note_id,
5285: p_creation_date => SYSDATE,
5286: p_created_by => fnd_global.user_id,
5287: p_last_update_date => SYSDATE,
5288: p_last_updated_by => fnd_global.user_id,
5289: p_last_update_login => fnd_global.login_id,
5290: p_attribute1 => NULL,

Line 5288: p_last_updated_by => fnd_global.user_id,

5284: x_jtf_note_id => l_jtf_note_id,
5285: p_creation_date => SYSDATE,
5286: p_created_by => fnd_global.user_id,
5287: p_last_update_date => SYSDATE,
5288: p_last_updated_by => fnd_global.user_id,
5289: p_last_update_login => fnd_global.login_id,
5290: p_attribute1 => NULL,
5291: p_attribute2 => NULL,
5292: p_attribute3 => NULL,

Line 5289: p_last_update_login => fnd_global.login_id,

5285: p_creation_date => SYSDATE,
5286: p_created_by => fnd_global.user_id,
5287: p_last_update_date => SYSDATE,
5288: p_last_updated_by => fnd_global.user_id,
5289: p_last_update_login => fnd_global.login_id,
5290: p_attribute1 => NULL,
5291: p_attribute2 => NULL,
5292: p_attribute3 => NULL,
5293: p_attribute4 => NULL,

Line 7181: fnd_global.user_id,

7177: 'TRF',
7178: a.transaction_date,
7179: b.instance_number,
7180: NULL, -- parameter
7181: fnd_global.user_id,
7182: SYSDATE,
7183: fnd_global.user_id,
7184: SYSDATE,
7185: fnd_global.login_id,

Line 7183: fnd_global.user_id,

7179: b.instance_number,
7180: NULL, -- parameter
7181: fnd_global.user_id,
7182: SYSDATE,
7183: fnd_global.user_id,
7184: SYSDATE,
7185: fnd_global.login_id,
7186: p_batch_id
7187: FROM oks_instance_temp a,

Line 7185: fnd_global.login_id,

7181: fnd_global.user_id,
7182: SYSDATE,
7183: fnd_global.user_id,
7184: SYSDATE,
7185: fnd_global.login_id,
7186: p_batch_id
7187: FROM oks_instance_temp a,
7188: csi_item_instances b
7189: WHERE a.old_customer_product_id = b.instance_id);

Line 7275: fnd_global.user_id,

7271: hdr_sts (i),
7272: hdr.sts_code,
7273: lines_b.date_terminated, -- subline_date_terminated,
7274: 1,
7275: fnd_global.user_id,
7276: SYSDATE,
7277: fnd_global.user_id,
7278: SYSDATE,
7279: fnd_global.login_id,

Line 7277: fnd_global.user_id,

7273: lines_b.date_terminated, -- subline_date_terminated,
7274: 1,
7275: fnd_global.user_id,
7276: SYSDATE,
7277: fnd_global.user_id,
7278: SYSDATE,
7279: fnd_global.login_id,
7280: lines_b.date_cancelled, --Date cancelled,
7281: 'TERM'

Line 7279: fnd_global.login_id,

7275: fnd_global.user_id,
7276: SYSDATE,
7277: fnd_global.user_id,
7278: SYSDATE,
7279: fnd_global.login_id,
7280: lines_b.date_cancelled, --Date cancelled,
7281: 'TERM'
7282: from oks_instance_history ins_hist,
7283: Okc_k_lines_b lines_b,

Line 7707: fnd_global.user_id,

7703: 'TRF',
7704: a.transaction_date,
7705: b.instance_number,
7706: NULL, -- parameter
7707: fnd_global.user_id,
7708: SYSDATE,
7709: fnd_global.user_id,
7710: SYSDATE,
7711: fnd_global.login_id,

Line 7709: fnd_global.user_id,

7705: b.instance_number,
7706: NULL, -- parameter
7707: fnd_global.user_id,
7708: SYSDATE,
7709: fnd_global.user_id,
7710: SYSDATE,
7711: fnd_global.login_id,
7712: p_batch_id
7713: FROM oks_instance_temp a,

Line 7711: fnd_global.login_id,

7707: fnd_global.user_id,
7708: SYSDATE,
7709: fnd_global.user_id,
7710: SYSDATE,
7711: fnd_global.login_id,
7712: p_batch_id
7713: FROM oks_instance_temp a,
7714: csi_item_instances b
7715: WHERE a.old_customer_product_id = b.instance_id);

Line 7796: fnd_global.user_id,

7792: hdr_sts (i),
7793: hdr.sts_code,
7794: line.date_terminated, -- subline_date_terminated,
7795: 1,
7796: fnd_global.user_id,
7797: SYSDATE,
7798: fnd_global.user_id,
7799: SYSDATE,
7800: fnd_global.login_id,

Line 7798: fnd_global.user_id,

7794: line.date_terminated, -- subline_date_terminated,
7795: 1,
7796: fnd_global.user_id,
7797: SYSDATE,
7798: fnd_global.user_id,
7799: SYSDATE,
7800: fnd_global.login_id,
7801: line.date_cancelled --Date cancelled
7802: from Oks_instance_history inshist, Okc_k_lines_b line

Line 7800: fnd_global.login_id,

7796: fnd_global.user_id,
7797: SYSDATE,
7798: fnd_global.user_id,
7799: SYSDATE,
7800: fnd_global.login_id,
7801: line.date_cancelled --Date cancelled
7802: from Oks_instance_history inshist, Okc_k_lines_b line
7803: ,okc_k_headers_all_b hdr
7804: Where inshist.instance_id = custprod_id(i)

Line 7899: fnd_global.user_id,

7895: hdr_sts (i),
7896: hdr.sts_code,--new_k_status (i),
7897: NULL, -- subline_date_terminated,
7898: 1,
7899: fnd_global.user_id,
7900: SYSDATE,
7901: fnd_global.user_id,
7902: SYSDATE,
7903: fnd_global.login_id

Line 7901: fnd_global.user_id,

7897: NULL, -- subline_date_terminated,
7898: 1,
7899: fnd_global.user_id,
7900: SYSDATE,
7901: fnd_global.user_id,
7902: SYSDATE,
7903: fnd_global.login_id
7904: from Oks_instance_history inshist
7905: , okc_k_headers_all_b hdr

Line 7903: fnd_global.login_id

7899: fnd_global.user_id,
7900: SYSDATE,
7901: fnd_global.user_id,
7902: SYSDATE,
7903: fnd_global.login_id
7904: from Oks_instance_history inshist
7905: , okc_k_headers_all_b hdr
7906: , okc_k_lines_b line
7907: , okc_k_lines_b subline

Line 8111: , fnd_global.user_id

8107: SELECT max(chr_id ),
8108: max(major_version) major_version,
8109: max(minor_version) minor_version,
8110: max(object_version_number) object_version_number
8111: , fnd_global.user_id
8112: , SYSDATE
8113: , fnd_global.user_id
8114: , SYSDATE
8115: , fnd_global.login_id

Line 8113: , fnd_global.user_id

8109: max(minor_version) minor_version,
8110: max(object_version_number) object_version_number
8111: , fnd_global.user_id
8112: , SYSDATE
8113: , fnd_global.user_id
8114: , SYSDATE
8115: , fnd_global.login_id
8116: FROM OKC_K_VERS_NUMBERS
8117: WHERE chr_id = header_id(i)

Line 8115: , fnd_global.login_id

8111: , fnd_global.user_id
8112: , SYSDATE
8113: , fnd_global.user_id
8114: , SYSDATE
8115: , fnd_global.login_id
8116: FROM OKC_K_VERS_NUMBERS
8117: WHERE chr_id = header_id(i)
8118: );
8119: End If;

Line 8183: fnd_global.user_id,

8179: 'IDC',
8180: transaction_date (1),
8181: b.instance_number,
8182: NULL, -- parameter
8183: fnd_global.user_id,
8184: SYSDATE,
8185: fnd_global.user_id,
8186: SYSDATE,
8187: fnd_global.login_id,

Line 8185: fnd_global.user_id,

8181: b.instance_number,
8182: NULL, -- parameter
8183: fnd_global.user_id,
8184: SYSDATE,
8185: fnd_global.user_id,
8186: SYSDATE,
8187: fnd_global.login_id,
8188: p_batch_id
8189: FROM oks_instance_k_dtls_temp a,

Line 8187: fnd_global.login_id,

8183: fnd_global.user_id,
8184: SYSDATE,
8185: fnd_global.user_id,
8186: SYSDATE,
8187: fnd_global.login_id,
8188: p_batch_id
8189: FROM oks_instance_k_dtls_temp a,
8190: csi_item_instances b
8191: WHERE a.instance_id = b.instance_id);

Line 8271: fnd_global.user_id,

8267: hdr_sts (i),
8268: hdr.sts_code,
8269: null, -- subline_date_terminated,
8270: 1,
8271: fnd_global.user_id,
8272: SYSDATE,
8273: fnd_global.user_id,
8274: SYSDATE,
8275: fnd_global.login_id,

Line 8273: fnd_global.user_id,

8269: null, -- subline_date_terminated,
8270: 1,
8271: fnd_global.user_id,
8272: SYSDATE,
8273: fnd_global.user_id,
8274: SYSDATE,
8275: fnd_global.login_id,
8276: null
8277: FROM oks_instance_history a, Okc_k_headers_all_b hdr

Line 8275: fnd_global.login_id,

8271: fnd_global.user_id,
8272: SYSDATE,
8273: fnd_global.user_id,
8274: SYSDATE,
8275: fnd_global.login_id,
8276: null
8277: FROM oks_instance_history a, Okc_k_headers_all_b hdr
8278: , okc_k_lines_b line
8279: , okc_k_lines_b subline

Line 8515: fnd_global.user_id,

8511: 'TRM',
8512: transaction_date (1),
8513: b.instance_number,
8514: NULL, -- parameter
8515: fnd_global.user_id,
8516: SYSDATE,
8517: fnd_global.user_id,
8518: SYSDATE,
8519: fnd_global.login_id,

Line 8517: fnd_global.user_id,

8513: b.instance_number,
8514: NULL, -- parameter
8515: fnd_global.user_id,
8516: SYSDATE,
8517: fnd_global.user_id,
8518: SYSDATE,
8519: fnd_global.login_id,
8520: p_batch_id
8521: FROM oks_instance_temp a,

Line 8519: fnd_global.login_id,

8515: fnd_global.user_id,
8516: SYSDATE,
8517: fnd_global.user_id,
8518: SYSDATE,
8519: fnd_global.login_id,
8520: p_batch_id
8521: FROM oks_instance_temp a,
8522: csi_item_instances b
8523: WHERE a.old_customer_product_id = b.instance_id);

Line 8603: fnd_global.user_id,

8599: hdr_sts (i),
8600: hdr.sts_code,
8601: line.date_terminated, -- subline_date_terminated,
8602: 1,
8603: fnd_global.user_id,
8604: SYSDATE,
8605: fnd_global.user_id,
8606: SYSDATE,
8607: fnd_global.login_id,

Line 8605: fnd_global.user_id,

8601: line.date_terminated, -- subline_date_terminated,
8602: 1,
8603: fnd_global.user_id,
8604: SYSDATE,
8605: fnd_global.user_id,
8606: SYSDATE,
8607: fnd_global.login_id,
8608: line.date_cancelled
8609: FROM oks_instance_history a,

Line 8607: fnd_global.login_id,

8603: fnd_global.user_id,
8604: SYSDATE,
8605: fnd_global.user_id,
8606: SYSDATE,
8607: fnd_global.login_id,
8608: line.date_cancelled
8609: FROM oks_instance_history a,
8610: Okc_k_lines_b line,
8611: Okc_k_headers_all_b hdr