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_PAYRPANP_XML_PKG dependencies on DBMS_LOB

Line 83: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

79: l_start_date_char := fnd_date.date_to_displaydate(p_start_date);
80: l_end_date_char := fnd_date.date_to_displaydate(p_end_date);
81:
82: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME', p_consolidation_set_name );
83: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
84:
85: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
86: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
87:

Line 86: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

82: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME', p_consolidation_set_name );
83: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
84:
85: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
86: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
87:
88: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
89: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
90:

Line 89: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

85: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
86: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
87:
88: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
89: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
90:
91: l_tag := pay_prl_xml_utils.getTag('CP_RECORD_COUNT',p_record_counter);
92: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
93:

Line 92: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

88: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
89: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
90:
91: l_tag := pay_prl_xml_utils.getTag('CP_RECORD_COUNT',p_record_counter);
92: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
93:
94: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_NAME',p_report_name);
95: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
96:

Line 95: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

91: l_tag := pay_prl_xml_utils.getTag('CP_RECORD_COUNT',p_record_counter);
92: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
93:
94: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_NAME',p_report_name);
95: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
96:
97: l_tag := pay_prl_xml_utils.getTag('CP_MODE_DESC',p_mode_desc);
98: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
99:

Line 98: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

94: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_NAME',p_report_name);
95: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
96:
97: l_tag := pay_prl_xml_utils.getTag('CP_MODE_DESC',p_mode_desc);
98: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
99:
100: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE', p_report_date );
101: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
102:

Line 101: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

97: l_tag := pay_prl_xml_utils.getTag('CP_MODE_DESC',p_mode_desc);
98: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
99:
100: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE', p_report_date );
101: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
102:
103: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
104: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
105:

Line 104: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

100: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE', p_report_date );
101: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
102:
103: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
104: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
105:
106: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
107: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
108:

Line 107: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

103: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
104: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
105:
106: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
107: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
108:
109: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
110: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
111:

Line 110: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

106: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
107: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
108:
109: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
110: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
111:
112: end;
113:
114: --

Line 136: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

132: l_tag varchar2(200);
133:
134: begin
135: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
136: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
137:
138: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
139: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
140:

Line 139: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

135: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
136: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
137:
138: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
139: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
140:
141: l_tag := pay_prl_xml_utils.getTag('EFFECTIVE_DATE',p_effective_date);
142: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
143:

Line 142: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

138: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
139: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
140:
141: l_tag := pay_prl_xml_utils.getTag('EFFECTIVE_DATE',p_effective_date);
142: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
143:
144: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
145: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
146:

Line 145: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

141: l_tag := pay_prl_xml_utils.getTag('EFFECTIVE_DATE',p_effective_date);
142: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
143:
144: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
145: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
146:
147: l_tag := pay_prl_xml_utils.getTag('ACTION_TYPE',p_action_type);
148: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
149:

Line 148: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

144: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
145: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
146:
147: l_tag := pay_prl_xml_utils.getTag('ACTION_TYPE',p_action_type);
148: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
149:
150: l_tag := pay_prl_xml_utils.getTag('ACTION_NUMBER',p_action_number);
151: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
152:

Line 151: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

147: l_tag := pay_prl_xml_utils.getTag('ACTION_TYPE',p_action_type);
148: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
149:
150: l_tag := pay_prl_xml_utils.getTag('ACTION_NUMBER',p_action_number);
151: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
152:
153: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
154: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
155:

Line 154: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

150: l_tag := pay_prl_xml_utils.getTag('ACTION_NUMBER',p_action_number);
151: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
152:
153: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
154: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
155:
156: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
157: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
158:

Line 157: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

153: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
154: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
155:
156: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
157: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
158:
159: l_tag := pay_prl_xml_utils.getTag('EMPLOYEE_NUMBER',p_employee_number);
160: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
161:

Line 160: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

156: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
157: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
158:
159: l_tag := pay_prl_xml_utils.getTag('EMPLOYEE_NUMBER',p_employee_number);
160: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
161:
162: l_tag := pay_prl_xml_utils.getTag('CF_ACTION_TYPE',p_action_type_meaning);
163: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
164:

Line 163: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

159: l_tag := pay_prl_xml_utils.getTag('EMPLOYEE_NUMBER',p_employee_number);
160: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
161:
162: l_tag := pay_prl_xml_utils.getTag('CF_ACTION_TYPE',p_action_type_meaning);
163: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
164:
165: l_tag := pay_prl_xml_utils.getTag('CF_RECORD_COUNTER',p_record_counter);
166: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
167:

Line 166: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

162: l_tag := pay_prl_xml_utils.getTag('CF_ACTION_TYPE',p_action_type_meaning);
163: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
164:
165: l_tag := pay_prl_xml_utils.getTag('CF_RECORD_COUNTER',p_record_counter);
166: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
167:
168: end append_group_data;
169:
170: --

Line 470: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);

466: and ' || l_locking_payroll_condition || ' ) order by ' || l_order_by;
467:
468:
469:
470: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
471: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
472:
473: l_tag :='';
474: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 471: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

467:
468:
469:
470: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
471: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
472:
473: l_tag :='';
474: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
475:

Line 474: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

470: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
471: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
472:
473: l_tag :='';
474: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
475:
476: l_tag := '';
477: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
478:

Line 477: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

473: l_tag :='';
474: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
475:
476: l_tag := '';
477: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
478:
479: l_tag := '';
480: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
481:

Line 480: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

476: l_tag := '';
477: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
478:
479: l_tag := '';
480: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
481:
482:
483: l_session_date := fnd_date.canonical_to_date(p_session_date_char);
484: l_start_date := fnd_date.canonical_to_date(p_start_date_char);

Line 503: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

499:
500: cf_action_type := get_action_type(l_report_data.action_type);
501:
502: l_tag := '';
503: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
504:
505: append_group_data(
506: l_report_data.consolidation_set_name
507: ,l_report_data.payroll_name

Line 521: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

517: );
518:
519:
520: l_tag := '';
521: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
522:
523: end loop;
524: close csr_report_data;
525:

Line 527: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

523: end loop;
524: close csr_report_data;
525:
526: l_tag := '';
527: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
528:
529: --
530: --
531: --

Line 550: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

546: ,l_template_name
547: );
548:
549: l_tag := '';
550: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
551:
552: p_xml := g_xml_data;
553:
554: end actions_not_processed;