APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on DUAL

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

2701: lv_object_code := 'RCPT_TRXN:';
2702: lv_execution_point := 'COMMON_CODE';
2703:
2704: -- this is to identify the path in SQL TRACE file if any problem occured
2705: SELECT to_char(sysdate,'dd/mm/yyyy hh24:mi:ss')||'-jirt_pkg.process_transaction-'||p_transaction_id INTO lv_temp FROM DUAL;
2706:
2707: FND_FILE.put_line(FND_FILE.log, '^Start of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss')
2708: ||', PrcSpecialReason:'||p_process_special_reason||', PrcSplQty:'||p_process_special_qty
2709: );

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

4602: /*
4603: Transaction can have two Currencies 1. Functional(INR) 2. Transactional (Non INR Currency in case of foreign Trxn)
4604: If p_return_in_inr_curr = 'Y' then Functional tax amount is returned otherwise in transactional currency in returned
4605: Tax amount returned is to the tune of TRANSACTION Quantity.
4606: eg in ILDEV -> select jai_rcv_trx_processing_pkg.get_trxn_tax_amount(14108, 10626, 50, 'N') amount from dual;
4607: */
4608:
4609: -- This cursor gives tax_amount in FOREIGN Currency
4610: CURSOR c_tax_amount(cp_shipment_line_id IN NUMBER, cp_curr_conv_rate IN NUMBER) IS

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

4649: ) RETURN NUMBER IS
4650:
4651: /*
4652: This Always Returns Total Cenvat amount in INR Currency to the tune of transaction quantity, uom
4653: eg in ILDEV -> select jai_rcv_trx_processing_pkg.get_trxn_cenvat_amount(14108, 10626, 50) amount from dual;
4654: */
4655:
4656: -- This cursor gives tax_amount in FOREIGN Currency
4657: CURSOR c_tax_amount(cp_shipment_line_id IN NUMBER, cp_curr_conv_rate IN NUMBER, cp_organization_type IN VARCHAR2) IS