APPS.CST_PACEAMCOST_GRP dependencies on CST_PAC_EAM_BALANCE_BY_ACCTS

Line 4154: -- The procedure inserts/updates data into CST_PAC_EAM_BALANCE_BY_ACCTS

4150: -- Start of comments
4151: -- API name : Insert_PAC_eamBalAcct
4152: -- Type : Public.
4153: -- Function : This API is called from CST_PacEamCost_GRP.Estimate_PAC_WipJobs.
4154: -- The procedure inserts/updates data into CST_PAC_EAM_BALANCE_BY_ACCTS
4155: -- table.
4156: -- Flow:
4157: -- |-- Verify if the estimation data already exists for the wip job
4158: -- | and GL Account for the given cost group and cost type.

Line 4314: MERGE INTO CST_PAC_EAM_BALANCE_BY_ACCTS cebba

4310:
4311:
4312: /* Update the record if already exists else insert a new one */
4313:
4314: MERGE INTO CST_PAC_EAM_BALANCE_BY_ACCTS cebba
4315: USING
4316: (
4317: SELECT NULL FROM DUAL
4318: ) temp

Line 4550: /* Delete data from CST_PAC_EAM_BALANCE_BY_ACCTS */

4546: x_return_status := FND_API.G_RET_STS_SUCCESS;
4547:
4548: l_stmt_num := 10;
4549:
4550: /* Delete data from CST_PAC_EAM_BALANCE_BY_ACCTS */
4551: FORALL l_index IN p_wip_entity_id_tab.FIRST..p_wip_entity_id_tab.LAST
4552: Delete from CST_PAC_EAM_BALANCE_BY_ACCTS
4553: where wip_entity_id = p_wip_entity_id_tab(l_index)
4554: -- and organization_id=p_org_id -- sikhanna not required

Line 4552: Delete from CST_PAC_EAM_BALANCE_BY_ACCTS

4548: l_stmt_num := 10;
4549:
4550: /* Delete data from CST_PAC_EAM_BALANCE_BY_ACCTS */
4551: FORALL l_index IN p_wip_entity_id_tab.FIRST..p_wip_entity_id_tab.LAST
4552: Delete from CST_PAC_EAM_BALANCE_BY_ACCTS
4553: where wip_entity_id = p_wip_entity_id_tab(l_index)
4554: -- and organization_id=p_org_id -- sikhanna not required
4555: and legal_entity_id = p_legal_entity_id
4556: and cost_group_id = p_cost_group_id