DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_PKG dependencies on HR_GENERAL

Line 1180: l_check := hr_general.decode_lookup(p_lookup_type =>'PAY_BASIS',

1176: If csr_period_type%notfound then
1177: hr_utility.set_location('not a valid period type:'||l_proc,10);
1178: Close csr_period_type;
1179: -- Frequency passed is not a valid period type, checking the lookups
1180: l_check := hr_general.decode_lookup(p_lookup_type =>'PAY_BASIS',
1181: p_lookup_code => p_frequency);
1182: If l_check is null then
1183: hr_utility.set_location('not a valid sal basis :'||l_proc,20);
1184: l_check := hr_general.decode_lookup(p_lookup_type =>'FREQUENCY',

Line 1184: l_check := hr_general.decode_lookup(p_lookup_type =>'FREQUENCY',

1180: l_check := hr_general.decode_lookup(p_lookup_type =>'PAY_BASIS',
1181: p_lookup_code => p_frequency);
1182: If l_check is null then
1183: hr_utility.set_location('not a valid sal basis :'||l_proc,20);
1184: l_check := hr_general.decode_lookup(p_lookup_type =>'FREQUENCY',
1185: p_lookup_code => p_frequency);
1186: If l_check is null then
1187: hr_utility.set_location('not a valid assignment frequency :'||l_proc,30);
1188: RETURN -1;

Line 2970: l_log_context := HR_GENERAL.DECODE_POSITION_LATEST_NAME(g_budget_entities(pos_cnt).entity_id);

2966: --
2967: For pos_cnt in NVL(g_budget_entities.FIRST,0)..NVL(g_budget_entities.LAST,-1) Loop
2968: --
2969: If p_budgeted_entity_cd = 'POSITION' then
2970: l_log_context := HR_GENERAL.DECODE_POSITION_LATEST_NAME(g_budget_entities(pos_cnt).entity_id);
2971: elsif p_budgeted_entity_cd ='JOB' then
2972: l_log_context := HR_GENERAL.DECODE_JOB(g_budget_entities(pos_cnt).entity_id);
2973: elsif p_budgeted_entity_cd ='ORGANIZATION' then
2974: l_log_context := HR_GENERAL.DECODE_ORGANIZATION(g_budget_entities(pos_cnt).entity_id);

Line 2972: l_log_context := HR_GENERAL.DECODE_JOB(g_budget_entities(pos_cnt).entity_id);

2968: --
2969: If p_budgeted_entity_cd = 'POSITION' then
2970: l_log_context := HR_GENERAL.DECODE_POSITION_LATEST_NAME(g_budget_entities(pos_cnt).entity_id);
2971: elsif p_budgeted_entity_cd ='JOB' then
2972: l_log_context := HR_GENERAL.DECODE_JOB(g_budget_entities(pos_cnt).entity_id);
2973: elsif p_budgeted_entity_cd ='ORGANIZATION' then
2974: l_log_context := HR_GENERAL.DECODE_ORGANIZATION(g_budget_entities(pos_cnt).entity_id);
2975: elsif p_budgeted_entity_cd ='GRADE' then
2976: l_log_context := HR_GENERAL.DECODE_GRADE(g_budget_entities(pos_cnt).entity_id);

Line 2974: l_log_context := HR_GENERAL.DECODE_ORGANIZATION(g_budget_entities(pos_cnt).entity_id);

2970: l_log_context := HR_GENERAL.DECODE_POSITION_LATEST_NAME(g_budget_entities(pos_cnt).entity_id);
2971: elsif p_budgeted_entity_cd ='JOB' then
2972: l_log_context := HR_GENERAL.DECODE_JOB(g_budget_entities(pos_cnt).entity_id);
2973: elsif p_budgeted_entity_cd ='ORGANIZATION' then
2974: l_log_context := HR_GENERAL.DECODE_ORGANIZATION(g_budget_entities(pos_cnt).entity_id);
2975: elsif p_budgeted_entity_cd ='GRADE' then
2976: l_log_context := HR_GENERAL.DECODE_GRADE(g_budget_entities(pos_cnt).entity_id);
2977: end if;
2978:

Line 2976: l_log_context := HR_GENERAL.DECODE_GRADE(g_budget_entities(pos_cnt).entity_id);

2972: l_log_context := HR_GENERAL.DECODE_JOB(g_budget_entities(pos_cnt).entity_id);
2973: elsif p_budgeted_entity_cd ='ORGANIZATION' then
2974: l_log_context := HR_GENERAL.DECODE_ORGANIZATION(g_budget_entities(pos_cnt).entity_id);
2975: elsif p_budgeted_entity_cd ='GRADE' then
2976: l_log_context := HR_GENERAL.DECODE_GRADE(g_budget_entities(pos_cnt).entity_id);
2977: end if;
2978:
2979: -- l_log_context := l_log_context||' ('||hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_budgeted_entity_cd)||' )';
2980: --

Line 2979: -- l_log_context := l_log_context||' ('||hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_budgeted_entity_cd)||' )';

2975: elsif p_budgeted_entity_cd ='GRADE' then
2976: l_log_context := HR_GENERAL.DECODE_GRADE(g_budget_entities(pos_cnt).entity_id);
2977: end if;
2978:
2979: -- l_log_context := l_log_context||' ('||hr_general.decode_lookup('PQH_BUDGET_ENTITY',p_budgeted_entity_cd)||' )';
2980: --
2981: pqh_process_batch_log.set_context_level
2982: (
2983: p_txn_id => g_budget_entities(pos_cnt).entity_id,

Line 3691: and bdgts.business_group_id = hr_general.get_business_group_id;

3687: and position_control_flag ='Y'
3688: and budgeted_entity_cd ='POSITION'
3689: and shtyps.shared_type_id = bdgts.budget_unit1_id
3690: and shtyps.system_type_cd ='MONEY'
3691: and bdgts.business_group_id = hr_general.get_business_group_id;
3692: --
3693: -- Obtain the frequency of the time periods for a calendar
3694: --
3695: Cursor csr_bdgt_cal_freq(p_period_set_name varchar2) is