DBA Data[Home] [Help]

APPS.MTL_SYSTEM_ITEMS_T4_BOM dependencies on BOM_PFI_PVT

Line 18: IF ( BOM_PFI_PVT.G_Cat_Create_Num > 0 ) THEN

14: ------------------------------------------------------
15: -- Check if any category creations have been recorded.
16: ------------------------------------------------------
17:
18: IF ( BOM_PFI_PVT.G_Cat_Create_Num > 0 ) THEN
19:
20: BOM_PFI_PVT.Create_PF_Category
21: ( p_return_sts => l_return_sts ,
22: p_return_err => l_return_err ,

Line 20: BOM_PFI_PVT.Create_PF_Category

16: ------------------------------------------------------
17:
18: IF ( BOM_PFI_PVT.G_Cat_Create_Num > 0 ) THEN
19:
20: BOM_PFI_PVT.Create_PF_Category
21: ( p_return_sts => l_return_sts ,
22: p_return_err => l_return_err ,
23: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,
24: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl

Line 23: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,

19:
20: BOM_PFI_PVT.Create_PF_Category
21: ( p_return_sts => l_return_sts ,
22: p_return_err => l_return_err ,
23: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,
24: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl
25: );
26: END IF;
27:

Line 24: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl

20: BOM_PFI_PVT.Create_PF_Category
21: ( p_return_sts => l_return_sts ,
22: p_return_err => l_return_err ,
23: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,
24: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl
25: );
26: END IF;
27:
28: --------------------------------------------------------------------------

Line 34: IF ( BOM_PFI_PVT.G_Assign_Num > 0 ) THEN

30: -- removals only from product family which update PRODUCT_FAMILY_ITEM_ID
31: -- column too).
32: --------------------------------------------------------------------------
33:
34: IF ( BOM_PFI_PVT.G_Assign_Num > 0 ) THEN
35:
36: ------------------------------------------------------------------
37: -- Perform each item assignment that has been recorded by the call
38: -- to Store_Cat_Assign in the row-level trigger.

Line 41: BOM_PFI_PVT.Assign_To_Category

37: -- Perform each item assignment that has been recorded by the call
38: -- to Store_Cat_Assign in the row-level trigger.
39: ------------------------------------------------------------------
40:
41: BOM_PFI_PVT.Assign_To_Category
42: ( p_return_sts => l_return_sts ,
43: p_return_err => l_return_err ,
44: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
45: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl

Line 44: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,

40:
41: BOM_PFI_PVT.Assign_To_Category
42: ( p_return_sts => l_return_sts ,
43: p_return_err => l_return_err ,
44: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
45: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl
46: );
47: END IF;
48:

Line 45: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl

41: BOM_PFI_PVT.Assign_To_Category
42: ( p_return_sts => l_return_sts ,
43: p_return_err => l_return_err ,
44: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
45: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl
46: );
47: END IF;
48:
49: ------------------------------------------------------

Line 53: IF ( BOM_PFI_PVT.G_Cat_Num > 0 ) THEN

49: ------------------------------------------------------
50: -- Check if any category deletions have been recorded.
51: ------------------------------------------------------
52:
53: IF ( BOM_PFI_PVT.G_Cat_Num > 0 ) THEN
54:
55: --------------------------------------------------------------------
56: -- Perform each category deletion that has been recorded by the call
57: -- to Store_Category in the row-level trigger.

Line 60: BOM_PFI_PVT.Delete_PF_Category

56: -- Perform each category deletion that has been recorded by the call
57: -- to Store_Category in the row-level trigger.
58: ---------------------------------------------------------------------
59:
60: BOM_PFI_PVT.Delete_PF_Category
61: ( p_return_sts => l_return_sts ,
62: p_return_err => l_return_err ,
63: p_Cat_Num => BOM_PFI_PVT.G_Cat_Num ,
64: p_Delete_Cat_Tbl => BOM_PFI_PVT.G_Delete_Cat_Tbl

Line 63: p_Cat_Num => BOM_PFI_PVT.G_Cat_Num ,

59:
60: BOM_PFI_PVT.Delete_PF_Category
61: ( p_return_sts => l_return_sts ,
62: p_return_err => l_return_err ,
63: p_Cat_Num => BOM_PFI_PVT.G_Cat_Num ,
64: p_Delete_Cat_Tbl => BOM_PFI_PVT.G_Delete_Cat_Tbl
65: );
66: END IF;
67:

Line 64: p_Delete_Cat_Tbl => BOM_PFI_PVT.G_Delete_Cat_Tbl

60: BOM_PFI_PVT.Delete_PF_Category
61: ( p_return_sts => l_return_sts ,
62: p_return_err => l_return_err ,
63: p_Cat_Num => BOM_PFI_PVT.G_Cat_Num ,
64: p_Delete_Cat_Tbl => BOM_PFI_PVT.G_Delete_Cat_Tbl
65: );
66: END IF;
67:
68: