APPS.PA_PERIOD_MASKS_PUB dependencies on PA_PERIOD_MASKS_TL

Line 170: *Populate both the master record in pa_period_masks_s + pa_period_masks_tl

166: return;
167: END IF;
168:
169: /**if period_mask_id is null, then we need to INSERT
170: *Populate both the master record in pa_period_masks_s + pa_period_masks_tl
171: *and detail record in pa_period_mask_details*/
172: IF p_period_mask_id = 0 THEN
173: SELECT pa_period_masks_s.nextval INTO l_period_masks_s FROM DUAL;
174: SELECT userenv('LANG') INTO l_language FROM dual;

Line 200: /*populating table pa_period_masks_tl*/

196: FND_GLOBAL.LOGIN_ID,
197: sysdate,
198: 1,
199: 'N');
200: /*populating table pa_period_masks_tl*/
201: INSERT INTO pa_period_masks_tl (
202: PERIOD_MASK_ID,
203: NAME,
204: DESCRIPTION,

Line 201: INSERT INTO pa_period_masks_tl (

197: sysdate,
198: 1,
199: 'N');
200: /*populating table pa_period_masks_tl*/
201: INSERT INTO pa_period_masks_tl (
202: PERIOD_MASK_ID,
203: NAME,
204: DESCRIPTION,
205: LANGUAGE,

Line 224: (select null from PA_PERIOD_MASKS_TL T

220: FND_GLOBAL.USER_ID,
221: FND_GLOBAL.LOGIN_ID /*Changes for Bug 6275098 */
222: from FND_LANGUAGES L where L.INSTALLED_FLAG in ('I', 'B')
223: and not exists
224: (select null from PA_PERIOD_MASKS_TL T
225: where T.PERIOD_MASK_ID = l_period_masks_s
226: and T.LANGUAGE = L.LANGUAGE_CODE);
227:
228: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 265: *Update both the master record in pa_period_masks_s + pa_period_masks_tl

261: RETURN;
262: END IF;
263:
264: /**if period_mask_id is not null, then we need to UPDATE
265: *Update both the master record in pa_period_masks_s + pa_period_masks_tl
266: *and detail record in pa_period_mask_details*/
267: ELSE
268: UPDATE pa_period_masks_b
269: SET effective_start_date = p_effective_start_date,

Line 290: UPDATE pa_period_masks_tl

286: END IF;
287: RETURN;
288: END IF;
289:
290: UPDATE pa_period_masks_tl
291: SET name = p_name,
292: description = p_description,
293: last_update_login = FND_GLOBAL.LOGIN_ID,
294: last_updated_by = FND_GLOBAL.LOGIN_ID,

Line 631: DELETE FROM pa_period_masks_tl

627: END IF;
628: RETURN;
629: END IF;
630:
631: DELETE FROM pa_period_masks_tl
632: WHERE period_mask_id = p_period_mask_id;
633:
634: DELETE FROM pa_period_mask_details
635: WHERE period_mask_id = p_period_mask_id;