-* Linux Migration End Change -* Linux Migration Start Change -SET &&REP_FILE = (&WORKDIR || '/'||&REP_NAME); -IF &UNAME_RESULT EQ 'Linux' THEN GOTO L1782591 ; -SET &&REP_FILE = ('../'||&REP_NAME); -L1782591
-* Linux Migration End Change -* -*---------------------* Initialize parameters *-----------------------* -* -SET &REPCODE = 'ARPR-02-SUM'; -SET &REPNAME = 'P A Y M E N T R E C E I P T S U M M A R Y R E P O R T'; -* -&& -*-----------------* Connect to the Oracle database *------------------* -* EX apcon -RUN -IF &FOCERRNUM NE 0 GOTO ERR; -* -*-------* Create file that contains decode for Payment Method *-------* -* DEFINE FILE M_PYMMTD -* PMDESC/A10 = ''''|METHOD_SHORT_DESC|''''; SPACE1/A2 = ' '; PYMETHOD/A4 = ''''|PYM_METHOD|''''; END -* TABLE FILE M_PYMMTD -* PRINT PYMETHOD SPACE1 PMDESC ON TABLE SAVE AS PMSAVE END -* -RUN -IF &FOCERRNUM NE 0 GOTO ERR; -* -*-----* Create file that contains decode for Payment Sub Method *-----* -* DEFINE FILE M_PYMSMT -* PSMDESC/A10 = ''''|PSM_SHRT_DESC|''''; SPACE1/A2 = ' '; PYMSMETH/A4 = ''''|PYM_SUB_METHOD|''''; END -* TABLE FILE M_PYMSMT -* PRINT PYMSMETH SPACE1 PSMDESC ON TABLE SAVE AS PSMSAVE END -* -RUN -IF &FOCERRNUM NE 0 GOTO ERR; -* -*----------------* Close the connection to the Database *-------------* -* EX dbdis -RUN -IF &FOCERRNUM NE 0 GOTO ERR; -* -*-----* Define report parameters, output file and page settings *-----* -* -SET &I=1; -SET &&APPARTXT.&I='File Name'; -SET &&APPARVAL.&I=&GET_FILE; -* FILEDEF OFFLINE DISK &&REP_FILE OFFLINE -INCLUDE gnrpdef.fex -* -*-----------------------* Define input file *-------------------------* -* FILEDEF arphpp_r DISK &DATA_FILE ( LRECL 2100 RECFM F -RUN -* -*-----------------------* Field definitions *-------------------------* DEFINE FILE ARPHPP_R -* PM_DCOD/A8=DECODE PYM_METH(PMSAVE); PYMMETH/A11=IF PYM_METH EQ ' ' THEN ' ' ELSE PYM_METH||'-'||PM_DCOD; -* PSM_DCOD/A8=DECODE SUB_METH(PSMSAVE); PYMSMTHD/A11=IF SUB_METH EQ ' ' THEN ' ' ELSE SUB_METH||'-'||PSM_DCOD; -* LINENO/I6C WITH REC_BAN = 1; ROWID/A1 = ' '; -* DESIGTYPE/A12=IF DES_TYPE EQ 'D' THEN 'D - Deposit' ELSE IF DES_TYPE EQ 'B' THEN 'B - Billing' ELSE 'None';
SOU_EX/A9 =SOU_TYPE|SOU_ID ; NMKT_CODE/A4 =MKT_CODE; NDESIGTYPE/A12 =DESIGTYPE; NPYMMETH/A11=PYMMETH; NPYMSMTHD/A11=PYMSMTHD ; -* END -* -*------------------* Check status of DEFINE section *-----------------* -* -RUN -IF &FOCERRNUM NE 0 GOTO ERR; -* -*-----------------------* Report definition *-------------------------* TABLE FILE ARPHPP_R -* -*-----------------------* Page heading lines *------------------------* HEADING -* -INCLUDE gnrphdr.fex -* " " "<44 File Source: File Seq #: " " " -* "Market <12 Payment-Type Method Sub Method Total Amount <+4 Number of " "<68 Payments" "----------------------------------------------------------------- <+0 --------------" SUM SOU_EX NOPRINT FST.SEQ_NO NOPRINT NMKT_CODE NOPRINT NDESIGTYPE NOPRINT NPYMMETH NOPRINT NPYMSMTHD NOPRINT
PYM_AMT AS '' IN 49 LINENO AS '' IN 62 BY ROWID NOPRINT BY MKT_CODE AS '' IN 4 BY DESIGTYPE AS '' IN 12 BY PYMMETH AS '' IN 26 BY PYMSMTHD AS '' IN 39 -*