eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_P_UTIL

Line 9950: l_sid_tab(l_slctd_optns_counter) := okc_p_util.raw_to_number(sys_guid());

9946: FOR i IN l_sid_tab2.first..l_sid_tab2.last
9947: LOOP
9948: l_sid_tab(l_slctd_optns_counter) := l_sid_tab2(i);
9949: -- Change id
9950: l_sid_tab(l_slctd_optns_counter) := okc_p_util.raw_to_number(sys_guid());
9951:
9952: l_spov_id_tab(l_slctd_optns_counter) := l_spov_id_tab2(i);
9953: l_skhr_id_tab(l_slctd_optns_counter) := l_skhr_id_tab2(i);
9954: -- Change khr_id

Line 11921: l_cid_tab(l_contacts_counter) := okc_p_util.raw_to_number(sys_guid());

11917: LOOP
11918: l_cid_tab(l_contacts_counter) := l_cid_tab2(i);
11919:
11920: -- Replace id
11921: l_cid_tab(l_contacts_counter) := okc_p_util.raw_to_number(sys_guid());
11922:
11923: l_ccpl_id_tab(l_contacts_counter) := l_ccpl_id_tab2(i);
11924: -- Replace cpl_id
11925: l_ccpl_id_tab(l_contacts_counter) := p_new_id;

Line 12288: l_phid_tab(l_party_payment_hdr_counter) := okc_p_util.raw_to_number(sys_guid());

12284: FOR i IN l_phid_tab2.FIRST..l_phid_tab2.LAST
12285: LOOP
12286: l_phid_tab(l_party_payment_hdr_counter) := l_phid_tab2(i);
12287: -- Replace id
12288: l_phid_tab(l_party_payment_hdr_counter) := okc_p_util.raw_to_number(sys_guid());
12289:
12290: l_phid_mapping_tab(l_party_payment_hdr_counter).old_id :=
12291: l_phid_tab2(i);
12292: l_phid_mapping_tab(l_party_payment_hdr_counter).new_id :=

Line 12469: l_ppid_tab(l_party_payment_dtls_counter) := okc_p_util.raw_to_number(sys_guid());

12465: LOOP
12466:
12467: l_ppid_tab(l_party_payment_dtls_counter) := l_ppid_tab2(i);
12468: -- Change id
12469: l_ppid_tab(l_party_payment_dtls_counter) := okc_p_util.raw_to_number(sys_guid());
12470:
12471: l_ppobject_version_number_tab(l_party_payment_dtls_counter) := l_ppobject_version_number_tab2(i);
12472: l_ppcpl_id_tab(l_party_payment_dtls_counter) := l_ppcpl_id_tab2(i);
12473: -- Change cpl_id

Line 12987: l_id_tab(l_loop_counter) := okc_p_util.raw_to_number(sys_guid());

12983: -- Store party old_id and new_id in mapping table
12984: l_party_id_mapping_tab(l_party_counter).old_id := l_id_tab2(i);
12985:
12986: -- Replace l_id_tab
12987: l_id_tab(l_loop_counter) := okc_p_util.raw_to_number(sys_guid());
12988: l_prid_tab(l_loop_counter) := l_id_tab(l_loop_counter);
12989:
12990: l_party_id_mapping_tab(l_party_counter).new_id := l_id_tab(l_loop_counter);
12991: l_chr_id_tab(l_loop_counter) := l_chr_id_tab2(i);

Line 13983: l_rrid_tab(l_rules_b_counter) := okc_p_util.raw_to_number(sys_guid());

13979: l_rrid_tab3(l_rules_b_counter) := l_rrid_tab2(i);
13980:
13981: l_rrid_tab(l_rules_b_counter) := l_rrid_tab2(i);
13982: -- Change id
13983: l_rrid_tab(l_rules_b_counter) := okc_p_util.raw_to_number(sys_guid());
13984:
13985: l_rrid_mapping_tab(l_rules_b_counter).old_id := l_rrid_tab3(l_rules_b_counter);
13986: l_rrid_mapping_tab(l_rules_b_counter).new_id := l_rrid_tab(l_rules_b_counter);
13987:

Line 14502: l_rid_tab(l_rule_groups_b_counter) :=okc_p_util.raw_to_number(sys_guid());

14498: l_rid_tab(l_rule_groups_b_counter) := l_rid_tab2(i);
14499: -- Store old value in tab3
14500: l_rid_tab3(l_rule_groups_b_counter) := l_rid_tab2(i);
14501: -- Change id
14502: l_rid_tab(l_rule_groups_b_counter) :=okc_p_util.raw_to_number(sys_guid());
14503:
14504: l_rid_mapping_tab(l_rule_groups_b_counter).old_id := l_rid_tab3(l_rule_groups_b_counter);
14505: l_rid_mapping_tab(l_rule_groups_b_counter).new_id := l_rid_tab(l_rule_groups_b_counter);
14506:

Line 15111: l_iid_tab(l_items_counter) := okc_p_util.raw_to_number(sys_guid());

15107: LOOP
15108:
15109: l_iid_tab(l_items_counter) := l_iid_tab2(i);
15110: -- Change id
15111: l_iid_tab(l_items_counter) := okc_p_util.raw_to_number(sys_guid());
15112:
15113: l_icle_id_tab(l_items_counter) := l_icle_id_tab2(i);
15114: -- Change cle_id
15115: IF (l_icle_id_tab(l_items_counter) IS NOT NULL) THEN

Line 16096: l_dbid_tab(l_txd_assets_b_counter) := okc_p_util.raw_to_number(sys_guid());

16092:
16093: l_dbid_tab3(l_txd_assets_b_counter) := l_dbid_tab2(i);
16094: l_dbid_tab(l_txd_assets_b_counter) := l_dbid_tab2(i);
16095: -- Change id
16096: l_dbid_tab(l_txd_assets_b_counter) := okc_p_util.raw_to_number(sys_guid());
16097:
16098: l_dbobject_version_number_tab(l_txd_assets_b_counter) := l_dbobject_version_number_tab2(i);
16099: l_dbtal_id_tab(l_txd_assets_b_counter) := l_dbtal_id_tab2(i);
16100: -- Change tal_id

Line 16590: l_tbid_tab(l_txl_assets_b_counter) := okc_p_util.raw_to_number(sys_guid());

16586:
16587: l_tbid_tab3(l_txl_assets_b_counter) := l_tbid_tab2(i);
16588: l_tbid_tab(l_txl_assets_b_counter) := l_tbid_tab2(i);
16589: -- Change id
16590: l_tbid_tab(l_txl_assets_b_counter) := okc_p_util.raw_to_number(sys_guid());
16591: l_txl_id_mapping_tab(l_txl_assets_b_counter).old_id := l_tbid_tab3(l_txl_assets_b_counter);
16592: l_txl_id_mapping_tab(l_txl_assets_b_counter).new_id := l_tbid_tab(l_txl_assets_b_counter);
16593:
16594: l_tbobject_version_number_tab(l_txl_assets_b_counter) := l_tbobject_version_number_tab2(i);

Line 16987: l_tid_tab(l_trx_assets_counter) := okc_p_util.raw_to_number(sys_guid());

16983: l_tid_tab(l_trx_assets_counter) := l_tid_tab2(i);
16984: l_trx_id_mapping_tab(l_trx_assets_counter).old_id := l_tid_tab2(i);
16985:
16986: --Change id
16987: l_tid_tab(l_trx_assets_counter) := okc_p_util.raw_to_number(sys_guid());
16988: l_trx_id_mapping_tab(l_trx_assets_counter).new_id := l_tid_tab(l_trx_assets_counter);
16989:
16990: l_tica_id_tab(l_trx_assets_counter) := l_tica_id_tab2(i);
16991: l_ttas_type_tab(l_trx_assets_counter) := l_ttas_type_tab2(i);

Line 17211: l_t2id_tab(l_trx_assets_counter2) := okc_p_util.raw_to_number(sys_guid());

17207:
17208: l_t2id_tab(l_trx_assets_counter2) := l_t2id_tab2(i);
17209: l_trx_id_mapping_tab2(l_trx_assets_counter2).old_id := l_t2id_tab2(i);
17210: -- Change id
17211: l_t2id_tab(l_trx_assets_counter2) := okc_p_util.raw_to_number(sys_guid());
17212: l_trx_id_mapping_tab2(l_trx_assets_counter2).new_id := l_t2id_tab(l_trx_assets_counter2);
17213:
17214: l_t2ica_id_tab(l_trx_assets_counter2) := l_t2ica_id_tab2(i);
17215: l_t2tas_type_tab(l_trx_assets_counter2) := l_t2tas_type_tab2(i);

Line 17495: l_tiid_tab(l_txl_itm_insts_counter) := okc_p_util.raw_to_number(sys_guid());

17491: LOOP
17492:
17493: l_tiid_tab(l_txl_itm_insts_counter) := l_tiid_tab2(i);
17494: -- Change id
17495: l_tiid_tab(l_txl_itm_insts_counter) := okc_p_util.raw_to_number(sys_guid());
17496:
17497: l_tiobject_version_number_tab(l_txl_itm_insts_counter) := l_tiobject_version_number_tab2(i);
17498: l_titas_id_tab(l_txl_itm_insts_counter) := l_titas_id_tab2(i);
17499: -- Change tas_id

Line 18292: l_t3id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());

18288: FOR i IN l_ID1_tab.first..l_ID1_tab.last
18289: LOOP
18290: IF (l_book_class_tab(i) = 'CORPORATE') THEN
18291: -- Populate okl_trx_assets
18292: l_t3id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());
18293: -- Populate kle to tas_id mapping
18294: l_cle_mapping_tab(l_trx_assets_counter4).old_id := l_ID_local_tab(i); -- kle_id
18295: --l_cle_mapping_tab(l_trx_assets_counter4).new_id := l_t3id_tab(l_trx_assets_counter4);
18296: l_cle_mapping_tab(l_trx_assets_counter4).line_number := 1;

Line 18299: l_tb2id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());

18295: --l_cle_mapping_tab(l_trx_assets_counter4).new_id := l_t3id_tab(l_trx_assets_counter4);
18296: l_cle_mapping_tab(l_trx_assets_counter4).line_number := 1;
18297:
18298: -- Populate okl_txl_assets_b
18299: l_tb2id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());
18300: l_cle_mapping_tab(l_trx_assets_counter4).new_id := l_tb2id_tab(l_trx_assets_counter4);
18301: l_tb2object_version_number_tab(l_trx_assets_counter4) := 1;
18302: l_tb2tas_id_tab(l_trx_assets_counter4) := l_t3id_tab(l_trx_assets_counter4);
18303: -- id already changed earlier

Line 18427: l_db2id_tab(l_txd_assets_b_counter4) := okc_p_util.raw_to_number(sys_guid());

18423: IF ((l_BOOK_TYPE_CODE_tab(i) = l_multi_gaap_profile) AND
18424: p_trans_type NOT IN ('CRB', 'CRL')) THEN
18425: NULL;
18426: ELSE
18427: l_db2id_tab(l_txd_assets_b_counter4) := okc_p_util.raw_to_number(sys_guid());
18428: l_new_tal_id := find_cle_mapping_id(l_ID_local_tab(i));
18429: IF (l_new_tal_id = -1) THEN
18430: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
18431: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR!!!!Mapping tal_id not found');

Line 18523: l_t3id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());

18519: IF ((l_tmp_itm_rec.object1_id1 IS NULL) AND
18520: (l_tmp_itm_rec.object1_id2 IS NULL)) THEN
18521: -- Populate okl_trx_assets
18522: --print('Yes object1_id1 and id2 null...');
18523: l_t3id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());
18524: --print('Upto 1...');
18525: -- Populate kle to tas_id mapping
18526: l_cle_mapping_tab(l_trx_assets_counter4).old_id := l_id_tab(i); -- kle_id
18527: l_cle_mapping_tab(l_trx_assets_counter4).line_number := 1;

Line 18531: l_tb2id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());

18527: l_cle_mapping_tab(l_trx_assets_counter4).line_number := 1;
18528:
18529: --print('Upto 2...');
18530: -- Populate okl_txl_assets_b
18531: l_tb2id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());
18532: l_cle_mapping_tab(l_trx_assets_counter4).new_id := l_tb2id_tab(l_trx_assets_counter4);
18533: --print('Upto 3...');
18534: l_tb2object_version_number_tab(l_trx_assets_counter4) := 1;
18535: l_tb2tas_id_tab(l_trx_assets_counter4) := l_t3id_tab(l_trx_assets_counter4);

Line 18993: l_gid_tab(l_rg_party_roles_counter) := okc_p_util.raw_to_number(sys_guid());

18989: FOR i IN l_gid_tab2.first..l_gid_tab2.last
18990: LOOP
18991: l_gid_tab(l_rg_party_roles_counter) := l_gid_tab2(i);
18992: -- Change id
18993: l_gid_tab(l_rg_party_roles_counter) := okc_p_util.raw_to_number(sys_guid());
18994:
18995: l_grgp_id_tab(l_rg_party_roles_counter) := l_grgp_id_tab2(i);
18996: -- Change rgp_id
18997: l_new_rgp_id := find_rid_mapping_id(l_grgp_id_tab(l_rg_party_roles_counter));

Line 19228: l_osid_tab(l_supp_invoice_dtls_counter) := okc_p_util.raw_to_number(sys_guid());

19224: FOR i IN l_osid_tab2.first..l_osid_tab2.last
19225: LOOP
19226: l_osid_tab(l_supp_invoice_dtls_counter) := l_osid_tab2(i);
19227: -- Change id
19228: l_osid_tab(l_supp_invoice_dtls_counter) := okc_p_util.raw_to_number(sys_guid());
19229:
19230: l_osobject_version_number_tab(l_supp_invoice_dtls_counter) := l_osobject_version_number_tab2(i);
19231: l_oscle_id_tab(l_supp_invoice_dtls_counter) := l_oscle_id_tab2(i);
19232: -- Change cle_id

Line 19608: l_t4id_tab(l_trx_assets_counter5) := okc_p_util.raw_to_number(sys_guid());

19604: CLOSE c28;
19605: IF (l_inventory_item_id_tab3.count > 0) THEN
19606: FOR i IN l_inventory_item_id_tab3.first..l_inventory_item_id_tab3.last
19607: LOOP
19608: l_t4id_tab(l_trx_assets_counter5) := okc_p_util.raw_to_number(sys_guid());
19609:
19610: l_ti2id_tab(l_txl_itm_insts_counter2) := okc_p_util.raw_to_number(sys_guid());
19611: l_ti2tas_id_tab(l_txl_itm_insts_counter2) := l_t4id_tab(l_trx_assets_counter5);
19612: l_ti2kle_id_tab(l_txl_itm_insts_counter2) := l_id_tab3(i);

Line 19610: l_ti2id_tab(l_txl_itm_insts_counter2) := okc_p_util.raw_to_number(sys_guid());

19606: FOR i IN l_inventory_item_id_tab3.first..l_inventory_item_id_tab3.last
19607: LOOP
19608: l_t4id_tab(l_trx_assets_counter5) := okc_p_util.raw_to_number(sys_guid());
19609:
19610: l_ti2id_tab(l_txl_itm_insts_counter2) := okc_p_util.raw_to_number(sys_guid());
19611: l_ti2tas_id_tab(l_txl_itm_insts_counter2) := l_t4id_tab(l_trx_assets_counter5);
19612: l_ti2kle_id_tab(l_txl_itm_insts_counter2) := l_id_tab3(i);
19613: -- Change kle_id
19614: l_new_kle_id := find_mapping_id(l_ti2kle_id_tab(l_txl_itm_insts_counter2));

Line 20496: --l_copied_id := okc_p_util.raw_to_number(sys_guid());

20492:
20493: l_curr_pos := 'okl_copy_lease_contract:4';
20494: -- kmotepal populating contract id from sys guid instead of using OKC sequence which fixes the bug 4436545 (Reverted back for OKL.H)
20495: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;
20496: --l_copied_id := okc_p_util.raw_to_number(sys_guid());
20497:
20498: l_contract_currency := c1rec.currency_code;
20499: l_contract_start_date := c1rec.start_date;
20500: l_conversion_type := c1rec.CONVERSION_TYPE;

Line 20756: okc_p_util.raw_to_number(sys_guid()), l_copied_id, l_copied_id,

20752: ISA_AGREEMENT_ID, COPIED_ONLY_YN, OBJECT_VERSION_NUMBER,
20753: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
20754: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, SECURITY_GROUP_ID
20755: ) VALUES (
20756: okc_p_util.raw_to_number(sys_guid()), l_copied_id, l_copied_id,
20757: c2rec.CLE_ID, c2rec.CHR_ID_REFERRED, c2rec.CLE_ID_REFERRED,
20758: c2rec.ISA_AGREEMENT_ID, c2rec.COPIED_ONLY_YN, c2rec.OBJECT_VERSION_NUMBER,
20759: l_created_by, SYSDATE, l_last_updated_by,
20760: SYSDATE, l_last_update_login, c2rec.SECURITY_GROUP_ID

Line 20952: l_id_tab(l_counter) := okc_p_util.raw_to_number(sys_guid());

20948: --l_orig_system_id1_tab(l_counter) := l_orig_system_id1_tab2(i);
20949:
20950: -- Populate proper values
20951: l_orig_system_id1_tab(l_counter) := l_id_tab(l_counter);
20952: l_id_tab(l_counter) := okc_p_util.raw_to_number(sys_guid());
20953: -- Populate proper values done
20954:
20955: -- Store sid mapping for business function processing
20956: l_sid_mapping_tab(l_counter).id := l_id_tab(l_counter);