APPS.CST_EAMCOST_PUB dependencies on CST_EAM_ROLLUP_TEMP

Line 5319: INSERT INTO cst_eam_rollup_temp

5315:
5316: /* Inserted maintenance_object_id and maintenance_object_type from CEAPB as
5317: part of eAM Requirements Project - R12. */
5318:
5319: INSERT INTO cst_eam_rollup_temp
5320: (group_id,
5321: period_set_name,
5322: period_name,
5323: inventory_item_id,

Line 5397: FROM cst_eam_rollup_temp

5393: ---------------------------------------------------------------------------
5394: -- Check if there is anything inserted
5395: ---------------------------------------------------------------------------
5396: SELECT count(*) INTO l_count
5397: FROM cst_eam_rollup_temp
5398: WHERE group_id = x_group_id;
5399:
5400: l_statement := 100;
5401: ---------------------------------------------------------------------------

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

5401: ---------------------------------------------------------------------------
5402: -- If nothing, raise error
5403: ---------------------------------------------------------------------------
5404: IF (l_count = 0) THEN
5405: l_api_message := 'No row is inserted into CST_EAM_ROLLUP_TEMP';
5406: fnd_msg_pub.add_exc_msg
5407: ( G_PKG_NAME,
5408: l_api_name,
5409: l_api_message );

Line 5467: -- cst_eam_rollup_temp

5463: -- Parameters
5464: -- IN :
5465: -- p_group_id IN VARCHAR2 Required
5466: -- group_id in cst_eam_hierarchy_snapshot
5467: -- cst_eam_rollup_temp
5468: --
5469: -- Version :
5470: --
5471: -- history :

Line 5534: -- Pruge cst_eam_rollup_temp

5530: DELETE cst_eam_hierarchy_snapshot
5531: WHERE group_id= p_group_id;
5532:
5533: -------------------------------------------------------------
5534: -- Pruge cst_eam_rollup_temp
5535: -------------------------------------------------------------
5536: l_statement := 50;
5537: DELETE cst_eam_rollup_temp
5538: WHERE group_id= p_group_id;

Line 5537: DELETE cst_eam_rollup_temp

5533: -------------------------------------------------------------
5534: -- Pruge cst_eam_rollup_temp
5535: -------------------------------------------------------------
5536: l_statement := 50;
5537: DELETE cst_eam_rollup_temp
5538: WHERE group_id= p_group_id;
5539:
5540: ---------------------------------------------------------------------------
5541: -- Standard check of p_commit