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 1125: l_tc_resource_id := wf_engine.GetItemAttrNumber(

1121: if g_debug then
1122: hr_utility.set_location(l_proc, 10);
1123: end if;
1124:
1125: l_tc_resource_id := wf_engine.GetItemAttrNumber(
1126: itemtype => itemtype,
1127: itemkey => itemkey ,
1128: aname => 'RESOURCE_ID');
1129:

Line 1135: l_period_start_date := wf_engine.GetItemAttrDate(

1131: if g_debug then
1132: hr_utility.set_location(l_proc, 30);
1133: end if;
1134:
1135: l_period_start_date := wf_engine.GetItemAttrDate(
1136: itemtype => itemtype,
1137: itemkey => itemkey ,
1138: aname => 'APP_START_DATE');
1139:

Line 1144: l_period_end_date := wf_engine.GetItemAttrDate(

1140: if g_debug then
1141: hr_utility.set_location(l_proc, 40);
1142: end if;
1143:
1144: l_period_end_date := wf_engine.GetItemAttrDate(
1145: itemtype => itemtype,
1146: itemkey => itemkey ,
1147: aname => 'APP_END_DATE');
1148:

Line 1153: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(

1149: if g_debug then
1150: hr_utility.set_location(l_proc, 50);
1151: end if;
1152:
1153: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
1154: itemtype => itemtype,
1155: itemkey => itemkey,
1156: aname => 'APP_BB_ID');
1157:

Line 1162: l_appl_period_bb_ovn := wf_engine.GetItemAttrNumber(

1158: if g_debug then
1159: hr_utility.set_location(l_proc, 60);
1160: end if;
1161:
1162: l_appl_period_bb_ovn := wf_engine.GetItemAttrNumber(
1163: itemtype => itemtype,
1164: itemkey => itemkey,
1165: aname => 'APP_BB_OVN');
1166:

Line 1174: l_approval_status := wf_engine.GetItemAttrText(

1170:
1171: -- Set up the approval status - get the value for the APPROVAL_STATUS
1172: -- attribute, which is set up in the activity previous to this one.
1173: --
1174: l_approval_status := wf_engine.GetItemAttrText(
1175: itemtype => itemtype,
1176: itemkey => itemkey ,
1177: aname => 'APPROVAL_STATUS');
1178:

Line 1179: l_approver_comment := wf_engine.GetItemAttrText(

1175: itemtype => itemtype,
1176: itemkey => itemkey ,
1177: aname => 'APPROVAL_STATUS');
1178:
1179: l_approver_comment := wf_engine.GetItemAttrText(
1180: itemtype => itemtype,
1181: itemkey => itemkey,
1182: aname => 'APR_REJ_REASON');
1183:

Line 1193: l_wf_item_type := wf_engine.GetItemAttrText(

1189:
1190: --get approver id
1191: --what happens to l_approver if AUTO_APPROVE??
1192:
1193: l_wf_item_type := wf_engine.GetItemAttrText(
1194: itemtype => itemtype
1195: ,itemkey => itemkey
1196: ,aname => 'WF_ITEM_TYPE'
1197: );

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

1232: hr_utility.trace('OTL: Exists in g table');
1233: l_is_blank := g_old_item_key(itemkey).is_diff_tc;
1234: ELSE
1235: hr_utility.trace('OTL: Not exists in g table');
1236: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,
1237: itemkey => itemkey ,
1238: aname => 'IS_DIFF_TC',
1239: ignore_notfound => true);
1240: END IF;

Line 1414: l_period_id := wf_engine.GetItemAttrNumber(

1410: end if;
1411:
1412: IF funcmode = 'RUN'
1413: THEN
1414: l_period_id := wf_engine.GetItemAttrNumber(
1415: itemtype => itemtype,
1416: itemkey => itemkey ,
1417: aname => 'APP_BB_ID');
1418:

Line 1419: l_period_start_date := wf_engine.GetItemAttrDate(

1415: itemtype => itemtype,
1416: itemkey => itemkey ,
1417: aname => 'APP_BB_ID');
1418:
1419: l_period_start_date := wf_engine.GetItemAttrDate(
1420: itemtype => itemtype,
1421: itemkey => itemkey ,
1422: aname => 'APP_START_DATE');
1423:

Line 1424: l_period_end_date := wf_engine.GetItemAttrDate(

1420: itemtype => itemtype,
1421: itemkey => itemkey ,
1422: aname => 'APP_START_DATE');
1423:
1424: l_period_end_date := wf_engine.GetItemAttrDate(
1425: itemtype => itemtype,
1426: itemkey => itemkey ,
1427: aname => 'APP_END_DATE');
1428:

Line 1429: l_tc_resource_id := wf_engine.GetItemAttrNumber(

1425: itemtype => itemtype,
1426: itemkey => itemkey ,
1427: aname => 'APP_END_DATE');
1428:
1429: l_tc_resource_id := wf_engine.GetItemAttrNumber(
1430: itemtype => itemtype,
1431: itemkey => itemkey ,
1432: aname => 'RESOURCE_ID');
1433:

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

1568:
1569: CLOSE c_ap_details;
1570:
1571: --now set workflow attribute to the new application period
1572: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1573: itemkey => itemkey,
1574: aname => 'NEXT_APP_BB_ID',
1575: avalue => l_new_appl_bb_id);
1576:

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

1573: itemkey => itemkey,
1574: aname => 'NEXT_APP_BB_ID',
1575: avalue => l_new_appl_bb_id);
1576:
1577: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1578: itemkey => itemkey,
1579: aname => 'NEXT_APP_BB_OVN',
1580: avalue => l_new_appl_bb_ovn);
1581:

Line 2423: wf_engine.SetItemAttrText(

2419: if(item_attribute_exists('HXCEMP',l_item_key,'IS_DIFF_TC')) then
2420:
2421: hr_utility.trace('SetItemAttrText of IS_DIFF_TC to Y - 01');
2422:
2423: wf_engine.SetItemAttrText(
2424: itemtype => 'HXCEMP',
2425: itemkey => l_item_key,
2426: aname => 'IS_DIFF_TC',
2427: avalue => 'Y');

Line 2432: wf_engine.additemattr

2428: else
2429:
2430: hr_utility.trace('SetItemAttrText of IS_DIFF_TC to Y - 02');
2431:
2432: wf_engine.additemattr
2433: (itemtype => 'HXCEMP',
2434: itemkey => l_item_key,
2435: aname => 'IS_DIFF_TC',
2436: text_value => 'Y');

Line 2546: wf_engine.SetItemAttrText(

2542: hr_utility.trace('OTL: Item key exists in workflow tables');
2543: if(item_attribute_exists('HXCEMP',l_item_key,'IS_DIFF_TC')) then
2544:
2545: hr_utility.trace('SetItemAttrText of IS_DIFF_TC to Y - 03');
2546: wf_engine.SetItemAttrText(
2547: itemtype => 'HXCEMP',
2548: itemkey => l_item_key,
2549: aname => 'IS_DIFF_TC',
2550: avalue => 'Y');

Line 2553: wf_engine.additemattr

2549: aname => 'IS_DIFF_TC',
2550: avalue => 'Y');
2551: else
2552: hr_utility.trace('SetItemAttrText of IS_DIFF_TC to Y - 04');
2553: wf_engine.additemattr
2554: (itemtype => 'HXCEMP',
2555: itemkey => l_item_key,
2556: aname => 'IS_DIFF_TC',
2557: text_value => 'Y');

Line 3160: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

3156: if g_debug then
3157: hr_utility.set_location(l_proc, 10);
3158: end if;
3159:
3160: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
3161: (itemtype => itemtype,
3162: itemkey => itemkey,
3163: aname => 'TC_BLD_BLK_ID');
3164:

Line 3168: l_tc_ovn := wf_engine.GetItemAttrNumber

3164:
3165: if g_debug then
3166: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
3167: end if;
3168: l_tc_ovn := wf_engine.GetItemAttrNumber
3169: (itemtype => itemtype,
3170: itemkey => itemkey,
3171: aname => 'TC_BLD_BLK_OVN');
3172:

Line 3177: l_tc_resubmitted := wf_engine.GetItemAttrText

3173: if g_debug then
3174: hr_utility.trace('Timecard BB OVN is : ' || to_char(l_tc_ovn));
3175: end if;
3176:
3177: l_tc_resubmitted := wf_engine.GetItemAttrText
3178: (itemtype => itemtype,
3179: itemkey => itemkey,
3180: aname => 'TC_RESUBMITTED');
3181:

Line 4110: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

4106: g_debug:=hr_utility.debug_enabled;
4107: if g_debug then
4108: hr_utility.set_location(l_proc, 10);
4109: end if;
4110: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
4111: (itemtype => itemtype,
4112: itemkey => itemkey,
4113: aname => 'TC_BLD_BLK_ID');
4114:

Line 4118: l_tc_ovn := wf_engine.GetItemAttrNumber

4114:
4115: if g_debug then
4116: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
4117: end if;
4118: l_tc_ovn := wf_engine.GetItemAttrNumber
4119: (itemtype => itemtype,
4120: itemkey => itemkey,
4121: aname => 'TC_BLD_BLK_OVN');
4122:

Line 4126: l_tc_resubmitted := wf_engine.GetItemAttrText

4122:
4123: if g_debug then
4124: hr_utility.trace('Timecard BB OVN is : ' || to_char(l_tc_ovn));
4125: end if;
4126: l_tc_resubmitted := wf_engine.GetItemAttrText
4127: (itemtype => itemtype,
4128: itemkey => itemkey,
4129: aname => 'TC_RESUBMITTED');
4130:

Line 4134: l_bb_new := wf_engine.GetItemAttrText

4130:
4131: if g_debug then
4132: hr_utility.trace('Timecard Resubmitted is : ' || l_tc_resubmitted);
4133: end if;
4134: l_bb_new := wf_engine.GetItemAttrText
4135: (itemtype => itemtype,
4136: itemkey => itemkey,
4137: aname => 'BB_NEW');
4138:

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

4300: hr_utility.trace('OTL: 200: exists in g table');
4301: l_is_blank := g_old_item_key(l_approval_item_key).is_diff_tc;
4302: ELSE
4303:
4304: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,
4305: itemkey => l_approval_item_key ,
4306: aname => 'IS_DIFF_TC',
4307: ignore_notfound => true);
4308: END IF;

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

4326: if g_debug then
4327: hr_utility.trace('l_item_key is : ' || l_item_key);
4328: end if;
4329:
4330: wf_engine.CreateProcess(itemtype => itemtype,
4331: itemkey => l_item_key,
4332: process => l_process_name);
4333: wf_engine.setitemowner(itemtype,
4334: l_item_key,

Line 4333: wf_engine.setitemowner(itemtype,

4329:
4330: wf_engine.CreateProcess(itemtype => itemtype,
4331: itemkey => l_item_key,
4332: process => l_process_name);
4333: wf_engine.setitemowner(itemtype,
4334: l_item_key,
4335: HXC_FIND_NOTIFY_APRS_PKG.get_login(p_person_id=>l_tc_resource_id,
4336: p_user_id => l_last_updated_by)
4337: );

Line 4345: wf_engine.SetItemAttrText(

4341: if(item_attribute_exists(itemtype,l_item_key,'IS_DIFF_TC')) then
4342:
4343: hr_utility.trace('SetItemAttrText of IS_DIFF_TC to '||l_is_blank||' - 05');
4344:
4345: wf_engine.SetItemAttrText(
4346: itemtype => itemtype,
4347: itemkey => l_item_key,
4348: aname => 'IS_DIFF_TC',
4349: avalue => l_is_blank);

Line 4354: wf_engine.additemattr

4350: else
4351:
4352: hr_utility.trace('SetItemAttrText of IS_DIFF_TC to '||l_is_blank||' - 06');
4353:
4354: wf_engine.additemattr
4355: (itemtype => itemtype,
4356: itemkey => l_item_key,
4357: aname => 'IS_DIFF_TC',
4358: text_value => l_is_blank);

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

4357: aname => 'IS_DIFF_TC',
4358: text_value => l_is_blank);
4359: end if;
4360:
4361: wf_engine.SetItemAttrDate(itemtype => itemtype,
4362: itemkey => l_item_key,
4363: aname => 'APP_START_DATE',
4364: avalue => l_period_start_date);
4365:

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

4362: itemkey => l_item_key,
4363: aname => 'APP_START_DATE',
4364: avalue => l_period_start_date);
4365:
4366: wf_engine.SetItemAttrText(itemtype => itemtype,
4367: itemkey => l_item_key,
4368: aname => 'FORMATTED_APP_START_DATE',
4369: avalue => to_char(l_period_start_date,'YYYY/MM/DD'));
4370: if g_debug then

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

4372: hr_utility.trace('APP_START_DATE is : ' ||
4373: to_char(l_period_start_date, 'DD-MM-YYYY'));
4374: end if;
4375:
4376: wf_engine.SetItemAttrDate(itemtype => itemtype,
4377: itemkey => l_item_key,
4378: aname => 'APP_END_DATE',
4379: avalue => l_period_end_date);
4380:

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

4383: hr_utility.trace('APP_END_DATE is : ' ||
4384: to_char(l_period_end_date, 'DD-MM-YYYY'));
4385: end if;
4386:
4387: wf_engine.SetItemAttrNumber(itemtype => itemtype,
4388: itemkey => l_item_key,
4389: aname => 'APP_BB_ID',
4390: avalue => l_appl_period_bb_id);
4391:

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

4393: hr_utility.set_location(l_proc, 290);
4394: hr_utility.trace('APP_BB_ID is : ' || to_char(l_appl_period_bb_id));
4395: end if;
4396:
4397: wf_engine.SetItemAttrNumber(itemtype => itemtype,
4398: itemkey => l_item_key,
4399: aname => 'APP_BB_OVN',
4400: avalue => l_appl_period_bb_ovn);
4401:

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

4404: hr_utility.trace('APP_BB_OVN is : ' ||
4405: to_char(l_appl_period_bb_ovn));
4406: end if;
4407:
4408: wf_engine.SetItemAttrNumber(itemtype => itemtype,
4409: itemkey => l_item_key,
4410: aname => 'RESOURCE_ID',
4411: avalue => l_tc_resource_id);
4412:

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

4414: hr_utility.set_location(l_proc, 310);
4415: hr_utility.trace('RESOURCE_ID is : ' || to_char(l_tc_resource_id));
4416: end if;
4417:
4418: wf_engine.SetItemAttrText(itemtype => itemtype,
4419: itemkey => l_item_key,
4420: aname => 'TIME_RECIPIENT_ID',
4421: avalue => l_time_recipient);
4422:

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

4424: hr_utility.set_location(l_proc, 320);
4425: hr_utility.trace('TIME_RECIPIENT_ID is : ' || l_time_recipient);
4426: end if;
4427:
4428: wf_engine.SetItemAttrText(itemtype => itemtype,
4429: itemkey => l_item_key,
4430: aname => 'TC_RESUBMITTED',
4431: avalue => l_tc_resubmitted);
4432:

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

4434: hr_utility.set_location(l_proc, 330);
4435: hr_utility.trace('TC_RESUBMITTED is : ' || l_tc_resubmitted);
4436: end if;
4437:
4438: wf_engine.SetItemAttrText(itemtype => itemtype,
4439: itemkey => l_item_key,
4440: aname => 'BB_NEW',
4441: avalue => l_bb_new);
4442:

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

4444: hr_utility.set_location(l_proc, 335);
4445: hr_utility.trace('BB_NEW is : ' || l_bb_new);
4446: end if;
4447:
4448: wf_engine.SetItemAttrNumber(itemtype => itemtype,
4449: itemkey => l_item_key,
4450: aname => 'TC_BLD_BLK_ID',
4451: avalue => l_tc_bld_blk_id);
4452:

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

4454: hr_utility.set_location(l_proc, 340);
4455: hr_utility.trace('TC_BLD_BLK_ID is : ' || to_char(l_tc_bld_blk_id));
4456: end if;
4457:
4458: wf_engine.SetItemAttrNumber(itemtype => itemtype,
4459: itemkey => l_item_key,
4460: aname => 'TC_BLD_BLK_OVN',
4461: avalue => l_tc_ovn);
4462:

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

4464: hr_utility.set_location(l_proc, 350);
4465: hr_utility.trace('TC_BLD_BLK_OVN is : ' || to_char(l_tc_ovn));
4466: end if;
4467:
4468: wf_engine.SetItemAttrNumber(itemtype => itemtype,
4469: itemkey => l_item_key,
4470: aname => 'APPROVAL_STYLE_ID',
4471: avalue => l_approval_style_id);
4472:

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

4479: '&OAFunc=HXC_TIME_ENTER'||
4480: '&NtfId=-&#NID-';
4481:
4482:
4483: wf_engine.SetItemAttrText(itemtype => itemtype,
4484: itemkey => l_item_key,
4485: aname => 'HXC_TIMECARD_URL',
4486: avalue => l_tc_url);
4487:

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

4510: where application_period_id = l_appl_period_bb_id
4511: and application_period_ovn = l_appl_period_bb_ovn;
4512:
4513:
4514: wf_engine.StartProcess(itemtype => itemtype,
4515: itemkey => l_item_key);
4516:
4517: if g_debug then
4518: hr_utility.set_location(l_proc, 365);

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

4659: --
4660: g_error_table.delete;
4661: g_error_count := 0;
4662: if(l_defer='Y') then
4663: wf_engine.threshold := -1; -- Ensures a deferred process
4664: else
4665: wf_engine.threshold := 100;
4666: end if;
4667:

Line 4665: wf_engine.threshold := 100;

4661: g_error_count := 0;
4662: if(l_defer='Y') then
4663: wf_engine.threshold := -1; -- Ensures a deferred process
4664: else
4665: wf_engine.threshold := 100;
4666: end if;
4667:
4668: wf_engine.createProcess
4669: (itemtype => p_item_type

Line 4668: wf_engine.createProcess

4664: else
4665: wf_engine.threshold := 100;
4666: end if;
4667:
4668: wf_engine.createProcess
4669: (itemtype => p_item_type
4670: ,itemkey => p_item_key
4671: ,process => p_process_name
4672: );

Line 4674: wf_engine.SetItemAttrNumber

4670: ,itemkey => p_item_key
4671: ,process => p_process_name
4672: );
4673:
4674: wf_engine.SetItemAttrNumber
4675: (itemtype => p_item_type
4676: ,itemkey => p_item_key
4677: ,aname => 'TC_BLD_BLK_ID'
4678: ,avalue => p_tc_bb_id

Line 4681: wf_engine.SetItemAttrNumber

4677: ,aname => 'TC_BLD_BLK_ID'
4678: ,avalue => p_tc_bb_id
4679: );
4680:
4681: wf_engine.SetItemAttrNumber
4682: (itemtype => p_item_type
4683: ,itemkey => p_item_key
4684: ,aname => 'TC_BLD_BLK_OVN'
4685: ,avalue => p_tc_ovn

Line 4688: wf_engine.SetItemAttrText

4684: ,aname => 'TC_BLD_BLK_OVN'
4685: ,avalue => p_tc_ovn
4686: );
4687:
4688: wf_engine.SetItemAttrText
4689: (itemtype => p_item_type
4690: ,itemkey => p_item_key
4691: ,aname => 'TC_RESUBMITTED'
4692: ,avalue => p_tc_resubmitted

Line 4695: wf_engine.SetItemAttrText

4691: ,aname => 'TC_RESUBMITTED'
4692: ,avalue => p_tc_resubmitted
4693: );
4694:
4695: wf_engine.SetItemAttrText
4696: (itemtype => p_item_type
4697: ,itemkey => p_item_key
4698: ,aname => 'BB_NEW'
4699: ,avalue => p_bb_new

Line 4702: wf_engine.StartProcess

4698: ,aname => 'BB_NEW'
4699: ,avalue => p_bb_new
4700: );
4701:
4702: wf_engine.StartProcess
4703: (itemtype => p_item_type
4704: ,itemkey => p_item_key
4705: );
4706:

Line 4707: wf_engine.threshold := 50;

4703: (itemtype => p_item_type
4704: ,itemkey => p_item_key
4705: );
4706:
4707: wf_engine.threshold := 50;
4708:
4709: END start_approval_wf_process;
4710:
4711:

Line 4766: wf_engine.threshold := -1;

4762: -- p_process_name is HXC_APPROVAL.
4763: --
4764: l_process_name := 'HXC_APPROVAL';
4765: --
4766: wf_engine.threshold := -1;
4767: --
4768: wf_engine.createProcess(itemtype => p_item_type,
4769: itemkey => p_item_key,
4770: process => l_process_name);

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

4764: l_process_name := 'HXC_APPROVAL';
4765: --
4766: wf_engine.threshold := -1;
4767: --
4768: wf_engine.createProcess(itemtype => p_item_type,
4769: itemkey => p_item_key,
4770: process => l_process_name);
4771: --
4772: if g_debug then

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

4772: if g_debug then
4773: hr_utility.set_location(l_proc, 20);
4774: end if;
4775: --
4776: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
4777: itemkey => p_item_key,
4778: aname => 'TC_BLD_BLK_ID',
4779: avalue => p_tc_bb_id);
4780: --

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

4781: if g_debug then
4782: hr_utility.set_location(l_proc, 30);
4783: end if;
4784: --
4785: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
4786: itemkey => p_item_key,
4787: aname => 'TC_BLD_BLK_OVN',
4788: avalue => p_tc_ovn);
4789: --

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

4790: if g_debug then
4791: hr_utility.set_location(l_proc, 40);
4792: end if;
4793: --
4794: wf_engine.SetItemAttrText(itemtype => p_item_type,
4795: itemkey => p_item_key,
4796: aname => 'TC_RESUBMITTED',
4797: avalue => p_tc_resubmitted);
4798: --

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

4800: hr_utility.set_location(l_proc, 50);
4801: end if;
4802: --
4803: IF p_bb_new = 'Y' THEN
4804: wf_engine.SetItemAttrText(itemtype => p_item_type,
4805: itemkey => p_item_key,
4806: aname => 'BB_NEW',
4807: avalue => 'YES');
4808: ELSE

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

4805: itemkey => p_item_key,
4806: aname => 'BB_NEW',
4807: avalue => 'YES');
4808: ELSE
4809: wf_engine.SetItemAttrText(itemtype => p_item_type,
4810: itemkey => p_item_key,
4811: aname => 'BB_NEW',
4812: avalue => 'NO');
4813: END IF;

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

4815: if g_debug then
4816: hr_utility.set_location(l_proc, 60);
4817: end if;
4818: --
4819: wf_engine.StartProcess(itemtype => p_item_type,
4820: itemkey => p_item_key);
4821: --
4822: wf_engine.threshold := 50;
4823: --

Line 4822: wf_engine.threshold := 50;

4818: --
4819: wf_engine.StartProcess(itemtype => p_item_type,
4820: itemkey => p_item_key);
4821: --
4822: wf_engine.threshold := 50;
4823: --
4824: if g_debug then
4825: hr_utility.set_location(l_proc, 70);
4826: end if;

Line 5046: l_app_bld_blk_id := wf_engine.GetItemAttrNumber

5042: if g_debug then
5043: hr_utility.set_location(l_proc, 10);
5044: end if;
5045: --
5046: l_app_bld_blk_id := wf_engine.GetItemAttrNumber
5047: (itemtype => itemtype,
5048: itemkey => itemkey ,
5049: aname => 'APP_BB_ID');
5050: --

Line 5055: l_app_ovn := wf_engine.GetItemAttrNumber

5051: if g_debug then
5052: hr_utility.set_location(l_proc, 20);
5053: end if;
5054: --
5055: l_app_ovn := wf_engine.GetItemAttrNumber
5056: (itemtype => itemtype,
5057: itemkey => itemkey ,
5058: aname => 'APP_BB_OVN');
5059: --

Line 5060: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

5056: (itemtype => itemtype,
5057: itemkey => itemkey ,
5058: aname => 'APP_BB_OVN');
5059: --
5060: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
5061: (itemtype => itemtype,
5062: itemkey => itemkey,
5063: aname => 'TC_BLD_BLK_ID');
5064: --

Line 5069: l_tc_ovn := wf_engine.GetItemAttrNumber

5065: if g_debug then
5066: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
5067: end if;
5068: --
5069: l_tc_ovn := wf_engine.GetItemAttrNumber
5070: (itemtype => itemtype,
5071: itemkey => itemkey,
5072: aname => 'TC_BLD_BLK_OVN');
5073: --

Line 5074: l_time_recipient := wf_engine.GetItemAttrText(

5070: (itemtype => itemtype,
5071: itemkey => itemkey,
5072: aname => 'TC_BLD_BLK_OVN');
5073: --
5074: l_time_recipient := wf_engine.GetItemAttrText(
5075: itemtype => itemtype,
5076: itemkey => itemkey ,
5077: aname => 'TIME_RECIPIENT_ID');
5078:

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

5161: if g_debug then
5162: hr_utility.set_location(l_proc, 80);
5163: end if;
5164: --
5165: wf_engine.SetItemAttrText(itemtype => itemtype,
5166: itemkey => itemkey,
5167: aname => 'APPR_REQ',
5168: avalue => 'NO');
5169: --

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

5230: if g_debug then
5231: hr_utility.set_location(l_proc, 120);
5232: end if;
5233: --
5234: wf_engine.SetItemAttrText(itemtype => itemtype,
5235: itemkey => itemkey,
5236: aname => 'EXT_MESSAGE',
5237: avalue => l_exception);
5238: --

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

5241: if g_debug then
5242: hr_utility.set_location(l_proc, 130);
5243: end if;
5244: --
5245: IF upper(wf_engine.GetItemAttrText(itemtype => itemtype,
5246: itemkey => itemkey ,
5247: aname => 'APPR_REQ')) = 'YES' THEN
5248: --
5249: result := 'COMPLETE:Y';

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

5263: --
5264: hr_utility.trace('APPR_REQ attribute is : NO');
5265: --
5266: end if;
5267: wf_engine.SetItemAttrText(itemtype => itemtype,
5268: itemkey => itemkey,
5269: aname => 'APPROVAL_STATUS',
5270: avalue => 'APPROVED');
5271: --

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

5268: itemkey => itemkey,
5269: aname => 'APPROVAL_STATUS',
5270: avalue => 'APPROVED');
5271: --
5272: wf_engine.SetItemAttrText(itemtype => itemtype,
5273: itemkey => itemkey,
5274: aname => 'APR_REJ_REASON',
5275: avalue => 'AUTO_APPROVE');
5276:

Line 5388: l_app_bld_blk_id := wf_engine.GetItemAttrNumber

5384: if g_debug then
5385: hr_utility.set_location(l_proc, 10);
5386: end if;
5387: --
5388: l_app_bld_blk_id := wf_engine.GetItemAttrNumber
5389: (itemtype => itemtype,
5390: itemkey => itemkey ,
5391: aname => 'APP_BB_ID');
5392: --

Line 5397: l_app_ovn := wf_engine.GetItemAttrNumber

5393: if g_debug then
5394: hr_utility.set_location(l_proc, 20);
5395: end if;
5396: --
5397: l_app_ovn := wf_engine.GetItemAttrNumber
5398: (itemtype => itemtype,
5399: itemkey => itemkey ,
5400: aname => 'APP_BB_OVN');
5401: --

Line 5406: l_time_recipient := wf_engine.GetItemAttrText

5402: if g_debug then
5403: hr_utility.set_location(l_proc, 30);
5404: end if;
5405: --
5406: l_time_recipient := wf_engine.GetItemAttrText
5407: (itemtype => itemtype,
5408: itemkey => itemkey,
5409: aname => 'TIME_RECIPIENT_ID');
5410: --

Line 5422: l_tc_appr_style_id := wf_engine.GetItemAttrNumber

5418:
5419: hr_utility.set_location(l_proc, 70);
5420: --
5421: end if;
5422: l_tc_appr_style_id := wf_engine.GetItemAttrNumber
5423: (itemtype => itemtype,
5424: itemkey => itemkey,
5425: aname => 'APPROVAL_STYLE_ID');
5426: --

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

5450: --
5451: -- hr_utility.trace('Setting Status to Approved');
5452: --
5453: end if;
5454: -- wf_engine.SetItemAttrText(itemtype => itemtype,
5455: -- itemkey => itemkey,
5456: -- aname => 'APPROVAL_STATUS',
5457: -- avalue => 'APPROVED');
5458: --

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

5498: if g_debug then
5499: hr_utility.set_location(l_proc, 120);
5500: end if;
5501: --
5502: wf_engine.SetItemAttrText(itemtype => itemtype,
5503: itemkey => itemkey,
5504: aname => 'ALL_RULES',
5505: avalue => l_all_rules);
5506: --

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

5556: if g_debug then
5557: hr_utility.set_location(l_proc, 10);
5558: end if;
5559: --
5560: l_all_rules := wf_engine.GetItemAttrText(itemtype => itemtype,
5561: itemkey => itemkey ,
5562: aname => 'ALL_RULES');
5563: --
5564: if g_debug then

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

5595: if g_debug then
5596: hr_utility.trace('No More Rules - Setting status to APPROVED');
5597: end if;
5598: --
5599: wf_engine.SetItemAttrText(itemtype => itemtype,
5600: itemkey => itemkey,
5601: aname => 'APPROVAL_STATUS',
5602: avalue => 'APPROVED');
5603:

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

5601: aname => 'APPROVAL_STATUS',
5602: avalue => 'APPROVED');
5603:
5604:
5605: wf_engine.SetItemAttrText(itemtype => itemtype,
5606: itemkey => itemkey,
5607: aname => 'APR_REJ_REASON',
5608: avalue => 'AUTO_APPROVE');
5609: --OIT Enhancement.

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

5619: return;
5620: --
5621: END IF;
5622: --
5623: wf_engine.SetItemAttrText(itemtype => itemtype,
5624: itemkey => itemkey,
5625: aname => 'CURRENT_RULE',
5626: avalue => l_current_rule);
5627: --

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

5630: --
5631: hr_utility.trace('CURRENT_RULE is : ' || l_current_rule);
5632: --
5633: end if;
5634: wf_engine.SetItemAttrText(itemtype => itemtype,
5635: itemkey => itemkey,
5636: aname => 'ALL_RULES',
5637: avalue => l_all_rules);
5638: --

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

5846: end if;
5847: --
5848:
5849:
5850: l_current_rule := wf_engine.GetItemAttrText(itemtype => itemtype,
5851: itemkey => itemkey,
5852: aname => 'CURRENT_RULE');
5853: --
5854: if g_debug then

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

5854: if g_debug then
5855: hr_utility.set_location(l_proc, 20);
5856: end if;
5857: --
5858: l_app_start_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
5859: itemkey => itemkey,
5860: aname => 'APP_START_DATE');
5861: --
5862: if g_debug then

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

5862: if g_debug then
5863: hr_utility.set_location(l_proc, 25);
5864: end if;
5865: --
5866: l_app_end_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
5867: itemkey => itemkey,
5868: aname => 'APP_END_DATE');
5869: --
5870: if g_debug then

Line 5874: l_tc_resource_id := wf_engine.GetItemAttrNumber(

5870: if g_debug then
5871: hr_utility.set_location(l_proc, 30);
5872: end if;
5873: --
5874: l_tc_resource_id := wf_engine.GetItemAttrNumber(
5875: itemtype => itemtype,
5876: itemkey => itemkey,
5877: aname => 'RESOURCE_ID');
5878: --

Line 5883: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber

5879: if g_debug then
5880: hr_utility.set_location(l_proc, 40);
5881: end if;
5882: --
5883: l_tc_bld_blk_id := wf_engine.GetItemAttrNumber
5884: (itemtype => itemtype,
5885: itemkey => itemkey,
5886: aname => 'TC_BLD_BLK_ID');
5887: --

Line 5892: l_tc_ovn := wf_engine.GetItemAttrNumber

5888: if g_debug then
5889: hr_utility.trace('Timecard BB ID is : ' || to_char(l_tc_bld_blk_id));
5890: end if;
5891: --
5892: l_tc_ovn := wf_engine.GetItemAttrNumber
5893: (itemtype => itemtype,
5894: itemkey => itemkey,
5895: aname => 'TC_BLD_BLK_OVN');
5896: --

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

5900: --
5901: -- Set up l_resubmit to indicate whether this is a resubmission or not.
5902: -- (YES means it is a resubmission; NO means it is a submission).
5903: --
5904: l_resubmit := wf_engine.GetItemAttrText(itemtype => itemtype,
5905: itemkey => itemkey,
5906: aname => 'TC_RESUBMITTED');
5907: --
5908: if g_debug then

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

5908: if g_debug then
5909: hr_utility.set_location(l_proc, 50);
5910: end if;
5911: --
5912: l_bb_new := wf_engine.GetItemAttrText(itemtype => itemtype,
5913: itemkey => itemkey,
5914: aname => 'BB_NEW');
5915: --
5916: if g_debug then

Line 5966: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(

5962: --
5963: if g_debug then
5964: hr_utility.set_location(l_proc, 90);
5965: end if;
5966: l_appl_period_bb_id := wf_engine.GetItemAttrNumber(
5967: itemtype => itemtype,
5968: itemkey => itemkey,
5969: aname => 'APP_BB_ID');
5970:

Line 5974: l_appl_period_bb_ovn := wf_engine.GetItemAttrNumber(

5970:
5971: if g_debug then
5972: hr_utility.trace('APP_BB_ID is : ' || to_char(l_appl_period_bb_id));
5973: end if;
5974: l_appl_period_bb_ovn := wf_engine.GetItemAttrNumber(
5975: itemtype => itemtype,
5976: itemkey => itemkey,
5977: aname => 'APP_BB_OVN');
5978:

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

5977: aname => 'APP_BB_OVN');
5978:
5979: IF NOT was_approved(l_appl_period_bb_id, l_appl_period_bb_ovn)
5980: THEN
5981: wf_engine.SetItemAttrText(itemtype => itemtype,
5982: itemkey => itemkey,
5983: aname => 'TO_APPROVE',
5984: avalue => 'YES');
5985:

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

6140: hr_utility.set_message(809, l_error_table(1).message_name);
6141: hr_utility.raise_error;
6142: END IF;
6143: --
6144: wf_engine.SetItemAttrText(itemtype => itemtype,
6145: itemkey => itemkey,
6146: aname => 'TO_APPROVE',
6147: avalue => upper(l_result));
6148: --

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

6157: if g_debug then
6158: hr_utility.set_location(l_proc, 230);
6159: end if;
6160: --
6161: wf_engine.SetItemAttrText(itemtype => itemtype,
6162: itemkey => itemkey,
6163: aname => 'TO_APPROVE',
6164: avalue => l_changed);
6165: --

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

6178: end if;
6179: --
6180: -- Modifying the 'TO_APPROVE' value from 'NO' to 'YES' and Commenting out the following code for bug#3497011.
6181:
6182: /* wf_engine.SetItemAttrText(itemtype => itemtype,
6183: itemkey => itemkey,
6184: aname => 'TO_APPROVE',
6185: avalue => 'NO');
6186: --

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

6187: if g_debug then
6188: hr_utility.trace('TO_APPROVE is : NO');
6189: end if; */
6190:
6191: wf_engine.SetItemAttrText(itemtype => itemtype,
6192: itemkey => itemkey,
6193: aname => 'TO_APPROVE',
6194: avalue => 'YES');
6195: --

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

6248: if g_debug then
6249: hr_utility.set_location(l_proc, 10);
6250: end if;
6251: --
6252: l_to_approve := wf_engine.GetItemAttrText(itemtype => itemtype,
6253: itemkey => itemkey ,
6254: aname => 'TO_APPROVE');
6255: --
6256: if g_debug then

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

6346: l_approval_mechansim varchar2(20);
6347:
6348: begin
6349:
6350: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,
6351: itemkey => itemkey ,
6352: aname => 'IS_DIFF_TC',
6353: ignore_notfound => true
6354: );

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

6352: aname => 'IS_DIFF_TC',
6353: ignore_notfound => true
6354: );
6355:
6356: l_app_bb_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6357: itemkey => itemkey ,
6358: aname => 'APP_BB_ID');
6359:
6360: hr_utility.trace('is_different_time_category l_is_blank ::'||l_is_blank);

Line 6368: wf_engine.SetItemAttrNumber(

6364: if l_is_blank = 'Y' then
6365:
6366: l_total_hours:= HXC_FIND_NOTIFY_APRS_PKG.category_timecard_hrs(l_app_bb_id,'');
6367:
6368: wf_engine.SetItemAttrNumber(
6369: itemtype => itemtype,
6370: itemkey => itemkey,
6371: aname => 'TOTAL_TC_HOURS',
6372: avalue => l_total_hours);