DBA Data[Home] [Help]

APPS.OKC_DELETE_CONTRACT_PVT dependencies on OKC_CONTRACT_PARTY_PUB

Line 457: l_ctcv_tbl_in OKC_CONTRACT_PARTY_PUB.ctcv_tbl_type;

453: --Function DELETE_CONTACTS
454:
455: FUNCTION DELETE_CONTACTS( p_chr_id number) Return varchar2 IS
456:
457: l_ctcv_tbl_in OKC_CONTRACT_PARTY_PUB.ctcv_tbl_type;
458:
459: CURSOR l_ctc_csr (p_id IN NUMBER) IS
460: SELECT ID
461: FROM OKC_CONTACTS_V

Line 472: OKC_CONTRACT_PARTY_PUB.Delete_Contact(

468: LOOP
469:
470: l_ctcv_tbl_in(1).ID := rec.id;
471:
472: OKC_CONTRACT_PARTY_PUB.Delete_Contact(
473: p_api_version => l_api_version,
474: p_init_msg_list => l_init_msg_list,
475: x_return_status => l_return_status,
476: x_msg_count => l_msg_count,

Line 1072: l_cplv_tbl_in OKC_CONTRACT_PARTY_PUB.cplv_tbl_type;

1068: --Function DELETE_K_PARTY_ROLES
1069:
1070: FUNCTION DELETE_K_PARTY_ROLES( p_chr_id number) Return varchar2 IS
1071:
1072: l_cplv_tbl_in OKC_CONTRACT_PARTY_PUB.cplv_tbl_type;
1073:
1074: CURSOR l_cplv_csr (p_id IN NUMBER) IS
1075: SELECT ID
1076: FROM OKC_K_PARTY_ROLES_V

Line 1087: OKC_CONTRACT_PARTY_PUB.DELETE_K_PARTY_ROLE (

1083: FOR rec IN l_cplv_csr(p_chr_id)
1084: LOOP
1085: l_cplv_tbl_in(1).ID := rec.id;
1086:
1087: OKC_CONTRACT_PARTY_PUB.DELETE_K_PARTY_ROLE (
1088: p_api_version => l_api_version,
1089: p_init_msg_list => l_init_msg_list,
1090: x_return_status => l_return_status,
1091: x_msg_count => l_msg_count,