APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 47: FROM ASO_QUOTE_HEADERS_ALL

43: CURSOR C_Validate_Quote (
44: x_qte_header_id NUMBER
45: ) IS
46: SELECT 'X'
47: FROM ASO_QUOTE_HEADERS_ALL
48: WHERE quote_header_id = x_qte_header_id;
49:
50: CURSOR C_Qte_Number IS
51: SELECT ASO_QUOTE_NUMBER_S.NEXTVAL

Line 65: FROM ASO_QUOTE_HEADERS_ALL

61: CURSOR C_Qte_Number_exists (
62: X_qte_number NUMBER
63: ) IS
64: SELECT quote_number
65: FROM ASO_QUOTE_HEADERS_ALL
66: WHERE quote_number = X_qte_number;
67:
68: CURSOR C_Curr_Qte_Info (
69: qte_numb NUMBER

Line 72: FROM ASO_QUOTE_HEADERS_ALL

68: CURSOR C_Curr_Qte_Info (
69: qte_numb NUMBER
70: ) IS
71: SELECT quote_status_id, quote_header_id, quote_version
72: FROM ASO_QUOTE_HEADERS_ALL
73: WHERE quote_number = qte_numb
74: AND max_version_flag = 'Y';
75:
76: CURSOR C_Check_Qte_Status (

Line 91: FROM ASO_QUOTE_HEADERS_ALL

87: CURSOR C_Get_Qte_Num (
88: qte_hdr_id NUMBER
89: ) IS
90: SELECT Quote_Number
91: FROM ASO_QUOTE_HEADERS_ALL
92: WHERE Quote_Header_Id = qte_hdr_id;
93:
94: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_quote';
95: l_api_version_number CONSTANT NUMBER := 1.0;

Line 122: FROM aso_quote_headers_all

118: CURSOR C_Get_Last_Upd_Date (
119: qte_hdr_id NUMBER
120: ) IS
121: SELECT last_update_date
122: FROM aso_quote_headers_all
123: WHERE quote_header_id = qte_hdr_id;
124:
125: CURSOR C_Get_RSA ( l_qte_hdr_id NUMBER) IS
126: Select assistance_requested

Line 127: FROM aso_quote_headers_all

123: WHERE quote_header_id = qte_hdr_id;
124:
125: CURSOR C_Get_RSA ( l_qte_hdr_id NUMBER) IS
126: Select assistance_requested
127: FROM aso_quote_headers_all
128: WHERE quote_header_id = l_qte_hdr_id;
129:
130:
131: CURSOR get_note_id ( l_qte_hdr_id NUMBER) IS

Line 589: UPDATE ASO_QUOTE_HEADERS_ALL

585:
586: l_qte_header_rec.quote_version := NVL ( l_qte_header_rec.quote_version, 0 ) + 1;
587: l_qte_header_rec.max_version_flag := 'Y';
588:
589: UPDATE ASO_QUOTE_HEADERS_ALL
590: SET Max_Version_Flag = 'N'
591: ,last_update_date =sysdate
592: ,last_updated_by = G_USER_ID
593: ,last_update_login = G_LOGIN_ID

Line 1322: FROM ASO_QUOTE_HEADERS_ALL

1318: WHERE QUOTE_NUMBER = l_qte_num;
1319:
1320: CURSOR C_Get_Old_Qte (l_hdr_id NUMBER) IS
1321: SELECT Quote_Number
1322: FROM ASO_QUOTE_HEADERS_ALL
1323: WHERE QUote_Header_Id = l_hdr_id;
1324:
1325: l_qte_access_tbl aso_quote_pub.qte_access_tbl_type := aso_quote_pub.g_miss_qte_access_tbl;
1326: x_qte_access_tbl aso_quote_pub.qte_access_tbl_type;

Line 1959: p_old_object_code => 'ASO_QUOTE_HEADERS_ALL',

1955: END IF;
1956:
1957: ASO_ATTACHMENT_INT.COPY_ATTACHMENTS(
1958: p_api_version => l_api_version,
1959: p_old_object_code => 'ASO_QUOTE_HEADERS_ALL',
1960: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',
1961: p_old_object_id => l_old_qte_header_id,
1962: p_new_object_id => x_qte_header_id,
1963: x_return_status => l_return_status,

Line 1960: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',

1956:
1957: ASO_ATTACHMENT_INT.COPY_ATTACHMENTS(
1958: p_api_version => l_api_version,
1959: p_old_object_code => 'ASO_QUOTE_HEADERS_ALL',
1960: p_new_object_code => 'ASO_QUOTE_HEADERS_ALL',
1961: p_old_object_id => l_old_qte_header_id,
1962: p_new_object_id => x_qte_header_id,
1963: x_return_status => l_return_status,
1964: x_msg_count => x_msg_count,

Line 2455: From ASO_QUOTE_HEADERS_ALL

2451:
2452: Cursor C_Get_quote(c_QUOTE_HEADER_ID Number) IS
2453: Select
2454: LAST_UPDATE_DATE
2455: From ASO_QUOTE_HEADERS_ALL
2456: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
2457:
2458: Cursor Get_Max_Line_Number ( c_QUOTE_HEADER_ID Number) IS
2459: Select Max(Line_number)

Line 2497: SELECT org_id FROM aso_quote_headers_all

2493: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
2494:
2495: /* Code change for Quoting Usability Sun ER Start */
2496: CURSOR c_header_org IS
2497: SELECT org_id FROM aso_quote_headers_all
2498: WHERE quote_header_id = P_Qte_Header_Id;
2499:
2500: l_header_org_id NUMBER;
2501:

Line 5509: FROM ASO_QUOTE_HEADERS_ALL

5505: CURSOR C_Validate_Quote (
5506: x_qte_header_id NUMBER
5507: ) IS
5508: SELECT 'X'
5509: FROM ASO_QUOTE_HEADERS_ALL
5510: WHERE quote_header_id = x_qte_header_id;
5511:
5512: CURSOR C_Validate_Quote_Line (
5513: x_qte_header_id NUMBER,

Line 5575: FROM aso_quote_headers_all

5571: CURSOR get_latest_date (
5572: c_quote_header_id NUMBER
5573: ) IS
5574: SELECT last_update_date
5575: FROM aso_quote_headers_all
5576: WHERE quote_header_id = c_quote_header_id;
5577:
5578:
5579: Cursor Get_Max_Line_Number ( c_QUOTE_HEADER_ID Number) IS