7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
12: p_this_level_dtl_tbl IN GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
13: p_lower_level_dtl_Tbl IN GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type,
14: p_user_id IN fnd_user.user_id%TYPE,
15: x_costcmpnt_ids OUT NOCOPY GMF_ItemCost_PUB.costcmpnt_ids_tbl_type
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
12: p_this_level_dtl_tbl IN GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
13: p_lower_level_dtl_Tbl IN GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type,
14: p_user_id IN fnd_user.user_id%TYPE,
15: x_costcmpnt_ids OUT NOCOPY GMF_ItemCost_PUB.costcmpnt_ids_tbl_type
16: );
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
12: p_this_level_dtl_tbl IN GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
13: p_lower_level_dtl_Tbl IN GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type,
14: p_user_id IN fnd_user.user_id%TYPE,
15: x_costcmpnt_ids OUT NOCOPY GMF_ItemCost_PUB.costcmpnt_ids_tbl_type
16: );
17:
11: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
12: p_this_level_dtl_tbl IN GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
13: p_lower_level_dtl_Tbl IN GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type,
14: p_user_id IN fnd_user.user_id%TYPE,
15: x_costcmpnt_ids OUT NOCOPY GMF_ItemCost_PUB.costcmpnt_ids_tbl_type
16: );
17:
18: PROCEDURE Update_Item_Cost
19: (
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
26: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
27: p_this_level_dtl_tbl IN GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
28: p_lower_level_dtl_Tbl IN GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type,
29: p_user_id IN fnd_user.user_id%TYPE
30: );
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
26: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
27: p_this_level_dtl_tbl IN GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
28: p_lower_level_dtl_Tbl IN GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type,
29: p_user_id IN fnd_user.user_id%TYPE
30: );
31:
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
26: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
27: p_this_level_dtl_tbl IN GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
28: p_lower_level_dtl_Tbl IN GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type,
29: p_user_id IN fnd_user.user_id%TYPE
30: );
31:
32: PROCEDURE Get_Item_Cost
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
41: x_this_level_dtl_tbl OUT NOCOPY GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
42: x_lower_level_dtl_Tbl OUT NOCOPY GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type
43: );
44:
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
41: x_this_level_dtl_tbl OUT NOCOPY GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
42: x_lower_level_dtl_Tbl OUT NOCOPY GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type
43: );
44:
45: END GMF_ITEMCOST_PVT;
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: p_header_rec IN GMF_ItemCost_PUB.Header_Rec_Type,
41: x_this_level_dtl_tbl OUT NOCOPY GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type,
42: x_lower_level_dtl_Tbl OUT NOCOPY GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type
43: );
44:
45: END GMF_ITEMCOST_PVT;