APPS.PQH_PQUBGTEN_XMLP_PKG dependencies on HR_GENERAL

Line 34: cp_bg_name := hr_general.decode_organization(p_business_group_id);

30: begin
31: P_EFFECTIVE_DATE_T := to_char(P_EFFECTIVE_DATE,'DD-MON-YYYY');
32: --hr_standard.event('BEFORE REPORT');
33:
34: cp_bg_name := hr_general.decode_organization(p_business_group_id);
35: CP_REPORT_TITLE:= hr_general.decode_lookup('PQH_REPORT_TITLES','PQHWSUBE');
36: If p_org_structure_id IS NOT NULL THEN
37: OPEN csr_org_struct_name;
38: FETCH csr_org_struct_name INTO l_org_struct_name;

Line 35: CP_REPORT_TITLE:= hr_general.decode_lookup('PQH_REPORT_TITLES','PQHWSUBE');

31: P_EFFECTIVE_DATE_T := to_char(P_EFFECTIVE_DATE,'DD-MON-YYYY');
32: --hr_standard.event('BEFORE REPORT');
33:
34: cp_bg_name := hr_general.decode_organization(p_business_group_id);
35: CP_REPORT_TITLE:= hr_general.decode_lookup('PQH_REPORT_TITLES','PQHWSUBE');
36: If p_org_structure_id IS NOT NULL THEN
37: OPEN csr_org_struct_name;
38: FETCH csr_org_struct_name INTO l_org_struct_name;
39: CLOSE csr_org_struct_name;

Line 43: cp_start_org_name := hr_general.decode_organization(p_start_org_id);

39: CLOSE csr_org_struct_name;
40: cp_org_structure_name := l_org_struct_name;
41: End If;
42: If p_start_org_id IS NOT NULL THEN
43: cp_start_org_name := hr_general.decode_organization(p_start_org_id);
44: End If;
45: OPEN csr_entity_name;
46: FETCH csr_entity_name INTO l_entity_name;
47: CLOSE csr_entity_name;

Line 49: cp_uom := hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',P_UNIT_OF_MEASURE);

45: OPEN csr_entity_name;
46: FETCH csr_entity_name INTO l_entity_name;
47: CLOSE csr_entity_name;
48: cp_entity_name := l_entity_name;
49: cp_uom := hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',P_UNIT_OF_MEASURE);
50: pqh_budget_analysis_pkg.get_entity(
51: errbuf,
52: retcode,
53: p_batch_name,

Line 121: l_currency_code := hr_general.default_currency_code(p_business_group_id => p_business_group_id);

117: SELECT bg.legislation_code
118: FROM per_business_groups_perf bg
119: WHERE bg.business_group_id = p_business_group_id;
120: begin
121: l_currency_code := hr_general.default_currency_code(p_business_group_id => p_business_group_id);
122: IF l_currency_code IS NULL THEN
123: OPEN csr_leg_code;
124: FETCH csr_leg_code INTO l_leg_code;
125: CLOSE csr_leg_code;

Line 126: l_currency_code := hr_general.default_currency_code(p_legislation_code => l_leg_code);

122: IF l_currency_code IS NULL THEN
123: OPEN csr_leg_code;
124: FETCH csr_leg_code INTO l_leg_code;
125: CLOSE csr_leg_code;
126: l_currency_code := hr_general.default_currency_code(p_legislation_code => l_leg_code);
127: END IF;
128: IF uom = 'MONEY' and l_currency_code IS NOT NULL THEN
129: l_format_mask := fnd_currency.get_format_mask(l_currency_code,22);
130: ELSE