eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 338: FROM ASO_QUOTE_HEADERS_ALL

334: FROM dual;
335:
336: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
337: SELECT quote_version
338: FROM ASO_QUOTE_HEADERS_ALL
339: WHERE quote_number = X_qte_number;
340:
341: CURSOR C_Qte_Status_Id (c_status_code VARCHAR2) IS
342: SELECT quote_status_id

Line 1677: select quote_number from aso_quote_headers_all

1673: FROM ASO_SHIPMENTS
1674: WHERE shipment_id = p_shipment_id;
1675:
1676: cursor c_quote_number is
1677: select quote_number from aso_quote_headers_all
1678: where quote_header_id = p_qte_header_rec.quote_header_id;
1679:
1680: cursor get_payment_type_code( l_payment_id Number) is
1681: select payment_type_code

Line 1687: from aso_quote_headers_all

1683: where payment_id = l_payment_id;
1684:
1685: cursor get_bill_to_party( l_qte_hdr_id Number) is
1686: select invoice_to_cust_party_id
1687: from aso_quote_headers_all
1688: where quote_header_id = l_qte_hdr_id;
1689:
1690: -- Refer bug 10217258
1691: ct NUMBER;

Line 3547: FROM aso_quote_headers_all

3543:
3544:
3545: CURSOR c_old_shipping_charge IS
3546: SELECT round(total_shipping_charge,l_precision)
3547: FROM aso_quote_headers_all
3548: WHERE quote_header_id = p_qte_header_id;
3549:
3550: CURSOR c_hd_discount IS
3551: SELECT total_adjusted_percent

Line 3552: FROM aso_quote_headers_all

3548: WHERE quote_header_id = p_qte_header_id;
3549:
3550: CURSOR c_hd_discount IS
3551: SELECT total_adjusted_percent
3552: FROM aso_quote_headers_all
3553: WHERE quote_header_id = p_qte_header_id;
3554:
3555:
3556: Cursor get_hdr_payment_term IS

Line 3564: FROM aso_quote_headers_all

3560: and quote_line_id is null;
3561:
3562: Cursor get_hdr_curr_code IS
3563: SELECT currency_code
3564: FROM aso_quote_headers_all
3565: WHERE quote_header_id = p_qte_header_id;
3566:
3567: Cursor c_org_id IS
3568: Select org_id,quote_type

Line 3569: from aso_quote_headers_all

3565: WHERE quote_header_id = p_qte_header_id;
3566:
3567: Cursor c_org_id IS
3568: Select org_id,quote_type
3569: from aso_quote_headers_all
3570: where quote_header_id = p_qte_header_id;
3571:
3572: Cursor get_total_payment_amount( l_qte_hdr_id number) is
3573: select sum(payment_amount)

Line 3926: /*update aso_quote_headers_all

3922:
3923:
3924: -- Update the corresponding columns in the header table
3925: -- this update has been commented out as the update for this column is done below
3926: /*update aso_quote_headers_all
3927: set header_paynow_charges = l_paynow_charges,
3928: last_updated_by = fnd_global.user_id,
3929: last_update_login = fnd_global.conc_login_id
3930: where quote_header_id = P_Qte_Header_id; */

Line 3939: UPDATE ASO_QUOTE_HEADERS_ALL

3935: END IF;
3936:
3937: -- End of PNPL Changes
3938:
3939: UPDATE ASO_QUOTE_HEADERS_ALL
3940: SET total_list_price = l_total_list_price,
3941: total_shipping_charge = l_total_shipping_charge,
3942: total_adjusted_amount = l_ln_total_discount,
3943: total_adjusted_percent = decode( l_total_list_price, 0, NULL,

Line 4095: from aso_quote_headers_all

4091: l_price_updated_date_flag VARCHAR2(1) := fnd_api.g_false;
4092:
4093: cursor c_last_update_date( p_qte_hdr_id number ) is
4094: select last_update_date
4095: from aso_quote_headers_all
4096: where quote_header_id = p_qte_hdr_id;
4097:
4098: -- Code for Sales Team Assignment Changes
4099: CURSOR C_Check_Qte_Status (l_qte_hdr NUMBER) IS

Line 4101: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B

4097:
4098: -- Code for Sales Team Assignment Changes
4099: CURSOR C_Check_Qte_Status (l_qte_hdr NUMBER) IS
4100: SELECT 'Y'
4101: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B
4102: WHERE A.Quote_Header_Id = l_qte_hdr
4103: AND A.Quote_Status_Id = B.Quote_Status_Id
4104: AND B.Status_Code = 'STORE DRAFT';
4105:

Line 6328: update aso_quote_headers_all

6324: IF p_control_rec.calculate_tax_flag = 'Y' THEN
6325:
6326: IF l_price_updated_date_flag = fnd_api.g_true THEN
6327:
6328: update aso_quote_headers_all
6329: set tax_updated_date = sysdate,
6330: price_updated_date = sysdate
6331: where quote_header_id = x_qte_header_rec.quote_header_id;
6332:

Line 6335: update aso_quote_headers_all

6331: where quote_header_id = x_qte_header_rec.quote_header_id;
6332:
6333: ELSE
6334:
6335: update aso_quote_headers_all
6336: set tax_updated_date = sysdate
6337: where quote_header_id = x_qte_header_rec.quote_header_id;
6338:
6339: END IF;

Line 6343: update aso_quote_headers_all

6339: END IF;
6340:
6341: ELSIF l_price_updated_date_flag = fnd_api.g_true THEN
6342:
6343: update aso_quote_headers_all
6344: set price_updated_date = sysdate
6345: where quote_header_id = x_qte_header_rec.quote_header_id;
6346:
6347: END IF;

Line 6757: From ASO_QUOTE_HEADERS_ALL

6753: --ovn
6754: Cursor C_Get_quote(c_QUOTE_HEADER_ID Number) IS
6755: Select LAST_UPDATE_DATE, QUOTE_STATUS_ID, quote_number, party_id, cust_account_id,
6756: order_type_id, order_id, object_version_number, currency_code, price_list_id
6757: From ASO_QUOTE_HEADERS_ALL
6758: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
6759:
6760: CURSOR C_Qte_Status(c_qte_status_id NUMBER) IS
6761: SELECT AUTO_VERSION_FLAG

Line 6767: FROM ASO_QUOTE_HEADERS_ALL

6763: WHERE quote_status_id = c_qte_status_id;
6764:
6765: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
6766: SELECT max(quote_version)
6767: FROM ASO_QUOTE_HEADERS_ALL
6768: WHERE quote_number = X_qte_number;
6769:
6770: CURSOR c_payment_rec IS
6771: SELECT payment_id, payment_option FROM ASO_PAYMENTS

Line 6793: from aso_quote_headers_all

6789:
6790: --ovn
6791: cursor c_last_update_date( p_qte_hdr_id number) is
6792: select last_update_date
6793: from aso_quote_headers_all
6794: where quote_header_id = p_qte_hdr_id;
6795:
6796: cursor c_quote_lines( p_qte_hdr_id number) is
6797: select quote_line_id,order_line_type_id,line_category_code,price_list_id,line_quote_price,quantity

Line 6995: FROM Aso_Quote_Headers_All

6991: and quote_line_id IS NULL;
6992:
6993: CURSOR C_Get_Hdr_Resource_Id(lc_qte_header_id NUMBER) IS
6994: SELECT resource_id
6995: FROM Aso_Quote_Headers_All
6996: WHERE quote_header_id = lc_qte_header_id;
6997:
6998: CURSOR c_inv_org_id(l_main_org_id Number) IS
6999: SELECT master_organization_id

Line 7005: FROM aso_quote_headers_all

7001: WHERE org_id = l_main_org_id;
7002:
7003: CURSOR c_org_id(p_qte_header_id Number) IS
7004: SELECT org_id
7005: FROM aso_quote_headers_all
7006: WHERE quote_header_id = p_qte_header_id;
7007:
7008: l_master_organization_id NUMBER;
7009: l_quote_org_id NUMBER;

Line 7064: FROM aso_quote_headers_all

7060: l_check_service_rec ASO_SERVICE_CONTRACTS_INT.CHECK_SERVICE_REC_TYPE;
7061:
7062: CURSOR C_get_cust( p_qte_hdr_id number) IS
7063: SELECT END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id
7064: FROM aso_quote_headers_all
7065: WHERE quote_header_id= p_qte_hdr_id;
7066:
7067: CURSOR c_serv( p_qte_hdr_id number) IS
7068: SELECT a1.quote_line_id,

Line 7156: From aso_quote_headers_all

7152: /*** Start : Code change done for Bug 11076978 ***/
7153:
7154: Cursor C_cust_account_id(p_quote_header_id Number) IS
7155: Select cust_account_id
7156: From aso_quote_headers_all
7157: Where quote_header_id = p_quote_header_id;
7158:
7159: CURSOR c_pay_term_acct(p_cust_account_id IN Number) IS
7160: SELECT hcp.standard_terms

Line 7210: From aso_quote_headers_all

7206: /*** Start : Code change done for Bug 13926015 ***/
7207: Cursor C_Expire_Date(P_Quote_header_id number) Is
7208: -- Select to_char(quote_expiration_date,'DD-MON-RRRR') commented for bug 14099184
7209: Select quote_expiration_date
7210: From aso_quote_headers_all
7211: Where Quote_header_id = P_Quote_header_id;
7212:
7213: l_expire_date Date;
7214:

Line 8702: update aso_quote_headers_all

8698: aso_debug_pub.add('Update_Quote: After copy_quote l_qte_header_id: ' || l_qte_header_id);
8699: aso_debug_pub.add('Update_Quote: After copy_quote l_quote_number: ' || l_quote_number);
8700: END IF;
8701:
8702: update aso_quote_headers_all
8703: set quote_version = l_qte_header_rec.quote_version + 1,
8704: max_version_flag = 'Y',
8705: creation_date = sysdate
8706: where quote_header_id = l_qte_header_rec.quote_header_id;

Line 8708: update aso_quote_headers_all

8704: max_version_flag = 'Y',
8705: creation_date = sysdate
8706: where quote_header_id = l_qte_header_rec.quote_header_id;
8707:
8708: update aso_quote_headers_all
8709: set max_version_flag = 'N',
8710: quote_version = l_old_header_rec.quote_version,
8711: quote_status_id = l_old_header_rec.quote_status_id,
8712: creation_date = l_old_header_rec.creation_date,

Line 8719: update aso_quote_headers_all

8715: last_updated_by = g_user_id,
8716: last_update_login = g_login_id
8717: where quote_header_id = l_qte_header_id;
8718:
8719: update aso_quote_headers_all
8720: set quote_version = l_qte_header_rec.quote_version,
8721: last_update_date = sysdate,
8722: created_by = g_user_id,
8723: last_updated_by = g_user_id,

Line 8734: aso_debug_pub.add('Update_Quote: After updating aso_quote_headers_all table for auto versioning.');

8730:
8731: l_control_rec.last_update_date := l_qte_header_rec.last_update_date;
8732:
8733: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8734: aso_debug_pub.add('Update_Quote: After updating aso_quote_headers_all table for auto versioning.');
8735: aso_debug_pub.add('l_qte_header_rec.last_update_date: '|| l_qte_header_rec.last_update_date);
8736: aso_debug_pub.add('l_control_rec.last_update_date: '|| l_control_rec.last_update_date);
8737: END IF;
8738:

Line 11344: update aso_quote_headers_all

11340: IF p_control_rec.calculate_tax_flag = 'Y' THEN
11341:
11342: IF l_price_updated_date_flag = fnd_api.g_true THEN
11343:
11344: update aso_quote_headers_all
11345: set tax_updated_date = sysdate,
11346: price_updated_date = sysdate,
11347: recalculate_flag = 'N'
11348: where quote_header_id = x_qte_header_rec.quote_header_id;

Line 11352: update aso_quote_headers_all

11348: where quote_header_id = x_qte_header_rec.quote_header_id;
11349:
11350: ELSE
11351:
11352: update aso_quote_headers_all
11353: set tax_updated_date = sysdate
11354: where quote_header_id = x_qte_header_rec.quote_header_id;
11355:
11356: END IF;

Line 11360: update aso_quote_headers_all

11356: END IF;
11357:
11358: ELSIF l_price_updated_date_flag = fnd_api.g_true THEN
11359:
11360: update aso_quote_headers_all
11361: set price_updated_date = sysdate,
11362: recalculate_flag = 'N'
11363: where quote_header_id = x_qte_header_rec.quote_header_id;
11364:

Line 11868: FROM ASO_QUOTE_HEADERS_ALL

11864: ) IS
11865: /* -- original cpy_qte
11866: CURSOR C_Validate_Quote (x_qte_header_id NUMBER) IS
11867: SELECT 'X'
11868: FROM ASO_QUOTE_HEADERS_ALL
11869: WHERE quote_header_id = x_qte_header_id;
11870:
11871:
11872:

Line 11989: FROM ASO_QUOTE_HEADERS_ALL

11985: FROM sys.dual;
11986:
11987: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
11988: SELECT max(quote_version)
11989: FROM ASO_QUOTE_HEADERS_ALL
11990: WHERE quote_number = X_qte_number;
11991:
11992: CURSOR C_Qte_Status_Id (c_status_code VARCHAR2) IS
11993: SELECT quote_status_id

Line 12005: FROM ASO_QUOTE_HEADERS_ALL

12001: WHERE from_status_id = from_id AND to_status_id = to_id;
12002:
12003: CURSOR C_Qte_Number_exists (X_qte_number NUMBER) IS
12004: SELECT quote_number
12005: FROM ASO_QUOTE_HEADERS_ALL
12006: WHERE quote_number = X_qte_number;
12007:
12008: l_api_name CONSTANT VARCHAR2(30) := 'Copy_quote';
12009: l_api_version_number CONSTANT NUMBER := 1.0;

Line 12022: FROM ASO_QUOTE_HEADERS_ALL

12018: */ -- original cpy_qte
12019:
12020: CURSOR C_Get_Hdr_Info(qte_hdr_id NUMBER) IS
12021: SELECT Quote_Expiration_Date, Resource_Id, Resource_Grp_Id
12022: FROM ASO_QUOTE_HEADERS_ALL
12023: WHERE Quote_Header_Id = qte_hdr_id;
12024:
12025: l_api_name CONSTANT VARCHAR2(30) := 'Copy_quote';
12026: l_api_version_number CONSTANT NUMBER := 1.0;