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.23.12020000.2 2012/09/12 07:44:10 bbayragi 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 1502: ,p_message_token => 'TER_NAME&'||hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name

1498:
1499: add_error_to_table (
1500: p_message_table => p_message_table
1501: ,p_message_name => 'HXC_ARCHIVE_TER_ERROR'
1502: ,p_message_token => 'TER_NAME&'||hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name
1503: ,p_message_level => 'ERROR'
1504: ,p_message_field => NULL
1505: ,p_timecard_bb_id=> NULL
1506: ,p_time_attribute_id=> NULL

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

1507: ,p_timecard_bb_ovn => NULL
1508: ,p_time_attribute_ovn=> NULL
1509: ,p_message_extent =>hxc_timecard.c_blk_children_extent);
1510:
1511: end if; -- hxc_time_entry_rules_utils_pkg.return_archived_status(l_period_tab(p)) = false )
1512:
1513:
1514: if g_debug then
1515: hr_utility.set_location('Processing '||l_proc, 100);

Line 1788: hxc_time_entry_rules_utils_pkg.add_error_to_table (

1784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1785: 'Stop BB Inner '||to_char(l_stop_detail,'DD-MON-YYYY:HH24:MI'));
1786: end if;
1787: --
1788: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1789: p_message_table => p_messages
1790: , p_message_name => 'HXT_39256_OVERLAPPING_TIME'
1791: , p_message_token => NULL
1792: , p_message_level => 'ERROR'

Line 1850: hxc_time_entry_rules_utils_pkg.add_error_to_table (

1846: -- End new code for Bug 2889097
1847: l_tc_db_overlap :=TRUE;
1848:
1849: -- Start new code for Bug 2889097
1850: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1851: p_message_table => p_messages
1852: , p_message_name => 'HXC_OVRLPPNG_TIME_TC_V_DB'
1853: , p_message_token => NULL
1854: , p_message_level => 'ERROR'

Line 1880: hxc_time_entry_rules_utils_pkg.add_error_to_table (

1876: FOR l_range_detail IN range_details_of_day(trunc(l_end_day_period+1),l_resource_id) LOOP
1877: IF(l_range_detail.start_time < l_latest_tc ) THEN
1878: l_tc_db_overlap :=TRUE;
1879: -- Start new code for Bug 2889097
1880: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1881: p_message_table => p_messages
1882: , p_message_name => 'HXC_OVRLPPNG_TIME_TC_V_DB'
1883: , p_message_token => NULL
1884: , p_message_level => 'ERROR'

Line 1913: -- hxc_time_entry_rules_utils_pkg.add_error_to_table (

1909: -- Note also that we could give the user more information in the msgs such as
1910: -- times of overlapping ranges if this is required.
1911:
1912: --IF (l_tc_db_overlap = TRUE) THEN
1913: -- hxc_time_entry_rules_utils_pkg.add_error_to_table (
1914: -- p_message_table => p_messages
1915: -- , p_message_name => 'HXC_OVRLPPNG_TIME_TC_V_DB'
1916: -- , p_message_token => NULL
1917: -- , p_message_level => 'ERROR'

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

1946: --
1947: -- p_formula_name Yes varchar2 formula name
1948: -- p_message_table Yes hxc_self_service_time_deposit.message_table
1949: -- p_message_level Yes varchar2 TER message level
1950: -- p_rule_record Yes hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype
1951: -- p_tco_bb Yes hxc_self_service_time_deposit.timecard_info
1952: -- p_tco_att Yes hxc_self_service_time_deposit.building_block_attribute_info
1953: -- p_timecard_info Yes r_timecard_info Timecard Information
1954: --

Line 1964: , p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype

1960: PROCEDURE execute_field_combo_rule (
1961: p_formula_name varchar2
1962: , p_message_table IN OUT NOCOPY hxc_self_service_time_deposit.message_table
1963: , p_message_level varchar2
1964: , p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype
1965: , p_tco_bb hxc_self_service_time_deposit.timecard_info
1966: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info ) IS
1967:
1968: l_proc VARCHAR2(72);

Line 2047: hxc_time_entry_rules_utils_pkg.add_error_to_table (

2043:
2044: IF ( l_tc_id_2 IS NULL )
2045: THEN
2046:
2047: hxc_time_entry_rules_utils_pkg.add_error_to_table (
2048: p_message_table => p_message_table
2049: , p_message_name => 'HXC_TER_VIOLATION' --'HXC_'||p_rule_record.name
2050: , p_message_token => 'TER&'|| p_rule_record.ter_message_name
2051: , p_message_level => p_message_level

Line 2104: hxc_time_entry_rules_utils_pkg.add_error_to_table (

2100:
2101: IF l_tc1_tab.EXISTS(p_tco_bb(l_bb_ind).time_building_block_id)
2102: THEN
2103:
2104: hxc_time_entry_rules_utils_pkg.add_error_to_table (
2105: p_message_table => p_message_table
2106: , p_message_name => 'HXC_TER_VIOLATION' --'HXC_'||p_rule_record.name
2107: , p_message_token => 'TER&'|| p_rule_record.ter_message_name
2108: , p_message_level => p_message_level

Line 2129: hxc_time_entry_rules_utils_pkg.add_error_to_table (

2125: END IF; -- ( l_tc_id_2 IS NOT NULL )
2126:
2127: EXCEPTION WHEN OTHERS THEN
2128:
2129: hxc_time_entry_rules_utils_pkg.add_error_to_table (
2130: p_message_table => p_message_table
2131: , p_message_name => 'EXCEPTION'
2132: , p_message_token => NULL
2133: , p_message_level => p_message_level

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

2162: -- set submission date to be within valid assignment
2163:
2164: -- GPM v115.69
2165:
2166: IF ( hxc_time_entry_rules_utils_pkg.g_assignment_info.EXISTS ( l_timecard_info_Rec.resource_id ) )
2167: THEN
2168:
2169: IF ( ( l_timecard_info_Rec.start_date =
2170: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).start_date )

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

2166: IF ( hxc_time_entry_rules_utils_pkg.g_assignment_info.EXISTS ( l_timecard_info_Rec.resource_id ) )
2167: THEN
2168:
2169: IF ( ( l_timecard_info_Rec.start_date =
2170: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).start_date )
2171: AND
2172: ( l_timecard_info_Rec.end_date =
2173: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).end_date ) )
2174: THEN

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

2169: IF ( ( l_timecard_info_Rec.start_date =
2170: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).start_date )
2171: AND
2172: ( l_timecard_info_Rec.end_date =
2173: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).end_date ) )
2174: THEN
2175:
2176: l_submission_date :=
2177: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;

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

2173: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).end_date ) )
2174: THEN
2175:
2176: l_submission_date :=
2177: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;
2178:
2179: ELSE
2180:
2181: -- overwrite cached assignment info since for a different timecard period

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

2187: , l_timecard_info_Rec.start_date
2188: , l_timecard_info_Rec.end_date );
2189:
2190: l_submission_date :=
2191: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;
2192:
2193: END IF;
2194: ELSE
2195:

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

2197: , l_timecard_info_Rec.start_date
2198: , l_timecard_info_Rec.end_date );
2199:
2200: l_submission_date :=
2201: hxc_time_entry_rules_utils_pkg.g_assignment_info(l_timecard_info_Rec.resource_id).submission_date;
2202:
2203: END IF;
2204:
2205:

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

2261: end if;
2262:
2263: -- maintain global record of TER info
2264:
2265: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2266: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2267: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2268: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2269: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;

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

2262:
2263: -- maintain global record of TER info
2264:
2265: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2266: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2267: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2268: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2269: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;
2270:

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

2263: -- maintain global record of TER info
2264:
2265: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2266: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2267: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2268: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2269: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;
2270:
2271: IF ( ( p_operation = 'SAVE' AND r_rules.rule_usage = 'SAVE' ) OR

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

2264:
2265: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2266: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2267: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2268: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2269: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;
2270:
2271: IF ( ( p_operation = 'SAVE' AND r_rules.rule_usage = 'SAVE' ) OR
2272: ( p_operation = 'SUBMIT' AND p_resubmit = 'NO' AND r_rules.rule_usage = 'SUBMISSION' ) OR

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

2265: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_name := r_rules.name;
2266: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_message_name := r_rules.ter_message_name;
2267: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_usage := r_rules.rule_usage;
2268: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name := NVL( r_rules.formula_name, 'NULL FORMULA');
2269: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := NULL;
2270:
2271: IF ( ( p_operation = 'SAVE' AND r_rules.rule_usage = 'SAVE' ) OR
2272: ( p_operation = 'SUBMIT' AND p_resubmit = 'NO' AND r_rules.rule_usage = 'SUBMISSION' ) OR
2273: ( p_operation = 'SUBMIT' AND p_resubmit = 'YES' AND r_rules.rule_usage = 'RESUBMISSION' ) OR

Line 2406: hxc_time_entry_rules_utils_pkg.add_error_to_table (

2402: if g_debug then
2403: hr_utility.trace('SQLERRM is '||SQLERRM);
2404: end if;
2405:
2406: hxc_time_entry_rules_utils_pkg.add_error_to_table (
2407: p_message_table => p_messages
2408: , p_message_name => 'EXCEPTION'
2409: , p_message_token => NULL
2410: , p_message_level => 'ERROR'

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

2650: end if;
2651:
2652: l_total_hrs := l_total_hrs + l_hrs + p_timecard_hrs;
2653:
2654: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )
2655: THEN
2656:
2657: -- calculate PTO INC hours
2658:

Line 2661: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;

2657: -- calculate PTO INC hours
2658:
2659: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2660: hxc_time_category_utils_pkg.g_time_category_id
2661: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2662:
2663: l_hrs := 0;
2664:
2665: OPEN csr_get_total_hrs ( l_db_pre_period_start, l_db_pre_period_end );

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

2712: end if;
2713:
2714: l_total_hrs := l_total_hrs + l_hrs + p_timecard_hrs;
2715:
2716: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )
2717: THEN
2718:
2719: -- calculate PTO INC hours
2720:

Line 2723: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;

2719: -- calculate PTO INC hours
2720:
2721: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2722: hxc_time_category_utils_pkg.g_time_category_id
2723: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2724:
2725: l_hrs := 0;
2726:
2727: OPEN csr_get_total_hrs ( l_db_pre_period_start, l_db_pre_period_end );

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

2759: end if;
2760:
2761: l_total_hrs := l_hrs + p_timecard_hrs;
2762:
2763: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )
2764: THEN
2765:
2766: -- calculate PTO INC hours
2767:

Line 2770: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;

2766: -- calculate PTO INC hours
2767:
2768: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2769: hxc_time_category_utils_pkg.g_time_category_id
2770: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2771:
2772: l_hrs := 0;
2773:
2774: OPEN csr_get_total_hrs ( l_db_post_period_start, l_db_post_period_end );

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

2839: -- check to see if period max is being called from a TER which is using the seeded PTO formula
2840: -- In this case if the l_total_hrs are 0 then we should always return success since
2841: -- there are no hours which will be deducted from the accrual balance
2842:
2843: IF ( ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_formula_name = 'HXC_PTO_ACCRUAL_COMPARISON' )
2844: AND
2845: ( l_total_hrs = 0 ) )
2846: THEN
2847:

Line 3215: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;

3211: ,P_TIME_ATTRIBUTES HXC_ATTRIBUTE_TABLE_TYPE
3212: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
3213: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER) IS
3214: n number;
3215: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3216: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3217: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3218:
3219: l_prefs hxc_preference_evaluation.t_pref_table;

Line 3322: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;

3318: ,P_TIME_ATTRIBUTES hxc_self_service_time_deposit.building_block_attribute_info
3319: ,P_MESSAGES in out NOCOPY hxc_self_service_time_deposit.MESSAGE_TABLE
3320: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER) IS
3321: n number;
3322: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3323: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3324: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3325:
3326: l_prefs hxc_preference_evaluation.t_pref_table;

Line 3390: p_timecard_rec IN hxc_time_entry_rules_utils_pkg.r_timecard_info,

3386: RETURN FALSE;
3387: END chk_bb_late;
3388:
3389: PROCEDURE populate_old_tco (
3390: p_timecard_rec IN hxc_time_entry_rules_utils_pkg.r_timecard_info,
3391: p_timecard_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
3392: p_timecard_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
3393: )
3394: IS

Line 4812: p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%ROWTYPE

4808: p_tco_bb IN hxc_self_service_time_deposit.timecard_info,
4809: p_tco_att IN hxc_self_service_time_deposit.building_block_attribute_info,
4810: p_message_table IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
4811: p_message_level VARCHAR2,
4812: p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%ROWTYPE
4813: )
4814: IS
4815: /* CURSOR csr_get_mapping_name(p_segment varchar2)
4816: IS

Line 4830: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;

4826: l_old_tbb_index NUMBER;
4827: l_old_att_index NUMBER;
4828: l_old_tco_bb hxc_self_service_time_deposit.timecard_info;
4829: l_old_tco_att hxc_self_service_time_deposit.building_block_attribute_info;
4830: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
4831: l_build_change_list VARCHAR2 (2000);
4832: l_change_list VARCHAR2 (2000);
4833: l_time_cat_tab hxc_time_category_utils_pkg.t_time_category;
4834: l_long LONG;

Line 5176: p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%ROWTYPE

5172: p_tco_bb IN hxc_self_service_time_deposit.timecard_info,
5173: p_tco_att IN hxc_self_service_time_deposit.building_block_attribute_info,
5174: p_message_table IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
5175: p_message_level VARCHAR2,
5176: p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%ROWTYPE
5177: )
5178: IS
5179: l_time_category_id hxc_time_categories.time_category_id%TYPE;
5180: l_tbb_index NUMBER;

Line 5238: hxc_time_entry_rules_utils_pkg.add_error_to_table (

5234: p_date_worked => l_date_worked
5235: )
5236: )
5237: THEN
5238: hxc_time_entry_rules_utils_pkg.add_error_to_table (
5239: p_message_table=> p_messages,
5240: p_message_name=> 'HXC_AUDIT_MSG',
5241: p_message_token=> 'LATE',
5242: p_message_level=> p_message_level,

Line 5289: hxc_time_entry_rules_utils_pkg.add_error_to_table (

5285: p_date_worked => l_date_worked
5286: )
5287: )
5288: THEN
5289: hxc_time_entry_rules_utils_pkg.add_error_to_table (
5290: p_message_table=> p_messages,
5291: p_message_name=> 'HXC_AUDIT_MSG',
5292: p_message_token=> 'LATE' --p_rule_record.rule_outcome
5293: ,

Line 5655: end hxc_time_entry_rules_utils_pkg;

5651: end if;
5652:
5653: end check_valid_calc_date_accrual;
5654:
5655: end hxc_time_entry_rules_utils_pkg;