APPS.MTL_DEMAND_T dependencies on INV_RSV_TRIGGER_GLOBAL

Line 17: if ((INSERTING) and (inv_rsv_trigger_global.g_from_trigger = FALSE)) then

13:
14: BEGIN
15: l_sql_stmt_num := 1;
16:
17: if ((INSERTING) and (inv_rsv_trigger_global.g_from_trigger = FALSE)) then
18: l_sql_stmt_num := 2;
19:
20: /*
21: ** Get sequence value

Line 56: inv_rsv_trigger_global.g_from_trigger := TRUE;

52: , null); -- To UOM Name
53:
54: l_sql_stmt_num := 5;
55:
56: inv_rsv_trigger_global.g_from_trigger := TRUE;
57:
58: insert into mtl_reservations(
59: RESERVATION_ID
60: ,REQUIREMENT_DATE

Line 187: inv_rsv_trigger_global.g_from_trigger := FALSE;

183: ,:new.demand_id);
184:
185: l_sql_stmt_num := 6;
186:
187: inv_rsv_trigger_global.g_from_trigger := FALSE;
188: end if;
189:
190: if ((UPDATING) and (inv_rsv_trigger_global.g_from_trigger = FALSE)) then
191: l_sql_stmt_num := 7;

Line 190: if ((UPDATING) and (inv_rsv_trigger_global.g_from_trigger = FALSE)) then

186:
187: inv_rsv_trigger_global.g_from_trigger := FALSE;
188: end if;
189:
190: if ((UPDATING) and (inv_rsv_trigger_global.g_from_trigger = FALSE)) then
191: l_sql_stmt_num := 7;
192:
193: /*
194: ** Primary UOM code is not stored in MTL_DEMAND

Line 220: inv_rsv_trigger_global.g_from_trigger := TRUE;

216: , null); -- To UOM Name
217:
218: l_sql_stmt_num := 9;
219:
220: inv_rsv_trigger_global.g_from_trigger := TRUE;
221:
222: update mtl_reservations
223: set
224: REQUIREMENT_DATE = :new.requirement_date

Line 303: inv_rsv_trigger_global.g_from_trigger := FALSE;

299: */
300:
301: l_sql_stmt_num := 10;
302:
303: inv_rsv_trigger_global.g_from_trigger := FALSE;
304: end if;
305:
306: if ((DELETING) and (inv_rsv_trigger_global.g_from_trigger = FALSE)) then
307: l_sql_stmt_num := 11;

Line 306: if ((DELETING) and (inv_rsv_trigger_global.g_from_trigger = FALSE)) then

302:
303: inv_rsv_trigger_global.g_from_trigger := FALSE;
304: end if;
305:
306: if ((DELETING) and (inv_rsv_trigger_global.g_from_trigger = FALSE)) then
307: l_sql_stmt_num := 11;
308:
309: inv_rsv_trigger_global.g_from_trigger := TRUE;
310:

Line 309: inv_rsv_trigger_global.g_from_trigger := TRUE;

305:
306: if ((DELETING) and (inv_rsv_trigger_global.g_from_trigger = FALSE)) then
307: l_sql_stmt_num := 11;
308:
309: inv_rsv_trigger_global.g_from_trigger := TRUE;
310:
311: delete mtl_reservations
312: where n_column1 = :old.demand_id;
313:

Line 314: inv_rsv_trigger_global.g_from_trigger := FALSE;

310:
311: delete mtl_reservations
312: where n_column1 = :old.demand_id;
313:
314: inv_rsv_trigger_global.g_from_trigger := FALSE;
315: end if;
316:
317: EXCEPTION
318: when others then

Line 320: inv_rsv_trigger_global.g_from_trigger := FALSE;

316:
317: EXCEPTION
318: when others then
319:
320: inv_rsv_trigger_global.g_from_trigger := FALSE;
321:
322: l_return_err := 'MTL_DEMAND_T:' || 'S' ||
323: l_sql_stmt_num || ':' ||
324: substrb(sqlerrm,1,55);