APPS.PA_PERIODS_PKG dependencies on GL_PERIOD_STATUSES

Line 73: x_stage := 'INSERT INTO GL_PERIOD_STATUSES';

69: , xperiod.gl_period_name
70: , NULL
71: , l_org_id ); -- 12i MOAC changes
72:
73: x_stage := 'INSERT INTO GL_PERIOD_STATUSES';
74: gl_period_statuses_pkg.insert_ps_api(
75: 275
76: , X_sob_id
77: , xperiod.period_name

Line 74: gl_period_statuses_pkg.insert_ps_api(

70: , NULL
71: , l_org_id ); -- 12i MOAC changes
72:
73: x_stage := 'INSERT INTO GL_PERIOD_STATUSES';
74: gl_period_statuses_pkg.insert_ps_api(
75: 275
76: , X_sob_id
77: , xperiod.period_name
78: , 'O'

Line 85: /* Bug 2579245: Inserting record in gl_period_statuses*/

81: , l_imp_period_set_name
82: , X_user_id
83: , X_login_id );
84:
85: /* Bug 2579245: Inserting record in gl_period_statuses*/
86: /* gl_period_statuses_pkg.insert_ps_api(
87: 275
88: , X_sob_id
89: , xperiod.gl_period_name

Line 86: /* gl_period_statuses_pkg.insert_ps_api(

82: , X_user_id
83: , X_login_id );
84:
85: /* Bug 2579245: Inserting record in gl_period_statuses*/
86: /* gl_period_statuses_pkg.insert_ps_api(
87: 275
88: , X_sob_id
89: , xperiod.gl_period_name
90: , 'O'

Line 134: gl_period_statuses gps

130: , start_date
131: , end_date
132: , closing_status
133: FROM
134: gl_period_statuses gps
135: WHERE gps.application_id = 8721
136: and gps.adjustment_period_flag = 'N'
137: and gps.set_of_books_id = p_sob_id
138: and not exists (

Line 187: /* x_stage := 'UPDATE GL_PERIOD_STATUSES';

183: , l_org_id); -- 12i MOAC changes
184:
185: /*Bug# 3271356 :Reverted the fix of 2579245*/
186: /* Bug 2579245 : updating the status of gl_period to open */
187: /* x_stage := 'UPDATE GL_PERIOD_STATUSES';
188: UPDATE gl_period_statuses
189: SET closing_status = 'O'
190: WHERE application_id = 8721
191: AND set_of_books_id = X_sob_id

Line 188: UPDATE gl_period_statuses

184:
185: /*Bug# 3271356 :Reverted the fix of 2579245*/
186: /* Bug 2579245 : updating the status of gl_period to open */
187: /* x_stage := 'UPDATE GL_PERIOD_STATUSES';
188: UPDATE gl_period_statuses
189: SET closing_status = 'O'
190: WHERE application_id = 8721
191: AND set_of_books_id = X_sob_id
192: AND period_name = xperiod.period_name; Commented for Bug 3271356*/