eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PACEAMCOST_GRP dependencies on CST_PAC_EAM_PERIOD_BALANCES

Line 723: -- |-- Update estimation columns of cst_pac_eam_period_balances to 0

719: -- Flow:
720: -- |-- Get estimation details of the wip_entity LOOP
721: -- | |--Update amount in cst_pac_eam_asset_per_balances
722: -- | End Loop;
723: -- |-- Update estimation columns of cst_pac_eam_period_balances to 0
724: -- |-- Delete the row in cst_pac_eam_period_balances if estimation and
725: -- | actual cost columns are 0 or null
726: -- |-- Similarly delete the row in cst_pac_eam_asset_per_balances if
727: -- | estimation and actual cost columns are 0 or null

Line 724: -- |-- Delete the row in cst_pac_eam_period_balances if estimation and

720: -- |-- Get estimation details of the wip_entity LOOP
721: -- | |--Update amount in cst_pac_eam_asset_per_balances
722: -- | End Loop;
723: -- |-- Update estimation columns of cst_pac_eam_period_balances to 0
724: -- |-- Delete the row in cst_pac_eam_period_balances if estimation and
725: -- | actual cost columns are 0 or null
726: -- |-- Similarly delete the row in cst_pac_eam_asset_per_balances if
727: -- | estimation and actual cost columns are 0 or null
728: --

Line 820: FROM cst_pac_eam_period_balances

816: maint_cost_category,
817: sum(NVL(system_estimated_mat_cost,0)) sys_mat,
818: sum(NVL(system_estimated_lab_cost,0)) sys_lab,
819: sum(NVL(system_estimated_eqp_cost,0)) sys_eqp
820: FROM cst_pac_eam_period_balances
821: WHERE wip_entity_id = c_wip_entity_id
822: AND organization_id = c_organization_id
823: AND legal_entity_id = p_legal_entity_id
824: AND cost_group_id = p_cost_group_id

Line 954: UPDATE cst_pac_eam_period_balances

950: END IF;
951:
952: -- Update cpepb estimates to zeros
953: FORALL l_index IN p_wip_entity_id_tab.FIRST..p_wip_entity_id_tab.LAST
954: UPDATE cst_pac_eam_period_balances
955: SET system_estimated_mat_cost = 0,
956: system_estimated_lab_cost = 0,
957: system_estimated_eqp_cost = 0
958: WHERE wip_entity_id = p_wip_entity_id_tab(l_index)

Line 975: DELETE FROM cst_pac_eam_period_balances

971: END IF;
972:
973: -- Delete cpepb rows with zeros in ALL value columns
974: FORALL l_index IN p_wip_entity_id_tab.FIRST..p_wip_entity_id_tab.LAST
975: DELETE FROM cst_pac_eam_period_balances
976: WHERE actual_mat_cost = 0
977: AND NVL(actual_lab_cost,0) = 0
978: AND NVL(actual_eqp_cost,0) = 0
979: AND NVL(system_estimated_mat_cost,0) = 0

Line 2826: -- |-- Insert/update CST_PAC_EAM_PERIOD_BALANCES

2822: -- | | |-- l_column := 'system_estimated_mat_cost';
2823: -- | | |-- l_col_type := 23;
2824: -- | | END IF;
2825: -- | END IF;
2826: -- |-- Insert/update CST_PAC_EAM_PERIOD_BALANCES
2827: -- | |-- Check if txn record already existing CST_PAC_EAM_PERIOD_BALANCES
2828: -- | | |-- If yes then UPDATE estimation details
2829: -- | | |-- Else Insert estimation details
2830: -- |-- Insert into asset period balances, call InsertUpdate_pac_assetPerBal

Line 2827: -- | |-- Check if txn record already existing CST_PAC_EAM_PERIOD_BALANCES

2823: -- | | |-- l_col_type := 23;
2824: -- | | END IF;
2825: -- | END IF;
2826: -- |-- Insert/update CST_PAC_EAM_PERIOD_BALANCES
2827: -- | |-- Check if txn record already existing CST_PAC_EAM_PERIOD_BALANCES
2828: -- | | |-- If yes then UPDATE estimation details
2829: -- | | |-- Else Insert estimation details
2830: -- |-- Insert into asset period balances, call InsertUpdate_pac_assetPerBal
2831: --

Line 2866: -- values into CST_PAC_EAM_PERIOD_BALANCES

2862: -- x_msg_data OUT VARCHAR2(2000)
2863: -- Version : Current version 1.0
2864: --
2865: -- Notes : This procedure inserts actuals (p_value_type = 1) or estimated (p_value_type = 2)
2866: -- values into CST_PAC_EAM_PERIOD_BALANCES
2867: --
2868: -- End of comments
2869:
2870: PROCEDURE InsertUpdate_PAC_eamPerBal (

Line 3065: -- Insert/update cst_pac_eam_period_balances --

3061: END IF;
3062: END IF;
3063:
3064: -----------------------------------------------
3065: -- Insert/update cst_pac_eam_period_balances --
3066: -----------------------------------------------
3067: SELECT count(*)
3068: INTO l_count
3069: FROM cst_pac_eam_period_balances

Line 3069: FROM cst_pac_eam_period_balances

3065: -- Insert/update cst_pac_eam_period_balances --
3066: -----------------------------------------------
3067: SELECT count(*)
3068: INTO l_count
3069: FROM cst_pac_eam_period_balances
3070: WHERE period_set_name = l_period_set_name
3071: AND period_name = l_period_name
3072: AND pac_period_id = l_period_id
3073: AND organization_id = p_organization_id

Line 3090: l_statement := 'UPDATE cst_pac_eam_period_balances SET '

3086:
3087: l_stmt_num := 420;
3088:
3089: -- Building the statement before to improve performance
3090: l_statement := 'UPDATE cst_pac_eam_period_balances SET '
3091: || l_column || '=' || 'nvl('|| l_column || ',0) + nvl(:p_value,0)'
3092: || ', last_update_date = sysdate'
3093: || ', last_updated_by = :p_user_id'
3094: || ', last_update_login = :p_login_id'

Line 3126: INSERT INTO cst_pac_eam_period_balances (

3122: ELSE -- Else, no records found, so Insert
3123:
3124: l_stmt_num := 430;
3125:
3126: INSERT INTO cst_pac_eam_period_balances (
3127: legal_entity_id,
3128: cost_group_id,
3129: cost_type_id,
3130: period_set_name,