DBA Data[Home] [Help]

APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_APPROVAL_PKG

Line 294: AP_APPROVAL_PKG.Get_Hold_Status(

290: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||
291: l_procedure_name, l_log_msg);
292: END IF;
293:
294: AP_APPROVAL_PKG.Get_Hold_Status(
295: p_invoice_id,
296: null,
297: null,
298: 'INSUFFICIENT FUNDS',

Line 566: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

562: p_set_of_books_id IN NUMBER,
563: p_base_currency_code IN VARCHAR2,
564: p_conc_flag IN VARCHAR2,
565: p_system_user IN NUMBER,
566: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
567: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
568: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
569: p_funds_return_code OUT NOCOPY VARCHAR2, -- 4276409 (3462325)
570: p_calling_sequence IN VARCHAR2) IS

Line 567: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

563: p_base_currency_code IN VARCHAR2,
564: p_conc_flag IN VARCHAR2,
565: p_system_user IN NUMBER,
566: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
567: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
568: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
569: p_funds_return_code OUT NOCOPY VARCHAR2, -- 4276409 (3462325)
570: p_calling_sequence IN VARCHAR2) IS
571:

Line 568: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

564: p_conc_flag IN VARCHAR2,
565: p_system_user IN NUMBER,
566: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
567: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
568: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
569: p_funds_return_code OUT NOCOPY VARCHAR2, -- 4276409 (3462325)
570: p_calling_sequence IN VARCHAR2) IS
571:
572:

Line 1247: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

1243: l_procedure_name, l_log_msg);
1244: END IF;
1245:
1246:
1247: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
1248: p_invoice_id,
1249: null,
1250: null,
1251: 'INSUFFICIENT FUNDS',

Line 1271: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

1267: l_procedure_name, l_log_msg);
1268: END IF;
1269:
1270:
1271: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
1272: p_invoice_id,
1273: null,
1274: null,
1275: 'CANT FUNDS CHECK',

Line 2921: l_holds AP_APPROVAL_PKG.HOLDSARRAY;

2917: l_result NUMBER;
2918: l_success BOOLEAN := TRUE;
2919: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
2920: i NUMBER;
2921: l_holds AP_APPROVAL_PKG.HOLDSARRAY;
2922: l_hold_count AP_APPROVAL_PKG.COUNTARRAY;
2923: l_release_count AP_APPROVAL_PKG.COUNTARRAY;
2924: l_system_user NUMBER := 5;
2925: l_chart_of_accounts_id NUMBER;

Line 2922: l_hold_count AP_APPROVAL_PKG.COUNTARRAY;

2918: l_success BOOLEAN := TRUE;
2919: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
2920: i NUMBER;
2921: l_holds AP_APPROVAL_PKG.HOLDSARRAY;
2922: l_hold_count AP_APPROVAL_PKG.COUNTARRAY;
2923: l_release_count AP_APPROVAL_PKG.COUNTARRAY;
2924: l_system_user NUMBER := 5;
2925: l_chart_of_accounts_id NUMBER;
2926: l_auto_offsets_flag VARCHAR2(1);

Line 2923: l_release_count AP_APPROVAL_PKG.COUNTARRAY;

2919: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
2920: i NUMBER;
2921: l_holds AP_APPROVAL_PKG.HOLDSARRAY;
2922: l_hold_count AP_APPROVAL_PKG.COUNTARRAY;
2923: l_release_count AP_APPROVAL_PKG.COUNTARRAY;
2924: l_system_user NUMBER := 5;
2925: l_chart_of_accounts_id NUMBER;
2926: l_auto_offsets_flag VARCHAR2(1);
2927: l_sys_xrate_gain_ccid NUMBER;

Line 3038: AP_Approval_Pkg.Check_Insufficient_Line_Data(

3034:
3035: IF ( t_inv_lines_table(i).line_type_lookup_code <> 'TAX' AND
3036: t_inv_lines_table(i).generate_dists = 'Y' ) THEN
3037:
3038: AP_Approval_Pkg.Check_Insufficient_Line_Data(
3039: p_inv_line_rec => t_inv_lines_table(i),
3040: p_system_user => l_system_user,
3041: p_holds => l_holds,
3042: p_holds_count => l_hold_count,

Line 3050: l_success := AP_Approval_Pkg.Execute_Dist_Generation_Check(

3046: p_calling_sequence => l_curr_calling_sequence );
3047:
3048: IF ( NOT l_insufficient_data_exist ) THEN
3049:
3050: l_success := AP_Approval_Pkg.Execute_Dist_Generation_Check(
3051: p_batch_id => l_batch_id,
3052: p_invoice_date => l_invoice_date,
3053: p_vendor_id => l_vendor_id,
3054: p_invoice_currency => l_invoice_currency_code,