DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on AP_INVOICES_PKG

Line 883: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;

879: l_invoice_date AP_INVOICES.invoice_date%TYPE;
880: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
881: l_invoice_type AP_INVOICES.invoice_type_lookup_code%TYPE;
882:
883: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
884:
885: l_insufficient_data_exist BOOLEAN := FALSE;
886: l_line_variance_hold_exist BOOLEAN := FALSE;
887: l_need_to_round_flag VARCHAR2(1) := 'Y';

Line 3063: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

3059: |
3060: *============================================================================*/
3061:
3062: PROCEDURE Check_Insufficient_Line_Data(
3063: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
3064: p_system_user IN NUMBER,
3065: p_holds IN OUT NOCOPY HOLDSARRAY,
3066: p_holds_count IN OUT NOCOPY COUNTARRAY,
3067: p_release_count IN OUT NOCOPY COUNTARRAY,

Line 3227: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

3223: p_invoice_currency IN VARCHAR2,
3224: p_exchange_rate IN NUMBER,
3225: p_exchange_rate_type IN VARCHAR2,
3226: p_exchange_date IN DATE,
3227: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
3228: p_system_user IN NUMBER,
3229: p_holds IN OUT NOCOPY HOLDSARRAY,
3230: p_holds_count IN OUT NOCOPY COUNTARRAY,
3231: p_release_count IN OUT NOCOPY COUNTARRAY,

Line 7528: SELECT AP_INVOICES_PKG.Get_Holds_Count(invoice_id),

7524: p_approval_status IN OUT NOCOPY VARCHAR2,
7525: p_calling_sequence IN VARCHAR2) IS
7526:
7527: CURSOR Invoice_Status_Cur IS
7528: SELECT AP_INVOICES_PKG.Get_Holds_Count(invoice_id),
7529: AP_INVOICES_PKG.Get_Approval_Status(
7530: invoice_id,
7531: invoice_amount,
7532: payment_status_flag,

Line 7529: AP_INVOICES_PKG.Get_Approval_Status(

7525: p_calling_sequence IN VARCHAR2) IS
7526:
7527: CURSOR Invoice_Status_Cur IS
7528: SELECT AP_INVOICES_PKG.Get_Holds_Count(invoice_id),
7529: AP_INVOICES_PKG.Get_Approval_Status(
7530: invoice_id,
7531: invoice_amount,
7532: payment_status_flag,
7533: invoice_type_lookup_code)

Line 8754: P_Invoice_Line_Rec IN AP_INVOICES_PKG.r_invoice_line_rec,

8750:
8751:
8752: FUNCTION Gen_Dists_From_Registration(
8753: P_Batch_Id IN NUMBER,
8754: P_Invoice_Line_Rec IN AP_INVOICES_PKG.r_invoice_line_rec,
8755: P_Registration_Api IN VARCHAR2,
8756: P_Registration_View IN VARCHAR2,
8757: P_Generate_Permanent IN VARCHAR2,
8758: X_Error_Code OUT NOCOPY VARCHAR2,

Line 9344: SELECT AP_INVOICES_PKG.Get_Approval_Status(

9340: -- bug 9304530 - start
9341: l_invoice_approval_status VARCHAR2(25);
9342:
9343: CURSOR Invoice_Status_Cursor(p_invoice_id NUMBER) IS
9344: SELECT AP_INVOICES_PKG.Get_Approval_Status(
9345: invoice_id,
9346: invoice_amount,
9347: payment_status_flag,
9348: invoice_type_lookup_code)

Line 11439: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;

11435: p_calling_sequence IN VARCHAR2,
11436: x_error_code IN VARCHAR2,
11437: p_calling_mode IN VARCHAR2 ) IS /*bug 6833543 - added p_calling_mode*/
11438:
11439: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
11440:
11441: l_curr_calling_sequence VARCHAR2(2000);
11442: l_debug_info VARCHAR2(2000);
11443: l_debug_loc VARCHAR2(30) := 'Generate_Distributions';

Line 12180: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;

12176: p_calling_sequence IN VARCHAR2,
12177: x_error_code IN VARCHAR2,
12178: p_calling_mode IN VARCHAR2 ) IS
12179:
12180: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
12181:
12182: l_curr_calling_sequence VARCHAR2(2000);
12183: l_debug_info VARCHAR2(2000);
12184: l_debug_loc VARCHAR2(30) := 'Generate_Distributions';