APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_CM_TYP_F

Line 12938: -- and tr.where_clause = l_BEN_CM_TYP_F

12934: from ben_copy_entity_results cpe,
12935: pqh_table_route tr
12936: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12937: and cpe.table_route_id = tr.table_route_id
12938: -- and tr.where_clause = l_BEN_CM_TYP_F
12939: and tr.table_alias = l_table_alias
12940: and cpe.number_of_copies = 1 --ADDITION
12941: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12942: order by information1, information2; --added for bug: 5151945

Line 12976: from BEN_CM_TYP_F CCT

12972: c_business_group_id number,
12973: c_new_pk_id number) is
12974: select
12975: CCT.cm_typ_id new_value
12976: from BEN_CM_TYP_F CCT
12977: where CCT.name = c_CCT_name
12978: and CCT.business_group_id = c_business_group_id
12979: and CCT.cm_typ_id <> c_new_pk_id
12980: --TEMPIK

Line 12986: from BEN_CM_TYP_F CCT1

12982: and effective_end_date ;
12983: --END TEMPIK
12984: /*TEMPIK
12985: and exists ( select null
12986: from BEN_CM_TYP_F CCT1
12987: where CCT1.name = c_CCT_name
12988: and CCT1.business_group_id = c_business_group_id
12989: and CCT1.effective_start_date <= c_effective_start_date )
12990: and exists ( select null

Line 12991: from BEN_CM_TYP_F CCT2

12987: where CCT1.name = c_CCT_name
12988: and CCT1.business_group_id = c_business_group_id
12989: and CCT1.effective_start_date <= c_effective_start_date )
12990: and exists ( select null
12991: from BEN_CM_TYP_F CCT2
12992: where CCT2.name = c_CCT_name
12993: and CCT2.business_group_id = c_business_group_id
12994: and CCT2.effective_end_date >= c_effective_end_date )
12995: ;

Line 13116: (p_base_table_name => 'BEN_CM_TYP_F',

13112: if c_find_CCT_in_target%found then
13113: --
13114: --TEMPIK
13115: l_dt_rec_found := dt_api.check_min_max_dates
13116: (p_base_table_name => 'BEN_CM_TYP_F',
13117: p_base_key_column => 'CM_TYP_ID',
13118: p_base_key_value => l_new_value,
13119: p_from_date => l_min_esd,
13120: p_to_date => l_max_eed );

Line 13179: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CM_TYP_F',l_prefix || r_CCT.INFORMATION170 || l_suffix);

13175: l_INSPN_RQD_RL := get_fk('FORMULA_ID', r_CCT.INFORMATION263,l_dml_operation);
13176: l_PARNT_CM_TYP_ID := get_fk('PARNT_CM_TYP_ID', r_CCT.INFORMATION260,l_dml_operation);
13177: l_TO_BE_SENT_DT_RL := get_fk('FORMULA_ID', r_CCT.INFORMATION264,l_dml_operation);
13178: --
13179: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CM_TYP_F',l_prefix || r_CCT.INFORMATION170 || l_suffix);
13180: --
13181:
13182: l_effective_date := r_CCT.information2;
13183: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 13190: hr_utility.set_location(' BEN_CM_TYP_F CREATE_COMP_COMM_TYPES ',20);

13186: end if;
13187:
13188: if l_first_rec and not l_update then
13189: -- Call Create routine.
13190: hr_utility.set_location(' BEN_CM_TYP_F CREATE_COMP_COMM_TYPES ',20);
13191: BEN_COMP_COMM_TYPES_API.CREATE_COMP_COMM_TYPES(
13192: --
13193: P_VALIDATE => false
13194: ,P_EFFECTIVE_DATE => l_effective_date

Line 13293: hr_utility.set_location(' BEN_CM_TYP_F UPDATE_COMP_COMM_TYPES ',30);

13289: IF l_update OR l_dml_operation <> 'UPDATE' THEN
13290: --UPD END
13291: -- Call Update routine for the pk_id created in prev run .
13292: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
13293: hr_utility.set_location(' BEN_CM_TYP_F UPDATE_COMP_COMM_TYPES ',30);
13294: BEN_COMP_COMM_TYPES_API.UPDATE_COMP_COMM_TYPES(
13295: --
13296: P_VALIDATE => false
13297: ,P_EFFECTIVE_DATE => l_effective_date