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 14: (p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,

10:
11: /****************************************************************************************
12: * Dusan changes. Moved this api to pa_fin_plan_utils
13: procedure end_date_active_val
14: (p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
15: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
16: x_return_status OUT VARCHAR2,
17: x_msg_count OUT NUMBER,
18: x_msg_data OUT VARCHAR2);

Line 15: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,

11: /****************************************************************************************
12: * Dusan changes. Moved this api to pa_fin_plan_utils
13: procedure end_date_active_val
14: (p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
15: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
16: x_return_status OUT VARCHAR2,
17: x_msg_count OUT NUMBER,
18: x_msg_data OUT VARCHAR2);
19: *****************************************************************************************/

Line 26: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,

22: Commented since generated_flag and used_in_billing_flag
23: are obsolete after change in functionality
24:
25: procedure generated_flag_val
26: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
27: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
28: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
29: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
30: p_name IN pa_fin_plan_types_tl.name%type,

Line 27: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,

23: are obsolete after change in functionality
24:
25: procedure generated_flag_val
26: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
27: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
28: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
29: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
30: p_name IN pa_fin_plan_types_tl.name%type,
31: x_return_status OUT VARCHAR2,

Line 28: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,

24:
25: procedure generated_flag_val
26: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
27: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
28: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
29: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
30: p_name IN pa_fin_plan_types_tl.name%type,
31: x_return_status OUT VARCHAR2,
32: x_msg_count OUT NUMBER,

Line 29: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,

25: procedure generated_flag_val
26: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
27: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
28: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
29: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
30: p_name IN pa_fin_plan_types_tl.name%type,
31: x_return_status OUT VARCHAR2,
32: x_msg_count OUT NUMBER,
33: x_msg_data OUT VARCHAR2);

Line 36: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,

32: x_msg_count OUT NUMBER,
33: x_msg_data OUT VARCHAR2);
34:
35: procedure used_in_billing_flag_val
36: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
37: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
38: x_return_status OUT VARCHAR2,
39: x_msg_count OUT NUMBER,
40: x_msg_data OUT VARCHAR2);

Line 37: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,

33: x_msg_data OUT VARCHAR2);
34:
35: procedure used_in_billing_flag_val
36: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
37: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
38: x_return_status OUT VARCHAR2,
39: x_msg_count OUT NUMBER,
40: x_msg_data OUT VARCHAR2);
41:

Line 44: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,

40: x_msg_data OUT VARCHAR2);
41:
42: **************************************************************************/
43: procedure delete_val
44: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
45: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
46: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
47: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
48:

Line 50: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,

46: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
47: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
48:
49: procedure validate
50: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
51: p_name IN pa_fin_plan_types_tl.name%type,
52: p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
53: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,

Line 52: p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,

48:
49: procedure validate
50: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
51: p_name IN pa_fin_plan_types_tl.name%type,
52: p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
53: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
55: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
56: p_record_version_number IN pa_fin_plan_types_b.record_version_number%type,

Line 53: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,

49: procedure validate
50: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
51: p_name IN pa_fin_plan_types_tl.name%type,
52: p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
53: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
55: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
56: p_record_version_number IN pa_fin_plan_types_b.record_version_number%type,
57: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,

Line 54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,

50: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type,
51: p_name IN pa_fin_plan_types_tl.name%type,
52: p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
53: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
55: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
56: p_record_version_number IN pa_fin_plan_types_b.record_version_number%type,
57: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
58: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,

Line 55: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,

51: p_name IN pa_fin_plan_types_tl.name%type,
52: p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
53: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
55: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
56: p_record_version_number IN pa_fin_plan_types_b.record_version_number%type,
57: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
58: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
59: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 56: p_record_version_number IN pa_fin_plan_types_b.record_version_number%type,

52: p_start_date_active IN pa_fin_plan_types_b.start_date_active%type,
53: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
55: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
56: p_record_version_number IN pa_fin_plan_types_b.record_version_number%type,
57: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
58: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
59: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 57: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,

53: p_end_date_active IN pa_fin_plan_types_b.end_date_active%type,
54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
55: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
56: p_record_version_number IN pa_fin_plan_types_b.record_version_number%type,
57: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
58: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
59: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
61: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 58: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,

54: p_generated_flag IN pa_fin_plan_types_b.generated_flag%type,
55: p_used_in_billing_flag IN pa_fin_plan_types_b.used_in_billing_flag%type,
56: p_record_version_number IN pa_fin_plan_types_b.record_version_number%type,
57: p_fin_plan_type_code IN pa_fin_plan_types_b.fin_plan_type_code%type,
58: p_pre_defined_flag IN pa_fin_plan_types_b.pre_defined_flag%type,
59: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
61: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
62:

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

60: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
61: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
62:
63: function isfptypeused
64: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%type)
65: return VARCHAR2;
66:
67: /* FP M - dbora Additional FUNCTIONS and PROCEDURE
68: */

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

66:
67: /* FP M - dbora Additional FUNCTIONS and PROCEDURE
68: */
69: FUNCTION PARTIALLY_IMPL_COS_EXIST
70: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
71: p_ci_type_id IN pa_control_items.ci_type_id%TYPE )
72: RETURN VARCHAR2;
73:
74: FUNCTION GET_CONCAT_STATUSES

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

71: p_ci_type_id IN pa_control_items.ci_type_id%TYPE )
72: RETURN VARCHAR2;
73:
74: FUNCTION GET_CONCAT_STATUSES
75: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
76: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
77: p_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE)
78: RETURN VARCHAR2;
79:

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

77: p_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE)
78: RETURN VARCHAR2;
79:
80: PROCEDURE GET_WORKPLAN_PT_DETAILS
81: (x_workplan_pt_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
82: x_w_pt_attached_to_proj OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
83: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
84: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
85: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895