APPS.CST_PACEAMCOST_GRP dependencies on CST_PAC_EAM_BALANCE_BY_ACCTS

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

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

Line 4313: MERGE INTO CST_PAC_EAM_BALANCE_BY_ACCTS cebba

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

Line 4549: /* Delete data from CST_PAC_EAM_BALANCE_BY_ACCTS */

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

Line 4551: Delete from CST_PAC_EAM_BALANCE_BY_ACCTS

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