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
1526: END execute_formula;
1527:
1528:
1529: PROCEDURE check_time_overlaps
1530: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
1531: ,p_messages IN OUT nocopy hxc_self_service_time_deposit.message_table) IS
1532:
1533: l_bb_id NUMBER;
1534: l_bb_id_detail NUMBER;
1527:
1528:
1529: PROCEDURE check_time_overlaps
1530: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
1531: ,p_messages IN OUT nocopy hxc_self_service_time_deposit.message_table) IS
1532:
1533: l_bb_id NUMBER;
1534: l_bb_id_detail NUMBER;
1535: l_type VARCHAR2(30);
1889: -- In Parameters:
1890: -- Name Reqd Type Description
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
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: --
1900: --
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: --
1900: --
1901: -- Access Status:
1903: --
1904:
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
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);
1914:
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);
1914:
1915: l_param_rec hxc_ff_dict.r_param;
2477: l_db_ref_period_end DATE;
2478:
2479: l_proc VARCHAR2(72);
2480:
2481: l_tc_bld_blks hxc_self_service_time_deposit.timecard_info;
2482: l_tc_ind binary_integer;
2483:
2484:
2485: BEGIN -- period_maximum
2492:
2493: hr_utility.trace('Lets see what is in the structure');
2494: end if;
2495:
2496: l_tc_bld_blks := hxc_self_service_time_deposit.get_building_blocks;
2497:
2498: l_tc_ind := l_tc_bld_blks.first;
2499:
2500: while l_tc_ind is not null
3153:
3154:
3155: PROCEDURE EXECUTE_ELP_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS HXC_BLOCK_TABLE_TYPE
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;
3258: end if;
3259:
3260: end execute_ELP_time_entry_rules;
3261:
3262: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.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;
3259:
3260: end execute_ELP_time_entry_rules;
3261:
3262: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.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;
3260: end execute_ELP_time_entry_rules;
3261:
3262: PROCEDURE EXECUTE_CLA_TIME_ENTRY_RULES( P_TIME_BUILDING_BLOCKS hxc_self_service_time_deposit.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;
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
3340: CURSOR csr_get_det_bbs
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
3340: CURSOR csr_get_det_bbs
3341: IS
3556: end if;
3557: END populate_old_tco;
3558:
3559: FUNCTION compare_tbb_attributes (
3560: p_attribute1 hxc_self_service_time_deposit.attribute_info,
3561: p_attribute2 hxc_self_service_time_deposit.attribute_info,
3562: p_tbb_deleted BOOLEAN,
3563: p_change_att_tab IN OUT NOCOPY t_change_att_tab
3564: )
3557: END populate_old_tco;
3558:
3559: FUNCTION compare_tbb_attributes (
3560: p_attribute1 hxc_self_service_time_deposit.attribute_info,
3561: p_attribute2 hxc_self_service_time_deposit.attribute_info,
3562: p_tbb_deleted BOOLEAN,
3563: p_change_att_tab IN OUT NOCOPY t_change_att_tab
3564: )
3565: RETURN VARCHAR2
4559: RETURN l_return_mapp;
4560: END compare_tbb_attributes;
4561:
4562: FUNCTION compare_time_building_blocks (
4563: p_block1 hxc_self_service_time_deposit.building_block_info,
4564: p_block2 hxc_self_service_time_deposit.building_block_info,
4565: p_tbb_deleted BOOLEAN,
4566: p_change_att_tab IN OUT NOCOPY t_change_att_tab
4567: )
4560: END compare_tbb_attributes;
4561:
4562: FUNCTION compare_time_building_blocks (
4563: p_block1 hxc_self_service_time_deposit.building_block_info,
4564: p_block2 hxc_self_service_time_deposit.building_block_info,
4565: p_tbb_deleted BOOLEAN,
4566: p_change_att_tab IN OUT NOCOPY t_change_att_tab
4567: )
4568: RETURN VARCHAR2
4719: RETURN l_ret_val;
4720: END compare_time_building_blocks;
4721:
4722: PROCEDURE execute_change_ter (
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
4720: END compare_time_building_blocks;
4721:
4722: PROCEDURE execute_change_ter (
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: )
4721:
4722: PROCEDURE execute_change_ter (
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
4739: l_tbb_index NUMBER;
4740: l_att_index NUMBER;
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);
4740: l_att_index NUMBER;
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;
5071:
5072: END execute_change_ter;
5073:
5074: PROCEDURE execute_late_ter (
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
5072: END execute_change_ter;
5073:
5074: PROCEDURE execute_late_ter (
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: )
5073:
5074: PROCEDURE execute_late_ter (
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