APPS.OKE_DEFAULTING_PKG dependencies on OKE_K_DELIVERABLES_B

Line 632: FROM oke_k_deliverables_b

628: L_Completed VARCHAR2(1);
629:
630: CURSOR Exist_C IS
631: SELECT Count(*)
632: FROM oke_k_deliverables_b
633: WHERE K_Line_ID = P_Line_ID
634: AND NVL(Defaulted_Flag, 'N') = 'Y';
635:
636: CURSOR Qualify_C IS

Line 642: FROM oke_k_deliverables_b

638: , NVL(Ready_To_Procure, 'N')
639: , NVL(Available_For_Ship_Flag, 'N')
640: , NVL(Ready_To_Bill, 'N')
641: , NVL(Completed_Flag, 'N')
642: FROM oke_k_deliverables_b
643: WHERE K_Line_ID = P_Line_ID
644: AND NVL(Defaulted_Flag, 'N') = 'Y';
645:
646: BEGIN

Line 1200: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id and nvl(defaulted_flag, 'N') = 'Y')

1196: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
1197: where h.id = p_id
1198: and l.header_id = p_id
1199: and h.id = k.k_header_id
1200: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id and nvl(defaulted_flag, 'N') = 'Y')
1201: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)
1202: and exists (select 'x' from okc_assents a
1203: where a.opn_code = 'CREATE_DELV'
1204: and a.sts_code = l.status_code

Line 1361: FROM oke_k_deliverables_b

1357: and k.k_header_id = l.header_id;
1358:
1359: CURSOR C IS
1360: SELECT Deliverable_ID, Mps_Transaction_ID
1361: FROM oke_k_deliverables_b
1362: WHERE K_Line_ID = P_Line_ID
1363: AND NVL(Defaulted_Flag, 'N') = 'Y';
1364:
1365: Update_L_Rec Update_L_C%ROWTYPE;

Line 1580: from oke_k_lines_v l, oke_k_deliverables_b b

1576: L_Token_Value VARCHAR2(2000);
1577:
1578: CURSOR Update_C ( P_ID NUMBER ) IS
1579: SELECT l.k_line_id, b.deliverable_ID, l.line_number
1580: from oke_k_lines_v l, oke_k_deliverables_b b
1581: where b.k_header_id = p_id
1582: and b.k_line_id = l.k_line_id
1583: and nvl(l.scheduled_delv_default, 'N') = 'Y'
1584: and nvl(defaulted_flag, 'N') = 'Y'

Line 1652: UPDATE oke_k_deliverables_b

1648: , X_Msg_Count => L_Msg_Count );
1649:
1650: ELSE
1651:
1652: UPDATE oke_k_deliverables_b
1653: SET Create_Demand = 'N'
1654: WHERE Deliverable_ID = Update_Rec.Deliverable_ID;
1655:
1656: END IF;

Line 1876: FROM OKE_K_DELIVERABLES_B

1872: L_Next_Token VARCHAR2(150);
1873:
1874: CURSOR C IS
1875: SELECT Mps_Transaction_ID, Deliverable_ID, Create_Demand
1876: FROM OKE_K_DELIVERABLES_B
1877: WHERE K_Line_ID = P_Line_ID
1878: AND NVL(Defaulted_Flag, 'N') = 'Y'
1879: AND NVL(Create_Demand, 'N') = 'Y';
1880: