Schedule a program every 2 weeks
Hi All,
Well I have developed a Concurrent program which takes "FROM DATE" and "TO DATE " as inputs and generate XML file with Payments made between that Period.
However I want to schedule this Job for every 15 days . Not sure how this can be scheduled or if i need to make changes in the program. Please suggest
Below is the pick criteria i use to
PROCEDURE XXPQ_MX_PYMT_INV_DETAIL (P_FROM_DATE IN DATE, P_TO_DATE IN DATE, p_err_flag OUT VARCHAR2, p_err_msg OUT VARCHAR2) AS CURSOR C_MX_PYMT IS SELECT ARPS.TRX_NUMBER, ARPS.TRX_DATE, ARPS.CREATION_DATE, ARPS.LAST_UPDATE_DATE, EDIP.COUNTRY FROM APPS.AR_PAYMENT_SCHEDULES_ALL ARPS, PQINF.XXPQ_EDI_IP_INV_PICK EDIP --PQINF.XXPQ_EDI_MX_PAYMENT_DETAILS MXPD WHERE ARPS.TRX_NUMBER = EDIP.INVOICE_NUMBER AND EDIP.COUNTRY = 'MX' AND EDIP.INVOICE_NUMBER NOT IN (SELECT INVOICE_NUMBER FROM PQINF.XXPQ_EDI_MX_PAYMENT_DETAILS) AND EDIP.PROCESS_FLAG='Y' AND ARPS.AMOUNT_DUE_ORIGINAL <> ARPS.AMOUNT_DUE_REMAINING AND TRUNC (ARPS.LAST_UPDATE_DATE) BETWEEN P_FROM_DATE AND P_TO_DATE;