APPS.CST_EAMCOST_PUB dependencies on CST_EAM_BALANCE_BY_ACCOUNTS

Line 2450: -- CST_EAM_BALANCE_BY_ACCOUNTS table, for --

2446: -- HISTORY:
2447: --
2448: -- 03/29/05 Anjali R Added call to Insert_eamBalAcct() to --
2449: -- insert estimation details into --
2450: -- CST_EAM_BALANCE_BY_ACCOUNTS table, for --
2451: -- eAM Requirements Project - R12. --
2452: --
2453: -- 04/17/01 Hemant G Created --
2454: ----------------------------------------------------------------------------

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

9395:
9396: --------------------------------------------------------------------------
9397: -- API name : Insert_eamBalAcct
9398: -- Type : Public
9399: -- Description : This API inserts data in CST_EAM_BALANCE_BY_ACCOUNTS
9400: -- table.
9401: --
9402: -- HISTORY
9403: -- 04/29/05 Anjali R Added as part of eAM Requirements Project (R12)

Line 9504: MERGE INTO CST_EAM_BALANCE_BY_ACCOUNTS cebba

9500: x_return_status := FND_API.G_RET_STS_SUCCESS;
9501:
9502: /* Update the record if already exists else insert a new one */
9503:
9504: MERGE INTO CST_EAM_BALANCE_BY_ACCOUNTS cebba
9505: USING
9506: (
9507: SELECT NULL FROM DUAL
9508: )

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

9642:
9643: -------------------------------------------------------------------------------
9644: -- API name : Delete_eamBalAcct
9645: -- Type : Public
9646: -- Function : This API deletes data from CST_EAM_BALANCE_BY_ACCOUNTS
9647: -- table for the given wip_entity_id.
9648: --
9649: -- History :
9650: -- 03/29/05 Anjali R Added as part of eAM requirements Project (R12)

Line 9703: /* Delete data from CST_EAM_BALANCE_BY_ACCOUNTS */

9699: x_return_status := FND_API.G_RET_STS_SUCCESS;
9700:
9701: l_stmt_num := 10;
9702:
9703: /* Delete data from CST_EAM_BALANCE_BY_ACCOUNTS */
9704: FORALL l_index IN p_entity_id_tab.FIRST..p_entity_id_tab.LAST
9705: Delete from CST_EAM_BALANCE_BY_ACCOUNTS
9706: where wip_entity_id = p_entity_id_tab(l_index)
9707: and organization_id=p_org_id;

Line 9705: Delete from CST_EAM_BALANCE_BY_ACCOUNTS

9701: l_stmt_num := 10;
9702:
9703: /* Delete data from CST_EAM_BALANCE_BY_ACCOUNTS */
9704: FORALL l_index IN p_entity_id_tab.FIRST..p_entity_id_tab.LAST
9705: Delete from CST_EAM_BALANCE_BY_ACCOUNTS
9706: where wip_entity_id = p_entity_id_tab(l_index)
9707: and organization_id=p_org_id;
9708:
9709: -- Standard check of p_commit.