APPS.FUN_PERIOD_STATUS_PKG dependencies on FUN_SEQ

Line 600: l_control_date_tbl FUN_SEQ.CONTROL_DATE_TBL_TYPE;

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

Line 601: l_control_date_rec FUN_SEQ.CONTROL_DATE_REC_TYPE;

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

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

855: AND STATUS NOT IN (''COMPLETE'', ''NEW'');';
856: END IF;
857:
858:
859: l_control_date_tbl := FUN_SEQ.CONTROL_DATE_TBL_TYPE();
860: l_control_date_tbl.EXTEND(1);
861: l_control_date_rec.date_type := 'CREATION_DATE';
862: l_control_date_rec.date_value := sysdate;
863: l_control_date_tbl(1) := l_control_date_rec;

Line 881: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',

877: --Fecthing the New Batch_id
878: SELECT FUN_TRX_BATCHES_S.nextval INTO l_batch_id FROM DUAL;
879:
880: --Fetching the New Batch Number
881: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
882: 'LOCAL',
883: 435,
884: 'FUN_TRX_BATCHES',
885: 'CREATION',