APPS.PAAP_PWP_PKG dependencies on PA_PWP_AP_INV_HDR_S

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

472: IF P_DEBUG_MODE = 'Y' THEN
473: log_message('In When Others Exception FORLOOP '||SQLERRM, 'paap_release_hold');
474: END IF;
475:
476: Update PA_PWP_AP_INV_HDR Set RELHOLD_REJ_REASON = SubStr(l_err_msg,1,2000)
477: Where invoice_id = p_inv_tbl(Inv_RelHOld_rec);
478:
479: x_msg_count := 1;
480: x_return_status :='E';

Line 490: Update PA_PWP_AP_INV_HDR Set HOLD_REASON = '',

486: log_message('Setting hold reason to null for Invoice_Id:'
487: ||'[Invoice_Id : '||p_inv_tbl(Inv_RelHOld_rec)||' ]', 'paap_release_hold');
488: END IF;
489:
490: Update PA_PWP_AP_INV_HDR Set HOLD_REASON = '',
491: PWP_HOLD_FLAG = 'N',
492: DLV_HOLD_FLAG = 'N'
493: Where Invoice_Id = p_inv_tbl(Inv_RelHOld_rec)
494: And RELHOLD_REJ_REASON Is Null;

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

956:
957: l_stage :=40;
958:
959:
960: -- L_PA_PWP_AP_HDR_ID:= PA_PWP_AP_INV_HDR_S.nextval; Changed for backward compatibility : Bug 7666516
961: SELECT PA_PWP_AP_INV_HDR_S.nextval
962: INTO L_PA_PWP_AP_HDR_ID
963: FROM dual;
964:

Line 961: SELECT PA_PWP_AP_INV_HDR_S.nextval

957: l_stage :=40;
958:
959:
960: -- L_PA_PWP_AP_HDR_ID:= PA_PWP_AP_INV_HDR_S.nextval; Changed for backward compatibility : Bug 7666516
961: SELECT PA_PWP_AP_INV_HDR_S.nextval
962: INTO L_PA_PWP_AP_HDR_ID
963: FROM dual;
964:
965: IF P_DEBUG_MODE = 'Y' THEN