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: Cursor C1 IS
10: Select 'Y' from pa_resource_assignments
11: where spread_curve_id = p_spread_curve_id;
12:

Line 47: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,

43: 3. Amount in buckets should not be less than 0
44: ==================================================================*/
45:
46: PROCEDURE validate (
47: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
48: p_name IN Pa_spread_curves_tl.name%TYPE,
49: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
50: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
51: P_point1 IN Pa_spread_curves_b.point1%TYPE,

Line 49: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,

45:
46: PROCEDURE validate (
47: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
48: p_name IN Pa_spread_curves_tl.name%TYPE,
49: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
50: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
51: P_point1 IN Pa_spread_curves_b.point1%TYPE,
52: P_point2 IN Pa_spread_curves_b.point2%TYPE,
53: P_point3 IN Pa_spread_curves_b.point3%TYPE,

Line 50: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,

46: PROCEDURE validate (
47: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
48: p_name IN Pa_spread_curves_tl.name%TYPE,
49: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
50: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
51: P_point1 IN Pa_spread_curves_b.point1%TYPE,
52: P_point2 IN Pa_spread_curves_b.point2%TYPE,
53: P_point3 IN Pa_spread_curves_b.point3%TYPE,
54: P_point4 IN Pa_spread_curves_b.point4%TYPE,

Line 51: P_point1 IN Pa_spread_curves_b.point1%TYPE,

47: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
48: p_name IN Pa_spread_curves_tl.name%TYPE,
49: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
50: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
51: P_point1 IN Pa_spread_curves_b.point1%TYPE,
52: P_point2 IN Pa_spread_curves_b.point2%TYPE,
53: P_point3 IN Pa_spread_curves_b.point3%TYPE,
54: P_point4 IN Pa_spread_curves_b.point4%TYPE,
55: P_point5 IN Pa_spread_curves_b.point5%TYPE,

Line 52: P_point2 IN Pa_spread_curves_b.point2%TYPE,

48: p_name IN Pa_spread_curves_tl.name%TYPE,
49: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
50: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
51: P_point1 IN Pa_spread_curves_b.point1%TYPE,
52: P_point2 IN Pa_spread_curves_b.point2%TYPE,
53: P_point3 IN Pa_spread_curves_b.point3%TYPE,
54: P_point4 IN Pa_spread_curves_b.point4%TYPE,
55: P_point5 IN Pa_spread_curves_b.point5%TYPE,
56: P_point6 IN Pa_spread_curves_b.point6%TYPE,

Line 53: P_point3 IN Pa_spread_curves_b.point3%TYPE,

49: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
50: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
51: P_point1 IN Pa_spread_curves_b.point1%TYPE,
52: P_point2 IN Pa_spread_curves_b.point2%TYPE,
53: P_point3 IN Pa_spread_curves_b.point3%TYPE,
54: P_point4 IN Pa_spread_curves_b.point4%TYPE,
55: P_point5 IN Pa_spread_curves_b.point5%TYPE,
56: P_point6 IN Pa_spread_curves_b.point6%TYPE,
57: P_point7 IN Pa_spread_curves_b.point7%TYPE,

Line 54: P_point4 IN Pa_spread_curves_b.point4%TYPE,

50: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
51: P_point1 IN Pa_spread_curves_b.point1%TYPE,
52: P_point2 IN Pa_spread_curves_b.point2%TYPE,
53: P_point3 IN Pa_spread_curves_b.point3%TYPE,
54: P_point4 IN Pa_spread_curves_b.point4%TYPE,
55: P_point5 IN Pa_spread_curves_b.point5%TYPE,
56: P_point6 IN Pa_spread_curves_b.point6%TYPE,
57: P_point7 IN Pa_spread_curves_b.point7%TYPE,
58: P_point8 IN Pa_spread_curves_b.point8%TYPE,

Line 55: P_point5 IN Pa_spread_curves_b.point5%TYPE,

51: P_point1 IN Pa_spread_curves_b.point1%TYPE,
52: P_point2 IN Pa_spread_curves_b.point2%TYPE,
53: P_point3 IN Pa_spread_curves_b.point3%TYPE,
54: P_point4 IN Pa_spread_curves_b.point4%TYPE,
55: P_point5 IN Pa_spread_curves_b.point5%TYPE,
56: P_point6 IN Pa_spread_curves_b.point6%TYPE,
57: P_point7 IN Pa_spread_curves_b.point7%TYPE,
58: P_point8 IN Pa_spread_curves_b.point8%TYPE,
59: P_point9 IN Pa_spread_curves_b.point9%TYPE,

Line 56: P_point6 IN Pa_spread_curves_b.point6%TYPE,

52: P_point2 IN Pa_spread_curves_b.point2%TYPE,
53: P_point3 IN Pa_spread_curves_b.point3%TYPE,
54: P_point4 IN Pa_spread_curves_b.point4%TYPE,
55: P_point5 IN Pa_spread_curves_b.point5%TYPE,
56: P_point6 IN Pa_spread_curves_b.point6%TYPE,
57: P_point7 IN Pa_spread_curves_b.point7%TYPE,
58: P_point8 IN Pa_spread_curves_b.point8%TYPE,
59: P_point9 IN Pa_spread_curves_b.point9%TYPE,
60: P_point10 IN Pa_spread_curves_b.point10%TYPE,

Line 57: P_point7 IN Pa_spread_curves_b.point7%TYPE,

53: P_point3 IN Pa_spread_curves_b.point3%TYPE,
54: P_point4 IN Pa_spread_curves_b.point4%TYPE,
55: P_point5 IN Pa_spread_curves_b.point5%TYPE,
56: P_point6 IN Pa_spread_curves_b.point6%TYPE,
57: P_point7 IN Pa_spread_curves_b.point7%TYPE,
58: P_point8 IN Pa_spread_curves_b.point8%TYPE,
59: P_point9 IN Pa_spread_curves_b.point9%TYPE,
60: P_point10 IN Pa_spread_curves_b.point10%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 58: P_point8 IN Pa_spread_curves_b.point8%TYPE,

54: P_point4 IN Pa_spread_curves_b.point4%TYPE,
55: P_point5 IN Pa_spread_curves_b.point5%TYPE,
56: P_point6 IN Pa_spread_curves_b.point6%TYPE,
57: P_point7 IN Pa_spread_curves_b.point7%TYPE,
58: P_point8 IN Pa_spread_curves_b.point8%TYPE,
59: P_point9 IN Pa_spread_curves_b.point9%TYPE,
60: P_point10 IN Pa_spread_curves_b.point10%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 59: P_point9 IN Pa_spread_curves_b.point9%TYPE,

55: P_point5 IN Pa_spread_curves_b.point5%TYPE,
56: P_point6 IN Pa_spread_curves_b.point6%TYPE,
57: P_point7 IN Pa_spread_curves_b.point7%TYPE,
58: P_point8 IN Pa_spread_curves_b.point8%TYPE,
59: P_point9 IN Pa_spread_curves_b.point9%TYPE,
60: P_point10 IN Pa_spread_curves_b.point10%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
63: X_msg_count OUT NOCOPY number ) --File.Sql.39 bug 4440895

Line 60: P_point10 IN Pa_spread_curves_b.point10%TYPE,

56: P_point6 IN Pa_spread_curves_b.point6%TYPE,
57: P_point7 IN Pa_spread_curves_b.point7%TYPE,
58: P_point8 IN Pa_spread_curves_b.point8%TYPE,
59: P_point9 IN Pa_spread_curves_b.point9%TYPE,
60: P_point10 IN Pa_spread_curves_b.point10%TYPE,
61: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
63: X_msg_count OUT NOCOPY number ) --File.Sql.39 bug 4440895
64: AS

Line 347: P_point1 IN Pa_spread_curves_b.point1%TYPE,

343: Amount in buckets total_weighting should not be < 0
344: ==================================================================*/
345:
346: PROCEDURE validate_amount_in_buckets(
347: P_point1 IN Pa_spread_curves_b.point1%TYPE,
348: P_point2 IN Pa_spread_curves_b.point2%TYPE,
349: P_point3 IN Pa_spread_curves_b.point3%TYPE,
350: P_point4 IN Pa_spread_curves_b.point4%TYPE,
351: P_point5 IN Pa_spread_curves_b.point5%TYPE,

Line 348: P_point2 IN Pa_spread_curves_b.point2%TYPE,

344: ==================================================================*/
345:
346: PROCEDURE validate_amount_in_buckets(
347: P_point1 IN Pa_spread_curves_b.point1%TYPE,
348: P_point2 IN Pa_spread_curves_b.point2%TYPE,
349: P_point3 IN Pa_spread_curves_b.point3%TYPE,
350: P_point4 IN Pa_spread_curves_b.point4%TYPE,
351: P_point5 IN Pa_spread_curves_b.point5%TYPE,
352: P_point6 IN Pa_spread_curves_b.point6%TYPE,

Line 349: P_point3 IN Pa_spread_curves_b.point3%TYPE,

345:
346: PROCEDURE validate_amount_in_buckets(
347: P_point1 IN Pa_spread_curves_b.point1%TYPE,
348: P_point2 IN Pa_spread_curves_b.point2%TYPE,
349: P_point3 IN Pa_spread_curves_b.point3%TYPE,
350: P_point4 IN Pa_spread_curves_b.point4%TYPE,
351: P_point5 IN Pa_spread_curves_b.point5%TYPE,
352: P_point6 IN Pa_spread_curves_b.point6%TYPE,
353: P_point7 IN Pa_spread_curves_b.point7%TYPE,

Line 350: P_point4 IN Pa_spread_curves_b.point4%TYPE,

346: PROCEDURE validate_amount_in_buckets(
347: P_point1 IN Pa_spread_curves_b.point1%TYPE,
348: P_point2 IN Pa_spread_curves_b.point2%TYPE,
349: P_point3 IN Pa_spread_curves_b.point3%TYPE,
350: P_point4 IN Pa_spread_curves_b.point4%TYPE,
351: P_point5 IN Pa_spread_curves_b.point5%TYPE,
352: P_point6 IN Pa_spread_curves_b.point6%TYPE,
353: P_point7 IN Pa_spread_curves_b.point7%TYPE,
354: P_point8 IN Pa_spread_curves_b.point8%TYPE,

Line 351: P_point5 IN Pa_spread_curves_b.point5%TYPE,

347: P_point1 IN Pa_spread_curves_b.point1%TYPE,
348: P_point2 IN Pa_spread_curves_b.point2%TYPE,
349: P_point3 IN Pa_spread_curves_b.point3%TYPE,
350: P_point4 IN Pa_spread_curves_b.point4%TYPE,
351: P_point5 IN Pa_spread_curves_b.point5%TYPE,
352: P_point6 IN Pa_spread_curves_b.point6%TYPE,
353: P_point7 IN Pa_spread_curves_b.point7%TYPE,
354: P_point8 IN Pa_spread_curves_b.point8%TYPE,
355: P_point9 IN Pa_spread_curves_b.point9%TYPE,

Line 352: P_point6 IN Pa_spread_curves_b.point6%TYPE,

348: P_point2 IN Pa_spread_curves_b.point2%TYPE,
349: P_point3 IN Pa_spread_curves_b.point3%TYPE,
350: P_point4 IN Pa_spread_curves_b.point4%TYPE,
351: P_point5 IN Pa_spread_curves_b.point5%TYPE,
352: P_point6 IN Pa_spread_curves_b.point6%TYPE,
353: P_point7 IN Pa_spread_curves_b.point7%TYPE,
354: P_point8 IN Pa_spread_curves_b.point8%TYPE,
355: P_point9 IN Pa_spread_curves_b.point9%TYPE,
356: P_point10 IN Pa_spread_curves_b.point10%TYPE,

Line 353: P_point7 IN Pa_spread_curves_b.point7%TYPE,

349: P_point3 IN Pa_spread_curves_b.point3%TYPE,
350: P_point4 IN Pa_spread_curves_b.point4%TYPE,
351: P_point5 IN Pa_spread_curves_b.point5%TYPE,
352: P_point6 IN Pa_spread_curves_b.point6%TYPE,
353: P_point7 IN Pa_spread_curves_b.point7%TYPE,
354: P_point8 IN Pa_spread_curves_b.point8%TYPE,
355: P_point9 IN Pa_spread_curves_b.point9%TYPE,
356: P_point10 IN Pa_spread_curves_b.point10%TYPE,
357: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 354: P_point8 IN Pa_spread_curves_b.point8%TYPE,

350: P_point4 IN Pa_spread_curves_b.point4%TYPE,
351: P_point5 IN Pa_spread_curves_b.point5%TYPE,
352: P_point6 IN Pa_spread_curves_b.point6%TYPE,
353: P_point7 IN Pa_spread_curves_b.point7%TYPE,
354: P_point8 IN Pa_spread_curves_b.point8%TYPE,
355: P_point9 IN Pa_spread_curves_b.point9%TYPE,
356: P_point10 IN Pa_spread_curves_b.point10%TYPE,
357: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
358: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 355: P_point9 IN Pa_spread_curves_b.point9%TYPE,

351: P_point5 IN Pa_spread_curves_b.point5%TYPE,
352: P_point6 IN Pa_spread_curves_b.point6%TYPE,
353: P_point7 IN Pa_spread_curves_b.point7%TYPE,
354: P_point8 IN Pa_spread_curves_b.point8%TYPE,
355: P_point9 IN Pa_spread_curves_b.point9%TYPE,
356: P_point10 IN Pa_spread_curves_b.point10%TYPE,
357: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
358: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
359: X_msg_count OUT NOCOPY number) --File.Sql.39 bug 4440895

Line 356: P_point10 IN Pa_spread_curves_b.point10%TYPE,

352: P_point6 IN Pa_spread_curves_b.point6%TYPE,
353: P_point7 IN Pa_spread_curves_b.point7%TYPE,
354: P_point8 IN Pa_spread_curves_b.point8%TYPE,
355: P_point9 IN Pa_spread_curves_b.point9%TYPE,
356: P_point10 IN Pa_spread_curves_b.point10%TYPE,
357: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
358: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
359: X_msg_count OUT NOCOPY number) --File.Sql.39 bug 4440895
360: IS