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.PA_CC_TP_UTILS dependencies on PA_CC_TP_SCHEDULE_LINE_LKP

Line 142: delete from pa_cc_tp_schedule_line_lkp

138: v_recvr_org_level :='NULL';
139: end if;
140:
141: if v_prvdr_org_level='ORG' and v_recvr_org_level='ORG' then
142: delete from pa_cc_tp_schedule_line_lkp
143: where prvdr_organization_id=p_prvdr_organization_id
144: and recvr_organization_id=p_recvr_organization_id
145: and tp_schedule_id=p_tp_schedule_id;
146:

Line 150: delete from pa_cc_tp_schedule_line_lkp

146:
147: /* Commented for Legal Entity Changes. After 12.0 TP SCHEDULE WILL
148: LOOK only in ORG HIERARCHY AND NOT IN OU,LE,BG
149: elsif v_prvdr_org_level='ORG' and v_recvr_org_level='OU' then
150: delete from pa_cc_tp_schedule_line_lkp
151: where prvdr_organization_id=p_prvdr_organization_id
152: and recvr_org_id=p_recvr_organization_id
153: and tp_schedule_id=p_tp_schedule_id;
154:

Line 156: delete from pa_cc_tp_schedule_line_lkp

152: and recvr_org_id=p_recvr_organization_id
153: and tp_schedule_id=p_tp_schedule_id;
154:
155: elsif v_prvdr_org_level='ORG' and v_recvr_org_level='LE' then
156: delete from pa_cc_tp_schedule_line_lkp
157: where tp_schedule_id=p_tp_schedule_id
158: and prvdr_organization_id=p_prvdr_organization_id
159: and recvr_org_id in
160: ( select organization_id

Line 165: delete from pa_cc_tp_schedule_line_lkp

161: from hr_operating_units h
162: where h.legal_entity_id=to_char(p_recvr_organization_id));
163:
164: elsif (v_prvdr_org_level='ORG' and v_recvr_org_level='BG') then
165: delete from pa_cc_tp_schedule_line_lkp
166: where tp_schedule_id=p_tp_schedule_id
167: and prvdr_organization_id=p_prvdr_organization_id
168: and recvr_org_id in
169: (select organization_id

Line 174: delete from pa_cc_tp_schedule_line_lkp

170: from hr_operating_units h
171: where h.business_group_id =p_recvr_organization_id);*/
172:
173: elsif (v_prvdr_org_level='ORG' and v_recvr_org_level='NULL') then
174: delete from pa_cc_tp_schedule_line_lkp
175: where tp_schedule_id=p_tp_schedule_id
176: and PRVDR_ORGANIZATION_ID =p_prvdr_organization_id;
177:
178: /* Commented for Legal Entity Changes. After 12.0 TP SCHEDULE WILL

Line 181: delete from pa_cc_tp_schedule_line_lkp

177:
178: /* Commented for Legal Entity Changes. After 12.0 TP SCHEDULE WILL
179: LOOK only in ORG HIERARCHY AND NOT IN OU,LE,BG
180: elsif v_prvdr_org_level='OU' and v_recvr_org_level='OU' then
181: delete from pa_cc_tp_schedule_line_lkp
182: where prvdr_org_id=p_prvdr_organization_id
183: and recvr_org_id=p_recvr_organization_id
184: and tp_schedule_id=p_tp_schedule_id;
185:

Line 187: delete from pa_cc_tp_schedule_line_lkp

183: and recvr_org_id=p_recvr_organization_id
184: and tp_schedule_id=p_tp_schedule_id;
185:
186: elsif v_prvdr_org_level='OU' and v_recvr_org_level='LE' then
187: delete from pa_cc_tp_schedule_line_lkp
188: where tp_schedule_id=p_tp_schedule_id
189: and prvdr_org_id=p_prvdr_organization_id
190: and recvr_org_id in
191: ( select organization_id

Line 196: delete from pa_cc_tp_schedule_line_lkp

192: from hr_operating_units h
193: where h.legal_entity_id=to_char(p_recvr_organization_id));
194:
195: elsif (v_prvdr_org_level='OU' and v_recvr_org_level='BG') then
196: delete from pa_cc_tp_schedule_line_lkp
197: where tp_schedule_id=p_tp_schedule_id
198: and PRVDR_ORG_ID=p_prvdr_organization_id
199: and recvr_org_id in
200: (select organization_id

Line 205: delete from pa_cc_tp_schedule_line_lkp

201: from hr_operating_units h
202: where h.business_group_id =p_recvr_organization_id);
203:
204: elsif (v_prvdr_org_level='OU' and v_recvr_org_level='NULL') then
205: delete from pa_cc_tp_schedule_line_lkp
206: where tp_schedule_id=p_tp_schedule_id
207: and PRVDR_ORG_ID=p_prvdr_organization_id;
208:
209: elsif v_prvdr_org_level='LE' and v_recvr_org_level='LE' then

Line 210: delete from pa_cc_tp_schedule_line_lkp

206: where tp_schedule_id=p_tp_schedule_id
207: and PRVDR_ORG_ID=p_prvdr_organization_id;
208:
209: elsif v_prvdr_org_level='LE' and v_recvr_org_level='LE' then
210: delete from pa_cc_tp_schedule_line_lkp
211: where tp_schedule_id=p_tp_schedule_id
212: and prvdr_org_id in
213: (select organization_id
214: from hr_operating_units h

Line 221: delete from pa_cc_tp_schedule_line_lkp

217: (select organization_id
218: from hr_operating_units h
219: where h.legal_entity_id=to_char(p_recvr_organization_id));
220: elsif (v_prvdr_org_level='LE' and v_recvr_org_level='BG') then
221: delete from pa_cc_tp_schedule_line_lkp
222: where tp_schedule_id=p_tp_schedule_id
223: and prvdr_org_id in
224: (select organization_id
225: from hr_operating_units h

Line 232: delete from pa_cc_tp_schedule_line_lkp

228: (select organization_id from hr_operating_units h
229: where h.business_group_id=p_recvr_organization_id);
230:
231: elsif (v_prvdr_org_level='LE' and v_recvr_org_level='NULL') then
232: delete from pa_cc_tp_schedule_line_lkp
233: where tp_schedule_id=p_tp_schedule_id
234: and prvdr_org_id in
235: (select organization_id
236: from hr_operating_units h

Line 240: delete from pa_cc_tp_schedule_line_lkp

236: from hr_operating_units h
237: where h.legal_entity_id =to_char(p_prvdr_organization_id));
238:
239: elsif (v_prvdr_org_level='BG' and v_recvr_org_level='BG') then
240: delete from pa_cc_tp_schedule_line_lkp
241: where tp_schedule_id=p_tp_schedule_id
242: and prvdr_org_id in
243: (select organization_id
244: from hr_operating_units h

Line 252: delete from pa_cc_tp_schedule_line_lkp

248: from hr_operating_units h
249: where h.business_group_id =p_recvr_organization_id);
250:
251: elsif (v_prvdr_org_level='BG' and v_recvr_org_level='NULL') then
252: delete from pa_cc_tp_schedule_line_lkp
253: where tp_schedule_id=p_tp_schedule_id
254: and prvdr_org_id in
255: (select organization_id
256: from hr_operating_units h

Line 267: delete from pa_cc_tp_schedule_line_lkp

263: -- would give the maximum level to which an org is defined, the following cases arise
264: --
265:
266: elsif (v_prvdr_org_level = 'BG' and v_recvr_org_level = 'LE') then
267: delete from pa_cc_tp_schedule_line_lkp
268: where tp_schedule_id=p_tp_schedule_id
269: and prvdr_org_id in
270: (select organization_id
271: from hr_operating_units h

Line 279: delete from pa_cc_tp_schedule_line_lkp

275: from hr_operating_units h
276: where h.legal_entity_id= to_char(p_prvdr_organization_id));
277:
278: elsif (v_prvdr_org_level = 'BG' and v_recvr_org_level = 'OU') then
279: delete from pa_cc_tp_schedule_line_lkp
280: where tp_schedule_id=p_tp_schedule_id
281: and prvdr_org_id in
282: (select organization_id
283: from hr_operating_units h

Line 288: delete from pa_cc_tp_schedule_line_lkp

284: where h.business_group_id =p_prvdr_organization_id)
285: and recvr_org_id =p_recvr_organization_id;
286:
287: elsif (v_prvdr_org_level = 'BG' and v_recvr_org_level = 'ORG') then
288: delete from pa_cc_tp_schedule_line_lkp
289: where tp_schedule_id=p_tp_schedule_id
290: and prvdr_org_id in
291: (select organization_id
292: from hr_operating_units h

Line 297: delete from pa_cc_tp_schedule_line_lkp

293: where h.business_group_id =p_prvdr_organization_id)
294: and recvr_organization_id =p_recvr_organization_id;
295:
296: elsif (v_prvdr_org_level = 'LE' and v_recvr_org_level = 'OU') then
297: delete from pa_cc_tp_schedule_line_lkp
298: where tp_schedule_id=p_tp_schedule_id
299: and prvdr_org_id in
300: (select organization_id
301: from hr_operating_units h

Line 305: delete from pa_cc_tp_schedule_line_lkp

301: from hr_operating_units h
302: where h.legal_entity_id=to_char(p_prvdr_organization_id))
303: and recvr_org_id = p_recvr_organization_id ;
304: elsif (v_prvdr_org_level = 'LE' and v_recvr_org_level = 'ORG') then
305: delete from pa_cc_tp_schedule_line_lkp
306: where tp_schedule_id=p_tp_schedule_id
307: and prvdr_org_id in
308: (select organization_id
309: from hr_operating_units h

Line 313: delete from pa_cc_tp_schedule_line_lkp

309: from hr_operating_units h
310: where h.legal_entity_id=to_char(p_prvdr_organization_id))
311: and recvr_organization_id = p_recvr_organization_id ;
312: elsif (v_prvdr_org_level = 'OU' and v_recvr_org_level = 'ORG') then
313: delete from pa_cc_tp_schedule_line_lkp
314: where tp_schedule_id=p_tp_schedule_id
315: and prvdr_org_id = p_prvdr_organization_id
316: and recvr_organization_id = p_recvr_organization_id ; End of 4654754 */
317: else

Line 333: delete from pa_cc_tp_schedule_line_lkp

329: procedure pre_delete_schedule_lines(p_tp_schedule_id in number,
330: p_tp_schedule_line_id in number)
331: is
332: begin
333: delete from pa_cc_tp_schedule_line_lkp
334: where tp_schedule_id=p_tp_schedule_id
335: and tp_schedule_line_id=p_tp_schedule_line_id;
336:
337: end pre_delete_schedule_lines;