APPS.OKE_DELIVERABLE_ACTIONS_PKG dependencies on OKE_DELIVERABLE_ACTIONS

Line 1: PACKAGE BODY OKE_DELIVERABLE_ACTIONS_PKG AS

1: PACKAGE BODY OKE_DELIVERABLE_ACTIONS_PKG AS
2: /* $Header: OKEVDACB.pls 120.2 2005/06/27 14:40:33 ausmani noship $ */
3:
4: G_Pkg_Name CONSTANT VARCHAR2(30) := 'OKE_DTS_INTERGRATION';
5:

Line 69: , oke_deliverable_actions oka

65: WHERE NOT EXISTS (
66: SELECT 1
67: FROM mrp_schedule_items mrp
68: , oke_deliverables_b oke
69: , oke_deliverable_actions oka
70: WHERE oka.action_id = p_action_id
71: AND oke.deliverable_id = oka.deliverable_id
72: AND mrp.inventory_item_id = oke.item_id
73: AND mrp.schedule_designator = oka.schedule_designator

Line 89: FROM oke_deliverable_actions

85: L_ID NUMBER;
86:
87: CURSOR c IS
88: SELECT reference2
89: FROM oke_deliverable_actions
90: WHERE action_id = p_action_id;
91:
92: BEGIN
93: OPEN c;

Line 145: , oke_deliverable_actions c

141: , c.task_id
142: , b.unit_number
143: , c.deliverable_id
144: FROM oke_deliverables_b b
145: , oke_deliverable_actions c
146: WHERE c.action_id = p_action_id
147: AND b.deliverable_id = c.deliverable_id;
148:
149: c3info c3%rowtype;

Line 185: , oke_deliverable_actions c

181: , fnd_global.user_id
182: , fnd_global.login_id
183: , d.maximum_bom_level
184: FROM oke_deliverables_b b
185: , oke_deliverable_actions c
186: , bom_parameters d
187: WHERE c.action_id = p_action_id
188: AND c.deliverable_id = b.deliverable_id
189: AND c.ship_from_org_id = d.organization_id;

Line 295: , oke_deliverable_actions c

291: , 1
292: , c.expected_date) workdate
293: , d.primary_uom_code
294: FROM oke_deliverables_b b
295: , oke_deliverable_actions c
296: , mtl_system_items d
297: WHERE c.action_id = p_action_id
298: AND b.deliverable_id = c.deliverable_id
299: AND d.inventory_item_id = b.item_id

Line 360: FROM oke_deliverable_actions

356: L_ID NUMBER;
357:
358: CURSOR c1 IS
359: SELECT reference2
360: FROM oke_deliverable_actions
361: WHERE action_id = p_action_id
362: FOR UPDATE NOWAIT;
363:
364: CURSOR c2 IS

Line 404: UPDATE oke_deliverable_actions

400:
401: IF L_ID IS NOT NULL THEN
402: X_ID := L_ID;
403:
404: UPDATE oke_deliverable_actions
405: SET reference2 = L_ID
406: WHERE action_id = p_action_id
407: AND action_type = 'WSH';
408: END IF;

Line 495: , oke_deliverable_actions c

491: , c.weight_uom_code
492: , nvl(b.currency_code, c.currency_code) currency_code
493: , c.task_id
494: FROM oke_deliverables_b b
495: , oke_deliverable_actions c
496: WHERE c.action_id = p_action_id
497: AND b.deliverable_id = c.deliverable_id;
498:
499: c1info c1%rowtype;

Line 618: UPDATE oke_deliverable_actions

614: , L_Return_Status );
615:
616:
617: IF L_Return_Status = OKE_API.G_Ret_Sts_Success THEN
618: UPDATE oke_deliverable_actions
619: SET reference1 = l_id
620: , in_process_flag = 'Y'
621: , initiate_date = sysdate
622: WHERE action_id = p_action_id;

Line 723: , oke_deliverable_actions c

719: , b.unit_number
720: , c.rate_date
721: , c.rate_type
722: FROM oke_deliverables_b b
723: , oke_deliverable_actions c
724: WHERE c.action_id = p_action_id
725: AND b.deliverable_id = c.deliverable_id;
726:
727: c2info c2%rowtype;

Line 858: UPDATE oke_deliverable_actions

854: , org_organization_definitions ood
855: where ood.organization_id = c2info.inventory_org_id
856: and mp.organization_id = c2info.inventory_org_id;
857:
858: UPDATE oke_deliverable_actions
859: SET reference1 = p_action_id
860: , in_process_flag = 'Y'
861: WHERE action_id = p_action_id;
862: -- COMMIT;

Line 971: FROM oke_deliverable_actions

967:
968: CURSOR c IS
969: SELECT action_id
970: , reference2
971: FROM oke_deliverable_actions
972: WHERE pa_action_id = p_action_id;
973:
974: BEGIN
975: OPEN c;

Line 983: DELETE FROM oke_deliverable_actions

979: IF L_Ref_2 > 0 THEN
980: Delete_Row ( L_Action_ID );
981: END IF;
982:
983: DELETE FROM oke_deliverable_actions
984: WHERE action_id = l_action_id;
985:
986: EXCEPTION
987: WHEN OTHERS THEN

Line 1004: FROM oke_deliverable_actions

1000: WHERE source_deliverable_id = p_deliverable_id;
1001:
1002: CURSOR c_act IS
1003: SELECT pa_action_id
1004: FROM oke_deliverable_actions
1005: WHERE deliverable_id = l_deliverable_id;
1006:
1007: BEGIN
1008: OPEN c;