APPS.OKE_DELIVERABLE_UTILS_PKG dependencies on OKE_DELIVERABLE_ACTIONS

Line 181: from oke_deliverable_actions

177: ) is
178:
179: cursor c_flag is
180: select count(1)
181: from oke_deliverable_actions
182: where deliverable_id = X_DELIVERABLE_ID
183: and nvl(ready_flag, 'N') = 'Y';
184:
185: l_count NUMBER := 0;

Line 344: from oke_deliverable_actions a,

340: X_FLAG out NOCOPY VARCHAR2
341: ) is
342: cursor c_1 is
343: select 'Y'
344: from oke_deliverable_actions a,
345: oke_deliverables_b b
346: where a.deliverable_id = b.deliverable_id
347: and a.action_type = X_ACTION_TYPE
348: and b.source_code = X_SOURCE_CODE

Line 523: INSERT INTO oke_deliverable_actions (

519: ,x_proc_name => x_proc_name
520: ,x_proc_due_date => x_proc_due_date
521: );
522: IF( x_ship_id IS NOT NULL ) THEN
523: INSERT INTO oke_deliverable_actions (
524: ACTION_ID
525: , CREATION_DATE
526: , CREATED_BY
527: , LAST_UPDATE_DATE

Line 560: INSERT INTO oke_deliverable_actions (

556: , X_INVENTORY_ORG_ID
557: );
558: END IF;
559: IF( x_proc_id IS NOT NULL ) THEN
560: INSERT INTO oke_deliverable_actions (
561: ACTION_ID
562: , CREATION_DATE
563: , CREATED_BY
564: , LAST_UPDATE_DATE

Line 645: select 'X' from oke_deliverable_actions where

641: X_LAST_UPDATED_BY in NUMBER,
642: X_LAST_UPDATE_LOGIN in NUMBER
643: ) is
644: Cursor c_check_inv_org(b_inv_org_id number,b_deliverable_id number) IS
645: select 'X' from oke_deliverable_actions where
646: deliverable_id=b_deliverable_id and
647: ( ( ship_from_org_id = b_inv_org_id and action_type = 'WSH' )
648: or (ship_to_org_id = b_inv_org_id and action_type = 'REQ' ) );
649:

Line 698: update oke_deliverable_actions

694: X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN);
695:
696: if (PA_DELIVERABLE_UTILS.Is_Dlvr_Item_Based ( x_source_deliverable_id ) = 'Y') then
697:
698: update oke_deliverable_actions
699: set uom_code = x_uom_code,
700: quantity = x_quantity,
701: unit_price = x_unit_price,
702: currency_code = x_currency_code

Line 717: update oke_deliverable_actions

713: l_location_count := l_Location_count +1;
714: end loop;
715: close c_get_location;
716:
717: update oke_deliverable_actions
718: set ship_from_org_id = x_inventory_org_id,
719: schedule_designator = null,
720: ship_from_location_id = decode( l_location_count, 1 , l_location_id, NULL)
721: where deliverable_id = x_deliverable_id

Line 724: update oke_deliverable_actions

720: ship_from_location_id = decode( l_location_count, 1 , l_location_id, NULL)
721: where deliverable_id = x_deliverable_id
722: and action_type = 'WSH';
723:
724: update oke_deliverable_actions
725: set ship_to_org_id = x_inventory_org_id,
726: ship_to_location_id = decode( l_location_count, 1 , l_location_id, NULL),
727: expenditure_organization_id = NULL
728: where deliverable_id = x_deliverable_id

Line 734: update oke_deliverable_actions

730: end if;
731:
732: else
733:
734: update oke_deliverable_actions
735: set destination_type_code = 'EXPENSE'
736: where deliverable_id = x_deliverable_id
737: and action_type = 'REQ';
738:

Line 850: update oke_deliverable_actions set expected_date = p_expected_date

846: p_pa_action_id in NUMBER,
847: p_expected_date in DATE
848: ) return Varchar2 IS
849: begin
850: update oke_deliverable_actions set expected_date = p_expected_date
851: where pa_action_id=p_pa_action_id
852: ;
853: if sql%rowcount <> 1 then
854: return fnd_api.g_false;