DBA Data[Home] [Help]

APPS.MTL_MATERIAL_STATUSES_PKG dependencies on MTL_MATERIAL_STATUSES_PKG

Line 1: package body MTL_MATERIAL_STATUSES_PKG as

1: package body MTL_MATERIAL_STATUSES_PKG as
2: /* $Header: INVMSMLB.pls 120.3 2008/02/15 10:22:17 aambulka ship $ */
3:
4: --Bugfix 2396883. This flag will determine where the update failed.
5: X_UPDATE_FLAG VARCHAR2(1) := 'N';

Line 617: MTL_MATERIAL_STATUSES_PKG.update_row

613:
614: l_onhand_control := fnd_number.canonical_to_number(x_onhand_control); --Onhand Material Status Control Bug #6633612
615: --END INVCONV kkillams
616:
617: MTL_MATERIAL_STATUSES_PKG.update_row
618: (
619: X_STATUS_ID => l_status_id,
620: X_ATTRIBUTE15 => X_ATTRIBUTE15,
621: X_ATTRIBUTE2 => X_ATTRIBUTE2,

Line 662: MTL_MATERIAL_STATUSES_PKG.insert_tl_row

658: -- If the update failed for MTL_MATERIAL_STATUSES_TL Table then insert recoreds into that table alone
659: -- else insert records into both the tables.
660: IF X_UPDATE_FLAG = 'T' THEN
661:
662: MTL_MATERIAL_STATUSES_PKG.insert_tl_row
663: (
664: X_ROWID => l_row_id,
665: X_STATUS_ID => l_status_id,
666: X_STATUS_CODE => x_status_code,

Line 677: MTL_MATERIAL_STATUSES_PKG.insert_row

673: );
674:
675: ELSE
676:
677: MTL_MATERIAL_STATUSES_PKG.insert_row
678: (
679: X_ROWID => l_row_id,
680: X_STATUS_ID => l_status_id,
681: X_ATTRIBUTE15 => X_ATTRIBUTE15,

Line 791: end MTL_MATERIAL_STATUSES_PKG;

787: where T.STATUS_ID = B.STATUS_ID
788: and T.LANGUAGE = L.LANGUAGE_CODE);
789: end ADD_LANGUAGE;
790:
791: end MTL_MATERIAL_STATUSES_PKG;