3:
4: -- Gets the item cost for a specific item.
5: PROCEDURE get_item_cost
6: ( p_api_version IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 DEFAULT 'FND_API.G_FALSE' ,
8: p_commit IN VARCHAR2 DEFAULT 'FND_API.G_FALSE' ,
9: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full ,
10: x_return_status OUT NOCOPY VARCHAR2 ,
11: x_msg_count OUT NOCOPY NUMBER ,
4: -- Gets the item cost for a specific item.
5: PROCEDURE get_item_cost
6: ( p_api_version IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 DEFAULT 'FND_API.G_FALSE' ,
8: p_commit IN VARCHAR2 DEFAULT 'FND_API.G_FALSE' ,
9: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full ,
10: x_return_status OUT NOCOPY VARCHAR2 ,
11: x_msg_count OUT NOCOPY NUMBER ,
12: x_msg_data OUT NOCOPY VARCHAR2 ,
5: PROCEDURE get_item_cost
6: ( p_api_version IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 DEFAULT 'FND_API.G_FALSE' ,
8: p_commit IN VARCHAR2 DEFAULT 'FND_API.G_FALSE' ,
9: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full ,
10: x_return_status OUT NOCOPY VARCHAR2 ,
11: x_msg_count OUT NOCOPY NUMBER ,
12: x_msg_data OUT NOCOPY VARCHAR2 ,
13: p_organization_id IN NUMBER ,
17:
18: -- calculate the system quantity of an given item
19: PROCEDURE calculate_systemquantity
20: ( p_api_version IN NUMBER ,
21: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false ,
22: p_commit IN VARCHAR2 DEFAULT FND_API.g_false ,
23: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
24: x_return_status OUT NOCOPY VARCHAR2 ,
25: x_msg_count OUT NOCOPY NUMBER ,
18: -- calculate the system quantity of an given item
19: PROCEDURE calculate_systemquantity
20: ( p_api_version IN NUMBER ,
21: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false ,
22: p_commit IN VARCHAR2 DEFAULT FND_API.g_false ,
23: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
24: x_return_status OUT NOCOPY VARCHAR2 ,
25: x_msg_count OUT NOCOPY NUMBER ,
26: x_msg_data OUT NOCOPY VARCHAR2 ,
19: PROCEDURE calculate_systemquantity
20: ( p_api_version IN NUMBER ,
21: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false ,
22: p_commit IN VARCHAR2 DEFAULT FND_API.g_false ,
23: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
24: x_return_status OUT NOCOPY VARCHAR2 ,
25: x_msg_count OUT NOCOPY NUMBER ,
26: x_msg_data OUT NOCOPY VARCHAR2 ,
27: p_organization_id IN NUMBER ,
39: -- BEGIN INVCONV
40: -- Overloaded procedure to return secondary quantity
41: PROCEDURE calculate_systemquantity
42: ( p_api_version IN NUMBER ,
43: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false ,
44: p_commit IN VARCHAR2 DEFAULT FND_API.g_false ,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2 ,
47: x_msg_count OUT NOCOPY NUMBER ,
40: -- Overloaded procedure to return secondary quantity
41: PROCEDURE calculate_systemquantity
42: ( p_api_version IN NUMBER ,
43: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false ,
44: p_commit IN VARCHAR2 DEFAULT FND_API.g_false ,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2 ,
47: x_msg_count OUT NOCOPY NUMBER ,
48: x_msg_data OUT NOCOPY VARCHAR2 ,
41: PROCEDURE calculate_systemquantity
42: ( p_api_version IN NUMBER ,
43: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false ,
44: p_commit IN VARCHAR2 DEFAULT FND_API.g_false ,
45: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46: x_return_status OUT NOCOPY VARCHAR2 ,
47: x_msg_count OUT NOCOPY NUMBER ,
48: x_msg_data OUT NOCOPY VARCHAR2 ,
49: p_organization_id IN NUMBER ,
75:
76: -- Calculate system quantity from a LPN
77: PROCEDURE Get_LPN_Item_SysQty
78: ( p_api_version IN NUMBER ,
79: p_init_msg_lst IN VARCHAR2 := fnd_api.g_false ,
80: p_commit IN VARCHAR2 := fnd_api.g_false ,
81: x_return_status OUT NOCOPY VARCHAR2 ,
82: x_msg_count OUT NOCOPY NUMBER ,
83: x_msg_data OUT NOCOPY VARCHAR2 ,
76: -- Calculate system quantity from a LPN
77: PROCEDURE Get_LPN_Item_SysQty
78: ( p_api_version IN NUMBER ,
79: p_init_msg_lst IN VARCHAR2 := fnd_api.g_false ,
80: p_commit IN VARCHAR2 := fnd_api.g_false ,
81: x_return_status OUT NOCOPY VARCHAR2 ,
82: x_msg_count OUT NOCOPY NUMBER ,
83: x_msg_data OUT NOCOPY VARCHAR2 ,
84: p_organization_id IN NUMBER ,
93: -- BEGIN INVCONV
94: -- Overloaded procedure to return secondary quantity
95: PROCEDURE Get_LPN_Item_SysQty
96: ( p_api_version IN NUMBER ,
97: p_init_msg_lst IN VARCHAR2 := fnd_api.g_false ,
98: p_commit IN VARCHAR2 := fnd_api.g_false ,
99: x_return_status OUT NOCOPY VARCHAR2 ,
100: x_msg_count OUT NOCOPY NUMBER ,
101: x_msg_data OUT NOCOPY VARCHAR2 ,
94: -- Overloaded procedure to return secondary quantity
95: PROCEDURE Get_LPN_Item_SysQty
96: ( p_api_version IN NUMBER ,
97: p_init_msg_lst IN VARCHAR2 := fnd_api.g_false ,
98: p_commit IN VARCHAR2 := fnd_api.g_false ,
99: x_return_status OUT NOCOPY VARCHAR2 ,
100: x_msg_count OUT NOCOPY NUMBER ,
101: x_msg_data OUT NOCOPY VARCHAR2 ,
102: p_organization_id IN NUMBER ,