APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_COST_ALLOCATIONS

Line 183: INSERT INTO hr_h2pi_cost_allocations

179: GROUP BY person_id, personal_payment_method_id,business_group_id
180: HAVING MAX(effective_end_date) <> g_eot;
181:
182: hr_utility.set_location(l_proc, 50);
183: INSERT INTO hr_h2pi_cost_allocations
184: (cost_allocation_id,
185: effective_start_date,
186: effective_end_date,
187: last_upd_date,

Line 208: FROM hr_h2pi_cost_allocations

204: -1,
205: id_flex_num,
206: summary_flag,
207: enabled_flag
208: FROM hr_h2pi_cost_allocations
209: WHERE client_id = p_from_client_id
210: GROUP BY person_id, cost_allocation_id,business_group_id,
211: id_flex_num,summary_flag,enabled_flag
212: HAVING MAX(effective_end_date) <> g_eot;

Line 333: DELETE FROM hr_h2pi_cost_allocations

329: DELETE FROM hr_h2pi_salaries
330: WHERE client_id = p_from_client_id
331: AND status = 'C';
332:
333: DELETE FROM hr_h2pi_cost_allocations
334: WHERE client_id = p_from_client_id
335: AND status = 'C';
336:
337: DELETE FROM hr_h2pi_payment_methods

Line 421: FROM hr_h2pi_cost_allocations

417: WHERE (status IS NULL OR status <> 'C')
418: AND client_id = p_bg_id
419: UNION
420: SELECT DISTINCT person_id
421: FROM hr_h2pi_cost_allocations
422: WHERE (status IS NULL OR status <> 'C')
423: AND client_id = p_bg_id
424: UNION
425: SELECT DISTINCT person_id

Line 529: FROM HR_H2PI_COST_ALLOCATIONS

525: effective_start_date eff_date,
526: 8 ord,
527: 'upload_cost_allocation' fn_name,
528: DECODE(last_upd_date, g_eot, 1, 2) sub_order
529: FROM HR_H2PI_COST_ALLOCATIONS
530: WHERE (status IS NULL OR status <> 'C')
531: AND person_id = p_per_id
532: AND client_id = p_from_client_id
533: UNION

Line 3072: FROM hr_h2pi_cost_allocations hca

3068:
3069: CURSOR csr_ud_cost_allocation (p_cost_allocation_id NUMBER,
3070: p_esd DATE) IS
3071: SELECT *
3072: FROM hr_h2pi_cost_allocations hca
3073: WHERE hca.cost_allocation_id = p_cost_allocation_id
3074: AND hca.client_id = p_from_client_id
3075: AND hca.effective_start_date = p_esd;
3076:

Line 3080: FROM hr_h2pi_cost_allocations_v hca

3076:
3077: CURSOR csr_ed_cost_allocation (p_cost_allocation_id NUMBER,
3078: p_esd DATE) IS
3079: SELECT *
3080: FROM hr_h2pi_cost_allocations_v hca
3081: WHERE hca.cost_allocation_id = p_cost_allocation_id
3082: AND p_esd BETWEEN hca.effective_start_date
3083: AND hca.effective_end_date;
3084:

Line 3096: v_ud_hca hr_h2pi_cost_allocations%ROWTYPE;

3092:
3093: l_encoded_message VARCHAR2(200);
3094: l_proc VARCHAR2(72) := g_package||'upload_cost_allocation';
3095:
3096: v_ud_hca hr_h2pi_cost_allocations%ROWTYPE;
3097: v_ed_hca hr_h2pi_cost_allocations_v%ROWTYPE;
3098:
3099: l_assignment_id pay_cost_allocations_f.assignment_id%TYPE;
3100: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;

Line 3097: v_ed_hca hr_h2pi_cost_allocations_v%ROWTYPE;

3093: l_encoded_message VARCHAR2(200);
3094: l_proc VARCHAR2(72) := g_package||'upload_cost_allocation';
3095:
3096: v_ud_hca hr_h2pi_cost_allocations%ROWTYPE;
3097: v_ed_hca hr_h2pi_cost_allocations_v%ROWTYPE;
3098:
3099: l_assignment_id pay_cost_allocations_f.assignment_id%TYPE;
3100: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;
3101: l_combination_name VARCHAR2(240);

Line 3234: p_table_name => 'HR_H2PI_COST_ALLOCATIONS',

3230: ROLLBACK;
3231: hr_utility.set_location(l_proc, 90);
3232: hr_h2pi_error.data_error
3233: (p_from_id => l_cost_allocation_id,
3234: p_table_name => 'HR_H2PI_COST_ALLOCATIONS',
3235: p_message_level => 'FATAL',
3236: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
3237: COMMIT;
3238: RAISE MAPPING_ID_INVALID;

Line 3350: UPDATE hr_h2pi_cost_allocations hca

3346: END IF;
3347: END IF;
3348:
3349: hr_utility.set_location(l_proc, 170);
3350: UPDATE hr_h2pi_cost_allocations hca
3351: SET status = 'C'
3352: WHERE hca.cost_allocation_id = v_ud_hca.cost_allocation_id
3353: AND hca.client_id = p_from_client_id
3354: AND hca.effective_start_date = v_ud_hca.effective_start_date

Line 3368: p_table_name => 'HR_H2PI_COST_ALLOCATIONS',

3364: hr_utility.set_location(l_proc, 190);
3365: l_encoded_message := fnd_message.get_encoded;
3366: hr_h2pi_error.data_error
3367: (p_from_id => v_ud_hca.cost_allocation_id,
3368: p_table_name => 'HR_H2PI_COST_ALLOCATIONS',
3369: p_message_level => 'FATAL',
3370: p_message_text => l_encoded_message);
3371: COMMIT;
3372: RAISE;