DBA Data[Home] [Help]

APPS.FUN_WEBADI_PKG dependencies on FUN_TRX_HEADERS

Line 684: Select Fun_Trx_Headers_S.nextval trx_id

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

Line 759: l_trx_id Fun_trx_headers.trx_id%type;

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

Line 760: l_recipient_id Fun_trx_headers.recipient_id%type;

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