14:
15:
16:
17: PROCEDURE get_timecard_info (
18: p_time_building_blocks hxc_self_service_time_deposit.timecard_info
19: , p_timecard_rec IN OUT NOCOPY r_timecard_info ) IS
20:
21: l_proc VARCHAR2(72);
22:
88: END get_timecard_info;
89:
90:
91: PROCEDURE get_timecard_info (
92: p_time_building_blocks hxc_self_service_time_deposit.timecard_info
93: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
94: , p_timecard_rec IN OUT NOCOPY r_timecard_info ) IS
95:
96: l_proc VARCHAR2(72);
89:
90:
91: PROCEDURE get_timecard_info (
92: p_time_building_blocks hxc_self_service_time_deposit.timecard_info
93: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
94: , p_timecard_rec IN OUT NOCOPY r_timecard_info ) IS
95:
96: l_proc VARCHAR2(72);
97:
138: PROCEDURE get_timecard_info (
139: p_time_building_blocks HXC_BLOCK_TABLE_TYPE
140: , p_timecard_rec IN OUT NOCOPY r_timecard_info ) IS
141:
142: l_blocks hxc_self_service_time_deposit.timecard_info;
143:
144: BEGIN
145:
146: l_blocks := hxc_timecard_block_utils.convert_to_dpwr_blocks(
540:
541: FUNCTION calc_timecard_hrs (
542: p_hrs_period_start DATE
543: , p_hrs_period_end DATE
544: , p_tco_bb hxc_self_service_time_deposit.timecard_info
545: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info )
546: RETURN NUMBER IS
547:
548: l_hours NUMBER := 0;
541: FUNCTION calc_timecard_hrs (
542: p_hrs_period_start DATE
543: , p_hrs_period_end DATE
544: , p_tco_bb hxc_self_service_time_deposit.timecard_info
545: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info )
546: RETURN NUMBER IS
547:
548: l_hours NUMBER := 0;
549: l_time_category_id hxc_time_categories.time_category_id%TYPE;
575:
576: FUNCTION calc_timecard_hrs (
577: p_hrs_period_start DATE
578: , p_hrs_period_end DATE
579: , p_tco_bb hxc_self_service_time_deposit.timecard_info
580: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info
581: , p_time_category_name VARCHAR2 )
582: RETURN NUMBER IS
583:
576: FUNCTION calc_timecard_hrs (
577: p_hrs_period_start DATE
578: , p_hrs_period_end DATE
579: , p_tco_bb hxc_self_service_time_deposit.timecard_info
580: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info
581: , p_time_category_name VARCHAR2 )
582: RETURN NUMBER IS
583:
584: l_hours NUMBER := 0;
695:
696: FUNCTION calc_timecard_hrs (
697: p_hrs_period_start DATE
698: , p_hrs_period_end DATE
699: , p_tco_bb hxc_self_service_time_deposit.timecard_info
700: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info
701: , p_time_category_id NUMBER )
702: RETURN NUMBER IS
703:
696: FUNCTION calc_timecard_hrs (
697: p_hrs_period_start DATE
698: , p_hrs_period_end DATE
699: , p_tco_bb hxc_self_service_time_deposit.timecard_info
700: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info
701: , p_time_category_id NUMBER )
702: RETURN NUMBER IS
703:
704: l_proc VARCHAR2(72);
750: -- description
751: -- adds error to the TCO message stack
752:
753: PROCEDURE add_error_to_table (
754: p_message_table in out nocopy HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
755: , p_message_name in FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
756: , p_message_token in VARCHAR2
757: , p_message_level in VARCHAR2
758: , p_message_field in VARCHAR2
835: -- deposit API based on resources preference time entry rule group
836:
837: PROCEDURE execute_time_entry_rules (
838: p_operation VARCHAR2
839: , p_time_building_blocks hxc_self_service_time_deposit.timecard_info
840: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
841: , p_messages IN OUT nocopy hxc_self_service_time_deposit.message_table
842: , p_resubmit VARCHAR2
843: , p_blocks hxc_block_table_type
836:
837: PROCEDURE execute_time_entry_rules (
838: p_operation VARCHAR2
839: , p_time_building_blocks hxc_self_service_time_deposit.timecard_info
840: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
841: , p_messages IN OUT nocopy hxc_self_service_time_deposit.message_table
842: , p_resubmit VARCHAR2
843: , p_blocks hxc_block_table_type
844: , p_attributes hxc_attribute_table_type ) IS
837: PROCEDURE execute_time_entry_rules (
838: p_operation VARCHAR2
839: , p_time_building_blocks hxc_self_service_time_deposit.timecard_info
840: , p_time_attributes hxc_self_service_time_deposit.building_block_attribute_info
841: , p_messages IN OUT nocopy hxc_self_service_time_deposit.message_table
842: , p_resubmit VARCHAR2
843: , p_blocks hxc_block_table_type
844: , p_attributes hxc_attribute_table_type ) IS
845:
914: -- description
915: -- executes and evaluates each WTD rule
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
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:
925: l_proc VARCHAR2(72);
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:
925: l_proc VARCHAR2(72);
926:
1005: END IF;
1006:
1007: END process_message;
1008:
1009: FUNCTION check_commit ( p_message_table IN OUT NOCOPY hxc_self_service_time_deposit.message_table
1010: ,p_timecard_info r_timecard_info ) RETURN BOOLEAN IS
1011:
1012: CURSOR chk_global_table IS
1013: select 1
1532: END execute_formula;
1533:
1534:
1535: PROCEDURE check_time_overlaps
1536: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
1537: ,p_messages IN OUT nocopy hxc_self_service_time_deposit.message_table) IS
1538:
1539: l_bb_id NUMBER;
1540: l_bb_id_detail NUMBER;
1533:
1534:
1535: PROCEDURE check_time_overlaps
1536: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
1537: ,p_messages IN OUT nocopy hxc_self_service_time_deposit.message_table) IS
1538:
1539: l_bb_id NUMBER;
1540: l_bb_id_detail NUMBER;
1541: l_type VARCHAR2(30);
1944: -- In Parameters:
1945: -- Name Reqd Type Description
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
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: --
1955: --
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: --
1955: --
1956: -- Access Status:
1958: --
1959:
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
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);
1969:
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);
1969:
1970: l_param_rec hxc_ff_dict.r_param;
2532: l_db_ref_period_end DATE;
2533:
2534: l_proc VARCHAR2(72);
2535:
2536: l_tc_bld_blks hxc_self_service_time_deposit.timecard_info;
2537: l_tc_ind binary_integer;
2538:
2539:
2540: BEGIN -- period_maximum
2547:
2548: hr_utility.trace('Lets see what is in the structure');
2549: end if;
2550:
2551: l_tc_bld_blks := hxc_self_service_time_deposit.get_building_blocks;
2552:
2553: l_tc_ind := l_tc_bld_blks.first;
2554:
2555: while l_tc_ind is not null
3208:
3209:
3210: PROCEDURE EXECUTE_ELP_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS HXC_BLOCK_TABLE_TYPE
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;
3313: end if;
3314:
3315: end execute_ELP_time_entry_rules;
3316:
3317: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.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;
3314:
3315: end execute_ELP_time_entry_rules;
3316:
3317: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.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;
3315: end execute_ELP_time_entry_rules;
3316:
3317: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.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;
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
3395: CURSOR csr_get_det_bbs
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
3395: CURSOR csr_get_det_bbs
3396: IS
3641: end if;
3642: END populate_old_tco;
3643:
3644: FUNCTION compare_tbb_attributes (
3645: p_attribute1 hxc_self_service_time_deposit.attribute_info,
3646: p_attribute2 hxc_self_service_time_deposit.attribute_info,
3647: p_tbb_deleted BOOLEAN,
3648: p_change_att_tab IN OUT NOCOPY t_change_att_tab
3649: )
3642: END populate_old_tco;
3643:
3644: FUNCTION compare_tbb_attributes (
3645: p_attribute1 hxc_self_service_time_deposit.attribute_info,
3646: p_attribute2 hxc_self_service_time_deposit.attribute_info,
3647: p_tbb_deleted BOOLEAN,
3648: p_change_att_tab IN OUT NOCOPY t_change_att_tab
3649: )
3650: RETURN VARCHAR2
4644: RETURN l_return_mapp;
4645: END compare_tbb_attributes;
4646:
4647: FUNCTION compare_time_building_blocks (
4648: p_block1 hxc_self_service_time_deposit.building_block_info,
4649: p_block2 hxc_self_service_time_deposit.building_block_info,
4650: p_tbb_deleted BOOLEAN,
4651: p_change_att_tab IN OUT NOCOPY t_change_att_tab
4652: )
4645: END compare_tbb_attributes;
4646:
4647: FUNCTION compare_time_building_blocks (
4648: p_block1 hxc_self_service_time_deposit.building_block_info,
4649: p_block2 hxc_self_service_time_deposit.building_block_info,
4650: p_tbb_deleted BOOLEAN,
4651: p_change_att_tab IN OUT NOCOPY t_change_att_tab
4652: )
4653: RETURN VARCHAR2
4804: RETURN l_ret_val;
4805: END compare_time_building_blocks;
4806:
4807: PROCEDURE execute_change_ter (
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
4805: END compare_time_building_blocks;
4806:
4807: PROCEDURE execute_change_ter (
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: )
4806:
4807: PROCEDURE execute_change_ter (
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
4824: l_tbb_index NUMBER;
4825: l_att_index NUMBER;
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);
4825: l_att_index NUMBER;
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;
5168:
5169: END execute_change_ter;
5170:
5171: PROCEDURE execute_late_ter (
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
5169: END execute_change_ter;
5170:
5171: PROCEDURE execute_late_ter (
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: )
5170:
5171: PROCEDURE execute_late_ter (
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