APPS.CST_EAMCOST_PUB dependencies on CST_EAM_BALANCE_BY_ACCOUNTS

Line 2672: -- CST_EAM_BALANCE_BY_ACCOUNTS table, for --

2668: -- HISTORY:
2669: --
2670: -- 03/29/05 Anjali R Added call to Insert_eamBalAcct() to --
2671: -- insert estimation details into --
2672: -- CST_EAM_BALANCE_BY_ACCOUNTS table, for --
2673: -- eAM Requirements Project - R12. --
2674: --
2675: -- 04/17/01 Hemant G Created --
2676: ----------------------------------------------------------------------------

Line 10112: -- Description : This API inserts data in CST_EAM_BALANCE_BY_ACCOUNTS

10108:
10109: --------------------------------------------------------------------------
10110: -- API name : Insert_eamBalAcct
10111: -- Type : Public
10112: -- Description : This API inserts data in CST_EAM_BALANCE_BY_ACCOUNTS
10113: -- table.
10114: --
10115: -- HISTORY
10116: -- 04/29/05 Anjali R Added as part of eAM Requirements Project (R12)

Line 10217: MERGE INTO CST_EAM_BALANCE_BY_ACCOUNTS cebba

10213: x_return_status := FND_API.G_RET_STS_SUCCESS;
10214:
10215: /* Update the record if already exists else insert a new one */
10216:
10217: MERGE INTO CST_EAM_BALANCE_BY_ACCOUNTS cebba
10218: USING
10219: (
10220: SELECT NULL FROM DUAL
10221: )

Line 10359: -- Function : This API deletes data from CST_EAM_BALANCE_BY_ACCOUNTS

10355:
10356: -------------------------------------------------------------------------------
10357: -- API name : Delete_eamBalAcct
10358: -- Type : Public
10359: -- Function : This API deletes data from CST_EAM_BALANCE_BY_ACCOUNTS
10360: -- table for the given wip_entity_id.
10361: --
10362: -- History :
10363: -- 03/29/05 Anjali R Added as part of eAM requirements Project (R12)

Line 10416: /* Delete data from CST_EAM_BALANCE_BY_ACCOUNTS */

10412: x_return_status := FND_API.G_RET_STS_SUCCESS;
10413:
10414: l_stmt_num := 10;
10415:
10416: /* Delete data from CST_EAM_BALANCE_BY_ACCOUNTS */
10417: FORALL l_index IN p_entity_id_tab.FIRST..p_entity_id_tab.LAST
10418: Delete from CST_EAM_BALANCE_BY_ACCOUNTS
10419: where wip_entity_id = p_entity_id_tab(l_index)
10420: and organization_id=p_org_id;

Line 10418: Delete from CST_EAM_BALANCE_BY_ACCOUNTS

10414: l_stmt_num := 10;
10415:
10416: /* Delete data from CST_EAM_BALANCE_BY_ACCOUNTS */
10417: FORALL l_index IN p_entity_id_tab.FIRST..p_entity_id_tab.LAST
10418: Delete from CST_EAM_BALANCE_BY_ACCOUNTS
10419: where wip_entity_id = p_entity_id_tab(l_index)
10420: and organization_id=p_org_id;
10421:
10422: -- Standard check of p_commit.