APPS.EGO_ITEM_GTN_ATTRS_PKG dependencies on EGO_ITEM_GTN_ATTRS_B

Line 124: cursor C is select ROWID from EGO_ITEM_GTN_ATTRS_B

120: X_LAST_UPDATE_DATE in DATE,
121: X_LAST_UPDATED_BY in NUMBER,
122: X_LAST_UPDATE_LOGIN in NUMBER
123: ) is
124: cursor C is select ROWID from EGO_ITEM_GTN_ATTRS_B
125: where EXTENSION_ID = X_EXTENSION_ID
126: ;
127: begin
128: insert into EGO_ITEM_GTN_ATTRS_B (

Line 128: insert into EGO_ITEM_GTN_ATTRS_B (

124: cursor C is select ROWID from EGO_ITEM_GTN_ATTRS_B
125: where EXTENSION_ID = X_EXTENSION_ID
126: ;
127: begin
128: insert into EGO_ITEM_GTN_ATTRS_B (
129: REQUEST_ID,
130: DELIVERY_TO_MRKT_TEMP_MIN,
131: UOM_DELIVERY_TO_MRKT_TEMP_MIN,
132: SUB_BRAND,

Line 635: from EGO_ITEM_GTN_ATTRS_B

631: IS_OUT_OF_BOX_PROVIDED,
632: REGISTRATION_UPDATE_DATE,
633: TP_NEUTRAL_UPDATE_DATE,
634: IS_BARCODE_SYMBOLOGY_DERIVABLE
635: from EGO_ITEM_GTN_ATTRS_B
636: where EXTENSION_ID = X_EXTENSION_ID
637: for update of EXTENSION_ID nowait;
638: recinfo c%rowtype;
639:

Line 1023: update EGO_ITEM_GTN_ATTRS_B set

1019: X_LAST_UPDATED_BY in NUMBER,
1020: X_LAST_UPDATE_LOGIN in NUMBER
1021: ) is
1022: begin
1023: update EGO_ITEM_GTN_ATTRS_B set
1024: REQUEST_ID = X_REQUEST_ID,
1025: DELIVERY_TO_MRKT_TEMP_MIN = X_DELIVERY_TO_MRKT_TEMP_MIN,
1026: UOM_DELIVERY_TO_MRKT_TEMP_MIN = X_UOM_DELIVERY_TO_MRKT_TEMP_MI,
1027: SUB_BRAND = X_SUB_BRAND,

Line 1169: delete from EGO_ITEM_GTN_ATTRS_B

1165: if (sql%notfound) then
1166: raise no_data_found;
1167: end if;
1168:
1169: delete from EGO_ITEM_GTN_ATTRS_B
1170: where EXTENSION_ID = X_EXTENSION_ID;
1171:
1172: if (sql%notfound) then
1173: raise no_data_found;

Line 1183: from EGO_ITEM_GTN_ATTRS_B B

1179: begin
1180: delete from EGO_ITEM_GTN_ATTRS_TL T
1181: where not exists
1182: (select NULL
1183: from EGO_ITEM_GTN_ATTRS_B B
1184: where B.EXTENSION_ID = T.EXTENSION_ID
1185: );
1186:
1187: update EGO_ITEM_GTN_ATTRS_TL T set (