10: -- Default number of records fetch per call
11:
12:
13: TYPE BOM_REC_TYPE IS RECORD
14: ( Inventory_Item_Id NUMBER := FND_API.G_MISS_NUM
15: , Organization_Id NUMBER := FND_API.G_MISS_NUM
16: , Alternate_Bom_Code VARCHAR2(10) := FND_API.G_MISS_CHAR
17: , Assembly_Type NUMBER := FND_API.G_MISS_NUM
18: , Transaction_Type VARCHAR2(30) := FND_API.G_MISS_CHAR
11:
12:
13: TYPE BOM_REC_TYPE IS RECORD
14: ( Inventory_Item_Id NUMBER := FND_API.G_MISS_NUM
15: , Organization_Id NUMBER := FND_API.G_MISS_NUM
16: , Alternate_Bom_Code VARCHAR2(10) := FND_API.G_MISS_CHAR
17: , Assembly_Type NUMBER := FND_API.G_MISS_NUM
18: , Transaction_Type VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
12:
13: TYPE BOM_REC_TYPE IS RECORD
14: ( Inventory_Item_Id NUMBER := FND_API.G_MISS_NUM
15: , Organization_Id NUMBER := FND_API.G_MISS_NUM
16: , Alternate_Bom_Code VARCHAR2(10) := FND_API.G_MISS_CHAR
17: , Assembly_Type NUMBER := FND_API.G_MISS_NUM
18: , Transaction_Type VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
20: );
13: TYPE BOM_REC_TYPE IS RECORD
14: ( Inventory_Item_Id NUMBER := FND_API.G_MISS_NUM
15: , Organization_Id NUMBER := FND_API.G_MISS_NUM
16: , Alternate_Bom_Code VARCHAR2(10) := FND_API.G_MISS_CHAR
17: , Assembly_Type NUMBER := FND_API.G_MISS_NUM
18: , Transaction_Type VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
20: );
21:
14: ( Inventory_Item_Id NUMBER := FND_API.G_MISS_NUM
15: , Organization_Id NUMBER := FND_API.G_MISS_NUM
16: , Alternate_Bom_Code VARCHAR2(10) := FND_API.G_MISS_CHAR
17: , Assembly_Type NUMBER := FND_API.G_MISS_NUM
18: , Transaction_Type VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
20: );
21:
22: G_MISS_BOM_REC_TYPE BOM_REC_TYPE;
15: , Organization_Id NUMBER := FND_API.G_MISS_NUM
16: , Alternate_Bom_Code VARCHAR2(10) := FND_API.G_MISS_CHAR
17: , Assembly_Type NUMBER := FND_API.G_MISS_NUM
18: , Transaction_Type VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
20: );
21:
22: G_MISS_BOM_REC_TYPE BOM_REC_TYPE;
23:
21:
22: G_MISS_BOM_REC_TYPE BOM_REC_TYPE;
23:
24: TYPE BOM_COMP_REC_TYPE IS RECORD
25: ( Start_Effective_Date DATE := FND_API.G_MISS_DATE
26: , Disable_Date DATE := FND_API.G_MISS_DATE
27: , Operation_Sequence_Number NUMBER := FND_API.G_MISS_NUM
28: , Component_Item_Name VARCHAR2(81) := FND_API.G_MISS_CHAR
29: , Component_Item_Id NUMBER := FND_API.G_MISS_NUM
22: G_MISS_BOM_REC_TYPE BOM_REC_TYPE;
23:
24: TYPE BOM_COMP_REC_TYPE IS RECORD
25: ( Start_Effective_Date DATE := FND_API.G_MISS_DATE
26: , Disable_Date DATE := FND_API.G_MISS_DATE
27: , Operation_Sequence_Number NUMBER := FND_API.G_MISS_NUM
28: , Component_Item_Name VARCHAR2(81) := FND_API.G_MISS_CHAR
29: , Component_Item_Id NUMBER := FND_API.G_MISS_NUM
30: , Item_Sequence_Number NUMBER := FND_API.G_MISS_NUM
23:
24: TYPE BOM_COMP_REC_TYPE IS RECORD
25: ( Start_Effective_Date DATE := FND_API.G_MISS_DATE
26: , Disable_Date DATE := FND_API.G_MISS_DATE
27: , Operation_Sequence_Number NUMBER := FND_API.G_MISS_NUM
28: , Component_Item_Name VARCHAR2(81) := FND_API.G_MISS_CHAR
29: , Component_Item_Id NUMBER := FND_API.G_MISS_NUM
30: , Item_Sequence_Number NUMBER := FND_API.G_MISS_NUM
31: , Quantity_Per_Assembly NUMBER := FND_API.G_MISS_NUM
24: TYPE BOM_COMP_REC_TYPE IS RECORD
25: ( Start_Effective_Date DATE := FND_API.G_MISS_DATE
26: , Disable_Date DATE := FND_API.G_MISS_DATE
27: , Operation_Sequence_Number NUMBER := FND_API.G_MISS_NUM
28: , Component_Item_Name VARCHAR2(81) := FND_API.G_MISS_CHAR
29: , Component_Item_Id NUMBER := FND_API.G_MISS_NUM
30: , Item_Sequence_Number NUMBER := FND_API.G_MISS_NUM
31: , Quantity_Per_Assembly NUMBER := FND_API.G_MISS_NUM
32: , Quantity_Related NUMBER := FND_API.G_MISS_NUM
25: ( Start_Effective_Date DATE := FND_API.G_MISS_DATE
26: , Disable_Date DATE := FND_API.G_MISS_DATE
27: , Operation_Sequence_Number NUMBER := FND_API.G_MISS_NUM
28: , Component_Item_Name VARCHAR2(81) := FND_API.G_MISS_CHAR
29: , Component_Item_Id NUMBER := FND_API.G_MISS_NUM
30: , Item_Sequence_Number NUMBER := FND_API.G_MISS_NUM
31: , Quantity_Per_Assembly NUMBER := FND_API.G_MISS_NUM
32: , Quantity_Related NUMBER := FND_API.G_MISS_NUM
33: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
26: , Disable_Date DATE := FND_API.G_MISS_DATE
27: , Operation_Sequence_Number NUMBER := FND_API.G_MISS_NUM
28: , Component_Item_Name VARCHAR2(81) := FND_API.G_MISS_CHAR
29: , Component_Item_Id NUMBER := FND_API.G_MISS_NUM
30: , Item_Sequence_Number NUMBER := FND_API.G_MISS_NUM
31: , Quantity_Per_Assembly NUMBER := FND_API.G_MISS_NUM
32: , Quantity_Related NUMBER := FND_API.G_MISS_NUM
33: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: );
27: , Operation_Sequence_Number NUMBER := FND_API.G_MISS_NUM
28: , Component_Item_Name VARCHAR2(81) := FND_API.G_MISS_CHAR
29: , Component_Item_Id NUMBER := FND_API.G_MISS_NUM
30: , Item_Sequence_Number NUMBER := FND_API.G_MISS_NUM
31: , Quantity_Per_Assembly NUMBER := FND_API.G_MISS_NUM
32: , Quantity_Related NUMBER := FND_API.G_MISS_NUM
33: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: );
35:
28: , Component_Item_Name VARCHAR2(81) := FND_API.G_MISS_CHAR
29: , Component_Item_Id NUMBER := FND_API.G_MISS_NUM
30: , Item_Sequence_Number NUMBER := FND_API.G_MISS_NUM
31: , Quantity_Per_Assembly NUMBER := FND_API.G_MISS_NUM
32: , Quantity_Related NUMBER := FND_API.G_MISS_NUM
33: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: );
35:
36: G_MISS_BOM_COMP_REC_TYPE BOM_COMP_REC_TYPE;
29: , Component_Item_Id NUMBER := FND_API.G_MISS_NUM
30: , Item_Sequence_Number NUMBER := FND_API.G_MISS_NUM
31: , Quantity_Per_Assembly NUMBER := FND_API.G_MISS_NUM
32: , Quantity_Related NUMBER := FND_API.G_MISS_NUM
33: , Return_Status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: );
35:
36: G_MISS_BOM_COMP_REC_TYPE BOM_COMP_REC_TYPE;
37:
41: -- G_MISS_BOM_COMP_Tbl_Type BOM_COMP_Tbl_Type;
42:
43: PROCEDURE Ams_Process_BOM(
44: P_Api_Version_Number IN NUMBER,
45: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
46: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48:
49: X_Return_Status OUT NOCOPY VARCHAR2,
42:
43: PROCEDURE Ams_Process_BOM(
44: P_Api_Version_Number IN NUMBER,
45: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
46: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48:
49: X_Return_Status OUT NOCOPY VARCHAR2,
50: X_Msg_Count OUT NOCOPY NUMBER,
43: PROCEDURE Ams_Process_BOM(
44: P_Api_Version_Number IN NUMBER,
45: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
46: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48:
49: X_Return_Status OUT NOCOPY VARCHAR2,
50: X_Msg_Count OUT NOCOPY NUMBER,
51: X_Msg_Data OUT NOCOPY VARCHAR2,
53: P_bom_rec_type IN BOM_REC_TYPE := G_MISS_BOM_REC_TYPE,
54:
55: P_bom_comp_rec_type IN BOM_COMP_REC_TYPE := G_MISS_BOM_COMP_REC_TYPE,
56:
57: P_Last_Update_Date IN DATE := FND_API.G_MISS_DATE,
58: P_Last_Update_By IN NUMBER := FND_API.G_MISS_NUM
59: );
60:
61: End AMS_BOM_PVT;
54:
55: P_bom_comp_rec_type IN BOM_COMP_REC_TYPE := G_MISS_BOM_COMP_REC_TYPE,
56:
57: P_Last_Update_Date IN DATE := FND_API.G_MISS_DATE,
58: P_Last_Update_By IN NUMBER := FND_API.G_MISS_NUM
59: );
60:
61: End AMS_BOM_PVT;