APPS.AP_PA_API_PKG dependencies on AP_PA_API_PKG

Line 1: PACKAGE BODY AP_PA_API_PKG AS

1: PACKAGE BODY AP_PA_API_PKG AS
2: /* $Header: appaapib.pls 120.11.12020000.2 2012/11/28 10:47:01 mkmeda ship $ */
3:
4: -----------------------------------------------------------------------
5: -- Function get_org_id returns the org_id that the invoice belongs to.

Line 145: WHERE nvl(ap_system_parameters_all.org_id,-999) = nvl(AP_PA_API_PKG.get_org_id(X_Invoice_Id),-999)

141: var_payment_status_flag,
142: var_allow_paid_invoice_adjust,
143: var_invoice_type_lookup_code
144: FROM ap_invoices_all, ap_system_parameters_all
145: WHERE nvl(ap_system_parameters_all.org_id,-999) = nvl(AP_PA_API_PKG.get_org_id(X_Invoice_Id),-999)
146: AND invoice_id = X_Invoice_Id;
147:
148: SELECT count(*)
149: INTO accrue_on_receipt_num

Line 184: (AP_PA_API_PKG.get_payments_exist_flag(X_invoice_Id) = 'Y') THEN

180: var_invoice_type_lookup_code = 'PREPAYMENT' THEN
181: return('PA_INV_PREPAY');
182:
183: Elsif (var_payment_status_flag in ('Y','P')) AND
184: (AP_PA_API_PKG.get_payments_exist_flag(X_invoice_Id) = 'Y') THEN
185: return('PA_INV_AUTO_OFFSETS_PAID');
186:
187: Elsif Selected_for_Payment_Flag(X_invoice_Id) = 'Y' THEN
188: return('PA_INV_SEL_PAYMENT');

Line 307: END AP_PA_API_PKG;

303: p_base_amount_variance := 0;
304:
305: END Get_Inv_Amount_Var;
306:
307: END AP_PA_API_PKG;