DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_WF_PKG dependencies on HXC_TIMEKEEPER_WF_PKG

Line 1: PACKAGE BODY hxc_timekeeper_wf_pkg AS

1: PACKAGE BODY hxc_timekeeper_wf_pkg AS
2: /* $Header: hxctimekeeperwf.pkb 120.4 2007/01/10 21:14:38 arundell noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 78: l_item_key := HXC_TIMEKEEPER_WF_PKG.GET_ITEM_KEY;

74: if(l_cla_terg_id is not null and
75: p_tk_notify_to <>'NONE' and
76: p_tk_audit_enabled ='Y' ) then
77:
78: l_item_key := HXC_TIMEKEEPER_WF_PKG.GET_ITEM_KEY;
79:
80: HXC_TIMEKEEPER_WF_PKG.START_TK_WF_PROCESS
81: ( p_item_type => 'HXCTKWF'
82: ,p_item_key => l_item_key

Line 80: HXC_TIMEKEEPER_WF_PKG.START_TK_WF_PROCESS

76: p_tk_audit_enabled ='Y' ) then
77:
78: l_item_key := HXC_TIMEKEEPER_WF_PKG.GET_ITEM_KEY;
79:
80: HXC_TIMEKEEPER_WF_PKG.START_TK_WF_PROCESS
81: ( p_item_type => 'HXCTKWF'
82: ,p_item_key => l_item_key
83: ,p_process_name => 'HXC_TK_AUDIT_PROCESS'
84: ,p_tc_bb_id => p_timecard_id

Line 224: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.set_login';

220: where tbb.time_building_block_id = p_tc_id
221: and tbb.object_version_number = p_tc_ovn
222: and tbb.last_updated_by = u.user_id;
223:
224: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.set_login';
225: l_login fnd_user.user_name%type;
226: begin
227:
228: l_login := hxc_find_notify_aprs_pkg.get_login(p_person_id => p_person_id);

Line 449: l_child_item_key := hxc_timekeeper_wf_pkg.get_item_key;

445:
446: l_child_item_key wf_items.item_key%type;
447:
448: BEGIN
449: l_child_item_key := hxc_timekeeper_wf_pkg.get_item_key;
450:
451: wf_engine.CreateProcess(itemtype => p_tc_item_type,
452: itemkey => l_child_item_key,
453: process => p_tc_process_name);

Line 645: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.find_tk_ntf_style';

641: WHERE tcsum.time_building_block_id = p_tc_bbid
642: AND tcsum.object_version_number = p_tc_ovn ;
643:
644:
645: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.find_tk_ntf_style';
646: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
647: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
648: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
649: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;

Line 825: l_proc := 'hxc_timekeeper_wf_pkg.PERSON_NOTIFY';

821: itemkey => p_itemkey,
822: aname => 'TC_BLD_BLK_ID');
823:
824: if g_debug then
825: l_proc := 'hxc_timekeeper_wf_pkg.PERSON_NOTIFY';
826: hr_utility.trace('l_tc_bb_id='||l_tc_bb_id);
827: end if;
828:
829: l_tc_bb_ovn := wf_engine.GetItemAttrNumber(

Line 1008: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.SUPERVISOR_NOTIFY';

1004: l_supervisor hxc_time_building_blocks.resource_id%TYPE;
1005: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1006: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1007: l_ntf_type VARCHAR2(150);
1008: l_proc constant varchar2(61) :='hxc_timekeeper_wf_pkg.SUPERVISOR_NOTIFY';
1009: l_title VARCHAR2(2000);
1010: l_otl_appr_id VARCHAR2(2000);
1011: l_timekeeper_id hxc_time_building_blocks.resource_id%TYPE;
1012: l_total_hours number;

Line 1343: end hxc_timekeeper_wf_pkg;

1339: --
1340: --
1341: END UPDATE_TK_NTF_RESULT;
1342:
1343: end hxc_timekeeper_wf_pkg;