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_FIN_PLAN_TYPES_UTILS dependencies on PA_FIN_PLAN_TYPES_B

Line 101: FROM pa_budget_types a, pa_fin_plan_types_b b

97: /*Commented out the sql for bug 2774573 */
98: /*
99: SELECT 'Y'
100: INTO l_exists
101: FROM pa_budget_types a, pa_fin_plan_types_b b
102: WHERE upper(budget_type) = upper(p_name)
103: AND b.fin_plan_type_id = p_fin_plan_type_id
104: AND a.budget_type_code <> b.migrated_frm_bdgt_typ_code;
105: */

Line 116: FROM pa_fin_plan_types_b f

112: INTO l_exists
113: FROM pa_budget_types a
114: WHERE upper(a.budget_type) = upper(p_name)
115: AND NOT EXISTS( SELECT 'x'
116: FROM pa_fin_plan_types_b f
117: WHERE f.fin_plan_type_id=p_fin_plan_type_id
118: AND nvl
119: (f.migrated_frm_bdgt_typ_code,'-99')=a.budget_type_code);
120:

Line 169: pa_fin_plan_types_b.start_date_active%type,

165: /****************************************************************************************
166: Commented as part of Dusan changes and moved the api to PA_FIN_PLAN_UTILS
167: procedure end_date_active_val
168: (p_start_date_active IN
169: pa_fin_plan_types_b.start_date_active%type,
170: p_end_date_active IN
171: pa_fin_plan_types_b.end_date_active%type,
172: x_return_status OUT VARCHAR2,
173: x_msg_count OUT NUMBER,

Line 171: pa_fin_plan_types_b.end_date_active%type,

167: procedure end_date_active_val
168: (p_start_date_active IN
169: pa_fin_plan_types_b.start_date_active%type,
170: p_end_date_active IN
171: pa_fin_plan_types_b.end_date_active%type,
172: x_return_status OUT VARCHAR2,
173: x_msg_count OUT NUMBER,
174: x_msg_data OUT VARCHAR2)
175: is

Line 235: pa_fin_plan_types_b.fin_plan_type_id%type,

231: are obsolete after change in functionality
232:
233: procedure generated_flag_val
234: (p_fin_plan_type_id IN
235: pa_fin_plan_types_b.fin_plan_type_id%type,
236: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
237: p_pre_defined_flag IN
238: pa_fin_plan_types_b.pre_defined_flag%type,
239: p_fin_plan_type_code IN

Line 236: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,

232:
233: procedure generated_flag_val
234: (p_fin_plan_type_id IN
235: pa_fin_plan_types_b.fin_plan_type_id%type,
236: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
237: p_pre_defined_flag IN
238: pa_fin_plan_types_b.pre_defined_flag%type,
239: p_fin_plan_type_code IN
240: pa_fin_plan_types_b.fin_plan_type_code%type,

Line 238: pa_fin_plan_types_b.pre_defined_flag%type,

234: (p_fin_plan_type_id IN
235: pa_fin_plan_types_b.fin_plan_type_id%type,
236: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
237: p_pre_defined_flag IN
238: pa_fin_plan_types_b.pre_defined_flag%type,
239: p_fin_plan_type_code IN
240: pa_fin_plan_types_b.fin_plan_type_code%type,
241: p_name IN pa_fin_plan_types_tl.name%type,
242: x_return_status OUT VARCHAR2,

Line 240: pa_fin_plan_types_b.fin_plan_type_code%type,

236: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
237: p_pre_defined_flag IN
238: pa_fin_plan_types_b.pre_defined_flag%type,
239: p_fin_plan_type_code IN
240: pa_fin_plan_types_b.fin_plan_type_code%type,
241: p_name IN pa_fin_plan_types_tl.name%type,
242: x_return_status OUT VARCHAR2,
243: x_msg_count OUT NUMBER,
244: x_msg_data OUT VARCHAR2)

Line 297: pa_fin_plan_types_b.fin_plan_type_id%type,

293: end generated_flag_val;
294:
295: procedure used_in_billing_flag_val
296: (p_fin_plan_type_id IN
297: pa_fin_plan_types_b.fin_plan_type_id%type,
298: p_used_in_billing_flag IN
299: pa_fin_plan_types_b.used_in_billing_flag%type,
300: x_return_status OUT VARCHAR2,
301: x_msg_count OUT NUMBER,

Line 299: pa_fin_plan_types_b.used_in_billing_flag%type,

295: procedure used_in_billing_flag_val
296: (p_fin_plan_type_id IN
297: pa_fin_plan_types_b.fin_plan_type_id%type,
298: p_used_in_billing_flag IN
299: pa_fin_plan_types_b.used_in_billing_flag%type,
300: x_return_status OUT VARCHAR2,
301: x_msg_count OUT NUMBER,
302: x_msg_data OUT VARCHAR2)
303: is

Line 313: from pa_fin_plan_types_b

309: begin
310:
311: Select count(*)
312: into l_count
313: from pa_fin_plan_types_b
314: where fin_plan_type_id <> p_fin_plan_type_id
315: and used_in_billing_flag = 'Y';
316:
317: if p_used_in_billing_flag = 'Y' and l_count > 0 then

Line 360: pa_fin_plan_types_b.fin_plan_type_id%type,

356: ************************************************************************************/
357:
358: procedure delete_val
359: (p_fin_plan_type_id IN
360: pa_fin_plan_types_b.fin_plan_type_id%type,
361: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
362: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
363: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
364: is

Line 414: pa_fin_plan_types_b.fin_plan_type_id%type,

410:
411:
412: procedure validate
413: (p_fin_plan_type_id IN
414: pa_fin_plan_types_b.fin_plan_type_id%type,
415: p_name IN pa_fin_plan_types_tl.name%type,
416: p_start_date_active IN
417: pa_fin_plan_types_b.start_date_active%type,
418: p_end_date_active IN

Line 417: pa_fin_plan_types_b.start_date_active%type,

413: (p_fin_plan_type_id IN
414: pa_fin_plan_types_b.fin_plan_type_id%type,
415: p_name IN pa_fin_plan_types_tl.name%type,
416: p_start_date_active IN
417: pa_fin_plan_types_b.start_date_active%type,
418: p_end_date_active IN
419: pa_fin_plan_types_b.end_date_active%type,
420: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
421: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,

Line 419: pa_fin_plan_types_b.end_date_active%type,

415: p_name IN pa_fin_plan_types_tl.name%type,
416: p_start_date_active IN
417: pa_fin_plan_types_b.start_date_active%type,
418: p_end_date_active IN
419: pa_fin_plan_types_b.end_date_active%type,
420: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
421: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
422: p_record_version_number IN
423: pa_fin_plan_types_b.record_version_number%type,

Line 420: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,

416: p_start_date_active IN
417: pa_fin_plan_types_b.start_date_active%type,
418: p_end_date_active IN
419: pa_fin_plan_types_b.end_date_active%type,
420: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
421: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
422: p_record_version_number IN
423: pa_fin_plan_types_b.record_version_number%type,
424: p_fin_plan_type_code IN

Line 421: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,

417: pa_fin_plan_types_b.start_date_active%type,
418: p_end_date_active IN
419: pa_fin_plan_types_b.end_date_active%type,
420: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
421: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
422: p_record_version_number IN
423: pa_fin_plan_types_b.record_version_number%type,
424: p_fin_plan_type_code IN
425: pa_fin_plan_types_b.fin_plan_type_code%type,

Line 423: pa_fin_plan_types_b.record_version_number%type,

419: pa_fin_plan_types_b.end_date_active%type,
420: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
421: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
422: p_record_version_number IN
423: pa_fin_plan_types_b.record_version_number%type,
424: p_fin_plan_type_code IN
425: pa_fin_plan_types_b.fin_plan_type_code%type,
426: p_pre_defined_flag IN
427: pa_fin_plan_types_b.pre_defined_flag%type,

Line 425: pa_fin_plan_types_b.fin_plan_type_code%type,

421: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
422: p_record_version_number IN
423: pa_fin_plan_types_b.record_version_number%type,
424: p_fin_plan_type_code IN
425: pa_fin_plan_types_b.fin_plan_type_code%type,
426: p_pre_defined_flag IN
427: pa_fin_plan_types_b.pre_defined_flag%type,
428: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
429: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 427: pa_fin_plan_types_b.pre_defined_flag%type,

423: pa_fin_plan_types_b.record_version_number%type,
424: p_fin_plan_type_code IN
425: pa_fin_plan_types_b.fin_plan_type_code%type,
426: p_pre_defined_flag IN
427: pa_fin_plan_types_b.pre_defined_flag%type,
428: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
429: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
430: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
431: l_msg_count NUMBER;

Line 504: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type)

500: raise FND_API.G_EXC_UNEXPECTED_ERROR;
501: end validate;
502:
503: function isfptypeused
504: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type)
505: return VARCHAR2 is
506: l_return VARCHAR2(1) := 'N';
507: begin
508:

Line 532: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,

528:
529: /* FP M - dbora - Function to check for any partially implemented COs in a plan type
530: */
531: FUNCTION partially_impl_cos_exist
532: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
533: p_ci_type_id IN pa_control_items.ci_type_id%TYPE)
534: RETURN VARCHAR2 is
535:
536: l_return_flag VARCHAR2(1);

Line 650: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,

646: statuses.
647: */
648:
649: FUNCTION GET_CONCAT_STATUSES
650: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
651: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
652: p_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE)
653: RETURN VARCHAR2 IS
654:

Line 734: (x_workplan_pt_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895

730:
731: END GET_CONCAT_STATUSES;
732:
733: PROCEDURE GET_WORKPLAN_PT_DETAILS
734: (x_workplan_pt_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
735: x_w_pt_attached_to_proj OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
736: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
737: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
738: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 765: FROM pa_fin_plan_types_b

761: BEGIN
762:
763: SELECT fin_plan_type_id
764: INTO x_workplan_pt_id
765: FROM pa_fin_plan_types_b
766: WHERE use_for_workplan_flag = 'Y';
767:
768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN