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_DEAL_PUB dependencies on ASO_QUOTE_HEADERS_ALL

Line 36: FROM aso_quote_headers_all

32: -- for fetching quote header details
33: CURSOR C_quote_header(pc_quote_header_id NUMBER)
34: IS
35: SELECT last_update_date, quote_number, max_version_flag, pricing_status_indicator, tax_status_indicator,quote_status_id,price_request_id
36: FROM aso_quote_headers_all
37: WHERE quote_header_id = pc_quote_header_id;
38:
39:
40: -- for fetching line level details

Line 122: l_last_update_date ASO_QUOTE_HEADERS_ALL.last_update_date%TYPE;

118: -- For multi-row query dynamic execution
119: TYPE PRCCURREF is REF CURSOR;
120: prcadj_cv PRCCURREF;
121:
122: l_last_update_date ASO_QUOTE_HEADERS_ALL.last_update_date%TYPE;
123: l_quote_number ASO_QUOTE_HEADERS_ALL.quote_number%TYPE;
124: l_max_version_flag ASO_QUOTE_HEADERS_ALL.max_version_flag%TYPE;
125: l_pricing_status ASO_QUOTE_HEADERS_ALL.PRICING_STATUS_INDICATOR%TYPE;
126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;

Line 123: l_quote_number ASO_QUOTE_HEADERS_ALL.quote_number%TYPE;

119: TYPE PRCCURREF is REF CURSOR;
120: prcadj_cv PRCCURREF;
121:
122: l_last_update_date ASO_QUOTE_HEADERS_ALL.last_update_date%TYPE;
123: l_quote_number ASO_QUOTE_HEADERS_ALL.quote_number%TYPE;
124: l_max_version_flag ASO_QUOTE_HEADERS_ALL.max_version_flag%TYPE;
125: l_pricing_status ASO_QUOTE_HEADERS_ALL.PRICING_STATUS_INDICATOR%TYPE;
126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;
127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;

Line 124: l_max_version_flag ASO_QUOTE_HEADERS_ALL.max_version_flag%TYPE;

120: prcadj_cv PRCCURREF;
121:
122: l_last_update_date ASO_QUOTE_HEADERS_ALL.last_update_date%TYPE;
123: l_quote_number ASO_QUOTE_HEADERS_ALL.quote_number%TYPE;
124: l_max_version_flag ASO_QUOTE_HEADERS_ALL.max_version_flag%TYPE;
125: l_pricing_status ASO_QUOTE_HEADERS_ALL.PRICING_STATUS_INDICATOR%TYPE;
126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;
127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;

Line 125: l_pricing_status ASO_QUOTE_HEADERS_ALL.PRICING_STATUS_INDICATOR%TYPE;

121:
122: l_last_update_date ASO_QUOTE_HEADERS_ALL.last_update_date%TYPE;
123: l_quote_number ASO_QUOTE_HEADERS_ALL.quote_number%TYPE;
124: l_max_version_flag ASO_QUOTE_HEADERS_ALL.max_version_flag%TYPE;
125: l_pricing_status ASO_QUOTE_HEADERS_ALL.PRICING_STATUS_INDICATOR%TYPE;
126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;
127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
129: ld_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;

Line 126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;

122: l_last_update_date ASO_QUOTE_HEADERS_ALL.last_update_date%TYPE;
123: l_quote_number ASO_QUOTE_HEADERS_ALL.quote_number%TYPE;
124: l_max_version_flag ASO_QUOTE_HEADERS_ALL.max_version_flag%TYPE;
125: l_pricing_status ASO_QUOTE_HEADERS_ALL.PRICING_STATUS_INDICATOR%TYPE;
126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;
127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
129: ld_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
130: l_price_request_id ASO_QUOTE_HEADERS_ALL.PRICE_REQUEST_ID%TYPE;

Line 127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;

123: l_quote_number ASO_QUOTE_HEADERS_ALL.quote_number%TYPE;
124: l_max_version_flag ASO_QUOTE_HEADERS_ALL.max_version_flag%TYPE;
125: l_pricing_status ASO_QUOTE_HEADERS_ALL.PRICING_STATUS_INDICATOR%TYPE;
126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;
127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
129: ld_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
130: l_price_request_id ASO_QUOTE_HEADERS_ALL.PRICE_REQUEST_ID%TYPE;
131: l_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;

Line 128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;

124: l_max_version_flag ASO_QUOTE_HEADERS_ALL.max_version_flag%TYPE;
125: l_pricing_status ASO_QUOTE_HEADERS_ALL.PRICING_STATUS_INDICATOR%TYPE;
126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;
127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
129: ld_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
130: l_price_request_id ASO_QUOTE_HEADERS_ALL.PRICE_REQUEST_ID%TYPE;
131: l_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;
132: l_line_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;

Line 129: ld_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;

125: l_pricing_status ASO_QUOTE_HEADERS_ALL.PRICING_STATUS_INDICATOR%TYPE;
126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;
127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
129: ld_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
130: l_price_request_id ASO_QUOTE_HEADERS_ALL.PRICE_REQUEST_ID%TYPE;
131: l_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;
132: l_line_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;
133: l_shipment_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;

Line 130: l_price_request_id ASO_QUOTE_HEADERS_ALL.PRICE_REQUEST_ID%TYPE;

126: l_tax_status ASO_QUOTE_HEADERS_ALL.TAX_STATUS_INDICATOR%TYPE;
127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
129: ld_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
130: l_price_request_id ASO_QUOTE_HEADERS_ALL.PRICE_REQUEST_ID%TYPE;
131: l_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;
132: l_line_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;
133: l_shipment_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;
134: l_line_ship_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;

Line 309: update aso_quote_headers_All

305: END IF;
306:
307: end if;
308:
309: update aso_quote_headers_All
310: set last_update_date=l_last_update_date,quote_status_id=ln_quote_Status_id
311: where quote_header_id=p_quote_header_id;
312:
313:

Line 350: update aso_quote_headers_All

346: else -- if valid transition to price approval pending
347: IF aso_debug_pub.g_debug_flag = 'Y' then
348: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count>0'||ld_quote_Status_id, 1, 'Y');
349: END IF;
350: update aso_quote_headers_All
351: set quote_status_id=ld_quote_Status_id
352: where quote_header_id=p_quote_header_id;
353: end if; -- status transition doesnot exist
354: end if; -- if status is not price approval pending

Line 743: update aso_quote_headers_All

739: RAISE FND_API.G_EXC_ERROR;
740: END IF;
741: end if;
742:
743: update aso_quote_headers_All
744: set last_update_date=l_last_update_date,quote_status_id=ln_quote_Status_id
745: where quote_header_id=p_quote_header_id;
746:
747: END IF;

Line 940: FROM aso_quote_headers_all

936:
937: -- Getting quote header Details
938: SELECT nvl(max_version_flag,'N'), price_request_id, nvl(pricing_status_indicator,'C'),quote_number,quote_status_id
939: into l_max_version_flag, l_price_request_id,l_pricing_status,l_quote_number,l_quote_status_id
940: FROM aso_quote_headers_all
941: WHERE quote_header_id = p_quote_header_id;
942:
943: -- Getting the user level access
944: l_access_level:=ASO_SECURITY_INT.Get_Quote_Access (p_resource_id,l_quote_number);

Line 1015: FROM aso_quote_headers_all

1011:
1012: -- Getting quote header Details
1013: SELECT nvl(max_version_flag,'N'), price_request_id, nvl(pricing_status_indicator,'C'),quote_number
1014: into l_max_version_flag, l_price_request_id,l_pricing_status,l_quote_number
1015: FROM aso_quote_headers_all
1016: WHERE quote_header_id = p_quote_header_id;
1017:
1018: -- Getting the user level access
1019: l_access_level:=ASO_SECURITY_INT.Get_Quote_Access (p_resource_id,l_quote_number);