APPS.AP_RETAINAGE_RELEASE_PKG dependencies on AP_INVOICES_ALL

Line 24: Cursor c_release_invoice_info (c_invoice_id IN ap_invoices_all.invoice_id%type) Is

20: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
21: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
22: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_RETAINAGE_RELEASE_PKG.';
23:
24: Cursor c_release_invoice_info (c_invoice_id IN ap_invoices_all.invoice_id%type) Is
25: Select ai.invoice_currency_code,
26: --Bug6893516 Exchange rate should be 1 for base currency invoices
27: nvl(ai.exchange_rate,1) exchange_rate,
28: ai.gl_date,

Line 32: From ap_invoices_all ai

28: ai.gl_date,
29: ai.vendor_id,
30: ai.vendor_site_id,
31: ai.org_id
32: From ap_invoices_all ai
33: Where invoice_id = c_invoice_id;
34:
35: g_release_invoice_info c_release_invoice_info%rowtype;
36: g_period_name gl_period_statuses.period_name%TYPE;

Line 50: Procedure create_release_lines (x_invoice_id IN ap_invoices_all.invoice_id%TYPE,

46:
47: Procedure Unlock_Retained_Invoices (x_retained_lines_tab IN retainedLinesType,
48: x_lock_status OUT NOCOPY BOOLEAN);
49:
50: Procedure create_release_lines (x_invoice_id IN ap_invoices_all.invoice_id%TYPE,
51: x_release_amount IN number,
52: x_release_amount_remaining IN number,
53: x_retained_lines_tab IN retainedLinesType,
54: x_released_lines_tab OUT NOCOPY releaseLinesType);

Line 73: PROCEDURE create_release (x_invoice_id IN ap_invoices_all.invoice_id%TYPE,

69:
70: --
71: -- Main Procedure
72: --
73: PROCEDURE create_release (x_invoice_id IN ap_invoices_all.invoice_id%TYPE,
74: x_release_shipments_tab IN release_shipments_tab) As
75:
76: released_lines_tab releaseLinesType;
77: l_retained_lines_locked boolean;

Line 215: Procedure create_release_lines (x_invoice_id IN ap_invoices_all.invoice_id%TYPE,

211: APP_EXCEPTION.RAISE_EXCEPTION;
212:
213: END create_release;
214:
215: Procedure create_release_lines (x_invoice_id IN ap_invoices_all.invoice_id%TYPE,
216: x_release_amount IN number,
217: x_release_amount_remaining IN number,
218: x_retained_lines_tab IN retainedLinesType,
219: x_released_lines_tab OUT NOCOPY releaseLinesType) As