DBA Data[Home] [Help]

APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_SEQ

Line 506: l_control_date_tbl fun_seq.control_date_tbl_type;

502: l_running_total_cr number;
503: l_batch_num varchar2(15);
504: l_numbering_type varchar2(30);
505: l_batch_count number;
506: l_control_date_tbl fun_seq.control_date_tbl_type;
507: l_seq_version_id NUMBER;
508: l_assignment_id NUMBER;
509: l_error_code VARCHAR2(30);
510:

Line 572: /* SELECT FUN_SEQ_S1.nextval

568: INTO l_numbering_type
569: FROM fun_system_options;
570:
571: IF l_numbering_type = 'SYS' then
572: /* SELECT FUN_SEQ_S1.nextval
573: INTO l_batch_num
574: FROM dual;
575: */
576: l_control_date_tbl := fun_seq.control_date_tbl_type();

Line 576: l_control_date_tbl := fun_seq.control_date_tbl_type();

572: /* SELECT FUN_SEQ_S1.nextval
573: INTO l_batch_num
574: FROM dual;
575: */
576: l_control_date_tbl := fun_seq.control_date_tbl_type();
577: l_control_date_tbl.extend(1);
578: l_control_date_tbl(1).date_type := 'CREATION_DATE';
579: l_control_date_tbl(1).date_value := sysdate;
580:

Line 581: FUN_SEQ.Get_Sequence_Number(

577: l_control_date_tbl.extend(1);
578: l_control_date_tbl(1).date_type := 'CREATION_DATE';
579: l_control_date_tbl(1).date_value := sysdate;
580:
581: FUN_SEQ.Get_Sequence_Number(
582: p_context_type => 'INTERCOMPANY_BATCH_SOURCE',
583: p_context_value => 'LOCAL',
584: p_application_id => 435,
585: p_table_name => 'FUN_TRX_BATCHES',