DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on AP_HOLDS_PKG

Line 502: log_message('Before calling AP_HOLDS_PKG.release_single_hold API '

498: if(p_rel_option = 'REL_ALL_HOLD') then
499: FOR HoldRec in c1(p_inv_tbl(Inv_RelHOld_rec)) LOOP
500: BEGIN
501: IF P_DEBUG_MODE = 'Y' THEN
502: log_message('Before calling AP_HOLDS_PKG.release_single_hold API '
503: ||'[Invoice_Id : '||p_inv_tbl(Inv_RelHOld_rec)||'] '
504: ||'[hold_lookup_code: '||HoldRec.hold_lookup_code||'] '
505: ||'[l_hold_reason: '||l_hold_reason||'] ', 'paap_release_hold');
506: END IF;

Line 508: AP_HOLDS_PKG.release_single_hold

504: ||'[hold_lookup_code: '||HoldRec.hold_lookup_code||'] '
505: ||'[l_hold_reason: '||l_hold_reason||'] ', 'paap_release_hold');
506: END IF;
507:
508: AP_HOLDS_PKG.release_single_hold
509: (X_invoice_id => p_inv_tbl(Inv_RelHOld_rec),
510: X_hold_lookup_code=> HoldRec.hold_lookup_code,
511: X_release_lookup_code =>l_hold_reason); /*Removed the parameter Held_By for bug 8916025 */
512:

Line 533: log_message('Before calling AP_HOLDS_PKG.release_single_hold API '

529: else
530: FOR HoldRec in c12(p_inv_tbl(Inv_RelHOld_rec),p_rel_option) LOOP
531: BEGIN
532: IF P_DEBUG_MODE = 'Y' THEN
533: log_message('Before calling AP_HOLDS_PKG.release_single_hold API '
534: ||'[Invoice_Id : '||p_inv_tbl(Inv_RelHOld_rec)||'] '
535: ||'[hold_lookup_code: '||HoldRec.hold_lookup_code||'] '
536: ||'[l_hold_reason: '||l_hold_reason||'] ', 'paap_release_hold');
537: END IF;

Line 539: AP_HOLDS_PKG.release_single_hold

535: ||'[hold_lookup_code: '||HoldRec.hold_lookup_code||'] '
536: ||'[l_hold_reason: '||l_hold_reason||'] ', 'paap_release_hold');
537: END IF;
538:
539: AP_HOLDS_PKG.release_single_hold
540: (X_invoice_id => p_inv_tbl(Inv_RelHOld_rec),
541: X_hold_lookup_code=> HoldRec.hold_lookup_code,
542: X_release_lookup_code =>l_hold_reason); /*Removed the parameter Held_By for bug 8916025 */
543:

Line 1791: AP_HOLDS_PKG.insert_single_hold (X_invoice_id=>P_Inv_Tbl(i)

1787: l_hold_applied_yn varchar2(1):= 'N';
1788: Begin
1789: X_return_status :='S';
1790: FOR I in 1..P_Inv_Tbl.COUNT LOOP
1791: AP_HOLDS_PKG.insert_single_hold (X_invoice_id=>P_Inv_Tbl(i)
1792: ,X_hold_lookup_code=>'Project Hold' -- bug 9525493
1793: ,X_hold_reason=>'Project Managers Hold'
1794: ,X_held_by=>FND_GLOBAL.User_Id);
1795: