eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_H2PI_PERSON_UPLOAD dependencies on PAY_COST_ALLOCATIONS_F

Line 3088: FROM pay_cost_allocations_f pca

3084:
3085: CURSOR csr_ed_cost_allocation_ovn (p_cost_allocation_id NUMBER,
3086: p_esd DATE) IS
3087: SELECT pca.object_version_number
3088: FROM pay_cost_allocations_f pca
3089: WHERE pca.cost_allocation_id = p_cost_allocation_id
3090: AND p_esd BETWEEN pca.effective_start_date
3091: AND pca.effective_end_date;
3092:

Line 3099: l_assignment_id pay_cost_allocations_f.assignment_id%TYPE;

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);
3102: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3103: l_ovn pay_cost_allocations_f.object_version_number%TYPE;

Line 3100: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;

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);
3102: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3103: l_ovn pay_cost_allocations_f.object_version_number%TYPE;
3104: l_esd pay_cost_allocations_f.effective_start_date%TYPE;

Line 3103: l_ovn pay_cost_allocations_f.object_version_number%TYPE;

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);
3102: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3103: l_ovn pay_cost_allocations_f.object_version_number%TYPE;
3104: l_esd pay_cost_allocations_f.effective_start_date%TYPE;
3105: l_eed pay_cost_allocations_f.effective_end_date%TYPE;
3106:
3107: l_max_eed pay_cost_allocations_f.effective_end_date%TYPE;

Line 3104: l_esd pay_cost_allocations_f.effective_start_date%TYPE;

3100: l_cost_allocation_id pay_cost_allocations_f.cost_allocation_id%TYPE;
3101: l_combination_name VARCHAR2(240);
3102: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3103: l_ovn pay_cost_allocations_f.object_version_number%TYPE;
3104: l_esd pay_cost_allocations_f.effective_start_date%TYPE;
3105: l_eed pay_cost_allocations_f.effective_end_date%TYPE;
3106:
3107: l_max_eed pay_cost_allocations_f.effective_end_date%TYPE;
3108: l_del_ovn pay_cost_allocations_f.object_version_number%TYPE;

Line 3105: l_eed pay_cost_allocations_f.effective_end_date%TYPE;

3101: l_combination_name VARCHAR2(240);
3102: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3103: l_ovn pay_cost_allocations_f.object_version_number%TYPE;
3104: l_esd pay_cost_allocations_f.effective_start_date%TYPE;
3105: l_eed pay_cost_allocations_f.effective_end_date%TYPE;
3106:
3107: l_max_eed pay_cost_allocations_f.effective_end_date%TYPE;
3108: l_del_ovn pay_cost_allocations_f.object_version_number%TYPE;
3109: l_del_esd pay_cost_allocations_f.effective_start_date%TYPE;

Line 3107: l_max_eed pay_cost_allocations_f.effective_end_date%TYPE;

3103: l_ovn pay_cost_allocations_f.object_version_number%TYPE;
3104: l_esd pay_cost_allocations_f.effective_start_date%TYPE;
3105: l_eed pay_cost_allocations_f.effective_end_date%TYPE;
3106:
3107: l_max_eed pay_cost_allocations_f.effective_end_date%TYPE;
3108: l_del_ovn pay_cost_allocations_f.object_version_number%TYPE;
3109: l_del_esd pay_cost_allocations_f.effective_start_date%TYPE;
3110: l_del_eed pay_cost_allocations_f.effective_end_date%TYPE;
3111: l_val_esd pay_cost_allocations_f.effective_start_date%TYPE;

Line 3108: l_del_ovn pay_cost_allocations_f.object_version_number%TYPE;

3104: l_esd pay_cost_allocations_f.effective_start_date%TYPE;
3105: l_eed pay_cost_allocations_f.effective_end_date%TYPE;
3106:
3107: l_max_eed pay_cost_allocations_f.effective_end_date%TYPE;
3108: l_del_ovn pay_cost_allocations_f.object_version_number%TYPE;
3109: l_del_esd pay_cost_allocations_f.effective_start_date%TYPE;
3110: l_del_eed pay_cost_allocations_f.effective_end_date%TYPE;
3111: l_val_esd pay_cost_allocations_f.effective_start_date%TYPE;
3112: l_val_eed pay_cost_allocations_f.effective_end_date%TYPE;

Line 3109: l_del_esd pay_cost_allocations_f.effective_start_date%TYPE;

3105: l_eed pay_cost_allocations_f.effective_end_date%TYPE;
3106:
3107: l_max_eed pay_cost_allocations_f.effective_end_date%TYPE;
3108: l_del_ovn pay_cost_allocations_f.object_version_number%TYPE;
3109: l_del_esd pay_cost_allocations_f.effective_start_date%TYPE;
3110: l_del_eed pay_cost_allocations_f.effective_end_date%TYPE;
3111: l_val_esd pay_cost_allocations_f.effective_start_date%TYPE;
3112: l_val_eed pay_cost_allocations_f.effective_end_date%TYPE;
3113: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;

Line 3110: l_del_eed pay_cost_allocations_f.effective_end_date%TYPE;

3106:
3107: l_max_eed pay_cost_allocations_f.effective_end_date%TYPE;
3108: l_del_ovn pay_cost_allocations_f.object_version_number%TYPE;
3109: l_del_esd pay_cost_allocations_f.effective_start_date%TYPE;
3110: l_del_eed pay_cost_allocations_f.effective_end_date%TYPE;
3111: l_val_esd pay_cost_allocations_f.effective_start_date%TYPE;
3112: l_val_eed pay_cost_allocations_f.effective_end_date%TYPE;
3113: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;
3114:

Line 3111: l_val_esd pay_cost_allocations_f.effective_start_date%TYPE;

3107: l_max_eed pay_cost_allocations_f.effective_end_date%TYPE;
3108: l_del_ovn pay_cost_allocations_f.object_version_number%TYPE;
3109: l_del_esd pay_cost_allocations_f.effective_start_date%TYPE;
3110: l_del_eed pay_cost_allocations_f.effective_end_date%TYPE;
3111: l_val_esd pay_cost_allocations_f.effective_start_date%TYPE;
3112: l_val_eed pay_cost_allocations_f.effective_end_date%TYPE;
3113: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;
3114:
3115: l_records_same BOOLEAN;

Line 3112: l_val_eed pay_cost_allocations_f.effective_end_date%TYPE;

3108: l_del_ovn pay_cost_allocations_f.object_version_number%TYPE;
3109: l_del_esd pay_cost_allocations_f.effective_start_date%TYPE;
3110: l_del_eed pay_cost_allocations_f.effective_end_date%TYPE;
3111: l_val_esd pay_cost_allocations_f.effective_start_date%TYPE;
3112: l_val_eed pay_cost_allocations_f.effective_end_date%TYPE;
3113: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;
3114:
3115: l_records_same BOOLEAN;
3116: l_future_records BOOLEAN;

Line 3113: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;

3109: l_del_esd pay_cost_allocations_f.effective_start_date%TYPE;
3110: l_del_eed pay_cost_allocations_f.effective_end_date%TYPE;
3111: l_val_esd pay_cost_allocations_f.effective_start_date%TYPE;
3112: l_val_eed pay_cost_allocations_f.effective_end_date%TYPE;
3113: l_business_group_id pay_cost_allocations_f.business_group_id%TYPE;
3114:
3115: l_records_same BOOLEAN;
3116: l_future_records BOOLEAN;
3117: l_update_mode VARCHAR2(30);

Line 3132: (p_table_name => 'PAY_COST_ALLOCATIONS_F',

3128: IF v_ud_hca.last_upd_date = g_eot THEN
3129:
3130: hr_utility.set_location(l_proc, 20);
3131: l_cost_allocation_id := hr_h2pi_map.get_to_id
3132: (p_table_name => 'PAY_COST_ALLOCATIONS_F',
3133: p_from_id => v_ud_hca.cost_allocation_id,
3134: p_report_error => TRUE);
3135:
3136: hr_utility.set_location(l_proc, 30);

Line 3166: (p_table_name => 'PAY_COST_ALLOCATIONS_F',

3162: p_from_id => v_ud_hca.assignment_id,
3163: p_report_error => TRUE);
3164:
3165: l_cost_allocation_id := hr_h2pi_map.get_to_id
3166: (p_table_name => 'PAY_COST_ALLOCATIONS_F',
3167: p_from_id => v_ud_hca.cost_allocation_id);
3168:
3169: IF l_cost_allocation_id = -1 THEN
3170: hr_utility.set_location(l_proc, 50);

Line 3216: (p_table_name => 'PAY_COST_ALLOCATIONS_F',

3212: ,p_object_version_number => l_ovn );
3213:
3214: hr_utility.set_location(l_proc, 60);
3215: hr_h2pi_map.create_id_mapping
3216: (p_table_name => 'PAY_COST_ALLOCATIONS_F',
3217: p_from_id => v_ud_hca.cost_allocation_id,
3218: p_to_id => l_cost_allocation_id);
3219: ELSE
3220:

Line 3257: FROM pay_cost_allocations_f caf

3253: l_records_same := FALSE;
3254:
3255: SELECT MAX(caf.effective_end_date)
3256: INTO l_max_eed
3257: FROM pay_cost_allocations_f caf
3258: WHERE caf.cost_allocation_id = l_cost_allocation_id;
3259:
3260: IF l_max_eed > v_ed_hca.effective_end_date THEN
3261: hr_utility.set_location(l_proc, 110);