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 161: l_save_threshold := wf_engine.threshold;

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

Line 163: IF wf_engine.threshold < 0 THEN

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

Line 164: wf_engine.threshold := l_save_threshold;

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

Line 166: wf_engine.threshold := -1;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 733: wf_engine.threshold := l_save_threshold;

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

Line 750: wf_engine.threshold := l_save_threshold;

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

Line 784: l_text_attr_name_tbl Wf_Engine.NameTabTyp;

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

Line 785: l_text_attr_value_tbl Wf_Engine.TextTabTyp;

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

Line 786: l_num_attr_name_tbl Wf_Engine.NameTabTyp;

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

Line 787: l_num_attr_value_tbl Wf_Engine.NumTabTyp;

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

Line 788: l_add_num_attr_name_tbl Wf_Engine.NameTabTyp;

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

Line 789: l_add_num_attr_value_tbl Wf_Engine.NumTabTyp;

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

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

844: WHERE item_type = p_item_type
845: AND item_key = p_item_key
846: AND process_status_code = 'P';
847:
848: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
849: itemkey => p_item_key,
850: aname => 'MODE');
851:
852: --if this is a mass assignment then assign the resource id tbl to the object id tbl.

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

894: --successfully created / updated then do the following to
895: --check overcommitment.
896: IF l_action <> G_SAVE AND l_success_assignments > 0 THEN
897:
898: l_resolve_con_action_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
899: itemkey => p_item_key,
900: aname => 'RESOLVE_CONFLICT_ACTION_CODE');
901:
902:

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

1016:
1017: IF (l_mode = G_MASS_SUBMIT_FOR_APPROVAL OR l_action = G_SAVE_AND_SUBMIT) AND -- Bug 9430922
1018: l_success_assignments > 0 THEN
1019: -- Bug 9114634
1020: l_note_to_all_approvers := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1021: itemkey => p_item_key,
1022: aname => 'NOTE_TO_ALL_APPROVERS');
1023: END IF;
1024:

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

1188:
1189: END IF;
1190:
1191: --dynamically create and set the Number item attributes
1192: WF_ENGINE.AddItemAttrNumberArray(itemtype => p_item_type,
1193: itemkey => p_item_key,
1194: aname => l_add_num_attr_name_tbl,
1195: avalue => l_add_num_attr_value_tbl);
1196: --set the wf item attributes.

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

1193: itemkey => p_item_key,
1194: aname => l_add_num_attr_name_tbl,
1195: avalue => l_add_num_attr_value_tbl);
1196: --set the wf item attributes.
1197: WF_ENGINE.SetItemAttrTextArray(itemtype => p_item_type,
1198: itemkey => p_item_key,
1199: aname => l_text_attr_name_tbl,
1200: avalue => l_text_attr_value_tbl);
1201:

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

1198: itemkey => p_item_key,
1199: aname => l_text_attr_name_tbl,
1200: avalue => l_text_attr_value_tbl);
1201:
1202: WF_ENGINE.SetItemAttrNumberArray(itemtype => p_item_type,
1203: itemkey => p_item_key,
1204: aname => l_num_attr_name_tbl,
1205: avalue => l_num_attr_value_tbl);
1206:

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

1208: --of the mass update wf notification.
1209: --see the mass_asgmt_autonomous_trx API for more information.
1210: --also refer to the Oracle Workflow documentation for information
1211: --regarding Document types.
1212: WF_ENGINE.SetItemAttrDocument(itemtype => p_item_type,
1213: itemkey => p_item_key,
1214: aname => 'UPDATED_INFORMATION_DOCUMENT',
1215: documentid => SubStrB('plsql:PA_MASS_ASGMT_TRX.Display_Updated_Attributes/' ||l_document,1,4000));
1216: -- bug#9786779

Line 1364: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;

1360: l_duration_shift_unit_code VARCHAR2(30);
1361: l_num_of_shift NUMBER;
1362: l_success_assignments NUMBER;
1363: l_failure_assignments NUMBER;
1364: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1365: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1366: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1367: l_project_customer pa_project_lists_v.customer_name%TYPE;
1368: l_project_manager pa_project_lists_v.person_name%TYPE;

Line 1365: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;

1361: l_num_of_shift NUMBER;
1362: l_success_assignments NUMBER;
1363: l_failure_assignments NUMBER;
1364: l_success_asgmt_name_tbl Wf_Engine.NameTabTyp;
1365: l_success_asgmt_val_tbl Wf_Engine.NumTabTyp;
1366: l_project_organization pa_project_lists_v.carrying_out_organization_name%TYPE;
1367: l_project_customer pa_project_lists_v.customer_name%TYPE;
1368: l_project_manager pa_project_lists_v.person_name%TYPE;
1369: l_err_code VARCHAR2(2000);

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

1403: --id is passed in - it must be valid.
1404: PA_STARTUP.G_Check_ID_Flag := 'N';
1405:
1406: --retrieve the number of assignments attribute
1407: l_submitter_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1408: itemkey => p_item_key,
1409: aname => 'SUBMITTER_USER_ID');
1410:
1411: l_submitter_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1407: l_submitter_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1408: itemkey => p_item_key,
1409: aname => 'SUBMITTER_USER_ID');
1410:
1411: l_submitter_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1412: itemkey => p_item_key,
1413: aname => 'SUBMITTER_RESP_ID');
1414:
1415: l_submitter_resp_appl_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1411: l_submitter_resp_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1412: itemkey => p_item_key,
1413: aname => 'SUBMITTER_RESP_ID');
1414:
1415: l_submitter_resp_appl_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1416: itemkey => p_item_key,
1417: aname => 'SUBMITTER_RESP_APPL_ID');
1418:
1419: FND_GLOBAL.Apps_Initialize ( user_id => l_submitter_user_id

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

1425: PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID := l_submitter_user_id;
1426: PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY := p_item_key;
1427:
1428: --get the following wf item attributes regardless of the mode
1429: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1430: itemkey => p_item_key,
1431: aname => 'MODE');
1432: x_mode := l_mode;
1433:

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

1430: itemkey => p_item_key,
1431: aname => 'MODE');
1432: x_mode := l_mode;
1433:
1434: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1435: itemkey => p_item_key,
1436: aname => 'ACTION');
1437: x_action := l_action;
1438:

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

1436: aname => 'ACTION');
1437: x_action := l_action;
1438:
1439:
1440: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1441: itemkey => p_item_key,
1442: aname => 'PROJECT_ID');
1443: x_project_id := l_project_id;
1444:

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

1448: --if the mode is mass assignment or mass update basic info then get the
1449: --following attributes.
1450: IF l_mode = G_MASS_ASGMT OR l_mode = G_MASS_UPDATE_ASGMT_BASIC_INFO THEN
1451:
1452: l_assignment_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1453: itemkey => p_item_key,
1454: aname => 'ASSIGNMENT_NAME');
1455:
1456: --if the attribute has been updated then

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

1458: IF l_assignment_name <> FND_API.G_MISS_CHAR AND l_assignment_name IS NOT NULL THEN
1459: x_document := x_document||get_translated_attr_name('ASSIGNMENT_NAME')||' - '||l_assignment_name||'
';
1460: END IF;
1461:
1462: l_wf_assignment_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1463: itemkey => p_item_key,
1464: aname => 'ASSIGNMENT_TYPE');
1465:
1466: l_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1462: l_wf_assignment_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1463: itemkey => p_item_key,
1464: aname => 'ASSIGNMENT_TYPE');
1465:
1466: l_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1467: itemkey => p_item_key,
1468: aname => 'STATUS_CODE');
1469:
1470: l_project_status_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1466: l_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1467: itemkey => p_item_key,
1468: aname => 'STATUS_CODE');
1469:
1470: l_project_status_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1471: itemkey => p_item_key,
1472: aname => 'PROJECT_STATUS_NAME');
1473:
1474: l_multiple_status_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1470: l_project_status_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1471: itemkey => p_item_key,
1472: aname => 'PROJECT_STATUS_NAME');
1473:
1474: l_multiple_status_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1475: itemkey => p_item_key,
1476: aname => 'MULTIPLE_STATUS_FLAG');
1477:
1478: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1474: l_multiple_status_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1475: itemkey => p_item_key,
1476: aname => 'MULTIPLE_STATUS_FLAG');
1477:
1478: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1479: itemkey => p_item_key,
1480: aname => 'WORK_TYPE_ID');
1481:
1482: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1478: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1479: itemkey => p_item_key,
1480: aname => 'WORK_TYPE_ID');
1481:
1482: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1483: itemkey => p_item_key,
1484: aname => 'WORK_TYPE_NAME');
1485:
1486: l_staffing_priority_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1482: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1483: itemkey => p_item_key,
1484: aname => 'WORK_TYPE_NAME');
1485:
1486: l_staffing_priority_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1487: itemkey => p_item_key,
1488: aname => 'STAFFING_PRIORITY_CODE');
1489:
1490: l_staffing_priority_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1486: l_staffing_priority_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1487: itemkey => p_item_key,
1488: aname => 'STAFFING_PRIORITY_CODE');
1489:
1490: l_staffing_priority_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1491: itemkey => p_item_key,
1492: aname => 'STAFFING_PRIORITY_NAME');
1493:
1494: --if the attribute has been updated then

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

1503: END IF;
1504: x_document := x_document||get_translated_attr_name('STAFFING_PRIORITY_NAME')||' - '||l_staffing_priority_name||'
';
1505: END IF;
1506:
1507: l_project_role_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1508: itemkey => p_item_key,
1509: aname => 'PROJECT_ROLE_ID');
1510:
1511: l_project_role_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1507: l_project_role_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1508: itemkey => p_item_key,
1509: aname => 'PROJECT_ROLE_ID');
1510:
1511: l_project_role_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1512: itemkey => p_item_key,
1513: aname => 'PROJECT_ROLE_NAME');
1514:
1515: l_role_list_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1511: l_project_role_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1512: itemkey => p_item_key,
1513: aname => 'PROJECT_ROLE_NAME');
1514:
1515: l_role_list_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1516: itemkey => p_item_key,
1517: aname => 'ROLE_LIST_ID');
1518:
1519: l_project_subteam_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1515: l_role_list_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1516: itemkey => p_item_key,
1517: aname => 'ROLE_LIST_ID');
1518:
1519: l_project_subteam_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1520: itemkey => p_item_key,
1521: aname => 'PROJECT_SUBTEAM_ID');
1522:
1523: l_project_subteam_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

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

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

1535: END IF;
1536: x_document := x_document||get_translated_attr_name('PROJECT_SUBTEAM_NAME')||' - '||l_project_subteam_name||'
';
1537: END IF;
1538:
1539: l_extension_possible := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1540: itemkey => p_item_key,
1541: aname => 'EXTENSION_POSSIBLE');
1542:
1543:

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

1551: AND lookup_code = l_extension_possible;
1552: x_document := x_document||get_translated_attr_name('EXTENSION_POSSIBLE')||' - '||l_extension_possible_meaning||'
';
1553: END IF;
1554:
1555: l_min_resource_job_level := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1556: itemkey => p_item_key,
1557: aname => 'MIN_RESOURCE_JOB_LEVEL');
1558:
1559: --if the attribute has been updated then

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

1561: IF l_min_resource_job_level <> FND_API.G_MISS_NUM AND l_min_resource_job_level IS NOT NULL THEN
1562: x_document := x_document||get_translated_attr_name('MIN_RESOURCE_JOB_LEVEL')||' - '||l_min_resource_job_level||'
';
1563: END IF;
1564:
1565: l_max_resource_job_level := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1566: itemkey => p_item_key,
1567: aname => 'MAX_RESOURCE_JOB_LEVEL');
1568:
1569: --if the attribute has been updated then

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

1572: x_document := x_document||get_translated_attr_name('MAX_RESOURCE_JOB_LEVEL')||' - '||l_max_resource_job_level||'
';
1573: END IF;
1574:
1575: -- FP.L Development
1576: l_staffing_owner_person_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1577: itemkey => p_item_key,
1578: aname => 'STAFFING_OWNER_PERSON_ID');
1579:
1580: l_staffing_owner_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1576: l_staffing_owner_person_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1577: itemkey => p_item_key,
1578: aname => 'STAFFING_OWNER_PERSON_ID');
1579:
1580: l_staffing_owner_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1581: itemkey => p_item_key,
1582: aname => 'STAFFING_OWNER_NAME');
1583:
1584: --if the attribute has been updated then

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

1586: IF l_staffing_owner_name <> FND_API.G_MISS_CHAR AND l_staffing_owner_name IS NOT NULL THEN
1587: x_document := x_document||get_translated_attr_name('STAFFING_OWNER')||' - '||l_staffing_owner_name||'
';
1588: END IF;
1589:
1590: l_description := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1591: itemkey => p_item_key,
1592: aname => 'DESCRIPTION');
1593:
1594: --if the attribute has been updated then

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

1596: IF l_description <> FND_API.G_MISS_CHAR AND l_description IS NOT NULL THEN
1597: x_document := x_document||get_translated_attr_name('DESCRIPTION')||' - '||l_description||'
';
1598: END IF;
1599:
1600: l_append_description_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1601: itemkey => p_item_key,
1602: aname => 'APPEND_DESCRIPTION_FLAG');
1603:
1604: l_additional_information := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1600: l_append_description_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1601: itemkey => p_item_key,
1602: aname => 'APPEND_DESCRIPTION_FLAG');
1603:
1604: l_additional_information := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1605: itemkey => p_item_key,
1606: aname => 'ADDITIONAL_INFORMATION');
1607:
1608: --if the attribute has been updated then

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

1610: IF l_additional_information <> FND_API.G_MISS_CHAR AND l_additional_information IS NOT NULL THEN
1611: x_document := x_document||get_translated_attr_name('ADDITIONAL_INFORMATION')||' - '||l_additional_information||'
';
1612: END IF;
1613:
1614: l_append_information_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1615: itemkey => p_item_key,
1616: aname => 'APPEND_INFORMATION_FLAG');
1617:
1618: l_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

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

1614: l_append_information_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1615: itemkey => p_item_key,
1616: aname => 'APPEND_INFORMATION_FLAG');
1617:
1618: l_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1619: itemkey => p_item_key,
1620: aname => 'START_DATE');
1621: x_start_date := l_start_date;
1622:

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

1625: IF l_start_date <> FND_API.G_MISS_DATE AND l_start_date IS NOT NULL THEN
1626: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_start_date||'
';
1627: END IF;
1628:
1629: l_end_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1630: itemkey => p_item_key,
1631: aname => 'END_DATE');
1632:
1633: x_end_date := l_end_date;

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

1637: IF l_end_date <> FND_API.G_MISS_DATE AND l_end_date IS NOT NULL THEN
1638: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_end_date||'
';
1639: END IF;
1640:
1641: l_location_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1642: itemkey => p_item_key,
1643: aname => 'LOCATION_ID');
1644:
1645: l_location_city := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1641: l_location_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1642: itemkey => p_item_key,
1643: aname => 'LOCATION_ID');
1644:
1645: l_location_city := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1646: itemkey => p_item_key,
1647: aname => 'LOCATION_CITY');
1648:
1649: --if the attribute has been updated then

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

1651: IF l_location_city <> FND_API.G_MISS_CHAR AND l_location_city IS NOT NULL THEN
1652: x_document := x_document||get_translated_attr_name('LOCATION_CITY')||' - '||l_location_city||'
';
1653: END IF;
1654:
1655: l_location_region := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1656: itemkey => p_item_key,
1657: aname => 'LOCATION_REGION');
1658:
1659: --if the attribute has been updated then

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

1661: IF l_location_region <> FND_API.G_MISS_CHAR AND l_location_region IS NOT NULL THEN
1662: x_document := x_document||get_translated_attr_name('LOCATION_REGION')||' - '||l_location_region||'
';
1663: END IF;
1664:
1665: l_location_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1666: itemkey => p_item_key,
1667: aname => 'LOCATION_COUNTRY_NAME');
1668:
1669: --if the attribute has been updated then

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

1671: IF l_location_country_name <> FND_API.G_MISS_CHAR AND l_location_country_name IS NOT NULL THEN
1672: x_document := x_document||get_translated_attr_name('LOCATION_COUNTRY_NAME')||' - '||l_location_country_name||'
';
1673: END IF;
1674:
1675: l_location_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1676: itemkey => p_item_key,
1677: aname => 'LOCATION_COUNTRY_CODE');
1678:
1679: l_calendar_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1675: l_location_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1676: itemkey => p_item_key,
1677: aname => 'LOCATION_COUNTRY_CODE');
1678:
1679: l_calendar_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1680: itemkey => p_item_key,
1681: aname => 'CALENDAR_TYPE');
1682:
1683: l_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1679: l_calendar_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1680: itemkey => p_item_key,
1681: aname => 'CALENDAR_TYPE');
1682:
1683: l_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1684: itemkey => p_item_key,
1685: aname => 'CALENDAR_ID');
1686:
1687: l_resource_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1683: l_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1684: itemkey => p_item_key,
1685: aname => 'CALENDAR_ID');
1686:
1687: l_resource_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1688: itemkey => p_item_key,
1689: aname => 'RESOURCE_CALENDAR_PERCENT');
1690:
1691: l_project_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1687: l_resource_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1688: itemkey => p_item_key,
1689: aname => 'RESOURCE_CALENDAR_PERCENT');
1690:
1691: l_project_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1692: itemkey => p_item_key,
1693: aname => 'PROJECT_NAME');
1694:
1695: l_project_number := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1691: l_project_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1692: itemkey => p_item_key,
1693: aname => 'PROJECT_NAME');
1694:
1695: l_project_number := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1696: itemkey => p_item_key,
1697: aname => 'PROJECT_NUMBER');
1698:
1699: l_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1695: l_project_number := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1696: itemkey => p_item_key,
1697: aname => 'PROJECT_NUMBER');
1698:
1699: l_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1700: itemkey => p_item_key,
1701: aname => 'CALENDAR_NAME');
1702:
1703: l_expense_owner := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1699: l_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1700: itemkey => p_item_key,
1701: aname => 'CALENDAR_NAME');
1702:
1703: l_expense_owner := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1704: itemkey => p_item_key,
1705: aname => 'EXPENSE_OWNER');
1706:
1707: --if the attribute has been updated then

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

1714: AND lookup_code = l_expense_owner;
1715: x_document := x_document||get_translated_attr_name('EXPENSE_OWNER')||' - '||l_expense_owner_meaning||'
';
1716: END IF;
1717:
1718: l_expense_limit := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1719: itemkey => p_item_key,
1720: aname => 'EXPENSE_LIMIT');
1721:
1722: --if the attribute has been updated then

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

1724: IF l_expense_limit <> FND_API.G_MISS_NUM AND l_expense_limit IS NOT NULL THEN
1725: x_document := x_document||get_translated_attr_name('EXPENSE_LIMIT')||' - '||l_expense_limit||'
';
1726: END IF;
1727:
1728: l_expense_limit_currency_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1729: itemkey => p_item_key,
1730: aname => 'EXPENSE_LIMIT_CURRENCY_CODE');
1731:
1732: l_comp_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1728: l_expense_limit_currency_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1729: itemkey => p_item_key,
1730: aname => 'EXPENSE_LIMIT_CURRENCY_CODE');
1731:
1732: l_comp_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1733: itemkey => p_item_key,
1734: aname => 'COMP_MATCH_WEIGHTING');
1735:
1736: --if the attribute has been updated then

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

1738: IF l_comp_match_weighting <> FND_API.G_MISS_NUM AND l_comp_match_weighting IS NOT NULL THEN
1739: x_document := x_document||get_translated_attr_name('COMP_MATCH_WEIGHTING')||' - '||l_comp_match_weighting||'
';
1740: END IF;
1741:
1742: l_avail_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1743: itemkey => p_item_key,
1744: aname => 'AVAIL_MATCH_WEIGHTING');
1745:
1746: --if the attribute has been updated then

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

1748: IF l_avail_match_weighting <> FND_API.G_MISS_NUM AND l_avail_match_weighting IS NOT NULL THEN
1749: x_document := x_document||get_translated_attr_name('AVAIL_MATCH_WEIGHTING')||' - '||l_avail_match_weighting||'
';
1750: END IF;
1751:
1752: l_job_level_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1753: itemkey => p_item_key,
1754: aname => 'JOB_LEVEL_MATCH_WEIGHTING');
1755:
1756: --if the attribute has been updated then

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

1758: IF l_job_level_match_weighting <> FND_API.G_MISS_NUM AND l_job_level_match_weighting IS NOT NULL THEN
1759: x_document := x_document||get_translated_attr_name('JOB_LEVEL_MATCH_WEIGHTING')||' - '||l_job_level_match_weighting||'
';
1760: END IF;
1761:
1762: l_search_min_availability := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1763: itemkey => p_item_key,
1764: aname => 'SEARCH_MIN_AVAILABILITY');
1765:
1766: --if the attribute has been updated then

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

1768: IF l_search_min_availability <> FND_API.G_MISS_NUM AND l_search_min_availability IS NOT NULL THEN
1769: x_document := x_document||get_translated_attr_name('SEARCH_MIN_AVAILABILITY')||' - '||l_search_min_availability||'
';
1770: END IF;
1771:
1772: l_search_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1773: itemkey => p_item_key,
1774: aname => 'SEARCH_COUNTRY_CODE');
1775:
1776: l_search_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1772: l_search_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1773: itemkey => p_item_key,
1774: aname => 'SEARCH_COUNTRY_CODE');
1775:
1776: l_search_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1777: itemkey => p_item_key,
1778: aname => 'SEARCH_COUNTRY_NAME');
1779:
1780: --if the attribute has been updated then

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

1782: IF l_search_country_name <> FND_API.G_MISS_CHAR AND l_search_country_name IS NOT NULL THEN
1783: x_document := x_document||get_translated_attr_name('LOCATION_COUNTRY_NAME')||' - '||l_search_country_name||'
';
1784: END IF;
1785:
1786: l_search_exp_org_struct_ver_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1787: itemkey => p_item_key,
1788: aname => 'SEARCH_EXP_ORG_STRUCT_VER_ID');
1789:
1790: l_search_exp_org_hier_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1786: l_search_exp_org_struct_ver_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1787: itemkey => p_item_key,
1788: aname => 'SEARCH_EXP_ORG_STRUCT_VER_ID');
1789:
1790: l_search_exp_org_hier_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1791: itemkey => p_item_key,
1792: aname => 'SEARCH_EXP_ORG_HIER_NAME');
1793:
1794: --if the attribute has been updated then

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

1796: IF l_search_exp_org_hier_name <> FND_API.G_MISS_CHAR AND l_search_exp_org_hier_name IS NOT NULL THEN
1797: x_document := x_document||get_translated_attr_name('SEARCH_EXP_ORG_HIER_NAME')||' - '||l_search_exp_org_hier_name||'
';
1798: END IF;
1799:
1800: l_search_exp_start_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1801: itemkey => p_item_key,
1802: aname => 'SEARCH_EXP_START_ORG_ID');
1803:
1804: l_search_exp_start_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1800: l_search_exp_start_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1801: itemkey => p_item_key,
1802: aname => 'SEARCH_EXP_START_ORG_ID');
1803:
1804: l_search_exp_start_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1805: itemkey => p_item_key,
1806: aname => 'SEARCH_EXP_START_ORG_NAME');
1807:
1808: --if the attribute has been updated then

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

1810: IF l_search_exp_start_org_name <> FND_API.G_MISS_CHAR AND l_search_exp_start_org_name IS NOT NULL THEN
1811: x_document := x_document||get_translated_attr_name('SEARCH_EXP_START_ORG_NAME')||' - '||l_search_exp_start_org_name||'
';
1812: END IF;
1813:
1814: l_search_min_candidate_score := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1815: itemkey => p_item_key,
1816: aname => 'SEARCH_MIN_CANDIDATE_SCORE');
1817:
1818: --if the attribute has been updated then

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

1820: IF l_search_min_candidate_score <> FND_API.G_MISS_NUM AND l_search_min_candidate_score IS NOT NULL THEN
1821: x_document := x_document||get_translated_attr_name('SEARCH_MIN_CANDIDATE_SCORE')||' - '||l_search_min_candidate_score||'
';
1822: END IF;
1823:
1824: L_ENABLE_AUTO_CAND_NOM_FLAG := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1825: itemkey => p_item_key,
1826: aname => 'ENABLE_AUTO_CAND_NOM_FLAG');
1827:
1828: --if the attribute has been updated then

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

1836: END IF;
1837:
1838: ELSIF l_mode = G_MASS_UPDATE_FORECAST_ITEMS THEN
1839:
1840: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1841: itemkey => p_item_key,
1842: aname => 'WORK_TYPE_ID');
1843:
1844: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1840: l_work_type_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1841: itemkey => p_item_key,
1842: aname => 'WORK_TYPE_ID');
1843:
1844: l_work_type_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1845: itemkey => p_item_key,
1846: aname => 'WORK_TYPE_NAME');
1847:
1848: --if the attribute has been updated then

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

1856: END IF;
1857: x_document := x_document||get_translated_attr_name('WORK_TYPE_NAME')||' - '||l_work_type_name||'
';
1858: END IF;
1859:
1860: l_fcst_tp_amount_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1861: itemkey => p_item_key,
1862: aname => 'FCST_TP_AMOUNT_TYPE');
1863:
1864: --if the attribute has been updated then

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

1871: AND lookup_code = l_fcst_tp_amount_type;
1872: x_document := x_document||get_translated_attr_name('FCST_TP_AMOUNT_TYPE')||' - '||l_fcst_tp_amount_type_meaning||'
';
1873: END IF;
1874:
1875: l_fcst_job_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1876: itemkey => p_item_key,
1877: aname => 'FCST_JOB_ID');
1878:
1879: l_fcst_job_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1875: l_fcst_job_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1876: itemkey => p_item_key,
1877: aname => 'FCST_JOB_ID');
1878:
1879: l_fcst_job_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1880: itemkey => p_item_key,
1881: aname => 'FCST_JOB_NAME');
1882:
1883: --if the attribute has been updated then

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

1885: IF l_fcst_job_name <> FND_API.G_MISS_CHAR AND l_fcst_job_name IS NOT NULL THEN
1886: x_document := x_document||get_translated_attr_name('FCST_JOB_NAME')||' - '||l_fcst_job_name||'
';
1887: END IF;
1888:
1889: l_fcst_job_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1890: itemkey => p_item_key,
1891: aname => 'FCST_JOB_GROUP_ID');
1892:
1893: l_fcst_job_group_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1889: l_fcst_job_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1890: itemkey => p_item_key,
1891: aname => 'FCST_JOB_GROUP_ID');
1892:
1893: l_fcst_job_group_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1894: itemkey => p_item_key,
1895: aname => 'FCST_JOB_GROUP_NAME');
1896:
1897: --if the attribute has been updated then

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

1899: IF l_fcst_job_group_name <> FND_API.G_MISS_CHAR AND l_fcst_job_group_name IS NOT NULL THEN
1900: x_document := x_document||get_translated_attr_name('FCST_JOB_GROUP_NAME')||' - '||l_fcst_job_group_name||'
';
1901: END IF;
1902:
1903: l_expenditure_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1904: itemkey => p_item_key,
1905: aname => 'EXPENDITURE_ORG_ID');
1906:
1907: l_expenditure_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1903: l_expenditure_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1904: itemkey => p_item_key,
1905: aname => 'EXPENDITURE_ORG_ID');
1906:
1907: l_expenditure_org_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1908: itemkey => p_item_key,
1909: aname => 'EXPENDITURE_ORG_NAME');
1910:
1911: --if the attribute has been updated then

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

1913: IF l_expenditure_org_name <> FND_API.G_MISS_CHAR AND l_expenditure_org_name IS NOT NULL THEN
1914: x_document := x_document||get_translated_attr_name('EXPENDITURE_ORG_NAME')||' - '||l_expenditure_org_name||'
';
1915: END IF;
1916:
1917: l_expenditure_organization_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1918: itemkey => p_item_key,
1919: aname => 'EXPENDITURE_ORGANIZATION_ID');
1920:
1921: l_exp_organization_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1917: l_expenditure_organization_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1918: itemkey => p_item_key,
1919: aname => 'EXPENDITURE_ORGANIZATION_ID');
1920:
1921: l_exp_organization_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1922: itemkey => p_item_key,
1923: aname => 'EXP_ORGANIZATION_NAME');
1924:
1925: --if the attribute has been updated then

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

1927: IF l_exp_organization_name <> FND_API.G_MISS_CHAR AND l_exp_organization_name IS NOT NULL THEN
1928: x_document := x_document||get_translated_attr_name('EXP_ORGANIZATION_NAME')||' - '||l_exp_organization_name||'
';
1929: END IF;
1930:
1931: l_expenditure_type_class := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1932: itemkey => p_item_key,
1933: aname => 'EXPENDITURE_TYPE_CLASS');
1934:
1935: l_expenditure_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1931: l_expenditure_type_class := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1932: itemkey => p_item_key,
1933: aname => 'EXPENDITURE_TYPE_CLASS');
1934:
1935: l_expenditure_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1936: itemkey => p_item_key,
1937: aname => 'EXPENDITURE_TYPE');
1938:
1939: --if the attribute has been updated then

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

1945:
1946: ELSIF l_mode = G_MASS_UPDATE_SCHEDULE THEN
1947:
1948:
1949: l_exception_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1950: itemkey => p_item_key,
1951: aname => 'EXCEPTION_TYPE_CODE');
1952:
1953: l_change_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

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

1949: l_exception_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1950: itemkey => p_item_key,
1951: aname => 'EXCEPTION_TYPE_CODE');
1952:
1953: l_change_start_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1954: itemkey => p_item_key,
1955: aname => 'CHANGE_START_DATE');
1956:
1957: IF l_exception_type_code = 'CHANGE_DURATION' THEN

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

1961: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_change_start_date||'
';
1962: END IF;
1963: END IF;
1964:
1965: l_change_end_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
1966: itemkey => p_item_key,
1967: aname => 'CHANGE_END_DATE');
1968:
1969: IF l_exception_type_code = 'CHANGE_DURATION' THEN

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

1973: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_change_end_date||'
';
1974: END IF;
1975: END IF;
1976:
1977: l_change_rqmt_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1978: itemkey => p_item_key,
1979: aname => 'CHANGE_RQMT_STATUS_CODE');
1980:
1981: IF l_change_rqmt_status_code <> FND_API.G_MISS_CHAR THEN

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

1988: x_document := x_document||get_translated_attr_name('STATUS_NAME')||' - '||l_project_status_name||'
';
1989:
1990: END IF;
1991:
1992: l_change_asgmt_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1993: itemkey => p_item_key,
1994: aname => 'CHANGE_ASGMT_STATUS_CODE');
1995:
1996: --if the attribute has been updated then

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

2004: x_document := x_document||get_translated_attr_name('STATUS_NAME')||' - '||l_project_status_name||'
';
2005: END IF;
2006:
2007: -- Multi-period Work Pattern Updates
2008: l_num_of_sch_periods := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2009: itemkey => p_item_key,
2010: aname => 'NUM_OF_SCH_PERIODS');
2011: IF l_num_of_sch_periods > 0 THEN
2012:

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

2021: l_sunday_hours_tbl.EXTEND(l_num_of_sch_periods);
2022:
2023: FOR j IN 1 .. l_num_of_sch_periods LOOP
2024:
2025: l_change_start_date_tbl(j) := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
2026: itemkey => p_item_key,
2027: aname => 'CHANGE_START_DATE'||j);
2028:
2029: --if the attribute has been updated then

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

2031: IF l_change_start_date_tbl(j) <> FND_API.G_MISS_DATE THEN
2032: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_change_start_date_tbl(j)||'
';
2033: END IF;
2034:
2035: l_change_end_date_tbl(j) := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,
2036: itemkey => p_item_key,
2037: aname => 'CHANGE_END_DATE'||j);
2038:
2039: --if the attribute has been updated then

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

2041: IF l_change_end_date_tbl(j) <> FND_API.G_MISS_DATE THEN
2042: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_change_end_date_tbl(j)||'
';
2043: END IF;
2044:
2045: l_monday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2046: itemkey => p_item_key,
2047: aname => 'MONDAY_HOURS'||j);
2048:
2049: --if the attribute has been updated then

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

2051: IF l_monday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_monday_hours_tbl(j) IS NOT NULL THEN
2052: x_document := x_document||get_translated_attr_name('MONDAY_HOURS')||' - '||l_monday_hours_tbl(j)||'
';
2053: END IF;
2054:
2055: l_tuesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2056: itemkey => p_item_key,
2057: aname => 'TUESDAY_HOURS'||j);
2058:
2059: --if the attribute has been updated then

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

2061: IF l_tuesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_tuesday_hours_tbl(j) IS NOT NULL THEN
2062: x_document := x_document||get_translated_attr_name('TUESDAY_HOURS')||' - '||l_tuesday_hours_tbl(j)||'
';
2063: END IF;
2064:
2065: l_wednesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2066: itemkey => p_item_key,
2067: aname => 'WEDNESDAY_HOURS'||j);
2068:
2069: --if the attribute has been updated then

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

2071: IF l_wednesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_wednesday_hours_tbl(j) IS NOT NULL THEN
2072: x_document := x_document||get_translated_attr_name('WEDNESDAY_HOURS')||' - '||l_wednesday_hours_tbl(j)||'
';
2073: END IF;
2074:
2075: l_thursday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2076: itemkey => p_item_key,
2077: aname => 'THURSDAY_HOURS'||j);
2078:
2079: --if the attribute has been updated then

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

2081: IF l_thursday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_thursday_hours_tbl(j) IS NOT NULL THEN
2082: x_document := x_document||get_translated_attr_name('THURSDAY_HOURS')||' - '||l_thursday_hours_tbl(j)||'
';
2083: END IF;
2084:
2085: l_friday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2086: itemkey => p_item_key,
2087: aname => 'FRIDAY_HOURS'||j);
2088:
2089: --if the attribute has been updated then

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

2091: IF l_friday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_friday_hours_tbl(j) IS NOT NULL THEN
2092: x_document := x_document||get_translated_attr_name('FRIDAY_HOURS')||' - '||l_friday_hours_tbl(j)||'
';
2093: END IF;
2094:
2095: l_saturday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2096: itemkey => p_item_key,
2097: aname => 'SATURDAY_HOURS'||j);
2098:
2099: --if the attribute has been updated then

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

2101: IF l_saturday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_saturday_hours_tbl(j) IS NOT NULL THEN
2102: x_document := x_document||get_translated_attr_name('SATURDAY_HOURS')||' - '||l_saturday_hours_tbl(j)||'
';
2103: END IF;
2104:
2105: l_sunday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2106: itemkey => p_item_key,
2107: aname => 'SUNDAY_HOURS'||j);
2108:
2109: --if the attribute has been updated then

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

2114:
2115: END LOOP;
2116: END IF; -- End if for muti-period work pattern updates
2117:
2118: l_non_working_day_flag := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2119: itemkey => p_item_key,
2120: aname => 'NON_WORKING_DAY_FLAG');
2121:
2122: l_change_hours_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

2118: l_non_working_day_flag := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2119: itemkey => p_item_key,
2120: aname => 'NON_WORKING_DAY_FLAG');
2121:
2122: l_change_hours_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2123: itemkey => p_item_key,
2124: aname => 'CHANGE_HOURS_TYPE_CODE');
2125:
2126: l_hrs_per_day := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2122: l_change_hours_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2123: itemkey => p_item_key,
2124: aname => 'CHANGE_HOURS_TYPE_CODE');
2125:
2126: l_hrs_per_day := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2127: itemkey => p_item_key,
2128: aname => 'HRS_PER_DAY');
2129:
2130: --if the attribute has been updated then

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

2132: IF l_hrs_per_day <> FND_API.G_MISS_NUM AND l_hrs_per_day IS NOT NULL THEN
2133: x_document := x_document||get_translated_attr_name('HRS_PER_DAY')||' - '||l_hrs_per_day||'
';
2134: END IF;
2135:
2136: l_change_calendar_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2137: itemkey => p_item_key,
2138: aname => 'CHANGE_CALENDAR_TYPE_CODE');
2139:
2140: l_change_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

2136: l_change_calendar_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2137: itemkey => p_item_key,
2138: aname => 'CHANGE_CALENDAR_TYPE_CODE');
2139:
2140: l_change_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2141: itemkey => p_item_key,
2142: aname => 'CHANGE_CALENDAR_NAME');
2143:
2144: IF l_change_calendar_name <> FND_API.G_MISS_CHAR and l_change_calendar_name IS NOT NULL THEN

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

2144: IF l_change_calendar_name <> FND_API.G_MISS_CHAR and l_change_calendar_name IS NOT NULL THEN
2145: l_calendar_display := ': '||l_change_calendar_name;
2146: END IF;
2147:
2148: l_change_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2149: itemkey => p_item_key,
2150: aname => 'CHANGE_CALENDAR_ID');
2151:
2152: l_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2148: l_change_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2149: itemkey => p_item_key,
2150: aname => 'CHANGE_CALENDAR_ID');
2151:
2152: l_calendar_percent := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2153: itemkey => p_item_key,
2154: aname => 'CALENDAR_PERCENT');
2155:
2156: --if the attribute has been updated then

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

2159: 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||'
';
2160: END IF;
2161:
2162:
2163: l_duration_shift_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2164: itemkey => p_item_key,
2165: aname => 'DURATION_SHIFT_TYPE_CODE');
2166:
2167: l_duration_shift_unit_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

2163: l_duration_shift_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2164: itemkey => p_item_key,
2165: aname => 'DURATION_SHIFT_TYPE_CODE');
2166:
2167: l_duration_shift_unit_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2168: itemkey => p_item_key,
2169: aname => 'DURATION_SHIFT_UNIT_CODE');
2170:
2171: l_num_of_shift := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2167: l_duration_shift_unit_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2168: itemkey => p_item_key,
2169: aname => 'DURATION_SHIFT_UNIT_CODE');
2170:
2171: l_num_of_shift := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2172: itemkey => p_item_key,
2173: aname => 'NUM_OF_SHIFT');
2174:
2175: IF l_num_of_shift <> FND_API.G_MISS_NUM AND l_num_of_shift IS NOT NULL THEN

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

2177: END IF;
2178:
2179: ELSIF l_mode = G_MASS_UPDATE_COMPETENCIES THEN
2180:
2181: l_number_of_competencies := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2182: itemkey => p_item_key,
2183: aname => 'NUMBER_OF_COMPETENCIES');
2184:
2185: IF l_number_of_competencies > 0 THEN

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

2191: l_mandatory_flag_tbl.EXTEND(l_number_of_competencies);
2192:
2193: FOR i IN 1 .. l_number_of_competencies LOOP
2194:
2195: l_competence_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2196: itemkey => p_item_key,
2197: aname => 'COMPETENCE_ID'||i);
2198:
2199: l_competence_name_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

2195: l_competence_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2196: itemkey => p_item_key,
2197: aname => 'COMPETENCE_ID'||i);
2198:
2199: l_competence_name_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2200: itemkey => p_item_key,
2201: aname => 'COMPETENCE_NAME'||i);
2202:
2203: l_competence_alias_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

2199: l_competence_name_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2200: itemkey => p_item_key,
2201: aname => 'COMPETENCE_NAME'||i);
2202:
2203: l_competence_alias_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2204: itemkey => p_item_key,
2205: aname => 'COMPETENCE_ALIAS'||i);
2206:
2207: l_rating_level_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2203: l_competence_alias_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2204: itemkey => p_item_key,
2205: aname => 'COMPETENCE_ALIAS'||i);
2206:
2207: l_rating_level_id_tbl(i) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2208: itemkey => p_item_key,
2209: aname => 'RATING_LEVEL_ID'||i);
2210:
2211: --if rating level id is not null then get the actual rating level

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

2215: FROM per_rating_levels_v
2216: WHERE rating_level_id = l_rating_level_id_tbl(i);
2217: END IF;
2218:
2219: l_mandatory_flag_tbl(i) := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2220: itemkey => p_item_key,
2221: aname => 'MANDATORY_FLAG'||i);
2222:
2223: --if mandatory_flag is not null then get the meaning

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

2322: CLOSE csr_get_tp_amt_type;
2323:
2324: END IF;
2325:
2326: WF_ENGINE.SetItemAttrText(itemtype => p_item_type,
2327: itemkey => p_item_key,
2328: aname => 'TP_AMT_TYPE_NAME',
2329: avalue => l_tp_amt_type_name);
2330:

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

2592:
2593: BEGIN
2594:
2595: --get the mode and action for this wf process
2596: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2597: itemkey => p_item_key,
2598: aname => 'MODE');
2599:
2600: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

2596: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2597: itemkey => p_item_key,
2598: aname => 'MODE');
2599:
2600: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2601: itemkey => p_item_key,
2602: aname => 'ACTION');
2603:
2604: l_num_success_assignments := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2600: l_action := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2601: itemkey => p_item_key,
2602: aname => 'ACTION');
2603:
2604: l_num_success_assignments := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2605: itemkey => p_item_key,
2606: aname => 'NUM_SUCCESS_ASSIGNMENTS');
2607:
2608: --if the assignments in this process are to be submitted then

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

2612: --get the conflict group id
2613: --this is used to filter out the assignments that the user chose to
2614: --cancel or revert due to overcommitment and not to pass them on to
2615: --be submitted.
2616: l_conflict_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2617: itemkey => p_item_key,
2618: aname => 'CONFLICT_GROUP_ID');
2619:
2620:

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

2649: --the approval attributes.
2650: IF l_assignment_id_tbl.COUNT > 0 THEN
2651:
2652:
2653: l_appr_over_auth_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2654: itemkey => p_item_key,
2655: aname => 'APPR_OVER_AUTH_FLAG');
2656:
2657: l_note_to_all_approvers := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

2653: l_appr_over_auth_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2654: itemkey => p_item_key,
2655: aname => 'APPR_OVER_AUTH_FLAG');
2656:
2657: l_note_to_all_approvers := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2658: itemkey => p_item_key,
2659: aname => 'NOTE_TO_ALL_APPROVERS');
2660:
2661: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2657: l_note_to_all_approvers := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2658: itemkey => p_item_key,
2659: aname => 'NOTE_TO_ALL_APPROVERS');
2660:
2661: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2662: itemkey => p_item_key,
2663: aname => 'PROJECT_ID');
2664:
2665: /* Fix for bug 9788813 - Modified aname */

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

2663: aname => 'PROJECT_ID');
2664:
2665: /* Fix for bug 9788813 - Modified aname */
2666:
2667: l_document := WF_ENGINE.GetItemAttrDocument(itemtype => p_item_type,
2668: itemkey => p_item_key,
2669: aname => 'UPDATED_INFORMATION_DOCUMENT',
2670: ignore_notfound => TRUE);
2671:

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

2668: itemkey => p_item_key,
2669: aname => 'UPDATED_INFORMATION_DOCUMENT',
2670: ignore_notfound => TRUE);
2671:
2672: l_submitter_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2673: itemkey => p_item_key,
2674: aname => 'SUBMITTER_USER_ID');
2675:
2676: --call the submit for approval API.

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

2723: --from the View Conflicts page from the notification to the submitter the
2724: --submitter may choose to cancel or revert certain assignments.
2725: --this API is called after the user has taken action on conflicts and
2726: --closed the notification in order to cancel or revert those assignments.
2727: l_conflict_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2728: itemkey => p_item_key,
2729: aname => 'CONFLICT_GROUP_ID');
2730:
2731: --set mass_wf_in_progress_flag = 'N' for those assignments to be canceled

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

2819: BEGIN
2820:
2821: IF p_funcmode = 'RESPOND' THEN
2822:
2823: l_conflict_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2824: itemkey => p_item_key,
2825: aname => 'CONFLICT_GROUP_ID');
2826:
2827: PA_SCHEDULE_PVT.Has_Action_Taken_On_Conflicts(p_conflict_group_id => l_conflict_group_id,

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

2865: l_mode VARCHAR2(30);
2866:
2867: BEGIN
2868:
2869: l_mode := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2870: itemkey => p_item_key,
2871: aname => 'MODE');
2872:
2873:

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

2925: --but we commit 1 at a time, so some of the transactions
2926: --may be complete - so we are only aborting the ones that are not yet processed.
2927:
2928: --get the following wf attributes for the process that errored out.
2929: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2930: itemkey => p_item_key,
2931: aname => 'ERROR_ITEM_TYPE');
2932:
2933: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

2929: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2930: itemkey => p_item_key,
2931: aname => 'ERROR_ITEM_TYPE');
2932:
2933: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2934: itemkey => p_item_key,
2935: aname => 'ERROR_ITEM_KEY');
2936:
2937: l_mode := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

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

2933: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2934: itemkey => p_item_key,
2935: aname => 'ERROR_ITEM_KEY');
2936:
2937: l_mode := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2938: itemkey => l_error_item_key,
2939: aname => 'MODE');
2940:
2941: l_submitter_user_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

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

2937: l_mode := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2938: itemkey => l_error_item_key,
2939: aname => 'MODE');
2940:
2941: l_submitter_user_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2942: itemkey => l_error_item_key,
2943: aname => 'SUBMITTER_USER_ID');
2944:
2945: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

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

2941: l_submitter_user_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2942: itemkey => l_error_item_key,
2943: aname => 'SUBMITTER_USER_ID');
2944:
2945: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
2946: itemkey => l_error_item_key,
2947: aname => 'PROJECT_ID');
2948:
2949: --set process_status_code to 'A' for the pending items.

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

3035: BEGIN
3036:
3037:
3038: --get the following wf attributes for the process that errored out.
3039: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
3040: itemkey => p_item_key,
3041: aname => 'ERROR_ITEM_TYPE');
3042:
3043: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

3039: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
3040: itemkey => p_item_key,
3041: aname => 'ERROR_ITEM_TYPE');
3042:
3043: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
3044: itemkey => p_item_key,
3045: aname => 'ERROR_ITEM_KEY');
3046:
3047: l_submitter_user_name := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,

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

3043: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
3044: itemkey => p_item_key,
3045: aname => 'ERROR_ITEM_KEY');
3046:
3047: l_submitter_user_name := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
3048: itemkey => l_error_item_key,
3049: aname => 'SUBMITTER_USER_NAME');
3050:
3051: --SET the Text item attributes (these attributes were created at design time)

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

3048: itemkey => l_error_item_key,
3049: aname => 'SUBMITTER_USER_NAME');
3050:
3051: --SET the Text item attributes (these attributes were created at design time)
3052: WF_ENGINE.SetItemAttrText(itemtype => p_item_type,
3053: itemkey => p_item_key,
3054: aname => 'SUBMITTER_USER_NAME',
3055: avalue => l_submitter_user_name);
3056: --4537865 :Included Exception block