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

Line 337: from ap_holds_all h

333: and ail.org_id = l_org_id
334: and ail.line_type_lookup_code = 'ITEM'
335: and exists (
336: (select h.line_location_id
337: from ap_holds_all h
338: where h.invoice_id = l_invoice_id
339: and h.org_id = l_org_id
340: and h.hold_id = l_hold_id
341: and ail.po_line_location_id = h.line_location_id

Line 556: UPDATE ap_holds_all

552: approverPersonIdIn => l_approver_id,
553: approverUserIdIn => NULL,
554: transactionTypeIn => 'APHLD');
555:
556: UPDATE ap_holds_all
557: SET wf_status = 'RELEASED'
558: WHERE hold_id = l_hold_id;
559:
560: resultout := wf_engine.eng_completed||':'||'Y';

Line 752: UPDATE ap_holds_all

748: approverPersonIdIn => l_approver_id,
749: approverUserIdIn => NULL,
750: transactionTypeIn => 'APHLD');
751:
752: UPDATE ap_holds_all
753: SET wf_status = 'RELEASED'
754: WHERE hold_id = l_hold_id;
755:
756: resultout := wf_engine.eng_completed||':'||'Y';

Line 927: UPDATE ap_holds_all

923: itemKey => l_parentkey,
924: activity => 'HOLD_MAIN:WAITNEGOTIABLE',
925: result => 'NULL');
926:
927: UPDATE ap_holds_all
928: SET wf_status = 'RELEASED'
929: WHERE hold_id = l_hold_id;
930:
931: resultout := wf_engine.eng_completed||':'||'Y';

Line 1243: UPDATE ap_holds_all

1239: activity => 'HOLD_MAIN:WAITNEGOTIABLE',
1240: result => 'NULL');
1241:
1242:
1243: UPDATE ap_holds_all
1244: SET wf_status = 'RELEASED'
1245: WHERE hold_id = l_hold_id;
1246:
1247: resultout := wf_engine.eng_completed||':'||'Y';

Line 4296: FROM ap_holds_all ah,

4292: AI.approval_iteration,
4293: nvl(p_ext_contact_id, AI.vendor_contact_id),
4294: NVL(AI.invoice_amount, 0),
4295: ahc.hold_instruction
4296: FROM ap_holds_all ah,
4297: ap_invoices_all AI,
4298: po_vendors PV,
4299: ap_hold_codes ahc
4300: WHERE ah.hold_id = p_hold_id

Line 4540: UPDATE ap_holds_all

4536:
4537: insert_history_table(p_hist_rec => l_hist_rec);
4538: newchildprocess := l_new_child_itemkey;
4539:
4540: UPDATE ap_holds_all
4541: SET wf_status = 'NEGOTIATE'
4542: WHERE hold_id = p_hold_id;
4543:
4544: EXCEPTION

Line 4566: FROM ap_holds_all ah,

4562: AI.invoice_id,
4563: alk.displayed_field,
4564: NVL(AI.invoice_amount, 0),
4565: ahc.hold_instruction
4566: FROM ap_holds_all ah,
4567: ap_invoices_all AI,
4568: po_vendors PV,
4569: ap_lookup_codes alk,
4570: ap_hold_codes ahc

Line 4653: UPDATE ap_holds_all

4649: 'PARENT_KEY',
4650: l_itemkey);
4651: WF_ENGINE.startProcess('APINVHDN', l_itemkey);
4652:
4653: UPDATE ap_holds_all
4654: SET wf_status = 'STARTED'
4655: WHERE hold_id = p_hold_id;
4656:
4657: EXCEPTION

Line 6483: l_hold_release_code ap_holds_all.release_lookup_code%TYPE;

6479: l_org_id NUMBER;
6480: l_invoice_id NUMBER;
6481: l_hold_id NUMBER;
6482: l_num number;
6483: l_hold_release_code ap_holds_all.release_lookup_code%TYPE;
6484: l_debug_info VARCHAR2(2000);
6485: l_api_name CONSTANT VARCHAR2(200) := 'continue_hold_workflow';
6486: BEGIN
6487: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 6505: from ap_holds_all aha,

6501: l_api_name,l_debug_info);
6502: END IF;
6503: select aha.release_lookup_code
6504: into l_hold_release_code
6505: from ap_holds_all aha,
6506: ap_hold_codes ahc
6507: where aha.invoice_id = l_invoice_id
6508: and aha.org_id = l_org_id
6509: and aha.hold_lookup_code = ahc.hold_lookup_code

Line 6562: from ap_holds_all aha,

6558: l_api_name,l_debug_info);
6559: END IF;
6560: select nvl(ahc.wait_before_notify_days,0)*24*60
6561: into l_wait_time
6562: from ap_holds_all aha,
6563: ap_hold_codes ahc
6564: where aha.invoice_id = l_invoice_id
6565: and aha.org_id = l_org_id
6566: and aha.hold_lookup_code = ahc.hold_lookup_code

Line 6602: l_hold_release_code ap_holds_all.release_lookup_code%TYPE;

6598: l_org_id NUMBER;
6599: l_invoice_id NUMBER;
6600: l_hold_id NUMBER;
6601: l_num number;
6602: l_hold_release_code ap_holds_all.release_lookup_code%TYPE;
6603: l_wait_time NUMBER;
6604: l_debug_info VARCHAR2(2000);
6605: l_api_name CONSTANT VARCHAR2(200) := 'is_hold_released';
6606: BEGIN

Line 6627: from ap_holds_all aha,

6623: select aha.release_lookup_code,
6624: nvl(ahc.wait_before_notify_days,0)*24*60
6625: into l_hold_release_code,
6626: l_wait_time
6627: from ap_holds_all aha,
6628: ap_hold_codes ahc
6629: where aha.invoice_id = l_invoice_id
6630: and aha.org_id = l_org_id
6631: and aha.hold_lookup_code = ahc.hold_lookup_code

Line 6666: UPDATE ap_holds_all

6662: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6663: l_api_name,l_debug_info);
6664: END IF;
6665:
6666: UPDATE ap_holds_all
6667: SET wf_status = 'MANUALLYRELEASED'
6668: WHERE hold_id = p_hold_id;
6669:
6670: l_debug_info := 'End';

Line 6698: FROM ap_holds_all aha

6694: END IF;
6695:
6696: SELECT count(*)
6697: INTO l_num_holds_under_neg
6698: FROM ap_holds_all aha
6699: WHERE aha.invoice_id = p_invoice_id
6700: AND aha.org_id = p_org_id
6701: AND aha.wf_status = 'NEGOTIATE';
6702: