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 1860: (SELECT okc_p_util.raw_to_number (SYS_GUID ())

1856: WHERE temp1.contract_id = temp.contract_id) hdr_edate,
1857: kh.contract_number contract_number,
1858: kh.contract_number_modifier,
1859: get_modifier(temp.contract_id),
1860: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
1861: FROM okc_k_headers_all_b where id = contract_id ) oks_id,
1862: ks.price_uom
1863:
1864: FROM okc_k_headers_all_b kh,

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

2433:
2434:
2435:
2436: -- Assigning records for okS_k_headers_b
2437: l_khrv_tbl_in (i).ID := hdr_oks_id(i); --okc_p_util.raw_to_number (SYS_GUID ());
2438: l_khrv_tbl_in (i).chr_id := hdr_id (i);
2439: l_khrv_tbl_in (i).summary_trx_yn := hdr_sum_trx (i);
2440: l_khrv_tbl_in (i).hold_billing := hdr_hold_bill (i);
2441: l_khrv_tbl_in (i).inv_trx_type := hdr_inv_trx (i);

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

2453: g_module_current || 'oks_mass_update.create_contract_header',
2454: 'Inside pdf assignment');
2455: END IF;
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;

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

2494: g_module_current || 'oks_mass_update.create_contract_header',
2495: 'Inside contract group assignment');
2496: END IF;
2497:
2498: l_cgcv_tbl_in (i).ID := okc_p_util.raw_to_number (SYS_GUID ());
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);

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

2514: 'Party roles assignment, Vendor = '|| hdr_authoring_org_id (i)
2515: || 'Customer = '|| p_batch_rules.new_party_id );
2516: END IF;
2517:
2518: l_cpl_tbl_in (j).ID := okc_p_util.raw_to_number (SYS_GUID ());
2519: l_cpl_tbl_in (j).object_version_number := 1;
2520: l_cpl_tbl_in (j).sfwt_flag := 'N';
2521: l_cpl_tbl_in (j).cpl_id := '';
2522: l_cpl_tbl_in (j).chr_id := hdr_id (i);

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

2643: END IF;
2644: CLOSE object_code_csr;
2645:
2646:
2647: l_ctcv_tbl_in (k).ID := okc_p_util.raw_to_number (SYS_GUID ());
2648: l_ctcv_tbl_in (k).object_version_number := 1;
2649:
2650: l_ctcv_tbl_in (k).cpl_id := l_cpl_tbl_in (j).ID;
2651:

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

2689: End If;
2690: End If;
2691: End If;
2692:
2693: l_cpl_tbl_in (j + 1).ID := okc_p_util.raw_to_number (SYS_GUID ());
2694: l_cpl_tbl_in (j + 1).object_version_number := 1;
2695: l_cpl_tbl_in (j + 1).sfwt_flag := 'N';
2696: l_cpl_tbl_in (j + 1).cpl_id := '';
2697: l_cpl_tbl_in (j + 1).chr_id := hdr_id (i);

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

2755: || l_third_party_id);
2756: END IF;
2757:
2758: l_cpl_tbl_in (j + 2).ID :=
2759: okc_p_util.raw_to_number (SYS_GUID ());
2760: l_cpl_tbl_in (j + 2).object_version_number := 1;
2761: l_cpl_tbl_in (j + 2).sfwt_flag := 'N';
2762: l_cpl_tbl_in (j + 2).cpl_id := '';
2763: l_cpl_tbl_in (j + 2).chr_id := hdr_id (i);

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

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

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

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

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

3119: last_updated_by,
3120: last_update_date,
3121: last_update_login
3122: )
3123: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
3124: hdr_id (i),
3125: groupid (i),
3126: resource_id (i),
3127: access_level (i),

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

3171: creation_date,
3172: last_updated_by,
3173: last_update_date
3174: )
3175: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
3176: PERCENT (i),
3177: sales_group_id (i),
3178: hdr_id (i),
3179: NULL,

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

3271: Ks.invoice_text,
3272: ks.coverage_id,
3273: ks.standard_cov_yn,
3274: st.ste_code line_sts,
3275: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
3276: FROM okc_k_lines_b WHERE id = topline_id) oks_id,
3277: topline_id,
3278: Ks.price_uom,
3279: kh.authoring_org_id,

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

3566: program_application_id,
3567: program_id,
3568: program_update_date
3569: )
3570: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
3571: srvline_id (i),
3572: --contract_id (i),
3573: NULL,
3574: contract_id (i),

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

3710: creation_date,
3711: last_updated_by,
3712: last_update_date
3713: )
3714: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
3715: PERCENT (i),
3716: sales_group_id (i),
3717: contract_id (i),
3718: srvline_id(i),

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

3802: ) line_number,
3803: kl1.start_date srv_sdate,
3804: kl1.end_date srv_edate,
3805: st.ste_code subline_sts,
3806: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
3807: FROM okc_k_lines_b WHERE id = subline_id) oks_id,
3808: ks.price_uom,
3809: ks.toplvl_price_qty,
3810: ks.toplvl_uom_code

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

4049: program_application_id,
4050: program_id,
4051: program_update_date
4052: )
4053: VALUES (okc_p_util.raw_to_number (SYS_GUID ()),
4054: subline_id (i),
4055: --contract_id (i),
4056: NULL,
4057: contract_id (i),

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

5550: THEN
5551:
5552: IF p_var = 'NEW'
5553: THEN
5554: l_line_id := okc_p_util.raw_to_number (SYS_GUID ());
5555: RETURN (l_line_id);
5556: ELSE
5557: RETURN (l_line_id);
5558: END IF;

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

5556: ELSE
5557: RETURN (l_line_id);
5558: END IF;
5559: ELSE
5560: RETURN (okc_p_util.raw_to_number (SYS_GUID ()));
5561: END IF;
5562: END get_seq_no;
5563:
5564: -----------* function get_object_line_id *-----------

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

7170: last_update_date,
7171: last_update_login,
7172: batch_id
7173: )
7174: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
7175: 1,
7176: b.instance_id,
7177: 'TRF',
7178: a.transaction_date,

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

7238: transfer_option
7239:
7240: )
7241: (SELECT
7242: okc_p_util.raw_to_number (SYS_GUID ()),
7243: ins_hist.id ,
7244: transaction_date(1),
7245: 'TRF',
7246: custprod_id (i),

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

7696: last_update_date,
7697: last_update_login,
7698: batch_id
7699: )
7700: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
7701: 1,
7702: b.instance_id,
7703: 'TRF',
7704: a.transaction_date,

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

7759: last_update_date,
7760: last_update_login,
7761: Date_Cancelled
7762: )
7763: (Select okc_p_util.raw_to_number (SYS_GUID ()),
7764: inshist.id ,
7765: transaction_date(i),
7766: 'TRF',
7767: custprod_id (i),

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

7862: last_updated_by,
7863: last_update_date,
7864: last_update_login
7865: )
7866: (Select okc_p_util.raw_to_number (SYS_GUID ()),
7867: inshist.id,
7868: transaction_date(i),
7869: 'TRF',
7870: custprod_id (i),

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

8172: last_update_date,
8173: last_update_login,
8174: batch_id
8175: )
8176: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
8177: 1,
8178: b.instance_id,
8179: 'IDC',
8180: transaction_date (1),

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

8234: last_update_date,
8235: last_update_login,
8236: date_cancelled
8237: )
8238: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
8239: a.ID,
8240: transaction_date (i),
8241: 'IDC',
8242: custprod_id (i),

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

8504: last_update_date,
8505: last_update_login,
8506: batch_id
8507: )
8508: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
8509: 1,
8510: b.instance_id,
8511: 'TRM',
8512: transaction_date (1),

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

8566: last_update_date,
8567: last_update_login,
8568: date_cancelled
8569: )
8570: (SELECT okc_p_util.raw_to_number (SYS_GUID ()),
8571: a.ID,
8572: transaction_date (i),
8573: 'TRM',
8574: custprod_id (i),