eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_SYSTEM_ITEMS_T3_BOM dependencies on BOM_PFI_PVT

Line 16: l_Org_Is_Master := BOM_PFI_PVT.Org_Is_Master( p_org_id => :new.ORGANIZATION_ID );

12: l_Org_Is_Master BOOLEAN ;
13: BEGIN
14: FND_MESSAGE.CLEAR;
15:
16: l_Org_Is_Master := BOM_PFI_PVT.Org_Is_Master( p_org_id => :new.ORGANIZATION_ID );
17:
18: -----------------------------------------------------------------------
19: -- Product family category creation and deletion based on BOM Item Type
20: -- attribute change.

Line 30: BOM_PFI_PVT.Check_PF_Segs;

26: IF (:new.BOM_ITEM_TYPE = 5) and
27: ( (:old.BOM_ITEM_TYPE <> 5) or (:old.BOM_ITEM_TYPE is NULL) )
28: THEN
29:
30: BOM_PFI_PVT.Check_PF_Segs;
31:
32: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )
33: THEN
34:

Line 32: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )

28: THEN
29:
30: BOM_PFI_PVT.Check_PF_Segs;
31:
32: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )
33: THEN
34:
35: IF l_Org_Is_Master THEN
36:

Line 42: BOM_PFI_PVT.Store_Cat_Create

38: -- Record each product family item for creation of a corresponding
39: -- category. Actual creation takes place in the statement-level trigger.
40: -------------------------------------------------------------------------
41:
42: BOM_PFI_PVT.Store_Cat_Create
43: ( p_return_sts => l_return_sts ,
44: p_return_err => l_return_err ,
45: p_item_id => :new.INVENTORY_ITEM_ID ,
46: p_org_id => :new.ORGANIZATION_ID ,

Line 47: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,

43: ( p_return_sts => l_return_sts ,
44: p_return_err => l_return_err ,
45: p_item_id => :new.INVENTORY_ITEM_ID ,
46: p_org_id => :new.ORGANIZATION_ID ,
47: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,
48: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl
49: );
50:
51: END IF; -- Org_Is_Master

Line 48: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl

44: p_return_err => l_return_err ,
45: p_item_id => :new.INVENTORY_ITEM_ID ,
46: p_org_id => :new.ORGANIZATION_ID ,
47: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,
48: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl
49: );
50:
51: END IF; -- Org_Is_Master
52:

Line 57: BOM_PFI_PVT.Store_Cat_Assign

53: ----------------------------------------------------------------------
54: -- Assign each product family item to its own category in a given org.
55: ----------------------------------------------------------------------
56:
57: BOM_PFI_PVT.Store_Cat_Assign
58: ( p_return_sts => l_return_sts ,
59: p_return_err => l_return_err ,
60: p_item_id => :new.INVENTORY_ITEM_ID ,
61: p_org_id => :new.ORGANIZATION_ID ,

Line 63: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,

59: p_return_err => l_return_err ,
60: p_item_id => :new.INVENTORY_ITEM_ID ,
61: p_org_id => :new.ORGANIZATION_ID ,
62: p_pf_item_id => :new.INVENTORY_ITEM_ID ,
63: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
64: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl
65: );
66:
67: END IF; -- PF_Segs_Status

Line 64: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl

60: p_item_id => :new.INVENTORY_ITEM_ID ,
61: p_org_id => :new.ORGANIZATION_ID ,
62: p_pf_item_id => :new.INVENTORY_ITEM_ID ,
63: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
64: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl
65: );
66:
67: END IF; -- PF_Segs_Status
68:

Line 73: BOM_PFI_PVT.Check_PF_Segs;

69: ELSIF (:old.BOM_ITEM_TYPE = 5) and
70: ( (:new.BOM_ITEM_TYPE <> 5) or (:new.BOM_ITEM_TYPE is NULL) )
71: THEN
72:
73: BOM_PFI_PVT.Check_PF_Segs;
74:
75: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )
76: THEN
77:

Line 75: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )

71: THEN
72:
73: BOM_PFI_PVT.Check_PF_Segs;
74:
75: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )
76: THEN
77:
78: -------------------------------------------------------------------
79: -- Remove product family item from its own category in a given org.

Line 82: BOM_PFI_PVT.Remove_From_Category

78: -------------------------------------------------------------------
79: -- Remove product family item from its own category in a given org.
80: -------------------------------------------------------------------
81:
82: BOM_PFI_PVT.Remove_From_Category
83: ( p_return_sts => l_return_sts ,
84: p_return_err => l_return_err ,
85: p_item_id => :old.INVENTORY_ITEM_ID ,
86: p_org_id => :old.ORGANIZATION_ID

Line 96: BOM_PFI_PVT.Store_Category

92: -- Record each product family item corresponding to a category to be
93: -- deleted. Actual deletion takes place in the statement-level trigger.
94: ------------------------------------------------------------------------
95:
96: BOM_PFI_PVT.Store_Category
97: ( p_return_sts => l_return_sts ,
98: p_return_err => l_return_err ,
99: p_item_id => :old.INVENTORY_ITEM_ID ,
100: p_org_id => :old.ORGANIZATION_ID ,

Line 101: p_Cat_Num => BOM_PFI_PVT.G_Cat_Num ,

97: ( p_return_sts => l_return_sts ,
98: p_return_err => l_return_err ,
99: p_item_id => :old.INVENTORY_ITEM_ID ,
100: p_org_id => :old.ORGANIZATION_ID ,
101: p_Cat_Num => BOM_PFI_PVT.G_Cat_Num ,
102: p_Delete_Cat_Tbl => BOM_PFI_PVT.G_Delete_Cat_Tbl
103: );
104:
105: END IF; -- Org_Is_Master

Line 102: p_Delete_Cat_Tbl => BOM_PFI_PVT.G_Delete_Cat_Tbl

98: p_return_err => l_return_err ,
99: p_item_id => :old.INVENTORY_ITEM_ID ,
100: p_org_id => :old.ORGANIZATION_ID ,
101: p_Cat_Num => BOM_PFI_PVT.G_Cat_Num ,
102: p_Delete_Cat_Tbl => BOM_PFI_PVT.G_Delete_Cat_Tbl
103: );
104:
105: END IF; -- Org_Is_Master
106:

Line 124: BOM_PFI_PVT.Check_PF_Segs;

120: (:new.PRODUCT_FAMILY_ITEM_ID is NULL) )
121: and (:old.BASE_ITEM_ID is NULL)
122: THEN
123:
124: BOM_PFI_PVT.Check_PF_Segs;
125:
126: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )
127: THEN
128:

Line 126: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )

122: THEN
123:
124: BOM_PFI_PVT.Check_PF_Segs;
125:
126: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )
127: THEN
128:
129: BOM_PFI_PVT.Remove_From_Category
130: ( p_return_sts => l_return_sts ,

Line 129: BOM_PFI_PVT.Remove_From_Category

125:
126: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )
127: THEN
128:
129: BOM_PFI_PVT.Remove_From_Category
130: ( p_return_sts => l_return_sts ,
131: p_return_err => l_return_err ,
132: p_item_id => :old.INVENTORY_ITEM_ID ,
133: p_org_id => :old.ORGANIZATION_ID

Line 146: BOM_PFI_PVT.Check_PF_Segs;

142: (:old.PRODUCT_FAMILY_ITEM_ID is NULL) )
143: and (:new.BASE_ITEM_ID is NULL)
144: THEN
145:
146: BOM_PFI_PVT.Check_PF_Segs;
147:
148: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )
149: THEN
150:

Line 148: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )

144: THEN
145:
146: BOM_PFI_PVT.Check_PF_Segs;
147:
148: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_OK )
149: THEN
150:
151: ---------------------------------------------------------------------
152: -- Record each item assignment to category/category set in the

Line 153: -- G_Cat_Assign_Tbl PL/SQL table inside BOM_PFI_PVT package.

149: THEN
150:
151: ---------------------------------------------------------------------
152: -- Record each item assignment to category/category set in the
153: -- G_Cat_Assign_Tbl PL/SQL table inside BOM_PFI_PVT package.
154: -- Do not read item's corresponding product family item key flexfield
155: -- segments from MTL_SYSTEM_ITEMS_B now to avoid mutating table error.
156: -- Actual assignment takes place in the statement-level trigger.
157: ---------------------------------------------------------------------

Line 159: BOM_PFI_PVT.Store_Cat_Assign

155: -- segments from MTL_SYSTEM_ITEMS_B now to avoid mutating table error.
156: -- Actual assignment takes place in the statement-level trigger.
157: ---------------------------------------------------------------------
158:
159: BOM_PFI_PVT.Store_Cat_Assign
160: ( p_return_sts => l_return_sts ,
161: p_return_err => l_return_err ,
162: p_item_id => :new.INVENTORY_ITEM_ID ,
163: p_org_id => :new.ORGANIZATION_ID ,

Line 165: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,

161: p_return_err => l_return_err ,
162: p_item_id => :new.INVENTORY_ITEM_ID ,
163: p_org_id => :new.ORGANIZATION_ID ,
164: p_pf_item_id => :new.PRODUCT_FAMILY_ITEM_ID ,
165: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
166: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl
167: );
168:
169: END IF; -- PF_Segs_Status

Line 166: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl

162: p_item_id => :new.INVENTORY_ITEM_ID ,
163: p_org_id => :new.ORGANIZATION_ID ,
164: p_pf_item_id => :new.PRODUCT_FAMILY_ITEM_ID ,
165: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
166: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl
167: );
168:
169: END IF; -- PF_Segs_Status
170: