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 90: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

86: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* BUG 11830805 */
87:
88:
89: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME', p_consolidation_set_name );
90: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
91:
92: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
93: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
94:

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

89: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME', p_consolidation_set_name );
90: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
91:
92: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
93: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
94:
95: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
96: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
97:

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

92: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
93: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
94:
95: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
96: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
97:
98: l_tag := pay_prl_xml_utils.getTag('CP_RECORD_COUNT',p_record_counter);
99: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
100:

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

95: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
96: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
97:
98: l_tag := pay_prl_xml_utils.getTag('CP_RECORD_COUNT',p_record_counter);
99: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
100:
101: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_NAME',p_report_name);
102: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
103:

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

98: l_tag := pay_prl_xml_utils.getTag('CP_RECORD_COUNT',p_record_counter);
99: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
100:
101: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_NAME',p_report_name);
102: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
103:
104: l_tag := pay_prl_xml_utils.getTag('CP_MODE_DESC',p_mode_desc);
105: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
106:

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

101: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_NAME',p_report_name);
102: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
103:
104: l_tag := pay_prl_xml_utils.getTag('CP_MODE_DESC',p_mode_desc);
105: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
106:
107: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE', p_report_date );
108: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
109:

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

104: l_tag := pay_prl_xml_utils.getTag('CP_MODE_DESC',p_mode_desc);
105: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
106:
107: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE', p_report_date );
108: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
109:
110: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
111: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
112:

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

107: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE', p_report_date );
108: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
109:
110: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
111: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
112:
113: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
114: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
115:

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

110: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
111: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
112:
113: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
114: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
115:
116: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
117: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
118:

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

113: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
114: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
115:
116: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
117: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
118:
119: end;
120:
121: --

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

139: l_tag varchar2(200);
140:
141: begin
142: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
143: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
144:
145: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
147:

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

142: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
143: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
144:
145: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
147:
148: l_tag := pay_prl_xml_utils.getTag('EFFECTIVE_DATE',p_effective_date);
149: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
150:

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

145: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
147:
148: l_tag := pay_prl_xml_utils.getTag('EFFECTIVE_DATE',p_effective_date);
149: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
150:
151: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
152: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
153:

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

148: l_tag := pay_prl_xml_utils.getTag('EFFECTIVE_DATE',p_effective_date);
149: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
150:
151: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
152: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
153:
154: l_tag := pay_prl_xml_utils.getTag('ACTION_TYPE',p_action_type);
155: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
156:

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

151: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
152: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
153:
154: l_tag := pay_prl_xml_utils.getTag('ACTION_TYPE',p_action_type);
155: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
156:
157: l_tag := pay_prl_xml_utils.getTag('ACTION_NUMBER',p_action_number);
158: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
159:

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

154: l_tag := pay_prl_xml_utils.getTag('ACTION_TYPE',p_action_type);
155: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
156:
157: l_tag := pay_prl_xml_utils.getTag('ACTION_NUMBER',p_action_number);
158: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
159:
160: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
161: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
162:

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

157: l_tag := pay_prl_xml_utils.getTag('ACTION_NUMBER',p_action_number);
158: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
159:
160: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
161: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
162:
163: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
164: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
165:

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

160: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
161: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
162:
163: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
164: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
165:
166: l_tag := pay_prl_xml_utils.getTag('EMPLOYEE_NUMBER',p_employee_number);
167: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
168:

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

163: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
164: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
165:
166: l_tag := pay_prl_xml_utils.getTag('EMPLOYEE_NUMBER',p_employee_number);
167: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
168:
169: l_tag := pay_prl_xml_utils.getTag('CF_ACTION_TYPE',p_action_type_meaning);
170: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
171:

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

166: l_tag := pay_prl_xml_utils.getTag('EMPLOYEE_NUMBER',p_employee_number);
167: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
168:
169: l_tag := pay_prl_xml_utils.getTag('CF_ACTION_TYPE',p_action_type_meaning);
170: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
171:
172: l_tag := pay_prl_xml_utils.getTag('CF_RECORD_COUNTER',p_record_counter);
173: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
174:

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

169: l_tag := pay_prl_xml_utils.getTag('CF_ACTION_TYPE',p_action_type_meaning);
170: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
171:
172: l_tag := pay_prl_xml_utils.getTag('CF_RECORD_COUNTER',p_record_counter);
173: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
174:
175: end append_group_data;
176:
177: --

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

473: and ' || l_locking_payroll_condition || ' ) order by ' || l_order_by;
474:
475:
476:
477: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
478: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
479:
480: l_tag :='';
481: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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

474:
475:
476:
477: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
478: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
479:
480: l_tag :='';
481: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
482:

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

477: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
478: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
479:
480: l_tag :='';
481: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
482:
483: l_tag := '';
484: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
485:

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

480: l_tag :='';
481: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
482:
483: l_tag := '';
484: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
485:
486: l_tag := '';
487: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
488:

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

483: l_tag := '';
484: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
485:
486: l_tag := '';
487: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
488:
489:
490: l_session_date := fnd_date.canonical_to_date(p_session_date_char);
491: l_start_date := fnd_date.canonical_to_date(p_start_date_char);

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

506:
507: cf_action_type := get_action_type(l_report_data.action_type);
508:
509: l_tag := '';
510: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
511:
512: append_group_data(
513: l_report_data.consolidation_set_name
514: ,l_report_data.payroll_name

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

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

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

530: end loop;
531: close csr_report_data;
532:
533: l_tag := '';
534: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
535:
536: --
537: --
538: --

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

553: ,l_template_name
554: );
555:
556: l_tag := '';
557: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
558:
559: p_xml := g_xml_data;
560:
561: end actions_not_processed;