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 OKC_P_UTIL

Line 233: l_oper_instance_id := okc_p_util.raw_to_number (SYS_GUID ());

229: l_return_status := 'S';
230: l_oper_instance_id := l_oie_id;
231:
232: ELSE
233: l_oper_instance_id := okc_p_util.raw_to_number (SYS_GUID ());
234: INSERT INTO OKC_OPERATION_INSTANCES(
235: id,
236: cop_id,
237: status_code,

Line 308: okc_p_util.raw_to_number (SYS_GUID ()),

304: program_id,
305: program_update_date,
306: message_code)
307: VALUES (
308: okc_p_util.raw_to_number (SYS_GUID ()),
309: null,
310: 'P',
311: 'Y',
312: l_oper_instance_id,

Line 363: okc_p_util.raw_to_number (SYS_GUID ()),

359: program_id,
360: program_update_date,
361: message_code)
362: VALUES (
363: okc_p_util.raw_to_number (SYS_GUID ()),
364: null,
365: 'P',
366: 'Y',
367: l_oper_instance_id,

Line 1864: (SELECT okc_p_util.raw_to_number (SYS_GUID ())

1860: WHERE temp1.contract_id = temp.contract_id) hdr_edate,
1861: kh.contract_number contract_number,
1862: kh.contract_number_modifier,
1863: get_modifier(temp.contract_id),
1864: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
1865: FROM okc_k_headers_all_b where id = contract_id ) oks_id,
1866: ks.price_uom
1867:
1868: FROM okc_k_headers_all_b kh,

Line 2442: l_khrv_tbl_in (i).ID := hdr_oks_id(i); --okc_p_util.raw_to_number (SYS_GUID ());

2438:
2439:
2440:
2441: -- Assigning records for okS_k_headers_b
2442: l_khrv_tbl_in (i).ID := hdr_oks_id(i); --okc_p_util.raw_to_number (SYS_GUID ());
2443: l_khrv_tbl_in (i).chr_id := hdr_id (i);
2444: l_khrv_tbl_in (i).summary_trx_yn := hdr_sum_trx (i);
2445: l_khrv_tbl_in (i).hold_billing := hdr_hold_bill (i);
2446: l_khrv_tbl_in (i).inv_trx_type := hdr_inv_trx (i);

Line 2462: l_cpsv_tbl_in (i).ID := okc_p_util.raw_to_number (SYS_GUID ());

2458: g_module_current || 'oks_mass_update.create_contract_header',
2459: 'Inside pdf assignment');
2460: END IF;
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;

Line 2503: l_cgcv_tbl_in (i).ID := okc_p_util.raw_to_number (SYS_GUID ());

2499: g_module_current || 'oks_mass_update.create_contract_header',
2500: 'Inside contract group assignment');
2501: END IF;
2502:
2503: l_cgcv_tbl_in (i).ID := okc_p_util.raw_to_number (SYS_GUID ());
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);

Line 2523: l_cpl_tbl_in (j).ID := okc_p_util.raw_to_number (SYS_GUID ());

2519: 'Party roles assignment, Vendor = '|| hdr_authoring_org_id (i)
2520: || 'Customer = '|| p_batch_rules.new_party_id );
2521: END IF;
2522:
2523: l_cpl_tbl_in (j).ID := okc_p_util.raw_to_number (SYS_GUID ());
2524: l_cpl_tbl_in (j).object_version_number := 1;
2525: l_cpl_tbl_in (j).sfwt_flag := 'N';
2526: l_cpl_tbl_in (j).cpl_id := '';
2527: l_cpl_tbl_in (j).chr_id := hdr_id (i);

Line 2652: l_ctcv_tbl_in (k).ID := okc_p_util.raw_to_number (SYS_GUID ());

2648: END IF;
2649: CLOSE object_code_csr;
2650:
2651:
2652: l_ctcv_tbl_in (k).ID := okc_p_util.raw_to_number (SYS_GUID ());
2653: l_ctcv_tbl_in (k).object_version_number := 1;
2654:
2655: l_ctcv_tbl_in (k).cpl_id := l_cpl_tbl_in (j).ID;
2656:

Line 2698: l_cpl_tbl_in (j + 1).ID := okc_p_util.raw_to_number (SYS_GUID ());

2694: End If;
2695: End If;
2696: End If;
2697:
2698: l_cpl_tbl_in (j + 1).ID := okc_p_util.raw_to_number (SYS_GUID ());
2699: l_cpl_tbl_in (j + 1).object_version_number := 1;
2700: l_cpl_tbl_in (j + 1).sfwt_flag := 'N';
2701: l_cpl_tbl_in (j + 1).cpl_id := '';
2702: l_cpl_tbl_in (j + 1).chr_id := hdr_id (i);

Line 2764: okc_p_util.raw_to_number (SYS_GUID ());

2760: || l_third_party_id);
2761: END IF;
2762:
2763: l_cpl_tbl_in (j + 2).ID :=
2764: okc_p_util.raw_to_number (SYS_GUID ());
2765: l_cpl_tbl_in (j + 2).object_version_number := 1;
2766: l_cpl_tbl_in (j + 2).sfwt_flag := 'N';
2767: l_cpl_tbl_in (j + 2).cpl_id := '';
2768: l_cpl_tbl_in (j + 2).chr_id := hdr_id (i);

Line 2808: l_ctcv_tbl_in (k).ID := okc_p_util.raw_to_number (SYS_GUID ());

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;
2810: l_ctcv_tbl_in (k).cpl_id := l_cpl_tbl_in (j + 2).ID;
2811: l_ctcv_tbl_in (k).cro_code := 'BILLING';
2812: l_ctcv_tbl_in (k).dnz_chr_id := hdr_id (i);

Line 2852: l_ctcv_tbl_in (k).ID := okc_p_util.raw_to_number (SYS_GUID ());

2848: g_module_current || 'oks_mass_update.create_contract_header',
2849: 'Billing account are related, create billing contact.');
2850: END IF;
2851:
2852: l_ctcv_tbl_in (k).ID := okc_p_util.raw_to_number (SYS_GUID ());
2853: l_ctcv_tbl_in (k).object_version_number := 1;
2854: l_ctcv_tbl_in (k).cpl_id := l_cpl_tbl_in (j + 1).ID;
2855: l_ctcv_tbl_in (k).cro_code := 'BILLING';
2856: l_ctcv_tbl_in (k).dnz_chr_id := hdr_id (i);

Line 3128: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),

3124: last_updated_by,
3125: last_update_date,
3126: last_update_login
3127: )
3128: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
3129: hdr_id (i),
3130: groupid (i),
3131: resource_id (i),
3132: access_level (i),

Line 3180: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),

3176: creation_date,
3177: last_updated_by,
3178: last_update_date
3179: )
3180: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
3181: PERCENT (i),
3182: sales_group_id (i),
3183: hdr_id (i),
3184: NULL,

Line 3280: (SELECT okc_p_util.raw_to_number (SYS_GUID ())

3276: Ks.invoice_text,
3277: ks.coverage_id,
3278: ks.standard_cov_yn,
3279: st.ste_code line_sts,
3280: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
3281: FROM okc_k_lines_b WHERE id = topline_id) oks_id,
3282: topline_id,
3283: Ks.price_uom,
3284: kh.authoring_org_id,

Line 3575: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),

3571: program_application_id,
3572: program_id,
3573: program_update_date
3574: )
3575: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
3576: srvline_id (i),
3577: --contract_id (i),
3578: NULL,
3579: contract_id (i),

Line 3719: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),

3715: creation_date,
3716: last_updated_by,
3717: last_update_date
3718: )
3719: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
3720: PERCENT (i),
3721: sales_group_id (i),
3722: contract_id (i),
3723: srvline_id(i),

Line 3811: (SELECT okc_p_util.raw_to_number (SYS_GUID ())

3807: ) line_number,
3808: kl1.start_date srv_sdate,
3809: kl1.end_date srv_edate,
3810: st.ste_code subline_sts,
3811: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
3812: FROM okc_k_lines_b WHERE id = subline_id) oks_id,
3813: ks.price_uom,
3814: ks.toplvl_price_qty,
3815: ks.toplvl_uom_code

Line 4058: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),

4054: program_application_id,
4055: program_id,
4056: program_update_date
4057: )
4058: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
4059: subline_id (i),
4060: --contract_id (i),
4061: NULL,
4062: contract_id (i),

Line 5571: l_line_id := okc_p_util.raw_to_number (SYS_GUID ());

5567: THEN
5568:
5569: IF p_var = 'NEW'
5570: THEN
5571: l_line_id := okc_p_util.raw_to_number (SYS_GUID ());
5572: RETURN (l_line_id);
5573: ELSE
5574: RETURN (l_line_id);
5575: END IF;

Line 5577: RETURN (okc_p_util.raw_to_number (SYS_GUID ()));

5573: ELSE
5574: RETURN (l_line_id);
5575: END IF;
5576: ELSE
5577: RETURN (okc_p_util.raw_to_number (SYS_GUID ()));
5578: END IF;
5579: END get_seq_no;
5580:
5581: -----------* function get_object_line_id *-----------

Line 7191: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),

7187: last_update_date,
7188: last_update_login,
7189: batch_id
7190: )
7191: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
7192: 1,
7193: b.instance_id,
7194: 'TRF',
7195: a.transaction_date,

Line 7259: okc_p_util.raw_to_number (SYS_GUID ()),

7255: transfer_option
7256:
7257: )
7258: (SELECT
7259: okc_p_util.raw_to_number (SYS_GUID ()),
7260: ins_hist.id ,
7261: transaction_date(1),
7262: 'TRF',
7263: custprod_id (i),

Line 7717: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),

7713: last_update_date,
7714: last_update_login,
7715: batch_id
7716: )
7717: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
7718: 1,
7719: b.instance_id,
7720: 'TRF',
7721: a.transaction_date,

Line 7780: (Select okc_p_util.raw_to_number (SYS_GUID ()),

7776: last_update_date,
7777: last_update_login,
7778: Date_Cancelled
7779: )
7780: (Select okc_p_util.raw_to_number (SYS_GUID ()),
7781: inshist.id ,
7782: transaction_date(i),
7783: 'TRF',
7784: custprod_id (i),

Line 7883: (Select okc_p_util.raw_to_number (SYS_GUID ()),

7879: last_updated_by,
7880: last_update_date,
7881: last_update_login
7882: )
7883: (Select okc_p_util.raw_to_number (SYS_GUID ()),
7884: inshist.id,
7885: transaction_date(i),
7886: 'TRF',
7887: custprod_id (i),

Line 8216: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),

8212: last_update_date,
8213: last_update_login,
8214: batch_id
8215: )
8216: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
8217: 1,
8218: b.instance_id,
8219: 'IDC',
8220: transaction_date (1),

Line 8278: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),

8274: last_update_date,
8275: last_update_login,
8276: date_cancelled
8277: )
8278: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
8279: a.ID,
8280: transaction_date (i),
8281: 'IDC',
8282: custprod_id (i),

Line 8551: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),

8547: last_update_date,
8548: last_update_login,
8549: batch_id
8550: )
8551: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
8552: 1,
8553: b.instance_id,
8554: 'TRM',
8555: transaction_date (1),

Line 8613: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),

8609: last_update_date,
8610: last_update_login,
8611: date_cancelled
8612: )
8613: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
8614: a.ID,
8615: transaction_date (i),
8616: 'TRM',
8617: custprod_id (i),