APPS.PAAP_PWP_PKG dependencies on PA_PWP_AP_INV_HDR

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 522: -- This procedure populates pa_pwp_ap_inv_hdr, pa_pwp_ap_inv_dtl tables by processing all the supplier

518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: END paap_release_hold;
520:
521: /*---------------------------------------------------------------------------------------------------------
522: -- This procedure populates pa_pwp_ap_inv_hdr, pa_pwp_ap_inv_dtl tables by processing all the supplier
523: -- invoices pertaining to the project_id being passed. Returns Success/Failure to the calling module.
524: -- Input parameters
525: -- Parameters Type Required Description
526: -- p_project_id NUMBER YES It stores the project_id

Line 799: log_message('Before deleting data from PA_PWP_AP_INV_HDR and PA_PWP_AP_INV_DTL for'||

795: 'Process_SuppInv_Dtls1');
796: END IF;
797:
798: IF P_DEBUG_MODE = 'Y' THEN
799: log_message('Before deleting data from PA_PWP_AP_INV_HDR and PA_PWP_AP_INV_DTL for'||
800: '[P_Project_Id : '||P_Project_Id||' ]',
801: 'Process_SuppInv_Dtls1');
802: END IF;
803:

Line 805: Delete from PA_PWP_AP_INV_HDR where project_id = P_Project_Id;

801: 'Process_SuppInv_Dtls1');
802: END IF;
803:
804: IF G_Draft_Inv_Num IS NULL THEN
805: Delete from PA_PWP_AP_INV_HDR where project_id = P_Project_Id;
806: Delete from PA_PWP_AP_INV_DTL where project_id = P_Project_Id;
807: END IF;
808: IF G_Draft_Inv_Num IS NOT NULL THEN
809: OPEN C6(G_Draft_Inv_Num);

Line 820: Delete from PA_PWP_AP_INV_HDR where project_id = P_Project_Id And Invoice_Id = G_Invoice_Id;

816: IF C6%NOTFOUND THEN
817: CLOSE C6;
818: EXIT;
819: ELSE
820: Delete from PA_PWP_AP_INV_HDR where project_id = P_Project_Id And Invoice_Id = G_Invoice_Id;
821: Delete from PA_PWP_AP_INV_DTL where project_id = P_Project_Id And Invoice_Id = G_Invoice_Id;
822: END IF;
823: END IF;
824:

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

Line 966: log_message('Before inserting record in PA_PWP_AP_INV_HDR'||

962: INTO L_PA_PWP_AP_HDR_ID
963: FROM dual;
964:
965: IF P_DEBUG_MODE = 'Y' THEN
966: log_message('Before inserting record in PA_PWP_AP_INV_HDR'||
967: '[INVREC.INVOICE_ID : '||INVREC.INVOICE_ID||'] '||
968: '[l_stage : '||l_stage||'] '||
969: '[L_PA_PWP_AP_HDR_ID : '||L_PA_PWP_AP_HDR_ID||'] ',
970: 'Process_SuppInv_Dtls1');

Line 973: Insert Into PA_PWP_AP_INV_HDR(PA_PWP_AP_HDR_ID

969: '[L_PA_PWP_AP_HDR_ID : '||L_PA_PWP_AP_HDR_ID||'] ',
970: 'Process_SuppInv_Dtls1');
971: END IF;
972:
973: Insert Into PA_PWP_AP_INV_HDR(PA_PWP_AP_HDR_ID
974: ,PROJECT_ID
975: ,INVOICE_ID
976: ,INVOICE_NUM
977: ,vendOR_ID

Line 1245: Update PA_PWP_AP_INV_HDR

1241: '[l_stage : '||l_stage||'] ',
1242: 'Process_SuppInv_Dtls1');
1243: END IF;
1244:
1245: Update PA_PWP_AP_INV_HDR
1246: Set po_number = l_po_number
1247: Where pa_pwp_ap_hdr_id = l_pa_pwp_ap_hdr_id;
1248:
1249: END LOOP;

Line 1308: -- This procedure in turn calls Process_SuppInv_Dtls1, to populate pa_pwp_ap_inv_hdr, pa_pwp_ap_inv_dtl

1304: X_msg_data := SQLERRM;
1305: END Process_SuppInv_Dtls1;
1306:
1307: ---------------------------------------------------------------------------------------------------------
1308: -- This procedure in turn calls Process_SuppInv_Dtls1, to populate pa_pwp_ap_inv_hdr, pa_pwp_ap_inv_dtl
1309: -- tables by processing all the supplier invoices pertaining to the project_id being passed.
1310: -- This is being called from the Summary Page of Subcontractor tab.
1311: -- Input parameters
1312: -- Parameters Type Required Description