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.JAI_PA_COSTING_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 682: from pa_transaction_interface_all

678: is
679:
680: cursor c_pa_trx_xface_rec_status is
681: select txn_interface_id, transaction_status_code, expenditure_item_id, cdl_system_reference4, attribute9
682: from pa_transaction_interface_all
683: where transaction_source = p_transaction_source
684: and transaction_status_code in ('I', 'A')
685: and interface_id = p_xface_id;
686:

Line 689: from pa_transaction_interface_all

685: and interface_id = p_xface_id;
686:
687: cursor c_pa_trx_xface_receipt is
688: select txn_interface_id, transaction_status_code, expenditure_item_id, cdl_system_reference4, attribute9
689: from pa_transaction_interface_all
690: where transaction_source = p_transaction_source
691: and transaction_status_code in ('I', 'A')
692: and interface_id = p_xface_id
693: and (attribute10 <> 'INDIA LOCALIZATION' or attribute10 is NULL);

Line 744: delete from pa_transaction_interface_all

740: loop
741:
742: FND_FILE.put_line(FND_FILE.log, 'Deleting records with transaction_status_code R');
743:
744: delete from pa_transaction_interface_all
745: where attribute10 = 'INDIA LOCALIZATION'
746: and transaction_status_code not in ('I', 'A')
747: and cdl_system_reference4 = r_pa_trx_xface_rec_status.cdl_system_reference4;
748:

Line 761: update pa_transaction_interface_all

757: set request_id = fnd_global.conc_request_id()
758: where current of c_upd_req_id;
759: end loop; /*for r_upd_req_id in c_upd_req_id*/
760:
761: update pa_transaction_interface_all
762: set transaction_status_code = 'A'
763: where transaction_source = p_transaction_source
764: and transaction_status_code = 'I'
765: and interface_id = p_xface_id;

Line 796: from pa_transaction_interface_all

792:
793: cursor c_pa_trx_xface_records
794: is
795: select *
796: from pa_transaction_interface_all
797: where transaction_source = p_transaction_source
798: and batch_name = p_batch
799: and transaction_status_code = 'P'
800: and interface_id = p_xface_id;

Line 902: from pa_transaction_interface_all pti

898: and batch_name = nvl(p_batch, batch_name)
899: and (request_id <> FND_GLOBAL.CONC_REQUEST_ID() or request_id is NULL)
900: and not exists
901: ( select 1
902: from pa_transaction_interface_all pti
903: where pti.transaction_source = jait.transaction_source
904: and pti.cdl_system_reference4 = jait.cdl_system_reference4
905: and pti.attribute9 = jait.attribute9
906: and pti.transaction_status_code = 'P');

Line 974: ,'Before update pa_transaction_interface_all'

970: );
971:
972: jai_cmn_debug_contexts_pkg.print
973: ( ln_reg_id
974: ,'Before update pa_transaction_interface_all'
975: );
976: */
977: /*
978: update pa_transaction_interface_all

Line 978: update pa_transaction_interface_all

974: ,'Before update pa_transaction_interface_all'
975: );
976: */
977: /*
978: update pa_transaction_interface_all
979: set raw_cost = raw_cost + nvl(ln_apportioned_tax_amt,0)
980: -- commented after talking to PROJECTs DEV team
981: -- ,receipt_currency_amount = receipt_currency_amount + nvl(ln_apportioned_tax_amt,0)
982: , denom_raw_cost = denom_raw_cost + nvl(ln_apportioned_tax_amt,0)

Line 1050: INSERT INTO pa_transaction_interface_all(

1046:
1047: -- Commented by Jia for FP Bug#9863751, Begin
1048: ----------------------------------------------------------------------------------------
1049: /*
1050: INSERT INTO pa_transaction_interface_all(
1051: TRANSACTION_SOURCE ,
1052: BATCH_NAME ,
1053: EXPENDITURE_ENDING_DATE ,
1054: EMPLOYEE_NUMBER ,

Line 1263: -- Insert into jai_pa_tax_trxs before inserting into pa_transaction_interface_all

1259: -- Commented by Jia for FP Bug#9863751, End
1260:
1261:
1262: -- Added by Jia for FP Bug#9863751, Begin
1263: -- Insert into jai_pa_tax_trxs before inserting into pa_transaction_interface_all
1264: -- This is done to prevent duplicate Tax lines from getting interfaced to Projects
1265: ------------------------------------------------------------------------------------
1266: FND_FILE.put_line(FND_FILE.log, 'Inserting into jai_pa_tax_trxs');
1267:

Line 1512: -- Insert records into pa_transaction_interface_all from jai_pa_tax_trxs

1508: END IF;
1509:
1510: END LOOP;
1511:
1512: -- Insert records into pa_transaction_interface_all from jai_pa_tax_trxs
1513: -- Only unprocessed records must be inserted - This is identified by using the PA_ADDITION_FLAG
1514: FOR r_jai_pa_tax_trxs IN c_jai_pa_tax_trxs
1515: LOOP
1516:

Line 1521: FND_FILE.put_line(FND_FILE.log, 'Inserting into pa_transaction_interface_all :' || ln_txn_interface_id);

1517: SELECT pa_txn_interface_s.nextval
1518: INTO ln_txn_interface_id
1519: FROM dual;
1520:
1521: FND_FILE.put_line(FND_FILE.log, 'Inserting into pa_transaction_interface_all :' || ln_txn_interface_id);
1522: FND_FILE.put_line(FND_FILE.log, 'Debugs Values: ' || R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE || ':' || R_JAI_PA_TAX_TRXS.BATCH_NAME || ':'
1523: || R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ||
1524: ':' || R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE10 || ':' || R_JAI_PA_TAX_TRXS.INTERFACE_ID
1525: || ':' || R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE9);

Line 1527: INSERT INTO pa_transaction_interface_all(

1523: || R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ||
1524: ':' || R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE10 || ':' || R_JAI_PA_TAX_TRXS.INTERFACE_ID
1525: || ':' || R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE9);
1526:
1527: INSERT INTO pa_transaction_interface_all(
1528: TRANSACTION_SOURCE ,
1529: BATCH_NAME ,
1530: EXPENDITURE_ENDING_DATE ,
1531: EMPLOYEE_NUMBER ,