APPS.IC_ITEM_MST_PKG dependencies on IC_ITEM_MST_B

Line 122: cursor C is select ROWID from IC_ITEM_MST_B

118: X_LAST_UPDATE_DATE in DATE,
119: X_LAST_UPDATED_BY in NUMBER,
120: X_LAST_UPDATE_LOGIN in NUMBER
121: ) is
122: cursor C is select ROWID from IC_ITEM_MST_B
123: where ITEM_ID = X_ITEM_ID
124: ;
125: begin
126: insert into IC_ITEM_MST_B (

Line 126: insert into IC_ITEM_MST_B (

122: cursor C is select ROWID from IC_ITEM_MST_B
123: where ITEM_ID = X_ITEM_ID
124: ;
125: begin
126: insert into IC_ITEM_MST_B (
127: ITEM_ID,
128: ITEM_NO,
129: ITEM_DESC1,
130: ITEM_DESC2,

Line 624: from IC_ITEM_MST_B

620: LOT_PREFIX,
621: LOT_SUFFIX,
622: SUBLOT_PREFIX,
623: SUBLOT_SUFFIX
624: from IC_ITEM_MST_B
625: where ITEM_ID = X_ITEM_ID
626: for update of ITEM_ID nowait;
627: recinfo c%rowtype;
628:

Line 979: update IC_ITEM_MST_B set

975: X_LAST_UPDATED_BY in NUMBER,
976: X_LAST_UPDATE_LOGIN in NUMBER
977: ) is
978: begin
979: update IC_ITEM_MST_B set
980: ITEM_NO = X_ITEM_NO,
981: ITEM_DESC1 = X_ITEM_DESC1,
982: ITEM_DESC2 = X_ITEM_DESC2,
983: ALT_ITEMA = X_ALT_ITEMA,

Line 1127: update IC_ITEM_MST_B set delete_mark = 1

1123: raise no_data_found;
1124: end if;
1125: **************** */
1126:
1127: update IC_ITEM_MST_B set delete_mark = 1
1128: where ITEM_ID = X_ITEM_ID;
1129:
1130: if (sql%notfound) then
1131: raise no_data_found;

Line 1141: from IC_ITEM_MST_B B

1137: begin
1138: delete from IC_ITEM_MST_TL T
1139: where not exists
1140: (select NULL
1141: from IC_ITEM_MST_B B
1142: where B.ITEM_ID = T.ITEM_ID
1143: );
1144:
1145: update IC_ITEM_MST_TL T set (