DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on CST_EAM_ROLLUP_TEMP

Line 5612: INSERT INTO cst_eam_rollup_temp

5608:
5609: /* Inserted maintenance_object_id and maintenance_object_type from CEAPB as
5610: part of eAM Requirements Project - R12. */
5611:
5612: INSERT INTO cst_eam_rollup_temp
5613: (group_id,
5614: period_set_name,
5615: period_name,
5616: inventory_item_id,

Line 5693: FROM cst_eam_rollup_temp

5689: ---------------------------------------------------------------------------
5690: -- Check if there is anything inserted
5691: ---------------------------------------------------------------------------
5692: SELECT count(*) INTO l_count
5693: FROM cst_eam_rollup_temp
5694: WHERE group_id = x_group_id;
5695:
5696: l_statement := 100;
5697: ---------------------------------------------------------------------------

Line 5701: l_api_message := 'No row is inserted into CST_EAM_ROLLUP_TEMP';

5697: ---------------------------------------------------------------------------
5698: -- If nothing, raise error
5699: ---------------------------------------------------------------------------
5700: IF (l_count = 0) THEN
5701: l_api_message := 'No row is inserted into CST_EAM_ROLLUP_TEMP';
5702: fnd_msg_pub.add_exc_msg
5703: ( G_PKG_NAME,
5704: l_api_name,
5705: l_api_message );

Line 5763: -- cst_eam_rollup_temp

5759: -- Parameters
5760: -- IN :
5761: -- p_group_id IN VARCHAR2 Required
5762: -- group_id in cst_eam_hierarchy_snapshot
5763: -- cst_eam_rollup_temp
5764: --
5765: -- Version :
5766: --
5767: -- history :

Line 5830: -- Pruge cst_eam_rollup_temp

5826: DELETE cst_eam_hierarchy_snapshot
5827: WHERE group_id= p_group_id;
5828:
5829: -------------------------------------------------------------
5830: -- Pruge cst_eam_rollup_temp
5831: -------------------------------------------------------------
5832: l_statement := 50;
5833: DELETE cst_eam_rollup_temp
5834: WHERE group_id= p_group_id;

Line 5833: DELETE cst_eam_rollup_temp

5829: -------------------------------------------------------------
5830: -- Pruge cst_eam_rollup_temp
5831: -------------------------------------------------------------
5832: l_statement := 50;
5833: DELETE cst_eam_rollup_temp
5834: WHERE group_id= p_group_id;
5835:
5836: ---------------------------------------------------------------------------
5837: -- Standard check of p_commit