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 447: hold_lookup_code ap_holds_all.hold_lookup_code%type,

443: p_invoice_id IN NUMBER,
444: p_calling_sequence IN VARCHAR2);
445:
446: TYPE holds_rec_type IS RECORD (
447: hold_lookup_code ap_holds_all.hold_lookup_code%type,
448: hold_status varchar2(30),
449: invoice_id ap_holds_all.invoice_id%type,
450: hold_reason ap_holds_all.hold_reason%type,
451: release_lookup_code ap_holds_all.release_lookup_code%type,

Line 449: invoice_id ap_holds_all.invoice_id%type,

445:
446: TYPE holds_rec_type IS RECORD (
447: hold_lookup_code ap_holds_all.hold_lookup_code%type,
448: hold_status varchar2(30),
449: invoice_id ap_holds_all.invoice_id%type,
450: hold_reason ap_holds_all.hold_reason%type,
451: release_lookup_code ap_holds_all.release_lookup_code%type,
452: line_location_id ap_holds_all.line_location_id%type,
453: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,

Line 450: hold_reason ap_holds_all.hold_reason%type,

446: TYPE holds_rec_type IS RECORD (
447: hold_lookup_code ap_holds_all.hold_lookup_code%type,
448: hold_status varchar2(30),
449: invoice_id ap_holds_all.invoice_id%type,
450: hold_reason ap_holds_all.hold_reason%type,
451: release_lookup_code ap_holds_all.release_lookup_code%type,
452: line_location_id ap_holds_all.line_location_id%type,
453: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
454: last_updated_by ap_holds_all.last_updated_by%type,

Line 451: release_lookup_code ap_holds_all.release_lookup_code%type,

447: hold_lookup_code ap_holds_all.hold_lookup_code%type,
448: hold_status varchar2(30),
449: invoice_id ap_holds_all.invoice_id%type,
450: hold_reason ap_holds_all.hold_reason%type,
451: release_lookup_code ap_holds_all.release_lookup_code%type,
452: line_location_id ap_holds_all.line_location_id%type,
453: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
454: last_updated_by ap_holds_all.last_updated_by%type,
455: responsibility_id ap_holds_all.responsibility_id%type);

Line 452: line_location_id ap_holds_all.line_location_id%type,

448: hold_status varchar2(30),
449: invoice_id ap_holds_all.invoice_id%type,
450: hold_reason ap_holds_all.hold_reason%type,
451: release_lookup_code ap_holds_all.release_lookup_code%type,
452: line_location_id ap_holds_all.line_location_id%type,
453: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
454: last_updated_by ap_holds_all.last_updated_by%type,
455: responsibility_id ap_holds_all.responsibility_id%type);
456:

Line 453: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,

449: invoice_id ap_holds_all.invoice_id%type,
450: hold_reason ap_holds_all.hold_reason%type,
451: release_lookup_code ap_holds_all.release_lookup_code%type,
452: line_location_id ap_holds_all.line_location_id%type,
453: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
454: last_updated_by ap_holds_all.last_updated_by%type,
455: responsibility_id ap_holds_all.responsibility_id%type);
456:
457: TYPE holds_tab_type IS TABLE OF holds_rec_type INDEX BY BINARY_INTEGER;

Line 454: last_updated_by ap_holds_all.last_updated_by%type,

450: hold_reason ap_holds_all.hold_reason%type,
451: release_lookup_code ap_holds_all.release_lookup_code%type,
452: line_location_id ap_holds_all.line_location_id%type,
453: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
454: last_updated_by ap_holds_all.last_updated_by%type,
455: responsibility_id ap_holds_all.responsibility_id%type);
456:
457: TYPE holds_tab_type IS TABLE OF holds_rec_type INDEX BY BINARY_INTEGER;
458:

Line 455: responsibility_id ap_holds_all.responsibility_id%type);

451: release_lookup_code ap_holds_all.release_lookup_code%type,
452: line_location_id ap_holds_all.line_location_id%type,
453: rcv_transaction_id ap_holds_all.rcv_transaction_id%type,
454: last_updated_by ap_holds_all.last_updated_by%type,
455: responsibility_id ap_holds_all.responsibility_id%type);
456:
457: TYPE holds_tab_type IS TABLE OF holds_rec_type INDEX BY BINARY_INTEGER;
458:
459: g_holds_tab holds_tab_type;

Line 2679: FROM ap_holds_all

2675: IF ( p_inv_line_rec.distribution_set_id is not null) THEN
2676:
2677: SELECT hold_lookup_code
2678: INTO l_hold_code
2679: FROM ap_holds_all
2680: WHERE invoice_id = p_inv_line_rec.invoice_id
2681: AND hold_lookup_code in ('DISTRIBUTION SET INACTIVE','SKELETON DISTRIBUTION SET',
2682: 'CANNOT OVERLAY ACCOUNT','INVALID DEFAULT ACCOUNT')
2683: AND release_lookup_code IS NULL;

Line 2690: FROM ap_holds_all

2686: l_alloc_rule_type is not null ) THEN
2687:
2688: SELECT hold_lookup_code
2689: INTO l_hold_code
2690: FROM ap_holds_all
2691: WHERE invoice_id = p_inv_line_rec.invoice_id
2692: AND hold_lookup_code = 'CANNOT EXECUTE ALLOCATION'
2693: AND release_lookup_code IS NULL;
2694:

Line 2699: FROM ap_holds_all

2695: ELSE
2696:
2697: SELECT hold_lookup_code
2698: INTO l_hold_code
2699: FROM ap_holds_all
2700: WHERE invoice_id = p_inv_line_rec.invoice_id
2701: AND hold_lookup_code in ('CANNOT OVERLAY ACCOUNT','INVALID DEFAULT ACCOUNT',
2702: 'PERIOD CLOSED','PROJECT GL DATE CLOSED')
2703: AND release_lookup_code IS NULL;

Line 8423: FROM ap_holds_all

8419: -- bug6783517 starts
8420: CURSOR dist_gen_holds(p_invoice_id NUMBER)
8421: IS
8422: SELECT hold_lookup_code
8423: FROM ap_holds_all
8424: WHERE hold_lookup_code IN ('DISTRIBUTION SET INACTIVE',
8425: 'SKELETON DISTRIBUTION SET',
8426: 'CANNOT OVERLAY ACCOUNT',
8427: 'INVALID DEFAULT ACCOUNT',

Line 8437: TABLE OF AP_HOLDS_ALL.HOLD_LOOKUP_CODE%TYPE

8433: AND release_lookup_code IS NULL
8434: AND invoice_id = p_invoice_id;
8435:
8436: TYPE holds_tab_type IS
8437: TABLE OF AP_HOLDS_ALL.HOLD_LOOKUP_CODE%TYPE
8438: INDEX BY BINARY_INTEGER;
8439:
8440: t_holds_tab holds_tab_type;
8441: -- bug6783517 ends