APPS.PA_RATE_PVT_PKG dependencies on PA_REP_PERIOD_DATES_V

Line 5: TYPE ProjAmt_Record IS RECORD ( period_name pa_rep_period_dates_v.period_name%TYPE,

1: PACKAGE PA_RATE_PVT_PKG AUTHID CURRENT_USER as
2: /* $Header: PAXRTPVS.pls 120.1 2005/08/19 17:19:38 mwasowic noship $ */
3:
4:
5: TYPE ProjAmt_Record IS RECORD ( period_name pa_rep_period_dates_v.period_name%TYPE,
6: Amount NUMBER,
7: start_date pa_rep_period_dates_v.start_date%TYPE,
8: end_date pa_rep_period_dates_v.end_date%TYPE);
9:

Line 7: start_date pa_rep_period_dates_v.start_date%TYPE,

3:
4:
5: TYPE ProjAmt_Record IS RECORD ( period_name pa_rep_period_dates_v.period_name%TYPE,
6: Amount NUMBER,
7: start_date pa_rep_period_dates_v.start_date%TYPE,
8: end_date pa_rep_period_dates_v.end_date%TYPE);
9:
10: TYPE ProjAmt_TabTyp IS TABLE OF ProjAmt_Record INDEX BY BINARY_INTEGER;
11:

Line 8: end_date pa_rep_period_dates_v.end_date%TYPE);

4:
5: TYPE ProjAmt_Record IS RECORD ( period_name pa_rep_period_dates_v.period_name%TYPE,
6: Amount NUMBER,
7: start_date pa_rep_period_dates_v.start_date%TYPE,
8: end_date pa_rep_period_dates_v.end_date%TYPE);
9:
10: TYPE ProjAmt_TabTyp IS TABLE OF ProjAmt_Record INDEX BY BINARY_INTEGER;
11:
12: /* Declaring global varible , which is going to be used to check whether the error from

Line 352: /* Added for performance bug 2691192, it replaces the use of view pa_rep_period_dates_v */

348: -- Parameters : Table of Record and Scalar
349: --
350:
351:
352: /* Added for performance bug 2691192, it replaces the use of view pa_rep_period_dates_v */
353: PROCEDURE get_rep_period_dates(
354: p_period_type IN VARCHAR2 ,
355: p_completion_date IN DATE,
356: x_period_year OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895