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

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 1540: FROM ap_holds H, ap_hold_codes C

1536: SELECT 'Y'
1537: INTO l_unpostable_holds_exist
1538: FROM dual
1539: WHERE EXISTS (SELECT 1
1540: FROM ap_holds H, ap_hold_codes C
1541: WHERE H.invoice_id = l_invoice_id
1542: AND H.hold_lookup_code = C.hold_lookup_code
1543: AND ((H.release_lookup_code IS NULL)
1544: AND ((C.postable_flag = 'N') OR (C.postable_flag = 'X'))));

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 4516: FROM ap_holds AH,

4512: FROM ap_invoice_distributions_all AID1
4513: WHERE AID1.invoice_id = AI.invoice_id
4514: AND AID1.awt_group_id IS NOT NULL)
4515: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
4516: FROM ap_holds AH,
4517: ap_hold_codes AHC
4518: WHERE AH.invoice_id = AI.invoice_id
4519: AND AH.release_lookup_code IS NULL
4520: AND AH.hold_lookup_code <> 'AWT ERROR'

Line 4590: FROM ap_holds AH,

4586: l_invoice_num
4587: FROM ap_invoices_all AI
4588: WHERE AI.invoice_id = p_invoice_id
4589: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
4590: FROM ap_holds AH,
4591: ap_hold_codes AHC
4592: WHERE AH.invoice_id = AI.invoice_id
4593: AND AH.release_lookup_code IS NULL
4594: AND AH.hold_lookup_code <> 'AWT ERROR'

Line 4787: FROM ap_holds H, ap_hold_codes C

4783: WHERE match_status_flag = 'T'
4784: AND D.invoice_id = p_invoice_id
4785: AND ((NOT EXISTS
4786: (SELECT invoice_id
4787: FROM ap_holds H, ap_hold_codes C
4788: WHERE H.invoice_id = D.invoice_id
4789: AND H.hold_lookup_code = C.hold_lookup_code
4790: AND ((H.release_lookup_code IS NULL) AND
4791: ((C.postable_flag = 'N') OR

Line 4807: FROM ap_holds H, ap_hold_codes C

4803: WHERE match_status_flag = 'T'
4804: AND D.invoice_id = p_invoice_id
4805: AND ((NOT EXISTS
4806: (SELECT invoice_id
4807: FROM ap_holds H, ap_hold_codes C
4808: WHERE H.invoice_id = D.invoice_id
4809: AND H.hold_lookup_code = C.hold_lookup_code
4810: AND ((H.release_lookup_code IS NULL) AND
4811: ((C.postable_flag = 'N') OR

Line 4962: UPDATE ap_holds

4958: l_debug_info := 'Erase responsibility id from old insuff funds holds';
4959: Print_Debug(l_debug_loc, l_debug_info);
4960: -------------------------------------------
4961:
4962: UPDATE ap_holds
4963: SET responsibility_id = NULL
4964: WHERE invoice_id = p_invoice_id
4965: AND hold_lookup_code = 'INSUFFICIENT FUNDS';
4966:

Line 5166: l_debug_info := 'Updating AP_HOLDS with release info';

5162: l_release_lookup_code,
5163: l_curr_calling_sequence);
5164:
5165: -------------------------------------------
5166: l_debug_info := 'Updating AP_HOLDS with release info';
5167: Print_Debug(l_debug_loc, l_debug_info);
5168: -------------------------------------------
5169:
5170: UPDATE ap_holds

Line 5170: UPDATE ap_holds

5166: l_debug_info := 'Updating AP_HOLDS with release info';
5167: Print_Debug(l_debug_loc, l_debug_info);
5168: -------------------------------------------
5169:
5170: UPDATE ap_holds
5171: SET release_lookup_code = l_release_lookup_code,
5172: release_reason = (SELECT description
5173: FROM ap_lookup_codes
5174: WHERE lookup_code = l_release_lookup_code

Line 5209: (p_table_name => 'AP_HOLDS',

5205: (p_invoice_id => p_invoice_id,
5206: p_calling_sequence => l_curr_calling_sequence);
5207:
5208: AP_DBI_PKG.Maintain_DBI_Summary
5209: (p_table_name => 'AP_HOLDS',
5210: p_operation => 'U',
5211: p_key_value1 => p_invoice_id,
5212: p_calling_sequence => l_curr_calling_sequence);
5213:

Line 5275: l_debug_info := 'Inserting Into AP_HOLDS';

5271: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5272: p_calling_sequence;
5273:
5274: -------------------------------------------
5275: l_debug_info := 'Inserting Into AP_HOLDS';
5276: Print_Debug(l_debug_loc, l_debug_info);
5277: -------------------------------------------
5278:
5279: SELECT ap_holds_s.nextval

Line 5279: SELECT ap_holds_s.nextval

5275: l_debug_info := 'Inserting Into AP_HOLDS';
5276: Print_Debug(l_debug_loc, l_debug_info);
5277: -------------------------------------------
5278:
5279: SELECT ap_holds_s.nextval
5280: INTO l_hold_id
5281: FROM DUAL;
5282:
5283: INSERT INTO ap_holds (

Line 5283: INSERT INTO ap_holds (

5279: SELECT ap_holds_s.nextval
5280: INTO l_hold_id
5281: FROM DUAL;
5282:
5283: INSERT INTO ap_holds (
5284: invoice_id,
5285: line_location_id,
5286: rcv_transaction_id,
5287: hold_lookup_code,

Line 5358: (p_table_name => 'AP_HOLDS',

5354:
5355: END IF;
5356:
5357: AP_DBI_PKG.Maintain_DBI_Summary
5358: (p_table_name => 'AP_HOLDS',
5359: p_operation => 'I',
5360: p_key_value1 => p_invoice_id,
5361: p_calling_sequence => l_curr_calling_sequence);
5362:

Line 7448: ' FROM AP_HOLDS H '||

7444: ' AND NVL(D.MATCH_STATUS_FLAG, ''N'') <> ''A''' ||
7445: ' ) '||
7446: ' OR EXISTS '||
7447: ' (SELECT ''Unreleased Hold exists'' '||
7448: ' FROM AP_HOLDS H '||
7449: ' WHERE H.INVOICE_ID = AI.INVOICE_ID '||
7450: ' AND H.HOLD_LOOKUP_CODE IN '||
7451: ' (''QTY ORD'', ''QTY REC'', ''AMT ORD'', ''AMT REC'', ''QUALITY'', '||
7452: ' ''PRICE'', ''TAX DIFFERENCE'', ''CURRENCY DIFFERENCE'', '||

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

Line 8797: From ap_holds

8793: line_location_id,
8794: rcv_transaction_id,
8795: last_updated_by,
8796: responsibility_id
8797: From ap_holds
8798: Where invoice_id = c_invoice_id
8799: Order By 1, 2 DESC;
8800:
8801: j NUMBER := 1;