[Home] [Help]
2317: -- new cursors added by suyog bug 5061912
2318:
2319: Cursor c_get_resource_id (l_qte_hdr_id NUMBER) is
2320: SELECT resource_id
2321: FROM aso_quote_headers_all trx
2322: WHERE trx.quote_header_id = l_qte_hdr_id;
2323:
2324: Cursor c_get_org_id ( l_source_id NUMBER) is
2325: SELECT per.organization_id
2588: END IF;
2589:
2590: DELETE FROM ZX_TRX_HEADERS_GT where
2591: APPLICATION_ID=697 and
2592: ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL' and
2593: EVENT_CLASS_CODE= 'SALES_TRANSACTION_TAX_QUOTE' and
2594: TRX_ID= p_qte_header_id;
2595:
2596: insert into ZX_TRX_HEADERS_GT
2630: (
2631: l_qte_header_rec.ORG_ID,
2632: l_int_org_location,
2633: 697,
2634: 'ASO_QUOTE_HEADERS_ALL',
2635: 'SALES_TRANSACTION_TAX_QUOTE',
2636: 'CREATE',
2637: p_qte_header_id,
2638: sysdate,
2666: END IF;
2667:
2668: DELETE FROM Zx_transaction_lines_gt
2669: WHERE APPLICATION_ID= 697
2670: AND ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL'
2671: AND EVENT_CLASS_CODE = 'SALES_TRANSACTION_TAX_QUOTE'
2672: AND TRX_ID = p_qte_header_id
2673: AND TRX_LEVEL_TYPE= 'LINE';
2674:
2871: p_tax_classification_code => l_Tax_Classification_Code,
2872: p_cust_trx_id => l_ra_cust_trx_type_id,
2873: p_customer_id => nvl(l_shipment_rec.ship_to_cust_party_id,l_shipment_header_rec.ship_to_cust_party_id),
2874: appl_short_name => 'ASO',
2875: p_entity_code => 'ASO_QUOTE_HEADERS_ALL',
2876: p_event_class_code => 'SALES_TRANSACTION_TAX_QUOTE',
2877: p_application_id => 697,
2878: p_internal_organization_id => l_qte_header_rec.org_id
2879: );
2935: )
2936: values
2937: (
2938: 697,
2939: 'ASO_QUOTE_HEADERS_ALL',
2940: 'SALES_TRANSACTION_TAX_QUOTE',
2941: p_qte_header_id,
2942: 'LINE',
2943: l_qte_line_rec.QUOTE_LINE_ID,
3079: a.TRX_ID=b.QUOTE_HEADER_ID
3080: AND
3081: a.APPLICATION_ID=697
3082: AND
3083: a.ENTITY_CODE='ASO_QUOTE_HEADERS_ALL'
3084: AND
3085: a.EVENT_CLASS_CODE='SALES_TRANSACTION_TAX_QUOTE'
3086: AND
3087: a.TRX_ID=p_qte_header_id