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_APPROVAL_WF_PKG dependencies on WF_ENGINE

Line 958: l_tc_resource_id := wf_engine.GetItemAttrNumber(

954: if g_debug then
955: hr_utility.set_location(l_proc, 10);
956: end if;
957:
958: l_tc_resource_id := wf_engine.GetItemAttrNumber(
959: itemtype => itemtype,
960: itemkey => itemkey ,
961: aname => 'RESOURCE_ID');
962:

Line 968: l_period_start_date := wf_engine.GetItemAttrDate(

964: if g_debug then
965: hr_utility.set_location(l_proc, 30);
966: end if;
967:
968: l_period_start_date := wf_engine.GetItemAttrDate(
969: itemtype => itemtype,
970: itemkey => itemkey ,
971: aname => 'APP_START_DATE');
972:

Line 977: l_period_end_date := wf_engine.GetItemAttrDate(

973: if g_debug then
974: hr_utility.set_location(l_proc, 40);
975: end if;
976:
977: l_period_end_date := wf_engine.GetItemAttrDate(
978: itemtype => itemtype,
979: itemkey => itemkey ,
980: aname => 'APP_END_DATE');
981:

Line 986: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(

982: if g_debug then
983: hr_utility.set_location(l_proc, 50);
984: end if;
985:
986: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
987: itemtype => itemtype,
988: itemkey => itemkey,
989: aname => 'APP_BB_ID');
990:

Line 995: l_appl_period_bb_ovn := wf_engine.GetItemAttrNumber(

991: if g_debug then
992: hr_utility.set_location(l_proc, 60);
993: end if;
994:
995: l_appl_period_bb_ovn := wf_engine.GetItemAttrNumber(
996: itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'APP_BB_OVN');
999:

Line 1007: l_approval_status := wf_engine.GetItemAttrText(

1003:
1004: -- Set up the approval status - get the value for the APPROVAL_STATUS
1005: -- attribute, which is set up in the activity previous to this one.
1006: --
1007: l_approval_status := wf_engine.GetItemAttrText(
1008: itemtype => itemtype,
1009: itemkey => itemkey ,
1010: aname => 'APPROVAL_STATUS');
1011:

Line 1012: l_approver_comment := wf_engine.GetItemAttrText(

1008: itemtype => itemtype,
1009: itemkey => itemkey ,
1010: aname => 'APPROVAL_STATUS');
1011:
1012: l_approver_comment := wf_engine.GetItemAttrText(
1013: itemtype => itemtype,
1014: itemkey => itemkey,
1015: aname => 'APR_REJ_REASON');
1016:

Line 1026: l_wf_item_type := wf_engine.GetItemAttrText(

1022:
1023: --get approver id
1024: --what happens to l_approver if AUTO_APPROVE??
1025:
1026: l_wf_item_type := wf_engine.GetItemAttrText(
1027: itemtype => itemtype
1028: ,itemkey => itemkey
1029: ,aname => 'WF_ITEM_TYPE'
1030: );

Line 1061: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,

1057: i.e. fnd_global.employee_id is
1058:
1059: */
1060:
1061: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,
1062: itemkey => itemkey ,
1063: aname => 'IS_DIFF_TC',
1064: ignore_notfound => true);
1065: if l_is_blank = 'Y' then

Line 1235: l_period_id := wf_engine.GetItemAttrNumber(

1231: end if;
1232:
1233: IF funcmode = 'RUN'
1234: THEN
1235: l_period_id := wf_engine.GetItemAttrNumber(
1236: itemtype => itemtype,
1237: itemkey => itemkey ,
1238: aname => 'APP_BB_ID');
1239:

Line 1240: l_period_start_date := wf_engine.GetItemAttrDate(

1236: itemtype => itemtype,
1237: itemkey => itemkey ,
1238: aname => 'APP_BB_ID');
1239:
1240: l_period_start_date := wf_engine.GetItemAttrDate(
1241: itemtype => itemtype,
1242: itemkey => itemkey ,
1243: aname => 'APP_START_DATE');
1244:

Line 1245: l_period_end_date := wf_engine.GetItemAttrDate(

1241: itemtype => itemtype,
1242: itemkey => itemkey ,
1243: aname => 'APP_START_DATE');
1244:
1245: l_period_end_date := wf_engine.GetItemAttrDate(
1246: itemtype => itemtype,
1247: itemkey => itemkey ,
1248: aname => 'APP_END_DATE');
1249:

Line 1250: l_tc_resource_id := wf_engine.GetItemAttrNumber(

1246: itemtype => itemtype,
1247: itemkey => itemkey ,
1248: aname => 'APP_END_DATE');
1249:
1250: l_tc_resource_id := wf_engine.GetItemAttrNumber(
1251: itemtype => itemtype,
1252: itemkey => itemkey ,
1253: aname => 'RESOURCE_ID');
1254:

Line 1393: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1389:
1390: CLOSE c_ap_details;
1391:
1392: --now set workflow attribute to the new application period
1393: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1394: itemkey => itemkey,
1395: aname => 'NEXT_APP_BB_ID',
1396: avalue => l_new_appl_bb_id);
1397:

Line 1398: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1394: itemkey => itemkey,
1395: aname => 'NEXT_APP_BB_ID',
1396: avalue => l_new_appl_bb_id);
1397:
1398: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1399: itemkey => itemkey,
1400: aname => 'NEXT_APP_BB_OVN',
1401: avalue => l_new_appl_bb_ovn);
1402:

Line 2162: wf_engine.SetItemAttrText(

2158:
2159: If l_item_key is not null then
2160:
2161: if(item_attribute_exists('HXCEMP',l_item_key,'IS_DIFF_TC')) then
2162: wf_engine.SetItemAttrText(
2163: itemtype => 'HXCEMP',
2164: itemkey => l_item_key,
2165: aname => 'IS_DIFF_TC',
2166: avalue => 'Y');

Line 2168: wf_engine.additemattr

2164: itemkey => l_item_key,
2165: aname => 'IS_DIFF_TC',
2166: avalue => 'Y');
2167: else
2168: wf_engine.additemattr
2169: (itemtype => 'HXCEMP',
2170: itemkey => l_item_key,
2171: aname => 'IS_DIFF_TC',
2172: text_value => 'Y');

Line 2212: wf_engine.SetItemAttrText(

2208: close get_item_key;
2209:
2210: If l_item_key is not null then
2211: if(item_attribute_exists('HXCEMP',l_item_key,'IS_DIFF_TC')) then
2212: wf_engine.SetItemAttrText(
2213: itemtype => 'HXCEMP',
2214: itemkey => l_item_key,
2215: aname => 'IS_DIFF_TC',
2216: avalue => 'Y');

Line 2218: wf_engine.additemattr

2214: itemkey => l_item_key,
2215: aname => 'IS_DIFF_TC',
2216: avalue => 'Y');
2217: else
2218: wf_engine.additemattr
2219: (itemtype => 'HXCEMP',
2220: itemkey => l_item_key,
2221: aname => 'IS_DIFF_TC',
2222: text_value => 'Y');

Line 2705: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

2701: if g_debug then
2702: hr_utility.set_location(l_proc, 10);
2703: end if;
2704:
2705: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
2706: (itemtype => itemtype,
2707: itemkey => itemkey,
2708: aname => 'TC_BLD_BLK_ID');
2709:

Line 2713: l_tc_ovn := wf_engine.GetItemAttrNumber

2709:
2710: if g_debug then
2711: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
2712: end if;
2713: l_tc_ovn := wf_engine.GetItemAttrNumber
2714: (itemtype => itemtype,
2715: itemkey => itemkey,
2716: aname => 'TC_BLD_BLK_OVN');
2717:

Line 2722: l_tc_resubmitted := wf_engine.GetItemAttrText

2718: if g_debug then
2719: hr_utility.trace('Timecard BB OVN is : ' || to_char(l_tc_ovn));
2720: end if;
2721:
2722: l_tc_resubmitted := wf_engine.GetItemAttrText
2723: (itemtype => itemtype,
2724: itemkey => itemkey,
2725: aname => 'TC_RESUBMITTED');
2726:

Line 3478: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

3474: g_debug:=hr_utility.debug_enabled;
3475: if g_debug then
3476: hr_utility.set_location(l_proc, 10);
3477: end if;
3478: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
3479: (itemtype => itemtype,
3480: itemkey => itemkey,
3481: aname => 'TC_BLD_BLK_ID');
3482:

Line 3486: l_tc_ovn := wf_engine.GetItemAttrNumber

3482:
3483: if g_debug then
3484: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
3485: end if;
3486: l_tc_ovn := wf_engine.GetItemAttrNumber
3487: (itemtype => itemtype,
3488: itemkey => itemkey,
3489: aname => 'TC_BLD_BLK_OVN');
3490:

Line 3494: l_tc_resubmitted := wf_engine.GetItemAttrText

3490:
3491: if g_debug then
3492: hr_utility.trace('Timecard BB OVN is : ' || to_char(l_tc_ovn));
3493: end if;
3494: l_tc_resubmitted := wf_engine.GetItemAttrText
3495: (itemtype => itemtype,
3496: itemkey => itemkey,
3497: aname => 'TC_RESUBMITTED');
3498:

Line 3502: l_bb_new := wf_engine.GetItemAttrText

3498:
3499: if g_debug then
3500: hr_utility.trace('Timecard Resubmitted is : ' || l_tc_resubmitted);
3501: end if;
3502: l_bb_new := wf_engine.GetItemAttrText
3503: (itemtype => itemtype,
3504: itemkey => itemkey,
3505: aname => 'BB_NEW');
3506:

Line 3661: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,

3657: --
3658: -- Setup l_item_key from a sequence.
3659: --
3660: if l_approval_item_key is not null then
3661: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,
3662: itemkey => l_approval_item_key ,
3663: aname => 'IS_DIFF_TC',
3664: ignore_notfound => true);
3665: else

Line 3685: wf_engine.CreateProcess(itemtype => itemtype,

3681: if g_debug then
3682: hr_utility.trace('l_item_key is : ' || l_item_key);
3683: end if;
3684:
3685: wf_engine.CreateProcess(itemtype => itemtype,
3686: itemkey => l_item_key,
3687: process => l_process_name);
3688: wf_engine.setitemowner(itemtype,
3689: l_item_key,

Line 3688: wf_engine.setitemowner(itemtype,

3684:
3685: wf_engine.CreateProcess(itemtype => itemtype,
3686: itemkey => l_item_key,
3687: process => l_process_name);
3688: wf_engine.setitemowner(itemtype,
3689: l_item_key,
3690: HXC_FIND_NOTIFY_APRS_PKG.get_login(p_person_id=>l_tc_resource_id,
3691: p_user_id => l_last_updated_by)
3692: );

Line 3697: wf_engine.SetItemAttrText(

3693: if g_debug then
3694: hr_utility.set_location(l_proc, 260);
3695: end if;
3696: if(item_attribute_exists(itemtype,l_item_key,'IS_DIFF_TC')) then
3697: wf_engine.SetItemAttrText(
3698: itemtype => itemtype,
3699: itemkey => l_item_key,
3700: aname => 'IS_DIFF_TC',
3701: avalue => l_is_blank);

Line 3703: wf_engine.additemattr

3699: itemkey => l_item_key,
3700: aname => 'IS_DIFF_TC',
3701: avalue => l_is_blank);
3702: else
3703: wf_engine.additemattr
3704: (itemtype => itemtype,
3705: itemkey => l_item_key,
3706: aname => 'IS_DIFF_TC',
3707: text_value => l_is_blank);

Line 3710: wf_engine.SetItemAttrDate(itemtype => itemtype,

3706: aname => 'IS_DIFF_TC',
3707: text_value => l_is_blank);
3708: end if;
3709:
3710: wf_engine.SetItemAttrDate(itemtype => itemtype,
3711: itemkey => l_item_key,
3712: aname => 'APP_START_DATE',
3713: avalue => l_period_start_date);
3714:

Line 3715: wf_engine.SetItemAttrText(itemtype => itemtype,

3711: itemkey => l_item_key,
3712: aname => 'APP_START_DATE',
3713: avalue => l_period_start_date);
3714:
3715: wf_engine.SetItemAttrText(itemtype => itemtype,
3716: itemkey => l_item_key,
3717: aname => 'FORMATTED_APP_START_DATE',
3718: avalue => to_char(l_period_start_date,'YYYY/MM/DD'));
3719: if g_debug then

Line 3725: wf_engine.SetItemAttrDate(itemtype => itemtype,

3721: hr_utility.trace('APP_START_DATE is : ' ||
3722: to_char(l_period_start_date, 'DD-MM-YYYY'));
3723: end if;
3724:
3725: wf_engine.SetItemAttrDate(itemtype => itemtype,
3726: itemkey => l_item_key,
3727: aname => 'APP_END_DATE',
3728: avalue => l_period_end_date);
3729:

Line 3736: wf_engine.SetItemAttrNumber(itemtype => itemtype,

3732: hr_utility.trace('APP_END_DATE is : ' ||
3733: to_char(l_period_end_date, 'DD-MM-YYYY'));
3734: end if;
3735:
3736: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3737: itemkey => l_item_key,
3738: aname => 'APP_BB_ID',
3739: avalue => l_appl_period_bb_id);
3740:

Line 3746: wf_engine.SetItemAttrNumber(itemtype => itemtype,

3742: hr_utility.set_location(l_proc, 290);
3743: hr_utility.trace('APP_BB_ID is : ' || to_char(l_appl_period_bb_id));
3744: end if;
3745:
3746: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3747: itemkey => l_item_key,
3748: aname => 'APP_BB_OVN',
3749: avalue => l_appl_period_bb_ovn);
3750:

Line 3757: wf_engine.SetItemAttrNumber(itemtype => itemtype,

3753: hr_utility.trace('APP_BB_OVN is : ' ||
3754: to_char(l_appl_period_bb_ovn));
3755: end if;
3756:
3757: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3758: itemkey => l_item_key,
3759: aname => 'RESOURCE_ID',
3760: avalue => l_tc_resource_id);
3761:

Line 3767: wf_engine.SetItemAttrText(itemtype => itemtype,

3763: hr_utility.set_location(l_proc, 310);
3764: hr_utility.trace('RESOURCE_ID is : ' || to_char(l_tc_resource_id));
3765: end if;
3766:
3767: wf_engine.SetItemAttrText(itemtype => itemtype,
3768: itemkey => l_item_key,
3769: aname => 'TIME_RECIPIENT_ID',
3770: avalue => l_time_recipient);
3771:

Line 3777: wf_engine.SetItemAttrText(itemtype => itemtype,

3773: hr_utility.set_location(l_proc, 320);
3774: hr_utility.trace('TIME_RECIPIENT_ID is : ' || l_time_recipient);
3775: end if;
3776:
3777: wf_engine.SetItemAttrText(itemtype => itemtype,
3778: itemkey => l_item_key,
3779: aname => 'TC_RESUBMITTED',
3780: avalue => l_tc_resubmitted);
3781:

Line 3787: wf_engine.SetItemAttrText(itemtype => itemtype,

3783: hr_utility.set_location(l_proc, 330);
3784: hr_utility.trace('TC_RESUBMITTED is : ' || l_tc_resubmitted);
3785: end if;
3786:
3787: wf_engine.SetItemAttrText(itemtype => itemtype,
3788: itemkey => l_item_key,
3789: aname => 'BB_NEW',
3790: avalue => l_bb_new);
3791:

Line 3797: wf_engine.SetItemAttrNumber(itemtype => itemtype,

3793: hr_utility.set_location(l_proc, 335);
3794: hr_utility.trace('BB_NEW is : ' || l_bb_new);
3795: end if;
3796:
3797: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3798: itemkey => l_item_key,
3799: aname => 'TC_BLD_BLK_ID',
3800: avalue => l_tc_bld_blk_id);
3801:

Line 3807: wf_engine.SetItemAttrNumber(itemtype => itemtype,

3803: hr_utility.set_location(l_proc, 340);
3804: hr_utility.trace('TC_BLD_BLK_ID is : ' || to_char(l_tc_bld_blk_id));
3805: end if;
3806:
3807: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3808: itemkey => l_item_key,
3809: aname => 'TC_BLD_BLK_OVN',
3810: avalue => l_tc_ovn);
3811:

Line 3817: wf_engine.SetItemAttrNumber(itemtype => itemtype,

3813: hr_utility.set_location(l_proc, 350);
3814: hr_utility.trace('TC_BLD_BLK_OVN is : ' || to_char(l_tc_ovn));
3815: end if;
3816:
3817: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3818: itemkey => l_item_key,
3819: aname => 'APPROVAL_STYLE_ID',
3820: avalue => l_approval_style_id);
3821:

Line 3831: wf_engine.SetItemAttrText(itemtype => itemtype,

3827: '&AprvResourceId=' || to_char(l_tc_resource_id) ||
3828: '&OAFunc=HXC_TIME_ENTER'||
3829: '&NtfId=-&#NID-';
3830:
3831: wf_engine.SetItemAttrText(itemtype => itemtype,
3832: itemkey => l_item_key,
3833: aname => 'HXC_TIMECARD_URL',
3834: avalue => l_tc_url);
3835:

Line 3862: wf_engine.StartProcess(itemtype => itemtype,

3858: where application_period_id = l_appl_period_bb_id
3859: and application_period_ovn = l_appl_period_bb_ovn;
3860:
3861:
3862: wf_engine.StartProcess(itemtype => itemtype,
3863: itemkey => l_item_key);
3864:
3865: if g_debug then
3866: hr_utility.set_location(l_proc, 365);

Line 4011: wf_engine.threshold := -1; -- Ensures a deferred process

4007: --
4008: g_error_table.delete;
4009: g_error_count := 0;
4010: if(l_defer='Y') then
4011: wf_engine.threshold := -1; -- Ensures a deferred process
4012: else
4013: wf_engine.threshold := 100;
4014: end if;
4015:

Line 4013: wf_engine.threshold := 100;

4009: g_error_count := 0;
4010: if(l_defer='Y') then
4011: wf_engine.threshold := -1; -- Ensures a deferred process
4012: else
4013: wf_engine.threshold := 100;
4014: end if;
4015:
4016: wf_engine.createProcess
4017: (itemtype => p_item_type

Line 4016: wf_engine.createProcess

4012: else
4013: wf_engine.threshold := 100;
4014: end if;
4015:
4016: wf_engine.createProcess
4017: (itemtype => p_item_type
4018: ,itemkey => p_item_key
4019: ,process => p_process_name
4020: );

Line 4022: wf_engine.SetItemAttrNumber

4018: ,itemkey => p_item_key
4019: ,process => p_process_name
4020: );
4021:
4022: wf_engine.SetItemAttrNumber
4023: (itemtype => p_item_type
4024: ,itemkey => p_item_key
4025: ,aname => 'TC_BLD_BLK_ID'
4026: ,avalue => p_tc_bb_id

Line 4029: wf_engine.SetItemAttrNumber

4025: ,aname => 'TC_BLD_BLK_ID'
4026: ,avalue => p_tc_bb_id
4027: );
4028:
4029: wf_engine.SetItemAttrNumber
4030: (itemtype => p_item_type
4031: ,itemkey => p_item_key
4032: ,aname => 'TC_BLD_BLK_OVN'
4033: ,avalue => p_tc_ovn

Line 4036: wf_engine.SetItemAttrText

4032: ,aname => 'TC_BLD_BLK_OVN'
4033: ,avalue => p_tc_ovn
4034: );
4035:
4036: wf_engine.SetItemAttrText
4037: (itemtype => p_item_type
4038: ,itemkey => p_item_key
4039: ,aname => 'TC_RESUBMITTED'
4040: ,avalue => p_tc_resubmitted

Line 4043: wf_engine.SetItemAttrText

4039: ,aname => 'TC_RESUBMITTED'
4040: ,avalue => p_tc_resubmitted
4041: );
4042:
4043: wf_engine.SetItemAttrText
4044: (itemtype => p_item_type
4045: ,itemkey => p_item_key
4046: ,aname => 'BB_NEW'
4047: ,avalue => p_bb_new

Line 4050: wf_engine.StartProcess

4046: ,aname => 'BB_NEW'
4047: ,avalue => p_bb_new
4048: );
4049:
4050: wf_engine.StartProcess
4051: (itemtype => p_item_type
4052: ,itemkey => p_item_key
4053: );
4054:

Line 4055: wf_engine.threshold := 50;

4051: (itemtype => p_item_type
4052: ,itemkey => p_item_key
4053: );
4054:
4055: wf_engine.threshold := 50;
4056:
4057: END start_approval_wf_process;
4058:
4059:

Line 4114: wf_engine.threshold := -1;

4110: -- p_process_name is HXC_APPROVAL.
4111: --
4112: l_process_name := 'HXC_APPROVAL';
4113: --
4114: wf_engine.threshold := -1;
4115: --
4116: wf_engine.createProcess(itemtype => p_item_type,
4117: itemkey => p_item_key,
4118: process => l_process_name);

Line 4116: wf_engine.createProcess(itemtype => p_item_type,

4112: l_process_name := 'HXC_APPROVAL';
4113: --
4114: wf_engine.threshold := -1;
4115: --
4116: wf_engine.createProcess(itemtype => p_item_type,
4117: itemkey => p_item_key,
4118: process => l_process_name);
4119: --
4120: if g_debug then

Line 4124: wf_engine.SetItemAttrNumber(itemtype => p_item_type,

4120: if g_debug then
4121: hr_utility.set_location(l_proc, 20);
4122: end if;
4123: --
4124: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
4125: itemkey => p_item_key,
4126: aname => 'TC_BLD_BLK_ID',
4127: avalue => p_tc_bb_id);
4128: --

Line 4133: wf_engine.SetItemAttrNumber(itemtype => p_item_type,

4129: if g_debug then
4130: hr_utility.set_location(l_proc, 30);
4131: end if;
4132: --
4133: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
4134: itemkey => p_item_key,
4135: aname => 'TC_BLD_BLK_OVN',
4136: avalue => p_tc_ovn);
4137: --

Line 4142: wf_engine.SetItemAttrText(itemtype => p_item_type,

4138: if g_debug then
4139: hr_utility.set_location(l_proc, 40);
4140: end if;
4141: --
4142: wf_engine.SetItemAttrText(itemtype => p_item_type,
4143: itemkey => p_item_key,
4144: aname => 'TC_RESUBMITTED',
4145: avalue => p_tc_resubmitted);
4146: --

Line 4152: wf_engine.SetItemAttrText(itemtype => p_item_type,

4148: hr_utility.set_location(l_proc, 50);
4149: end if;
4150: --
4151: IF p_bb_new = 'Y' THEN
4152: wf_engine.SetItemAttrText(itemtype => p_item_type,
4153: itemkey => p_item_key,
4154: aname => 'BB_NEW',
4155: avalue => 'YES');
4156: ELSE

Line 4157: wf_engine.SetItemAttrText(itemtype => p_item_type,

4153: itemkey => p_item_key,
4154: aname => 'BB_NEW',
4155: avalue => 'YES');
4156: ELSE
4157: wf_engine.SetItemAttrText(itemtype => p_item_type,
4158: itemkey => p_item_key,
4159: aname => 'BB_NEW',
4160: avalue => 'NO');
4161: END IF;

Line 4167: wf_engine.StartProcess(itemtype => p_item_type,

4163: if g_debug then
4164: hr_utility.set_location(l_proc, 60);
4165: end if;
4166: --
4167: wf_engine.StartProcess(itemtype => p_item_type,
4168: itemkey => p_item_key);
4169: --
4170: wf_engine.threshold := 50;
4171: --

Line 4170: wf_engine.threshold := 50;

4166: --
4167: wf_engine.StartProcess(itemtype => p_item_type,
4168: itemkey => p_item_key);
4169: --
4170: wf_engine.threshold := 50;
4171: --
4172: if g_debug then
4173: hr_utility.set_location(l_proc, 70);
4174: end if;

Line 4359: l_app_bld_blk_id := wf_engine.GetItemAttrNumber

4355: if g_debug then
4356: hr_utility.set_location(l_proc, 10);
4357: end if;
4358: --
4359: l_app_bld_blk_id := wf_engine.GetItemAttrNumber
4360: (itemtype => itemtype,
4361: itemkey => itemkey ,
4362: aname => 'APP_BB_ID');
4363: --

Line 4368: l_app_ovn := wf_engine.GetItemAttrNumber

4364: if g_debug then
4365: hr_utility.set_location(l_proc, 20);
4366: end if;
4367: --
4368: l_app_ovn := wf_engine.GetItemAttrNumber
4369: (itemtype => itemtype,
4370: itemkey => itemkey ,
4371: aname => 'APP_BB_OVN');
4372: --

Line 4373: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

4369: (itemtype => itemtype,
4370: itemkey => itemkey ,
4371: aname => 'APP_BB_OVN');
4372: --
4373: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
4374: (itemtype => itemtype,
4375: itemkey => itemkey,
4376: aname => 'TC_BLD_BLK_ID');
4377: --

Line 4382: l_tc_ovn := wf_engine.GetItemAttrNumber

4378: if g_debug then
4379: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
4380: end if;
4381: --
4382: l_tc_ovn := wf_engine.GetItemAttrNumber
4383: (itemtype => itemtype,
4384: itemkey => itemkey,
4385: aname => 'TC_BLD_BLK_OVN');
4386: --

Line 4387: l_time_recipient := wf_engine.GetItemAttrText(

4383: (itemtype => itemtype,
4384: itemkey => itemkey,
4385: aname => 'TC_BLD_BLK_OVN');
4386: --
4387: l_time_recipient := wf_engine.GetItemAttrText(
4388: itemtype => itemtype,
4389: itemkey => itemkey ,
4390: aname => 'TIME_RECIPIENT_ID');
4391:

Line 4478: wf_engine.SetItemAttrText(itemtype => itemtype,

4474: if g_debug then
4475: hr_utility.set_location(l_proc, 80);
4476: end if;
4477: --
4478: wf_engine.SetItemAttrText(itemtype => itemtype,
4479: itemkey => itemkey,
4480: aname => 'APPR_REQ',
4481: avalue => 'NO');
4482: --

Line 4547: wf_engine.SetItemAttrText(itemtype => itemtype,

4543: if g_debug then
4544: hr_utility.set_location(l_proc, 120);
4545: end if;
4546: --
4547: wf_engine.SetItemAttrText(itemtype => itemtype,
4548: itemkey => itemkey,
4549: aname => 'EXT_MESSAGE',
4550: avalue => l_exception);
4551: --

Line 4558: IF upper(wf_engine.GetItemAttrText(itemtype => itemtype,

4554: if g_debug then
4555: hr_utility.set_location(l_proc, 130);
4556: end if;
4557: --
4558: IF upper(wf_engine.GetItemAttrText(itemtype => itemtype,
4559: itemkey => itemkey ,
4560: aname => 'APPR_REQ')) = 'YES' THEN
4561: --
4562: result := 'COMPLETE:Y';

Line 4580: wf_engine.SetItemAttrText(itemtype => itemtype,

4576: --
4577: hr_utility.trace('APPR_REQ attribute is : NO');
4578: --
4579: end if;
4580: wf_engine.SetItemAttrText(itemtype => itemtype,
4581: itemkey => itemkey,
4582: aname => 'APPROVAL_STATUS',
4583: avalue => 'APPROVED');
4584: --

Line 4585: wf_engine.SetItemAttrText(itemtype => itemtype,

4581: itemkey => itemkey,
4582: aname => 'APPROVAL_STATUS',
4583: avalue => 'APPROVED');
4584: --
4585: wf_engine.SetItemAttrText(itemtype => itemtype,
4586: itemkey => itemkey,
4587: aname => 'APR_REJ_REASON',
4588: avalue => 'AUTO_APPROVE');
4589:

Line 4701: l_app_bld_blk_id := wf_engine.GetItemAttrNumber

4697: if g_debug then
4698: hr_utility.set_location(l_proc, 10);
4699: end if;
4700: --
4701: l_app_bld_blk_id := wf_engine.GetItemAttrNumber
4702: (itemtype => itemtype,
4703: itemkey => itemkey ,
4704: aname => 'APP_BB_ID');
4705: --

Line 4710: l_app_ovn := wf_engine.GetItemAttrNumber

4706: if g_debug then
4707: hr_utility.set_location(l_proc, 20);
4708: end if;
4709: --
4710: l_app_ovn := wf_engine.GetItemAttrNumber
4711: (itemtype => itemtype,
4712: itemkey => itemkey ,
4713: aname => 'APP_BB_OVN');
4714: --

Line 4719: l_time_recipient := wf_engine.GetItemAttrText

4715: if g_debug then
4716: hr_utility.set_location(l_proc, 30);
4717: end if;
4718: --
4719: l_time_recipient := wf_engine.GetItemAttrText
4720: (itemtype => itemtype,
4721: itemkey => itemkey,
4722: aname => 'TIME_RECIPIENT_ID');
4723: --

Line 4735: l_tc_appr_style_id := wf_engine.GetItemAttrNumber

4731:
4732: hr_utility.set_location(l_proc, 70);
4733: --
4734: end if;
4735: l_tc_appr_style_id := wf_engine.GetItemAttrNumber
4736: (itemtype => itemtype,
4737: itemkey => itemkey,
4738: aname => 'APPROVAL_STYLE_ID');
4739: --

Line 4767: -- wf_engine.SetItemAttrText(itemtype => itemtype,

4763: --
4764: -- hr_utility.trace('Setting Status to Approved');
4765: --
4766: end if;
4767: -- wf_engine.SetItemAttrText(itemtype => itemtype,
4768: -- itemkey => itemkey,
4769: -- aname => 'APPROVAL_STATUS',
4770: -- avalue => 'APPROVED');
4771: --

Line 4815: wf_engine.SetItemAttrText(itemtype => itemtype,

4811: if g_debug then
4812: hr_utility.set_location(l_proc, 120);
4813: end if;
4814: --
4815: wf_engine.SetItemAttrText(itemtype => itemtype,
4816: itemkey => itemkey,
4817: aname => 'ALL_RULES',
4818: avalue => l_all_rules);
4819: --

Line 4873: l_all_rules := wf_engine.GetItemAttrText(itemtype => itemtype,

4869: if g_debug then
4870: hr_utility.set_location(l_proc, 10);
4871: end if;
4872: --
4873: l_all_rules := wf_engine.GetItemAttrText(itemtype => itemtype,
4874: itemkey => itemkey ,
4875: aname => 'ALL_RULES');
4876: --
4877: if g_debug then

Line 4912: wf_engine.SetItemAttrText(itemtype => itemtype,

4908: if g_debug then
4909: hr_utility.trace('No More Rules - Setting status to APPROVED');
4910: end if;
4911: --
4912: wf_engine.SetItemAttrText(itemtype => itemtype,
4913: itemkey => itemkey,
4914: aname => 'APPROVAL_STATUS',
4915: avalue => 'APPROVED');
4916:

Line 4918: wf_engine.SetItemAttrText(itemtype => itemtype,

4914: aname => 'APPROVAL_STATUS',
4915: avalue => 'APPROVED');
4916:
4917:
4918: wf_engine.SetItemAttrText(itemtype => itemtype,
4919: itemkey => itemkey,
4920: aname => 'APR_REJ_REASON',
4921: avalue => 'AUTO_APPROVE');
4922: --OIT Enhancement.

Line 4936: wf_engine.SetItemAttrText(itemtype => itemtype,

4932: return;
4933: --
4934: END IF;
4935: --
4936: wf_engine.SetItemAttrText(itemtype => itemtype,
4937: itemkey => itemkey,
4938: aname => 'CURRENT_RULE',
4939: avalue => l_current_rule);
4940: --

Line 4947: wf_engine.SetItemAttrText(itemtype => itemtype,

4943: --
4944: hr_utility.trace('CURRENT_RULE is : ' || l_current_rule);
4945: --
4946: end if;
4947: wf_engine.SetItemAttrText(itemtype => itemtype,
4948: itemkey => itemkey,
4949: aname => 'ALL_RULES',
4950: avalue => l_all_rules);
4951: --

Line 5163: l_current_rule := wf_engine.GetItemAttrText(itemtype => itemtype,

5159: end if;
5160: --
5161:
5162:
5163: l_current_rule := wf_engine.GetItemAttrText(itemtype => itemtype,
5164: itemkey => itemkey,
5165: aname => 'CURRENT_RULE');
5166: --
5167: if g_debug then

Line 5171: l_app_start_date := wf_engine.GetItemAttrDate(itemtype => itemtype,

5167: if g_debug then
5168: hr_utility.set_location(l_proc, 20);
5169: end if;
5170: --
5171: l_app_start_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
5172: itemkey => itemkey,
5173: aname => 'APP_START_DATE');
5174: --
5175: if g_debug then

Line 5179: l_app_end_date := wf_engine.GetItemAttrDate(itemtype => itemtype,

5175: if g_debug then
5176: hr_utility.set_location(l_proc, 25);
5177: end if;
5178: --
5179: l_app_end_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
5180: itemkey => itemkey,
5181: aname => 'APP_END_DATE');
5182: --
5183: if g_debug then

Line 5187: l_tc_resource_id := wf_engine.GetItemAttrNumber(

5183: if g_debug then
5184: hr_utility.set_location(l_proc, 30);
5185: end if;
5186: --
5187: l_tc_resource_id := wf_engine.GetItemAttrNumber(
5188: itemtype => itemtype,
5189: itemkey => itemkey,
5190: aname => 'RESOURCE_ID');
5191: --

Line 5196: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

5192: if g_debug then
5193: hr_utility.set_location(l_proc, 40);
5194: end if;
5195: --
5196: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
5197: (itemtype => itemtype,
5198: itemkey => itemkey,
5199: aname => 'TC_BLD_BLK_ID');
5200: --

Line 5205: l_tc_ovn := wf_engine.GetItemAttrNumber

5201: if g_debug then
5202: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
5203: end if;
5204: --
5205: l_tc_ovn := wf_engine.GetItemAttrNumber
5206: (itemtype => itemtype,
5207: itemkey => itemkey,
5208: aname => 'TC_BLD_BLK_OVN');
5209: --

Line 5217: l_resubmit := wf_engine.GetItemAttrText(itemtype => itemtype,

5213: --
5214: -- Set up l_resubmit to indicate whether this is a resubmission or not.
5215: -- (YES means it is a resubmission; NO means it is a submission).
5216: --
5217: l_resubmit := wf_engine.GetItemAttrText(itemtype => itemtype,
5218: itemkey => itemkey,
5219: aname => 'TC_RESUBMITTED');
5220: --
5221: if g_debug then

Line 5225: l_bb_new := wf_engine.GetItemAttrText(itemtype => itemtype,

5221: if g_debug then
5222: hr_utility.set_location(l_proc, 50);
5223: end if;
5224: --
5225: l_bb_new := wf_engine.GetItemAttrText(itemtype => itemtype,
5226: itemkey => itemkey,
5227: aname => 'BB_NEW');
5228: --
5229: if g_debug then

Line 5279: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(

5275: --
5276: if g_debug then
5277: hr_utility.set_location(l_proc, 90);
5278: end if;
5279: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
5280: itemtype => itemtype,
5281: itemkey => itemkey,
5282: aname => 'APP_BB_ID');
5283:

Line 5287: l_appl_period_bb_ovn := wf_engine.GetItemAttrNumber(

5283:
5284: if g_debug then
5285: hr_utility.trace('APP_BB_ID is : ' || to_char(l_appl_period_bb_id));
5286: end if;
5287: l_appl_period_bb_ovn := wf_engine.GetItemAttrNumber(
5288: itemtype => itemtype,
5289: itemkey => itemkey,
5290: aname => 'APP_BB_OVN');
5291:

Line 5294: wf_engine.SetItemAttrText(itemtype => itemtype,

5290: aname => 'APP_BB_OVN');
5291:
5292: IF NOT was_approved(l_appl_period_bb_id, l_appl_period_bb_ovn)
5293: THEN
5294: wf_engine.SetItemAttrText(itemtype => itemtype,
5295: itemkey => itemkey,
5296: aname => 'TO_APPROVE',
5297: avalue => 'YES');
5298:

Line 5457: wf_engine.SetItemAttrText(itemtype => itemtype,

5453: hr_utility.set_message(809, l_error_table(1).message_name);
5454: hr_utility.raise_error;
5455: END IF;
5456: --
5457: wf_engine.SetItemAttrText(itemtype => itemtype,
5458: itemkey => itemkey,
5459: aname => 'TO_APPROVE',
5460: avalue => upper(l_result));
5461: --

Line 5474: wf_engine.SetItemAttrText(itemtype => itemtype,

5470: if g_debug then
5471: hr_utility.set_location(l_proc, 230);
5472: end if;
5473: --
5474: wf_engine.SetItemAttrText(itemtype => itemtype,
5475: itemkey => itemkey,
5476: aname => 'TO_APPROVE',
5477: avalue => l_changed);
5478: --

Line 5495: /* wf_engine.SetItemAttrText(itemtype => itemtype,

5491: end if;
5492: --
5493: -- Modifying the 'TO_APPROVE' value from 'NO' to 'YES' and Commenting out the following code for bug#3497011.
5494:
5495: /* wf_engine.SetItemAttrText(itemtype => itemtype,
5496: itemkey => itemkey,
5497: aname => 'TO_APPROVE',
5498: avalue => 'NO');
5499: --

Line 5504: wf_engine.SetItemAttrText(itemtype => itemtype,

5500: if g_debug then
5501: hr_utility.trace('TO_APPROVE is : NO');
5502: end if; */
5503:
5504: wf_engine.SetItemAttrText(itemtype => itemtype,
5505: itemkey => itemkey,
5506: aname => 'TO_APPROVE',
5507: avalue => 'YES');
5508: --

Line 5565: l_to_approve := wf_engine.GetItemAttrText(itemtype => itemtype,

5561: if g_debug then
5562: hr_utility.set_location(l_proc, 10);
5563: end if;
5564: --
5565: l_to_approve := wf_engine.GetItemAttrText(itemtype => itemtype,
5566: itemkey => itemkey ,
5567: aname => 'TO_APPROVE');
5568: --
5569: if g_debug then

Line 5663: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,

5659: l_approval_mechansim varchar2(20);
5660:
5661: begin
5662:
5663: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,
5664: itemkey => itemkey ,
5665: aname => 'IS_DIFF_TC',
5666: ignore_notfound => true
5667: );

Line 5669: l_app_bb_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

5665: aname => 'IS_DIFF_TC',
5666: ignore_notfound => true
5667: );
5668:
5669: l_app_bb_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5670: itemkey => itemkey ,
5671: aname => 'APP_BB_ID');
5672:
5673: if l_is_blank = 'Y' then

Line 5677: wf_engine.SetItemAttrNumber(

5673: if l_is_blank = 'Y' then
5674:
5675: l_total_hours:= HXC_FIND_NOTIFY_APRS_PKG.category_timecard_hrs(l_app_bb_id,'');
5676:
5677: wf_engine.SetItemAttrNumber(
5678: itemtype => itemtype,
5679: itemkey => itemkey,
5680: aname => 'TOTAL_TC_HOURS',
5681: avalue => l_total_hours);