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

Line 123: l_text_attr_name_tbl Wf_Engine.NameTabTyp;

119:
120: l_item_type VARCHAR2(8) := 'PARMATRX';
121: l_item_key NUMBER;
122: l_save_threshold NUMBER;
123: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
124: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
125: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
126: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;

Line 124: l_text_attr_value_tbl Wf_Engine.TextTabTyp;

120: l_item_type VARCHAR2(8) := 'PARMATRX';
121: l_item_key NUMBER;
122: l_save_threshold NUMBER;
123: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
124: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
125: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
126: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;

Line 125: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;

121: l_item_key NUMBER;
122: l_save_threshold NUMBER;
123: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
124: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
125: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
126: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;

Line 126: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;

122: l_save_threshold NUMBER;
123: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
124: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
125: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
126: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;

Line 127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;

123: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
124: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
125: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
126: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;

Line 128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;

124: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
125: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
126: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;
132: l_date_attr_value_tbl Wf_Engine.DateTabTyp;

Line 129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;

125: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
126: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;
132: l_date_attr_value_tbl Wf_Engine.DateTabTyp;
133: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;

Line 130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;

126: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;
132: l_date_attr_value_tbl Wf_Engine.DateTabTyp;
133: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
134: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;

Line 131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;

127: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;
132: l_date_attr_value_tbl Wf_Engine.DateTabTyp;
133: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
134: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
135: l_err_code fnd_new_messages.message_name%TYPE;

Line 132: l_date_attr_value_tbl Wf_Engine.DateTabTyp;

128: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;
132: l_date_attr_value_tbl Wf_Engine.DateTabTyp;
133: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
134: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
135: l_err_code fnd_new_messages.message_name%TYPE;
136: l_err_stage VARCHAR2(2000);

Line 133: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;

129: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;
130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;
132: l_date_attr_value_tbl Wf_Engine.DateTabTyp;
133: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
134: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
135: l_err_code fnd_new_messages.message_name%TYPE;
136: l_err_stage VARCHAR2(2000);
137: l_err_stack VARCHAR2(2000);

Line 134: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;

130: l_set_num_attr_value_tbl Wf_Engine.NumTabTyp;
131: l_date_attr_name_tbl Wf_Engine.NameTabTyp;
132: l_date_attr_value_tbl Wf_Engine.DateTabTyp;
133: l_set_date_attr_name_tbl Wf_Engine.NameTabTyp;
134: l_set_date_attr_value_tbl Wf_Engine.DateTabTyp;
135: l_err_code fnd_new_messages.message_name%TYPE;
136: l_err_stage VARCHAR2(2000);
137: l_err_stack VARCHAR2(2000);
138: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 160: l_save_threshold := wf_engine.threshold;

156: --initialize return status to Success
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:
159: -- Setting thresold value to run the process in background
160: l_save_threshold := wf_engine.threshold;
161:
162: IF wf_engine.threshold < 0 THEN
163: wf_engine.threshold := l_save_threshold;
164: END IF;

Line 162: IF wf_engine.threshold < 0 THEN

158:
159: -- Setting thresold value to run the process in background
160: l_save_threshold := wf_engine.threshold;
161:
162: IF wf_engine.threshold < 0 THEN
163: wf_engine.threshold := l_save_threshold;
164: END IF;
165: wf_engine.threshold := -1;
166:

Line 163: wf_engine.threshold := l_save_threshold;

159: -- Setting thresold value to run the process in background
160: l_save_threshold := wf_engine.threshold;
161:
162: IF wf_engine.threshold < 0 THEN
163: wf_engine.threshold := l_save_threshold;
164: END IF;
165: wf_engine.threshold := -1;
166:
167: --get item key

Line 165: wf_engine.threshold := -1;

161:
162: IF wf_engine.threshold < 0 THEN
163: wf_engine.threshold := l_save_threshold;
164: END IF;
165: wf_engine.threshold := -1;
166:
167: --get item key
168: SELECT pa_mass_asgmt_trx_wf_s.nextval
169: INTO l_item_key

Line 198: WF_ENGINE.CreateProcess( itemtype => l_item_type,

194: END IF;
195: --------------------------------------------------------------------------
196:
197: -- Creating the work flow process
198: WF_ENGINE.CreateProcess( itemtype => l_item_type,
199: itemkey => l_item_key,
200: process => 'PA_MASS_ASGMT_TRX_WF') ;
201:
202: --if project id is not passed (could only happen when adding a delivery or

Line 690: WF_ENGINE.AddItemAttrTextArray(itemtype => l_item_type,

686: l_num_attr_name_tbl(l_num_attr_name_tbl.COUNT+1) := 'SUBMITTER_RESP_APPL_ID';
687: l_num_attr_value_tbl(l_num_attr_value_tbl.COUNT+1) := FND_GLOBAL.resp_appl_id;
688:
689: --dynamically create and set the Text item attributes
690: WF_ENGINE.AddItemAttrTextArray(itemtype => l_item_type,
691: itemkey => l_item_key,
692: aname => l_text_attr_name_tbl,
693: avalue => l_text_attr_value_tbl);
694:

Line 696: WF_ENGINE.AddItemAttrNumberArray(itemtype => l_item_type,

692: aname => l_text_attr_name_tbl,
693: avalue => l_text_attr_value_tbl);
694:
695: --dynamically create and set the Number item attributes
696: WF_ENGINE.AddItemAttrNumberArray(itemtype => l_item_type,
697: itemkey => l_item_key,
698: aname => l_num_attr_name_tbl,
699: avalue => l_num_attr_value_tbl);
700:

Line 702: WF_ENGINE.AddItemAttrDateArray(itemtype => l_item_type,

698: aname => l_num_attr_name_tbl,
699: avalue => l_num_attr_value_tbl);
700:
701: --dynamically create and set the Date item attributes
702: WF_ENGINE.AddItemAttrDateArray(itemtype => l_item_type,
703: itemkey => l_item_key,
704: aname => l_date_attr_name_tbl,
705: avalue => l_date_attr_value_tbl);
706:

Line 708: WF_ENGINE.SetItemAttrTextArray(itemtype => l_item_type,

704: aname => l_date_attr_name_tbl,
705: avalue => l_date_attr_value_tbl);
706:
707: --SET the Text item attributes (these attributes were created at design time)
708: WF_ENGINE.SetItemAttrTextArray(itemtype => l_item_type,
709: itemkey => l_item_key,
710: aname => l_set_text_attr_name_tbl,
711: avalue => l_set_text_attr_value_tbl);
712:

Line 714: WF_ENGINE.SetItemAttrNumberArray(itemtype => l_item_type,

710: aname => l_set_text_attr_name_tbl,
711: avalue => l_set_text_attr_value_tbl);
712:
713: --SET the Number item attributes (these attributes were created at design time)
714: WF_ENGINE.SetItemAttrNumberArray(itemtype => l_item_type,
715: itemkey => l_item_key,
716: aname => l_set_num_attr_name_tbl,
717: avalue => l_set_num_attr_value_tbl);
718:

Line 720: WF_ENGINE.SetItemAttrDateArray(itemtype => l_item_type,

716: aname => l_set_num_attr_name_tbl,
717: avalue => l_set_num_attr_value_tbl);
718:
719: --SET the Date item attributes
720: WF_ENGINE.SetItemAttrDateArray(itemtype => l_item_type,
721: itemkey => l_item_key,
722: aname => l_set_date_attr_name_tbl,
723: avalue => l_set_date_attr_value_tbl);
724:

Line 727: WF_ENGINE.StartProcess( itemtype => l_item_type,

723: avalue => l_set_date_attr_value_tbl);
724:
725:
726: -- start the workflow process
727: WF_ENGINE.StartProcess( itemtype => l_item_type,
728: itemkey => l_item_key);
729:
730: --Setting the original value
731: wf_engine.threshold := l_save_threshold;

Line 731: wf_engine.threshold := l_save_threshold;

727: WF_ENGINE.StartProcess( itemtype => l_item_type,
728: itemkey => l_item_key);
729:
730: --Setting the original value
731: wf_engine.threshold := l_save_threshold;
732:
733: --if this is a mass update then set the mass_wf_in_progress_flag to 'Y'
734: --in pa_project_assignments. This is a bulk update for all assignments being updated.
735: IF p_mode <> G_MASS_ASGMT THEN

Line 748: wf_engine.threshold := l_save_threshold;

744: EXCEPTION
745: WHEN OTHERS THEN
746:
747: --Setting the original value
748: wf_engine.threshold := l_save_threshold;
749:
750: -- Set the excetption Message and the stack
751: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'pa_mass_asgmt_trx.start_mass_asgmt_trx_wf'
752: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line 782: l_text_attr_name_tbl Wf_Engine.NameTabTyp;

778: l_project_name pa_projects_all.name%TYPE;
779: l_project_number pa_projects_all.segment1%TYPE;
780: l_success_assignments NUMBER := 0;
781: l_failure_assignments NUMBER := 0;
782: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
783: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
784: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
785: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;

Line 783: l_text_attr_value_tbl Wf_Engine.TextTabTyp;

779: l_project_number pa_projects_all.segment1%TYPE;
780: l_success_assignments NUMBER := 0;
781: l_failure_assignments NUMBER := 0;
782: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
783: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
784: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
785: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
787: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;

Line 784: l_num_attr_name_tbl Wf_Engine.NameTabTyp;

780: l_success_assignments NUMBER := 0;
781: l_failure_assignments NUMBER := 0;
782: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
783: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
784: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
785: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
787: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
788: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;

Line 785: l_num_attr_value_tbl Wf_Engine.NumTabTyp;

781: l_failure_assignments NUMBER := 0;
782: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
783: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
784: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
785: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
787: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
788: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;
789: l_project_customer pa_project_lists_v.customer_name%TYPE;

Line 786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;

782: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
783: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
784: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
785: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
787: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
788: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;
789: l_project_customer pa_project_lists_v.customer_name%TYPE;
790: l_project_manager pa_project_lists_v.person_name%TYPE;

Line 787: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;

783: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
784: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
785: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
786: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;
787: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;
788: l_project_organization pa_project_lists_v.CARRYING_OUT_ORGANIZATION_NAME%TYPE;
789: l_project_customer pa_project_lists_v.customer_name%TYPE;
790: l_project_manager pa_project_lists_v.person_name%TYPE;
791: l_err_code VARCHAR2(2000);

Line 837: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

833: WHERE item_type = p_item_type
834: AND item_key = p_item_key
835: AND process_status_code = 'P';
836:
837: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
838: itemkey => p_item_key,
839: aname => 'MODE');
840:
841: --if this is a mass assignment then assign the resource id tbl to the object id tbl.

Line 887: l_resolve_con_action_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

883: --successfully created / updated then do the following to
884: --check overcommitment.
885: IF l_action <> G_SAVE AND l_success_assignments > 0 THEN
886:
887: l_resolve_con_action_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
888: itemkey => p_item_key,
889: aname => 'RESOLVE_CONFLICT_ACTION_CODE');
890:
891:

Line 1136: WF_ENGINE.AddItemAttrNumberArray(itemtype => p_item_type,

1132:
1133: END IF;
1134:
1135: --dynamically create and set the Number item attributes
1136: WF_ENGINE.AddItemAttrNumberArray(itemtype => p_item_type,
1137: itemkey => p_item_key,
1138: aname => l_add_num_attr_name_tbl,
1139: avalue => l_add_num_attr_value_tbl);
1140: --set the wf item attributes.

Line 1141: WF_ENGINE.SetItemAttrTextArray(itemtype => p_item_type,

1137: itemkey => p_item_key,
1138: aname => l_add_num_attr_name_tbl,
1139: avalue => l_add_num_attr_value_tbl);
1140: --set the wf item attributes.
1141: WF_ENGINE.SetItemAttrTextArray(itemtype => p_item_type,
1142: itemkey => p_item_key,
1143: aname => l_text_attr_name_tbl,
1144: avalue => l_text_attr_value_tbl);
1145:

Line 1146: WF_ENGINE.SetItemAttrNumberArray(itemtype => p_item_type,

1142: itemkey => p_item_key,
1143: aname => l_text_attr_name_tbl,
1144: avalue => l_text_attr_value_tbl);
1145:
1146: WF_ENGINE.SetItemAttrNumberArray(itemtype => p_item_type,
1147: itemkey => p_item_key,
1148: aname => l_num_attr_name_tbl,
1149: avalue => l_num_attr_value_tbl);
1150:

Line 1156: WF_ENGINE.SetItemAttrDocument(itemtype => p_item_type,

1152: --of the mass update wf notification.
1153: --see the mass_asgmt_autonomous_trx API for more information.
1154: --also refer to the Oracle Workflow documentation for information
1155: --regarding Document types.
1156: WF_ENGINE.SetItemAttrDocument(itemtype => p_item_type,
1157: itemkey => p_item_key,
1158: aname => 'UPDATED_INFORMATION_DOCUMENT',
1159: documentid => 'plsql:PA_MASS_ASGMT_TRX.Display_Updated_Attributes/' ||l_document);
1160:

Line 1307: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;

1303: l_duration_shift_unit_code VARCHAR2(30);
1304: l_num_of_shift NUMBER;
1305: l_success_assignments NUMBER;
1306: l_failure_assignments NUMBER;
1307: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1308: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1309: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1310: l_project_customer pa_project_lists_v.customer_name%TYPE;
1311: l_project_manager pa_project_lists_v.person_name%TYPE;

Line 1308: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;

1304: l_num_of_shift NUMBER;
1305: l_success_assignments NUMBER;
1306: l_failure_assignments NUMBER;
1307: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1308: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1309: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1310: l_project_customer pa_project_lists_v.customer_name%TYPE;
1311: l_project_manager pa_project_lists_v.person_name%TYPE;
1312: l_err_code VARCHAR2(2000);

Line 1350: l_submitter_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1346: --id is passed in - it must be valid.
1347: PA_STARTUP.G_Check_ID_Flag := 'N';
1348:
1349: --retrieve the number of assignments attribute
1350: l_submitter_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1351: itemkey => p_item_key,
1352: aname => 'SUBMITTER_USER_ID');
1353:
1354: l_submitter_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1354: l_submitter_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1350: l_submitter_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1351: itemkey => p_item_key,
1352: aname => 'SUBMITTER_USER_ID');
1353:
1354: l_submitter_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1355: itemkey => p_item_key,
1356: aname => 'SUBMITTER_RESP_ID');
1357:
1358: l_submitter_resp_appl_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1358: l_submitter_resp_appl_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1354: l_submitter_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1355: itemkey => p_item_key,
1356: aname => 'SUBMITTER_RESP_ID');
1357:
1358: l_submitter_resp_appl_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1359: itemkey => p_item_key,
1360: aname => 'SUBMITTER_RESP_APPL_ID');
1361:
1362: FND_GLOBAL.Apps_Initialize ( user_id => l_submitter_user_id

Line 1372: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1368: PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID := l_submitter_user_id;
1369: PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY := p_item_key;
1370:
1371: --get the following wf item attributes regardless of the mode
1372: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1373: itemkey => p_item_key,
1374: aname => 'MODE');
1375: x_mode := l_mode;
1376:

Line 1377: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1373: itemkey => p_item_key,
1374: aname => 'MODE');
1375: x_mode := l_mode;
1376:
1377: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1378: itemkey => p_item_key,
1379: aname => 'ACTION');
1380: x_action := l_action;
1381:

Line 1383: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1379: aname => 'ACTION');
1380: x_action := l_action;
1381:
1382:
1383: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1384: itemkey => p_item_key,
1385: aname => 'PROJECT_ID');
1386: x_project_id := l_project_id;
1387:

Line 1395: l_assignment_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1391: --if the mode is mass assignment or mass update basic info then get the
1392: --following attributes.
1393: IF l_mode = G_MASS_ASGMT OR l_mode = G_MASS_UPDATE_ASGMT_BASIC_INFO THEN
1394:
1395: l_assignment_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1396: itemkey => p_item_key,
1397: aname => 'ASSIGNMENT_NAME');
1398:
1399: --if the attribute has been updated then

Line 1405: l_wf_assignment_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1401: IF l_assignment_name <> FND_API.G_MISS_CHAR AND l_assignment_name IS NOT NULL THEN
1402: x_document := x_document||get_translated_attr_name('ASSIGNMENT_NAME')||' - '||l_assignment_name||'
';
1403: END IF;
1404:
1405: l_wf_assignment_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1406: itemkey => p_item_key,
1407: aname => 'ASSIGNMENT_TYPE');
1408:
1409: l_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1409: l_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1405: l_wf_assignment_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1406: itemkey => p_item_key,
1407: aname => 'ASSIGNMENT_TYPE');
1408:
1409: l_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1410: itemkey => p_item_key,
1411: aname => 'STATUS_CODE');
1412:
1413: l_project_status_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1413: l_project_status_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1409: l_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1410: itemkey => p_item_key,
1411: aname => 'STATUS_CODE');
1412:
1413: l_project_status_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1414: itemkey => p_item_key,
1415: aname => 'PROJECT_STATUS_NAME');
1416:
1417: l_multiple_status_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1417: l_multiple_status_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1413: l_project_status_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1414: itemkey => p_item_key,
1415: aname => 'PROJECT_STATUS_NAME');
1416:
1417: l_multiple_status_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1418: itemkey => p_item_key,
1419: aname => 'MULTIPLE_STATUS_FLAG');
1420:
1421: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1421: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1417: l_multiple_status_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1418: itemkey => p_item_key,
1419: aname => 'MULTIPLE_STATUS_FLAG');
1420:
1421: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1422: itemkey => p_item_key,
1423: aname => 'WORK_TYPE_ID');
1424:
1425: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1425: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1421: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1422: itemkey => p_item_key,
1423: aname => 'WORK_TYPE_ID');
1424:
1425: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1426: itemkey => p_item_key,
1427: aname => 'WORK_TYPE_NAME');
1428:
1429: l_staffing_priority_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1429: l_staffing_priority_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1425: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1426: itemkey => p_item_key,
1427: aname => 'WORK_TYPE_NAME');
1428:
1429: l_staffing_priority_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1430: itemkey => p_item_key,
1431: aname => 'STAFFING_PRIORITY_CODE');
1432:
1433: l_staffing_priority_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1433: l_staffing_priority_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1429: l_staffing_priority_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1430: itemkey => p_item_key,
1431: aname => 'STAFFING_PRIORITY_CODE');
1432:
1433: l_staffing_priority_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1434: itemkey => p_item_key,
1435: aname => 'STAFFING_PRIORITY_NAME');
1436:
1437: --if the attribute has been updated then

Line 1450: l_project_role_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1446: END IF;
1447: x_document := x_document||get_translated_attr_name('STAFFING_PRIORITY_NAME')||' - '||l_staffing_priority_name||'
';
1448: END IF;
1449:
1450: l_project_role_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1451: itemkey => p_item_key,
1452: aname => 'PROJECT_ROLE_ID');
1453:
1454: l_project_role_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1454: l_project_role_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1450: l_project_role_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1451: itemkey => p_item_key,
1452: aname => 'PROJECT_ROLE_ID');
1453:
1454: l_project_role_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1455: itemkey => p_item_key,
1456: aname => 'PROJECT_ROLE_NAME');
1457:
1458: l_role_list_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1458: l_role_list_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1454: l_project_role_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1455: itemkey => p_item_key,
1456: aname => 'PROJECT_ROLE_NAME');
1457:
1458: l_role_list_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1459: itemkey => p_item_key,
1460: aname => 'ROLE_LIST_ID');
1461:
1462: l_project_subteam_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1462: l_project_subteam_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1458: l_role_list_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1459: itemkey => p_item_key,
1460: aname => 'ROLE_LIST_ID');
1461:
1462: l_project_subteam_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1463: itemkey => p_item_key,
1464: aname => 'PROJECT_SUBTEAM_ID');
1465:
1466: l_project_subteam_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1466: l_project_subteam_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1462: l_project_subteam_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1463: itemkey => p_item_key,
1464: aname => 'PROJECT_SUBTEAM_ID');
1465:
1466: l_project_subteam_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1467: itemkey => p_item_key,
1468: aname => 'PROJECT_SUBTEAM_NAME');
1469:
1470: --if the attribute has been updated then

Line 1482: l_extension_possible := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1478: END IF;
1479: x_document := x_document||get_translated_attr_name('PROJECT_SUBTEAM_NAME')||' - '||l_project_subteam_name||'
';
1480: END IF;
1481:
1482: l_extension_possible := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1483: itemkey => p_item_key,
1484: aname => 'EXTENSION_POSSIBLE');
1485:
1486:

Line 1498: l_min_resource_job_level := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1494: AND lookup_code = l_extension_possible;
1495: x_document := x_document||get_translated_attr_name('EXTENSION_POSSIBLE')||' - '||l_extension_possible_meaning||'
';
1496: END IF;
1497:
1498: l_min_resource_job_level := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1499: itemkey => p_item_key,
1500: aname => 'MIN_RESOURCE_JOB_LEVEL');
1501:
1502: --if the attribute has been updated then

Line 1508: l_max_resource_job_level := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1504: IF l_min_resource_job_level <> FND_API.G_MISS_NUM AND l_min_resource_job_level IS NOT NULL THEN
1505: x_document := x_document||get_translated_attr_name('MIN_RESOURCE_JOB_LEVEL')||' - '||l_min_resource_job_level||'
';
1506: END IF;
1507:
1508: l_max_resource_job_level := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1509: itemkey => p_item_key,
1510: aname => 'MAX_RESOURCE_JOB_LEVEL');
1511:
1512: --if the attribute has been updated then

Line 1519: l_staffing_owner_person_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1515: x_document := x_document||get_translated_attr_name('MAX_RESOURCE_JOB_LEVEL')||' - '||l_max_resource_job_level||'
';
1516: END IF;
1517:
1518: -- FP.L Development
1519: l_staffing_owner_person_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1520: itemkey => p_item_key,
1521: aname => 'STAFFING_OWNER_PERSON_ID');
1522:
1523: l_staffing_owner_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1523: l_staffing_owner_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1519: l_staffing_owner_person_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1520: itemkey => p_item_key,
1521: aname => 'STAFFING_OWNER_PERSON_ID');
1522:
1523: l_staffing_owner_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1524: itemkey => p_item_key,
1525: aname => 'STAFFING_OWNER_NAME');
1526:
1527: --if the attribute has been updated then

Line 1533: l_description := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1529: IF l_staffing_owner_name <> FND_API.G_MISS_CHAR AND l_staffing_owner_name IS NOT NULL THEN
1530: x_document := x_document||get_translated_attr_name('STAFFING_OWNER')||' - '||l_staffing_owner_name||'
';
1531: END IF;
1532:
1533: l_description := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1534: itemkey => p_item_key,
1535: aname => 'DESCRIPTION');
1536:
1537: --if the attribute has been updated then

Line 1543: l_append_description_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1539: IF l_description <> FND_API.G_MISS_CHAR AND l_description IS NOT NULL THEN
1540: x_document := x_document||get_translated_attr_name('DESCRIPTION')||' - '||l_description||'
';
1541: END IF;
1542:
1543: l_append_description_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1544: itemkey => p_item_key,
1545: aname => 'APPEND_DESCRIPTION_FLAG');
1546:
1547: l_additional_information := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1547: l_additional_information := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1543: l_append_description_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1544: itemkey => p_item_key,
1545: aname => 'APPEND_DESCRIPTION_FLAG');
1546:
1547: l_additional_information := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1548: itemkey => p_item_key,
1549: aname => 'ADDITIONAL_INFORMATION');
1550:
1551: --if the attribute has been updated then

Line 1557: l_append_information_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1553: IF l_additional_information <> FND_API.G_MISS_CHAR AND l_additional_information IS NOT NULL THEN
1554: x_document := x_document||get_translated_attr_name('ADDITIONAL_INFORMATION')||' - '||l_additional_information||'
';
1555: END IF;
1556:
1557: l_append_information_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1558: itemkey => p_item_key,
1559: aname => 'APPEND_INFORMATION_FLAG');
1560:
1561: l_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

Line 1561: l_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

1557: l_append_information_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1558: itemkey => p_item_key,
1559: aname => 'APPEND_INFORMATION_FLAG');
1560:
1561: l_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1562: itemkey => p_item_key,
1563: aname => 'START_DATE');
1564: x_start_date := l_start_date;
1565:

Line 1572: l_end_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

1568: IF l_start_date <> FND_API.G_MISS_DATE AND l_start_date IS NOT NULL THEN
1569: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_start_date||'
';
1570: END IF;
1571:
1572: l_end_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1573: itemkey => p_item_key,
1574: aname => 'END_DATE');
1575:
1576: x_end_date := l_end_date;

Line 1584: l_location_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1580: IF l_end_date <> FND_API.G_MISS_DATE AND l_end_date IS NOT NULL THEN
1581: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_end_date||'
';
1582: END IF;
1583:
1584: l_location_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1585: itemkey => p_item_key,
1586: aname => 'LOCATION_ID');
1587:
1588: l_location_city := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1588: l_location_city := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1584: l_location_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1585: itemkey => p_item_key,
1586: aname => 'LOCATION_ID');
1587:
1588: l_location_city := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1589: itemkey => p_item_key,
1590: aname => 'LOCATION_CITY');
1591:
1592: --if the attribute has been updated then

Line 1598: l_location_region := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1594: IF l_location_city <> FND_API.G_MISS_CHAR AND l_location_city IS NOT NULL THEN
1595: x_document := x_document||get_translated_attr_name('LOCATION_CITY')||' - '||l_location_city||'
';
1596: END IF;
1597:
1598: l_location_region := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1599: itemkey => p_item_key,
1600: aname => 'LOCATION_REGION');
1601:
1602: --if the attribute has been updated then

Line 1608: l_location_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1604: IF l_location_region <> FND_API.G_MISS_CHAR AND l_location_region IS NOT NULL THEN
1605: x_document := x_document||get_translated_attr_name('LOCATION_REGION')||' - '||l_location_region||'
';
1606: END IF;
1607:
1608: l_location_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1609: itemkey => p_item_key,
1610: aname => 'LOCATION_COUNTRY_NAME');
1611:
1612: --if the attribute has been updated then

Line 1618: l_location_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1614: IF l_location_country_name <> FND_API.G_MISS_CHAR AND l_location_country_name IS NOT NULL THEN
1615: x_document := x_document||get_translated_attr_name('LOCATION_COUNTRY_NAME')||' - '||l_location_country_name||'
';
1616: END IF;
1617:
1618: l_location_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1619: itemkey => p_item_key,
1620: aname => 'LOCATION_COUNTRY_CODE');
1621:
1622: l_calendar_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1622: l_calendar_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1618: l_location_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1619: itemkey => p_item_key,
1620: aname => 'LOCATION_COUNTRY_CODE');
1621:
1622: l_calendar_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1623: itemkey => p_item_key,
1624: aname => 'CALENDAR_TYPE');
1625:
1626: l_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1626: l_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1622: l_calendar_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1623: itemkey => p_item_key,
1624: aname => 'CALENDAR_TYPE');
1625:
1626: l_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1627: itemkey => p_item_key,
1628: aname => 'CALENDAR_ID');
1629:
1630: l_resource_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1630: l_resource_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1626: l_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1627: itemkey => p_item_key,
1628: aname => 'CALENDAR_ID');
1629:
1630: l_resource_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1631: itemkey => p_item_key,
1632: aname => 'RESOURCE_CALENDAR_PERCENT');
1633:
1634: l_project_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1634: l_project_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1630: l_resource_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1631: itemkey => p_item_key,
1632: aname => 'RESOURCE_CALENDAR_PERCENT');
1633:
1634: l_project_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1635: itemkey => p_item_key,
1636: aname => 'PROJECT_NAME');
1637:
1638: l_project_number := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1638: l_project_number := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1634: l_project_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1635: itemkey => p_item_key,
1636: aname => 'PROJECT_NAME');
1637:
1638: l_project_number := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1639: itemkey => p_item_key,
1640: aname => 'PROJECT_NUMBER');
1641:
1642: l_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1642: l_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1638: l_project_number := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1639: itemkey => p_item_key,
1640: aname => 'PROJECT_NUMBER');
1641:
1642: l_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1643: itemkey => p_item_key,
1644: aname => 'CALENDAR_NAME');
1645:
1646: l_expense_owner := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1646: l_expense_owner := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1642: l_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1643: itemkey => p_item_key,
1644: aname => 'CALENDAR_NAME');
1645:
1646: l_expense_owner := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1647: itemkey => p_item_key,
1648: aname => 'EXPENSE_OWNER');
1649:
1650: --if the attribute has been updated then

Line 1661: l_expense_limit := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1657: AND lookup_code = l_expense_owner;
1658: x_document := x_document||get_translated_attr_name('EXPENSE_OWNER')||' - '||l_expense_owner_meaning||'
';
1659: END IF;
1660:
1661: l_expense_limit := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1662: itemkey => p_item_key,
1663: aname => 'EXPENSE_LIMIT');
1664:
1665: --if the attribute has been updated then

Line 1671: l_expense_limit_currency_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1667: IF l_expense_limit <> FND_API.G_MISS_NUM AND l_expense_limit IS NOT NULL THEN
1668: x_document := x_document||get_translated_attr_name('EXPENSE_LIMIT')||' - '||l_expense_limit||'
';
1669: END IF;
1670:
1671: l_expense_limit_currency_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1672: itemkey => p_item_key,
1673: aname => 'EXPENSE_LIMIT_CURRENCY_CODE');
1674:
1675: l_comp_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1675: l_comp_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1671: l_expense_limit_currency_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1672: itemkey => p_item_key,
1673: aname => 'EXPENSE_LIMIT_CURRENCY_CODE');
1674:
1675: l_comp_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1676: itemkey => p_item_key,
1677: aname => 'COMP_MATCH_WEIGHTING');
1678:
1679: --if the attribute has been updated then

Line 1685: l_avail_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1681: IF l_comp_match_weighting <> FND_API.G_MISS_NUM AND l_comp_match_weighting IS NOT NULL THEN
1682: x_document := x_document||get_translated_attr_name('COMP_MATCH_WEIGHTING')||' - '||l_comp_match_weighting||'
';
1683: END IF;
1684:
1685: l_avail_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1686: itemkey => p_item_key,
1687: aname => 'AVAIL_MATCH_WEIGHTING');
1688:
1689: --if the attribute has been updated then

Line 1695: l_job_level_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1691: IF l_avail_match_weighting <> FND_API.G_MISS_NUM AND l_avail_match_weighting IS NOT NULL THEN
1692: x_document := x_document||get_translated_attr_name('AVAIL_MATCH_WEIGHTING')||' - '||l_avail_match_weighting||'
';
1693: END IF;
1694:
1695: l_job_level_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1696: itemkey => p_item_key,
1697: aname => 'JOB_LEVEL_MATCH_WEIGHTING');
1698:
1699: --if the attribute has been updated then

Line 1705: l_search_min_availability := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1701: IF l_job_level_match_weighting <> FND_API.G_MISS_NUM AND l_job_level_match_weighting IS NOT NULL THEN
1702: x_document := x_document||get_translated_attr_name('JOB_LEVEL_MATCH_WEIGHTING')||' - '||l_job_level_match_weighting||'
';
1703: END IF;
1704:
1705: l_search_min_availability := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1706: itemkey => p_item_key,
1707: aname => 'SEARCH_MIN_AVAILABILITY');
1708:
1709: --if the attribute has been updated then

Line 1715: l_search_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1711: IF l_search_min_availability <> FND_API.G_MISS_NUM AND l_search_min_availability IS NOT NULL THEN
1712: x_document := x_document||get_translated_attr_name('SEARCH_MIN_AVAILABILITY')||' - '||l_search_min_availability||'
';
1713: END IF;
1714:
1715: l_search_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1716: itemkey => p_item_key,
1717: aname => 'SEARCH_COUNTRY_CODE');
1718:
1719: l_search_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1719: l_search_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1715: l_search_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1716: itemkey => p_item_key,
1717: aname => 'SEARCH_COUNTRY_CODE');
1718:
1719: l_search_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1720: itemkey => p_item_key,
1721: aname => 'SEARCH_COUNTRY_NAME');
1722:
1723: --if the attribute has been updated then

Line 1729: l_search_exp_org_struct_ver_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1725: IF l_search_country_name <> FND_API.G_MISS_CHAR AND l_search_country_name IS NOT NULL THEN
1726: x_document := x_document||get_translated_attr_name('LOCATION_COUNTRY_NAME')||' - '||l_search_country_name||'
';
1727: END IF;
1728:
1729: l_search_exp_org_struct_ver_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1730: itemkey => p_item_key,
1731: aname => 'SEARCH_EXP_ORG_STRUCT_VER_ID');
1732:
1733: l_search_exp_org_hier_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1733: l_search_exp_org_hier_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1729: l_search_exp_org_struct_ver_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1730: itemkey => p_item_key,
1731: aname => 'SEARCH_EXP_ORG_STRUCT_VER_ID');
1732:
1733: l_search_exp_org_hier_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1734: itemkey => p_item_key,
1735: aname => 'SEARCH_EXP_ORG_HIER_NAME');
1736:
1737: --if the attribute has been updated then

Line 1743: l_search_exp_start_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1739: IF l_search_exp_org_hier_name <> FND_API.G_MISS_CHAR AND l_search_exp_org_hier_name IS NOT NULL THEN
1740: x_document := x_document||get_translated_attr_name('SEARCH_EXP_ORG_HIER_NAME')||' - '||l_search_exp_org_hier_name||'
';
1741: END IF;
1742:
1743: l_search_exp_start_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1744: itemkey => p_item_key,
1745: aname => 'SEARCH_EXP_START_ORG_ID');
1746:
1747: l_search_exp_start_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1747: l_search_exp_start_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1743: l_search_exp_start_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1744: itemkey => p_item_key,
1745: aname => 'SEARCH_EXP_START_ORG_ID');
1746:
1747: l_search_exp_start_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1748: itemkey => p_item_key,
1749: aname => 'SEARCH_EXP_START_ORG_NAME');
1750:
1751: --if the attribute has been updated then

Line 1757: l_search_min_candidate_score := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1753: IF l_search_exp_start_org_name <> FND_API.G_MISS_CHAR AND l_search_exp_start_org_name IS NOT NULL THEN
1754: x_document := x_document||get_translated_attr_name('SEARCH_EXP_START_ORG_NAME')||' - '||l_search_exp_start_org_name||'
';
1755: END IF;
1756:
1757: l_search_min_candidate_score := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1758: itemkey => p_item_key,
1759: aname => 'SEARCH_MIN_CANDIDATE_SCORE');
1760:
1761: --if the attribute has been updated then

Line 1767: L_ENABLE_AUTO_CAND_NOM_FLAG := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1763: IF l_search_min_candidate_score <> FND_API.G_MISS_NUM AND l_search_min_candidate_score IS NOT NULL THEN
1764: x_document := x_document||get_translated_attr_name('SEARCH_MIN_CANDIDATE_SCORE')||' - '||l_search_min_candidate_score||'
';
1765: END IF;
1766:
1767: L_ENABLE_AUTO_CAND_NOM_FLAG := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1768: itemkey => p_item_key,
1769: aname => 'ENABLE_AUTO_CAND_NOM_FLAG');
1770:
1771: --if the attribute has been updated then

Line 1783: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1779: END IF;
1780:
1781: ELSIF l_mode = G_MASS_UPDATE_FORECAST_ITEMS THEN
1782:
1783: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1784: itemkey => p_item_key,
1785: aname => 'WORK_TYPE_ID');
1786:
1787: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1787: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1783: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1784: itemkey => p_item_key,
1785: aname => 'WORK_TYPE_ID');
1786:
1787: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1788: itemkey => p_item_key,
1789: aname => 'WORK_TYPE_NAME');
1790:
1791: --if the attribute has been updated then

Line 1803: l_fcst_tp_amount_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1799: END IF;
1800: x_document := x_document||get_translated_attr_name('WORK_TYPE_NAME')||' - '||l_work_type_name||'
';
1801: END IF;
1802:
1803: l_fcst_tp_amount_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1804: itemkey => p_item_key,
1805: aname => 'FCST_TP_AMOUNT_TYPE');
1806:
1807: --if the attribute has been updated then

Line 1818: l_fcst_job_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1814: AND lookup_code = l_fcst_tp_amount_type;
1815: x_document := x_document||get_translated_attr_name('FCST_TP_AMOUNT_TYPE')||' - '||l_fcst_tp_amount_type_meaning||'
';
1816: END IF;
1817:
1818: l_fcst_job_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1819: itemkey => p_item_key,
1820: aname => 'FCST_JOB_ID');
1821:
1822: l_fcst_job_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1822: l_fcst_job_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1818: l_fcst_job_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1819: itemkey => p_item_key,
1820: aname => 'FCST_JOB_ID');
1821:
1822: l_fcst_job_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1823: itemkey => p_item_key,
1824: aname => 'FCST_JOB_NAME');
1825:
1826: --if the attribute has been updated then

Line 1832: l_fcst_job_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1828: IF l_fcst_job_name <> FND_API.G_MISS_CHAR AND l_fcst_job_name IS NOT NULL THEN
1829: x_document := x_document||get_translated_attr_name('FCST_JOB_NAME')||' - '||l_fcst_job_name||'
';
1830: END IF;
1831:
1832: l_fcst_job_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1833: itemkey => p_item_key,
1834: aname => 'FCST_JOB_GROUP_ID');
1835:
1836: l_fcst_job_group_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1836: l_fcst_job_group_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1832: l_fcst_job_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1833: itemkey => p_item_key,
1834: aname => 'FCST_JOB_GROUP_ID');
1835:
1836: l_fcst_job_group_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1837: itemkey => p_item_key,
1838: aname => 'FCST_JOB_GROUP_NAME');
1839:
1840: --if the attribute has been updated then

Line 1846: l_expenditure_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1842: IF l_fcst_job_group_name <> FND_API.G_MISS_CHAR AND l_fcst_job_group_name IS NOT NULL THEN
1843: x_document := x_document||get_translated_attr_name('FCST_JOB_GROUP_NAME')||' - '||l_fcst_job_group_name||'
';
1844: END IF;
1845:
1846: l_expenditure_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1847: itemkey => p_item_key,
1848: aname => 'EXPENDITURE_ORG_ID');
1849:
1850: l_expenditure_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1850: l_expenditure_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1846: l_expenditure_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1847: itemkey => p_item_key,
1848: aname => 'EXPENDITURE_ORG_ID');
1849:
1850: l_expenditure_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1851: itemkey => p_item_key,
1852: aname => 'EXPENDITURE_ORG_NAME');
1853:
1854: --if the attribute has been updated then

Line 1860: l_expenditure_organization_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1856: IF l_expenditure_org_name <> FND_API.G_MISS_CHAR AND l_expenditure_org_name IS NOT NULL THEN
1857: x_document := x_document||get_translated_attr_name('EXPENDITURE_ORG_NAME')||' - '||l_expenditure_org_name||'
';
1858: END IF;
1859:
1860: l_expenditure_organization_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1861: itemkey => p_item_key,
1862: aname => 'EXPENDITURE_ORGANIZATION_ID');
1863:
1864: l_exp_organization_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1864: l_exp_organization_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1860: l_expenditure_organization_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1861: itemkey => p_item_key,
1862: aname => 'EXPENDITURE_ORGANIZATION_ID');
1863:
1864: l_exp_organization_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1865: itemkey => p_item_key,
1866: aname => 'EXP_ORGANIZATION_NAME');
1867:
1868: --if the attribute has been updated then

Line 1874: l_expenditure_type_class := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1870: IF l_exp_organization_name <> FND_API.G_MISS_CHAR AND l_exp_organization_name IS NOT NULL THEN
1871: x_document := x_document||get_translated_attr_name('EXP_ORGANIZATION_NAME')||' - '||l_exp_organization_name||'
';
1872: END IF;
1873:
1874: l_expenditure_type_class := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1875: itemkey => p_item_key,
1876: aname => 'EXPENDITURE_TYPE_CLASS');
1877:
1878: l_expenditure_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1878: l_expenditure_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1874: l_expenditure_type_class := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1875: itemkey => p_item_key,
1876: aname => 'EXPENDITURE_TYPE_CLASS');
1877:
1878: l_expenditure_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1879: itemkey => p_item_key,
1880: aname => 'EXPENDITURE_TYPE');
1881:
1882: --if the attribute has been updated then

Line 1892: l_exception_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1888:
1889: ELSIF l_mode = G_MASS_UPDATE_SCHEDULE THEN
1890:
1891:
1892: l_exception_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1893: itemkey => p_item_key,
1894: aname => 'EXCEPTION_TYPE_CODE');
1895:
1896: l_change_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

Line 1896: l_change_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

1892: l_exception_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1893: itemkey => p_item_key,
1894: aname => 'EXCEPTION_TYPE_CODE');
1895:
1896: l_change_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1897: itemkey => p_item_key,
1898: aname => 'CHANGE_START_DATE');
1899:
1900: IF l_exception_type_code = 'CHANGE_DURATION' THEN

Line 1908: l_change_end_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

1904: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_change_start_date||'
';
1905: END IF;
1906: END IF;
1907:
1908: l_change_end_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1909: itemkey => p_item_key,
1910: aname => 'CHANGE_END_DATE');
1911:
1912: IF l_exception_type_code = 'CHANGE_DURATION' THEN

Line 1920: l_change_rqmt_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1916: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_change_end_date||'
';
1917: END IF;
1918: END IF;
1919:
1920: l_change_rqmt_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1921: itemkey => p_item_key,
1922: aname => 'CHANGE_RQMT_STATUS_CODE');
1923:
1924: IF l_change_rqmt_status_code <> FND_API.G_MISS_CHAR THEN

Line 1935: l_change_asgmt_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

1931: x_document := x_document||get_translated_attr_name('STATUS_NAME')||' - '||l_project_status_name||'
';
1932:
1933: END IF;
1934:
1935: l_change_asgmt_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1936: itemkey => p_item_key,
1937: aname => 'CHANGE_ASGMT_STATUS_CODE');
1938:
1939: --if the attribute has been updated then

Line 1951: l_num_of_sch_periods := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1947: x_document := x_document||get_translated_attr_name('STATUS_NAME')||' - '||l_project_status_name||'
';
1948: END IF;
1949:
1950: -- Multi-period Work Pattern Updates
1951: l_num_of_sch_periods := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1952: itemkey => p_item_key,
1953: aname => 'NUM_OF_SCH_PERIODS');
1954: IF l_num_of_sch_periods > 0 THEN
1955:

Line 1968: l_change_start_date_tbl(j) := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

1964: l_sunday_hours_tbl.EXTEND(l_num_of_sch_periods);
1965:
1966: FOR j IN 1 .. l_num_of_sch_periods LOOP
1967:
1968: l_change_start_date_tbl(j) := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1969: itemkey => p_item_key,
1970: aname => 'CHANGE_START_DATE'||j);
1971:
1972: --if the attribute has been updated then

Line 1978: l_change_end_date_tbl(j) := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

1974: IF l_change_start_date_tbl(j) <> FND_API.G_MISS_DATE THEN
1975: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_change_start_date_tbl(j)||'
';
1976: END IF;
1977:
1978: l_change_end_date_tbl(j) := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1979: itemkey => p_item_key,
1980: aname => 'CHANGE_END_DATE'||j);
1981:
1982: --if the attribute has been updated then

Line 1988: l_monday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1984: IF l_change_end_date_tbl(j) <> FND_API.G_MISS_DATE THEN
1985: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_change_end_date_tbl(j)||'
';
1986: END IF;
1987:
1988: l_monday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1989: itemkey => p_item_key,
1990: aname => 'MONDAY_HOURS'||j);
1991:
1992: --if the attribute has been updated then

Line 1998: l_tuesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

1994: IF l_monday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_monday_hours_tbl(j) IS NOT NULL THEN
1995: x_document := x_document||get_translated_attr_name('MONDAY_HOURS')||' - '||l_monday_hours_tbl(j)||'
';
1996: END IF;
1997:
1998: l_tuesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1999: itemkey => p_item_key,
2000: aname => 'TUESDAY_HOURS'||j);
2001:
2002: --if the attribute has been updated then

Line 2008: l_wednesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2004: IF l_tuesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_tuesday_hours_tbl(j) IS NOT NULL THEN
2005: x_document := x_document||get_translated_attr_name('TUESDAY_HOURS')||' - '||l_tuesday_hours_tbl(j)||'
';
2006: END IF;
2007:
2008: l_wednesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2009: itemkey => p_item_key,
2010: aname => 'WEDNESDAY_HOURS'||j);
2011:
2012: --if the attribute has been updated then

Line 2018: l_thursday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2014: IF l_wednesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_wednesday_hours_tbl(j) IS NOT NULL THEN
2015: x_document := x_document||get_translated_attr_name('WEDNESDAY_HOURS')||' - '||l_wednesday_hours_tbl(j)||'
';
2016: END IF;
2017:
2018: l_thursday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2019: itemkey => p_item_key,
2020: aname => 'THURSDAY_HOURS'||j);
2021:
2022: --if the attribute has been updated then

Line 2028: l_friday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2024: IF l_thursday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_thursday_hours_tbl(j) IS NOT NULL THEN
2025: x_document := x_document||get_translated_attr_name('THURSDAY_HOURS')||' - '||l_thursday_hours_tbl(j)||'
';
2026: END IF;
2027:
2028: l_friday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2029: itemkey => p_item_key,
2030: aname => 'FRIDAY_HOURS'||j);
2031:
2032: --if the attribute has been updated then

Line 2038: l_saturday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2034: IF l_friday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_friday_hours_tbl(j) IS NOT NULL THEN
2035: x_document := x_document||get_translated_attr_name('FRIDAY_HOURS')||' - '||l_friday_hours_tbl(j)||'
';
2036: END IF;
2037:
2038: l_saturday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2039: itemkey => p_item_key,
2040: aname => 'SATURDAY_HOURS'||j);
2041:
2042: --if the attribute has been updated then

Line 2048: l_sunday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2044: IF l_saturday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_saturday_hours_tbl(j) IS NOT NULL THEN
2045: x_document := x_document||get_translated_attr_name('SATURDAY_HOURS')||' - '||l_saturday_hours_tbl(j)||'
';
2046: END IF;
2047:
2048: l_sunday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2049: itemkey => p_item_key,
2050: aname => 'SUNDAY_HOURS'||j);
2051:
2052: --if the attribute has been updated then

Line 2061: l_non_working_day_flag := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2057:
2058: END LOOP;
2059: END IF; -- End if for muti-period work pattern updates
2060:
2061: l_non_working_day_flag := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2062: itemkey => p_item_key,
2063: aname => 'NON_WORKING_DAY_FLAG');
2064:
2065: l_change_hours_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2065: l_change_hours_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2061: l_non_working_day_flag := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2062: itemkey => p_item_key,
2063: aname => 'NON_WORKING_DAY_FLAG');
2064:
2065: l_change_hours_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2066: itemkey => p_item_key,
2067: aname => 'CHANGE_HOURS_TYPE_CODE');
2068:
2069: l_hrs_per_day := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2069: l_hrs_per_day := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2065: l_change_hours_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2066: itemkey => p_item_key,
2067: aname => 'CHANGE_HOURS_TYPE_CODE');
2068:
2069: l_hrs_per_day := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2070: itemkey => p_item_key,
2071: aname => 'HRS_PER_DAY');
2072:
2073: --if the attribute has been updated then

Line 2079: l_change_calendar_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2075: IF l_hrs_per_day <> FND_API.G_MISS_NUM AND l_hrs_per_day IS NOT NULL THEN
2076: x_document := x_document||get_translated_attr_name('HRS_PER_DAY')||' - '||l_hrs_per_day||'
';
2077: END IF;
2078:
2079: l_change_calendar_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2080: itemkey => p_item_key,
2081: aname => 'CHANGE_CALENDAR_TYPE_CODE');
2082:
2083: l_change_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2083: l_change_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2079: l_change_calendar_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2080: itemkey => p_item_key,
2081: aname => 'CHANGE_CALENDAR_TYPE_CODE');
2082:
2083: l_change_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2084: itemkey => p_item_key,
2085: aname => 'CHANGE_CALENDAR_NAME');
2086:
2087: IF l_change_calendar_name <> FND_API.G_MISS_CHAR and l_change_calendar_name IS NOT NULL THEN

Line 2091: l_change_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2087: IF l_change_calendar_name <> FND_API.G_MISS_CHAR and l_change_calendar_name IS NOT NULL THEN
2088: l_calendar_display := ': '||l_change_calendar_name;
2089: END IF;
2090:
2091: l_change_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2092: itemkey => p_item_key,
2093: aname => 'CHANGE_CALENDAR_ID');
2094:
2095: l_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2095: l_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2091: l_change_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2092: itemkey => p_item_key,
2093: aname => 'CHANGE_CALENDAR_ID');
2094:
2095: l_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2096: itemkey => p_item_key,
2097: aname => 'CALENDAR_PERCENT');
2098:
2099: --if the attribute has been updated then

Line 2106: l_duration_shift_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2102: x_document := x_document||get_translated_attr_name('CALENDAR_PERCENT')||': '||get_translated_attr_name(l_change_calendar_type_code||'_CALENDAR')||l_calendar_display||' - '||l_calendar_percent||'
';
2103: END IF;
2104:
2105:
2106: l_duration_shift_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2107: itemkey => p_item_key,
2108: aname => 'DURATION_SHIFT_TYPE_CODE');
2109:
2110: l_duration_shift_unit_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2110: l_duration_shift_unit_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2106: l_duration_shift_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2107: itemkey => p_item_key,
2108: aname => 'DURATION_SHIFT_TYPE_CODE');
2109:
2110: l_duration_shift_unit_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2111: itemkey => p_item_key,
2112: aname => 'DURATION_SHIFT_UNIT_CODE');
2113:
2114: l_num_of_shift := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2114: l_num_of_shift := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2110: l_duration_shift_unit_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2111: itemkey => p_item_key,
2112: aname => 'DURATION_SHIFT_UNIT_CODE');
2113:
2114: l_num_of_shift := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2115: itemkey => p_item_key,
2116: aname => 'NUM_OF_SHIFT');
2117:
2118: IF l_num_of_shift <> FND_API.G_MISS_NUM AND l_num_of_shift IS NOT NULL THEN

Line 2124: l_number_of_competencies := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2120: END IF;
2121:
2122: ELSIF l_mode = G_MASS_UPDATE_COMPETENCIES THEN
2123:
2124: l_number_of_competencies := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2125: itemkey => p_item_key,
2126: aname => 'NUMBER_OF_COMPETENCIES');
2127:
2128: IF l_number_of_competencies > 0 THEN

Line 2138: l_competence_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2134: l_mandatory_flag_tbl.EXTEND(l_number_of_competencies);
2135:
2136: FOR i IN 1 .. l_number_of_competencies LOOP
2137:
2138: l_competence_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2139: itemkey => p_item_key,
2140: aname => 'COMPETENCE_ID'||i);
2141:
2142: l_competence_name_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2142: l_competence_name_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2138: l_competence_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2139: itemkey => p_item_key,
2140: aname => 'COMPETENCE_ID'||i);
2141:
2142: l_competence_name_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2143: itemkey => p_item_key,
2144: aname => 'COMPETENCE_NAME'||i);
2145:
2146: l_competence_alias_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2146: l_competence_alias_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2142: l_competence_name_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2143: itemkey => p_item_key,
2144: aname => 'COMPETENCE_NAME'||i);
2145:
2146: l_competence_alias_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2147: itemkey => p_item_key,
2148: aname => 'COMPETENCE_ALIAS'||i);
2149:
2150: l_rating_level_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2150: l_rating_level_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2146: l_competence_alias_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2147: itemkey => p_item_key,
2148: aname => 'COMPETENCE_ALIAS'||i);
2149:
2150: l_rating_level_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2151: itemkey => p_item_key,
2152: aname => 'RATING_LEVEL_ID'||i);
2153:
2154: --if rating level id is not null then get the actual rating level

Line 2162: l_mandatory_flag_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2158: FROM per_rating_levels_v
2159: WHERE rating_level_id = l_rating_level_id_tbl(i);
2160: END IF;
2161:
2162: l_mandatory_flag_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2163: itemkey => p_item_key,
2164: aname => 'MANDATORY_FLAG'||i);
2165:
2166: --if mandatory_flag is not null then get the meaning

Line 2269: WF_ENGINE.SetItemAttrText(itemtype => p_item_type,

2265: CLOSE csr_get_tp_amt_type;
2266:
2267: END IF;
2268:
2269: WF_ENGINE.SetItemAttrText(itemtype => p_item_type,
2270: itemkey => p_item_key,
2271: aname => 'TP_AMT_TYPE_NAME',
2272: avalue => l_tp_amt_type_name);
2273:

Line 2539: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2535:
2536: BEGIN
2537:
2538: --get the mode and action for this wf process
2539: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2540: itemkey => p_item_key,
2541: aname => 'MODE');
2542:
2543: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2543: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2539: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2540: itemkey => p_item_key,
2541: aname => 'MODE');
2542:
2543: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2544: itemkey => p_item_key,
2545: aname => 'ACTION');
2546:
2547: l_num_success_assignments := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2547: l_num_success_assignments := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2543: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2544: itemkey => p_item_key,
2545: aname => 'ACTION');
2546:
2547: l_num_success_assignments := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2548: itemkey => p_item_key,
2549: aname => 'NUM_SUCCESS_ASSIGNMENTS');
2550:
2551: --if the assignments in this process are to be submitted then

Line 2559: l_conflict_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2555: --get the conflict group id
2556: --this is used to filter out the assignments that the user chose to
2557: --cancel or revert due to overcommitment and not to pass them on to
2558: --be submitted.
2559: l_conflict_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2560: itemkey => p_item_key,
2561: aname => 'CONFLICT_GROUP_ID');
2562:
2563:

Line 2596: l_appr_over_auth_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2592: --the approval attributes.
2593: IF l_assignment_id_tbl.COUNT > 0 THEN
2594:
2595:
2596: l_appr_over_auth_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2597: itemkey => p_item_key,
2598: aname => 'APPR_OVER_AUTH_FLAG');
2599:
2600: l_note_to_all_approvers := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2600: l_note_to_all_approvers := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2596: l_appr_over_auth_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2597: itemkey => p_item_key,
2598: aname => 'APPR_OVER_AUTH_FLAG');
2599:
2600: l_note_to_all_approvers := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2601: itemkey => p_item_key,
2602: aname => 'NOTE_TO_ALL_APPROVERS');
2603:
2604: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2604: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2600: l_note_to_all_approvers := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2601: itemkey => p_item_key,
2602: aname => 'NOTE_TO_ALL_APPROVERS');
2603:
2604: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2605: itemkey => p_item_key,
2606: aname => 'PROJECT_ID');
2607:
2608: l_document := WF_ENGINE.GetItemAttrDocument(itemtype => p_item_type,

Line 2608: l_document := WF_ENGINE.GetItemAttrDocument(itemtype => p_item_type,

2604: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2605: itemkey => p_item_key,
2606: aname => 'PROJECT_ID');
2607:
2608: l_document := WF_ENGINE.GetItemAttrDocument(itemtype => p_item_type,
2609: itemkey => p_item_key,
2610: aname => ' UPDATED_INFORMATION_DOCUMENT',
2611: ignore_notfound => TRUE);
2612:

Line 2613: l_submitter_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2609: itemkey => p_item_key,
2610: aname => ' UPDATED_INFORMATION_DOCUMENT',
2611: ignore_notfound => TRUE);
2612:
2613: l_submitter_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2614: itemkey => p_item_key,
2615: aname => 'SUBMITTER_USER_ID');
2616:
2617: --call the submit for approval API.

Line 2668: l_conflict_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2664: --from the View Conflicts page from the notification to the submitter the
2665: --submitter may choose to cancel or revert certain assignments.
2666: --this API is called after the user has taken action on conflicts and
2667: --closed the notification in order to cancel or revert those assignments.
2668: l_conflict_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2669: itemkey => p_item_key,
2670: aname => 'CONFLICT_GROUP_ID');
2671:
2672: --set mass_wf_in_progress_flag = 'N' for those assignments to be canceled

Line 2764: l_conflict_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

2760: BEGIN
2761:
2762: IF p_funcmode = 'RESPOND' THEN
2763:
2764: l_conflict_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2765: itemkey => p_item_key,
2766: aname => 'CONFLICT_GROUP_ID');
2767:
2768: PA_SCHEDULE_PVT.Has_Action_Taken_On_Conflicts(p_conflict_group_id => l_conflict_group_id,

Line 2810: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2806: l_mode VARCHAR2(30);
2807:
2808: BEGIN
2809:
2810: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2811: itemkey => p_item_key,
2812: aname => 'MODE');
2813:
2814:

Line 2870: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2866: --but we commit 1 at a time, so some of the transactions
2867: --may be complete - so we are only aborting the ones that are not yet processed.
2868:
2869: --get the following wf attributes for the process that errored out.
2870: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2871: itemkey => p_item_key,
2872: aname => 'ERROR_ITEM_TYPE');
2873:
2874: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2874: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2870: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2871: itemkey => p_item_key,
2872: aname => 'ERROR_ITEM_TYPE');
2873:
2874: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2875: itemkey => p_item_key,
2876: aname => 'ERROR_ITEM_KEY');
2877:
2878: l_mode := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

Line 2878: l_mode := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

2874: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2875: itemkey => p_item_key,
2876: aname => 'ERROR_ITEM_KEY');
2877:
2878: l_mode := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2879: itemkey => l_error_item_key,
2880: aname => 'MODE');
2881:
2882: l_submitter_user_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

Line 2882: l_submitter_user_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

2878: l_mode := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2879: itemkey => l_error_item_key,
2880: aname => 'MODE');
2881:
2882: l_submitter_user_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2883: itemkey => l_error_item_key,
2884: aname => 'SUBMITTER_USER_ID');
2885:
2886: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

Line 2886: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

2882: l_submitter_user_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2883: itemkey => l_error_item_key,
2884: aname => 'SUBMITTER_USER_ID');
2885:
2886: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2887: itemkey => l_error_item_key,
2888: aname => 'PROJECT_ID');
2889:
2890: --set process_status_code to 'A' for the pending items.

Line 2980: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2976: BEGIN
2977:
2978:
2979: --get the following wf attributes for the process that errored out.
2980: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2981: itemkey => p_item_key,
2982: aname => 'ERROR_ITEM_TYPE');
2983:
2984: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2984: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

2980: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2981: itemkey => p_item_key,
2982: aname => 'ERROR_ITEM_TYPE');
2983:
2984: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2985: itemkey => p_item_key,
2986: aname => 'ERROR_ITEM_KEY');
2987:
2988: l_submitter_user_name := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

Line 2988: l_submitter_user_name := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

2984: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2985: itemkey => p_item_key,
2986: aname => 'ERROR_ITEM_KEY');
2987:
2988: l_submitter_user_name := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2989: itemkey => l_error_item_key,
2990: aname => 'SUBMITTER_USER_NAME');
2991:
2992: --SET the Text item attributes (these attributes were created at design time)

Line 2993: WF_ENGINE.SetItemAttrText(itemtype => p_item_type,

2989: itemkey => l_error_item_key,
2990: aname => 'SUBMITTER_USER_NAME');
2991:
2992: --SET the Text item attributes (these attributes were created at design time)
2993: WF_ENGINE.SetItemAttrText(itemtype => p_item_type,
2994: itemkey => p_item_key,
2995: aname => 'SUBMITTER_USER_NAME',
2996: avalue => l_submitter_user_name);
2997: --4537865 :Included Exception block