APPS.AMS_DELIVERABLES_ALL_PKG dependencies on AMS_DELIVERABLES_ALL_B

Line 73: cursor C is select ROWID from AMS_DELIVERABLES_ALL_B

69: X_LAST_UPDATE_DATE in DATE,
70: X_LAST_UPDATED_BY in NUMBER,
71: X_LAST_UPDATE_LOGIN in NUMBER
72: ) is
73: cursor C is select ROWID from AMS_DELIVERABLES_ALL_B
74: where DELIVERABLE_ID = X_DELIVERABLE_ID
75: ;
76: begin
77: insert into AMS_DELIVERABLES_ALL_B (

Line 77: insert into AMS_DELIVERABLES_ALL_B (

73: cursor C is select ROWID from AMS_DELIVERABLES_ALL_B
74: where DELIVERABLE_ID = X_DELIVERABLE_ID
75: ;
76: begin
77: insert into AMS_DELIVERABLES_ALL_B (
78: NON_INV_CTRL_CODE,
79: NON_INV_QUANTITY_ON_HAND,
80: NON_INV_QUANTITY_ON_ORDER,
81: NON_INV_QUANTITY_ON_RESERVE,

Line 375: from AMS_DELIVERABLES_ALL_B

371: KIT_FLAG,
372: INVENTORY_FLAG,
373: INVENTORY_ITEM_ID,
374: INVENTORY_ITEM_ORG_ID
375: from AMS_DELIVERABLES_ALL_B
376: where DELIVERABLE_ID = X_DELIVERABLE_ID
377: for update of DELIVERABLE_ID nowait;
378: recinfo c%rowtype;
379:

Line 604: update AMS_DELIVERABLES_ALL_B set

600: X_LAST_UPDATED_BY in NUMBER,
601: X_LAST_UPDATE_LOGIN in NUMBER
602: ) is
603: begin
604: update AMS_DELIVERABLES_ALL_B set
605: NON_INV_CTRL_CODE = X_NON_INV_CTRL_CODE,
606: NON_INV_QUANTITY_ON_HAND = X_NON_INV_QUANTITY_ON_HAND,
607: NON_INV_QUANTITY_ON_ORDER = X_NON_INV_QUANTITY_ON_ORDER,
608: NON_INV_QUANTITY_ON_RESERVE = X_NON_INV_QUANTITY_ON_RESERVE,

Line 699: delete from AMS_DELIVERABLES_ALL_B

695: if (sql%notfound) then
696: raise no_data_found;
697: end if;
698:
699: delete from AMS_DELIVERABLES_ALL_B
700: where DELIVERABLE_ID = X_DELIVERABLE_ID;
701:
702: if (sql%notfound) then
703: raise no_data_found;

Line 713: from AMS_DELIVERABLES_ALL_B B

709: begin
710: delete from AMS_DELIVERABLES_ALL_TL T
711: where not exists
712: (select NULL
713: from AMS_DELIVERABLES_ALL_B B
714: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
715: );
716:
717: update AMS_DELIVERABLES_ALL_TL T set (

Line 864: from AMS_DELIVERABLES_ALL_B

860: l_deliverable_id number;
861:
862: cursor c_obj_verno is
863: select object_version_number
864: from AMS_DELIVERABLES_ALL_B
865: where deliverable_id = X_DELIVERABLE_ID;
866:
867: cursor c_chk_del_exists is
868: select 'x'

Line 869: from AMS_DELIVERABLES_ALL_B

865: where deliverable_id = X_DELIVERABLE_ID;
866:
867: cursor c_chk_del_exists is
868: select 'x'
869: from AMS_DELIVERABLES_ALL_B
870: where deliverable_id = X_DELIVERABLE_ID;
871:
872: cursor c_get_delid is
873: select AMS_DELIVERABLES_ALL_B_S.nextval

Line 873: select AMS_DELIVERABLES_ALL_B_S.nextval

869: from AMS_DELIVERABLES_ALL_B
870: where deliverable_id = X_DELIVERABLE_ID;
871:
872: cursor c_get_delid is
873: select AMS_DELIVERABLES_ALL_B_S.nextval
874: from dual;
875:
876: BEGIN
877: