APPS.PAAP_PWP_PKG dependencies on PA_PWP_AP_INV_HDR_S

Line 521: Update PA_PWP_AP_INV_HDR Set RELHOLD_REJ_REASON = SubStr(l_err_msg,1,2000)

517: IF P_DEBUG_MODE = 'Y' THEN
518: log_message('In When Others Exception FORLOOP '||SQLERRM, 'paap_release_hold');
519: END IF;
520:
521: Update PA_PWP_AP_INV_HDR Set RELHOLD_REJ_REASON = SubStr(l_err_msg,1,2000)
522: Where invoice_id = p_inv_tbl(Inv_RelHOld_rec);
523:
524: x_msg_count := 1;
525: x_return_status :='E';

Line 552: Update PA_PWP_AP_INV_HDR Set RELHOLD_REJ_REASON = SubStr(l_err_msg,1,2000)

548: IF P_DEBUG_MODE = 'Y' THEN
549: log_message('In When Others Exception FORLOOP '||SQLERRM, 'paap_release_hold');
550: END IF;
551:
552: Update PA_PWP_AP_INV_HDR Set RELHOLD_REJ_REASON = SubStr(l_err_msg,1,2000)
553: Where invoice_id = p_inv_tbl(Inv_RelHOld_rec);
554:
555: x_msg_count := 1;
556: x_return_status :='E';

Line 589: Update PA_PWP_AP_INV_HDR Set HOLD_REASON = l_hold_reason1,

585: log_message('Setting hold reason to null for Invoice_Id:'
586: ||'[Invoice_Id : '||p_inv_tbl(Inv_RelHOld_rec)||' ]', 'paap_release_hold');
587: END IF;
588:
589: Update PA_PWP_AP_INV_HDR Set HOLD_REASON = l_hold_reason1,
590: PWP_HOLD_FLAG = l_inv_pwp_hold,
591: DLV_HOLD_FLAG = l_inv_dlv_hold,
592: HOLD_FLAG = l_inv_hold,
593: HOLD_APPLIED_YN = l_hold_applied_yn

Line 1240: -- L_PA_PWP_AP_HDR_ID:= PA_PWP_AP_INV_HDR_S.nextval; Changed for backward compatibility : Bug 7666516

1236: inv_prepay_amt:=inv_prepay_rec.prepaid_amount;
1237: END LOOP;
1238: /* sosharma end changes*/
1239:
1240: -- L_PA_PWP_AP_HDR_ID:= PA_PWP_AP_INV_HDR_S.nextval; Changed for backward compatibility : Bug 7666516
1241: SELECT PA_PWP_AP_INV_HDR_S.nextval
1242: INTO L_PA_PWP_AP_HDR_ID
1243: FROM dual;
1244:

Line 1241: SELECT PA_PWP_AP_INV_HDR_S.nextval

1237: END LOOP;
1238: /* sosharma end changes*/
1239:
1240: -- L_PA_PWP_AP_HDR_ID:= PA_PWP_AP_INV_HDR_S.nextval; Changed for backward compatibility : Bug 7666516
1241: SELECT PA_PWP_AP_INV_HDR_S.nextval
1242: INTO L_PA_PWP_AP_HDR_ID
1243: FROM dual;
1244:
1245: IF P_DEBUG_MODE = 'Y' THEN

Line 1819: Update PA_PWP_AP_INV_HDR Set HOLD_REASON = l_hold_reason1,

1815: l_hold_applied_yn := 'Y';
1816: End If;
1817: END LOOP;
1818:
1819: Update PA_PWP_AP_INV_HDR Set HOLD_REASON = l_hold_reason1,
1820: PWP_HOLD_FLAG = l_inv_pwp_hold,
1821: DLV_HOLD_FLAG = l_inv_dlv_hold,
1822: HOLD_FLAG = l_inv_hold,
1823: HOLD_APPLIED_YN = l_hold_applied_yn