APPS.OKE_DELIVERABLE_UTILS_PKG dependencies on OKE_DELIVERABLES_B

Line 28: from oke_deliverables_b

24: ) is
25:
26: cursor c_check_item is
27: select deliverable_id
28: from oke_deliverables_b
29: where source_code = nvl(X_SOURCE_CODE, '-99')
30: and source_header_id = X_SOURCE_HEADER_ID
31: --and deliverable_number = X_DELIVERABLE_NUM
32: and source_deliverable_id = X_SOURCE_DELIVERABLE_ID;

Line 140: from oke_deliverables_b b,

136: l.name location_name,
137: b.deliverable_id,
138: b.quantity,
139: b.uom_code
140: from oke_deliverables_b b,
141: hr_all_organization_units_vl v,
142: okx_locations_v l
143: --po_supplier_sites_val_v l
144: where source_code = x_source_code

Line 219: update oke_deliverables_b

215: X_SOURCE_DELIVERABLE_ID in NUMBER
216: ) is
217: begin
218:
219: update oke_deliverables_b
220: set quantity = X_QUANTITY
221: where source_code = X_SOURCE_CODE
222: and source_header_id = X_SOURCE_HEADER_ID
223: and source_deliverable_id = X_SOURCE_DELIVERABLE_ID;

Line 265: from oke_deliverables_b b,

261: uom_code,
262: inventory_org_id,
263: v.organization_name,
264: currency_code
265: from oke_deliverables_b b,
266: org_organization_definitions v
267: where source_code = X_SOURCE_CODE
268: and source_header_id = X_SOURCE_HEADER_ID
269: and source_deliverable_id = X_SOURCE_DELIVERABLE_ID

Line 309: from oke_deliverables_b b

305:
306: cursor c_id is
307: select deliverable_id,
308: currency_code
309: from oke_deliverables_b b
310: where source_code = X_SOURCE_CODE
311: and source_header_id = X_SOURCE_HEADER_ID
312: and source_deliverable_id = X_SOURCE_DELIVERABLE_ID;
313:

Line 345: oke_deliverables_b b

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
349: and b.source_deliverable_id = X_SOURCE_DELIVERABLE_ID

Line 381: update oke_deliverables_b

377: X_SOURCE_DELIVERABLE_ID in NUMBER
378: ) is
379: begin
380:
381: update oke_deliverables_b
382: set currency_code = X_CURRENCY_CODE
383: where source_code = X_SOURCE_CODE
384: and source_header_id = X_SOURCE_HEADER_ID
385: and source_deliverable_id = X_SOURCE_DELIVERABLE_ID;

Line 408: update oke_deliverables_b

404: X_SOURCE_DELIVERABLE_ID in NUMBER
405: ) is
406: begin
407:
408: update oke_deliverables_b
409: set unit_price = X_UNIT_PRICE
410: where source_code = X_SOURCE_CODE
411: and source_header_id = X_SOURCE_HEADER_ID
412: and source_deliverable_id = X_SOURCE_DELIVERABLE_ID;

Line 419: * Usage: To insert a row in oke_deliverables_b

415:
416:
417: /*
418: * Procedure Name: Insert_Row
419: * Usage: To insert a row in oke_deliverables_b
420: *
421: */
422:
423: procedure INSERT_ROW (

Line 602: * Usage: To update a row in oke_deliverables_b

598: end INSERT_ROW;
599:
600: /*
601: * Procedure Name: Update_Row
602: * Usage: To update a row in oke_deliverables_b
603: *
604: */
605:
606: procedure UPDATE_ROW (

Line 745: * Usage: To lock a row in oke_deliverables_b

741: end UPDATE_ROW;
742:
743: /*
744: * Procedure Name: Lock_Row
745: * Usage: To lock a row in oke_deliverables_b
746: *
747: */
748:
749: procedure LOCK_ROW (

Line 822: * Usage: To delete a row in oke_deliverables_b

818: end LOCK_ROW;
819:
820: /*
821: * Procedure Name: Delete_Row
822: * Usage: To delete a row in oke_deliverables_b
823: *
824: */
825:
826: procedure DELETE_ROW (