APPS.OKC_DELETE_CONTRACT_PVT dependencies on OKC_CONDITIONS_PUB

Line 103: l_cnhv_tbl_in OKC_CONDITIONS_PUB.cnhv_tbl_type;

99: --Function DELETE_CONDITION_HEADERS
100:
101: FUNCTION DELETE_CONDITION_HEADERS( p_chr_id number) Return varchar2 IS
102:
103: l_cnhv_tbl_in OKC_CONDITIONS_PUB.cnhv_tbl_type;
104:
105: CURSOR l_cnhv_csr (p_id IN NUMBER) IS
106: SELECT ID
107: FROM OKC_CONDITION_HEADERS_V

Line 117: OKC_CONDITIONS_PUB.DELETE_COND_HDRS(

113: FOR rec IN l_cnhv_csr(p_chr_id)
114: LOOP
115: l_cnhv_tbl_in(1).ID := rec.id;
116:
117: OKC_CONDITIONS_PUB.DELETE_COND_HDRS(
118: p_api_version => l_api_version,
119: p_init_msg_list => l_init_msg_list,
120: x_return_status => l_return_status,
121: x_msg_count => l_msg_count,

Line 158: l_cnlv_tbl_in OKC_CONDITIONS_PUB.cnlv_tbl_type;

154: --Function DELETE_CONDITION_LINES
155:
156: FUNCTION DELETE_CONDITION_LINES( p_chr_id number) Return varchar2 IS
157:
158: l_cnlv_tbl_in OKC_CONDITIONS_PUB.cnlv_tbl_type;
159:
160: CURSOR l_cnlb_csr (p_id IN NUMBER) IS
161: SELECT ID
162: FROM OKC_CONDITION_LINES_V

Line 172: OKC_CONDITIONS_PUB.DELETE_COND_LINES(

168: FOR rec IN l_cnlb_csr(p_chr_id)
169: LOOP
170: l_cnlv_tbl_in(1).ID := rec.id;
171:
172: OKC_CONDITIONS_PUB.DELETE_COND_LINES(
173: p_api_version => l_api_version,
174: p_init_msg_list => l_init_msg_list,
175: x_return_status => l_return_status,
176: x_msg_count => l_msg_count,

Line 574: l_fepv_tbl_in OKC_CONDITIONS_PUB.fepv_tbl_type;

570: --Function DELETE_FUNCTION_EXPR_PARAMS
571:
572: FUNCTION DELETE_FUNCTION_EXPR_PARAMS( p_chr_id number) Return varchar2 IS
573:
574: l_fepv_tbl_in OKC_CONDITIONS_PUB.fepv_tbl_type;
575:
576: CURSOR l_fepv_csr (p_id IN NUMBER) IS
577: SELECT ID
578: FROM OKC_FUNCTION_EXPR_PARAMS_V

Line 589: OKC_CONDITIONS_PUB.DELETE_FUNC_EXPRS(

585: LOOP
586:
587: l_fepv_tbl_in(1).ID := rec.id;
588:
589: OKC_CONDITIONS_PUB.DELETE_FUNC_EXPRS(
590: p_api_version => l_api_version,
591: p_init_msg_list => l_init_msg_list,
592: x_return_status => l_return_status,
593: x_msg_count => l_msg_count,