DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_CONTRACT_PARTY_PUB

Line 595: x_cplv_rec_type OUT NOCOPY OKC_CONTRACT_PARTY_PUB.cplv_rec_type) IS

591: ---------------------------------------------------------------------------------------------------
592: -- Local Procedure to migrate from Locally declared cplv record type
593: -- to OKC cplv declared record type
594: PROCEDURE migrate_okl_okc_party(p_cplv_rec_type IN cplv_rec_type,
595: x_cplv_rec_type OUT NOCOPY OKC_CONTRACT_PARTY_PUB.cplv_rec_type) IS
596: BEGIN
597: x_cplv_rec_type.id := p_cplv_rec_type.id;
598: x_cplv_rec_type.cpl_id := p_cplv_rec_type.cpl_id;
599: x_cplv_rec_type.chr_id := p_cplv_rec_type.chr_id;

Line 644: PROCEDURE migrate_okc_okl_party(p_cplv_rec_type IN OKC_CONTRACT_PARTY_PUB.cplv_rec_type,

640: END migrate_okl_okc_party;
641: -------------------------------------------------------------------------------------------------------
642: -- Local Procedure to migrate from OKC declared cplv record type
643: -- to Locally declared cplv record type
644: PROCEDURE migrate_okc_okl_party(p_cplv_rec_type IN OKC_CONTRACT_PARTY_PUB.cplv_rec_type,
645: x_cplv_rec_type OUT NOCOPY cplv_rec_type) IS
646: BEGIN
647: x_cplv_rec_type.id := p_cplv_rec_type.id;
648: x_cplv_rec_type.cpl_id := p_cplv_rec_type.cpl_id;

Line 737: x_ctcv_rec_type OUT NOCOPY OKC_CONTRACT_PARTY_PUB.ctcv_rec_type) IS

733: ---------------------------------------------------------------------------------------------------
734: -- Local Procedure to migrate from Locally declared ctcv record type
735: -- to OKC ctcv declared record type
736: PROCEDURE migrate_okl_okc_contact(p_ctcv_rec_type IN ctcv_rec_type,
737: x_ctcv_rec_type OUT NOCOPY OKC_CONTRACT_PARTY_PUB.ctcv_rec_type) IS
738: BEGIN
739: x_ctcv_rec_type.id := p_ctcv_rec_type.id;
740: x_ctcv_rec_type.cpl_id := p_ctcv_rec_type.cpl_id;
741: x_ctcv_rec_type.cro_code := p_ctcv_rec_type.cro_code;

Line 775: PROCEDURE migrate_okc_okl_contact(p_ctcv_rec_type IN OKC_CONTRACT_PARTY_PUB.ctcv_rec_type,

771: END migrate_okl_okc_contact;
772: ---------------------------------------------------------------------------------------------------
773: -- Local Procedure to migrate from Locally declared ctcv record type
774: -- to OKC ctcv declared record type
775: PROCEDURE migrate_okc_okl_contact(p_ctcv_rec_type IN OKC_CONTRACT_PARTY_PUB.ctcv_rec_type,
776: x_ctcv_rec_type OUT NOCOPY ctcv_rec_type) IS
777: BEGIN
778: x_ctcv_rec_type.id := p_ctcv_rec_type.id;
779: x_ctcv_rec_type.cpl_id := p_ctcv_rec_type.cpl_id;

Line 1649: lr_cplv_rec_type_in OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

1645: x_msg_data OUT NOCOPY VARCHAR2,
1646: p_cplv_rec IN cplv_rec_type,
1647: x_cplv_rec OUT NOCOPY cplv_rec_type) AS
1648:
1649: lr_cplv_rec_type_in OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1650: lr_cplv_rec_type_out OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1651: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CREATE_K_PARTY_ROLE';
1652:
1653: CURSOR role_csr(p_rle_code VARCHAR2) IS

Line 1650: lr_cplv_rec_type_out OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

1646: p_cplv_rec IN cplv_rec_type,
1647: x_cplv_rec OUT NOCOPY cplv_rec_type) AS
1648:
1649: lr_cplv_rec_type_in OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1650: lr_cplv_rec_type_out OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1651: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CREATE_K_PARTY_ROLE';
1652:
1653: CURSOR role_csr(p_rle_code VARCHAR2) IS
1654: SELECT access_level

Line 1718: OKC_CONTRACT_PARTY_PUB.create_k_party_role(p_api_version => p_api_version,

1714: ---- Changes End
1715:
1716:
1717:
1718: OKC_CONTRACT_PARTY_PUB.create_k_party_role(p_api_version => p_api_version,
1719: p_init_msg_list => p_init_msg_list,
1720: x_return_status => x_return_status,
1721: x_msg_count => x_msg_count,
1722: x_msg_data => x_msg_data,

Line 1891: lr_cplv_rec_type_in OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

1887: x_msg_data OUT NOCOPY VARCHAR2,
1888: p_cplv_rec IN cplv_rec_type,
1889: x_cplv_rec OUT NOCOPY cplv_rec_type) AS
1890:
1891: lr_cplv_rec_type_in OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1892: lr_cplv_rec_type_out OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1893: l_api_name CONSTANT VARCHAR2(30) := 'OKL_UPDATE_K_PARTY_ROLE';
1894:
1895: CURSOR role_csr(p_rle_code VARCHAR2) IS

Line 1892: lr_cplv_rec_type_out OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

1888: p_cplv_rec IN cplv_rec_type,
1889: x_cplv_rec OUT NOCOPY cplv_rec_type) AS
1890:
1891: lr_cplv_rec_type_in OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1892: lr_cplv_rec_type_out OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1893: l_api_name CONSTANT VARCHAR2(30) := 'OKL_UPDATE_K_PARTY_ROLE';
1894:
1895: CURSOR role_csr(p_rle_code VARCHAR2) IS
1896: SELECT access_level

Line 1955: OKC_CONTRACT_PARTY_PUB.update_k_party_role(p_api_version => p_api_version,

1951:
1952: -- Calling the actual OKC api
1953:
1954:
1955: OKC_CONTRACT_PARTY_PUB.update_k_party_role(p_api_version => p_api_version,
1956: p_init_msg_list => p_init_msg_list,
1957: x_return_status => x_return_status,
1958: x_msg_count => x_msg_count,
1959: x_msg_data => x_msg_data,

Line 2097: lr_cplv_rec_type_in OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

2093: x_msg_count OUT NOCOPY NUMBER,
2094: x_msg_data OUT NOCOPY VARCHAR2,
2095: p_cplv_rec IN cplv_rec_type) AS
2096:
2097: lr_cplv_rec_type_in OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
2098: l_api_name CONSTANT VARCHAR2(30) := 'OKL_DELETE_K_PARTY_ROLE';
2099:
2100: --cursor to find out chr id required to flip status at edit point
2101: CURSOR chr_id_crs (p_cpl_id IN NUMBER) IS

Line 2164: OKC_CONTRACT_PARTY_PUB.delete_k_party_role(p_api_version => p_api_version,

2160: -- to OKC declared cplv record type as process of input
2161: migrate_okl_okc_party(p_cplv_rec,
2162: lr_cplv_rec_type_in);
2163: -- Calling the actual OKC api
2164: OKC_CONTRACT_PARTY_PUB.delete_k_party_role(p_api_version => p_api_version,
2165: p_init_msg_list => p_init_msg_list,
2166: x_return_status => x_return_status,
2167: x_msg_count => x_msg_count,
2168: x_msg_data => x_msg_data,

Line 2277: lr_ctcv_rec_type_in OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;

2273: x_msg_data OUT NOCOPY VARCHAR2,
2274: p_ctcv_rec IN ctcv_rec_type,
2275: x_ctcv_rec OUT NOCOPY ctcv_rec_type) AS
2276:
2277: lr_ctcv_rec_type_in OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
2278: lr_ctcv_rec_type_out OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
2279: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CREATE_CONTACT';
2280:
2281: CURSOR contact_csr(p_cro_code VARCHAR2, p_cpl_id NUMBER) IS

Line 2278: lr_ctcv_rec_type_out OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;

2274: p_ctcv_rec IN ctcv_rec_type,
2275: x_ctcv_rec OUT NOCOPY ctcv_rec_type) AS
2276:
2277: lr_ctcv_rec_type_in OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
2278: lr_ctcv_rec_type_out OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
2279: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CREATE_CONTACT';
2280:
2281: CURSOR contact_csr(p_cro_code VARCHAR2, p_cpl_id NUMBER) IS
2282: SELECT access_level

Line 2341: OKC_CONTRACT_PARTY_PUB.create_contact(p_api_version => p_api_version,

2337:
2338: ---- Changes End
2339:
2340:
2341: OKC_CONTRACT_PARTY_PUB.create_contact(p_api_version => p_api_version,
2342: p_init_msg_list => p_init_msg_list,
2343: x_return_status => x_return_status,
2344: x_msg_count => x_msg_count,
2345: x_msg_data => x_msg_data,

Line 2483: lr_ctcv_rec_type_in OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;

2479: x_msg_data OUT NOCOPY VARCHAR2,
2480: p_ctcv_rec IN ctcv_rec_type,
2481: x_ctcv_rec OUT NOCOPY ctcv_rec_type) AS
2482:
2483: lr_ctcv_rec_type_in OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
2484: lr_ctcv_rec_type_out OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
2485: l_api_name CONSTANT VARCHAR2(30) := 'OKL_UPDATE_CONTACT';
2486:
2487: CURSOR contact_csr(p_cro_code VARCHAR2, p_cpl_id NUMBER) IS

Line 2484: lr_ctcv_rec_type_out OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;

2480: p_ctcv_rec IN ctcv_rec_type,
2481: x_ctcv_rec OUT NOCOPY ctcv_rec_type) AS
2482:
2483: lr_ctcv_rec_type_in OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
2484: lr_ctcv_rec_type_out OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
2485: l_api_name CONSTANT VARCHAR2(30) := 'OKL_UPDATE_CONTACT';
2486:
2487: CURSOR contact_csr(p_cro_code VARCHAR2, p_cpl_id NUMBER) IS
2488: SELECT access_level

Line 2548: OKC_CONTRACT_PARTY_PUB.update_contact(p_api_version => p_api_version,

2544: ---- Changes End
2545:
2546:
2547: -- Calling the actual OKC api
2548: OKC_CONTRACT_PARTY_PUB.update_contact(p_api_version => p_api_version,
2549: p_init_msg_list => p_init_msg_list,
2550: x_return_status => x_return_status,
2551: x_msg_count => x_msg_count,
2552: x_msg_data => x_msg_data,

Line 2689: lr_ctcv_rec_type_in OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;

2685: x_msg_count OUT NOCOPY NUMBER,
2686: x_msg_data OUT NOCOPY VARCHAR2,
2687: p_ctcv_rec IN ctcv_rec_type) AS
2688:
2689: lr_ctcv_rec_type_in OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
2690: l_api_name CONSTANT VARCHAR2(30) := 'OKL_DELETE_CONTACT';
2691:
2692: --cursor to find out chr id required to flip status at edit point
2693: CURSOR chr_id_crs (p_ctc_id IN NUMBER) IS

Line 2754: OKC_CONTRACT_PARTY_PUB.delete_contact(p_api_version => p_api_version,

2750: -- to OKC declared ctcv record type as process of input
2751: migrate_okl_okc_contact(p_ctcv_rec,
2752: lr_ctcv_rec_type_in);
2753: -- Calling the actual OKC api
2754: OKC_CONTRACT_PARTY_PUB.delete_contact(p_api_version => p_api_version,
2755: p_init_msg_list => p_init_msg_list,
2756: x_return_status => x_return_status,
2757: x_msg_count => x_msg_count,
2758: x_msg_data => x_msg_data,