APPS.MTL_MATERIAL_STATUSES_PKG dependencies on MTL_MATERIAL_STATUSES_B

Line 47: cursor C is select ROWID from MTL_MATERIAL_STATUSES_B

43: X_reservable_type IN NUMBER,
44: X_availability_type IN NUMBER
45: --END INVCONV KKILLAMS
46: ) is
47: cursor C is select ROWID from MTL_MATERIAL_STATUSES_B
48: where STATUS_ID = X_STATUS_ID
49: ;
50: begin
51: insert into MTL_MATERIAL_STATUSES_B (

Line 51: insert into MTL_MATERIAL_STATUSES_B (

47: cursor C is select ROWID from MTL_MATERIAL_STATUSES_B
48: where STATUS_ID = X_STATUS_ID
49: ;
50: begin
51: insert into MTL_MATERIAL_STATUSES_B (
52: ATTRIBUTE15,
53: ATTRIBUTE2,
54: ATTRIBUTE3,
55: ATTRIBUTE4,

Line 284: from MTL_MATERIAL_STATUSES_B

280: INVENTORY_ATP_CODE,
281: RESERVABLE_TYPE,
282: AVAILABILITY_TYPE
283: --END INVCONV KKILLAMS
284: from MTL_MATERIAL_STATUSES_B
285: where STATUS_ID = X_STATUS_ID
286: for update of STATUS_ID nowait;
287: recinfo c%rowtype;
288:

Line 418: CURSOR cur_status IS SELECT 1 FROM MTL_MATERIAL_STATUSES_B

414: --END INVCONV KKILLAMS
415: ) is
416: --INVCONV KKILLAMS
417: --Cursor is to verify the atp,reservable and available flags are getting modified or not.
418: CURSOR cur_status IS SELECT 1 FROM MTL_MATERIAL_STATUSES_B
419: WHERE STATUS_ID = X_STATUS_ID
420: AND (INVENTORY_ATP_CODE <> X_INVENTORY_ATP_CODE
421: OR RESERVABLE_TYPE <> X_RESERVABLE_TYPE
422: OR AVAILABILITY_TYPE <> X_AVAILABILITY_TYPE );

Line 430: update MTL_MATERIAL_STATUSES_B set

426: --INVCONV KKILLAMS
427: OPEN cur_status;
428: FETCH cur_status INTO l_dummy;
429: --END INVCONV KKILLAMS
430: update MTL_MATERIAL_STATUSES_B set
431: ATTRIBUTE15 = X_ATTRIBUTE15,
432: ATTRIBUTE2 = X_ATTRIBUTE2,
433: ATTRIBUTE3 = X_ATTRIBUTE3,
434: ATTRIBUTE4 = X_ATTRIBUTE4,

Line 516: delete from MTL_MATERIAL_STATUSES_B

512: if (sql%notfound) then
513: raise no_data_found;
514: end if;
515:
516: delete from MTL_MATERIAL_STATUSES_B
517: where STATUS_ID = X_STATUS_ID;
518:
519: if (sql%notfound) then
520: raise no_data_found;

Line 731: from MTL_MATERIAL_STATUSES_B B

727: begin
728: delete from MTL_MATERIAL_STATUSES_TL T
729: where not exists
730: (select NULL
731: from MTL_MATERIAL_STATUSES_B B
732: where B.STATUS_ID = T.STATUS_ID
733: );
734:
735: update MTL_MATERIAL_STATUSES_TL T set (