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

Line 9412: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;

9408: v_target_exp_type_class VARCHAR2(30) ;
9409: v_offset_exp_type_class VARCHAR2(30) ;
9410: v_expnd_end_date DATE ;
9411: v_interface_id NUMBER ;
9412: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;
9413: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9414: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9415: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;
9416:

Line 9415: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;

9411: v_interface_id NUMBER ;
9412: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;
9413: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9414: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9415: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;
9416:
9417: l_rej_code PA_ALLOC_TXN_DETAILS.rejection_code%type; /* added for bug 6243121 */
9418: l_cnt_ex number:=0; /* added for bug 6243121 */
9419:

Line 9510: pa_debug.write_file('Release_alloc_txns: ' || 'LOG', 'Inserting records in pa_transaction_interface_all');

9506: alloc_errors(p_rule_id, p_run_id, 'R', 'E','PA_AL_RELEASE_FAILED',TRUE,'N') ;
9507: END IF;
9508: end if ;
9509: IF P_DEBUG_MODE = 'Y' THEN
9510: pa_debug.write_file('Release_alloc_txns: ' || 'LOG', 'Inserting records in pa_transaction_interface_all');
9511: END IF;
9512: v_batch_name := substr( to_char(p_run_id), 1, 10) ;
9513: Open C_org_id ;
9514: Fetch C_org_id into v_org_id ;

Line 9535: insert into pa_transaction_interface_all

9531: ---- Validate the Items inserted in the Interface table --------
9532: --- We don't do this since transaction import will take care of this
9533: --- If we call validate item then we have to maintain that.
9534: ---- Items inserted in to the Interface table --------
9535: insert into pa_transaction_interface_all
9536: ( transaction_source
9537: , system_linkage
9538: , batch_name
9539: , organization_name

Line 9685: from pa_transaction_interface_all pti

9681: ( select transaction_status_code
9682: ,transaction_rejection_code
9683: , expenditure_id
9684: , expenditure_item_id
9685: from pa_transaction_interface_all pti
9686: where pti.orig_transaction_reference = to_char(alloc_txn_id)
9687: and pti.transaction_source = l_transaction_source -- Changed this for capital project changes
9688: and pti.batch_name = v_batch_name )
9689: where run_id = p_run_id ;