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.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIME_ENTRY_RULES_UTILS_PKG

Line 1: Package Body hxc_time_entry_rules_utils_pkg as

1: Package Body hxc_time_entry_rules_utils_pkg as
2: /* $Header: hxcterutl.pkb 120.15.12010000.5 2008/12/29 14:30:45 asrajago ship $ */
3: --
4: -- Package Variables
5: --

Line 898: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).assignment_id

894: CLOSE csr_get_first_asg_date;
895:
896: l_submission_date := GREATEST( l_submission_date, p_start_date );
897:
898: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).assignment_id
899: := l_assignment_id;
900: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).submission_date
901: := l_submission_date;
902: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).start_date

Line 900: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).submission_date

896: l_submission_date := GREATEST( l_submission_date, p_start_date );
897:
898: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).assignment_id
899: := l_assignment_id;
900: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).submission_date
901: := l_submission_date;
902: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).start_date
903: := p_start_date;
904: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).end_date

Line 902: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).start_date

898: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).assignment_id
899: := l_assignment_id;
900: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).submission_date
901: := l_submission_date;
902: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).start_date
903: := p_start_date;
904: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).end_date
905: := p_end_date;
906:

Line 904: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).end_date

900: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).submission_date
901: := l_submission_date;
902: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).start_date
903: := p_start_date;
904: hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).end_date
905: := p_end_date;
906:
907: END set_global_asg_info;
908:

Line 920: , p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype

916:
917: PROCEDURE execute_formula ( p_formula_name varchar2
918: , p_message_table IN OUT NOCOPY hxc_self_service_time_deposit.message_table
919: , p_message_level varchar2
920: , p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype
921: , p_tco_bb hxc_self_service_time_deposit.timecard_info
922: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info
923: , p_timecard_info r_timecard_info ) IS
924:

Line 962: , p_rule_record IN hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype ) IS

958: p_output_name IN VARCHAR2
959: , p_output_value IN VARCHAR2
960: , p_output_number IN NUMBER
961: , p_message_table IN OUT NOCOPY t_message_table
962: , p_rule_record IN hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype ) IS
963:
964: l_index BINARY_INTEGER;
965:
966: BEGIN

Line 1289: IF ( hxc_time_entry_rules_utils_pkg.return_archived_status(l_period_tab(p)) = false )

1285: if g_debug then
1286: hr_utility.set_location('Processing '||l_proc, 40);
1287: end if;
1288:
1289: IF ( hxc_time_entry_rules_utils_pkg.return_archived_status(l_period_tab(p)) = false )
1290: THEN
1291:
1292: -- check to see if any time entry rule has issued a commit i.e. the global tmp tables
1293: -- are empty. Stop processing of remaining time entry rules

Line 1314: hr_utility.trace('TER INC PTO plan id is '||hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id);

1310: , p_tco_bb => p_tco_bb
1311: , p_tco_att => p_tco_att );
1312:
1313: if g_debug then
1314: hr_utility.trace('TER INC PTO plan id is '||hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id);
1315: end if;
1316:
1317: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )
1318: THEN

Line 1317: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )

1313: if g_debug then
1314: hr_utility.trace('TER INC PTO plan id is '||hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id);
1315: end if;
1316:
1317: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )
1318: THEN
1319: -- calc incrementing PTO time category hours
1320:
1321: l_timecard_hrs := l_timecard_hrs - calc_timecard_hrs (

Line 1326: , p_time_category_id => hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id );

1322: p_hrs_period_start => l_period_tab(p).period_start
1323: , p_hrs_period_end => l_period_tab(p).period_end
1324: , p_tco_bb => p_tco_bb
1325: , p_tco_att => p_tco_att
1326: , p_time_category_id => hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id );
1327:
1328: END IF;
1329:
1330: if g_debug then

Line 1496: ,p_message_token => 'TER_NAME&'||hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name

1492:
1493: add_error_to_table (
1494: p_message_table => p_message_table
1495: ,p_message_name => 'HXC_ARCHIVE_TER_ERROR'
1496: ,p_message_token => 'TER_NAME&'||hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name
1497: ,p_message_level => 'ERROR'
1498: ,p_message_field => NULL
1499: ,p_timecard_bb_id=> NULL
1500: ,p_time_attribute_id=> NULL

Line 1505: end if; -- hxc_time_entry_rules_utils_pkg.return_archived_status(l_period_tab(p)) = false )

1501: ,p_timecard_bb_ovn => NULL
1502: ,p_time_attribute_ovn=> NULL
1503: ,p_message_extent =>hxc_timecard.c_blk_children_extent);
1504:
1505: end if; -- hxc_time_entry_rules_utils_pkg.return_archived_status(l_period_tab(p)) = false )
1506:
1507:
1508: if g_debug then
1509: hr_utility.set_location('Processing '||l_proc, 100);

Line 1733: hxc_time_entry_rules_utils_pkg.add_error_to_table (

1729: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1730: 'Stop BB Inner '||to_char(l_stop_detail,'DD-MON-YYYY:HH24:MI'));
1731: end if;
1732: --
1733: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1734: p_message_table => p_messages
1735: , p_message_name => 'HXT_39256_OVERLAPPING_TIME'
1736: , p_message_token => NULL
1737: , p_message_level => 'ERROR'

Line 1795: hxc_time_entry_rules_utils_pkg.add_error_to_table (

1791: -- End new code for Bug 2889097
1792: l_tc_db_overlap :=TRUE;
1793:
1794: -- Start new code for Bug 2889097
1795: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1796: p_message_table => p_messages
1797: , p_message_name => 'HXC_OVRLPPNG_TIME_TC_V_DB'
1798: , p_message_token => NULL
1799: , p_message_level => 'ERROR'

Line 1825: hxc_time_entry_rules_utils_pkg.add_error_to_table (

1821: FOR l_range_detail IN range_details_of_day(trunc(l_end_day_period+1),l_resource_id) LOOP
1822: IF(l_range_detail.start_time < l_latest_tc ) THEN
1823: l_tc_db_overlap :=TRUE;
1824: -- Start new code for Bug 2889097
1825: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1826: p_message_table => p_messages
1827: , p_message_name => 'HXC_OVRLPPNG_TIME_TC_V_DB'
1828: , p_message_token => NULL
1829: , p_message_level => 'ERROR'

Line 1858: -- hxc_time_entry_rules_utils_pkg.add_error_to_table (

1854: -- Note also that we could give the user more information in the msgs such as
1855: -- times of overlapping ranges if this is required.
1856:
1857: --IF (l_tc_db_overlap = TRUE) THEN
1858: -- hxc_time_entry_rules_utils_pkg.add_error_to_table (
1859: -- p_message_table => p_messages
1860: -- , p_message_name => 'HXC_OVRLPPNG_TIME_TC_V_DB'
1861: -- , p_message_token => NULL
1862: -- , p_message_level => 'ERROR'

Line 1895: -- p_rule_record Yes hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype

1891: --
1892: -- p_formula_name Yes varchar2 formula name
1893: -- p_message_table Yes hxc_self_service_time_deposit.message_table
1894: -- p_message_level Yes varchar2 TER message level
1895: -- p_rule_record Yes hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype
1896: -- p_tco_bb Yes hxc_self_service_time_deposit.timecard_info
1897: -- p_tco_att Yes hxc_self_service_time_deposit.building_block_attribute_info
1898: -- p_timecard_info Yes r_timecard_info Timecard Information
1899: --

Line 1909: , p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype

1905: PROCEDURE execute_field_combo_rule (
1906: p_formula_name varchar2
1907: , p_message_table IN OUT NOCOPY hxc_self_service_time_deposit.message_table
1908: , p_message_level varchar2
1909: , p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype
1910: , p_tco_bb hxc_self_service_time_deposit.timecard_info
1911: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info ) IS
1912:
1913: l_proc VARCHAR2(72);

Line 1992: hxc_time_entry_rules_utils_pkg.add_error_to_table (

1988:
1989: IF ( l_tc_id_2 IS NULL )
1990: THEN
1991:
1992: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1993: p_message_table => p_message_table
1994: , p_message_name => 'HXC_TER_VIOLATION' --'HXC_'||p_rule_record.name
1995: , p_message_token => 'TER&'|| p_rule_record.ter_message_name
1996: , p_message_level => p_message_level

Line 2049: hxc_time_entry_rules_utils_pkg.add_error_to_table (

2045:
2046: IF l_tc1_tab.EXISTS(p_tco_bb(l_bb_ind).time_building_block_id)
2047: THEN
2048:
2049: hxc_time_entry_rules_utils_pkg.add_error_to_table (
2050: p_message_table => p_message_table
2051: , p_message_name => 'HXC_TER_VIOLATION' --'HXC_'||p_rule_record.name
2052: , p_message_token => 'TER&'|| p_rule_record.ter_message_name
2053: , p_message_level => p_message_level

Line 2074: hxc_time_entry_rules_utils_pkg.add_error_to_table (

2070: END IF; -- ( l_tc_id_2 IS NOT NULL )
2071:
2072: EXCEPTION WHEN OTHERS THEN
2073:
2074: hxc_time_entry_rules_utils_pkg.add_error_to_table (
2075: p_message_table => p_message_table
2076: , p_message_name => 'EXCEPTION'
2077: , p_message_token => NULL
2078: , p_message_level => p_message_level

Line 2111: IF ( hxc_time_entry_rules_utils_pkg.g_assignment_info.EXISTS ( l_timecard_info_Rec.resource_id ) )

2107: -- set submission date to be within valid assignment
2108:
2109: -- GPM v115.69
2110:
2111: IF ( hxc_time_entry_rules_utils_pkg.g_assignment_info.EXISTS ( l_timecard_info_Rec.resource_id ) )
2112: THEN
2113:
2114: IF ( ( l_timecard_info_Rec.start_date =
2115: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).start_date )

Line 2115: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).start_date )

2111: IF ( hxc_time_entry_rules_utils_pkg.g_assignment_info.EXISTS ( l_timecard_info_Rec.resource_id ) )
2112: THEN
2113:
2114: IF ( ( l_timecard_info_Rec.start_date =
2115: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).start_date )
2116: AND
2117: ( l_timecard_info_Rec.end_date =
2118: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).end_date ) )
2119: THEN

Line 2118: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).end_date ) )

2114: IF ( ( l_timecard_info_Rec.start_date =
2115: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).start_date )
2116: AND
2117: ( l_timecard_info_Rec.end_date =
2118: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).end_date ) )
2119: THEN
2120:
2121: l_submission_date :=
2122: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;

Line 2122: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;

2118: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).end_date ) )
2119: THEN
2120:
2121: l_submission_date :=
2122: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;
2123:
2124: ELSE
2125:
2126: -- overwrite cached assignment info since for a different timecard period

Line 2136: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;

2132: , l_timecard_info_Rec.start_date
2133: , l_timecard_info_Rec.end_date );
2134:
2135: l_submission_date :=
2136: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;
2137:
2138: END IF;
2139: ELSE
2140:

Line 2146: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;

2142: , l_timecard_info_Rec.start_date
2143: , l_timecard_info_Rec.end_date );
2144:
2145: l_submission_date :=
2146: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;
2147:
2148: END IF;
2149:
2150:

Line 2210: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;

2206: end if;
2207:
2208: -- maintain global record of TER info
2209:
2210: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2211: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2212: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2213: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2214: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;

Line 2211: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;

2207:
2208: -- maintain global record of TER info
2209:
2210: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2211: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2212: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2213: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2214: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;
2215:

Line 2212: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;

2208: -- maintain global record of TER info
2209:
2210: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2211: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2212: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2213: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2214: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;
2215:
2216: IF ( ( p_operation = 'SAVE' AND r_rules.rule_usage = 'SAVE' ) OR

Line 2213: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');

2209:
2210: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2211: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2212: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2213: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2214: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;
2215:
2216: IF ( ( p_operation = 'SAVE' AND r_rules.rule_usage = 'SAVE' ) OR
2217: ( p_operation = 'SUBMIT' AND p_resubmit = 'NO' AND r_rules.rule_usage = 'SUBMISSION' ) OR

Line 2214: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;

2210: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2211: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2212: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2213: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2214: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;
2215:
2216: IF ( ( p_operation = 'SAVE' AND r_rules.rule_usage = 'SAVE' ) OR
2217: ( p_operation = 'SUBMIT' AND p_resubmit = 'NO' AND r_rules.rule_usage = 'SUBMISSION' ) OR
2218: ( p_operation = 'SUBMIT' AND p_resubmit = 'YES' AND r_rules.rule_usage = 'RESUBMISSION' ) OR

Line 2351: hxc_time_entry_rules_utils_pkg.add_error_to_table (

2347: if g_debug then
2348: hr_utility.trace('SQLERRM is '||SQLERRM);
2349: end if;
2350:
2351: hxc_time_entry_rules_utils_pkg.add_error_to_table (
2352: p_message_table => p_messages
2353: , p_message_name => 'EXCEPTION'
2354: , p_message_token => NULL
2355: , p_message_level => 'ERROR'

Line 2599: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )

2595: end if;
2596:
2597: l_total_hrs := l_total_hrs + l_hrs + p_timecard_hrs;
2598:
2599: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )
2600: THEN
2601:
2602: -- calculate PTO INC hours
2603:

Line 2606: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;

2602: -- calculate PTO INC hours
2603:
2604: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2605: hxc_time_category_utils_pkg.g_time_category_id
2606: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2607:
2608: l_hrs := 0;
2609:
2610: OPEN csr_get_total_hrs ( l_db_pre_period_start, l_db_pre_period_end );

Line 2661: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )

2657: end if;
2658:
2659: l_total_hrs := l_total_hrs + l_hrs + p_timecard_hrs;
2660:
2661: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )
2662: THEN
2663:
2664: -- calculate PTO INC hours
2665:

Line 2668: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;

2664: -- calculate PTO INC hours
2665:
2666: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2667: hxc_time_category_utils_pkg.g_time_category_id
2668: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2669:
2670: l_hrs := 0;
2671:
2672: OPEN csr_get_total_hrs ( l_db_pre_period_start, l_db_pre_period_end );

Line 2708: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )

2704: end if;
2705:
2706: l_total_hrs := l_hrs + p_timecard_hrs;
2707:
2708: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )
2709: THEN
2710:
2711: -- calculate PTO INC hours
2712:

Line 2715: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;

2711: -- calculate PTO INC hours
2712:
2713: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2714: hxc_time_category_utils_pkg.g_time_category_id
2715: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2716:
2717: l_hrs := 0;
2718:
2719: OPEN csr_get_total_hrs ( l_db_post_period_start, l_db_post_period_end );

Line 2788: IF ( ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name = 'HXC_PTO_ACCRUAL_COMPARISON' )

2784: -- check to see if period max is being called from a TER which is using the seeded PTO formula
2785: -- In this case if the l_total_hrs are 0 then we should always return success since
2786: -- there are no hours which will be deducted from the accrual balance
2787:
2788: IF ( ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name = 'HXC_PTO_ACCRUAL_COMPARISON' )
2789: AND
2790: ( l_total_hrs = 0 ) )
2791: THEN
2792:

Line 3160: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;

3156: ,P_TIME_ATTRIBUTES HXC_ATTRIBUTE_TABLE_TYPE
3157: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
3158: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER) IS
3159: n number;
3160: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3161: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3162: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3163:
3164: l_prefs hxc_preference_evaluation.t_pref_table;

Line 3267: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;

3263: ,P_TIME_ATTRIBUTES hxc_self_service_time_deposit.building_block_attribute_info
3264: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
3265: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER) IS
3266: n number;
3267: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3268: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3269: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3270:
3271: l_prefs hxc_preference_evaluation.t_pref_table;

Line 3335: p_timecard_rec IN hxc_time_entry_rules_utils_pkg.r_timecard_info,

3331: RETURN FALSE;
3332: END chk_bb_late;
3333:
3334: PROCEDURE populate_old_tco (
3335: p_timecard_rec IN hxc_time_entry_rules_utils_pkg.r_timecard_info,
3336: p_timecard_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
3337: p_timecard_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
3338: )
3339: IS

Line 4727: p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%ROWTYPE

4723: p_tco_bb IN hxc_self_service_time_deposit.timecard_info,
4724: p_tco_att IN hxc_self_service_time_deposit.building_block_attribute_info,
4725: p_message_table IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
4726: p_message_level VARCHAR2,
4727: p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%ROWTYPE
4728: )
4729: IS
4730: /* CURSOR csr_get_mapping_name(p_segment varchar2)
4731: IS

Line 4745: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;

4741: l_old_tbb_index NUMBER;
4742: l_old_att_index NUMBER;
4743: l_old_tco_bb hxc_self_service_time_deposit.timecard_info;
4744: l_old_tco_att hxc_self_service_time_deposit.building_block_attribute_info;
4745: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
4746: l_build_change_list VARCHAR2 (2000);
4747: l_change_list VARCHAR2 (2000);
4748: l_time_cat_tab hxc_time_category_utils_pkg.t_time_category;
4749: l_long LONG;

Line 5079: p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%ROWTYPE

5075: p_tco_bb IN hxc_self_service_time_deposit.timecard_info,
5076: p_tco_att IN hxc_self_service_time_deposit.building_block_attribute_info,
5077: p_message_table IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
5078: p_message_level VARCHAR2,
5079: p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%ROWTYPE
5080: )
5081: IS
5082: l_time_category_id hxc_time_categories.time_category_id%TYPE;
5083: l_tbb_index NUMBER;

Line 5141: hxc_time_entry_rules_utils_pkg.add_error_to_table (

5137: p_date_worked => l_date_worked
5138: )
5139: )
5140: THEN
5141: hxc_time_entry_rules_utils_pkg.add_error_to_table (
5142: p_message_table=> p_messages,
5143: p_message_name=> 'HXC_AUDIT_MSG',
5144: p_message_token=> 'LATE',
5145: p_message_level=> p_message_level,

Line 5192: hxc_time_entry_rules_utils_pkg.add_error_to_table (

5188: p_date_worked => l_date_worked
5189: )
5190: )
5191: THEN
5192: hxc_time_entry_rules_utils_pkg.add_error_to_table (
5193: p_message_table=> p_messages,
5194: p_message_name=> 'HXC_AUDIT_MSG',
5195: p_message_token=> 'LATE' --p_rule_record.rule_outcome
5196: ,

Line 5558: end hxc_time_entry_rules_utils_pkg;

5554: end if;
5555:
5556: end check_valid_calc_date_accrual;
5557:
5558: end hxc_time_entry_rules_utils_pkg;