APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on OKC_REP_CONTRACT_RELS

Line 2839: * Procedure to migrate date from okc_rep_contract_rels table to okc_rep_contract_usages table.

2835: END cancel_contract;
2836:
2837:
2838: /*
2839: * Procedure to migrate date from okc_rep_contract_rels table to okc_rep_contract_usages table.
2840: * This migration is applicable for 12.2.2.
2841: * 1. For one row in okc_rep_contract_rels table, all the target related contracts are brought and these are inserted
2842: * against each version of source contract.
2843: * 2. If the relationship(combination of contract_id, contract_type, contract_version_num, business_document_id, business_document_type,

Line 2841: * 1. For one row in okc_rep_contract_rels table, all the target related contracts are brought and these are inserted

2837:
2838: /*
2839: * Procedure to migrate date from okc_rep_contract_rels table to okc_rep_contract_usages table.
2840: * This migration is applicable for 12.2.2.
2841: * 1. For one row in okc_rep_contract_rels table, all the target related contracts are brought and these are inserted
2842: * against each version of source contract.
2843: * 2. If the relationship(combination of contract_id, contract_type, contract_version_num, business_document_id, business_document_type,
2844: business_document_version, relationship_role_id) already exists in the new table (okc_rep_contract_usages), then this procedure doesn't insert it again in the new table
2845: * 3. Marks the rows in okc_rep_contract_usagaes with source_code as 'MIGRATION' and populates corresponding requires_id, program_id.

Line 2913: FROM okc_rep_contract_rels rels,

2909: rels.creation_date,
2910: rels.last_updated_by,
2911: rels.last_update_date,
2912: rels.last_update_login
2913: FROM okc_rep_contract_rels rels,
2914: okc_rep_contracts_all src,
2915: okc_rep_contracts_all tgt
2916: WHERE src.contract_id = rels.contract_id
2917: AND tgt.contract_id = rels.related_contract_id

Line 2942: FROM okc_rep_contract_rels rels,

2938: rels.creation_date,
2939: rels.last_updated_by,
2940: rels.last_update_date,
2941: rels.last_update_login
2942: FROM okc_rep_contract_rels rels,
2943: okc_rep_contract_vers src_vers,
2944: okc_rep_contracts_all tgt
2945: WHERE src_vers.contract_id = rels.contract_id
2946: AND tgt.contract_id = rels.related_contract_id

Line 2979: FROM okc_rep_contract_rels;

2975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'g_prog_appl_id:' || g_prog_appl_id);
2976:
2977: BEGIN
2978: SELECT count(1) INTO l_source_rels
2979: FROM okc_rep_contract_rels;
2980:
2981: SELECT sum(con.contract_version_num) INTO l_source_rows
2982: FROM okc_rep_contract_rels rels, okc_rep_contracts_all con
2983: WHERE rels.contract_id = con.contract_id;

Line 2982: FROM okc_rep_contract_rels rels, okc_rep_contracts_all con

2978: SELECT count(1) INTO l_source_rels
2979: FROM okc_rep_contract_rels;
2980:
2981: SELECT sum(con.contract_version_num) INTO l_source_rows
2982: FROM okc_rep_contract_rels rels, okc_rep_contracts_all con
2983: WHERE rels.contract_id = con.contract_id;
2984:
2985: SELECT count(1) INTO l_already_migrated
2986: FROM okc_rep_contract_usages usages

Line 2993: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of rows in okc_rep_contract_rels table: ' || l_source_rels);

2989: WHEN OTHERS THEN
2990: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured: ' || sqlerrm);
2991: END;
2992:
2993: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of rows in okc_rep_contract_rels table: ' || l_source_rels);
2994: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Expected no. of rows to be migrated: ' || l_source_rows);
2995: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows which are already migrated (rows with source_code as MIGRATION): ' || l_already_migrated);
2996:
2997: IF nvl(p_purge_and_rerun, 'No') = 'Yes' THEN