APPS.GMD_ITEM_SUBSTITUTION_DTL_PKG dependencies on GMD_ITEM_SUBSTITUTION_DTL

Line 1: package body GMD_ITEM_SUBSTITUTION_DTL_PKG as

1: package body GMD_ITEM_SUBSTITUTION_DTL_PKG as
2: /* $Header: GMDITSDB.pls 120.1 2005/07/13 02:57:13 kkillams noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_SUBSTITUTION_LINE_ID in NUMBER,

Line 16: cursor C is select ROWID from GMD_ITEM_SUBSTITUTION_DTL

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from GMD_ITEM_SUBSTITUTION_DTL
17: where SUBSTITUTION_LINE_ID = X_SUBSTITUTION_LINE_ID
18: ;
19: begin
20: insert into GMD_ITEM_SUBSTITUTION_DTL (

Line 20: insert into GMD_ITEM_SUBSTITUTION_DTL (

16: cursor C is select ROWID from GMD_ITEM_SUBSTITUTION_DTL
17: where SUBSTITUTION_LINE_ID = X_SUBSTITUTION_LINE_ID
18: ;
19: begin
20: insert into GMD_ITEM_SUBSTITUTION_DTL (
21: SUBSTITUTION_LINE_ID,
22: SUBSTITUTION_ID,
23: INVENTORY_ITEM_ID,
24: UNIT_QTY,

Line 66: from GMD_ITEM_SUBSTITUTION_DTL

62: SUBSTITUTION_ID,
63: INVENTORY_ITEM_ID,
64: UNIT_QTY,
65: DETAIL_UOM
66: from GMD_ITEM_SUBSTITUTION_DTL
67: where SUBSTITUTION_LINE_ID = X_SUBSTITUTION_LINE_ID
68: for update of SUBSTITUTION_LINE_ID nowait;
69: recinfo c%rowtype;
70:

Line 104: update GMD_ITEM_SUBSTITUTION_DTL set

100: X_LAST_UPDATED_BY in NUMBER,
101: X_LAST_UPDATE_LOGIN in NUMBER
102: ) is
103: begin
104: update GMD_ITEM_SUBSTITUTION_DTL set
105: SUBSTITUTION_ID = X_SUBSTITUTION_ID,
106: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
107: UNIT_QTY = X_UNIT_QTY,
108: DETAIL_UOM = X_DETAIL_UOM,

Line 125: delete from GMD_ITEM_SUBSTITUTION_DTL

121: X_SUBSTITUTION_LINE_ID in NUMBER
122: ) is
123: begin
124:
125: delete from GMD_ITEM_SUBSTITUTION_DTL
126: where SUBSTITUTION_LINE_ID = X_SUBSTITUTION_LINE_ID;
127:
128: if (sql%notfound) then
129: raise no_data_found;

Line 132: end GMD_ITEM_SUBSTITUTION_DTL_PKG;

128: if (sql%notfound) then
129: raise no_data_found;
130: end if;
131: end DELETE_ROW;
132: end GMD_ITEM_SUBSTITUTION_DTL_PKG;