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_FP_SPREAD_CURVES_UTILS dependencies on PA_SPREAD_CURVES_B

Line 8: FUNCTION is_spread_curve_in_use ( p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE ) RETURN VARCHAR2 IS

4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_spread_curves_utils';
5:
6: /* This function checks whether the spread curve is in use in Budgeting and Forecasting or not */
7:
8: FUNCTION is_spread_curve_in_use ( p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE ) RETURN VARCHAR2 IS
9:
10: /* Start of Commenting code for bug 9036322
11: Cursor C1 IS
12: Select 'Y' from pa_resource_assignments

Line 73: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,

69: 3. Amount in buckets should not be less than 0
70: ==================================================================*/
71:
72: PROCEDURE validate (
73: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
74: p_name IN Pa_spread_curves_tl.name%TYPE,
75: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
76: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
77: P_point1 IN Pa_spread_curves_b.point1%TYPE,

Line 75: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,

71:
72: PROCEDURE validate (
73: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
74: p_name IN Pa_spread_curves_tl.name%TYPE,
75: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
76: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
77: P_point1 IN Pa_spread_curves_b.point1%TYPE,
78: P_point2 IN Pa_spread_curves_b.point2%TYPE,
79: P_point3 IN Pa_spread_curves_b.point3%TYPE,

Line 76: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,

72: PROCEDURE validate (
73: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
74: p_name IN Pa_spread_curves_tl.name%TYPE,
75: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
76: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
77: P_point1 IN Pa_spread_curves_b.point1%TYPE,
78: P_point2 IN Pa_spread_curves_b.point2%TYPE,
79: P_point3 IN Pa_spread_curves_b.point3%TYPE,
80: P_point4 IN Pa_spread_curves_b.point4%TYPE,

Line 77: P_point1 IN Pa_spread_curves_b.point1%TYPE,

73: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
74: p_name IN Pa_spread_curves_tl.name%TYPE,
75: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
76: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
77: P_point1 IN Pa_spread_curves_b.point1%TYPE,
78: P_point2 IN Pa_spread_curves_b.point2%TYPE,
79: P_point3 IN Pa_spread_curves_b.point3%TYPE,
80: P_point4 IN Pa_spread_curves_b.point4%TYPE,
81: P_point5 IN Pa_spread_curves_b.point5%TYPE,

Line 78: P_point2 IN Pa_spread_curves_b.point2%TYPE,

74: p_name IN Pa_spread_curves_tl.name%TYPE,
75: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
76: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
77: P_point1 IN Pa_spread_curves_b.point1%TYPE,
78: P_point2 IN Pa_spread_curves_b.point2%TYPE,
79: P_point3 IN Pa_spread_curves_b.point3%TYPE,
80: P_point4 IN Pa_spread_curves_b.point4%TYPE,
81: P_point5 IN Pa_spread_curves_b.point5%TYPE,
82: P_point6 IN Pa_spread_curves_b.point6%TYPE,

Line 79: P_point3 IN Pa_spread_curves_b.point3%TYPE,

75: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
76: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
77: P_point1 IN Pa_spread_curves_b.point1%TYPE,
78: P_point2 IN Pa_spread_curves_b.point2%TYPE,
79: P_point3 IN Pa_spread_curves_b.point3%TYPE,
80: P_point4 IN Pa_spread_curves_b.point4%TYPE,
81: P_point5 IN Pa_spread_curves_b.point5%TYPE,
82: P_point6 IN Pa_spread_curves_b.point6%TYPE,
83: P_point7 IN Pa_spread_curves_b.point7%TYPE,

Line 80: P_point4 IN Pa_spread_curves_b.point4%TYPE,

76: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
77: P_point1 IN Pa_spread_curves_b.point1%TYPE,
78: P_point2 IN Pa_spread_curves_b.point2%TYPE,
79: P_point3 IN Pa_spread_curves_b.point3%TYPE,
80: P_point4 IN Pa_spread_curves_b.point4%TYPE,
81: P_point5 IN Pa_spread_curves_b.point5%TYPE,
82: P_point6 IN Pa_spread_curves_b.point6%TYPE,
83: P_point7 IN Pa_spread_curves_b.point7%TYPE,
84: P_point8 IN Pa_spread_curves_b.point8%TYPE,

Line 81: P_point5 IN Pa_spread_curves_b.point5%TYPE,

77: P_point1 IN Pa_spread_curves_b.point1%TYPE,
78: P_point2 IN Pa_spread_curves_b.point2%TYPE,
79: P_point3 IN Pa_spread_curves_b.point3%TYPE,
80: P_point4 IN Pa_spread_curves_b.point4%TYPE,
81: P_point5 IN Pa_spread_curves_b.point5%TYPE,
82: P_point6 IN Pa_spread_curves_b.point6%TYPE,
83: P_point7 IN Pa_spread_curves_b.point7%TYPE,
84: P_point8 IN Pa_spread_curves_b.point8%TYPE,
85: P_point9 IN Pa_spread_curves_b.point9%TYPE,

Line 82: P_point6 IN Pa_spread_curves_b.point6%TYPE,

78: P_point2 IN Pa_spread_curves_b.point2%TYPE,
79: P_point3 IN Pa_spread_curves_b.point3%TYPE,
80: P_point4 IN Pa_spread_curves_b.point4%TYPE,
81: P_point5 IN Pa_spread_curves_b.point5%TYPE,
82: P_point6 IN Pa_spread_curves_b.point6%TYPE,
83: P_point7 IN Pa_spread_curves_b.point7%TYPE,
84: P_point8 IN Pa_spread_curves_b.point8%TYPE,
85: P_point9 IN Pa_spread_curves_b.point9%TYPE,
86: P_point10 IN Pa_spread_curves_b.point10%TYPE,

Line 83: P_point7 IN Pa_spread_curves_b.point7%TYPE,

79: P_point3 IN Pa_spread_curves_b.point3%TYPE,
80: P_point4 IN Pa_spread_curves_b.point4%TYPE,
81: P_point5 IN Pa_spread_curves_b.point5%TYPE,
82: P_point6 IN Pa_spread_curves_b.point6%TYPE,
83: P_point7 IN Pa_spread_curves_b.point7%TYPE,
84: P_point8 IN Pa_spread_curves_b.point8%TYPE,
85: P_point9 IN Pa_spread_curves_b.point9%TYPE,
86: P_point10 IN Pa_spread_curves_b.point10%TYPE,
87: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 84: P_point8 IN Pa_spread_curves_b.point8%TYPE,

80: P_point4 IN Pa_spread_curves_b.point4%TYPE,
81: P_point5 IN Pa_spread_curves_b.point5%TYPE,
82: P_point6 IN Pa_spread_curves_b.point6%TYPE,
83: P_point7 IN Pa_spread_curves_b.point7%TYPE,
84: P_point8 IN Pa_spread_curves_b.point8%TYPE,
85: P_point9 IN Pa_spread_curves_b.point9%TYPE,
86: P_point10 IN Pa_spread_curves_b.point10%TYPE,
87: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 85: P_point9 IN Pa_spread_curves_b.point9%TYPE,

81: P_point5 IN Pa_spread_curves_b.point5%TYPE,
82: P_point6 IN Pa_spread_curves_b.point6%TYPE,
83: P_point7 IN Pa_spread_curves_b.point7%TYPE,
84: P_point8 IN Pa_spread_curves_b.point8%TYPE,
85: P_point9 IN Pa_spread_curves_b.point9%TYPE,
86: P_point10 IN Pa_spread_curves_b.point10%TYPE,
87: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
89: X_msg_count OUT NOCOPY number ) --File.Sql.39 bug 4440895

Line 86: P_point10 IN Pa_spread_curves_b.point10%TYPE,

82: P_point6 IN Pa_spread_curves_b.point6%TYPE,
83: P_point7 IN Pa_spread_curves_b.point7%TYPE,
84: P_point8 IN Pa_spread_curves_b.point8%TYPE,
85: P_point9 IN Pa_spread_curves_b.point9%TYPE,
86: P_point10 IN Pa_spread_curves_b.point10%TYPE,
87: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
89: X_msg_count OUT NOCOPY number ) --File.Sql.39 bug 4440895
90: AS

Line 373: P_point1 IN Pa_spread_curves_b.point1%TYPE,

369: Amount in buckets total_weighting should not be < 0
370: ==================================================================*/
371:
372: PROCEDURE validate_amount_in_buckets(
373: P_point1 IN Pa_spread_curves_b.point1%TYPE,
374: P_point2 IN Pa_spread_curves_b.point2%TYPE,
375: P_point3 IN Pa_spread_curves_b.point3%TYPE,
376: P_point4 IN Pa_spread_curves_b.point4%TYPE,
377: P_point5 IN Pa_spread_curves_b.point5%TYPE,

Line 374: P_point2 IN Pa_spread_curves_b.point2%TYPE,

370: ==================================================================*/
371:
372: PROCEDURE validate_amount_in_buckets(
373: P_point1 IN Pa_spread_curves_b.point1%TYPE,
374: P_point2 IN Pa_spread_curves_b.point2%TYPE,
375: P_point3 IN Pa_spread_curves_b.point3%TYPE,
376: P_point4 IN Pa_spread_curves_b.point4%TYPE,
377: P_point5 IN Pa_spread_curves_b.point5%TYPE,
378: P_point6 IN Pa_spread_curves_b.point6%TYPE,

Line 375: P_point3 IN Pa_spread_curves_b.point3%TYPE,

371:
372: PROCEDURE validate_amount_in_buckets(
373: P_point1 IN Pa_spread_curves_b.point1%TYPE,
374: P_point2 IN Pa_spread_curves_b.point2%TYPE,
375: P_point3 IN Pa_spread_curves_b.point3%TYPE,
376: P_point4 IN Pa_spread_curves_b.point4%TYPE,
377: P_point5 IN Pa_spread_curves_b.point5%TYPE,
378: P_point6 IN Pa_spread_curves_b.point6%TYPE,
379: P_point7 IN Pa_spread_curves_b.point7%TYPE,

Line 376: P_point4 IN Pa_spread_curves_b.point4%TYPE,

372: PROCEDURE validate_amount_in_buckets(
373: P_point1 IN Pa_spread_curves_b.point1%TYPE,
374: P_point2 IN Pa_spread_curves_b.point2%TYPE,
375: P_point3 IN Pa_spread_curves_b.point3%TYPE,
376: P_point4 IN Pa_spread_curves_b.point4%TYPE,
377: P_point5 IN Pa_spread_curves_b.point5%TYPE,
378: P_point6 IN Pa_spread_curves_b.point6%TYPE,
379: P_point7 IN Pa_spread_curves_b.point7%TYPE,
380: P_point8 IN Pa_spread_curves_b.point8%TYPE,

Line 377: P_point5 IN Pa_spread_curves_b.point5%TYPE,

373: P_point1 IN Pa_spread_curves_b.point1%TYPE,
374: P_point2 IN Pa_spread_curves_b.point2%TYPE,
375: P_point3 IN Pa_spread_curves_b.point3%TYPE,
376: P_point4 IN Pa_spread_curves_b.point4%TYPE,
377: P_point5 IN Pa_spread_curves_b.point5%TYPE,
378: P_point6 IN Pa_spread_curves_b.point6%TYPE,
379: P_point7 IN Pa_spread_curves_b.point7%TYPE,
380: P_point8 IN Pa_spread_curves_b.point8%TYPE,
381: P_point9 IN Pa_spread_curves_b.point9%TYPE,

Line 378: P_point6 IN Pa_spread_curves_b.point6%TYPE,

374: P_point2 IN Pa_spread_curves_b.point2%TYPE,
375: P_point3 IN Pa_spread_curves_b.point3%TYPE,
376: P_point4 IN Pa_spread_curves_b.point4%TYPE,
377: P_point5 IN Pa_spread_curves_b.point5%TYPE,
378: P_point6 IN Pa_spread_curves_b.point6%TYPE,
379: P_point7 IN Pa_spread_curves_b.point7%TYPE,
380: P_point8 IN Pa_spread_curves_b.point8%TYPE,
381: P_point9 IN Pa_spread_curves_b.point9%TYPE,
382: P_point10 IN Pa_spread_curves_b.point10%TYPE,

Line 379: P_point7 IN Pa_spread_curves_b.point7%TYPE,

375: P_point3 IN Pa_spread_curves_b.point3%TYPE,
376: P_point4 IN Pa_spread_curves_b.point4%TYPE,
377: P_point5 IN Pa_spread_curves_b.point5%TYPE,
378: P_point6 IN Pa_spread_curves_b.point6%TYPE,
379: P_point7 IN Pa_spread_curves_b.point7%TYPE,
380: P_point8 IN Pa_spread_curves_b.point8%TYPE,
381: P_point9 IN Pa_spread_curves_b.point9%TYPE,
382: P_point10 IN Pa_spread_curves_b.point10%TYPE,
383: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 380: P_point8 IN Pa_spread_curves_b.point8%TYPE,

376: P_point4 IN Pa_spread_curves_b.point4%TYPE,
377: P_point5 IN Pa_spread_curves_b.point5%TYPE,
378: P_point6 IN Pa_spread_curves_b.point6%TYPE,
379: P_point7 IN Pa_spread_curves_b.point7%TYPE,
380: P_point8 IN Pa_spread_curves_b.point8%TYPE,
381: P_point9 IN Pa_spread_curves_b.point9%TYPE,
382: P_point10 IN Pa_spread_curves_b.point10%TYPE,
383: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
384: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 381: P_point9 IN Pa_spread_curves_b.point9%TYPE,

377: P_point5 IN Pa_spread_curves_b.point5%TYPE,
378: P_point6 IN Pa_spread_curves_b.point6%TYPE,
379: P_point7 IN Pa_spread_curves_b.point7%TYPE,
380: P_point8 IN Pa_spread_curves_b.point8%TYPE,
381: P_point9 IN Pa_spread_curves_b.point9%TYPE,
382: P_point10 IN Pa_spread_curves_b.point10%TYPE,
383: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
384: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
385: X_msg_count OUT NOCOPY number) --File.Sql.39 bug 4440895

Line 382: P_point10 IN Pa_spread_curves_b.point10%TYPE,

378: P_point6 IN Pa_spread_curves_b.point6%TYPE,
379: P_point7 IN Pa_spread_curves_b.point7%TYPE,
380: P_point8 IN Pa_spread_curves_b.point8%TYPE,
381: P_point9 IN Pa_spread_curves_b.point9%TYPE,
382: P_point10 IN Pa_spread_curves_b.point10%TYPE,
383: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
384: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
385: X_msg_count OUT NOCOPY number) --File.Sql.39 bug 4440895
386: IS