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_PKG dependencies on AP_HOLDS_ALL

Line 624: hold_lookup_code ap_holds_all.hold_lookup_code%type,

620: p_invoice_id IN NUMBER,
621: p_calling_sequence IN VARCHAR2);
622:
623: TYPE holds_rec_type IS RECORD (
624: hold_lookup_code ap_holds_all.hold_lookup_code%type,
625: hold_status varchar2(30),
626: invoice_id ap_holds_all.invoice_id%type,
627: hold_reason ap_holds_all.hold_reason%type,
628: release_lookup_code ap_holds_all.release_lookup_code%type,

Line 626: invoice_id ap_holds_all.invoice_id%type,

622:
623: TYPE holds_rec_type IS RECORD (
624: hold_lookup_code ap_holds_all.hold_lookup_code%type,
625: hold_status varchar2(30),
626: invoice_id ap_holds_all.invoice_id%type,
627: hold_reason ap_holds_all.hold_reason%type,
628: release_lookup_code ap_holds_all.release_lookup_code%type,
629: line_location_id ap_holds_all.line_location_id%type,
630: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,

Line 627: hold_reason ap_holds_all.hold_reason%type,

623: TYPE holds_rec_type IS RECORD (
624: hold_lookup_code ap_holds_all.hold_lookup_code%type,
625: hold_status varchar2(30),
626: invoice_id ap_holds_all.invoice_id%type,
627: hold_reason ap_holds_all.hold_reason%type,
628: release_lookup_code ap_holds_all.release_lookup_code%type,
629: line_location_id ap_holds_all.line_location_id%type,
630: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
631: last_updated_by ap_holds_all.last_updated_by%type,

Line 628: release_lookup_code ap_holds_all.release_lookup_code%type,

624: hold_lookup_code ap_holds_all.hold_lookup_code%type,
625: hold_status varchar2(30),
626: invoice_id ap_holds_all.invoice_id%type,
627: hold_reason ap_holds_all.hold_reason%type,
628: release_lookup_code ap_holds_all.release_lookup_code%type,
629: line_location_id ap_holds_all.line_location_id%type,
630: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
631: last_updated_by ap_holds_all.last_updated_by%type,
632: responsibility_id ap_holds_all.responsibility_id%type);

Line 629: line_location_id ap_holds_all.line_location_id%type,

625: hold_status varchar2(30),
626: invoice_id ap_holds_all.invoice_id%type,
627: hold_reason ap_holds_all.hold_reason%type,
628: release_lookup_code ap_holds_all.release_lookup_code%type,
629: line_location_id ap_holds_all.line_location_id%type,
630: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
631: last_updated_by ap_holds_all.last_updated_by%type,
632: responsibility_id ap_holds_all.responsibility_id%type);
633:

Line 630: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,

626: invoice_id ap_holds_all.invoice_id%type,
627: hold_reason ap_holds_all.hold_reason%type,
628: release_lookup_code ap_holds_all.release_lookup_code%type,
629: line_location_id ap_holds_all.line_location_id%type,
630: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
631: last_updated_by ap_holds_all.last_updated_by%type,
632: responsibility_id ap_holds_all.responsibility_id%type);
633:
634: TYPE holds_tab_type IS TABLE OF holds_rec_type INDEX BY BINARY_INTEGER;

Line 631: last_updated_by ap_holds_all.last_updated_by%type,

627: hold_reason ap_holds_all.hold_reason%type,
628: release_lookup_code ap_holds_all.release_lookup_code%type,
629: line_location_id ap_holds_all.line_location_id%type,
630: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
631: last_updated_by ap_holds_all.last_updated_by%type,
632: responsibility_id ap_holds_all.responsibility_id%type);
633:
634: TYPE holds_tab_type IS TABLE OF holds_rec_type INDEX BY BINARY_INTEGER;
635:

Line 632: responsibility_id ap_holds_all.responsibility_id%type);

628: release_lookup_code ap_holds_all.release_lookup_code%type,
629: line_location_id ap_holds_all.line_location_id%type,
630: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
631: last_updated_by ap_holds_all.last_updated_by%type,
632: responsibility_id ap_holds_all.responsibility_id%type);
633:
634: TYPE holds_tab_type IS TABLE OF holds_rec_type INDEX BY BINARY_INTEGER;
635:
636: g_holds_tab holds_tab_type;

Line 3646: FROM ap_holds_all

3642: IF ( p_inv_line_rec.distribution_set_id is not null) THEN
3643:
3644: SELECT hold_lookup_code
3645: INTO l_hold_code
3646: FROM ap_holds_all
3647: WHERE invoice_id = p_inv_line_rec.invoice_id
3648: AND hold_lookup_code in ('DISTRIBUTION SET INACTIVE','SKELETON DISTRIBUTION SET',
3649: 'CANNOT OVERLAY ACCOUNT','INVALID DEFAULT ACCOUNT')
3650: AND release_lookup_code IS NULL;

Line 3657: FROM ap_holds_all

3653: l_alloc_rule_type is not null ) THEN
3654:
3655: SELECT hold_lookup_code
3656: INTO l_hold_code
3657: FROM ap_holds_all
3658: WHERE invoice_id = p_inv_line_rec.invoice_id
3659: AND hold_lookup_code = 'CANNOT EXECUTE ALLOCATION'
3660: AND release_lookup_code IS NULL;
3661:

Line 3666: FROM ap_holds_all

3662: ELSE
3663:
3664: SELECT hold_lookup_code
3665: INTO l_hold_code
3666: FROM ap_holds_all
3667: WHERE invoice_id = p_inv_line_rec.invoice_id
3668: AND hold_lookup_code in ('CANNOT OVERLAY ACCOUNT','INVALID DEFAULT ACCOUNT',
3669: 'PERIOD CLOSED','PROJECT GL DATE CLOSED')
3670: AND release_lookup_code IS NULL;

Line 6878: l_old_wf_status AP_HOLDS_ALL.WF_STATUS%TYPE ; -- Bug 8323412

6874: l_release_lookup_code VARCHAR2(30);
6875: l_debug_loc VARCHAR2(30) := 'Release_Hold';
6876: l_curr_calling_sequence VARCHAR2(2000);
6877: l_debug_info VARCHAR2(1000);
6878: l_old_wf_status AP_HOLDS_ALL.WF_STATUS%TYPE ; -- Bug 8323412
6879: l_hold_id AP_HOLDS_ALL.HOLD_ID%TYPE ; -- Bug 8323412
6880: BEGIN
6881:
6882: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||

Line 6879: l_hold_id AP_HOLDS_ALL.HOLD_ID%TYPE ; -- Bug 8323412

6875: l_debug_loc VARCHAR2(30) := 'Release_Hold';
6876: l_curr_calling_sequence VARCHAR2(2000);
6877: l_debug_info VARCHAR2(1000);
6878: l_old_wf_status AP_HOLDS_ALL.WF_STATUS%TYPE ; -- Bug 8323412
6879: l_hold_id AP_HOLDS_ALL.HOLD_ID%TYPE ; -- Bug 8323412
6880: BEGIN
6881:
6882: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
6883: p_calling_sequence;

Line 9834: FROM AP_HOLDS_ALL H

9830: AND D2.CANCELLATION_FLAG = ''Y''
9831: )
9832: UNION ALL
9833: SELECT 1
9834: FROM AP_HOLDS_ALL H
9835: WHERE H.INVOICE_ID = AI.INVOICE_ID
9836: AND ((H.HOLD_LOOKUP_CODE IN
9837: (''QTY ORD'', ''QTY REC'', ''AMT ORD'', ''AMT REC'', ''QUALITY'',
9838: ''PRICE'', ''TAX DIFFERENCE'', ''CURRENCY DIFFERENCE'',

Line 11474: FROM ap_holds_all

11470: -- bug6783517 starts
11471: CURSOR dist_gen_holds(p_invoice_id NUMBER)
11472: IS
11473: SELECT hold_lookup_code
11474: FROM ap_holds_all
11475: WHERE hold_lookup_code IN ('DISTRIBUTION SET INACTIVE',
11476: 'SKELETON DISTRIBUTION SET',
11477: 'CANNOT OVERLAY ACCOUNT',
11478: 'INVALID DEFAULT ACCOUNT',

Line 11488: TABLE OF AP_HOLDS_ALL.HOLD_LOOKUP_CODE%TYPE

11484: AND release_lookup_code IS NULL
11485: AND invoice_id = p_invoice_id;
11486:
11487: TYPE holds_tab_type IS
11488: TABLE OF AP_HOLDS_ALL.HOLD_LOOKUP_CODE%TYPE
11489: INDEX BY BINARY_INTEGER;
11490:
11491: t_holds_tab holds_tab_type;
11492: -- bug6783517 ends

Line 11608: FROM ap_holds_all aha

11604: --Bug8820542 / 10295316
11605: BEGIN
11606: SELECT COUNT(1)
11607: INTO l_disc_chrge_line
11608: FROM ap_holds_all aha
11609: WHERE aha.invoice_id = p_invoice_rec.invoice_id
11610: AND aha.hold_lookup_code = 'CANNOT EXECUTE ALLOCATION'
11611: AND aha.release_lookup_code IS NULL
11612: AND NOT EXISTS ( SELECT 1

Line 12211: FROM ap_holds_all

12207:
12208: CURSOR dist_gen_holds(p_invoice_id NUMBER)
12209: IS
12210: SELECT hold_lookup_code
12211: FROM ap_holds_all
12212: WHERE hold_lookup_code IN ('DISTRIBUTION SET INACTIVE',
12213: 'SKELETON DISTRIBUTION SET',
12214: 'CANNOT OVERLAY ACCOUNT',
12215: 'INVALID DEFAULT ACCOUNT',

Line 12223: TABLE OF AP_HOLDS_ALL.HOLD_LOOKUP_CODE%TYPE

12219: AND release_lookup_code IS NULL
12220: AND invoice_id = p_invoice_id;
12221:
12222: TYPE holds_tab_type IS
12223: TABLE OF AP_HOLDS_ALL.HOLD_LOOKUP_CODE%TYPE
12224: INDEX BY BINARY_INTEGER;
12225:
12226: t_holds_tab holds_tab_type;
12227: