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 10037: l_sid_tab(l_slctd_optns_counter) := okc_p_util.raw_to_number(sys_guid());

10033: FOR i IN l_sid_tab2.first..l_sid_tab2.last
10034: LOOP
10035: l_sid_tab(l_slctd_optns_counter) := l_sid_tab2(i);
10036: -- Change id
10037: l_sid_tab(l_slctd_optns_counter) := okc_p_util.raw_to_number(sys_guid());
10038:
10039: l_spov_id_tab(l_slctd_optns_counter) := l_spov_id_tab2(i);
10040: l_skhr_id_tab(l_slctd_optns_counter) := l_skhr_id_tab2(i);
10041: -- Change khr_id

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

12069: LOOP
12070: l_cid_tab(l_contacts_counter) := l_cid_tab2(i);
12071:
12072: -- Replace id
12073: l_cid_tab(l_contacts_counter) := okc_p_util.raw_to_number(sys_guid());
12074:
12075: l_ccpl_id_tab(l_contacts_counter) := l_ccpl_id_tab2(i);
12076: -- Replace cpl_id
12077: l_ccpl_id_tab(l_contacts_counter) := p_new_id;

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

12436: FOR i IN l_phid_tab2.FIRST..l_phid_tab2.LAST
12437: LOOP
12438: l_phid_tab(l_party_payment_hdr_counter) := l_phid_tab2(i);
12439: -- Replace id
12440: l_phid_tab(l_party_payment_hdr_counter) := okc_p_util.raw_to_number(sys_guid());
12441:
12442: l_phid_mapping_tab(l_party_payment_hdr_counter).old_id :=
12443: l_phid_tab2(i);
12444: l_phid_mapping_tab(l_party_payment_hdr_counter).new_id :=

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

12620: LOOP
12621:
12622: l_ppid_tab(l_party_payment_dtls_counter) := l_ppid_tab2(i);
12623: -- Change id
12624: l_ppid_tab(l_party_payment_dtls_counter) := okc_p_util.raw_to_number(sys_guid());
12625:
12626: l_ppobject_version_number_tab(l_party_payment_dtls_counter) := l_ppobject_version_number_tab2(i);
12627: l_ppcpl_id_tab(l_party_payment_dtls_counter) := l_ppcpl_id_tab2(i);
12628: -- Change cpl_id

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

13147: -- Store party old_id and new_id in mapping table
13148: l_party_id_mapping_tab(l_party_counter).old_id := l_id_tab2(i);
13149:
13150: -- Replace l_id_tab
13151: l_id_tab(l_loop_counter) := okc_p_util.raw_to_number(sys_guid());
13152: l_prid_tab(l_loop_counter) := l_id_tab(l_loop_counter);
13153:
13154: l_party_id_mapping_tab(l_party_counter).new_id := l_id_tab(l_loop_counter);
13155: l_chr_id_tab(l_loop_counter) := l_chr_id_tab2(i);

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

14144: l_rrid_tab3(l_rules_b_counter) := l_rrid_tab2(i);
14145:
14146: l_rrid_tab(l_rules_b_counter) := l_rrid_tab2(i);
14147: -- Change id
14148: l_rrid_tab(l_rules_b_counter) := okc_p_util.raw_to_number(sys_guid());
14149:
14150: l_rrid_mapping_tab(l_rules_b_counter).old_id := l_rrid_tab3(l_rules_b_counter);
14151: l_rrid_mapping_tab(l_rules_b_counter).new_id := l_rrid_tab(l_rules_b_counter);
14152:

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

14674: l_rid_tab(l_rule_groups_b_counter) := l_rid_tab2(i);
14675: -- Store old value in tab3
14676: l_rid_tab3(l_rule_groups_b_counter) := l_rid_tab2(i);
14677: -- Change id
14678: l_rid_tab(l_rule_groups_b_counter) :=okc_p_util.raw_to_number(sys_guid());
14679:
14680: l_rid_mapping_tab(l_rule_groups_b_counter).old_id := l_rid_tab3(l_rule_groups_b_counter);
14681: l_rid_mapping_tab(l_rule_groups_b_counter).new_id := l_rid_tab(l_rule_groups_b_counter);
14682:

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

15283: LOOP
15284:
15285: l_iid_tab(l_items_counter) := l_iid_tab2(i);
15286: -- Change id
15287: l_iid_tab(l_items_counter) := okc_p_util.raw_to_number(sys_guid());
15288:
15289: l_icle_id_tab(l_items_counter) := l_icle_id_tab2(i);
15290: -- Change cle_id
15291: IF (l_icle_id_tab(l_items_counter) IS NOT NULL) THEN

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

16269:
16270: l_dbid_tab3(l_txd_assets_b_counter) := l_dbid_tab2(i);
16271: l_dbid_tab(l_txd_assets_b_counter) := l_dbid_tab2(i);
16272: -- Change id
16273: l_dbid_tab(l_txd_assets_b_counter) := okc_p_util.raw_to_number(sys_guid());
16274:
16275: l_dbobject_version_number_tab(l_txd_assets_b_counter) := l_dbobject_version_number_tab2(i);
16276: l_dbtal_id_tab(l_txd_assets_b_counter) := l_dbtal_id_tab2(i);
16277: -- Change tal_id

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

16763:
16764: l_tbid_tab3(l_txl_assets_b_counter) := l_tbid_tab2(i);
16765: l_tbid_tab(l_txl_assets_b_counter) := l_tbid_tab2(i);
16766: -- Change id
16767: l_tbid_tab(l_txl_assets_b_counter) := okc_p_util.raw_to_number(sys_guid());
16768: l_txl_id_mapping_tab(l_txl_assets_b_counter).old_id := l_tbid_tab3(l_txl_assets_b_counter);
16769: l_txl_id_mapping_tab(l_txl_assets_b_counter).new_id := l_tbid_tab(l_txl_assets_b_counter);
16770:
16771: l_tbobject_version_number_tab(l_txl_assets_b_counter) := l_tbobject_version_number_tab2(i);

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

17160: l_tid_tab(l_trx_assets_counter) := l_tid_tab2(i);
17161: l_trx_id_mapping_tab(l_trx_assets_counter).old_id := l_tid_tab2(i);
17162:
17163: --Change id
17164: l_tid_tab(l_trx_assets_counter) := okc_p_util.raw_to_number(sys_guid());
17165: l_trx_id_mapping_tab(l_trx_assets_counter).new_id := l_tid_tab(l_trx_assets_counter);
17166:
17167: l_tica_id_tab(l_trx_assets_counter) := l_tica_id_tab2(i);
17168: l_ttas_type_tab(l_trx_assets_counter) := l_ttas_type_tab2(i);

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

17384:
17385: l_t2id_tab(l_trx_assets_counter2) := l_t2id_tab2(i);
17386: l_trx_id_mapping_tab2(l_trx_assets_counter2).old_id := l_t2id_tab2(i);
17387: -- Change id
17388: l_t2id_tab(l_trx_assets_counter2) := okc_p_util.raw_to_number(sys_guid());
17389: l_trx_id_mapping_tab2(l_trx_assets_counter2).new_id := l_t2id_tab(l_trx_assets_counter2);
17390:
17391: l_t2ica_id_tab(l_trx_assets_counter2) := l_t2ica_id_tab2(i);
17392: l_t2tas_type_tab(l_trx_assets_counter2) := l_t2tas_type_tab2(i);

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

17668: LOOP
17669:
17670: l_tiid_tab(l_txl_itm_insts_counter) := l_tiid_tab2(i);
17671: -- Change id
17672: l_tiid_tab(l_txl_itm_insts_counter) := okc_p_util.raw_to_number(sys_guid());
17673:
17674: l_tiobject_version_number_tab(l_txl_itm_insts_counter) := l_tiobject_version_number_tab2(i);
17675: l_titas_id_tab(l_txl_itm_insts_counter) := l_titas_id_tab2(i);
17676: -- Change tas_id

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

18465: FOR i IN l_ID1_tab.first..l_ID1_tab.last
18466: LOOP
18467: IF (l_book_class_tab(i) = 'CORPORATE') THEN
18468: -- Populate okl_trx_assets
18469: l_t3id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());
18470: -- Populate kle to tas_id mapping
18471: l_cle_mapping_tab(l_trx_assets_counter4).old_id := l_ID_local_tab(i); -- kle_id
18472: --l_cle_mapping_tab(l_trx_assets_counter4).new_id := l_t3id_tab(l_trx_assets_counter4);
18473: l_cle_mapping_tab(l_trx_assets_counter4).line_number := 1;

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

18472: --l_cle_mapping_tab(l_trx_assets_counter4).new_id := l_t3id_tab(l_trx_assets_counter4);
18473: l_cle_mapping_tab(l_trx_assets_counter4).line_number := 1;
18474:
18475: -- Populate okl_txl_assets_b
18476: l_tb2id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());
18477: l_cle_mapping_tab(l_trx_assets_counter4).new_id := l_tb2id_tab(l_trx_assets_counter4);
18478: l_tb2object_version_number_tab(l_trx_assets_counter4) := 1;
18479: l_tb2tas_id_tab(l_trx_assets_counter4) := l_t3id_tab(l_trx_assets_counter4);
18480: -- id already changed earlier

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

18600: IF ((l_BOOK_TYPE_CODE_tab(i) = l_multi_gaap_profile) AND
18601: p_trans_type NOT IN ('CRB', 'CRL')) THEN
18602: NULL;
18603: ELSE
18604: l_db2id_tab(l_txd_assets_b_counter4) := okc_p_util.raw_to_number(sys_guid());
18605: l_new_tal_id := find_cle_mapping_id(l_ID_local_tab(i));
18606: IF (l_new_tal_id = -1) THEN
18607: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
18608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR!!!!Mapping tal_id not found');

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

18696: IF ((l_tmp_itm_rec.object1_id1 IS NULL) AND
18697: (l_tmp_itm_rec.object1_id2 IS NULL)) THEN
18698: -- Populate okl_trx_assets
18699: --print('Yes object1_id1 and id2 null...');
18700: l_t3id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());
18701: --print('Upto 1...');
18702: -- Populate kle to tas_id mapping
18703: l_cle_mapping_tab(l_trx_assets_counter4).old_id := l_id_tab(i); -- kle_id
18704: l_cle_mapping_tab(l_trx_assets_counter4).line_number := 1;

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

18704: l_cle_mapping_tab(l_trx_assets_counter4).line_number := 1;
18705:
18706: --print('Upto 2...');
18707: -- Populate okl_txl_assets_b
18708: l_tb2id_tab(l_trx_assets_counter4) := okc_p_util.raw_to_number(sys_guid());
18709: l_cle_mapping_tab(l_trx_assets_counter4).new_id := l_tb2id_tab(l_trx_assets_counter4);
18710: --print('Upto 3...');
18711: l_tb2object_version_number_tab(l_trx_assets_counter4) := 1;
18712: l_tb2tas_id_tab(l_trx_assets_counter4) := l_t3id_tab(l_trx_assets_counter4);

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

19166: FOR i IN l_gid_tab2.first..l_gid_tab2.last
19167: LOOP
19168: l_gid_tab(l_rg_party_roles_counter) := l_gid_tab2(i);
19169: -- Change id
19170: l_gid_tab(l_rg_party_roles_counter) := okc_p_util.raw_to_number(sys_guid());
19171:
19172: l_grgp_id_tab(l_rg_party_roles_counter) := l_grgp_id_tab2(i);
19173: -- Change rgp_id
19174: l_new_rgp_id := find_rid_mapping_id(l_grgp_id_tab(l_rg_party_roles_counter));

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

19401: FOR i IN l_osid_tab2.first..l_osid_tab2.last
19402: LOOP
19403: l_osid_tab(l_supp_invoice_dtls_counter) := l_osid_tab2(i);
19404: -- Change id
19405: l_osid_tab(l_supp_invoice_dtls_counter) := okc_p_util.raw_to_number(sys_guid());
19406:
19407: l_osobject_version_number_tab(l_supp_invoice_dtls_counter) := l_osobject_version_number_tab2(i);
19408: l_oscle_id_tab(l_supp_invoice_dtls_counter) := l_oscle_id_tab2(i);
19409: -- Change cle_id

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

19781: CLOSE c28;
19782: IF (l_inventory_item_id_tab3.count > 0) THEN
19783: FOR i IN l_inventory_item_id_tab3.first..l_inventory_item_id_tab3.last
19784: LOOP
19785: l_t4id_tab(l_trx_assets_counter5) := okc_p_util.raw_to_number(sys_guid());
19786:
19787: l_ti2id_tab(l_txl_itm_insts_counter2) := okc_p_util.raw_to_number(sys_guid());
19788: l_ti2tas_id_tab(l_txl_itm_insts_counter2) := l_t4id_tab(l_trx_assets_counter5);
19789: l_ti2kle_id_tab(l_txl_itm_insts_counter2) := l_id_tab3(i);

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

19783: FOR i IN l_inventory_item_id_tab3.first..l_inventory_item_id_tab3.last
19784: LOOP
19785: l_t4id_tab(l_trx_assets_counter5) := okc_p_util.raw_to_number(sys_guid());
19786:
19787: l_ti2id_tab(l_txl_itm_insts_counter2) := okc_p_util.raw_to_number(sys_guid());
19788: l_ti2tas_id_tab(l_txl_itm_insts_counter2) := l_t4id_tab(l_trx_assets_counter5);
19789: l_ti2kle_id_tab(l_txl_itm_insts_counter2) := l_id_tab3(i);
19790: -- Change kle_id
19791: l_new_kle_id := find_mapping_id(l_ti2kle_id_tab(l_txl_itm_insts_counter2));

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

20669:
20670: l_curr_pos := 'okl_copy_lease_contract:4';
20671: -- kmotepal populating contract id from sys guid instead of using OKC sequence which fixes the bug 4436545 (Reverted back for OKL.H)
20672: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;
20673: --l_copied_id := okc_p_util.raw_to_number(sys_guid());
20674:
20675: l_contract_currency := c1rec.currency_code;
20676: l_contract_start_date := c1rec.start_date;
20677: l_conversion_type := c1rec.CONVERSION_TYPE;

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

20930: ISA_AGREEMENT_ID, COPIED_ONLY_YN, OBJECT_VERSION_NUMBER,
20931: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
20932: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, SECURITY_GROUP_ID
20933: ) VALUES (
20934: okc_p_util.raw_to_number(sys_guid()), l_copied_id, l_copied_id,
20935: c2rec.CLE_ID, c2rec.CHR_ID_REFERRED, c2rec.CLE_ID_REFERRED,
20936: c2rec.ISA_AGREEMENT_ID, c2rec.COPIED_ONLY_YN, c2rec.OBJECT_VERSION_NUMBER,
20937: l_created_by, SYSDATE, l_last_updated_by,
20938: SYSDATE, l_last_update_login, c2rec.SECURITY_GROUP_ID

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

21126: --l_orig_system_id1_tab(l_counter) := l_orig_system_id1_tab2(i);
21127:
21128: -- Populate proper values
21129: l_orig_system_id1_tab(l_counter) := l_id_tab(l_counter);
21130: l_id_tab(l_counter) := okc_p_util.raw_to_number(sys_guid());
21131: -- Populate proper values done
21132:
21133: -- Store sid mapping for business function processing
21134: l_sid_mapping_tab(l_counter).id := l_id_tab(l_counter);