DBA Data[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on PA_TXN_INTERFACE_S

Line 3880: -- l_interface_id := pa_txn_interface_s.nextval;

3876:
3877:
3878: l_expenditure_comment := gms_batch_rec.source_type||':'||gms_batch_rec.payroll_source_code||':'||l_period_name||':'||gms_batch_rec.batch_name;
3879:
3880: -- l_interface_id := pa_txn_interface_s.nextval;
3881:
3882: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' open gms_interface_cursor');
3883:
3884: OPEN gms_interface_cursor(gms_batch_rec.payroll_control_id);

Line 3988: select pa_txn_interface_s.nextval

3984: END;
3985:
3986: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
3987:
3988: select pa_txn_interface_s.nextval
3989: into l_txn_interface_id
3990: from dual;
3991:
3992: -- get the expenditure week ending date