eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_APPROVAL_PKG

Line 18: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

14: p_line_location_id IN NUMBER,
15: p_match_option IN VARCHAR2,
16: p_rcv_transaction_id IN NUMBER,
17: p_system_user IN NUMBER,
18: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
19: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
20: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
21: p_calling_sequence IN VARCHAR2);
22:

Line 19: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

15: p_match_option IN VARCHAR2,
16: p_rcv_transaction_id IN NUMBER,
17: p_system_user IN NUMBER,
18: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
19: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
20: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
21: p_calling_sequence IN VARCHAR2);
22:
23: PROCEDURE Calc_Shipment_Qty_Billed(

Line 20: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

16: p_rcv_transaction_id IN NUMBER,
17: p_system_user IN NUMBER,
18: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
19: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
20: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
21: p_calling_sequence IN VARCHAR2);
22:
23: PROCEDURE Calc_Shipment_Qty_Billed(
24: p_invoice_id IN NUMBER,

Line 70: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

66: p_invoice_currency_code IN VARCHAR2,
67: p_po_unit_price IN NUMBER,
68: p_price_tolerance IN NUMBER,
69: p_system_user IN NUMBER,
70: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
71: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
72: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
73: p_calling_sequence IN VARCHAR2);
74:

Line 71: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

67: p_po_unit_price IN NUMBER,
68: p_price_tolerance IN NUMBER,
69: p_system_user IN NUMBER,
70: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
71: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
72: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
73: p_calling_sequence IN VARCHAR2);
74:
75: PROCEDURE CHECK_AVERAGE_PRICE(

Line 72: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

68: p_price_tolerance IN NUMBER,
69: p_system_user IN NUMBER,
70: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
71: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
72: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
73: p_calling_sequence IN VARCHAR2);
74:
75: PROCEDURE CHECK_AVERAGE_PRICE(
76: p_invoice_id IN NUMBER,

Line 233: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

229: p_inv_currency_code IN VARCHAR2,
230: p_sys_xrate_gain_ccid IN NUMBER,
231: p_sys_xrate_loss_ccid IN NUMBER,
232: p_system_user IN NUMBER,
233: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
234: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
235: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
236: p_calling_sequence IN VARCHAR2) IS
237:

Line 234: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

230: p_sys_xrate_gain_ccid IN NUMBER,
231: p_sys_xrate_loss_ccid IN NUMBER,
232: p_system_user IN NUMBER,
233: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
234: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
235: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
236: p_calling_sequence IN VARCHAR2) IS
237:
238: -- Project LCM 7588322

Line 235: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

231: p_sys_xrate_loss_ccid IN NUMBER,
232: p_system_user IN NUMBER,
233: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
234: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
235: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
236: p_calling_sequence IN VARCHAR2) IS
237:
238: -- Project LCM 7588322
239: l_lcm_enabled VARCHAR2(1) := 'N';

Line 372: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

368:
369: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
370: p_calling_sequence;
371:
372: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
373: g_debug_mode := 'Y';
374: END IF;
375:
376: IF (g_debug_mode = 'Y') THEN

Line 1251: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

1247: END IF;
1248:
1249: /* Bug 5230770. We should not process any invalid acct holds since it
1250: does not make any sense with SLA
1251: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
1252: p_invoice_id,
1253: NULL,
1254: NULL,
1255: 'ERV ACCT INVALID',

Line 1400: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

1396:
1397: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
1398: p_calling_sequence;
1399:
1400: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
1401: g_debug_mode := 'Y';
1402: END IF;
1403:
1404: IF (g_debug_mode = 'Y') THEN

Line 1663: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

1659:
1660: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
1661: p_calling_sequence;
1662:
1663: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
1664: g_debug_mode := 'Y';
1665: END IF;
1666:
1667: IF (g_debug_mode = 'Y') THEN

Line 1870: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

1866: p_services_rate_amt_tolerance IN NUMBER,
1867: p_services_total_amt_tolerance IN NUMBER,
1868: p_system_user IN NUMBER,
1869: p_conc_flag IN VARCHAR2,
1870: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
1871: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1872: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1873: p_calling_sequence IN VARCHAR2) IS
1874:

Line 1871: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

1867: p_services_total_amt_tolerance IN NUMBER,
1868: p_system_user IN NUMBER,
1869: p_conc_flag IN VARCHAR2,
1870: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
1871: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1872: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1873: p_calling_sequence IN VARCHAR2) IS
1874:
1875: CURSOR Matched_Cur IS

Line 1872: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

1868: p_system_user IN NUMBER,
1869: p_conc_flag IN VARCHAR2,
1870: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
1871: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1872: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
1873: p_calling_sequence IN VARCHAR2) IS
1874:
1875: CURSOR Matched_Cur IS
1876: SELECT PLL.line_location_id,

Line 2095: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

2091:
2092: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
2093: p_calling_sequence;
2094:
2095: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
2096: g_debug_mode := 'Y';
2097: END IF;
2098:
2099: l_action := 'UPDATE_CLOSE_STATE';

Line 2276: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2272: IF (g_debug_mode = 'Y') THEN
2273: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2274: END IF;
2275:
2276: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2277: p_invoice_id,
2278: l_line_location_id,
2279: l_rcv_transaction_id,
2280: 'FINAL MATCHING',

Line 2309: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2305: IF (g_debug_mode = 'Y') THEN
2306: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2307: END IF;
2308:
2309: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2310: p_invoice_id,
2311: l_line_location_id,
2312: l_rcv_transaction_id,
2313: 'CURRENCY DIFFERENCE',

Line 2344: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2340: IF (g_debug_mode = 'Y') THEN
2341: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2342: END IF;
2343:
2344: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2345: p_invoice_id,
2346: l_line_location_id,
2347: l_rcv_transaction_id,
2348: 'PO NOT APPROVED',

Line 2419: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2415: IF (g_debug_mode = 'Y') THEN
2416: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2417: END IF;
2418:
2419: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2420: p_invoice_id,
2421: l_line_location_id,
2422: l_rcv_transaction_id,
2423: 'QTY ORD',

Line 2451: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2447: IF (g_debug_mode = 'Y') THEN
2448: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2449: END IF;
2450:
2451: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2452: p_invoice_id,
2453: l_line_location_id,
2454: l_rcv_transaction_id,
2455: 'MAX QTY ORD',

Line 2511: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2507: IF (g_debug_mode = 'Y') THEN
2508: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2509: END IF;
2510:
2511: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2512: p_invoice_id,
2513: l_line_location_id,
2514: l_rcv_transaction_id,
2515: 'QTY REC',

Line 2550: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2546: IF (g_debug_mode = 'Y') THEN
2547: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2548: END IF;
2549:
2550: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2551: p_invoice_id,
2552: l_line_location_id,
2553: l_rcv_transaction_id,
2554: 'MAX QTY REC',

Line 2615: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2611: IF (g_debug_mode = 'Y') THEN
2612: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2613: END IF;
2614:
2615: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2616: p_invoice_id,
2617: l_line_location_id,
2618: l_rcv_transaction_id,
2619: 'QUALITY',

Line 2665: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2661: IF (g_debug_mode = 'Y') THEN
2662: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2663: END IF;
2664:
2665: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2666: p_invoice_id,
2667: l_line_location_id,
2668: l_rcv_transaction_id,
2669: 'AMT ORD',

Line 2697: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2693: IF (g_debug_mode = 'Y') THEN
2694: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2695: END IF;
2696:
2697: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2698: p_invoice_id,
2699: l_line_location_id,
2700: l_rcv_transaction_id,
2701: 'MAX AMT ORD',

Line 2750: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2746: IF (g_debug_mode = 'Y') THEN
2747: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2748: END IF;
2749:
2750: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2751: p_invoice_id,
2752: l_line_location_id,
2753: l_rcv_transaction_id,
2754: 'AMT REC',

Line 2789: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2785: IF (g_debug_mode = 'Y') THEN
2786: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2787: END IF;
2788:
2789: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2790: p_invoice_id,
2791: l_line_location_id,
2792: l_rcv_transaction_id,
2793: 'MAX AMT REC',

Line 2866: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2862: IF (g_debug_mode = 'Y') THEN
2863: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2864: END IF;
2865:
2866: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2867: p_invoice_id,
2868: l_line_location_id,
2869: l_rcv_transaction_id,
2870: 'MILESTONE',

Line 2929: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2925: IF (g_debug_mode = 'Y') THEN
2926: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2927: END IF;
2928:
2929: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2930: p_invoice_id,
2931: l_line_location_id,
2932: l_rcv_transaction_id,
2933: 'QTY REC',

Line 2984: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2980: IF (g_debug_mode = 'Y') THEN
2981: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
2982: END IF;
2983:
2984: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2985: p_invoice_id,
2986: l_line_location_id,
2987: l_rcv_transaction_id,
2988: 'MILESTONE',

Line 3040: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3036: IF (g_debug_mode = 'Y') THEN
3037: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
3038: END IF;
3039:
3040: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3041: p_invoice_id,
3042: l_line_location_id,
3043: l_rcv_transaction_id,
3044: 'AMT REC',

Line 3148: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3144: IF (g_debug_mode = 'Y') THEN
3145: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
3146: END IF;
3147:
3148: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3149: p_invoice_id,
3150: l_line_location_id,
3151: l_rcv_transaction_id,
3152: 'MAX SHIP AMOUNT',

Line 3204: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3200: IF (g_debug_mode = 'Y') THEN
3201: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
3202: END IF;
3203:
3204: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3205: p_invoice_id,
3206: l_line_location_id,
3207: l_rcv_transaction_id,
3208: 'MAX RATE AMOUNT',

Line 3265: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3261: IF (g_debug_mode = 'Y') THEN
3262: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
3263: END IF;
3264:
3265: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3266: p_invoice_id,
3267: l_line_location_id,
3268: l_rcv_transaction_id,
3269: 'MAX TOTAL AMOUNT',

Line 3633: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

3629: PROCEDURE Exec_PO_Final_Close(
3630: p_invoice_id IN NUMBER,
3631: p_system_user IN NUMBER,
3632: p_conc_flag IN VARCHAR2,
3633: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
3634: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
3635: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
3636: p_calling_sequence IN VARCHAR2) IS
3637:

Line 3634: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

3630: p_invoice_id IN NUMBER,
3631: p_system_user IN NUMBER,
3632: p_conc_flag IN VARCHAR2,
3633: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
3634: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
3635: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
3636: p_calling_sequence IN VARCHAR2) IS
3637:
3638: /*-----------------------------------------------------------------+

Line 3635: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

3631: p_system_user IN NUMBER,
3632: p_conc_flag IN VARCHAR2,
3633: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
3634: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
3635: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
3636: p_calling_sequence IN VARCHAR2) IS
3637:
3638: /*-----------------------------------------------------------------+
3639: | 1. Select each 'CANT CLOSE PO' hold associated with |

Line 3759: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

3755:
3756: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
3757: p_calling_sequence;
3758:
3759: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
3760: g_debug_mode := 'Y';
3761: END IF;
3762:
3763: l_cant_try_po_close_exists := 'N';

Line 3791: AP_APPROVAL_PKG.Release_Hold(

3787:
3788: -------------------------------------------------------------------------
3789: -- Release 'CANT PO CLOSE' or 'CANT TRY PO CLOSE' hold for this match --
3790: -------------------------------------------------------------------------
3791: AP_APPROVAL_PKG.Release_Hold(
3792: p_invoice_id,
3793: l_line_location_id,
3794: '', -- rcv_transaction_id
3795: l_hold_code,

Line 3995: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3991: IF (g_debug_mode = 'Y') THEN
3992: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
3993: END IF;
3994:
3995: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3996: p_invoice_id,
3997: l_line_location_id,
3998: null,
3999: 'CANT CLOSE PO',

Line 4032: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

4028: IF (g_debug_mode = 'Y') THEN
4029: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
4030: END IF;
4031:
4032: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
4033: p_invoice_id,
4034: null,
4035: null,
4036: 'CANT TRY PO CLOSE',

Line 4083: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

4079: p_line_location_id IN NUMBER,
4080: p_match_option IN VARCHAR2,
4081: p_rcv_transaction_id IN NUMBER,
4082: p_system_user IN NUMBER,
4083: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4084: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4085: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4086: p_calling_sequence IN VARCHAR2) IS
4087:

Line 4084: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4080: p_match_option IN VARCHAR2,
4081: p_rcv_transaction_id IN NUMBER,
4082: p_system_user IN NUMBER,
4083: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4084: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4085: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4086: p_calling_sequence IN VARCHAR2) IS
4087:
4088: l_rec_exception_exists VARCHAR2(1) := 'N';

Line 4085: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4081: p_rcv_transaction_id IN NUMBER,
4082: p_system_user IN NUMBER,
4083: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4084: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4085: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4086: p_calling_sequence IN VARCHAR2) IS
4087:
4088: l_rec_exception_exists VARCHAR2(1) := 'N';
4089: l_rec_exception_count NUMBER := 0;

Line 4148: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

4144: l_debug_info := 'Process Invoice Hold Status for REC EXCEPTION';
4145: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info);
4146: END IF;
4147:
4148: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
4149: p_invoice_id,
4150: p_line_location_id,
4151: p_rcv_transaction_id,
4152: 'REC EXCEPTION',

Line 4209: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

4205: p_invoice_currency_code IN VARCHAR2,
4206: p_po_unit_price IN NUMBER,
4207: p_price_tolerance IN NUMBER,
4208: p_system_user IN NUMBER,
4209: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4210: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4211: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4212: p_calling_sequence IN VARCHAR2) IS
4213:

Line 4210: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4206: p_po_unit_price IN NUMBER,
4207: p_price_tolerance IN NUMBER,
4208: p_system_user IN NUMBER,
4209: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4210: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4211: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4212: p_calling_sequence IN VARCHAR2) IS
4213:
4214:

Line 4211: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4207: p_price_tolerance IN NUMBER,
4208: p_system_user IN NUMBER,
4209: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4210: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4211: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4212: p_calling_sequence IN VARCHAR2) IS
4213:
4214:
4215: l_price_error_exists VARCHAR2(1):='N';

Line 4339: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

4335: IF (g_debug_mode = 'Y') THEN
4336: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
4337: END IF;
4338:
4339: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
4340: p_invoice_id,
4341: p_line_location_id,
4342: p_rcv_transaction_id,
4343: 'PRICE',

Line 5851: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,

5847:
5848: -- 7299826 EnC Project
5849: PROCEDURE exec_pay_when_paid_check(p_invoice_id IN NUMBER,
5850: p_system_user IN NUMBER,
5851: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
5852: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5853: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5854: p_calling_sequence IN VARCHAR2) IS
5855:

Line 5852: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,

5848: -- 7299826 EnC Project
5849: PROCEDURE exec_pay_when_paid_check(p_invoice_id IN NUMBER,
5850: p_system_user IN NUMBER,
5851: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
5852: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5853: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5854: p_calling_sequence IN VARCHAR2) IS
5855:
5856: l_debug_loc VARCHAR2(30) := 'exec_pay_when_paid_check';

Line 5853: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,

5849: PROCEDURE exec_pay_when_paid_check(p_invoice_id IN NUMBER,
5850: p_system_user IN NUMBER,
5851: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
5852: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5853: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5854: p_calling_sequence IN VARCHAR2) IS
5855:
5856: l_debug_loc VARCHAR2(30) := 'exec_pay_when_paid_check';
5857: l_curr_calling_sequence VARCHAR2(2000);

Line 5898: AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,

5894: END LOOP;
5895:
5896: Print_Debug(l_debug_loc, 'pay when paid hold required for invoice id : '||p_invoice_id||' - '||l_hold_required );
5897:
5898: AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,
5899: NULL,
5900: NULL,
5901: 'Pay When Paid',
5902: l_hold_required,

Line 5929: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,

5925:
5926: -- 7299826 EnC Project
5927: PROCEDURE exec_po_deliverable_check(p_invoice_id IN NUMBER,
5928: p_system_user IN NUMBER,
5929: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
5930: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5931: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5932: p_calling_sequence IN VARCHAR2
5933: ) IS

Line 5930: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,

5926: -- 7299826 EnC Project
5927: PROCEDURE exec_po_deliverable_check(p_invoice_id IN NUMBER,
5928: p_system_user IN NUMBER,
5929: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
5930: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5931: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5932: p_calling_sequence IN VARCHAR2
5933: ) IS
5934:

Line 5931: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,

5927: PROCEDURE exec_po_deliverable_check(p_invoice_id IN NUMBER,
5928: p_system_user IN NUMBER,
5929: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
5930: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5931: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
5932: p_calling_sequence IN VARCHAR2
5933: ) IS
5934:
5935: l_debug_loc VARCHAR2(30) := 'exec_po_deliverable_check';

Line 5977: AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,

5973: END LOOP;
5974:
5975: Print_Debug(l_debug_loc, 'po deliverable hold required for invoice id : '||p_invoice_id||' - '||l_hold_required );
5976:
5977: AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,
5978: NULL,
5979: NULL,
5980: 'PO Deliverable',
5981: l_hold_required,

Line 6011: IF AP_APPROVAL_PKG.g_debug_mode = 'Y' THEN

6007: p_api_name IN VARCHAR2,
6008: p_debug_info IN VARCHAR2) IS
6009: BEGIN
6010:
6011: IF AP_APPROVAL_PKG.g_debug_mode = 'Y' THEN
6012: AP_Debug_Pkg.Print('Y', p_debug_info );
6013: END IF;
6014:
6015: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN