APPS.PA_PERIODS_PKG dependencies on PA_PERIODS

Line 1: PACKAGE BODY pa_periods_pkg AS

1: PACKAGE BODY pa_periods_pkg AS
2: /* $Header: PASUCPSB.pls 120.2.12010000.2 2008/09/16 09:14:43 svivaram ship $ */
3:
4: PROCEDURE copy_periods ( P_Org_Id IN NUMBER DEFAULT NULL -- 12i MOAC changes
5: , x_rec_count OUT NOCOPY NUMBER

Line 28: pa_periods_copy_v;

24: , start_date
25: , end_date
26: , gl_period_name
27: FROM
28: pa_periods_copy_v;
29:
30: BEGIN
31:
32: x_stage := 'SELECT FROM PA_IMPLEMENTATIONS';

Line 45: x_stage := 'INSERT INTO PA_PERIODS';

41: FOR xperiod IN NewPeriods LOOP
42:
43: l_rec_count := l_rec_count + 1;
44:
45: x_stage := 'INSERT INTO PA_PERIODS';
46: INSERT INTO pa_periods (
47: period_name
48: , last_update_date
49: , last_updated_by

Line 46: INSERT INTO pa_periods (

42:
43: l_rec_count := l_rec_count + 1;
44:
45: x_stage := 'INSERT INTO PA_PERIODS';
46: INSERT INTO pa_periods (
47: period_name
48: , last_update_date
49: , last_updated_by
50: , creation_date

Line 140: FROM PA_PERIODS pp

136: and gps.adjustment_period_flag = 'N'
137: and gps.set_of_books_id = p_sob_id
138: and not exists (
139: SELECT NULL
140: FROM PA_PERIODS pp
141: WHERE PP.PERIOD_NAME = GPS.PERIOD_NAME );
142:
143: BEGIN
144:

Line 157: x_stage := 'INSERT INTO PA_PERIODS';

153: FOR xperiod IN C_GlPeriods(X_sob_id) LOOP
154:
155: l_rec_count := l_rec_count + 1;
156:
157: x_stage := 'INSERT INTO PA_PERIODS';
158: INSERT INTO pa_periods (
159: period_name
160: , last_update_date
161: , last_updated_by

Line 158: INSERT INTO pa_periods (

154:
155: l_rec_count := l_rec_count + 1;
156:
157: x_stage := 'INSERT INTO PA_PERIODS';
158: INSERT INTO pa_periods (
159: period_name
160: , last_update_date
161: , last_updated_by
162: , creation_date

Line 215: trying to manipulate the GL period name into which the PA periods falls.

211:
212: /*****************************************************************************
213: Bug# 3271356 :
214: FUNCTION check_gl_period_used_in_pa :This is used by GL to prevent the user
215: trying to manipulate the GL period name into which the PA periods falls.
216: *****************************************************************************/
217:
218: FUNCTION check_gl_period_used_in_pa ( p_period_name IN VARCHAR2,
219: p_period_set_name IN VARCHAR2)

Line 223: l_period_name pa_periods_all.period_name%TYPE;

219: p_period_set_name IN VARCHAR2)
220: RETURN VARCHAR2 is
221:
222: l_temp varchar2(1);
223: l_period_name pa_periods_all.period_name%TYPE;
224:
225: l_pji_name pji_time_cal_period.NAME%TYPE;
226:
227: l_rec_count NUMBER;

Line 232: FROM PA_PERIODS_ALL prd,

228:
229:
230: CURSOR period_cur IS
231: SELECT period_name
232: FROM PA_PERIODS_ALL prd,
233: PA_IMPLEMENTATIONS_ALL imp,
234: GL_SETS_OF_BOOKS sob
235: WHERE (period_name = p_period_name
236: OR gl_period_name = p_period_name)

Line 253: FROM PA_PERIODS_ALL prd,

249: If period_cur%NOTFOUND Then
250:
251: SELECT COUNT(*)
252: into l_rec_count
253: FROM PA_PERIODS_ALL prd,
254: PA_IMPLEMENTATIONS_ALL imp
255: WHERE ( period_name = p_period_name
256: OR gl_period_name =p_period_name)
257: AND prd.org_id = imp.org_id /* Removed the NVL check for bug 6811046*/

Line 301: END pa_periods_pkg;

297: Raise;
298: END check_gl_period_used_in_pa;
299: /*End of changes for Bug# 3271356 */
300:
301: END pa_periods_pkg;