APPS.AP_APXIAWRE_XMLP_PKG dependencies on AP_INVOICES

Line 118: AP_INVOICES;

114: SELECT
115: count(*)
116: INTO A
117: FROM
118: AP_INVOICES;
119: /*SRW.MESSAGE('1'
120: ,'After SRWINIT' || A)*/NULL;
121: C_REPORT_START_DATE := SYSDATE;
122: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

Line 176: LP_APPROVAL_TIMING := ' AND AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID,

172: AP_SYSTEM_PARAMETERS;
173: /*SRW.MESSAGE('7'
174: ,'After check flag')*/NULL;
175: IF (P_APPROVAL_TIMING in ('VALIDATED','ACCOUNTED')) THEN
176: LP_APPROVAL_TIMING := ' AND AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID,
177: AI.INVOICE_AMOUNT,
178: AI.PAYMENT_STATUS_FLAG,
179: AI.INVOICE_TYPE_LOOKUP_CODE)
180: in ( ''APPROVED'',''UNPAID'')';

Line 183: LP_APPROVAL_TIMING := LP_APPROVAL_TIMING || ' AND AP_INVOICES_PKG.GET_Accounting_status(AI.INVOICE_ID) = ''ACCOUNTED''';

179: AI.INVOICE_TYPE_LOOKUP_CODE)
180: in ( ''APPROVED'',''UNPAID'')';
181: END IF;
182: IF (P_APPROVAL_TIMING = 'ACCOUNTED') THEN
183: LP_APPROVAL_TIMING := LP_APPROVAL_TIMING || ' AND AP_INVOICES_PKG.GET_Accounting_status(AI.INVOICE_ID) = ''ACCOUNTED''';
184: END IF;
185: IF P_VENDOR_ID IS NOT NULL THEN
186: SELECT
187: VENDOR_NAME

Line 250: AP_INVOICES

246: pragma autonomous_transaction;
247: BEGIN
248:
249: UPDATE
250: AP_INVOICES
251: SET
252: APPROVAL_ITERATION = NVL(C_ITERATION
253: ,0) + 1
254: ,WFAPPROVAL_STATUS = 'INITIATED'