APPS.ASO_TAX_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 2322: FROM aso_quote_headers_all trx

2318: -- new cursors added by suyog bug 5061912
2319:
2320: Cursor c_get_resource_id (l_qte_hdr_id NUMBER) is
2321: SELECT resource_id
2322: FROM aso_quote_headers_all trx
2323: WHERE trx.quote_header_id = l_qte_hdr_id;
2324:
2325: Cursor c_get_org_id ( l_source_id NUMBER) is
2326: SELECT per.organization_id

Line 2358: FROM ASO_QUOTE_HEADERS_ALL

2354: and b.party_id = a.party_id;
2355:
2356: Cursor C_ACC(p_quote_header_id Number) Is
2357: SELECT CUST_PARTY_ID
2358: FROM ASO_QUOTE_HEADERS_ALL
2359: WHERE QUOTE_HEADER_ID = p_quote_header_id;
2360:
2361: /* End for Bug 9558210 */
2362:

Line 2674: ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL' and

2670: END IF;
2671:
2672: DELETE FROM ZX_TRX_HEADERS_GT where
2673: APPLICATION_ID=697 and
2674: ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL' and
2675: EVENT_CLASS_CODE= 'SALES_TRANSACTION_TAX_QUOTE' and
2676: TRX_ID= p_qte_header_id;
2677:
2678: insert into ZX_TRX_HEADERS_GT

Line 2716: 'ASO_QUOTE_HEADERS_ALL',

2712: (
2713: l_qte_header_rec.ORG_ID,
2714: l_int_org_location,
2715: 697,
2716: 'ASO_QUOTE_HEADERS_ALL',
2717: 'SALES_TRANSACTION_TAX_QUOTE',
2718: 'CREATE',
2719: p_qte_header_id,
2720: sysdate,

Line 2752: AND ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL'

2748: END IF;
2749:
2750: DELETE FROM Zx_transaction_lines_gt
2751: WHERE APPLICATION_ID= 697
2752: AND ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL'
2753: AND EVENT_CLASS_CODE = 'SALES_TRANSACTION_TAX_QUOTE'
2754: AND TRX_ID = p_qte_header_id
2755: AND TRX_LEVEL_TYPE= 'LINE';
2756:

Line 2967: p_entity_code => 'ASO_QUOTE_HEADERS_ALL',

2963: p_tax_classification_code => l_Tax_Classification_Code,
2964: p_cust_trx_id => l_ra_cust_trx_type_id,
2965: p_customer_id => nvl(l_shipment_rec.ship_to_cust_party_id,l_shipment_header_rec.ship_to_cust_party_id),
2966: appl_short_name => 'ASO',
2967: p_entity_code => 'ASO_QUOTE_HEADERS_ALL',
2968: p_event_class_code => 'SALES_TRANSACTION_TAX_QUOTE',
2969: p_application_id => 697,
2970: p_internal_organization_id => l_qte_header_rec.org_id
2971: );

Line 3031: 'ASO_QUOTE_HEADERS_ALL',

3027: )
3028: values
3029: (
3030: 697,
3031: 'ASO_QUOTE_HEADERS_ALL',
3032: 'SALES_TRANSACTION_TAX_QUOTE',
3033: p_qte_header_id,
3034: 'LINE',
3035: l_qte_line_rec.QUOTE_LINE_ID,

Line 3181: a.ENTITY_CODE='ASO_QUOTE_HEADERS_ALL'

3177: a.TRX_ID=b.QUOTE_HEADER_ID
3178: AND
3179: a.APPLICATION_ID=697
3180: AND
3181: a.ENTITY_CODE='ASO_QUOTE_HEADERS_ALL'
3182: AND
3183: a.EVENT_CLASS_CODE='SALES_TRANSACTION_TAX_QUOTE'
3184: AND
3185: a.TRX_ID=p_qte_header_id