APPS.PA_PERIOD_MASKS_PUB dependencies on PA_PERIOD_MASK_DETAILS

Line 171: *and detail record in pa_period_mask_details*/

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;
175: /*populating table pa_period_masks_b*/

Line 235: /*populating table pa_period_mask_details*/

231: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS',
232: p_module_name => l_module_name,
233: p_log_level => 5);
234: END IF;
235: /*populating table pa_period_mask_details*/
236: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS(
237: p_period_mask_id => l_period_masks_s,
238: p_num_of_periods => p_num_of_periods,
239: p_anchor_period_flag => p_anchor_period_flag,

Line 266: *and detail record in pa_period_mask_details*/

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,
270: effective_end_date = p_effective_end_date,

Line 299: DELETE FROM pa_period_mask_details

295: last_update_date = sysdate
296: WHERE period_mask_id = p_period_mask_id;
297:
298:
299: DELETE FROM pa_period_mask_details
300: WHERE period_mask_id = p_period_mask_id;
301: l_rec_count := p_num_of_periods.count();
302:
303: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 542: INSERT INTO pa_period_mask_details(PERIOD_MASK_ID,

538: END IF;
539:
540:
541:
542: INSERT INTO pa_period_mask_details(PERIOD_MASK_ID,
543: num_of_periods,
544: anchor_period_flag,
545: from_anchor_start,
546: from_anchor_end,

Line 634: DELETE FROM pa_period_mask_details

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;
636:
637: IF (p_commit_flag = 'Y') THEN
638: COMMIT;