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.HXT_INTERFACE_UTILITIES dependencies on PER_ALL_ASSIGNMENTS_F

Line 931: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

927: RETURN l_detail_lines_retrieved;
928: END detail_lines_retrieved;
929:
930: FUNCTION gre (
931: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
932: p_effective_date IN per_all_assignments_f.effective_start_date%TYPE
933: )
934: RETURN hr_soft_coding_keyflex.segment1%TYPE
935: IS

Line 932: p_effective_date IN per_all_assignments_f.effective_start_date%TYPE

928: END detail_lines_retrieved;
929:
930: FUNCTION gre (
931: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
932: p_effective_date IN per_all_assignments_f.effective_start_date%TYPE
933: )
934: RETURN hr_soft_coding_keyflex.segment1%TYPE
935: IS
936: l_proc proc_name ;

Line 939: p_assignment_id per_all_assignments_f.assignment_id%TYPE,

935: IS
936: l_proc proc_name ;
937:
938: CURSOR csr_gre (
939: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
940: p_effective_date per_all_assignments_f.effective_start_date%TYPE
941: )
942: IS
943: SELECT hsck.segment1 gre

Line 940: p_effective_date per_all_assignments_f.effective_start_date%TYPE

936: l_proc proc_name ;
937:
938: CURSOR csr_gre (
939: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
940: p_effective_date per_all_assignments_f.effective_start_date%TYPE
941: )
942: IS
943: SELECT hsck.segment1 gre
944: FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck

Line 944: FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck

940: p_effective_date per_all_assignments_f.effective_start_date%TYPE
941: )
942: IS
943: SELECT hsck.segment1 gre
944: FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck
945: WHERE paaf.assignment_id = p_assignment_id
946: AND p_effective_date BETWEEN paaf.effective_start_date
947: AND paaf.effective_end_date
948: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;

Line 1050: p_asg_type IN per_all_assignments_f.assignment_type%TYPE,

1046: RETURN l_list;
1047: END table_to_comma;
1048:
1049: FUNCTION valid_assignment_type (
1050: p_asg_type IN per_all_assignments_f.assignment_type%TYPE,
1051: p_validation_tbl IN asg_type_table
1052: )
1053: RETURN BOOLEAN
1054: AS

Line 1154: RETURN per_all_assignments_f.assignment_id%TYPE

1150: p_effective_date IN DATE,
1151: p_valid_asg_types IN asg_type_table,
1152: p_valid_asg_status_types IN asg_system_status_table
1153: )
1154: RETURN per_all_assignments_f.assignment_id%TYPE
1155: IS
1156: l_proc proc_name ;
1157:
1158: CURSOR csr_prim_asg (

Line 1183: l_prim_asg_id per_all_assignments_f.assignment_id%TYPE := NULL;

1179: OR LENGTH (p_asg_system_type_list) IS NULL -- if the list is empty ALL asg are valid
1180: );
1181:
1182: l_rec_prim_asg csr_prim_asg%ROWTYPE;
1183: l_prim_asg_id per_all_assignments_f.assignment_id%TYPE := NULL;
1184: l_found_in_cache BOOLEAN := FALSE;
1185: BEGIN
1186: g_debug :=hr_utility.debug_enabled;
1187: if g_debug then

Line 1260: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1256: RETURN l_prim_asg_id;
1257: END primary_assignment_id;
1258:
1259: PROCEDURE get_assignment_info (
1260: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1261: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1262: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1263: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1264: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,

Line 1261: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,

1257: END primary_assignment_id;
1258:
1259: PROCEDURE get_assignment_info (
1260: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1261: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1262: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1263: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1264: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1265: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,

Line 1262: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,

1258:
1259: PROCEDURE get_assignment_info (
1260: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1261: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1262: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1263: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1264: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1265: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1266: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE

Line 1263: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,

1259: PROCEDURE get_assignment_info (
1260: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1261: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1262: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1263: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1264: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1265: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1266: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
1267: )

Line 1264: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,

1260: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1261: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1262: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1263: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1264: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1265: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1266: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
1267: )
1268: IS

Line 1265: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,

1261: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1262: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1263: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1264: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1265: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1266: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
1267: )
1268: IS
1269: l_proc proc_name ;

Line 1266: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE

1262: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1263: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1264: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1265: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1266: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
1267: )
1268: IS
1269: l_proc proc_name ;
1270:

Line 1272: p_assignment_id per_all_assignments_f.assignment_id%TYPE,

1268: IS
1269: l_proc proc_name ;
1270:
1271: CURSOR csr_assignment_info (
1272: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
1273: p_effective_date per_all_assignments_f.effective_end_date%TYPE
1274: )
1275: IS
1276: SELECT paaf.assignment_number, paaf.payroll_id, paaf.organization_id,

Line 1273: p_effective_date per_all_assignments_f.effective_end_date%TYPE

1269: l_proc proc_name ;
1270:
1271: CURSOR csr_assignment_info (
1272: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
1273: p_effective_date per_all_assignments_f.effective_end_date%TYPE
1274: )
1275: IS
1276: SELECT paaf.assignment_number, paaf.payroll_id, paaf.organization_id,
1277: paaf.location_id, paaf.business_group_id,

Line 1280: FROM per_all_assignments_f paaf

1276: SELECT paaf.assignment_number, paaf.payroll_id, paaf.organization_id,
1277: paaf.location_id, paaf.business_group_id,
1278: paaf.assignment_type, paaf.effective_start_date,
1279: paaf.effective_end_date
1280: FROM per_all_assignments_f paaf
1281: WHERE paaf.assignment_id = p_assignment_id
1282: AND p_effective_date BETWEEN paaf.effective_start_date
1283: AND paaf.effective_end_date;
1284:

Line 1360: p_person_id IN per_all_assignments_f.person_id%TYPE,

1356: end if;
1357: END get_assignment_info;
1358:
1359: PROCEDURE get_primary_assignment_info (
1360: p_person_id IN per_all_assignments_f.person_id%TYPE,
1361: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1362: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1363: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1364: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,

Line 1361: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,

1357: END get_assignment_info;
1358:
1359: PROCEDURE get_primary_assignment_info (
1360: p_person_id IN per_all_assignments_f.person_id%TYPE,
1361: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1362: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1363: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1364: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1365: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,

Line 1362: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,

1358:
1359: PROCEDURE get_primary_assignment_info (
1360: p_person_id IN per_all_assignments_f.person_id%TYPE,
1361: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1362: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1363: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1364: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1365: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1366: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,

Line 1363: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,

1359: PROCEDURE get_primary_assignment_info (
1360: p_person_id IN per_all_assignments_f.person_id%TYPE,
1361: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1362: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1363: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1364: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1365: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1366: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1367: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE

Line 1364: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,

1360: p_person_id IN per_all_assignments_f.person_id%TYPE,
1361: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1362: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1363: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1364: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1365: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1366: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1367: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
1368: )

Line 1365: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,

1361: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
1362: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1363: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1364: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1365: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1366: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1367: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
1368: )
1369: IS

Line 1366: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,

1362: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1363: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1364: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1365: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1366: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1367: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
1368: )
1369: IS
1370: l_proc proc_name;

Line 1367: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE

1363: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1364: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
1365: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
1366: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
1367: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
1368: )
1369: IS
1370: l_proc proc_name;
1371:

Line 1467: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,

1463: END is_person;
1464:
1465: PROCEDURE assignment_info (
1466: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
1467: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1468: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
1469: )
1470: AS
1471: l_proc proc_name ;

Line 1468: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

1464:
1465: PROCEDURE assignment_info (
1466: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
1467: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1468: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
1469: )
1470: AS
1471: l_proc proc_name ;
1472: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 1472: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

1468: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
1469: )
1470: AS
1471: l_proc proc_name ;
1472: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1473: l_org_id per_all_assignments_f.organization_id%TYPE;
1474: l_location_id per_all_assignments_f.location_id%TYPE;
1475: l_bg_id per_all_assignments_f.business_group_id%TYPE;
1476: BEGIN

Line 1473: l_org_id per_all_assignments_f.organization_id%TYPE;

1469: )
1470: AS
1471: l_proc proc_name ;
1472: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1473: l_org_id per_all_assignments_f.organization_id%TYPE;
1474: l_location_id per_all_assignments_f.location_id%TYPE;
1475: l_bg_id per_all_assignments_f.business_group_id%TYPE;
1476: BEGIN
1477: g_debug :=hr_utility.debug_enabled;

Line 1474: l_location_id per_all_assignments_f.location_id%TYPE;

1470: AS
1471: l_proc proc_name ;
1472: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1473: l_org_id per_all_assignments_f.organization_id%TYPE;
1474: l_location_id per_all_assignments_f.location_id%TYPE;
1475: l_bg_id per_all_assignments_f.business_group_id%TYPE;
1476: BEGIN
1477: g_debug :=hr_utility.debug_enabled;
1478: if g_debug then

Line 1475: l_bg_id per_all_assignments_f.business_group_id%TYPE;

1471: l_proc proc_name ;
1472: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1473: l_org_id per_all_assignments_f.organization_id%TYPE;
1474: l_location_id per_all_assignments_f.location_id%TYPE;
1475: l_bg_id per_all_assignments_f.business_group_id%TYPE;
1476: BEGIN
1477: g_debug :=hr_utility.debug_enabled;
1478: if g_debug then
1479: l_proc := g_package

Line 2150: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

2146: RETURN l_accrual_plan_ivs;
2147: END accr_plan_added_date_ivs;
2148:
2149: FUNCTION accrual_plan_ids (
2150: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2151: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
2152: )
2153: RETURN accrual_plan_id_table
2154: AS

Line 2158: p_assignment_id per_all_assignments_f.assignment_id%TYPE,

2154: AS
2155: l_proc proc_name ;
2156:
2157: CURSOR csr_accrual_plan_ids (
2158: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
2159: p_effective_date pay_element_types_f.effective_start_date%TYPE
2160: )
2161: IS
2162: SELECT pap.accrual_plan_id

Line 2200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

2196: RETURN l_accrual_plan_ids;
2197: END accrual_plan_ids;
2198:
2199: FUNCTION accrual_plan_exists (
2200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2201: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
2202: p_accrual_plan_id IN pay_accrual_plans.accrual_plan_id%TYPE
2203: )
2204: RETURN BOOLEAN

Line 2873: RETURN per_all_assignments_f.assignment_id%TYPE

2869: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
2870: p_effective_date IN DATE,
2871: p_bee_rec IN bee_rec
2872: )
2873: RETURN per_all_assignments_f.assignment_id%TYPE
2874: AS
2875: l_proc proc_name ;
2876: CURSOR csr_asg_id (
2877: p_bg_id pay_batch_headers.business_group_id%TYPE,

Line 2879: p_assignment_number per_all_assignments_f.assignment_number%TYPE

2875: l_proc proc_name ;
2876: CURSOR csr_asg_id (
2877: p_bg_id pay_batch_headers.business_group_id%TYPE,
2878: p_effective_date DATE,
2879: p_assignment_number per_all_assignments_f.assignment_number%TYPE
2880: )
2881: IS
2882: SELECT assignment_id
2883: FROM per_all_assignments_f

Line 2883: FROM per_all_assignments_f

2879: p_assignment_number per_all_assignments_f.assignment_number%TYPE
2880: )
2881: IS
2882: SELECT assignment_id
2883: FROM per_all_assignments_f
2884: WHERE assignment_number = p_assignment_number
2885: AND business_group_id = p_bg_id
2886: AND p_effective_date BETWEEN effective_start_date
2887: AND effective_end_date;

Line 2889: l_asg_id per_all_assignments_f.assignment_id%TYPE;

2885: AND business_group_id = p_bg_id
2886: AND p_effective_date BETWEEN effective_start_date
2887: AND effective_end_date;
2888:
2889: l_asg_id per_all_assignments_f.assignment_id%TYPE;
2890: BEGIN
2891:
2892: if g_debug then
2893: l_proc := g_package

Line 2920: RETURN per_all_assignments_f.assignment_number%TYPE

2916: RETURN l_asg_id;
2917: END asg_id;
2918:
2919: FUNCTION asg_num (p_effective_date IN DATE, p_bee_rec IN bee_rec)
2920: RETURN per_all_assignments_f.assignment_number%TYPE
2921: AS
2922: l_proc proc_name ;
2923: CURSOR csr_asg_num (
2924: p_effective_date DATE,

Line 2925: p_assignment_id per_all_assignments_f.assignment_id%TYPE

2921: AS
2922: l_proc proc_name ;
2923: CURSOR csr_asg_num (
2924: p_effective_date DATE,
2925: p_assignment_id per_all_assignments_f.assignment_id%TYPE
2926: )
2927: IS
2928: SELECT assignment_number
2929: FROM per_all_assignments_f

Line 2929: FROM per_all_assignments_f

2925: p_assignment_id per_all_assignments_f.assignment_id%TYPE
2926: )
2927: IS
2928: SELECT assignment_number
2929: FROM per_all_assignments_f
2930: WHERE assignment_id = p_assignment_id
2931: AND p_effective_date BETWEEN effective_start_date
2932: AND effective_end_date;
2933:

Line 2934: l_asg_num per_all_assignments_f.assignment_number%TYPE;

2930: WHERE assignment_id = p_assignment_id
2931: AND p_effective_date BETWEEN effective_start_date
2932: AND effective_end_date;
2933:
2934: l_asg_num per_all_assignments_f.assignment_number%TYPE;
2935: BEGIN
2936:
2937: if g_debug then
2938: l_proc := g_package