223: ,TRANS_ID IN NUMBER) RETURN DATE IS
224: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;
225: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;
226: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;
227: V_CHECK_ID AP_CHECKS.CHECK_ID%TYPE;
228: V_CHECK_DATE AP_CHECKS.CHECK_DATE%TYPE;
229: V_CHECK_NUMBER AP_CHECKS.CHECK_NUMBER%TYPE;
230: V_TRANS_TYPE VARCHAR2(25);
231: CURSOR C_INV_REL_AWT IS
224: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;
225: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;
226: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;
227: V_CHECK_ID AP_CHECKS.CHECK_ID%TYPE;
228: V_CHECK_DATE AP_CHECKS.CHECK_DATE%TYPE;
229: V_CHECK_NUMBER AP_CHECKS.CHECK_NUMBER%TYPE;
230: V_TRANS_TYPE VARCHAR2(25);
231: CURSOR C_INV_REL_AWT IS
232: SELECT
225: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;
226: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;
227: V_CHECK_ID AP_CHECKS.CHECK_ID%TYPE;
228: V_CHECK_DATE AP_CHECKS.CHECK_DATE%TYPE;
229: V_CHECK_NUMBER AP_CHECKS.CHECK_NUMBER%TYPE;
230: V_TRANS_TYPE VARCHAR2(25);
231: CURSOR C_INV_REL_AWT IS
232: SELECT
233: INVOICE_DATE,
239: SELECT
240: CHECK_DATE,
241: CHECK_NUMBER
242: FROM
243: AP_CHECKS_ALL
244: WHERE CHECK_ID = V_CHECK_ID;
245: BEGIN
246: IF TRANS_TYPE = 'AWT' THEN
247: IF CP_CREATE_AWT_DISTS_TYPE = 'PAYMENT' THEN
623: IF P_COUNTRY_CODE = 'CL' AND P_CA_SET_OF_BOOKS_ID IS NOT NULL THEN
624: CP_SOB_ID := P_CA_SET_OF_BOOKS_ID;
625: END IF;
626: IF P_REPORTING_LEVEL = '2000' THEN
627: LP_AP_CHECKS_WH := 'AND ac.legal_entity_id = ' || P_REPORTING_CONTEXT;
628: LP_AP_INVOICES_WH := 'AND ai.legal_entity_id = ' || P_REPORTING_CONTEXT;
629: ELSE
630: /*SRW.MESSAGE('124'
631: ,' Not 2000')*/NULL;
634: ,'AUTO');
635: LP_AP_INVOICE_DISTRIBUTIONS_WH := FND_MO_REPORTING_API.GET_PREDICATE('DIS'
636: ,NULL
637: ,P_REPORTING_CONTEXT);
638: LP_AP_CHECKS_WH := FND_MO_REPORTING_API.GET_PREDICATE('AC'
639: ,NULL
640: ,P_REPORTING_CONTEXT);
641: LP_AP_INVOICES_WH := FND_MO_REPORTING_API.GET_PREDICATE('AI'
642: ,NULL