APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 41: FROM ASO_QUOTE_HEADERS_ALL

37: CURSOR C_Validate_Quote (
38: x_qte_header_id NUMBER
39: ) IS
40: SELECT 'X'
41: FROM ASO_QUOTE_HEADERS_ALL
42: WHERE quote_header_id = x_qte_header_id;
43:
44: CURSOR C_Qte_Number IS
45: SELECT ASO_QUOTE_NUMBER_S.NEXTVAL

Line 59: FROM ASO_QUOTE_HEADERS_ALL

55: CURSOR C_Qte_Number_exists (
56: X_qte_number NUMBER
57: ) IS
58: SELECT quote_number
59: FROM ASO_QUOTE_HEADERS_ALL
60: WHERE quote_number = X_qte_number;
61:
62: CURSOR C_Curr_Qte_Info (
63: qte_numb NUMBER

Line 66: FROM ASO_QUOTE_HEADERS_ALL

62: CURSOR C_Curr_Qte_Info (
63: qte_numb NUMBER
64: ) IS
65: SELECT quote_status_id, quote_header_id, quote_version
66: FROM ASO_QUOTE_HEADERS_ALL
67: WHERE quote_number = qte_numb
68: AND max_version_flag = 'Y';
69:
70: CURSOR C_Check_Qte_Status (

Line 85: FROM ASO_QUOTE_HEADERS_ALL

81: CURSOR C_Get_Qte_Num (
82: qte_hdr_id NUMBER
83: ) IS
84: SELECT Quote_Number
85: FROM ASO_QUOTE_HEADERS_ALL
86: WHERE Quote_Header_Id = qte_hdr_id;
87:
88: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_quote';
89: l_api_version_number CONSTANT NUMBER := 1.0;

Line 112: FROM aso_quote_headers_all

108: CURSOR C_Get_Last_Upd_Date (
109: qte_hdr_id NUMBER
110: ) IS
111: SELECT last_update_date
112: FROM aso_quote_headers_all
113: WHERE quote_header_id = qte_hdr_id;
114:
115: CURSOR C_Get_RSA ( l_qte_hdr_id NUMBER) IS
116: Select assistance_requested

Line 117: FROM aso_quote_headers_all

113: WHERE quote_header_id = qte_hdr_id;
114:
115: CURSOR C_Get_RSA ( l_qte_hdr_id NUMBER) IS
116: Select assistance_requested
117: FROM aso_quote_headers_all
118: WHERE quote_header_id = l_qte_hdr_id;
119:
120:
121: CURSOR get_note_id ( l_qte_hdr_id NUMBER) IS

Line 368: UPDATE ASO_QUOTE_HEADERS_ALL

364:
365: l_qte_header_rec.quote_version := NVL ( l_qte_header_rec.quote_version, 0 ) + 1;
366: l_qte_header_rec.max_version_flag := 'Y';
367:
368: UPDATE ASO_QUOTE_HEADERS_ALL
369: SET Max_Version_Flag = 'N'
370: ,last_update_date =sysdate
371: ,last_updated_by = G_USER_ID
372: ,last_update_login = G_LOGIN_ID

Line 968: FROM ASO_QUOTE_HEADERS_ALL

964: WHERE QUOTE_NUMBER = l_qte_num;
965:
966: CURSOR C_Get_Old_Qte (l_hdr_id NUMBER) IS
967: SELECT Quote_Number
968: FROM ASO_QUOTE_HEADERS_ALL
969: WHERE QUote_Header_Id = l_hdr_id;
970:
971: l_qte_access_tbl aso_quote_pub.qte_access_tbl_type := aso_quote_pub.g_miss_qte_access_tbl;
972: x_qte_access_tbl aso_quote_pub.qte_access_tbl_type;

Line 1401: p_old_object_code => 'ASO_QUOTE_HEADERS_ALL',

1397: END IF;
1398:
1399: ASO_ATTACHMENT_INT.COPY_ATTACHMENTS(
1400: p_api_version => l_api_version,
1401: p_old_object_code => 'ASO_QUOTE_HEADERS_ALL',
1402: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',
1403: p_old_object_id => l_old_qte_header_id,
1404: p_new_object_id => x_qte_header_id,
1405: x_return_status => l_return_status,

Line 1402: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',

1398:
1399: ASO_ATTACHMENT_INT.COPY_ATTACHMENTS(
1400: p_api_version => l_api_version,
1401: p_old_object_code => 'ASO_QUOTE_HEADERS_ALL',
1402: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',
1403: p_old_object_id => l_old_qte_header_id,
1404: p_new_object_id => x_qte_header_id,
1405: x_return_status => l_return_status,
1406: x_msg_count => x_msg_count,

Line 1760: From ASO_QUOTE_HEADERS_ALL

1756:
1757: Cursor C_Get_quote(c_QUOTE_HEADER_ID Number) IS
1758: Select
1759: LAST_UPDATE_DATE
1760: From ASO_QUOTE_HEADERS_ALL
1761: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
1762:
1763: Cursor Get_Max_Line_Number ( c_QUOTE_HEADER_ID Number) IS
1764: Select Max(Line_number)

Line 4201: FROM ASO_QUOTE_HEADERS_ALL

4197: CURSOR C_Validate_Quote (
4198: x_qte_header_id NUMBER
4199: ) IS
4200: SELECT 'X'
4201: FROM ASO_QUOTE_HEADERS_ALL
4202: WHERE quote_header_id = x_qte_header_id;
4203:
4204: CURSOR C_Validate_Quote_Line (
4205: x_qte_header_id NUMBER,

Line 4267: FROM aso_quote_headers_all

4263: CURSOR get_latest_date (
4264: c_quote_header_id NUMBER
4265: ) IS
4266: SELECT last_update_date
4267: FROM aso_quote_headers_all
4268: WHERE quote_header_id = c_quote_header_id;
4269:
4270:
4271: Cursor Get_Max_Line_Number ( c_QUOTE_HEADER_ID Number) IS