APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on DUAL

Line 504: --DFF er changes has been removed in 12.1.1 branch file due to enabling the dualcheckin btw 12.0.6-->12.1.1

500: transactions also the rg register is hit in case of non bonded sub inventories so that a reverse
501: transaction can be passed for offsetting the receive transaction already done.
502: 42. 24-nov-2011 vkaranam for bug#13364465
503: issue:RTV TRANSACTION NOT FOUND IN RETURN TO VENDOR(INDIA) FORM FOR PROCESSING
504: --DFF er changes has been removed in 12.1.1 branch file due to enabling the dualcheckin btw 12.0.6-->12.1.1
505: fix:ported the DFF ER changes in bug#9305067 to the current file.
506:
507: 43. 22-Dec-2011 Bug 13514510
508: Issue - Cenvat cannot be claimed on ISO receipts of FGIN / FGEX items.

Line 3148: SELECT to_char(sysdate,'dd/mm/yyyy hh24:mi:ss')||'-jirt_pkg.process_transaction-'||p_transaction_id INTO lv_temp FROM DUAL;

3144: lv_object_code := 'RCPT_TRXN:';
3145: lv_execution_point := 'COMMON_CODE';
3146:
3147: -- this is to identify the path in SQL TRACE file if any problem occured
3148: SELECT to_char(sysdate,'dd/mm/yyyy hh24:mi:ss')||'-jirt_pkg.process_transaction-'||p_transaction_id INTO lv_temp FROM DUAL;
3149:
3150: FND_FILE.put_line(FND_FILE.log, '^Start of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss')
3151: ||', PrcSpecialReason:'||p_process_special_reason||', PrcSplQty:'||p_process_special_qty
3152: );

Line 4176: select 1 from dual

4172: /*Cursor is checking for Non Recoverable taxes
4173: with modvat flag as 'N' also mod_cr_percentage can be NULL
4174: or less than 100*/
4175: Cursor c_check_non_recover_taxes (p_shipment_line_id number) is /*Added by nprashar for bug # 9767315*/
4176: select 1 from dual
4177: Where Exists (
4178: select 1 from jai_rcv_line_taxes jrlt, jai_cmn_taxes_all jcta
4179: where jrlt.tax_id = jcta.tax_id
4180: and jrlt.shipment_line_id = p_shipment_line_id

Line 5287: eg in ILDEV -> select jai_rcv_trx_processing_pkg.get_trxn_tax_amount(14108, 10626, 50, 'N') amount from dual;

5283: /*
5284: Transaction can have two Currencies 1. Functional(INR) 2. Transactional (Non INR Currency in case of foreign Trxn)
5285: If p_return_in_inr_curr = 'Y' then Functional tax amount is returned otherwise in transactional currency in returned
5286: Tax amount returned is to the tune of TRANSACTION Quantity.
5287: eg in ILDEV -> select jai_rcv_trx_processing_pkg.get_trxn_tax_amount(14108, 10626, 50, 'N') amount from dual;
5288: */
5289:
5290: -- This cursor gives tax_amount in FOREIGN Currency
5291: CURSOR c_tax_amount(cp_shipment_line_id IN NUMBER, cp_curr_conv_rate IN NUMBER) IS

Line 5334: eg in ILDEV -> select jai_rcv_trx_processing_pkg.get_trxn_cenvat_amount(14108, 10626, 50) amount from dual;

5330: ) RETURN NUMBER IS
5331:
5332: /*
5333: This Always Returns Total Cenvat amount in INR Currency to the tune of transaction quantity, uom
5334: eg in ILDEV -> select jai_rcv_trx_processing_pkg.get_trxn_cenvat_amount(14108, 10626, 50) amount from dual;
5335: */
5336:
5337: -- This cursor gives tax_amount in FOREIGN Currency
5338: CURSOR c_tax_amount(cp_shipment_line_id IN NUMBER, cp_curr_conv_rate IN NUMBER, cp_organization_type IN VARCHAR2) IS