APPS.PAAP_PWP_PKG dependencies on PA_PWP_AP_INV_DTL

Line 623: -- This procedure populates pa_pwp_ap_inv_hdr, pa_pwp_ap_inv_dtl tables by processing all the supplier

619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END paap_release_hold;
621:
622: /*---------------------------------------------------------------------------------------------------------
623: -- This procedure populates pa_pwp_ap_inv_hdr, pa_pwp_ap_inv_dtl tables by processing all the supplier
624: -- invoices pertaining to the project_id being passed. Returns Success/Failure to the calling module.
625: -- Input parameters
626: -- Parameters Type Required Description
627: -- p_project_id NUMBER YES It stores the project_id

Line 865: from pa_pwp_ap_inv_dtl where invoice_id = p_Invoice_id);

861: -- Cursor C5 is to get all the PO number's matched to an Invoice.
862: Cursor C5(p_Invoice_Id Number) IS
863: Select Segment1 PO_NUMBER From po_headers_all
864: Where po_header_id in (Select distinct po_header_id
865: from pa_pwp_ap_inv_dtl where invoice_id = p_Invoice_id);
866:
867: --Cursor C6 is to get all the linked invoices for a given Draft_Inv_Num
868: Cursor C6(P_Draft_Inv_Num Number) IS
869: Select distinct Invoice_Id From (

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

1023: 'Process_SuppInv_Dtls1');
1024: END IF;
1025:
1026: IF P_DEBUG_MODE = 'Y' THEN
1027: log_message('Before deleting data from PA_PWP_AP_INV_HDR and PA_PWP_AP_INV_DTL for'||
1028: '[P_Project_Id : '||P_Project_Id||' ]',
1029: 'Process_SuppInv_Dtls1');
1030: END IF;
1031:

Line 1034: Delete from PA_PWP_AP_INV_DTL where project_id = P_Project_Id;

1030: END IF;
1031:
1032: IF G_Draft_Inv_Num IS NULL THEN
1033: Delete from PA_PWP_AP_INV_HDR where project_id = P_Project_Id;
1034: Delete from PA_PWP_AP_INV_DTL where project_id = P_Project_Id;
1035: END IF;
1036: IF G_Draft_Inv_Num IS NOT NULL THEN
1037: OPEN C6(G_Draft_Inv_Num);
1038: END IF;

Line 1049: Delete from PA_PWP_AP_INV_DTL where project_id = P_Project_Id And Invoice_Id = G_Invoice_Id;

1045: CLOSE C6;
1046: EXIT;
1047: ELSE
1048: Delete from PA_PWP_AP_INV_HDR where project_id = P_Project_Id And Invoice_Id = G_Invoice_Id;
1049: Delete from PA_PWP_AP_INV_DTL where project_id = P_Project_Id And Invoice_Id = G_Invoice_Id;
1050: END IF;
1051: END IF;
1052:
1053: l_stage :=10;

Line 1313: log_message('Before opening the loop for inserting record in PA_PWP_AP_INV_DTL '||

1309:
1310: l_stage :=50;
1311:
1312: IF P_DEBUG_MODE = 'Y' THEN
1313: log_message('Before opening the loop for inserting record in PA_PWP_AP_INV_DTL '||
1314: '[INVREC.INVOICE_ID : '||INVREC.INVOICE_ID||'] '||
1315: '[l_stage : '||l_stage||'] ',
1316: 'Process_SuppInv_Dtls1');
1317: END IF;

Line 1542: log_message('Before inserting record in PA_PWP_AP_INV_DTL '||

1538:
1539: l_stage :=70;
1540:
1541: IF P_DEBUG_MODE = 'Y' THEN
1542: log_message('Before inserting record in PA_PWP_AP_INV_DTL '||
1543: '[INVREC.INVOICE_ID : '||INVREC.INVOICE_ID||'] '||
1544: '[l_stage : '||l_stage||'] ',
1545: 'Process_SuppInv_Dtls1');
1546: END IF;

Line 1548: Insert into PA_PWP_AP_INV_DTL(PA_PWP_AP_HDR_ID

1544: '[l_stage : '||l_stage||'] ',
1545: 'Process_SuppInv_Dtls1');
1546: END IF;
1547:
1548: Insert into PA_PWP_AP_INV_DTL(PA_PWP_AP_HDR_ID
1549: ,INVOICE_ID
1550: ,PROJECT_ID
1551: ,TASK_ID
1552: ,Expenditure_Item_Date

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

1706: X_msg_data := SQLERRM;
1707: END Process_SuppInv_Dtls1;
1708:
1709: ---------------------------------------------------------------------------------------------------------
1710: -- This procedure in turn calls Process_SuppInv_Dtls1, to populate pa_pwp_ap_inv_hdr, pa_pwp_ap_inv_dtl
1711: -- tables by processing all the supplier invoices pertaining to the project_id being passed.
1712: -- This is being called from the Summary Page of Subcontractor tab.
1713: -- Input parameters
1714: -- Parameters Type Required Description