DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on WF_ENGINE

Line 3872: l_action := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ACTION');

3868: --
3869: IF (funcmode = 'RUN')
3870: THEN
3871: --
3872: l_action := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ACTION');
3873:
3874: --
3875: IF (l_action IN ('PUBLISH', 'REVERSE_PUBLISH'))
3876: THEN

Line 3913: l_method := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_METHOD');

3909: --
3910: IF (funcmode = 'RUN')
3911: THEN
3912: --
3913: l_method := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_METHOD');
3914:
3915: --
3916: IF (l_method IN ('CAS', 'PAR'))
3917: THEN

Line 3989: wf_engine.createprocess (itemtype => p_item_type, itemkey => l_item_key, process => p_wf_process);

3985: l_plan_action := 'REVERSE_PUBLISH';
3986: END IF;
3987:
3988: -- WF Process
3989: wf_engine.createprocess (itemtype => p_item_type, itemkey => l_item_key, process => p_wf_process);
3990: -- Item User Key
3991: wf_engine.setitemuserkey (itemtype => p_item_type, itemkey => l_item_key, userkey => l_item_user_key);
3992: -- Effective Date
3993: wf_engine.setitemattrtext (itemtype => p_item_type,

Line 3991: wf_engine.setitemuserkey (itemtype => p_item_type, itemkey => l_item_key, userkey => l_item_user_key);

3987:
3988: -- WF Process
3989: wf_engine.createprocess (itemtype => p_item_type, itemkey => l_item_key, process => p_wf_process);
3990: -- Item User Key
3991: wf_engine.setitemuserkey (itemtype => p_item_type, itemkey => l_item_key, userkey => l_item_user_key);
3992: -- Effective Date
3993: wf_engine.setitemattrtext (itemtype => p_item_type,
3994: itemkey => l_item_key,
3995: aname => 'EFFECTIVE_DATE',

Line 3993: wf_engine.setitemattrtext (itemtype => p_item_type,

3989: wf_engine.createprocess (itemtype => p_item_type, itemkey => l_item_key, process => p_wf_process);
3990: -- Item User Key
3991: wf_engine.setitemuserkey (itemtype => p_item_type, itemkey => l_item_key, userkey => l_item_user_key);
3992: -- Effective Date
3993: wf_engine.setitemattrtext (itemtype => p_item_type,
3994: itemkey => l_item_key,
3995: aname => 'EFFECTIVE_DATE',
3996: avalue => p_effective_date
3997: );

Line 3999: wf_engine.setitemattrtext (itemtype => p_item_type,

3995: aname => 'EFFECTIVE_DATE',
3996: avalue => p_effective_date
3997: );
3998: -- Plan Id
3999: wf_engine.setitemattrtext (itemtype => p_item_type,
4000: itemkey => l_item_key,
4001: aname => 'WPM_PLAN_ID',
4002: avalue => p_plan_rec.plan_id
4003: );

Line 4005: wf_engine.setitemattrtext (itemtype => p_item_type,

4001: aname => 'WPM_PLAN_ID',
4002: avalue => p_plan_rec.plan_id
4003: );
4004: -- Plan Name
4005: wf_engine.setitemattrtext (itemtype => p_item_type,
4006: itemkey => l_item_key,
4007: aname => 'WPM_PLAN',
4008: avalue => p_plan_rec.plan_name
4009: );

Line 4011: wf_engine.setitemattrtext (itemtype => p_item_type,

4007: aname => 'WPM_PLAN',
4008: avalue => p_plan_rec.plan_name
4009: );
4010: -- Plan Action
4011: wf_engine.setitemattrtext (itemtype => p_item_type,
4012: itemkey => l_item_key,
4013: aname => 'WPM_PLAN_ACTION',
4014: avalue => l_plan_action
4015: );

Line 4017: wf_engine.setitemattrtext (itemtype => p_item_type,

4013: aname => 'WPM_PLAN_ACTION',
4014: avalue => l_plan_action
4015: );
4016: -- Plan Method
4017: wf_engine.setitemattrtext (itemtype => p_item_type,
4018: itemkey => l_item_key,
4019: aname => 'WPM_PLAN_METHOD',
4020: avalue => p_plan_rec.method_code
4021: );

Line 4023: wf_engine.setitemattrtext (itemtype => p_item_type,

4019: aname => 'WPM_PLAN_METHOD',
4020: avalue => p_plan_rec.method_code
4021: );
4022: -- Plan Hierarchy
4023: wf_engine.setitemattrtext (itemtype => p_item_type,
4024: itemkey => l_item_key,
4025: aname => 'WPM_PLAN_HIERARCHY',
4026: avalue => p_plan_rec.hierarchy_type_code
4027: );

Line 4029: wf_engine.setitemattrtext (itemtype => p_item_type,

4025: aname => 'WPM_PLAN_HIERARCHY',
4026: avalue => p_plan_rec.hierarchy_type_code
4027: );
4028: -- Plan Supervisor Id
4029: wf_engine.setitemattrtext (itemtype => p_item_type,
4030: itemkey => l_item_key,
4031: aname => 'WPM_PLAN_SUPERVISOR_ID',
4032: avalue => p_plan_rec.supervisor_id
4033: );

Line 4035: wf_engine.setitemattrtext (itemtype => p_item_type,

4031: aname => 'WPM_PLAN_SUPERVISOR_ID',
4032: avalue => p_plan_rec.supervisor_id
4033: );
4034: -- Plan Supervisor Assignment Id
4035: wf_engine.setitemattrtext (itemtype => p_item_type,
4036: itemkey => l_item_key,
4037: aname => 'WPM_PLAN_SUPERVISOR_ASG_ID',
4038: avalue => p_plan_rec.supervisor_assignment_id
4039: );

Line 4041: wf_engine.setitemattrtext (itemtype => p_item_type,

4037: aname => 'WPM_PLAN_SUPERVISOR_ASG_ID',
4038: avalue => p_plan_rec.supervisor_assignment_id
4039: );
4040: -- Plan Top Organization Id
4041: wf_engine.setitemattrtext (itemtype => p_item_type,
4042: itemkey => l_item_key,
4043: aname => 'WPM_PLAN_TOP_ORG_ID',
4044: avalue => p_plan_rec.top_organization_id
4045: );

Line 4047: wf_engine.setitemattrtext (itemtype => p_item_type,

4043: aname => 'WPM_PLAN_TOP_ORG_ID',
4044: avalue => p_plan_rec.top_organization_id
4045: );
4046: -- Plan Top Position Id
4047: wf_engine.setitemattrtext (itemtype => p_item_type,
4048: itemkey => l_item_key,
4049: aname => 'WPM_PLAN_TOP_POS_ID',
4050: avalue => p_plan_rec.top_position_id
4051: );

Line 4053: wf_engine.setitemattrtext (itemtype => p_item_type,

4049: aname => 'WPM_PLAN_TOP_POS_ID',
4050: avalue => p_plan_rec.top_position_id
4051: );
4052: -- Objective Setting Start Date
4053: wf_engine.setitemattrtext (itemtype => p_item_type,
4054: itemkey => l_item_key,
4055: aname => 'OBJ_SET_START',
4056: avalue => p_plan_rec.obj_setting_start_date
4057: );

Line 4059: wf_engine.setitemattrtext (itemtype => p_item_type,

4055: aname => 'OBJ_SET_START',
4056: avalue => p_plan_rec.obj_setting_start_date
4057: );
4058: -- Objective Setting End Date
4059: wf_engine.setitemattrtext (itemtype => p_item_type,
4060: itemkey => l_item_key,
4061: aname => 'OBJ_SET_FINISH',
4062: avalue => p_plan_rec.obj_setting_deadline
4063: );

Line 4065: wf_engine.setitemattrtext (itemtype => p_item_type,

4061: aname => 'OBJ_SET_FINISH',
4062: avalue => p_plan_rec.obj_setting_deadline
4063: );
4064: -- start changes for Bug#5903006
4065: wf_engine.setitemattrtext (itemtype => p_item_type,
4066: itemkey => l_item_key,
4067: aname => 'HR_WPM_OBJ_SETTING_FLAG',
4068: avalue => p_plan_rec.include_obj_setting_flag
4069: );

Line 4085: wf_engine.setitemattrtext (itemtype => p_item_type,

4081: );
4082: --
4083: -- Plan Administrator
4084: --
4085: wf_engine.setitemattrtext (itemtype => p_item_type,
4086: itemkey => l_item_key,
4087: aname => 'HR_WPM_PLAN_ADMINISTRATOR',
4088: avalue => l_admin_role_name
4089: );

Line 4101: wf_engine.setitemowner (itemtype => p_item_type, itemkey => l_item_key, owner => l_role_name);

4097: p_name => l_role_name,
4098: p_display_name => l_role_displayname
4099: );
4100: --
4101: wf_engine.setitemowner (itemtype => p_item_type, itemkey => l_item_key, owner => l_role_name);
4102: --
4103: -- Changes by KMG for fixing BUG#7710591
4104: l_wfthreshold := NVL (wf_engine.threshold, 50);
4105: wf_engine.threshold := -1; -- Ensures a deferred process

Line 4104: l_wfthreshold := NVL (wf_engine.threshold, 50);

4100: --
4101: wf_engine.setitemowner (itemtype => p_item_type, itemkey => l_item_key, owner => l_role_name);
4102: --
4103: -- Changes by KMG for fixing BUG#7710591
4104: l_wfthreshold := NVL (wf_engine.threshold, 50);
4105: wf_engine.threshold := -1; -- Ensures a deferred process
4106: wf_engine.startprocess (itemtype => p_item_type, itemkey => l_item_key);
4107: wf_engine.threshold := l_wfthreshold;
4108:

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

4101: wf_engine.setitemowner (itemtype => p_item_type, itemkey => l_item_key, owner => l_role_name);
4102: --
4103: -- Changes by KMG for fixing BUG#7710591
4104: l_wfthreshold := NVL (wf_engine.threshold, 50);
4105: wf_engine.threshold := -1; -- Ensures a deferred process
4106: wf_engine.startprocess (itemtype => p_item_type, itemkey => l_item_key);
4107: wf_engine.threshold := l_wfthreshold;
4108:
4109: --

Line 4106: wf_engine.startprocess (itemtype => p_item_type, itemkey => l_item_key);

4102: --
4103: -- Changes by KMG for fixing BUG#7710591
4104: l_wfthreshold := NVL (wf_engine.threshold, 50);
4105: wf_engine.threshold := -1; -- Ensures a deferred process
4106: wf_engine.startprocess (itemtype => p_item_type, itemkey => l_item_key);
4107: wf_engine.threshold := l_wfthreshold;
4108:
4109: --
4110: --

Line 4107: wf_engine.threshold := l_wfthreshold;

4103: -- Changes by KMG for fixing BUG#7710591
4104: l_wfthreshold := NVL (wf_engine.threshold, 50);
4105: wf_engine.threshold := -1; -- Ensures a deferred process
4106: wf_engine.startprocess (itemtype => p_item_type, itemkey => l_item_key);
4107: wf_engine.threshold := l_wfthreshold;
4108:
4109: --
4110: --
4111: IF g_dbg

Line 4175: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');

4171: --
4172: IF (funcmode = 'RUN')
4173: THEN
4174: -- Get the workwlow attribute values
4175: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');
4176: l_effective_date := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'EFFECTIVE_DATE');
4177:
4178: --
4179: -- Get plan record

Line 4176: l_effective_date := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'EFFECTIVE_DATE');

4172: IF (funcmode = 'RUN')
4173: THEN
4174: -- Get the workwlow attribute values
4175: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');
4176: l_effective_date := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'EFFECTIVE_DATE');
4177:
4178: --
4179: -- Get plan record
4180: --

Line 4239: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');

4235: --
4236: IF (funcmode = 'RUN')
4237: THEN
4238: -- Get the workwlow attribute values
4239: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');
4240:
4241: -- If plan population is known
4242: IF (g_plan_pop_known_t (l_plan_id))
4243: THEN

Line 4265: wf_engine.setitemattrtext (itemtype, itemkey, 'WPM_PLAN_MEMBER', l_role_name);

4261:
4262: --
4263: IF (l_role_name IS NOT NULL)
4264: THEN
4265: wf_engine.setitemattrtext (itemtype, itemkey, 'WPM_PLAN_MEMBER', l_role_name);
4266: resultout := 'COMPLETE:' || 'Y';
4267: RETURN;
4268: END IF;
4269:

Line 4319: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');

4315: --
4316: IF (funcmode = 'RUN')
4317: THEN
4318: -- Get the workwlow attribute values
4319: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');
4320: --
4321: l_plan_hierarchy := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_HIERARCHY');
4322:
4323: IF (l_plan_hierarchy = 'SUP')

Line 4321: l_plan_hierarchy := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_HIERARCHY');

4317: THEN
4318: -- Get the workwlow attribute values
4319: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');
4320: --
4321: l_plan_hierarchy := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_HIERARCHY');
4322:
4323: IF (l_plan_hierarchy = 'SUP')
4324: THEN
4325: --

Line 4326: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_SUPERVISOR_ID');

4322:
4323: IF (l_plan_hierarchy = 'SUP')
4324: THEN
4325: --
4326: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_SUPERVISOR_ID');
4327: ELSIF (l_plan_hierarchy = 'SUP_ASG')
4328: THEN
4329: --
4330: l_top_id :=

Line 4331: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,

4327: ELSIF (l_plan_hierarchy = 'SUP_ASG')
4328: THEN
4329: --
4330: l_top_id :=
4331: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,
4332: aname => 'WPM_PLAN_SUPERVISOR_ASG_ID');
4333: ELSIF (l_plan_hierarchy = 'ORG')
4334: THEN
4335: --

Line 4336: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_ORG_ID');

4332: aname => 'WPM_PLAN_SUPERVISOR_ASG_ID');
4333: ELSIF (l_plan_hierarchy = 'ORG')
4334: THEN
4335: --
4336: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_ORG_ID');
4337: ELSIF (l_plan_hierarchy = 'POS')
4338: THEN
4339: --
4340: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_POS_ID');

Line 4340: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_POS_ID');

4336: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_ORG_ID');
4337: ELSIF (l_plan_hierarchy = 'POS')
4338: THEN
4339: --
4340: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_POS_ID');
4341: END IF;
4342:
4343: -- If plan population is known
4344: IF (g_plan_pop_known_t (l_plan_id))

Line 4372: wf_engine.setitemattrtext (itemtype, itemkey, 'WPM_PLAN_MEMBER', l_role_name);

4368:
4369: --
4370: IF (l_role_name IS NOT NULL)
4371: THEN
4372: wf_engine.setitemattrtext (itemtype, itemkey, 'WPM_PLAN_MEMBER', l_role_name);
4373: resultout := 'COMPLETE:' || 'Y';
4374: RETURN;
4375: END IF;
4376: --

Line 4437: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');

4433: --
4434: IF (funcmode = 'RUN')
4435: THEN
4436: -- Get the workwlow attribute values
4437: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');
4438: --
4439: l_plan_hierarchy := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_HIERARCHY');
4440:
4441: IF (l_plan_hierarchy = 'SUP')

Line 4439: l_plan_hierarchy := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_HIERARCHY');

4435: THEN
4436: -- Get the workwlow attribute values
4437: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');
4438: --
4439: l_plan_hierarchy := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_HIERARCHY');
4440:
4441: IF (l_plan_hierarchy = 'SUP')
4442: THEN
4443: --

Line 4444: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_SUPERVISOR_ID');

4440:
4441: IF (l_plan_hierarchy = 'SUP')
4442: THEN
4443: --
4444: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_SUPERVISOR_ID');
4445: ELSIF (l_plan_hierarchy = 'SUP_ASG')
4446: THEN
4447: --
4448: l_top_id :=

Line 4449: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,

4445: ELSIF (l_plan_hierarchy = 'SUP_ASG')
4446: THEN
4447: --
4448: l_top_id :=
4449: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,
4450: aname => 'WPM_PLAN_SUPERVISOR_ASG_ID');
4451: ELSIF (l_plan_hierarchy = 'ORG')
4452: THEN
4453: --

Line 4454: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_ORG_ID');

4450: aname => 'WPM_PLAN_SUPERVISOR_ASG_ID');
4451: ELSIF (l_plan_hierarchy = 'ORG')
4452: THEN
4453: --
4454: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_ORG_ID');
4455: ELSIF (l_plan_hierarchy = 'POS')
4456: THEN
4457: --
4458: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_POS_ID');

Line 4458: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_POS_ID');

4454: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_ORG_ID');
4455: ELSIF (l_plan_hierarchy = 'POS')
4456: THEN
4457: --
4458: l_top_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_TOP_POS_ID');
4459: END IF;
4460:
4461: -- If plan population is known
4462: IF (g_plan_pop_known_t (l_plan_id))

Line 4503: wf_engine.setitemattrtext (itemtype, itemkey, 'WPM_PLAN_MEMBER', l_role_name);

4499:
4500: --
4501: IF (l_role_name IS NOT NULL)
4502: THEN
4503: wf_engine.setitemattrtext (itemtype, itemkey, 'WPM_PLAN_MEMBER', l_role_name);
4504: resultout := 'COMPLETE:' || 'Y';
4505: RETURN;
4506: END IF;
4507: --

Line 6171: IF (funcmode <> wf_engine.eng_run)

6167: l_obj_setting_flag VARCHAR2 (30);
6168: --end changes for bug#5903006
6169: --
6170: BEGIN
6171: IF (funcmode <> wf_engine.eng_run)
6172: THEN
6173: resultout := wf_engine.eng_null;
6174: RETURN;
6175: END IF;

Line 6173: resultout := wf_engine.eng_null;

6169: --
6170: BEGIN
6171: IF (funcmode <> wf_engine.eng_run)
6172: THEN
6173: resultout := wf_engine.eng_null;
6174: RETURN;
6175: END IF;
6176:
6177: l_role_name := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_MEMBER');

Line 6177: l_role_name := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_MEMBER');

6173: resultout := wf_engine.eng_null;
6174: RETURN;
6175: END IF;
6176:
6177: l_role_name := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_MEMBER');
6178: l_msg := UPPER (wf_engine.getactivityattrtext (itemtype, itemkey, actid, 'MESSAGE_NAME'));
6179: -- Start Changes for bug#5903006
6180: l_obj_setting_flag :=
6181: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,

Line 6178: l_msg := UPPER (wf_engine.getactivityattrtext (itemtype, itemkey, actid, 'MESSAGE_NAME'));

6174: RETURN;
6175: END IF;
6176:
6177: l_role_name := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_MEMBER');
6178: l_msg := UPPER (wf_engine.getactivityattrtext (itemtype, itemkey, actid, 'MESSAGE_NAME'));
6179: -- Start Changes for bug#5903006
6180: l_obj_setting_flag :=
6181: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,
6182: aname => 'HR_WPM_OBJ_SETTING_FLAG');

Line 6181: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,

6177: l_role_name := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_MEMBER');
6178: l_msg := UPPER (wf_engine.getactivityattrtext (itemtype, itemkey, actid, 'MESSAGE_NAME'));
6179: -- Start Changes for bug#5903006
6180: l_obj_setting_flag :=
6181: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,
6182: aname => 'HR_WPM_OBJ_SETTING_FLAG');
6183:
6184: IF NVL (l_obj_setting_flag, 'N') = 'N'
6185: THEN

Line 6209: wf_engine_util.notification_send (itemtype, itemkey, actid, l_msg, 'HRWPM', l_role_name, expand_role, resultout);

6205: wf_core.RAISE ('WFENG_NOTIFICATION_PERFORMER');
6206: END IF;
6207:
6208: --
6209: wf_engine_util.notification_send (itemtype, itemkey, actid, l_msg, 'HRWPM', l_role_name, expand_role, resultout);
6210: EXCEPTION
6211: WHEN OTHERS
6212: THEN
6213: RAISE;

Line 6246: IF (funcmode <> wf_engine.eng_run)

6242: l_admin_person_id NUMBER;
6243: l_supervisor_id NUMBER;
6244: --
6245: BEGIN
6246: IF (funcmode <> wf_engine.eng_run)
6247: THEN
6248: resultout := wf_engine.eng_null;
6249: RETURN;
6250: END IF;

Line 6248: resultout := wf_engine.eng_null;

6244: --
6245: BEGIN
6246: IF (funcmode <> wf_engine.eng_run)
6247: THEN
6248: resultout := wf_engine.eng_null;
6249: RETURN;
6250: END IF;
6251:
6252: --

Line 6255: l_plan_id := wf_engine.getitemattrnumber (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');

6251:
6252: --
6253: -- get plan id
6254: --
6255: l_plan_id := wf_engine.getitemattrnumber (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');
6256:
6257: --
6258: -- get administrator person id from plan
6259: --

Line 6279: l_role_name :=wf_engine.GetItemAttrText(

6275: p_name => l_role_name,
6276: p_display_name => l_role_displayname
6277: );
6278: /*
6279: l_role_name :=wf_engine.GetItemAttrText(
6280: itemtype => itemtype,
6281: itemkey => itemkey,
6282: aname => 'WPM_PLAN_MEMBER');
6283: */

Line 6284: l_msg := UPPER (wf_engine.getactivityattrtext (itemtype, itemkey, actid, 'MESSAGE_NAME'));

6280: itemtype => itemtype,
6281: itemkey => itemkey,
6282: aname => 'WPM_PLAN_MEMBER');
6283: */
6284: l_msg := UPPER (wf_engine.getactivityattrtext (itemtype, itemkey, actid, 'MESSAGE_NAME'));
6285: expand_role := 'N';
6286:
6287: IF l_role_name IS NULL
6288: THEN

Line 6295: wf_engine_util.notification_send (itemtype, itemkey, actid, l_msg, 'HRWPM', l_role_name, expand_role, resultout);

6291: wf_core.RAISE ('WFENG_NOTIFICATION_PERFORMER');
6292: END IF;
6293:
6294: --
6295: wf_engine_util.notification_send (itemtype, itemkey, actid, l_msg, 'HRWPM', l_role_name, expand_role, resultout);
6296: END IF; --l_admin <> l_supervisor_id
6297: EXCEPTION
6298: WHEN OTHERS
6299: THEN

Line 9555: IF (funcmode <> wf_engine.eng_run)

9551: l_obj_setting_flag VARCHAR2 (30);
9552: --end changes for bug#5903006
9553: --
9554: BEGIN
9555: IF (funcmode <> wf_engine.eng_run)
9556: THEN
9557: resultout := wf_engine.eng_null;
9558: RETURN;
9559: END IF;

Line 9557: resultout := wf_engine.eng_null;

9553: --
9554: BEGIN
9555: IF (funcmode <> wf_engine.eng_run)
9556: THEN
9557: resultout := wf_engine.eng_null;
9558: RETURN;
9559: END IF;
9560:
9561: l_role_name := rolename;

Line 9562: l_msg := UPPER (wf_engine.getactivityattrtext (itemtype, itemkey, actid, 'MESSAGE_NAME'));

9558: RETURN;
9559: END IF;
9560:
9561: l_role_name := rolename;
9562: l_msg := UPPER (wf_engine.getactivityattrtext (itemtype, itemkey, actid, 'MESSAGE_NAME'));
9563: -- Start Changes for bug#5903006
9564: l_obj_setting_flag :=
9565: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,
9566: aname => 'HR_WPM_OBJ_SETTING_FLAG');

Line 9565: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,

9561: l_role_name := rolename;
9562: l_msg := UPPER (wf_engine.getactivityattrtext (itemtype, itemkey, actid, 'MESSAGE_NAME'));
9563: -- Start Changes for bug#5903006
9564: l_obj_setting_flag :=
9565: wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey,
9566: aname => 'HR_WPM_OBJ_SETTING_FLAG');
9567:
9568: IF NVL (l_obj_setting_flag, 'N') = 'N'
9569: THEN

Line 9593: wf_engine_util.notification_send (itemtype, itemkey, actid, l_msg, 'HRWPM', l_role_name, expand_role, resultout);

9589: wf_core.RAISE ('WFENG_NOTIFICATION_PERFORMER');
9590: END IF;
9591:
9592: --
9593: wf_engine_util.notification_send (itemtype, itemkey, actid, l_msg, 'HRWPM', l_role_name, expand_role, resultout);
9594: EXCEPTION
9595: WHEN OTHERS
9596: THEN
9597: RAISE;

Line 9630: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');

9626: --
9627: IF (funcmode = 'RUN')
9628: THEN
9629: -- Get the workwlow attribute values
9630: l_plan_id := wf_engine.getitemattrtext (itemtype => itemtype, itemkey => itemkey, aname => 'WPM_PLAN_ID');
9631:
9632: -- If plan population is known
9633: IF (g_plan_pop_known_t (l_plan_id))
9634: THEN