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_VP_SYNC_CR_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 616: FROM okc_k_party_roles_b cpl

612: cpl.object1_id1,
613: cpl.object1_id2,
614: cpl.jtot_object1_code,
615: cpl.rle_code
616: FROM okc_k_party_roles_b cpl
617: WHERE cpl.chr_id = cp_creq_chr_id
618: AND cpl.jtot_object1_code = 'OKX_PARTY'
619: AND NOT EXISTS (
620: SELECT 'Y'

Line 621: FROM okc_k_party_roles_b orig

617: WHERE cpl.chr_id = cp_creq_chr_id
618: AND cpl.jtot_object1_code = 'OKX_PARTY'
619: AND NOT EXISTS (
620: SELECT 'Y'
621: FROM okc_k_party_roles_b orig
622: WHERE orig.object1_id1 = cpl.object1_id1
623: AND orig.object1_id2 = cpl.object1_id2
624: AND orig.jtot_object1_code = cpl.jtot_object1_code
625: AND orig.rle_code = cpl.rle_code

Line 686: CURSOR c_get_role_contacts_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS

682: /* AND cpl.id = kpl.id;*/
683:
684: cv_get_party_info_rec c_get_party_info_csr%ROWTYPE;
685:
686: CURSOR c_get_role_contacts_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
687: SELECT id
688: FROM okc_contacts
689: WHERE cpl_id = cp_cpl_id;
690:

Line 696: x_cpl_id okc_k_party_roles_b.cpl_id%TYPE;

692: x_cplv_rec cplv_rec_type;
693: lv_ctcv_tbl ctcv_tbl_type;
694: contact_tbl_idx PLS_INTEGER;
695:
696: x_cpl_id okc_k_party_roles_b.cpl_id%TYPE;
697: l_api_version CONSTANT NUMBER DEFAULT 1.0;
698: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_NON_PRIMARY_PARTIES';
699: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_NON_PRIMARY_PARTIES';
700: l_debug_enabled VARCHAR2(10);

Line 854: -- cannot rely on primary_yn of okc_k_party_roles_b as this value is null always

850: END IF; -- end of cursor found case
851: END LOOP;
852:
853: -- synchronize all the non primary parties that have been created on the change request
854: -- cannot rely on primary_yn of okc_k_party_roles_b as this value is null always
855: FOR new_parties_rec IN new_parties_csr(p_creq_chr_id, p_orig_chr_id) LOOP
856: okl_copy_contract_pub.copy_party_roles(p_api_version => 1.0
857: ,p_init_msg_list => OKL_API.G_FALSE
858: ,x_return_status => x_return_status

Line 937: FROM okc_k_party_roles_b role

933: ,contact.object1_id2 contact_object1_id2
934: ,contact.cro_code
935: ,contact.jtot_object1_code contact_object
936: ,contact.id
937: FROM okc_k_party_roles_b role
938: ,okc_contacts contact
939: WHERE role.id = contact.cpl_id
940: AND role.dnz_chr_id = contact.dnz_chr_id
941: AND role.dnz_chr_id = cp_chr_id_1

Line 943: FROM okc_k_party_roles_b role_new

939: WHERE role.id = contact.cpl_id
940: AND role.dnz_chr_id = contact.dnz_chr_id
941: AND role.dnz_chr_id = cp_chr_id_1
942: AND NOT EXISTS(SELECT 'X'
943: FROM okc_k_party_roles_b role_new
944: ,okc_contacts contact_new
945: WHERE role_new.id = contact_new.cpl_id
946: AND role_new.chr_id = contact_new.dnz_chr_id
947: AND role_new.object1_id1 = role.object1_id1

Line 958: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE

954: AND contact_new.jtot_object1_code = contact.jtot_object1_code
955: AND role_new.chr_id = cp_chr_id_2
956: );
957: CURSOR c_get_cpl_csr(cp_dnz_chr_id okc_k_headers_b.id%TYPE
958: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
959: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
960: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
961: ,cp_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE
962: ) IS

Line 959: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE

955: AND role_new.chr_id = cp_chr_id_2
956: );
957: CURSOR c_get_cpl_csr(cp_dnz_chr_id okc_k_headers_b.id%TYPE
958: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
959: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
960: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
961: ,cp_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE
962: ) IS
963: SELECT id

Line 960: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE

956: );
957: CURSOR c_get_cpl_csr(cp_dnz_chr_id okc_k_headers_b.id%TYPE
958: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
959: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
960: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
961: ,cp_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE
962: ) IS
963: SELECT id
964: FROM okc_k_party_roles_b

Line 961: ,cp_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE

957: CURSOR c_get_cpl_csr(cp_dnz_chr_id okc_k_headers_b.id%TYPE
958: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
959: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
960: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
961: ,cp_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE
962: ) IS
963: SELECT id
964: FROM okc_k_party_roles_b
965: WHERE dnz_chr_id = cp_dnz_chr_id

Line 964: FROM okc_k_party_roles_b

960: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
961: ,cp_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE
962: ) IS
963: SELECT id
964: FROM okc_k_party_roles_b
965: WHERE dnz_chr_id = cp_dnz_chr_id
966: AND rle_code = cp_rle_code
967: AND object1_id1 = cp_object1_id1
968: AND object1_id2 = cp_object1_id2

Line 974: lv_cpl_id okc_k_party_roles_b.id%TYPE;

970:
971: lv_ctcv_tbl ctcv_tbl_type;
972: x_ctcv_tbl ctcv_tbl_type;
973: contact_tbl_idx PLS_INTEGER;
974: lv_cpl_id okc_k_party_roles_b.id%TYPE;
975:
976: BEGIN
977: x_return_status := OKL_API.G_RET_STS_SUCCESS;
978:

Line 1341: FROM okc_k_party_roles_b

1337: -- cursor that fetches party role id of Lease Vendor
1338: CURSOR c_get_cpl_id_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
1339: SELECT id
1340: ,object1_id1
1341: FROM okc_k_party_roles_b
1342: WHERE dnz_chr_id = cp_chr_id
1343: AND rle_code = 'OKL_VENDOR'
1344: AND jtot_object1_code = 'OKX_VENDOR';
1345: lv_orig_chr_cpl_id okc_k_party_roles_b.id%TYPE;

Line 1345: lv_orig_chr_cpl_id okc_k_party_roles_b.id%TYPE;

1341: FROM okc_k_party_roles_b
1342: WHERE dnz_chr_id = cp_chr_id
1343: AND rle_code = 'OKL_VENDOR'
1344: AND jtot_object1_code = 'OKX_VENDOR';
1345: lv_orig_chr_cpl_id okc_k_party_roles_b.id%TYPE;
1346: lv_creq_chr_cpl_id okc_k_party_roles_b.id%TYPE;
1347:
1348: lv_orig_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;
1349: lv_creq_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;

Line 1346: lv_creq_chr_cpl_id okc_k_party_roles_b.id%TYPE;

1342: WHERE dnz_chr_id = cp_chr_id
1343: AND rle_code = 'OKL_VENDOR'
1344: AND jtot_object1_code = 'OKX_VENDOR';
1345: lv_orig_chr_cpl_id okc_k_party_roles_b.id%TYPE;
1346: lv_creq_chr_cpl_id okc_k_party_roles_b.id%TYPE;
1347:
1348: lv_orig_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;
1349: lv_creq_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;
1350:

Line 1348: lv_orig_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;

1344: AND jtot_object1_code = 'OKX_VENDOR';
1345: lv_orig_chr_cpl_id okc_k_party_roles_b.id%TYPE;
1346: lv_creq_chr_cpl_id okc_k_party_roles_b.id%TYPE;
1347:
1348: lv_orig_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;
1349: lv_creq_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;
1350:
1351: -- cursor to fetch customer information from the billing page
1352: CURSOR c_get_cust_info_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE) IS

Line 1349: lv_creq_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;

1345: lv_orig_chr_cpl_id okc_k_party_roles_b.id%TYPE;
1346: lv_creq_chr_cpl_id okc_k_party_roles_b.id%TYPE;
1347:
1348: lv_orig_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;
1349: lv_creq_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;
1350:
1351: -- cursor to fetch customer information from the billing page
1352: CURSOR c_get_cust_info_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE) IS
1353: SELECT chrb.id chr_id,

Line 1352: CURSOR c_get_cust_info_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE) IS

1348: lv_orig_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;
1349: lv_creq_chr_object1 okc_k_party_roles_b.object1_id1%TYPE;
1350:
1351: -- cursor to fetch customer information from the billing page
1352: CURSOR c_get_cust_info_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE) IS
1353: SELECT chrb.id chr_id,
1354: rgpb.id rgp_id,
1355: cplv.id cpl_id,
1356: rulb.id cust_rule_id,

Line 2540: FUNCTION get_original_cpl_id(p_new_cpl_id okc_k_party_roles_b.id%TYPE

2536: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_TERMS';
2537: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_TERMS';
2538: l_debug_enabled VARCHAR2(10);
2539:
2540: FUNCTION get_original_cpl_id(p_new_cpl_id okc_k_party_roles_b.id%TYPE
2541: ,p_orig_chr_id okc_k_headers_b.id%TYPE
2542: ,p_creq_chr_id okc_k_headers_b.id%TYPE
2543: ) RETURN NUMBER IS
2544: CURSOR c_get_cpl_id_csr (cp_cpl_id okc_k_party_roles_b.id%TYPE

Line 2544: CURSOR c_get_cpl_id_csr (cp_cpl_id okc_k_party_roles_b.id%TYPE

2540: FUNCTION get_original_cpl_id(p_new_cpl_id okc_k_party_roles_b.id%TYPE
2541: ,p_orig_chr_id okc_k_headers_b.id%TYPE
2542: ,p_creq_chr_id okc_k_headers_b.id%TYPE
2543: ) RETURN NUMBER IS
2544: CURSOR c_get_cpl_id_csr (cp_cpl_id okc_k_party_roles_b.id%TYPE
2545: ,cp_orig_chr_id okc_k_headers_b.id%TYPE
2546: ,cp_creq_chr_id okc_k_headers_b.id%TYPE) IS
2547: SELECT cpl.id
2548: FROM okc_k_party_roles_b cpl

Line 2548: FROM okc_k_party_roles_b cpl

2544: CURSOR c_get_cpl_id_csr (cp_cpl_id okc_k_party_roles_b.id%TYPE
2545: ,cp_orig_chr_id okc_k_headers_b.id%TYPE
2546: ,cp_creq_chr_id okc_k_headers_b.id%TYPE) IS
2547: SELECT cpl.id
2548: FROM okc_k_party_roles_b cpl
2549: ,okc_k_party_roles_b cpl1
2550: WHERE cpl.chr_id = cp_orig_chr_id
2551: AND cpl.rle_code = cpl1.rle_code
2552: AND cpl1.chr_id = cp_creq_chr_id

Line 2549: ,okc_k_party_roles_b cpl1

2545: ,cp_orig_chr_id okc_k_headers_b.id%TYPE
2546: ,cp_creq_chr_id okc_k_headers_b.id%TYPE) IS
2547: SELECT cpl.id
2548: FROM okc_k_party_roles_b cpl
2549: ,okc_k_party_roles_b cpl1
2550: WHERE cpl.chr_id = cp_orig_chr_id
2551: AND cpl.rle_code = cpl1.rle_code
2552: AND cpl1.chr_id = cp_creq_chr_id
2553: AND cpl.object1_id1 = cpl1.object1_id1

Line 2558: lv_return_cpl_id okc_k_party_roles_b.id%TYPE;

2554: AND cpl.object1_id2 = cpl1.object1_id2
2555: AND cpl.jtot_object1_code = cpl1.jtot_object1_code
2556: AND cpl1.id = cp_cpl_id;
2557:
2558: lv_return_cpl_id okc_k_party_roles_b.id%TYPE;
2559: BEGIN
2560: -- the value is always guaranteed in this cursor as the terms are being synced after the parties
2561: -- sync. so even if the party was not on the original agreement, we would still get the id from okc_k_party_roles_b
2562: -- as that record would have been inserted in the table before executing sync_terms api

Line 2561: -- sync. so even if the party was not on the original agreement, we would still get the id from okc_k_party_roles_b

2557:
2558: lv_return_cpl_id okc_k_party_roles_b.id%TYPE;
2559: BEGIN
2560: -- the value is always guaranteed in this cursor as the terms are being synced after the parties
2561: -- sync. so even if the party was not on the original agreement, we would still get the id from okc_k_party_roles_b
2562: -- as that record would have been inserted in the table before executing sync_terms api
2563: OPEN c_get_cpl_id_csr (cp_cpl_id => p_new_cpl_id
2564: ,cp_orig_chr_id => p_orig_chr_id
2565: ,cp_creq_chr_id => p_creq_chr_id);

Line 2965: ,okc_k_party_roles_b role

2961: ,role.object1_id2
2962: ,role.jtot_object1_code
2963: ,role.id cpl_id
2964: FROM okl_party_payment_dtls pay
2965: ,okc_k_party_roles_b role
2966: WHERE pay.cpl_id = role.id
2967: AND role.cle_id IS NULL
2968: AND role.dnz_chr_id = cp_chr_id;
2969:

Line 2971: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE

2967: AND role.cle_id IS NULL
2968: AND role.dnz_chr_id = cp_chr_id;
2969:
2970: CURSOR c_get_orig_disb_csr(cp_chr_id okc_k_headers_b.id%TYPE
2971: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
2972: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
2973: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2974: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2975: SELECT role.id

Line 2972: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE

2968: AND role.dnz_chr_id = cp_chr_id;
2969:
2970: CURSOR c_get_orig_disb_csr(cp_chr_id okc_k_headers_b.id%TYPE
2971: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
2972: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
2973: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2974: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2975: SELECT role.id
2976: ,payment.id payment_id

Line 2973: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE

2969:
2970: CURSOR c_get_orig_disb_csr(cp_chr_id okc_k_headers_b.id%TYPE
2971: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
2972: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
2973: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2974: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2975: SELECT role.id
2976: ,payment.id payment_id
2977: FROM okc_k_party_roles_b role

Line 2974: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS

2970: CURSOR c_get_orig_disb_csr(cp_chr_id okc_k_headers_b.id%TYPE
2971: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
2972: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
2973: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2974: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2975: SELECT role.id
2976: ,payment.id payment_id
2977: FROM okc_k_party_roles_b role
2978: ,okl_party_payment_dtls payment

Line 2977: FROM okc_k_party_roles_b role

2973: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2974: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2975: SELECT role.id
2976: ,payment.id payment_id
2977: FROM okc_k_party_roles_b role
2978: ,okl_party_payment_dtls payment
2979: WHERE role.dnz_chr_id = p_orig_chr_id
2980: AND role.chr_id IS NOT NULL
2981: AND role.chr_id = cp_chr_id

Line 2991: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE

2987: --udhenuko Bug 5201243 Commenting as the vendor and party need not be same
2988: --AND payment.vendor_id = cp_object1_id1;
2989:
2990: CURSOR c_get_party_role_csr(cp_chr_id okc_k_headers_b.id%TYPE
2991: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
2992: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
2993: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2994: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2995: SELECT role.id

Line 2992: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE

2988: --AND payment.vendor_id = cp_object1_id1;
2989:
2990: CURSOR c_get_party_role_csr(cp_chr_id okc_k_headers_b.id%TYPE
2991: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
2992: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
2993: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2994: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2995: SELECT role.id
2996: FROM okc_k_party_roles_b role

Line 2993: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE

2989:
2990: CURSOR c_get_party_role_csr(cp_chr_id okc_k_headers_b.id%TYPE
2991: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
2992: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
2993: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2994: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2995: SELECT role.id
2996: FROM okc_k_party_roles_b role
2997: WHERE role.dnz_chr_id = cp_chr_id

Line 2994: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS

2990: CURSOR c_get_party_role_csr(cp_chr_id okc_k_headers_b.id%TYPE
2991: ,cp_rle_code okc_k_party_roles_b.rle_code%TYPE
2992: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
2993: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2994: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2995: SELECT role.id
2996: FROM okc_k_party_roles_b role
2997: WHERE role.dnz_chr_id = cp_chr_id
2998: AND role.chr_id IS NOT NULL

Line 2996: FROM okc_k_party_roles_b role

2992: ,cp_object1_id1 okc_k_party_roles_b.object1_id1%TYPE
2993: ,cp_object1_id2 okc_k_party_roles_b.object1_id2%TYPE
2994: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2995: SELECT role.id
2996: FROM okc_k_party_roles_b role
2997: WHERE role.dnz_chr_id = cp_chr_id
2998: AND role.chr_id IS NOT NULL
2999: AND role.chr_id = p_orig_chr_id
3000: AND role.rle_code = cp_rle_code

Line 3005: lv_cpl_id okc_k_party_roles_b.id%TYPE;

3001: AND role.object1_id1 = cp_object1_id1
3002: AND role.object1_id2 = cp_object1_id2
3003: AND role.jtot_object1_code = cp_jtot_code;
3004:
3005: lv_cpl_id okc_k_party_roles_b.id%TYPE;
3006: lv_payment_id okl_party_payment_dtls.id%TYPE;
3007:
3008: lv_srfvv_rec okl_subsidy_rfnd_dtls_pvt.srfvv_rec_type;
3009: x_srfvv_rec okl_subsidy_rfnd_dtls_pvt.srfvv_rec_type;

Line 3010: lv_party_role_id okc_k_party_roles_b.id%TYPE;

3006: lv_payment_id okl_party_payment_dtls.id%TYPE;
3007:
3008: lv_srfvv_rec okl_subsidy_rfnd_dtls_pvt.srfvv_rec_type;
3009: x_srfvv_rec okl_subsidy_rfnd_dtls_pvt.srfvv_rec_type;
3010: lv_party_role_id okc_k_party_roles_b.id%TYPE;
3011:
3012: l_api_version CONSTANT NUMBER DEFAULT 1.0;
3013: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SYNC_VENDOR_DISB_SETUP';
3014: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_SYNC_CR_PVT.SYNC_VENDOR_DISB_SETUP';