APPS.EGO_ITM_GTN_MUL_ATTRS_PKG dependencies on EGO_ITM_GTN_MUL_ATTRS_B

Line 40: cursor C is select ROWID from EGO_ITM_GTN_MUL_ATTRS_B

36: X_LAST_UPDATE_DATE in DATE,
37: X_LAST_UPDATED_BY in NUMBER,
38: X_LAST_UPDATE_LOGIN in NUMBER
39: ) is
40: cursor C is select ROWID from EGO_ITM_GTN_MUL_ATTRS_B
41: where EXTENSION_ID = X_EXTENSION_ID
42: ;
43: begin
44: insert into EGO_ITM_GTN_MUL_ATTRS_B (

Line 44: insert into EGO_ITM_GTN_MUL_ATTRS_B (

40: cursor C is select ROWID from EGO_ITM_GTN_MUL_ATTRS_B
41: where EXTENSION_ID = X_EXTENSION_ID
42: ;
43: begin
44: insert into EGO_ITM_GTN_MUL_ATTRS_B (
45: REQUEST_ID,
46: SIZE_CODE_LIST_AGENCY,
47: SIZE_CODE_VALUE,
48: EXTENSION_ID,

Line 222: from EGO_ITM_GTN_MUL_ATTRS_B

218: MANUFACTURER_ID,
219: PARTY_RECEIVING_PRIVATE_DATA,
220: ITEM_CATALOG_GROUP_ID,
221: REVISION_ID
222: from EGO_ITM_GTN_MUL_ATTRS_B
223: where EXTENSION_ID = X_EXTENSION_ID
224: for update of EXTENSION_ID nowait;
225: recinfo c%rowtype;
226:

Line 353: update EGO_ITM_GTN_MUL_ATTRS_B set

349: X_LAST_UPDATED_BY in NUMBER,
350: X_LAST_UPDATE_LOGIN in NUMBER
351: ) is
352: begin
353: update EGO_ITM_GTN_MUL_ATTRS_B set
354: REQUEST_ID = X_REQUEST_ID,
355: SIZE_CODE_LIST_AGENCY = X_SIZE_CODE_LIST_AGENCY,
356: SIZE_CODE_VALUE = X_SIZE_CODE_VALUE,
357: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,

Line 415: delete from EGO_ITM_GTN_MUL_ATTRS_B

411: if (sql%notfound) then
412: raise no_data_found;
413: end if;
414:
415: delete from EGO_ITM_GTN_MUL_ATTRS_B
416: where EXTENSION_ID = X_EXTENSION_ID;
417:
418: if (sql%notfound) then
419: raise no_data_found;

Line 429: from EGO_ITM_GTN_MUL_ATTRS_B B

425: begin
426: delete from EGO_ITM_GTN_MUL_ATTRS_TL T
427: where not exists
428: (select NULL
429: from EGO_ITM_GTN_MUL_ATTRS_B B
430: where B.EXTENSION_ID = T.EXTENSION_ID
431: );
432:
433: update EGO_ITM_GTN_MUL_ATTRS_TL T set (