APPS.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 42: FROM ASO_QUOTE_HEADERS_ALL

38:
39: IS
40: CURSOR C_Validate_Quote (x_qte_header_id NUMBER) IS
41: SELECT 'X'
42: FROM ASO_QUOTE_HEADERS_ALL
43: WHERE quote_header_id = x_qte_header_id;
44:
45: CURSOR c_line_relation (x_quote_header_id NUMBER) IS
46: SELECT a.LINE_RELATIONSHIP_ID, a.QUOTE_LINE_ID, a.RELATED_QUOTE_LINE_ID,

Line 69: FROM ASO_QUOTE_HEADERS_ALL

65: WHERE quote_header_id = qte_hdr_id ;
66:
67: CURSOR C_payment_amount(qte_hdr_id NUMBER) IS
68: SELECT nvl(total_quote_price ,0)
69: FROM ASO_QUOTE_HEADERS_ALL
70: WHERE quote_header_id = qte_hdr_id ;
71:
72: -- 2469621 vtariker
73: CURSOR C_Get_Config_Flag(qte_line_id NUMBER) IS

Line 81: FROM ASO_QUOTE_HEADERS_ALL

77: -- 2469621 vtariker
78:
79: CURSOR C_Get_Update_Date(qte_hdr_id NUMBER) IS
80: SELECT Last_Update_Date
81: FROM ASO_QUOTE_HEADERS_ALL
82: WHERE Quote_Header_Id = qte_hdr_id;
83:
84: l_last_upd_date DATE;
85: l_complete_config VARCHAR2(1);

Line 188: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B

184: l_status VARCHAR2(1) := 'S';
185:
186: CURSOR C_Check_Qte_Status (l_qte_hdr NUMBER) IS
187: SELECT 'Y'
188: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B
189: WHERE A.Quote_Header_Id = l_qte_hdr
190: AND A.Quote_Status_Id = B.Quote_Status_Id
191: AND B.Status_Code = 'STORE DRAFT';
192:

Line 956: UPDATE ASO_QUOTE_HEADERS_ALL

952: FETCH c_qte_status_id INTO l_qte_status_id;
953: CLOSE c_qte_status_id;
954: -- end of hyang quote_status
955:
956: UPDATE ASO_QUOTE_HEADERS_ALL
957: SET order_Id = x_order_header_rec.order_header_id,
958: quote_status_id = l_qte_status_id,
959: last_update_date = sysdate,
960: last_updated_by = fnd_global.user_id,

Line 1097: UPDATE ASO_QUOTE_HEADERS_ALL

1093: aso_debug_pub.add('Submit_Q: Raise_Quote_Event: X_Current_State: '||X_Current_State, 1, 'N');
1094: END IF;
1095: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1096:
1097: UPDATE ASO_QUOTE_HEADERS_ALL
1098: SET Order_Id = x_order_header_rec.order_header_id,
1099: last_update_date = sysdate,
1100: last_updated_by = fnd_global.user_id,
1101: last_update_login = fnd_global.conc_login_id