APPS.PA_PERIOD_MASKS_PUB dependencies on PA_PERIOD_MASKS_S

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 173: SELECT pa_period_masks_s.nextval INTO l_period_masks_s FROM DUAL;

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;
175: /*populating table pa_period_masks_b*/
176: INSERT INTO pa_period_masks_b (
177: PERIOD_MASK_ID,

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,