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.4 2012/03/07 11:12:47 skuchima ship $ */
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 873: UPDATE oke_deliverable_actions

869: , org_organization_definitions ood
870: where ood.organization_id = c2info.inventory_org_id
871: and mp.organization_id = c2info.inventory_org_id;
872:
873: UPDATE oke_deliverable_actions
874: SET reference1 = p_action_id
875: , in_process_flag = 'Y'
876: WHERE action_id = p_action_id;
877: -- COMMIT;

Line 986: FROM oke_deliverable_actions

982:
983: CURSOR c IS
984: SELECT action_id
985: , reference2
986: FROM oke_deliverable_actions
987: WHERE pa_action_id = p_action_id;
988:
989: BEGIN
990: OPEN c;

Line 998: DELETE FROM oke_deliverable_actions

994: IF L_Ref_2 > 0 THEN
995: Delete_Row ( L_Action_ID );
996: END IF;
997:
998: DELETE FROM oke_deliverable_actions
999: WHERE action_id = l_action_id;
1000:
1001: EXCEPTION
1002: WHEN OTHERS THEN

Line 1019: FROM oke_deliverable_actions

1015: WHERE source_deliverable_id = p_deliverable_id;
1016:
1017: CURSOR c_act IS
1018: SELECT pa_action_id
1019: FROM oke_deliverable_actions
1020: WHERE deliverable_id = l_deliverable_id;
1021:
1022: BEGIN
1023: OPEN c;