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.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on HR_GENERAL

Line 90: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');

86: lv_gre_heading VARCHAR2(200);
87:
88: BEGIN
89:
90: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
91: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
92: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
93: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
94: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');

Line 91: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');

87:
88: BEGIN
89:
90: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
91: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
92: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
93: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
94: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');
95:

Line 92: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');

88: BEGIN
89:
90: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
91: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
92: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
93: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
94: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');
95:
96: lv_format1 :=

Line 93: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');

89:
90: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
91: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
92: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
93: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
94: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');
95:
96: lv_format1 :=
97: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading

Line 94: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');

90: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
91: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
92: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
93: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
94: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');
95:
96: lv_format1 :=
97: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading
98: ,p_bold => 'Y'

Line 132: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');

128: lv_pre_heading VARCHAR2(200);
129:
130: BEGIN
131:
132: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
133: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
134: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
135: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
136: lv_pre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','PRE');

Line 133: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');

129:
130: BEGIN
131:
132: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
133: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
134: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
135: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
136: lv_pre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','PRE');
137:

Line 134: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');

130: BEGIN
131:
132: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
133: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
134: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
135: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
136: lv_pre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','PRE');
137:
138: lv_format1 :=

Line 135: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');

131:
132: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
133: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
134: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
135: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
136: lv_pre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','PRE');
137:
138: lv_format1 :=
139: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading

Line 136: lv_pre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','PRE');

132: lv_year_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','YEAR');
133: lv_emp_sin_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_SIN');
134: lv_emp_num_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NUM');
135: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
136: lv_pre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','PRE');
137:
138: lv_format1 :=
139: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading
140: ,p_bold => 'Y'

Line 239: lvc_message := hr_general.decode_lookup ('PAY_CA_MISSING_ASG','NO_MISSING_ASG');

235: IS
236: lvc_message VARCHAR2(200);
237: BEGIN
238: -- lvc_message := 'The Year End Preprocess Archive has no missing assignments';
239: lvc_message := hr_general.decode_lookup ('PAY_CA_MISSING_ASG','NO_MISSING_ASG');
240:
241: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
242:
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 266: lvc_message1 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_CREATED')||': '||assignment_set_name;

262: lvc_message3 VARCHAR2(400);
263:
264: BEGIN
265: if assign_set_created = 1 then
266: lvc_message1 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_CREATED')||': '||assignment_set_name;
267: else
268: lvc_message1 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_NAME')||': '||assignment_set_name;
269: end if;
270:

Line 268: lvc_message1 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_NAME')||': '||assignment_set_name;

264: BEGIN
265: if assign_set_created = 1 then
266: lvc_message1 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_CREATED')||': '||assignment_set_name;
267: else
268: lvc_message1 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_NAME')||': '||assignment_set_name;
269: end if;
270:
271: lvc_message2 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_ID')||': '||to_char(assignment_set_id);
272: lvc_message3 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','NUMBER_OF_ASG')||': '||to_char(record_count);

Line 271: lvc_message2 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_ID')||': '||to_char(assignment_set_id);

267: else
268: lvc_message1 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_NAME')||': '||assignment_set_name;
269: end if;
270:
271: lvc_message2 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_ID')||': '||to_char(assignment_set_id);
272: lvc_message3 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','NUMBER_OF_ASG')||': '||to_char(record_count);
273:
274: if output_file_type ='HTML' then
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

Line 272: lvc_message3 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','NUMBER_OF_ASG')||': '||to_char(record_count);

268: lvc_message1 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_NAME')||': '||assignment_set_name;
269: end if;
270:
271: lvc_message2 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_ID')||': '||to_char(assignment_set_id);
272: lvc_message3 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','NUMBER_OF_ASG')||': '||to_char(record_count);
273:
274: if output_file_type ='HTML' then
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

Line 576: gv_title := hr_general.decode_lookup('PAY_CA_MISSING_ASG','MISSING_REPORT_HEADING');

572: lv_assignment_amd_exists :=0;
573: lv_effective_date := FND_DATE.canonical_to_date(p_effective_date);
574:
575: -- 'Year End Archive Missing Assignments Report'
576: gv_title := hr_general.decode_lookup('PAY_CA_MISSING_ASG','MISSING_REPORT_HEADING');
577:
578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
579: pay_us_payroll_utils.formated_header_string(gv_title || ' - '|| p_report_type ||' '||
580: to_char(lv_effective_date,'YYYY'), p_output_file_type ));