APPS.OKC_DELETE_CONTRACT_PVT dependencies on OKC_CONTRACT_PUB

Line 631: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;

627: --Function DELETE_GOVERNANCES
628:
629: FUNCTION DELETE_GOVERNANCES( p_chr_id number) Return varchar2 IS
630:
631: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
632:
633: CURSOR l_gvev_csr (p_id IN NUMBER) IS
634: SELECT ID
635: FROM OKC_GOVERNANCES_V

Line 647: okc_contract_pub.delete_governance (

643: LOOP
644:
645: l_gvev_tbl_in(1).ID := rec.id;
646:
647: okc_contract_pub.delete_governance (
648: p_api_version => l_api_version,
649: p_init_msg_list => l_init_msg_list,
650: x_return_status => l_return_status,
651: x_msg_count => l_msg_count,

Line 689: l_cacv_tbl_in okc_contract_pub.cacv_tbl_type;

685: --Function DELETE_K_ACCESSES
686:
687: FUNCTION DELETE_K_ACCESSES( p_chr_id number) Return varchar2 IS
688:
689: l_cacv_tbl_in okc_contract_pub.cacv_tbl_type;
690:
691: CURSOR l_cacv_csr (p_id IN NUMBER) IS
692: SELECT ID
693: FROM OKC_K_ACCESSES_V

Line 704: OKC_CONTRACT_PUB.Delete_Contract_Access (

700: FOR rec IN l_cacv_csr(p_chr_id)
701: LOOP
702: l_cacv_tbl_in(1).ID := rec.id;
703:
704: OKC_CONTRACT_PUB.Delete_Contract_Access (
705: p_api_version => l_api_version,
706: p_init_msg_list => l_init_msg_list,
707: x_return_status => l_return_status,
708: x_msg_count => l_msg_count,

Line 857: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;

853: --Function DELETE_K_HEADERS
854:
855: FUNCTION DELETE_K_HEADERS( p_chr_id number ) Return varchar2 IS
856:
857: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
858: l_clean_relink_flag VARCHAR2(10) := 'CLEAN';
859: Begin
860:
861: l_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 907: OKC_CONTRACT_PUB.Delete_Contract_Header (

903: p_token3 => G_SQLERRM_TOKEN,
904: p_token3_value => sqlerrm);
905: End If;
906:
907: OKC_CONTRACT_PUB.Delete_Contract_Header (
908: p_api_version => l_api_version,
909: p_init_msg_list => l_init_msg_list,
910: x_return_status => l_return_status,
911: x_msg_count => l_msg_count,

Line 1004: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;

1000: --Function DELETE_K_LINES
1001:
1002: FUNCTION DELETE_K_LINES( p_chr_id number) Return varchar2 IS
1003:
1004: l_clev_tbl_in OKC_CONTRACT_PUB.clev_tbl_type;
1005: l_cle_id NUMBER;
1006: l_not_found BOOLEAN;
1007:
1008: CURSOR l_clev_csr (p_id IN NUMBER) IS

Line 1030: OKC_CONTRACT_PUB.Delete_Contract_Line(

1026: For rec in l_clev_csr(p_chr_id)
1027: Loop
1028: l_clev_tbl_in(1).ID := rec.id;
1029:
1030: OKC_CONTRACT_PUB.Delete_Contract_Line(
1031: p_api_version => l_api_version,
1032: p_init_msg_list => l_init_msg_list,
1033: x_return_status => l_return_status,
1034: x_msg_count => l_msg_count,

Line 1130: l_cpsv_tbl_in OKC_CONTRACT_PUB.cpsv_tbl_type;

1126: --Function DELETE_K_PROCESSES
1127:
1128: FUNCTION DELETE_K_PROCESSES( p_chr_id number) Return varchar2 IS
1129:
1130: l_cpsv_tbl_in OKC_CONTRACT_PUB.cpsv_tbl_type;
1131:
1132: CURSOR l_cpsv_csr (p_id IN NUMBER) IS
1133: SELECT ID
1134: FROM OKC_K_PROCESSES_V

Line 1145: OKC_CONTRACT_PUB.Delete_Contract_Process (

1141: FOR rec IN l_cpsv_csr(p_chr_id)
1142: LOOP
1143: l_cpsv_tbl_in(1).ID := rec.id;
1144:
1145: OKC_CONTRACT_PUB.Delete_Contract_Process (
1146: p_api_version => l_api_version,
1147: p_init_msg_list => l_init_msg_list,
1148: x_return_status => l_return_status,
1149: x_msg_count => l_msg_count,

Line 1599: p_chrv_rec IN OKC_CONTRACT_PUB.chrv_rec_type) IS

1595: p_init_msg_list IN VARCHAR2 ,
1596: x_return_status OUT NOCOPY VARCHAR2,
1597: x_msg_count OUT NOCOPY NUMBER,
1598: x_msg_data OUT NOCOPY VARCHAR2,
1599: p_chrv_rec IN OKC_CONTRACT_PUB.chrv_rec_type) IS
1600:
1601: l_api_name VARCHAR2(30) := 'V_Delete_Contract';
1602: l_delete_allowed VARCHAR2(1);
1603: DELETE_NOT_ALLOWED Exception;