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 9307: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;

9303: v_target_exp_type_class VARCHAR2(30) ;
9304: v_offset_exp_type_class VARCHAR2(30) ;
9305: v_expnd_end_date DATE ;
9306: v_interface_id NUMBER ;
9307: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;
9308: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9309: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9310: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;
9311:

Line 9310: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;

9306: v_interface_id NUMBER ;
9307: v_batch_name PA_TRANSACTION_INTERFACE_ALL.BATCH_NAME%TYPE ;
9308: v_tgt_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9309: v_off_exp_group PA_EXPENDITURE_GROUPS.EXPENDITURE_GROUP%TYPE ;
9310: v_expnd_comment PA_TRANSACTION_INTERFACE_ALL.EXPENDITURE_COMMENT%TYPE;
9311:
9312: l_rej_code PA_ALLOC_TXN_DETAILS.rejection_code%type; /* added for bug 6243121 */
9313: l_cnt_ex number:=0; /* added for bug 6243121 */
9314:

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

9401: alloc_errors(p_rule_id, p_run_id, 'R', 'E','PA_AL_RELEASE_FAILED',TRUE,'N') ;
9402: END IF;
9403: end if ;
9404: IF P_DEBUG_MODE = 'Y' THEN
9405: pa_debug.write_file('Release_alloc_txns: ' || 'LOG', 'Inserting records in pa_transaction_interface_all');
9406: END IF;
9407: v_batch_name := substr( to_char(p_run_id), 1, 10) ;
9408: Open C_org_id ;
9409: Fetch C_org_id into v_org_id ;

Line 9430: insert into pa_transaction_interface_all

9426: ---- Validate the Items inserted in the Interface table --------
9427: --- We don't do this since transaction import will take care of this
9428: --- If we call validate item then we have to maintain that.
9429: ---- Items inserted in to the Interface table --------
9430: insert into pa_transaction_interface_all
9431: ( transaction_source
9432: , system_linkage
9433: , batch_name
9434: , organization_name

Line 9580: from pa_transaction_interface_all pti

9576: ( select transaction_status_code
9577: ,transaction_rejection_code
9578: , expenditure_id
9579: , expenditure_item_id
9580: from pa_transaction_interface_all pti
9581: where pti.orig_transaction_reference = to_char(alloc_txn_id)
9582: and pti.transaction_source = l_transaction_source -- Changed this for capital project changes
9583: and pti.batch_name = v_batch_name )
9584: where run_id = p_run_id ;