APPS.FUN_PERIOD_STATUS_PKG dependencies on FUN_SEQ

Line 598: l_control_date_tbl FUN_SEQ.CONTROL_DATE_TBL_TYPE;

594: FROM FUN_TRX_HEADERS
595: WHERE BATCH_ID = l_batch_id
596: AND STATUS IN ('SENT','ERROR','RECEIVED');
597:
598: l_control_date_tbl FUN_SEQ.CONTROL_DATE_TBL_TYPE;
599: l_control_date_rec FUN_SEQ.CONTROL_DATE_REC_TYPE;
600: l_seq_version_id NUMBER;
601: l_assignment_id NUMBER;
602: l_error_code VARCHAR2(1000);

Line 599: l_control_date_rec FUN_SEQ.CONTROL_DATE_REC_TYPE;

595: WHERE BATCH_ID = l_batch_id
596: AND STATUS IN ('SENT','ERROR','RECEIVED');
597:
598: l_control_date_tbl FUN_SEQ.CONTROL_DATE_TBL_TYPE;
599: l_control_date_rec FUN_SEQ.CONTROL_DATE_REC_TYPE;
600: l_seq_version_id NUMBER;
601: l_assignment_id NUMBER;
602: l_error_code VARCHAR2(1000);
603: l_batch_id FUN_TRX_BATCHES.BATCH_ID%TYPE;

Line 692: l_control_date_tbl := FUN_SEQ.CONTROL_DATE_TBL_TYPE();

688: AND STATUS NOT IN (''COMPLETE'', ''NEW'');';
689: END IF;
690:
691:
692: l_control_date_tbl := FUN_SEQ.CONTROL_DATE_TBL_TYPE();
693: l_control_date_tbl.EXTEND(1);
694: l_control_date_rec.date_type := 'CREATION_DATE';
695: l_control_date_rec.date_value := sysdate;
696: l_control_date_tbl(1) := l_control_date_rec;

Line 712: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',

708: --Fecthing the New Batch_id
709: SELECT FUN_TRX_BATCHES_S.nextval INTO l_batch_id FROM DUAL;
710:
711: --Fetching the New Batch Number
712: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
713: 'LOCAL',
714: 435,
715: 'FUN_TRX_BATCHES',
716: 'CREATION',