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.AMS_SCHEDULERULES_PVT dependencies on WF_ENGINE

Line 3388: l_schedule_id := WF_ENGINE.GetItemAttrText(

3384: l_return_status VARCHAR2(1);
3385: l_schedule_id NUMBER ;
3386: BEGIN
3387:
3388: l_schedule_id := WF_ENGINE.GetItemAttrText(
3389: itemtype => p_itemtype,
3390: itemkey => p_itemkey ,
3391: aname => 'SCHEDULE_ID');
3392:

Line 3412: WF_ENGINE.SetItemAttrText(itemtype => p_itemtype,

3408: l_cnt := l_cnt + 1 ;
3409:
3410: END LOOP ;
3411:
3412: WF_ENGINE.SetItemAttrText(itemtype => p_itemtype,
3413: itemkey => p_itemkey ,
3414: aname => 'ERROR_MESSAGE',
3415: avalue => l_final_data );
3416:

Line 3465: l_schedule_id := WF_ENGINE.GetItemAttrText(

3461: BEGIN
3462: IF (funcmode = 'RUN')
3463: THEN
3464:
3465: l_schedule_id := WF_ENGINE.GetItemAttrText(
3466: itemtype => itemtype,
3467: itemkey => itemkey ,
3468: aname => 'SCHEDULE_ID');
3469:

Line 3498: Wf_Engine.SetItemOwner(itemtype => itemtype,

3494: p_name => l_user_name,
3495: p_display_name => l_display_name );
3496:
3497: IF l_user_name IS NOT NULL THEN
3498: Wf_Engine.SetItemOwner(itemtype => itemtype,
3499: itemkey => itemkey,
3500: owner => l_user_name);
3501: END IF;
3502: END IF;

Line 3505: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3501: END IF;
3502: END IF;
3503: CLOSE c_emp_dtl;
3504:
3505: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3506: itemkey => itemkey,
3507: aname => 'SCHEDULE_NAME',
3508: avalue => l_schedule_rec.schedule_name);
3509:

Line 3510: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

3506: itemkey => itemkey,
3507: aname => 'SCHEDULE_NAME',
3508: avalue => l_schedule_rec.schedule_name);
3509:
3510: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
3511: itemkey => itemkey ,
3512: userkey => l_schedule_rec.schedule_name);
3513:
3514: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 3514: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3510: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
3511: itemkey => itemkey ,
3512: userkey => l_schedule_rec.schedule_name);
3513:
3514: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3515: itemkey => itemkey,
3516: aname => 'SCHEDULE_OWNER',
3517: avalue => l_user_name);
3518:

Line 3519: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3515: itemkey => itemkey,
3516: aname => 'SCHEDULE_OWNER',
3517: avalue => l_user_name);
3518:
3519: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3520: itemkey => itemkey,
3521: aname => 'WF_ADMINISTRATOR',
3522: avalue => l_user_name);
3523:

Line 3524: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3520: itemkey => itemkey,
3521: aname => 'WF_ADMINISTRATOR',
3522: avalue => l_user_name);
3523:
3524: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3525: itemkey => itemkey,
3526: aname => 'SCHEDULE_STATUS',
3527: avalue => l_schedule_rec.status_code);
3528:

Line 3529: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3525: itemkey => itemkey,
3526: aname => 'SCHEDULE_STATUS',
3527: avalue => l_schedule_rec.status_code);
3528:
3529: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3530: itemkey => itemkey,
3531: aname => 'SCHEDULE_CHANNEL',
3532: avalue => l_schedule_rec.activity_id );
3533:

Line 3534: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3530: itemkey => itemkey,
3531: aname => 'SCHEDULE_CHANNEL',
3532: avalue => l_schedule_rec.activity_id );
3533:
3534: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3535: itemkey => itemkey,
3536: aname => 'ACTIVITY_TYPE',
3537: avalue => l_schedule_rec.activity_type );
3538:

Line 3539: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3535: itemkey => itemkey,
3536: aname => 'ACTIVITY_TYPE',
3537: avalue => l_schedule_rec.activity_type );
3538:
3539: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3540: itemkey => itemkey,
3541: aname => 'ERROR_FLAG',
3542: avalue => 'N');
3543: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 3543: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3539: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3540: itemkey => itemkey,
3541: aname => 'ERROR_FLAG',
3542: avalue => 'N');
3543: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3544: itemkey => itemkey,
3545: aname => 'AMS_SCHEDULE_START_DATE',
3546: avalue => l_schedule_rec.start_date_time );
3547:

Line 3548: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3544: itemkey => itemkey,
3545: aname => 'AMS_SCHEDULE_START_DATE',
3546: avalue => l_schedule_rec.start_date_time );
3547:
3548: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3549: itemkey => itemkey,
3550: aname => 'AMS_SCHEDULE_END_DATE',
3551: avalue => l_schedule_rec.end_date_time );
3552:

Line 3612: l_schedule_id := WF_ENGINE.GetItemAttrText(

3608: l_user_id := FND_GLOBAL.USER_ID;
3609: l_resp_id := FND_GLOBAL.RESP_ID;
3610: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3611:
3612: l_schedule_id := WF_ENGINE.GetItemAttrText(
3613: itemtype => p_itemtype,
3614: itemkey => p_itemkey ,
3615: aname => 'SCHEDULE_ID');
3616:

Line 3660: l_schedule_id := WF_ENGINE.GetItemAttrText(

3656: -- based on the work item context stored in item attributes
3657: -- get Item Attributes for user_id, responsibility_id and application_id
3658: -- this assumes that they were set as item attribute, probably through
3659: -- definition.
3660: l_schedule_id := WF_ENGINE.GetItemAttrText(
3661: itemtype => p_itemtype,
3662: itemkey => p_itemkey ,
3663: aname => 'SCHEDULE_ID');
3664:

Line 3722: l_schedule_id := WF_ENGINE.GetItemAttrText(

3718: -- dbms_output.put_line('Process Check_Repeat');
3719: -- RUN mode - Normal Process Execution
3720: IF (funcmode = 'RUN')
3721: THEN
3722: l_schedule_id := WF_ENGINE.GetItemAttrText(
3723: itemtype => itemtype,
3724: itemkey => itemkey ,
3725: aname => 'SCHEDULE_ID' );
3726:

Line 3735: l_schedule_status := WF_ENGINE.GetItemAttrText(

3731: p_msg_data => 'Check_Schedule_Status : started',
3732: p_msg_type => 'DEBUG'
3733: );
3734:
3735: l_schedule_status := WF_ENGINE.GetItemAttrText(
3736: itemtype => itemtype,
3737: itemkey => itemkey ,
3738: aname => 'SCHEDULE_STATUS' );
3739:

Line 3811: l_schedule_id := WF_ENGINE.GetItemAttrText(

3807: -- dbms_output.put_line('Process Check_Repeat');
3808: -- RUN mode - Normal Process Execution
3809: IF (funcmode = 'RUN')
3810: THEN
3811: l_schedule_id := WF_ENGINE.GetItemAttrText(
3812: itemtype => itemtype,
3813: itemkey => itemkey ,
3814: aname => 'SCHEDULE_ID' );
3815:

Line 3894: l_schedule_id := WF_ENGINE.GetItemAttrText(

3890: -- dbms_output.put_line('Process Check_Repeat');
3891: -- RUN mode - Normal Process Execution
3892: IF (funcmode = 'RUN')
3893: THEN
3894: l_schedule_id := WF_ENGINE.GetItemAttrText(
3895: itemtype => itemtype,
3896: itemkey => itemkey ,
3897: aname => 'SCHEDULE_ID' );
3898:

Line 3907: l_schedule_activity := WF_ENGINE.GetItemAttrText(

3903: p_msg_data => 'Check_Schedule_Act_Type : started',
3904: p_msg_type => 'DEBUG'
3905: );
3906:
3907: l_schedule_activity := WF_ENGINE.GetItemAttrText(
3908: itemtype => itemtype,
3909: itemkey => itemkey ,
3910: aname => 'ACTIVITY_TYPE' );
3911:

Line 4025: l_schedule_id := WF_ENGINE.GetItemAttrText(

4021: -- RUN mode - Normal Process Execution
4022: IF (funcmode = 'RUN')
4023: THEN
4024: -- get schedule id
4025: l_schedule_id := WF_ENGINE.GetItemAttrText(
4026: itemtype => itemtype,
4027: itemkey => itemkey ,
4028: aname => 'SCHEDULE_ID' );
4029:

Line 4040: l_activity_id := WF_ENGINE.GetItemAttrText(

4036: );
4037:
4038:
4039: -- get schedule activity
4040: l_activity_id := WF_ENGINE.GetItemAttrText(
4041: itemtype => itemtype,
4042: itemkey => itemkey ,
4043: aname => 'SCHEDULE_CHANNEL' );
4044: --

Line 4078: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4074: p_list_header_id => l_list_id -- target group id
4075: );
4076:
4077: IF l_return_status <> FND_API.g_ret_sts_success THEN
4078: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4079: itemkey => itemkey,
4080: aname => 'ERROR_FLAG',
4081: avalue => 'Y');
4082: Handle_Error(p_itemtype => itemtype,

Line 4117: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4113: x_msg_data => l_msg_data
4114: );
4115:
4116: IF l_return_status <> FND_API.g_ret_sts_success THEN
4117: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4118: itemkey => itemkey,
4119: aname => 'ERROR_FLAG',
4120: avalue => 'Y');
4121: Handle_Error(p_itemtype => itemtype,

Line 4129: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4125: RETURN;
4126: END IF;
4127:
4128: /*
4129: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4130: itemkey => itemkey,
4131: aname => 'ERROR_FLAG',
4132: avalue => 'Y');
4133: Handle_Error(p_itemtype => itemtype,

Line 4209: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4205: p_msg_type => 'DEBUG'
4206: );
4207:
4208: IF l_return_status <> FND_API.g_ret_sts_success THEN
4209: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4210: itemkey => itemkey,
4211: aname => 'ERROR_FLAG',
4212: avalue => 'Y');
4213: Handle_Error(p_itemtype => itemtype,

Line 4251: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4247: p_msg_type => 'DEBUG'
4248: );
4249:
4250: IF l_return_status <> FND_API.g_ret_sts_success THEN
4251: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4252: itemkey => itemkey,
4253: aname => 'ERROR_FLAG',
4254: avalue => 'Y');
4255: Handle_Error(p_itemtype => itemtype,

Line 4285: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4281: p_msg_data => 'Execute_Direct_Marketing : Target Group is empty',
4282: p_msg_type => 'DEBUG'
4283: );
4284:
4285: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4286: itemkey => itemkey,
4287: aname => 'ERROR_FLAG',
4288: avalue => 'Y');
4289:

Line 4297: WF_ENGINE.SetItemAttrText(itemtype => itemtype, -- 29-apr-2004 anchaudh : fixed the reopened bug#3553087

4293: p_msg_data => l_msg_data);*/
4294:
4295: l_error_msg := FND_MESSAGE.get_string('AMS','AMS_CSCH_NO_TARGET_GROUP');
4296:
4297: WF_ENGINE.SetItemAttrText(itemtype => itemtype, -- 29-apr-2004 anchaudh : fixed the reopened bug#3553087
4298: itemkey => itemkey,
4299: aname => 'ERROR_MESSAGE',
4300: avalue => l_error_msg);
4301:

Line 4357: l_schedule_id := WF_ENGINE.GetItemAttrText(

4353: BEGIN
4354: -- RUN mode - Normal Process Execution
4355: IF (funcmode = 'RUN')
4356: THEN
4357: l_schedule_id := WF_ENGINE.GetItemAttrText(
4358: itemtype => itemtype,
4359: itemkey => itemkey ,
4360: aname => 'SCHEDULE_ID' );
4361:

Line 4387: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4383: p_msg_type => 'DEBUG'
4384: );
4385:
4386: IF l_return_status <> FND_API.g_ret_sts_success THEN
4387: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4388: itemkey => itemkey,
4389: aname => 'ERROR_FLAG',
4390: avalue => 'Y');
4391: Handle_Error(p_itemtype => itemtype,

Line 4612: l_asn_group_id := WF_ENGINE.GetItemAttrText(

4608: CLOSE c_sch_det;
4609:
4610: if(l_triggerable_flag = 'N' and l_trig_repeat_flag = 'N' and l_orig_csch_id IS NULL) then -- anchaudh added for the leads bug.
4611:
4612: l_asn_group_id := WF_ENGINE.GetItemAttrText(
4613: itemtype => itemtype,
4614: itemkey => itemkey ,
4615: aname => 'ASN_GROUP_ID');--anchaudh added for the leads bug.
4616:

Line 4619: l_asn_resource_id := WF_ENGINE.GetItemAttrText(

4615: aname => 'ASN_GROUP_ID');--anchaudh added for the leads bug.
4616:
4617: --insert_log_mesg('Anirban inside generate_leads api, value of l_asn_group_id retrieved is :'||l_asn_group_id);
4618:
4619: l_asn_resource_id := WF_ENGINE.GetItemAttrText(
4620: itemtype => itemtype,
4621: itemkey => itemkey ,
4622: aname => 'ASN_RESOURCE_ID');--anchaudh added for the leads bug.
4623: --insert_log_mesg('Anirban inside generate_leads api, value of l_asn_resource_id retrieved is :'||l_asn_resource_id);

Line 4910: l_schedule_id := WF_ENGINE.GetItemAttrText(

4906: -- dbms_output.put_line('Process Check_Repeat');
4907: -- RUN mode - Normal Process Execution
4908: IF (funcmode = 'RUN')
4909: THEN
4910: l_schedule_id := WF_ENGINE.GetItemAttrText(
4911: itemtype => itemtype,
4912: itemkey => itemkey ,
4913: aname => 'SCHEDULE_ID' );
4914:

Line 4923: l_error_flag := WF_ENGINE.GetItemAttrText(

4919: p_msg_data => 'Check_WF_Error : started',
4920: p_msg_type => 'DEBUG'
4921: );
4922:
4923: l_error_flag := WF_ENGINE.GetItemAttrText(
4924: itemtype => itemtype,
4925: itemkey => itemkey ,
4926: aname => 'ERROR_FLAG' );
4927:

Line 5071: l_schedule_id := WF_ENGINE.GetItemAttrText(

5067: l_api_name := 'Wf_Repeat_Init_var';
5068: IF (funcmode = 'RUN')
5069: THEN
5070:
5071: l_schedule_id := WF_ENGINE.GetItemAttrText(
5072: itemtype => itemtype,
5073: itemkey => itemkey ,
5074: aname => 'SCHEDULE_ID');
5075:

Line 5078: l_temp_varaibale := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

5074: aname => 'SCHEDULE_ID');
5075:
5076:
5077:
5078: l_temp_varaibale := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
5079: itemkey => itemkey ,
5080: aname => 'AMS_PARENT_STATUS'
5081: );
5082:

Line 5097: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

5093: ||l_temp_varaibale);
5094:
5095:
5096:
5097: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
5098: itemkey => itemkey,
5099: aname => 'AMS_SCHEDULE_ID',
5100: avalue => l_schedule_id);
5101:

Line 5139: Wf_Engine.SetItemOwner(itemtype => itemtype,

5135: p_name => l_user_name,
5136: p_display_name => l_display_name );
5137:
5138: IF l_user_name IS NOT NULL THEN
5139: Wf_Engine.SetItemOwner(itemtype => itemtype,
5140: itemkey => itemkey,
5141: owner => l_user_name);
5142: END IF;
5143: END IF;

Line 5146: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5142: END IF;
5143: END IF;
5144: CLOSE c_emp_dtl;
5145:
5146: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5147: itemkey => itemkey,
5148: aname => 'SCHEDULE_NAME',
5149: avalue => l_schedule_name);
5150:

Line 5151: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

5147: itemkey => itemkey,
5148: aname => 'SCHEDULE_NAME',
5149: avalue => l_schedule_name);
5150:
5151: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
5152: itemkey => itemkey ,
5153: userkey => l_schedule_name);
5154:
5155: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

Line 5155: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5151: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
5152: itemkey => itemkey ,
5153: userkey => l_schedule_name);
5154:
5155: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5156: itemkey => itemkey,
5157: aname => 'AMS_SCHEDULE_START_DATE',
5158: avalue => to_date(l_csch_st_date,'DD-MM-RRRR HH24:MI:SS') );
5159:

Line 5160: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5156: itemkey => itemkey,
5157: aname => 'AMS_SCHEDULE_START_DATE',
5158: avalue => to_date(l_csch_st_date,'DD-MM-RRRR HH24:MI:SS') );
5159:
5160: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5161: itemkey => itemkey,
5162: aname => 'AMS_SCHEDULE_END_DATE',
5163: avalue => to_date(l_csch_en_date,'DD-MM-RRRR HH24:MI:SS') );
5164:

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

5161: itemkey => itemkey,
5162: aname => 'AMS_SCHEDULE_END_DATE',
5163: avalue => to_date(l_csch_en_date,'DD-MM-RRRR HH24:MI:SS') );
5164:
5165: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5166: itemkey => itemkey,
5167: aname => 'SCHEDULE_STATUS',
5168: avalue => l_csch_status);
5169:

Line 5170: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5166: itemkey => itemkey,
5167: aname => 'SCHEDULE_STATUS',
5168: avalue => l_csch_status);
5169:
5170: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5171: itemkey => itemkey,
5172: aname => 'SCHEDULE_OWNER',
5173: avalue => l_user_name);
5174:

Line 5175: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5171: itemkey => itemkey,
5172: aname => 'SCHEDULE_OWNER',
5173: avalue => l_user_name);
5174:
5175: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5176: itemkey => itemkey,
5177: aname => 'SCHEDULE_CHANNEL',
5178: avalue => l_csch_act_id);
5179:

Line 5180: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5176: itemkey => itemkey,
5177: aname => 'SCHEDULE_CHANNEL',
5178: avalue => l_csch_act_id);
5179:
5180: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5181: itemkey => itemkey,
5182: aname => 'ACTIVITY_TYPE',
5183: avalue => l_csch_act_code);
5184:

Line 5185: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

5181: itemkey => itemkey,
5182: aname => 'ACTIVITY_TYPE',
5183: avalue => l_csch_act_code);
5184:
5185: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
5186: itemkey => itemkey,
5187: aname => 'AMS_ORIG_SCHEDULE_ID',
5188: avalue => l_csch_orig_id);
5189:

Line 5190: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

5186: itemkey => itemkey,
5187: aname => 'AMS_ORIG_SCHEDULE_ID',
5188: avalue => l_csch_orig_id);
5189:
5190: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
5191: itemkey => itemkey,
5192: aname => 'AMS_SCHEDULER_FREQUENCY',
5193: avalue => l_sched_freq);
5194:

Line 5195: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5191: itemkey => itemkey,
5192: aname => 'AMS_SCHEDULER_FREQUENCY',
5193: avalue => l_sched_freq);
5194:
5195: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5196: itemkey => itemkey,
5197: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE',
5198: avalue => l_sched_freq_type);
5199:

Line 5200: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5196: itemkey => itemkey,
5197: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE',
5198: avalue => l_sched_freq_type);
5199:
5200: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5201: itemkey => itemkey,
5202: aname => 'AMS_CAMPAIGN_START_DATE',
5203: avalue => to_date(l_camp_st_date,'DD-MM-RRRR HH24:MI:SS') );
5204:

Line 5205: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5201: itemkey => itemkey,
5202: aname => 'AMS_CAMPAIGN_START_DATE',
5203: avalue => to_date(l_camp_st_date,'DD-MM-RRRR HH24:MI:SS') );
5204:
5205: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5206: itemkey => itemkey,
5207: aname => 'AMS_CAMPAIGN_END_DATE',
5208: avalue => to_date(l_camp_en_date,'DD-MM-RRRR HH24:MI:SS') );
5209:

Line 5210: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5206: itemkey => itemkey,
5207: aname => 'AMS_CAMPAIGN_END_DATE',
5208: avalue => to_date(l_camp_en_date,'DD-MM-RRRR HH24:MI:SS') );
5209:
5210: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5211: itemkey => itemkey,
5212: aname => 'AMS_PARENT_START_DATE',
5213: avalue => to_date(l_parent_st_date,'DD-MM-RRRR HH24:MI:SS') );
5214:

Line 5215: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5211: itemkey => itemkey,
5212: aname => 'AMS_PARENT_START_DATE',
5213: avalue => to_date(l_parent_st_date,'DD-MM-RRRR HH24:MI:SS') );
5214:
5215: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5216: itemkey => itemkey,
5217: aname => 'AMS_PARENT_END_DATE',
5218: avalue => to_date(l_parent_en_date,'DD-MM-RRRR HH24:MI:SS') );
5219:

Line 5220: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5216: itemkey => itemkey,
5217: aname => 'AMS_PARENT_END_DATE',
5218: avalue => to_date(l_parent_en_date,'DD-MM-RRRR HH24:MI:SS') );
5219:
5220: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5221: itemkey => itemkey,
5222: aname => 'AMS_PARENT_STATUS',
5223: avalue => l_parent_status);
5224:

Line 5226: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5222: aname => 'AMS_PARENT_STATUS',
5223: avalue => l_parent_status);
5224:
5225:
5226: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5227: itemkey => itemkey ,
5228: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',
5229: avalue => l_schedule_next_run_st_date);
5230:

Line 5288: l_schedule_id := WF_ENGINE.GetItemAttrText(

5284:
5285: BEGIN
5286: l_api_name := 'WF_REPEAT_CHECK_EXECUTE';
5287:
5288: l_schedule_id := WF_ENGINE.GetItemAttrText(
5289: itemtype => itemtype,
5290: itemkey => itemkey ,
5291: aname => 'SCHEDULE_ID');
5292:

Line 5303: l_sched_status := WF_ENGINE.GetItemAttrText(

5299: IF (funcmode = 'RUN')
5300: THEN
5301: WRITE_LOG(l_api_name, 'Wf_Repeat_Check_Execute: Schedule id is '||l_schedule_id);
5302:
5303: l_sched_status := WF_ENGINE.GetItemAttrText(
5304: itemtype => itemtype,
5305: itemkey => itemkey ,
5306: aname => 'SCHEDULE_STATUS');
5307:

Line 5308: l_sched_end_date := WF_ENGINE.GetItemAttrDate(

5304: itemtype => itemtype,
5305: itemkey => itemkey ,
5306: aname => 'SCHEDULE_STATUS');
5307:
5308: l_sched_end_date := WF_ENGINE.GetItemAttrDate(
5309: itemtype => itemtype,
5310: itemkey => itemkey ,
5311: aname => 'AMS_SCHEDULE_END_DATE');
5312:

Line 5313: l_orig_csch_status := WF_ENGINE.GetItemAttrText(

5309: itemtype => itemtype,
5310: itemkey => itemkey ,
5311: aname => 'AMS_SCHEDULE_END_DATE');
5312:
5313: l_orig_csch_status := WF_ENGINE.GetItemAttrText(
5314: itemtype => itemtype,
5315: itemkey => itemkey ,
5316: aname => 'AMS_PARENT_STATUS');
5317:

Line 5318: l_orig_csch_end_date := WF_ENGINE.GetItemAttrDate(

5314: itemtype => itemtype,
5315: itemkey => itemkey ,
5316: aname => 'AMS_PARENT_STATUS');
5317:
5318: l_orig_csch_end_date := WF_ENGINE.GetItemAttrDate(
5319: itemtype => itemtype,
5320: itemkey => itemkey ,
5321: aname => 'AMS_PARENT_END_DATE');
5322:

Line 5324: l_camp_end_date := WF_ENGINE.GetItemAttrDate(

5320: itemkey => itemkey ,
5321: aname => 'AMS_PARENT_END_DATE');
5322:
5323:
5324: l_camp_end_date := WF_ENGINE.GetItemAttrDate(
5325: itemtype => itemtype,
5326: itemkey => itemkey ,
5327: aname => 'AMS_CAMPAIGN_END_DATE');
5328:

Line 5412: l_schedule_id := WF_ENGINE.GetItemAttrText(

5408: l_api_name := 'WF_REPEAT_SCHEDULER';
5409: IF (funcmode = 'RUN')
5410: THEN
5411:
5412: l_schedule_id := WF_ENGINE.GetItemAttrText(
5413: itemtype => itemtype,
5414: itemkey => itemkey ,
5415: aname => 'SCHEDULE_ID');
5416: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule id ' ||l_schedule_id);

Line 5418: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(

5414: itemkey => itemkey ,
5415: aname => 'SCHEDULE_ID');
5416: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule id ' ||l_schedule_id);
5417:
5418: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(
5419: itemtype => itemtype,
5420: itemkey => itemkey ,
5421: aname => 'AMS_SCHEDULER_FREQUENCY');
5422:

Line 5423: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(

5419: itemtype => itemtype,
5420: itemkey => itemkey ,
5421: aname => 'AMS_SCHEDULER_FREQUENCY');
5422:
5423: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5424: itemtype => itemtype,
5425: itemkey => itemkey ,
5426: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5427:

Line 5431: l_new_last_run_date := WF_ENGINE.GetItemAttrDate(

5427:
5428: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type);
5429:
5430:
5431: l_new_last_run_date := WF_ENGINE.GetItemAttrDate(
5432: itemtype => itemtype,
5433: itemkey => itemkey ,
5434: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5435:

Line 5452: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule_Repeat returned last run date from the WF Engine : '||to_char(l_new_last_run_date,'DD-MON-RRRR HH24:MI:SS')||'; For Schedule Id: '||l_schedule_id);

5448: END IF;
5449:
5450:
5451:
5452: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule_Repeat returned last run date from the WF Engine : '||to_char(l_new_last_run_date,'DD-MON-RRRR HH24:MI:SS')||'; For Schedule Id: '||l_schedule_id);
5453:
5454:
5455: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type||'; For Schedule Id: '||l_schedule_id);
5456:

Line 5473: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5469: THEN
5470: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule_Repeat returned success for next run date for schedule id: '||l_schedule_id);
5471: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule_Repeat returned next run date is : '||to_char(l_scheduler_next_run_date,'DD-MON-RRRR HH24:MI:SS')||' Schedule Id is : '||l_schedule_id);
5472:
5473: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5474: itemkey => itemkey ,
5475: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',
5476: avalue => l_scheduler_next_run_date);
5477:

Line 5481: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5477:
5478: result := 'COMPLETE:SUCCESS' ;
5479: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
5480: THEN
5481: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5482: itemkey => itemkey,
5483: aname => 'ERROR_FLAG',
5484: avalue => 'Y');
5485: Handle_Error(p_itemtype => itemtype,

Line 5544: l_schedule_id := WF_ENGINE.GetItemAttrText(

5540: l_api_name := 'WF_REPEAT_CHECK_CREATE_CSCH';
5541: IF (funcmode = 'RUN')
5542: THEN
5543:
5544: l_schedule_id := WF_ENGINE.GetItemAttrText(
5545: itemtype => itemtype,
5546: itemkey => itemkey ,
5547: aname => 'SCHEDULE_ID');
5548: WRITE_LOG(l_api_name, 'WF_REPEAT_CHECK_CREATE_CSCH: Started for schedule id ' ||l_schedule_id);

Line 5550: l_schedule_next_run_date := WF_ENGINE.GetItemAttrDate(

5546: itemkey => itemkey ,
5547: aname => 'SCHEDULE_ID');
5548: WRITE_LOG(l_api_name, 'WF_REPEAT_CHECK_CREATE_CSCH: Started for schedule id ' ||l_schedule_id);
5549:
5550: l_schedule_next_run_date := WF_ENGINE.GetItemAttrDate(
5551: itemtype => itemtype,
5552: itemkey => itemkey ,
5553: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5554:

Line 5555: l_parent_end_date := WF_ENGINE.GetItemAttrDate(

5551: itemtype => itemtype,
5552: itemkey => itemkey ,
5553: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5554:
5555: l_parent_end_date := WF_ENGINE.GetItemAttrDate(
5556: itemtype => itemtype,
5557: itemkey => itemkey ,
5558: aname => 'AMS_PARENT_END_DATE');
5559:

Line 5560: l_campaign_end_date := WF_ENGINE.GetItemAttrDate(

5556: itemtype => itemtype,
5557: itemkey => itemkey ,
5558: aname => 'AMS_PARENT_END_DATE');
5559:
5560: l_campaign_end_date := WF_ENGINE.GetItemAttrDate(
5561: itemtype => itemtype,
5562: itemkey => itemkey ,
5563: aname => 'AMS_CAMPAIGN_END_DATE');
5564:

Line 5632: l_schedule_id := WF_ENGINE.GetItemAttrText(

5628: -- WHERE schedule_id = p_schedule_id;
5629:
5630: BEGIN
5631: l_api_name := 'WF_REPEAT_CREATE_CSCH';
5632: l_schedule_id := WF_ENGINE.GetItemAttrText(
5633: itemtype => itemtype,
5634: itemkey => itemkey ,
5635: aname => 'SCHEDULE_ID');
5636:

Line 5641: l_parent_sched_id := WF_ENGINE.GetItemAttrNumber(

5637: IF (funcmode = 'RUN')
5638: THEN
5639: WRITE_LOG(l_api_name, 'WF_REPEAT_CREATE_CSCH: Schedule id is '||l_schedule_id);
5640:
5641: l_parent_sched_id := WF_ENGINE.GetItemAttrNumber(
5642: itemtype => itemtype,
5643: itemkey => itemkey ,
5644: aname => 'AMS_ORIG_SCHEDULE_ID');
5645:

Line 5646: l_campaign_end_date := WF_ENGINE.GetItemAttrDate(

5642: itemtype => itemtype,
5643: itemkey => itemkey ,
5644: aname => 'AMS_ORIG_SCHEDULE_ID');
5645:
5646: l_campaign_end_date := WF_ENGINE.GetItemAttrDate(
5647: itemtype => itemtype,
5648: itemkey => itemkey ,
5649: aname => 'AMS_CAMPAIGN_END_DATE');
5650:

Line 5651: l_parent_end_date := WF_ENGINE.GetItemAttrDate(

5647: itemtype => itemtype,
5648: itemkey => itemkey ,
5649: aname => 'AMS_CAMPAIGN_END_DATE');
5650:
5651: l_parent_end_date := WF_ENGINE.GetItemAttrDate(
5652: itemtype => itemtype,
5653: itemkey => itemkey ,
5654: aname => 'AMS_PARENT_END_DATE');
5655:

Line 5656: l_schedule_start_date := WF_ENGINE.GetItemAttrDate(

5652: itemtype => itemtype,
5653: itemkey => itemkey ,
5654: aname => 'AMS_PARENT_END_DATE');
5655:
5656: l_schedule_start_date := WF_ENGINE.GetItemAttrDate(
5657: itemtype => itemtype,
5658: itemkey => itemkey ,
5659: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5660:

Line 5661: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(

5657: itemtype => itemtype,
5658: itemkey => itemkey ,
5659: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5660:
5661: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(
5662: itemtype => itemtype,
5663: itemkey => itemkey ,
5664: aname => 'AMS_SCHEDULER_FREQUENCY');
5665:

Line 5666: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(

5662: itemtype => itemtype,
5663: itemkey => itemkey ,
5664: aname => 'AMS_SCHEDULER_FREQUENCY');
5665:
5666: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5667: itemtype => itemtype,
5668: itemkey => itemkey ,
5669: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5670:

Line 5694: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5690: x_msg_data => l_msg_data);
5691:
5692: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)
5693: THEN
5694: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5695: itemkey => itemkey,
5696: aname => 'ERROR_FLAG',
5697: avalue => 'Y');
5698: Handle_Error(p_itemtype => itemtype,

Line 5739: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5735: IF l_return_status = FND_API.G_RET_STS_SUCCESS
5736: THEN
5737: WRITE_LOG(l_api_name, 'WF_REPEAT_CREATE_CSCH: Create next schedule returned Success ');
5738:
5739: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5740: itemkey => itemkey,
5741: aname => 'AMS_NEW_SCHEDULE_ID',
5742: avalue => l_child_sched_id);
5743:

Line 5747: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5743:
5744: result := 'COMPLETE:SUCCESS' ;
5745: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
5746: THEN
5747: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5748: itemkey => itemkey,
5749: aname => 'ERROR_FLAG',
5750: avalue => 'Y');
5751: Handle_Error(p_itemtype => itemtype,

Line 5809: l_schedule_id := WF_ENGINE.GetItemAttrText(

5805: BEGIN
5806: l_api_name := 'WF_REPEAT_RAISE_EVENT';
5807: IF (funcmode = 'RUN')
5808: THEN
5809: l_schedule_id := WF_ENGINE.GetItemAttrText(
5810: itemtype => itemtype,
5811: itemkey => itemkey ,
5812: aname => 'AMS_NEW_SCHEDULE_ID');
5813:

Line 5820: l_schedule_next_run_st_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype,

5816: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
5817: p_value => l_schedule_id,
5818: p_parameterlist => l_parameter_list);
5819:
5820: l_schedule_next_run_st_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype,
5821: itemkey => itemkey ,
5822: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE'
5823: );
5824:

Line 6165: l_schedule_id := to_number(WF_ENGINE.GetItemAttrText(

6161:
6162: -- RUN mode - Normal Process Execution
6163: IF (funcmode = 'RUN')
6164: THEN
6165: l_schedule_id := to_number(WF_ENGINE.GetItemAttrText(
6166: itemtype => itemtype,
6167: itemkey => itemkey ,
6168: aname => 'SCHEDULE_ID' ));
6169:

Line 6205: l_scheduler_frequency := to_number(WF_ENGINE.GetItemAttrText(

6201: END IF;
6202:
6203: IF ((l_triggerable_flag = 'N' AND l_trig_repeat_flag = 'Y') OR l_orig_csch_id IS NOT NULL) THEN
6204: --Repeating activity
6205: l_scheduler_frequency := to_number(WF_ENGINE.GetItemAttrText(
6206: itemtype => itemtype,
6207: itemkey => itemkey ,
6208: aname => 'AMS_SCHEDULER_FREQUENCY' ));
6209: IF (l_scheduler_frequency IS NULL) THEN

Line 6236: l_new_schedule_id := TO_NUMBER(WF_ENGINE.GetItemAttrText(

6232: result := 'COMPLETE:F';
6233: END IF;
6234: --RETURN;
6235: ELSE
6236: l_new_schedule_id := TO_NUMBER(WF_ENGINE.GetItemAttrText(
6237: itemtype => itemtype,
6238: itemkey => itemkey ,
6239: aname => 'AMS_NEW_SCHEDULE_ID'));
6240:

Line 6248: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6244: OPEN l_new_sch_det(l_new_schedule_id);
6245: FETCH l_new_sch_det INTO l_new_schedule_name;
6246: CLOSE l_new_sch_det;
6247:
6248: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6249: itemkey => itemkey ,
6250: aname => 'AMS_NEW_SCHEDULE_NAME',
6251: avalue => l_new_schedule_name );
6252: END IF;

Line 6253: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6249: itemkey => itemkey ,
6250: aname => 'AMS_NEW_SCHEDULE_NAME',
6251: avalue => l_new_schedule_name );
6252: END IF;
6253: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6254: itemkey => itemkey ,
6255: aname => 'AMS_SCHEDULER_FREQ_MEANING',
6256: avalue => l_freq_meaning );
6257:

Line 6267: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6263: FND_MESSAGE.Set_Name('AMS', 'AMS_ACTIVITY_PROMPT');
6264: END IF;
6265: l_msg_data := FND_MESSAGE.Get;
6266:
6267: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6268: itemkey => itemkey ,
6269: aname => 'AMS_ACTIVITY_DESCRIPTION',
6270: avalue => l_msg_data );
6271: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 6271: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6267: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6268: itemkey => itemkey ,
6269: aname => 'AMS_ACTIVITY_DESCRIPTION',
6270: avalue => l_msg_data );
6271: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6272: itemkey => itemkey ,
6273: aname => 'SOURCE_CODE',
6274: avalue => l_source_code );
6275: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 6275: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6271: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6272: itemkey => itemkey ,
6273: aname => 'SOURCE_CODE',
6274: avalue => l_source_code );
6275: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6276: itemkey => itemkey ,
6277: aname => 'AMS_CHANNEL_DESCRIPTION',
6278: avalue => l_media_name );
6279: