DBA Data[Home] [Help]

APPS.FUN_WEBADI_PKG dependencies on FUN_TRX_HEADERS

Line 685: Select Fun_Trx_Headers_S.nextval trx_id

681: Where batch_id = cp_batch_id
682: And trx_number = cp_trx_number;
683:
684: Cursor C_Trx_Id Is
685: Select Fun_Trx_Headers_S.nextval trx_id
686: From Dual;
687:
688: Cursor C_Dupl_Reci_In_Batch(
689: cp_batch_id In Fun_Interface_Headers.batch_id%type,

Line 760: l_trx_id Fun_trx_headers.trx_id%type;

756: l_reci_dist_line_insert Varchar2(1);
757: l_data varchar2(2000);
758: l_dr_sum Fun_Interface_Dist_Lines.amount_dr%type;
759: l_cr_sum Fun_Interface_Dist_Lines.amount_cr%type;
760: l_trx_id Fun_trx_headers.trx_id%type;
761: l_recipient_id Fun_trx_headers.recipient_id%type;
762: l_init_amount_cr Fun_Interface_Headers.init_amount_cr%type;
763: l_init_amount_dr Fun_Interface_Headers.init_amount_dr%type;
764: l_trx_number Fun_Interface_Headers.trx_number%type;

Line 761: l_recipient_id Fun_trx_headers.recipient_id%type;

757: l_data varchar2(2000);
758: l_dr_sum Fun_Interface_Dist_Lines.amount_dr%type;
759: l_cr_sum Fun_Interface_Dist_Lines.amount_cr%type;
760: l_trx_id Fun_trx_headers.trx_id%type;
761: l_recipient_id Fun_trx_headers.recipient_id%type;
762: l_init_amount_cr Fun_Interface_Headers.init_amount_cr%type;
763: l_init_amount_dr Fun_Interface_Headers.init_amount_dr%type;
764: l_trx_number Fun_Interface_Headers.trx_number%type;
765: