APPS.OKE_CONTRACT_PVT dependencies on OKE_K_DELIVERABLES_B

Line 993: FROM OKE_K_DELIVERABLES_B

989: v_Index Binary_Integer;
990:
991: CURSOR Child_Cur1(P_Parent_Id IN NUMBER)
992: IS SELECT DELIVERABLE_ID
993: FROM OKE_K_DELIVERABLES_B
994: WHERE parent_deliverable_id=P_Parent_Id;
995:
996: CURSOR Child_Cur2(P_Parent_Id IN NUMBER)
997: IS SELECT DELIVERABLE_ID

Line 998: FROM oke_k_deliverables_b

994: WHERE parent_deliverable_id=P_Parent_Id;
995:
996: CURSOR Child_Cur2(P_Parent_Id IN NUMBER)
997: IS SELECT DELIVERABLE_ID
998: FROM oke_k_deliverables_b
999: WHERE parent_deliverable_id = P_Parent_Id;
1000:
1001: CURSOR Child_Cur3(P_Parent_Id IN NUMBER)
1002: IS SELECT DELIVERABLE_ID

Line 1003: FROM oke_k_deliverables_b

999: WHERE parent_deliverable_id = P_Parent_Id;
1000:
1001: CURSOR Child_Cur3(P_Parent_Id IN NUMBER)
1002: IS SELECT DELIVERABLE_ID
1003: FROM oke_k_deliverables_b
1004: WHERE parent_deliverable_id = P_Parent_Id ;
1005:
1006: CURSOR Child_Cur4(P_Parent_Id IN NUMBER)
1007: IS SELECT DELIVERABLE_ID

Line 1008: FROM oke_k_deliverables_b

1004: WHERE parent_deliverable_id = P_Parent_Id ;
1005:
1006: CURSOR Child_Cur4(P_Parent_Id IN NUMBER)
1007: IS SELECT DELIVERABLE_ID
1008: FROM oke_k_deliverables_b
1009: WHERE parent_deliverable_id=P_Parent_Id;
1010:
1011: CURSOR Child_Cur5(P_Parent_Id IN NUMBER)
1012: IS SELECT DELIVERABLE_ID

Line 1013: FROM oke_k_deliverables_b

1009: WHERE parent_deliverable_id=P_Parent_Id;
1010:
1011: CURSOR Child_Cur5(P_Parent_Id IN NUMBER)
1012: IS SELECT DELIVERABLE_ID
1013: FROM oke_k_deliverables_b
1014: WHERE parent_deliverable_id=P_Parent_Id;
1015:
1016: n NUMBER:=0;
1017: l_del_tbl_in OKE_DELIVERABLE_PVT.del_tbl_type;

Line 1042: SELECT COUNT(*) FROM oke_k_deliverables_b

1038: x_return_status OUT NOCOPY VARCHAR2) IS
1039: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1040: l_Count NUMBER;
1041: CURSOR Cur_Deliverable(P_Deliverable_Id IN NUMBER) IS
1042: SELECT COUNT(*) FROM oke_k_deliverables_b
1043: WHERE deliverable_id=P_Deliverable_Id;
1044: BEGIN
1045: IF p_deliverable_id = OKE_API.G_MISS_NUM OR
1046: P_Deliverable_Id IS NULL

Line 1333: from oke_k_deliverables_b

1329:
1330: delete from oke_dependencies
1331: where deliverable_id in
1332: (select deliverable_id
1333: from oke_k_deliverables_b
1334: where k_header_id = p_header_id);
1335:
1336:
1337: delete from oke_k_billing_methods

Line 1398: (select deliverable_id from OKE_K_DELIVERABLES_BH

1394: where dnz_chr_id = p_header_id);
1395:
1396: delete from OKE_K_DELIVERABLES_TLH
1397: where deliverable_id in
1398: (select deliverable_id from OKE_K_DELIVERABLES_BH
1399: where k_header_id = p_header_id);
1400:
1401: delete from OKE_K_DELIVERABLES_BH
1402: where k_header_id = p_header_id;

Line 1401: delete from OKE_K_DELIVERABLES_BH

1397: where deliverable_id in
1398: (select deliverable_id from OKE_K_DELIVERABLES_BH
1399: where k_header_id = p_header_id);
1400:
1401: delete from OKE_K_DELIVERABLES_BH
1402: where k_header_id = p_header_id;
1403:
1404: delete from OKE_K_FUNDING_SOURCES_H
1405: where object_id = p_header_id and object_type = 'OKE_K_HEADER';