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 242: update ap_holds_all

238: APP_EXCEPTION.RAISE_EXCEPTION;
239: END IF;
240: IF l_next_approver.person_id is null THEN /*no approver on the list*/
241: -- added for bug 8671976
242: update ap_holds_all
243: set wf_status = 'TERMINATED'
244: where hold_id = l_hold_id ;
245: -- added for bug 8671976
246: resultout := wf_engine.eng_completed||':'||'N';

Line 345: from ap_holds_all h

341: and ail.org_id = l_org_id
342: and ail.line_type_lookup_code = 'ITEM'
343: and exists (
344: (select h.line_location_id
345: from ap_holds_all h
346: where h.invoice_id = l_invoice_id
347: and h.org_id = l_org_id
348: and h.hold_id = l_hold_id
349: and ail.po_line_location_id = h.line_location_id

Line 575: UPDATE ap_holds_all

571: approverPersonIdIn => l_approver_id,
572: approverUserIdIn => NULL,
573: transactionTypeIn => 'APHLD');
574:
575: UPDATE ap_holds_all
576: SET wf_status = 'RELEASED'
577: WHERE hold_id = l_hold_id;
578:
579: resultout := wf_engine.eng_completed||':'||'Y';

Line 784: UPDATE ap_holds_all

780: approverPersonIdIn => l_approver_id,
781: approverUserIdIn => NULL,
782: transactionTypeIn => 'APHLD');
783:
784: UPDATE ap_holds_all
785: SET wf_status = 'RELEASED'
786: WHERE hold_id = l_hold_id;
787:
788: resultout := wf_engine.eng_completed||':'||'Y';

Line 959: UPDATE ap_holds_all

955: itemKey => l_parentkey,
956: activity => 'HOLD_MAIN:WAITNEGOTIABLE',
957: result => 'NULL');
958:
959: UPDATE ap_holds_all
960: SET wf_status = 'RELEASED'
961: WHERE hold_id = l_hold_id;
962:
963: resultout := wf_engine.eng_completed||':'||'Y';

Line 1275: UPDATE ap_holds_all

1271: activity => 'HOLD_MAIN:WAITNEGOTIABLE',
1272: result => 'NULL');
1273:
1274:
1275: UPDATE ap_holds_all
1276: SET wf_status = 'RELEASED'
1277: WHERE hold_id = l_hold_id;
1278:
1279: resultout := wf_engine.eng_completed||':'||'Y';

Line 4423: FROM ap_holds_all ah,

4419: AI.approval_iteration,
4420: nvl(p_ext_contact_id, AI.vendor_contact_id),
4421: NVL(AI.invoice_amount, 0),
4422: ahc.hold_instruction
4423: FROM ap_holds_all ah,
4424: ap_invoices_all AI,
4425: po_vendors PV,
4426: ap_hold_codes ahc
4427: WHERE ah.hold_id = p_hold_id

Line 4672: UPDATE ap_holds_all

4668:
4669: insert_history_table(p_hist_rec => l_hist_rec);
4670: newchildprocess := l_new_child_itemkey;
4671:
4672: UPDATE ap_holds_all
4673: SET wf_status = 'NEGOTIATE'
4674: WHERE hold_id = p_hold_id;
4675:
4676: EXCEPTION

Line 4698: FROM ap_holds_all ah,

4694: AI.invoice_id,
4695: alk.displayed_field,
4696: NVL(AI.invoice_amount, 0),
4697: ahc.hold_instruction
4698: FROM ap_holds_all ah,
4699: ap_invoices_all AI,
4700: po_vendors PV,
4701: ap_lookup_codes alk,
4702: ap_hold_codes ahc

Line 4784: UPDATE ap_holds_all

4780: l_itemkey,
4781: 'PARENT_KEY',
4782: l_itemkey);
4783:
4784: UPDATE ap_holds_all
4785: SET wf_status = 'STARTED'
4786: WHERE hold_id = p_hold_id;
4787:
4788: WF_ENGINE.startProcess('APINVHDN', l_itemkey);

Line 6751: l_hold_release_code ap_holds_all.release_lookup_code%TYPE;

6747: l_org_id NUMBER;
6748: l_invoice_id NUMBER;
6749: l_hold_id NUMBER;
6750: l_num number;
6751: l_hold_release_code ap_holds_all.release_lookup_code%TYPE;
6752: l_debug_info VARCHAR2(2000);
6753: l_api_name CONSTANT VARCHAR2(200) := 'continue_hold_workflow';
6754: BEGIN
6755: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 6773: from ap_holds_all aha,

6769: l_api_name,l_debug_info);
6770: END IF;
6771: select aha.release_lookup_code
6772: into l_hold_release_code
6773: from ap_holds_all aha,
6774: ap_hold_codes ahc
6775: where aha.invoice_id = l_invoice_id
6776: and aha.org_id = l_org_id
6777: and aha.hold_lookup_code = ahc.hold_lookup_code

Line 6830: from ap_holds_all aha,

6826: l_api_name,l_debug_info);
6827: END IF;
6828: select nvl(ahc.wait_before_notify_days,0) -- Bug 10090981 *24*60
6829: into l_wait_time
6830: from ap_holds_all aha,
6831: ap_hold_codes ahc
6832: where aha.invoice_id = l_invoice_id
6833: and aha.org_id = l_org_id
6834: and aha.hold_lookup_code = ahc.hold_lookup_code

Line 6870: l_hold_release_code ap_holds_all.release_lookup_code%TYPE;

6866: l_org_id NUMBER;
6867: l_invoice_id NUMBER;
6868: l_hold_id NUMBER;
6869: l_num number;
6870: l_hold_release_code ap_holds_all.release_lookup_code%TYPE;
6871: l_wait_time NUMBER;
6872: l_debug_info VARCHAR2(2000);
6873: l_api_name CONSTANT VARCHAR2(200) := 'is_hold_released';
6874: BEGIN

Line 6895: from ap_holds_all aha,

6891: select aha.release_lookup_code,
6892: nvl(ahc.reminder_days,0) -- Bug 10090981 *24*60 --Bug8839774
6893: into l_hold_release_code,
6894: l_wait_time
6895: from ap_holds_all aha,
6896: ap_hold_codes ahc
6897: where aha.invoice_id = l_invoice_id
6898: and aha.org_id = l_org_id
6899: and aha.hold_lookup_code = ahc.hold_lookup_code

Line 6963: UPDATE ap_holds_all

6959: END IF;
6960: END ;
6961:
6962: If ( NVL( l_status, 'N' ) <> 'COMPLETE' ) THEN -- Bug 9402921 : Added NVL
6963: UPDATE ap_holds_all
6964: SET wf_status = 'MANUALLYRELEASED'
6965: WHERE hold_id = p_hold_id;
6966:
6967: IF l_success THEN -- Bug 9402921 : Added if-end if

Line 7007: FROM ap_holds_all aha

7003: END IF;
7004:
7005: SELECT count(*)
7006: INTO l_num_holds_under_neg
7007: FROM ap_holds_all aha
7008: WHERE aha.invoice_id = p_invoice_id
7009: AND aha.org_id = p_org_id
7010: AND aha.wf_status = 'NEGOTIATE';
7011: