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 337: FROM ASO_QUOTE_HEADERS_ALL

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

Line 1673: select quote_number from aso_quote_headers_all

1669: FROM ASO_SHIPMENTS
1670: WHERE shipment_id = p_shipment_id;
1671:
1672: cursor c_quote_number is
1673: select quote_number from aso_quote_headers_all
1674: where quote_header_id = p_qte_header_rec.quote_header_id;
1675:
1676: cursor get_payment_type_code( l_payment_id Number) is
1677: select payment_type_code

Line 1683: from aso_quote_headers_all

1679: where payment_id = l_payment_id;
1680:
1681: cursor get_bill_to_party( l_qte_hdr_id Number) is
1682: select invoice_to_cust_party_id
1683: from aso_quote_headers_all
1684: where quote_header_id = l_qte_hdr_id;
1685:
1686: BEGIN
1687: x_return_status := fnd_api.g_ret_sts_success;

Line 3485: FROM aso_quote_headers_all

3481:
3482:
3483: CURSOR c_old_shipping_charge IS
3484: SELECT total_shipping_charge
3485: FROM aso_quote_headers_all
3486: WHERE quote_header_id = p_qte_header_id;
3487:
3488:
3489: CURSOR c_hd_discount IS

Line 3491: FROM aso_quote_headers_all

3487:
3488:
3489: CURSOR c_hd_discount IS
3490: SELECT total_adjusted_percent
3491: FROM aso_quote_headers_all
3492: WHERE quote_header_id = p_qte_header_id;
3493:
3494:
3495: Cursor get_hdr_payment_term IS

Line 3503: FROM aso_quote_headers_all

3499: and quote_line_id is null;
3500:
3501: Cursor get_hdr_curr_code IS
3502: SELECT currency_code
3503: FROM aso_quote_headers_all
3504: WHERE quote_header_id = p_qte_header_id;
3505:
3506: Cursor c_org_id IS
3507: Select org_id,quote_type

Line 3508: from aso_quote_headers_all

3504: WHERE quote_header_id = p_qte_header_id;
3505:
3506: Cursor c_org_id IS
3507: Select org_id,quote_type
3508: from aso_quote_headers_all
3509: where quote_header_id = p_qte_header_id;
3510:
3511: Cursor get_total_payment_amount( l_qte_hdr_id number) is
3512: select sum(payment_amount)

Line 3844: /*update aso_quote_headers_all

3840:
3841:
3842: -- Update the corresponding columns in the header table
3843: -- this update has been commented out as the update for this column is done below
3844: /*update aso_quote_headers_all
3845: set header_paynow_charges = l_paynow_charges,
3846: last_updated_by = fnd_global.user_id,
3847: last_update_login = fnd_global.conc_login_id
3848: where quote_header_id = P_Qte_Header_id; */

Line 3857: UPDATE ASO_QUOTE_HEADERS_ALL

3853: END IF;
3854:
3855: -- End of PNPL Changes
3856:
3857: UPDATE ASO_QUOTE_HEADERS_ALL
3858: SET total_list_price = l_total_list_price,
3859: total_shipping_charge = l_total_shipping_charge,
3860: total_adjusted_amount = l_ln_total_discount,
3861: total_adjusted_percent = decode( l_total_list_price, 0, NULL,

Line 4012: from aso_quote_headers_all

4008: l_price_updated_date_flag VARCHAR2(1) := fnd_api.g_false;
4009:
4010: cursor c_last_update_date( p_qte_hdr_id number ) is
4011: select last_update_date
4012: from aso_quote_headers_all
4013: where quote_header_id = p_qte_hdr_id;
4014:
4015: -- Code for Sales Team Assignment Changes
4016: CURSOR C_Check_Qte_Status (l_qte_hdr NUMBER) IS

Line 4018: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B

4014:
4015: -- Code for Sales Team Assignment Changes
4016: CURSOR C_Check_Qte_Status (l_qte_hdr NUMBER) IS
4017: SELECT 'Y'
4018: FROM ASO_QUOTE_HEADERS_ALL A, ASO_QUOTE_STATUSES_B B
4019: WHERE A.Quote_Header_Id = l_qte_hdr
4020: AND A.Quote_Status_Id = B.Quote_Status_Id
4021: AND B.Status_Code = 'STORE DRAFT';
4022:

Line 6190: update aso_quote_headers_all

6186: IF p_control_rec.calculate_tax_flag = 'Y' THEN
6187:
6188: IF l_price_updated_date_flag = fnd_api.g_true THEN
6189:
6190: update aso_quote_headers_all
6191: set tax_updated_date = sysdate,
6192: price_updated_date = sysdate
6193: where quote_header_id = x_qte_header_rec.quote_header_id;
6194:

Line 6197: update aso_quote_headers_all

6193: where quote_header_id = x_qte_header_rec.quote_header_id;
6194:
6195: ELSE
6196:
6197: update aso_quote_headers_all
6198: set tax_updated_date = sysdate
6199: where quote_header_id = x_qte_header_rec.quote_header_id;
6200:
6201: END IF;

Line 6205: update aso_quote_headers_all

6201: END IF;
6202:
6203: ELSIF l_price_updated_date_flag = fnd_api.g_true THEN
6204:
6205: update aso_quote_headers_all
6206: set price_updated_date = sysdate
6207: where quote_header_id = x_qte_header_rec.quote_header_id;
6208:
6209: END IF;

Line 6618: From ASO_QUOTE_HEADERS_ALL

6614: --ovn
6615: Cursor C_Get_quote(c_QUOTE_HEADER_ID Number) IS
6616: Select LAST_UPDATE_DATE, QUOTE_STATUS_ID, quote_number, party_id, cust_account_id,
6617: order_type_id, order_id, object_version_number, currency_code, price_list_id
6618: From ASO_QUOTE_HEADERS_ALL
6619: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
6620:
6621: CURSOR C_Qte_Status(c_qte_status_id NUMBER) IS
6622: SELECT AUTO_VERSION_FLAG

Line 6628: FROM ASO_QUOTE_HEADERS_ALL

6624: WHERE quote_status_id = c_qte_status_id;
6625:
6626: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
6627: SELECT max(quote_version)
6628: FROM ASO_QUOTE_HEADERS_ALL
6629: WHERE quote_number = X_qte_number;
6630:
6631: CURSOR c_payment_rec IS
6632: SELECT payment_id, payment_option FROM ASO_PAYMENTS

Line 6654: from aso_quote_headers_all

6650:
6651: --ovn
6652: cursor c_last_update_date( p_qte_hdr_id number) is
6653: select last_update_date
6654: from aso_quote_headers_all
6655: where quote_header_id = p_qte_hdr_id;
6656:
6657: cursor c_quote_lines( p_qte_hdr_id number) is
6658: select quote_line_id,order_line_type_id,line_category_code,price_list_id,line_quote_price,quantity

Line 6855: FROM Aso_Quote_Headers_All

6851: and quote_line_id IS NULL;
6852:
6853: CURSOR C_Get_Hdr_Resource_Id(lc_qte_header_id NUMBER) IS
6854: SELECT resource_id
6855: FROM Aso_Quote_Headers_All
6856: WHERE quote_header_id = lc_qte_header_id;
6857:
6858: CURSOR c_inv_org_id(l_main_org_id Number) IS
6859: SELECT master_organization_id

Line 6865: FROM aso_quote_headers_all

6861: WHERE org_id = l_main_org_id;
6862:
6863: CURSOR c_org_id(p_qte_header_id Number) IS
6864: SELECT org_id
6865: FROM aso_quote_headers_all
6866: WHERE quote_header_id = p_qte_header_id;
6867:
6868: l_master_organization_id NUMBER;
6869: l_quote_org_id NUMBER;

Line 7916: update aso_quote_headers_all

7912: aso_debug_pub.add('Update_Quote: After copy_quote l_qte_header_id: ' || l_qte_header_id);
7913: aso_debug_pub.add('Update_Quote: After copy_quote l_quote_number: ' || l_quote_number);
7914: END IF;
7915:
7916: update aso_quote_headers_all
7917: set quote_version = l_qte_header_rec.quote_version + 1,
7918: max_version_flag = 'Y',
7919: creation_date = sysdate
7920: where quote_header_id = l_qte_header_rec.quote_header_id;

Line 7922: update aso_quote_headers_all

7918: max_version_flag = 'Y',
7919: creation_date = sysdate
7920: where quote_header_id = l_qte_header_rec.quote_header_id;
7921:
7922: update aso_quote_headers_all
7923: set max_version_flag = 'N',
7924: quote_version = l_old_header_rec.quote_version,
7925: quote_status_id = l_old_header_rec.quote_status_id,
7926: creation_date = l_old_header_rec.creation_date,

Line 7933: update aso_quote_headers_all

7929: last_updated_by = g_user_id,
7930: last_update_login = g_login_id
7931: where quote_header_id = l_qte_header_id;
7932:
7933: update aso_quote_headers_all
7934: set quote_version = l_qte_header_rec.quote_version,
7935: last_update_date = sysdate,
7936: created_by = g_user_id,
7937: last_updated_by = g_user_id,

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

7944:
7945: l_control_rec.last_update_date := l_qte_header_rec.last_update_date;
7946:
7947: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7948: aso_debug_pub.add('Update_Quote: After updating aso_quote_headers_all table for auto versioning.');
7949: aso_debug_pub.add('l_qte_header_rec.last_update_date: '|| l_qte_header_rec.last_update_date);
7950: aso_debug_pub.add('l_control_rec.last_update_date: '|| l_control_rec.last_update_date);
7951: END IF;
7952:

Line 10273: update aso_quote_headers_all

10269: IF p_control_rec.calculate_tax_flag = 'Y' THEN
10270:
10271: IF l_price_updated_date_flag = fnd_api.g_true THEN
10272:
10273: update aso_quote_headers_all
10274: set tax_updated_date = sysdate,
10275: price_updated_date = sysdate,
10276: recalculate_flag = 'N'
10277: where quote_header_id = x_qte_header_rec.quote_header_id;

Line 10281: update aso_quote_headers_all

10277: where quote_header_id = x_qte_header_rec.quote_header_id;
10278:
10279: ELSE
10280:
10281: update aso_quote_headers_all
10282: set tax_updated_date = sysdate
10283: where quote_header_id = x_qte_header_rec.quote_header_id;
10284:
10285: END IF;

Line 10289: update aso_quote_headers_all

10285: END IF;
10286:
10287: ELSIF l_price_updated_date_flag = fnd_api.g_true THEN
10288:
10289: update aso_quote_headers_all
10290: set price_updated_date = sysdate,
10291: recalculate_flag = 'N'
10292: where quote_header_id = x_qte_header_rec.quote_header_id;
10293:

Line 10797: FROM ASO_QUOTE_HEADERS_ALL

10793: ) IS
10794: /* -- original cpy_qte
10795: CURSOR C_Validate_Quote (x_qte_header_id NUMBER) IS
10796: SELECT 'X'
10797: FROM ASO_QUOTE_HEADERS_ALL
10798: WHERE quote_header_id = x_qte_header_id;
10799:
10800:
10801:

Line 10918: FROM ASO_QUOTE_HEADERS_ALL

10914: FROM sys.dual;
10915:
10916: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
10917: SELECT max(quote_version)
10918: FROM ASO_QUOTE_HEADERS_ALL
10919: WHERE quote_number = X_qte_number;
10920:
10921: CURSOR C_Qte_Status_Id (c_status_code VARCHAR2) IS
10922: SELECT quote_status_id

Line 10934: FROM ASO_QUOTE_HEADERS_ALL

10930: WHERE from_status_id = from_id AND to_status_id = to_id;
10931:
10932: CURSOR C_Qte_Number_exists (X_qte_number NUMBER) IS
10933: SELECT quote_number
10934: FROM ASO_QUOTE_HEADERS_ALL
10935: WHERE quote_number = X_qte_number;
10936:
10937: l_api_name CONSTANT VARCHAR2(30) := 'Copy_quote';
10938: l_api_version_number CONSTANT NUMBER := 1.0;

Line 10951: FROM ASO_QUOTE_HEADERS_ALL

10947: */ -- original cpy_qte
10948:
10949: CURSOR C_Get_Hdr_Info(qte_hdr_id NUMBER) IS
10950: SELECT Quote_Expiration_Date, Resource_Id, Resource_Grp_Id
10951: FROM ASO_QUOTE_HEADERS_ALL
10952: WHERE Quote_Header_Id = qte_hdr_id;
10953:
10954: l_api_name CONSTANT VARCHAR2(30) := 'Copy_quote';
10955: l_api_version_number CONSTANT NUMBER := 1.0;