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 1222: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id and nvl(defaulted_flag, 'N') = 'Y')

1218: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
1219: where h.id = p_id
1220: and l.header_id = p_id
1221: and h.id = k.k_header_id
1222: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id and nvl(defaulted_flag, 'N') = 'Y')
1223: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)
1224: and exists (select 'x' from okc_assents a
1225: where a.opn_code = 'CREATE_DELV'
1226: and a.sts_code = l.status_code

Line 1383: FROM oke_k_deliverables_b

1379: and k.k_header_id = l.header_id;
1380:
1381: CURSOR C IS
1382: SELECT Deliverable_ID, Mps_Transaction_ID
1383: FROM oke_k_deliverables_b
1384: WHERE K_Line_ID = P_Line_ID
1385: AND NVL(Defaulted_Flag, 'N') = 'Y';
1386:
1387: Update_L_Rec Update_L_C%ROWTYPE;

Line 1602: from oke_k_lines_v l, oke_k_deliverables_b b

1598: L_Token_Value VARCHAR2(2000);
1599:
1600: CURSOR Update_C ( P_ID NUMBER ) IS
1601: SELECT l.k_line_id, b.deliverable_ID, l.line_number
1602: from oke_k_lines_v l, oke_k_deliverables_b b
1603: where b.k_header_id = p_id
1604: and b.k_line_id = l.k_line_id
1605: and nvl(l.scheduled_delv_default, 'N') = 'Y'
1606: and nvl(defaulted_flag, 'N') = 'Y'

Line 1674: UPDATE oke_k_deliverables_b

1670: , X_Msg_Count => L_Msg_Count );
1671:
1672: ELSE
1673:
1674: UPDATE oke_k_deliverables_b
1675: SET Create_Demand = 'N'
1676: WHERE Deliverable_ID = Update_Rec.Deliverable_ID;
1677:
1678: END IF;

Line 1898: FROM OKE_K_DELIVERABLES_B

1894: L_Next_Token VARCHAR2(150);
1895:
1896: CURSOR C IS
1897: SELECT Mps_Transaction_ID, Deliverable_ID, Create_Demand
1898: FROM OKE_K_DELIVERABLES_B
1899: WHERE K_Line_ID = P_Line_ID
1900: AND NVL(Defaulted_Flag, 'N') = 'Y'
1901: AND NVL(Create_Demand, 'N') = 'Y';
1902: