DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_TIMECARD

Line 3033: hxc_timecard_message_helper.initializeErrors;

3029:
3030: IF g_debug THEN
3031: hr_utility.trace ('p_template_procedure='||p_template_procedure);
3032: END IF;
3033: hxc_timecard_message_helper.initializeErrors;
3034:
3035: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3036: ||p_template_procedure ||fnd_global.newline
3037: ||'(p_resource_id => :1' ||fnd_global.newline

Line 3058: hxc_timecard_message_helper.addErrorToCollection

3054:
3055: EXCEPTION
3056: when others then
3057:
3058: hxc_timecard_message_helper.addErrorToCollection
3059: (p_messages
3060: ,'HXC_INVALID_DYNAMIC_TEMPL'
3061: ,hxc_timecard.c_error
3062: ,null

Line 3061: ,hxc_timecard.c_error

3057:
3058: hxc_timecard_message_helper.addErrorToCollection
3059: (p_messages
3060: ,'HXC_INVALID_DYNAMIC_TEMPL'
3061: ,hxc_timecard.c_error
3062: ,null
3063: ,null
3064: ,hxc_timecard.c_hxc
3065: ,null

Line 3064: ,hxc_timecard.c_hxc

3060: ,'HXC_INVALID_DYNAMIC_TEMPL'
3061: ,hxc_timecard.c_error
3062: ,null
3063: ,null
3064: ,hxc_timecard.c_hxc
3065: ,null
3066: ,null
3067: ,null
3068: ,null

Line 3444: if(p_block_array(l_block_array_idx).scope = hxc_timecard.c_detail_scope) then

3440: l_block_array_idx := p_block_array.first;
3441: l_found := false;
3442: Loop
3443: Exit when ((l_found) or (not p_block_array.exists(l_block_array_idx)));
3444: if(p_block_array(l_block_array_idx).scope = hxc_timecard.c_detail_scope) then
3445: l_found := true;
3446: if((p_block_array(l_block_array_idx).translation_display_key is null)
3447: OR
3448: (p_block_array(l_block_array_idx).translation_display_key ='')) then

Line 3495: l_blocks(l_block_index).new := hxc_timecard.c_yes;

3491: l_blocks(l_block_index).DATE_TO := fnd_date.date_to_canonical(hr_general.end_of_time);
3492: l_blocks(l_block_index).RESOURCE_ID := p_resource_id;
3493: l_blocks(l_block_index).RESOURCE_TYPE := p_resource_type;
3494: l_blocks(l_block_index).OBJECT_VERSION_NUMBER := 1;
3495: l_blocks(l_block_index).new := hxc_timecard.c_yes;
3496:
3497: if((l_blocks(l_block_index).translation_display_key is null)
3498: OR
3499: (l_blocks(l_block_index).translation_display_key = '')) then

Line 5007: from hxc_timecard_summary

5003: (p_resource_id in number,
5004: p_start_time in date,
5005: p_stop_time in date) is
5006: select timecard_id
5007: from hxc_timecard_summary
5008: where resource_id = p_resource_id
5009: and trunc(start_time) = trunc(p_start_time)
5010: and trunc(stop_time) = trunc(p_stop_time);
5011:

Line 5031: l_timecard_id hxc_timecard_summary.timecard_id%type;

5027: l_lock_rowid ROWID;
5028: l_temp_block HXC_BLOCK_TYPE;
5029: l_row_data hxc_trans_display_key_utils.translation_row_used;
5030: l_missing_rows boolean;
5031: l_timecard_id hxc_timecard_summary.timecard_id%type;
5032: l_temp_attributes hxc_attribute_table_type;
5033: i number;
5034:
5035: l_proc VARCHAR2(50);

Line 5530: FROM hxc_tc_ap_links tal, hxc_timecard_summary ts

5526: IS
5527: SELECT tal.application_period_id,
5528: ts.start_time,
5529: ts.stop_time
5530: FROM hxc_tc_ap_links tal, hxc_timecard_summary ts
5531: WHERE ts.timecard_id = p_timecard_id
5532: and ts.timecard_id = tal.timecard_id;
5533:
5534: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 5535: l_start_time hxc_timecard_summary.start_time%type;

5531: WHERE ts.timecard_id = p_timecard_id
5532: and ts.timecard_id = tal.timecard_id;
5533:
5534: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
5535: l_start_time hxc_timecard_summary.start_time%type;
5536: l_stop_time hxc_timecard_summary.stop_time%type;
5537: l_block_array HXC_BLOCK_TABLE_TYPE;
5538: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5539: l_message_string VARCHAR(2000) := NULL;

Line 5536: l_stop_time hxc_timecard_summary.stop_time%type;

5532: and ts.timecard_id = tal.timecard_id;
5533:
5534: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
5535: l_start_time hxc_timecard_summary.start_time%type;
5536: l_stop_time hxc_timecard_summary.stop_time%type;
5537: l_block_array HXC_BLOCK_TABLE_TYPE;
5538: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5539: l_message_string VARCHAR(2000) := NULL;
5540: l_count NUMBER;

Line 5784: hxc_timecard_message_helper.addErrorToCollection

5780: l_attribute_count := l_temp_attributes.count;
5781:
5782: IF l_block_count < 0
5783: THEN
5784: hxc_timecard_message_helper.addErrorToCollection
5785: (p_messages
5786: ,'HXC_INVALID_DYNAMIC_TEMPL1'
5787: ,hxc_timecard.c_error
5788: ,null

Line 5787: ,hxc_timecard.c_error

5783: THEN
5784: hxc_timecard_message_helper.addErrorToCollection
5785: (p_messages
5786: ,'HXC_INVALID_DYNAMIC_TEMPL1'
5787: ,hxc_timecard.c_error
5788: ,null
5789: ,null
5790: ,hxc_timecard.c_hxc
5791: ,null

Line 5790: ,hxc_timecard.c_hxc

5786: ,'HXC_INVALID_DYNAMIC_TEMPL1'
5787: ,hxc_timecard.c_error
5788: ,null
5789: ,null
5790: ,hxc_timecard.c_hxc
5791: ,null
5792: ,null
5793: ,null
5794: ,null

Line 5802: FUNCTION get_timecard_transferred_to(f_timecard_id HXC_TIMECARD_SUMMARY.TIMECARD_ID%TYPE,

5798:
5799: END check_blocks_from_template;
5800:
5801:
5802: FUNCTION get_timecard_transferred_to(f_timecard_id HXC_TIMECARD_SUMMARY.TIMECARD_ID%TYPE,
5803: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2
5804: is
5805:
5806: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,

Line 5803: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2

5799: END check_blocks_from_template;
5800:
5801:
5802: FUNCTION get_timecard_transferred_to(f_timecard_id HXC_TIMECARD_SUMMARY.TIMECARD_ID%TYPE,
5803: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2
5804: is
5805:
5806: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,
5807: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS

Line 5806: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,

5802: FUNCTION get_timecard_transferred_to(f_timecard_id HXC_TIMECARD_SUMMARY.TIMECARD_ID%TYPE,
5803: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2
5804: is
5805:
5806: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,
5807: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS
5808: SELECT /*+ ordered */
5809: lat.time_building_block_id,
5810: lat.object_version_number

Line 5807: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS

5803: f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2
5804: is
5805:
5806: CURSOR c_get_latest_timecard_details(l_timecard_id hxc_timecard_summary.timecard_id%TYPE,
5807: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS
5808: SELECT /*+ ordered */
5809: lat.time_building_block_id,
5810: lat.object_version_number
5811: FROM hxc_timecard_summary sum,

Line 5811: FROM hxc_timecard_summary sum,

5807: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE) IS
5808: SELECT /*+ ordered */
5809: lat.time_building_block_id,
5810: lat.object_version_number
5811: FROM hxc_timecard_summary sum,
5812: hxc_time_building_blocks day,
5813: hxc_time_building_blocks det,
5814: hxc_latest_details lat
5815: WHERE sum.timecard_id = l_timecard_id

Line 5841: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;

5837:
5838:
5839: --------------------------------------------------------------------------
5840:
5841: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;
5842: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;
5843: l_resource_id hxc_timecard_summary.resource_id%TYPE;
5844: l_start_time hxc_timecard_summary.start_time%TYPE;
5845:

Line 5842: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;

5838:
5839: --------------------------------------------------------------------------
5840:
5841: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;
5842: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;
5843: l_resource_id hxc_timecard_summary.resource_id%TYPE;
5844: l_start_time hxc_timecard_summary.start_time%TYPE;
5845:
5846:

Line 5843: l_resource_id hxc_timecard_summary.resource_id%TYPE;

5839: --------------------------------------------------------------------------
5840:
5841: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;
5842: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;
5843: l_resource_id hxc_timecard_summary.resource_id%TYPE;
5844: l_start_time hxc_timecard_summary.start_time%TYPE;
5845:
5846:
5847: TYPE building_blocks_tab IS TABLE OF NUMBER;

Line 5844: l_start_time hxc_timecard_summary.start_time%TYPE;

5840:
5841: l_timecard_id hxc_timecard_summary.timecard_id%TYPE;
5842: l_timecard_ovn hxc_timecard_summary.timecard_ovn%TYPE;
5843: l_resource_id hxc_timecard_summary.resource_id%TYPE;
5844: l_start_time hxc_timecard_summary.start_time%TYPE;
5845:
5846:
5847: TYPE building_blocks_tab IS TABLE OF NUMBER;
5848: