9: -- End of Comments
10:
11: PROCEDURE Check_Pricing_Attributes (
12: P_Api_Version_Number IN NUMBER := 1,
13: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
14: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
15: P_Inventory_Id IN NUMBER := FND_API.G_MISS_NUM,
16: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
17: P_Price_List_Id IN NUMBER := FND_API.G_MISS_NUM,
10:
11: PROCEDURE Check_Pricing_Attributes (
12: P_Api_Version_Number IN NUMBER := 1,
13: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
14: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
15: P_Inventory_Id IN NUMBER := FND_API.G_MISS_NUM,
16: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
17: P_Price_List_Id IN NUMBER := FND_API.G_MISS_NUM,
18: X_Check_Return_Status_qp OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
11: PROCEDURE Check_Pricing_Attributes (
12: P_Api_Version_Number IN NUMBER := 1,
13: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
14: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
15: P_Inventory_Id IN NUMBER := FND_API.G_MISS_NUM,
16: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
17: P_Price_List_Id IN NUMBER := FND_API.G_MISS_NUM,
18: X_Check_Return_Status_qp OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
19: X_Check_Return_Status_aso OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
12: P_Api_Version_Number IN NUMBER := 1,
13: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
14: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
15: P_Inventory_Id IN NUMBER := FND_API.G_MISS_NUM,
16: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
17: P_Price_List_Id IN NUMBER := FND_API.G_MISS_NUM,
18: X_Check_Return_Status_qp OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
19: X_Check_Return_Status_aso OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
13: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
14: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
15: P_Inventory_Id IN NUMBER := FND_API.G_MISS_NUM,
16: P_Quote_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
17: P_Price_List_Id IN NUMBER := FND_API.G_MISS_NUM,
18: X_Check_Return_Status_qp OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
19: X_Check_Return_Status_aso OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
21: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
50: l_list_line_id NUMBER;
51:
52: BEGIN
53: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
54: X_Check_Return_Status_qp := FND_API.G_FALSE;
55: X_Check_Return_Status_aso := FND_API.G_FALSE;
56:
57: OPEN c_check_qpprc_atr;
58: FETCH c_check_qpprc_atr INTO l_list_line_id;
51:
52: BEGIN
53: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
54: X_Check_Return_Status_qp := FND_API.G_FALSE;
55: X_Check_Return_Status_aso := FND_API.G_FALSE;
56:
57: OPEN c_check_qpprc_atr;
58: FETCH c_check_qpprc_atr INTO l_list_line_id;
59: If c_check_qpprc_atr%found THEN
56:
57: OPEN c_check_qpprc_atr;
58: FETCH c_check_qpprc_atr INTO l_list_line_id;
59: If c_check_qpprc_atr%found THEN
60: X_Check_Return_Status_qp := FND_API.G_TRUE;
61: OPEN c_check_asorec;
62: FETCH c_check_asorec INTO l_count;
63: CLOSE c_check_asorec;
64: IF l_count>0 THEN
61: OPEN c_check_asorec;
62: FETCH c_check_asorec INTO l_count;
63: CLOSE c_check_asorec;
64: IF l_count>0 THEN
65: X_Check_Return_Status_aso := FND_API.G_TRUE;
66: END IF;
67: END If;
68: CLOSE c_check_qpprc_atr;
69: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN