APPS.PA_PERIOD_MASKS_PUB dependencies on PA_PERIOD_MASKS_B

Line 10: p_effective_start_date IN pa_period_masks_b.effective_start_date%type,

6: p_period_mask_id IN NUMBER,
7: p_name IN VARCHAR2,
8: p_description IN VARCHAR2,
9: p_time_phase_code IN VARCHAR2,
10: p_effective_start_date IN pa_period_masks_b.effective_start_date%type,
11: p_effective_end_date IN pa_period_masks_b.effective_end_date%type,
12: p_record_version_number IN NUMBER,
13: p_num_of_periods IN PA_NUM_1000_NUM,
14: p_anchor_period_flag IN PA_VC_1000_150,

Line 11: p_effective_end_date IN pa_period_masks_b.effective_end_date%type,

7: p_name IN VARCHAR2,
8: p_description IN VARCHAR2,
9: p_time_phase_code IN VARCHAR2,
10: p_effective_start_date IN pa_period_masks_b.effective_start_date%type,
11: p_effective_end_date IN pa_period_masks_b.effective_end_date%type,
12: p_record_version_number IN NUMBER,
13: p_num_of_periods IN PA_NUM_1000_NUM,
14: p_anchor_period_flag IN PA_VC_1000_150,
15: p_from_anchor_position IN PA_NUM_1000_NUM,

Line 175: /*populating table pa_period_masks_b*/

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,
178: EFFECTIVE_START_DATE,
179: EFFECTIVE_END_DATE,

Line 176: INSERT INTO pa_period_masks_b (

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,
178: EFFECTIVE_START_DATE,
179: EFFECTIVE_END_DATE,
180: TIME_PHASE_CODE,

Line 268: UPDATE pa_period_masks_b

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,
271: time_phase_code = p_time_phase_code,
272: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 370: (p_period_mask_id IN PA_PERIOD_MASKS_B.PERIOD_MASK_ID%TYPE,

366:
367:
368: --*********************
369: PROCEDURE MAINTAIN_PERIOD_MASK_DTLS
370: (p_period_mask_id IN PA_PERIOD_MASKS_B.PERIOD_MASK_ID%TYPE,
371: p_num_of_periods IN PA_NUM_1000_NUM,
372: p_anchor_period_flag IN PA_VC_1000_150,
373: p_from_anchor_position IN PA_NUM_1000_NUM,
374: p_init_msg_flag IN VARCHAR2,

Line 618: DELETE FROM pa_period_masks_b

614: IF p_init_msg_flag = 'Y' THEN
615: FND_MSG_PUB.Initialize;
616: END IF;
617:
618: DELETE FROM pa_period_masks_b
619: WHERE period_mask_id = p_period_mask_id
620: and record_version_number = p_record_version_number;
621: IF (sql%notfound) THEN
622: x_return_status := FND_API.G_RET_STS_ERROR;