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

Line 119: n_varname Wf_Engine.NameTabTyp;

115: l_supplier_username fnd_user.user_name%type;
116: l_requestor_username fnd_user.user_name%type;
117: l_requestor_disp_name varchar2(2000);
118:
119: n_varname Wf_Engine.NameTabTyp;
120: n_varval Wf_Engine.NumTabTyp;
121: t_varname Wf_Engine.NameTabTyp;
122: t_varval Wf_Engine.TextTabTyp;
123: BEGIN

Line 120: n_varval Wf_Engine.NumTabTyp;

116: l_requestor_username fnd_user.user_name%type;
117: l_requestor_disp_name varchar2(2000);
118:
119: n_varname Wf_Engine.NameTabTyp;
120: n_varval Wf_Engine.NumTabTyp;
121: t_varname Wf_Engine.NameTabTyp;
122: t_varval Wf_Engine.TextTabTyp;
123: BEGIN
124:

Line 121: t_varname Wf_Engine.NameTabTyp;

117: l_requestor_disp_name varchar2(2000);
118:
119: n_varname Wf_Engine.NameTabTyp;
120: n_varval Wf_Engine.NumTabTyp;
121: t_varname Wf_Engine.NameTabTyp;
122: t_varval Wf_Engine.TextTabTyp;
123: BEGIN
124:
125: if(p_requestor_id is null or p_chg_req_grp_id is null) then

Line 122: t_varval Wf_Engine.TextTabTyp;

118:
119: n_varname Wf_Engine.NameTabTyp;
120: n_varval Wf_Engine.NumTabTyp;
121: t_varname Wf_Engine.NameTabTyp;
122: t_varval Wf_Engine.TextTabTyp;
123: BEGIN
124:
125: if(p_requestor_id is null or p_chg_req_grp_id is null) then
126: return;

Line 138: wf_engine.createProcess ( ItemType => 'POSCHORD',

134: end if;
135:
136: l_progress := '001';
137:
138: wf_engine.createProcess ( ItemType => 'POSCHORD',
139: ItemKey => l_item_key,
140: Process => 'NOTIFY_REQUESTER_SUP_CHN');
141:
142: l_progress := '002';

Line 182: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);

178:
179:
180: l_progress := '004';
181:
182: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
183: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
184:
185: wf_engine.StartProcess( ItemType => 'POSCHORD',
186: ItemKey => l_item_key);

Line 183: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);

179:
180: l_progress := '004';
181:
182: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
183: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
184:
185: wf_engine.StartProcess( ItemType => 'POSCHORD',
186: ItemKey => l_item_key);
187: END IF;

Line 185: wf_engine.StartProcess( ItemType => 'POSCHORD',

181:
182: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
183: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
184:
185: wf_engine.StartProcess( ItemType => 'POSCHORD',
186: ItemKey => l_item_key);
187: END IF;
188: exception when others then
189: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 212: n_varname Wf_Engine.NameTabTyp;

208: l_planner_username fnd_user.user_name%type;
209: l_planner_disp_name varchar2(2000);
210: l_type_lookup_code po_headers_all.type_lookup_code%type;
211:
212: n_varname Wf_Engine.NameTabTyp;
213: n_varval Wf_Engine.NumTabTyp;
214: t_varname Wf_Engine.NameTabTyp;
215: t_varval Wf_Engine.TextTabTyp;
216:

Line 213: n_varval Wf_Engine.NumTabTyp;

209: l_planner_disp_name varchar2(2000);
210: l_type_lookup_code po_headers_all.type_lookup_code%type;
211:
212: n_varname Wf_Engine.NameTabTyp;
213: n_varval Wf_Engine.NumTabTyp;
214: t_varname Wf_Engine.NameTabTyp;
215: t_varval Wf_Engine.TextTabTyp;
216:
217: BEGIN

Line 214: t_varname Wf_Engine.NameTabTyp;

210: l_type_lookup_code po_headers_all.type_lookup_code%type;
211:
212: n_varname Wf_Engine.NameTabTyp;
213: n_varval Wf_Engine.NumTabTyp;
214: t_varname Wf_Engine.NameTabTyp;
215: t_varval Wf_Engine.TextTabTyp;
216:
217: BEGIN
218:

Line 215: t_varval Wf_Engine.TextTabTyp;

211:
212: n_varname Wf_Engine.NameTabTyp;
213: n_varval Wf_Engine.NumTabTyp;
214: t_varname Wf_Engine.NameTabTyp;
215: t_varval Wf_Engine.TextTabTyp;
216:
217: BEGIN
218:
219: if(p_planner_id is null or p_chg_req_grp_id is null) then

Line 232: wf_engine.createProcess ( ItemType => 'POSCHORD',

228: l_item_key := 'NPSC-'||to_char(p_planner_id)||'-'||to_char(p_release_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
229: end if;
230:
231: l_progress := '001';
232: wf_engine.createProcess ( ItemType => 'POSCHORD',
233: ItemKey => l_item_key,
234: Process => 'NOTIFY_PLANNER_SUP_CHN');
235:
236: l_progress := '002';

Line 278: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);

274:
275:
276: l_progress := '004';
277:
278: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
279: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
280:
281: wf_engine.StartProcess( ItemType => 'POSCHORD',
282: ItemKey => l_item_key);

Line 279: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);

275:
276: l_progress := '004';
277:
278: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
279: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
280:
281: wf_engine.StartProcess( ItemType => 'POSCHORD',
282: ItemKey => l_item_key);
283: END IF;

Line 281: wf_engine.StartProcess( ItemType => 'POSCHORD',

277:
278: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
279: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
280:
281: wf_engine.StartProcess( ItemType => 'POSCHORD',
282: ItemKey => l_item_key);
283: END IF;
284: exception when others then
285: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 945: l_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => p_itemtype,

941: SELECT po_acceptances_s.nextval into l_Acceptance_id FROM sys.dual;
942:
943: -- commented out the usage of accptance_type (FPI)
944: /*
945: l_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => p_itemtype,
946: itemkey => p_itemkey,
947: aname => 'ACCEPTANCE_LOOKUP_CODE');
948: */
949:

Line 965: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => p_itemtype,

961: end if;
962: end if;
963: */
964:
965: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => p_itemtype,
966: itemkey => p_itemkey,
967: aname => 'DOCUMENT_ID');
968:
969: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => p_itemtype,

Line 969: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => p_itemtype,

965: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => p_itemtype,
966: itemkey => p_itemkey,
967: aname => 'DOCUMENT_ID');
968:
969: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => p_itemtype,
970: itemkey => p_itemkey,
971: aname => 'DOCUMENT_TYPE');
972:
973: -- abort any outstanding acceptance notifications for any previous revision of the document.

Line 1011: l_rspndr_usr_name := wf_engine.GetItemAttrText ( itemtype => p_itemtype,

1007: ELSE
1008: l_acc_po_header_id := NULL;
1009: END IF;
1010:
1011: l_rspndr_usr_name := wf_engine.GetItemAttrText ( itemtype => p_itemtype,
1012: itemkey => p_itemkey,
1013: aname => 'SUPPLIER_USER_NAME');
1014:
1015: begin

Line 1105: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

1101: l_ntf_role_name varchar2(320);
1102: begin
1103:
1104: -- set the org context
1105: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1106: itemkey => itemkey,
1107: aname => 'ORG_ID');
1108:
1109: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 1114: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

1110:
1111: fnd_message.set_name ('PO','PO_WF_REJECTED_VALUE');
1112: l_acceptance_result := fnd_message.get;
1113:
1114: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1115: itemkey => itemkey,
1116: aname => 'DOCUMENT_ID');
1117:
1118: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 1118: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

1114: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1115: itemkey => itemkey,
1116: aname => 'DOCUMENT_ID');
1117:
1118: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
1119: itemkey => itemkey,
1120: aname => 'DOCUMENT_TYPE');
1121:
1122: -- commented out the usage of accptance_type (FPI)

Line 1497: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

1493: l_revision_num number;
1494: x_progress varchar2(3) := '000';
1495: l_return_status varchar2(1);
1496: BEGIN
1497: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1498: itemkey => itemkey,
1499: aname => 'DOCUMENT_ID');
1500:
1501: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 1501: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

1497: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1498: itemkey => itemkey,
1499: aname => 'DOCUMENT_ID');
1500:
1501: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
1502: itemkey => itemkey,
1503: aname => 'DOCUMENT_TYPE');
1504: x_progress := '001';
1505: if (l_document_type_code <> 'RELEASE') then

Line 5157: l_header_id := wf_engine.GetItemAttrNumber(

5153:
5154: l_itemtype := 'POSCHORD';
5155: l_itemkey := document_id;
5156:
5157: l_header_id := wf_engine.GetItemAttrNumber(
5158: itemtype => l_itemtype,
5159: itemkey => l_itemkey,
5160: aname => 'PO_HEADER_ID');
5161:

Line 5162: l_release_id := wf_engine.GetItemAttrNumber(

5158: itemtype => l_itemtype,
5159: itemkey => l_itemkey,
5160: aname => 'PO_HEADER_ID');
5161:
5162: l_release_id := wf_engine.GetItemAttrNumber(
5163: itemtype => l_itemtype,
5164: itemkey => l_itemkey,
5165: aname => 'PO_RELEASE_ID');
5166:

Line 5167: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(

5163: itemtype => l_itemtype,
5164: itemkey => l_itemkey,
5165: aname => 'PO_RELEASE_ID');
5166:
5167: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(
5168: itemtype => l_itemtype,
5169: itemkey => l_itemkey,
5170: aname => 'CHANGE_REQUEST_GROUP_ID');
5171:

Line 5172: l_ack_req_flag := wf_engine.GetItemAttrText(

5168: itemtype => l_itemtype,
5169: itemkey => l_itemkey,
5170: aname => 'CHANGE_REQUEST_GROUP_ID');
5171:
5172: l_ack_req_flag := wf_engine.GetItemAttrText(
5173: itemtype => l_itemtype,
5174: itemkey => l_itemkey,
5175: aname => 'ACKNOWLEDGE_REQ_FLAG');
5176:

Line 5177: l_notif_usage := wf_engine.GetItemAttrText( -- RDP changes

5173: itemtype => l_itemtype,
5174: itemkey => l_itemkey,
5175: aname => 'ACKNOWLEDGE_REQ_FLAG');
5176:
5177: l_notif_usage := wf_engine.GetItemAttrText( -- RDP changes
5178: itemtype => l_itemtype,
5179: itemkey => l_itemKey,
5180: aname => 'NOTIF_USAGE');
5181:

Line 5379: l_header_id := wf_engine.GetItemAttrNumber(

5375:
5376: l_itemtype := 'POSCHORD';
5377: l_itemkey := document_id;
5378:
5379: l_header_id := wf_engine.GetItemAttrNumber(
5380: itemtype => l_itemtype,
5381: itemkey => l_itemkey,
5382: aname => 'PO_HEADER_ID');
5383:

Line 5384: l_release_id := wf_engine.GetItemAttrNumber(

5380: itemtype => l_itemtype,
5381: itemkey => l_itemkey,
5382: aname => 'PO_HEADER_ID');
5383:
5384: l_release_id := wf_engine.GetItemAttrNumber(
5385: itemtype => l_itemtype,
5386: itemkey => l_itemkey,
5387: aname => 'PO_RELEASE_ID');
5388:

Line 5389: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(

5385: itemtype => l_itemtype,
5386: itemkey => l_itemkey,
5387: aname => 'PO_RELEASE_ID');
5388:
5389: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(
5390: itemtype => l_itemtype,
5391: itemkey => l_itemkey,
5392: aname => 'CHANGE_REQUEST_GROUP_ID');
5393:

Line 5394: l_revision_num := wf_engine.GetItemAttrNumber(

5390: itemtype => l_itemtype,
5391: itemkey => l_itemkey,
5392: aname => 'CHANGE_REQUEST_GROUP_ID');
5393:
5394: l_revision_num := wf_engine.GetItemAttrNumber(
5395: itemtype => l_itemtype,
5396: itemkey => l_itemkey,
5397: aname => 'PO_REVISION_NUM');
5398:

Line 5563: l_header_id := wf_engine.GetItemAttrNumber(

5559:
5560: l_itemtype := 'POSCHORD';
5561: l_itemkey := document_id;
5562:
5563: l_header_id := wf_engine.GetItemAttrNumber(
5564: itemtype => l_itemtype,
5565: itemkey => l_itemkey,
5566: aname => 'PO_HEADER_ID');
5567:

Line 5568: l_release_id := wf_engine.GetItemAttrNumber(

5564: itemtype => l_itemtype,
5565: itemkey => l_itemkey,
5566: aname => 'PO_HEADER_ID');
5567:
5568: l_release_id := wf_engine.GetItemAttrNumber(
5569: itemtype => l_itemtype,
5570: itemkey => l_itemkey,
5571: aname => 'PO_RELEASE_ID');
5572:

Line 5573: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(

5569: itemtype => l_itemtype,
5570: itemkey => l_itemkey,
5571: aname => 'PO_RELEASE_ID');
5572:
5573: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(
5574: itemtype => l_itemtype,
5575: itemkey => l_itemkey,
5576: aname => 'CHANGE_REQUEST_GROUP_ID');
5577:

Line 5719: l_header_id := wf_engine.GetItemAttrNumber(

5715:
5716: l_itemtype := 'POSCHORD';
5717: l_itemkey := document_id;
5718:
5719: l_header_id := wf_engine.GetItemAttrNumber(
5720: itemtype => l_itemtype,
5721: itemkey => l_itemkey,
5722: aname => 'PO_HEADER_ID');
5723:

Line 5724: l_release_id := wf_engine.GetItemAttrNumber(

5720: itemtype => l_itemtype,
5721: itemkey => l_itemkey,
5722: aname => 'PO_HEADER_ID');
5723:
5724: l_release_id := wf_engine.GetItemAttrNumber(
5725: itemtype => l_itemtype,
5726: itemkey => l_itemkey,
5727: aname => 'PO_RELEASE_ID');
5728:

Line 5729: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(

5725: itemtype => l_itemtype,
5726: itemkey => l_itemkey,
5727: aname => 'PO_RELEASE_ID');
5728:
5729: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(
5730: itemtype => l_itemtype,
5731: itemkey => l_itemkey,
5732: aname => 'CHANGE_REQUEST_GROUP_ID');
5733:

Line 5855: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

5851: l_header_change number;
5852: l_retro_count number;
5853:
5854: BEGIN
5855: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5856: itemkey => itemkey,
5857: aname => 'CHANGE_REQUEST_GROUP_ID');
5858:
5859: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 5859: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

5855: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5856: itemkey => itemkey,
5857: aname => 'CHANGE_REQUEST_GROUP_ID');
5858:
5859: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5860: itemkey => itemkey,
5861: aname => 'PO_HEADER_ID');
5862:
5863: select count(*) into l_retro_count

Line 5888: wf_engine.SetItemAttrText(itemtype => itemtype, -- RDP if PRORATE,ADIITIONAL CHANGES , set the NOTIF_USAGE as BUYER_FYI

5884: and additional_changes is not null;
5885:
5886: if(l_temp is not null or l_header_change > 0 or l_retro_count > 0) then
5887: resultout := 'Y';
5888: wf_engine.SetItemAttrText(itemtype => itemtype, -- RDP if PRORATE,ADIITIONAL CHANGES , set the NOTIF_USAGE as BUYER_FYI
5889: itemkey => itemkey,
5890: aname => 'NOTIF_USAGE',
5891: avalue => 'BUYER_FYI');
5892:

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

5891: avalue => 'BUYER_FYI');
5892:
5893:
5894: if(l_header_change = 0) then -- RDP means no ADDITIONAL changes but PRORATE is required, set EXPLAIN_FYI
5895: wf_engine.SetItemAttrText ( itemtype => itemtype,
5896: itemkey => itemkey,
5897: aname => 'EXPLAIN_FYI',
5898: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_EXPLAIN_FYI'));
5899: else

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

5896: itemkey => itemkey,
5897: aname => 'EXPLAIN_FYI',
5898: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_EXPLAIN_FYI'));
5899: else
5900: wf_engine.SetItemAttrText ( itemtype => itemtype,
5901: itemkey => itemkey,
5902: aname => 'EXPLAIN_FYI',
5903: avalue => '');
5904: end if;

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

5904: end if;
5905:
5906: else
5907: resultout := 'N';
5908: wf_engine.SetItemAttrText ( itemtype => itemtype,
5909: itemkey => itemkey,
5910: aname => 'EXPLAIN_FYI',
5911: avalue => '');
5912:

Line 5940: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

5936:
5937: x_progress varchar2(3) := '000';
5938: BEGIN
5939:
5940: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5941: itemkey => itemkey,
5942: aname => 'PO_HEADER_ID');
5943: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5944: itemkey => itemkey,

Line 5943: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

5939:
5940: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5941: itemkey => itemkey,
5942: aname => 'PO_HEADER_ID');
5943: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5944: itemkey => itemkey,
5945: aname => 'PO_RELEASE_ID');
5946: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5947: itemkey => itemkey,

Line 5946: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,

5942: aname => 'PO_HEADER_ID');
5943: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5944: itemkey => itemkey,
5945: aname => 'PO_RELEASE_ID');
5946: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5947: itemkey => itemkey,
5948: aname => 'PO_REVISION_NUM');
5949: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5950: itemkey => itemkey,

Line 5949: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

5945: aname => 'PO_RELEASE_ID');
5946: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5947: itemkey => itemkey,
5948: aname => 'PO_REVISION_NUM');
5949: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5950: itemkey => itemkey,
5951: aname => 'CHANGE_REQUEST_GROUP_ID');
5952:
5953:

Line 6074: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

6070: l_carryover_status varchar2(1);
6071: l_carryover_exception exception;
6072: BEGIN
6073:
6074: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6075: itemkey => itemkey,
6076: aname => 'DOCUMENT_ID');
6077: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6078: itemkey => itemkey,

Line 6077: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,

6073:
6074: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6075: itemkey => itemkey,
6076: aname => 'DOCUMENT_ID');
6077: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6078: itemkey => itemkey,
6079: aname => 'DOCUMENT_TYPE');
6080: x_progress := '001';
6081: if(l_document_type = 'RELEASE') then

Line 6130: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

6126: l_document_type po_document_types_all.document_type_code%TYPE;
6127: l_acc_flag varchar2(1);
6128: x_progress varchar2(3) := '000';
6129: BEGIN
6130: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6131: itemkey => itemkey,
6132: aname => 'DOCUMENT_ID');
6133: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6134: itemkey => itemkey,

Line 6133: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,

6129: BEGIN
6130: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6131: itemkey => itemkey,
6132: aname => 'DOCUMENT_ID');
6133: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6134: itemkey => itemkey,
6135: aname => 'DOCUMENT_TYPE');
6136:
6137: if(l_document_type = 'RELEASE') then

Line 6224: t_varname Wf_Engine.NameTabTyp;

6220: u1 pls_integer := 0;
6221: --Bug 6722239 - End
6222:
6223: x_progress varchar2(100) := '000';
6224: t_varname Wf_Engine.NameTabTyp;
6225: t_varval Wf_Engine.TextTabTyp;
6226: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
6227: l_po_header_id po_headers_all.po_header_id%TYPE;
6228: l_id number;

Line 6225: t_varval Wf_Engine.TextTabTyp;

6221: --Bug 6722239 - End
6222:
6223: x_progress varchar2(100) := '000';
6224: t_varname Wf_Engine.NameTabTyp;
6225: t_varval Wf_Engine.TextTabTyp;
6226: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
6227: l_po_header_id po_headers_all.po_header_id%TYPE;
6228: l_id number;
6229: l_header_cancel varchar2(1);

Line 6278: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

6274: WHERE pcr.change_request_group_id = l_chg_req_grp_id_csr
6275: AND fndu.user_id = pcr.responded_by;
6276:
6277: BEGIN
6278: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6279: itemkey => itemkey,
6280: aname => 'DOCUMENT_ID');
6281:
6282: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 6282: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,

6278: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6279: itemkey => itemkey,
6280: aname => 'DOCUMENT_ID');
6281:
6282: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6283: itemkey => itemkey,
6284: aname => 'DOCUMENT_TYPE');
6285:
6286: if(l_document_type = 'RELEASE') then

Line 6713: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);

6709: t_varval(5) := 'BUYER_RESP';
6710: t_varname(6) := 'PO_STYLE_TYPE';
6711: t_varval(6) := l_po_style;
6712:
6713: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);
6714:
6715: exception when others then
6716: wf_core.context('PO_ChangeOrderWF_PVT','is_po_approved_by_hie',x_progress);
6717: raise;

Line 6733: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

6729: l_seq number;
6730: l_item_key varchar2(2000);
6731: x_progress varchar2(3) := '000';
6732: BEGIN
6733: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6734: itemkey => itemkey,
6735: aname => 'DOCUMENT_ID');
6736: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6737: itemkey => itemkey,

Line 6736: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,

6732: BEGIN
6733: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6734: itemkey => itemkey,
6735: aname => 'DOCUMENT_ID');
6736: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6737: itemkey => itemkey,
6738: aname => 'DOCUMENT_TYPE');
6739:
6740:

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

6747: l_item_key := 'SC_PO'||'-'||l_document_id||'-'||l_seq;
6748: end if;
6749:
6750:
6751: wf_engine.SetItemAttrText ( itemtype => itemtype,
6752: itemkey => itemkey,
6753: aname => 'SUP_CHANGE_EVENT_KEY',
6754: avalue => l_item_key );
6755:

Line 6786: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

6782: where action_type = 'MODIFICATION'
6783: and change_request_group_id = grp_id;
6784:
6785: BEGIN
6786: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6787: itemkey => itemkey,
6788: aname => 'PO_HEADER_ID');
6789: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6790: itemkey => itemkey,

Line 6789: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

6785: BEGIN
6786: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6787: itemkey => itemkey,
6788: aname => 'PO_HEADER_ID');
6789: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6790: itemkey => itemkey,
6791: aname => 'PO_RELEASE_ID');
6792:
6793: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 6793: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

6789: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6790: itemkey => itemkey,
6791: aname => 'PO_RELEASE_ID');
6792:
6793: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6794: itemkey => itemkey,
6795: aname => 'CHANGE_REQUEST_GROUP_ID');
6796: l_acc_req_flag := wf_engine.GetItemAttrText( itemtype => itemtype,
6797: itemkey => itemkey,

Line 6796: l_acc_req_flag := wf_engine.GetItemAttrText( itemtype => itemtype,

6792:
6793: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6794: itemkey => itemkey,
6795: aname => 'CHANGE_REQUEST_GROUP_ID');
6796: l_acc_req_flag := wf_engine.GetItemAttrText( itemtype => itemtype,
6797: itemkey => itemkey,
6798: aname => 'ACKNOWLEDGE_REQ_FLAG');
6799:
6800:

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

6829: end if;
6830: x_progress := '001';
6831: if(l_chg_req_grp_id is null) then
6832: resultout := 'N';
6833: wf_engine.SetItemAttrText ( itemtype => itemtype,
6834: itemkey => itemkey,
6835: aname => 'EXPLAIN_FYI',
6836: avalue => '');
6837:

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

6835: aname => 'EXPLAIN_FYI',
6836: avalue => '');
6837:
6838: if(l_acc_req_flag = 'Y') then -- RDP no changes just Acknowledged ( Set the NOTIF_USAGE as BUYER_ACK)
6839: wf_engine.SetItemAttrText ( itemtype => itemtype,
6840: itemkey => itemkey,
6841: aname => 'NOTIF_USAGE',
6842: avalue => 'BUYER_ACK');
6843: end if;

Line 6874: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

6870: x_progress varchar2(100) := '000';
6871: l_change_request_group_id number := null;
6872: BEGIN
6873:
6874: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6875: itemkey => itemkey,
6876: aname => 'DOCUMENT_ID');
6877: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6878: itemkey => itemkey,

Line 6877: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,

6873:
6874: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6875: itemkey => itemkey,
6876: aname => 'DOCUMENT_ID');
6877: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6878: itemkey => itemkey,
6879: aname => 'DOCUMENT_TYPE');
6880:
6881:

Line 7019: n_varname Wf_Engine.NameTabTyp;

7015: l_po_style varchar2(10);
7016: x_return_status varchar2(1);
7017: x_complex_flag varchar2(1);
7018:
7019: n_varname Wf_Engine.NameTabTyp;
7020: n_varval Wf_Engine.NumTabTyp;
7021: t_varname Wf_Engine.NameTabTyp;
7022: t_varval Wf_Engine.TextTabTyp;
7023:

Line 7020: n_varval Wf_Engine.NumTabTyp;

7016: x_return_status varchar2(1);
7017: x_complex_flag varchar2(1);
7018:
7019: n_varname Wf_Engine.NameTabTyp;
7020: n_varval Wf_Engine.NumTabTyp;
7021: t_varname Wf_Engine.NameTabTyp;
7022: t_varval Wf_Engine.TextTabTyp;
7023:
7024:

Line 7021: t_varname Wf_Engine.NameTabTyp;

7017: x_complex_flag varchar2(1);
7018:
7019: n_varname Wf_Engine.NameTabTyp;
7020: n_varval Wf_Engine.NumTabTyp;
7021: t_varname Wf_Engine.NameTabTyp;
7022: t_varval Wf_Engine.TextTabTyp;
7023:
7024:
7025: --l_id number;

Line 7022: t_varval Wf_Engine.TextTabTyp;

7018:
7019: n_varname Wf_Engine.NameTabTyp;
7020: n_varval Wf_Engine.NumTabTyp;
7021: t_varname Wf_Engine.NameTabTyp;
7022: t_varval Wf_Engine.TextTabTyp;
7023:
7024:
7025: --l_id number;
7026: --l_header_cancel varchar2(1);

Line 7055: wf_engine.createProcess ( ItemType => 'POSCHORD',

7051: l_document_id := p_header_id;
7052: l_item_key := 'NSCR'||'-'||to_char(p_header_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
7053: end if;
7054:
7055: wf_engine.createProcess ( ItemType => 'POSCHORD',
7056: ItemKey => l_item_key,
7057: Process => 'CHG_RESPONDED_FYI_TO_SUPPLIER');
7058:
7059: l_progress := '001';

Line 7184: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);

7180: t_varname(7) := '#WFM_HTMLAGENT';
7181: t_varval(7) := fnd_profile.value('POS_EXTERNAL_URL');
7182:
7183:
7184: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7185: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
7186: l_progress := '003';
7187: wf_engine.StartProcess( ItemType => 'POSCHORD',
7188: ItemKey => l_item_key);

Line 7185: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);

7181: t_varval(7) := fnd_profile.value('POS_EXTERNAL_URL');
7182:
7183:
7184: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7185: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
7186: l_progress := '003';
7187: wf_engine.StartProcess( ItemType => 'POSCHORD',
7188: ItemKey => l_item_key);
7189:

Line 7187: wf_engine.StartProcess( ItemType => 'POSCHORD',

7183:
7184: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7185: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
7186: l_progress := '003';
7187: wf_engine.StartProcess( ItemType => 'POSCHORD',
7188: ItemKey => l_item_key);
7189:
7190: exception when others then
7191: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 7462: wf_engine.completeActivity('POSCHORD',l_item_key,'NOTIFY_BUYER_OF_CHN', 'Abort');

7458: select distinct wf_item_key
7459: into l_item_key
7460: from po_change_requests
7461: where change_request_group_id = p_chg_req_grp_id;
7462: wf_engine.completeActivity('POSCHORD',l_item_key,'NOTIFY_BUYER_OF_CHN', 'Abort');
7463: exception when others then
7464: null;
7465: end;
7466: end if;

Line 7639: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7635: and msi.planner_code = mtp.planner_code
7636: and msi.organization_id = mtp.organization_id;
7637:
7638: BEGIN
7639: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7640: itemkey => itemkey,
7641: aname => 'PO_HEADER_ID');
7642: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7643: itemkey => itemkey,

Line 7642: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7638: BEGIN
7639: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7640: itemkey => itemkey,
7641: aname => 'PO_HEADER_ID');
7642: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7643: itemkey => itemkey,
7644: aname => 'PO_RELEASE_ID');
7645: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7646: itemkey => itemkey,

Line 7645: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7641: aname => 'PO_HEADER_ID');
7642: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7643: itemkey => itemkey,
7644: aname => 'PO_RELEASE_ID');
7645: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7646: itemkey => itemkey,
7647: aname => 'PO_REVISION_NUM');
7648:
7649: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 7649: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7645: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7646: itemkey => itemkey,
7647: aname => 'PO_REVISION_NUM');
7648:
7649: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7650: itemkey => itemkey,
7651: aname => 'CHANGE_REQUEST_GROUP_ID');
7652: if(l_release_id is null) then
7653: select agent_id

Line 7721: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7717: l_return_status varchar2(1);
7718: l_doc_check_rec_type POS_ERR_TYPE;
7719:
7720: BEGIN
7721: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7722: itemkey => itemkey,
7723: aname => 'PO_HEADER_ID');
7724: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7725: itemkey => itemkey,

Line 7724: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7720: BEGIN
7721: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7722: itemkey => itemkey,
7723: aname => 'PO_HEADER_ID');
7724: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7725: itemkey => itemkey,
7726: aname => 'PO_RELEASE_ID');
7727: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7728: itemkey => itemkey,

Line 7727: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7723: aname => 'PO_HEADER_ID');
7724: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7725: itemkey => itemkey,
7726: aname => 'PO_RELEASE_ID');
7727: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7728: itemkey => itemkey,
7729: aname => 'PO_REVISION_NUM');
7730: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7731: itemkey => itemkey,

Line 7730: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7726: aname => 'PO_RELEASE_ID');
7727: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7728: itemkey => itemkey,
7729: aname => 'PO_REVISION_NUM');
7730: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7731: itemkey => itemkey,
7732: aname => 'CHANGE_REQUEST_GROUP_ID');
7733:
7734: x_progress := '001';

Line 7757: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7753: l_notif_usage VARCHAR2(30);
7754:
7755: BEGIN
7756:
7757: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7758: itemkey => itemkey,
7759: aname => 'CHANGE_REQUEST_GROUP_ID');
7760:
7761: l_notif_usage := wf_engine.GetItemAttrText(itemtype =>itemtype,

Line 7761: l_notif_usage := wf_engine.GetItemAttrText(itemtype =>itemtype,

7757: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7758: itemkey => itemkey,
7759: aname => 'CHANGE_REQUEST_GROUP_ID');
7760:
7761: l_notif_usage := wf_engine.GetItemAttrText(itemtype =>itemtype,
7762: itemkey => itemKey,
7763: aname => 'NOTIF_USAGE');
7764:
7765: IF( l_notif_usage = 'BUYER_AUTO_FYI') THEN

Line 7808: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

7804: l_req_hdr_id number;
7805: l_po_header_id number;
7806: BEGIN
7807:
7808: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7809: itemkey => itemkey,
7810: aname => 'CHANGE_REQUEST_GROUP_ID');
7811:
7812:

Line 7813: l_notif_usage := wf_engine.GetItemAttrText(itemtype => itemtype,

7809: itemkey => itemkey,
7810: aname => 'CHANGE_REQUEST_GROUP_ID');
7811:
7812:
7813: l_notif_usage := wf_engine.GetItemAttrText(itemtype => itemtype,
7814: itemkey => itemkey,
7815: aname => 'NOTIF_USAGE');
7816:
7817: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 7817: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

7813: l_notif_usage := wf_engine.GetItemAttrText(itemtype => itemtype,
7814: itemkey => itemkey,
7815: aname => 'NOTIF_USAGE');
7816:
7817: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7818: itemkey => itemkey,
7819: aname => 'PO_HEADER_ID');
7820:
7821: -- Withdraw the lock from requisition , if the changes have been rejected by the requester

Line 7877: n_varname Wf_Engine.NameTabTyp;

7873: l_buyer_agent_id number;
7874: l_buyer_username fnd_user.user_name%TYPE;
7875: l_supplier_username fnd_user.user_name%TYPE;
7876: l_buyer_disp_name varchar2(2000);
7877: n_varname Wf_Engine.NameTabTyp;
7878: n_varval Wf_Engine.NumTabTyp;
7879: t_varname Wf_Engine.NameTabTyp;
7880: t_varval Wf_Engine.TextTabTyp;
7881: x_ret_status varchar2(1);

Line 7878: n_varval Wf_Engine.NumTabTyp;

7874: l_buyer_username fnd_user.user_name%TYPE;
7875: l_supplier_username fnd_user.user_name%TYPE;
7876: l_buyer_disp_name varchar2(2000);
7877: n_varname Wf_Engine.NameTabTyp;
7878: n_varval Wf_Engine.NumTabTyp;
7879: t_varname Wf_Engine.NameTabTyp;
7880: t_varval Wf_Engine.TextTabTyp;
7881: x_ret_status varchar2(1);
7882: x_complex_flag varchar2(1);

Line 7879: t_varname Wf_Engine.NameTabTyp;

7875: l_supplier_username fnd_user.user_name%TYPE;
7876: l_buyer_disp_name varchar2(2000);
7877: n_varname Wf_Engine.NameTabTyp;
7878: n_varval Wf_Engine.NumTabTyp;
7879: t_varname Wf_Engine.NameTabTyp;
7880: t_varval Wf_Engine.TextTabTyp;
7881: x_ret_status varchar2(1);
7882: x_complex_flag varchar2(1);
7883:

Line 7880: t_varval Wf_Engine.TextTabTyp;

7876: l_buyer_disp_name varchar2(2000);
7877: n_varname Wf_Engine.NameTabTyp;
7878: n_varval Wf_Engine.NumTabTyp;
7879: t_varname Wf_Engine.NameTabTyp;
7880: t_varval Wf_Engine.TextTabTyp;
7881: x_ret_status varchar2(1);
7882: x_complex_flag varchar2(1);
7883:
7884:

Line 7904: wf_engine.createProcess ( ItemType => 'POSCHORD',

7900:
7901:
7902:
7903:
7904: wf_engine.createProcess ( ItemType => 'POSCHORD',
7905: ItemKey => l_item_key,
7906: Process => 'MAIN_PROCESS');
7907:
7908: l_progress := '001';

Line 7918: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',

7914: into l_supplier_username
7915: from fnd_user
7916: where user_id = fnd_global.user_id;
7917:
7918: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7919: itemkey => l_item_key,
7920: aname => 'RESP_ID',
7921: avalue => fnd_global.RESP_ID);
7922:

Line 7923: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',

7919: itemkey => l_item_key,
7920: aname => 'RESP_ID',
7921: avalue => fnd_global.RESP_ID);
7922:
7923: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7924: itemkey => l_item_key,
7925: aname => 'APPL_RESP_ID',
7926: avalue => fnd_global.RESP_APPL_ID);
7927:

Line 8017: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);

8013: t_varval(5) := p_acc_req_flag;
8014: t_varname(6) := 'PO_STYLE_TYPE';
8015: t_varval(6) := l_po_style;
8016:
8017: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
8018: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
8019:
8020:
8021:

Line 8018: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);

8014: t_varname(6) := 'PO_STYLE_TYPE';
8015: t_varval(6) := l_po_style;
8016:
8017: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
8018: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
8019:
8020:
8021:
8022: /*update data to include wf item key and item type. p_chg_req_grp_id could be null in the case where user accepts/rejects

Line 8032: wf_engine.StartProcess( ItemType => 'POSCHORD',

8028: where change_request_group_id = p_chg_req_grp_id;
8029: end if;
8030: l_progress := '004';
8031:
8032: wf_engine.StartProcess( ItemType => 'POSCHORD',
8033: ItemKey => l_item_key);
8034:
8035: x_return_status := FND_API.G_RET_STS_SUCCESS;
8036: exception when others then

Line 8740: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);

8736: l_action := 'ANSWER';
8737: end if;
8738:
8739:
8740: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);
8741: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 02.';
8742:
8743: if (p_funcmode = 'RESPOND') then
8744: l_notification_id := WF_ENGINE.context_nid;

Line 8744: l_notification_id := WF_ENGINE.context_nid;

8740: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);
8741: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 02.';
8742:
8743: if (p_funcmode = 'RESPOND') then
8744: l_notification_id := WF_ENGINE.context_nid;
8745: IF (g_fnd_debug = 'Y') THEN
8746: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_api_name, 'l_notification_id '||l_notification_id );
8747: END IF;
8748: l_result := wf_notification.GetAttrText(l_notification_id, 'RESULT');

Line 8757: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => p_itemtype,

8753:
8754: if (l_result = 'FORWARD') THEN
8755:
8756: l_forwardTo := wf_notification.GetAttrText(l_notification_id, 'FORWARD_TO_USERNAME_RESPONSE');
8757: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => p_itemtype,
8758: itemkey => p_itemkey,
8759: aname => 'FORWARD_TO_USERNAME_RESPONSE');
8760:
8761: if(l_forwardTo is null) then

Line 8767: if (wf_engine.preserved_context = TRUE) then

8763: app_exception.raise_exception;
8764: end if;
8765: end if;
8766:
8767: if (wf_engine.preserved_context = TRUE) then
8768: l_preserved_ctx := 'TRUE';
8769: else
8770: l_preserved_ctx := 'FALSE';
8771: end if;

Line 8828: l_preparer_resp_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

8824: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_session_appl_id ' ||l_session_appl_id);
8825: END IF;
8826: --
8827:
8828: l_preparer_resp_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
8829: itemkey => p_itemkey,
8830: aname => 'RESP_ID');
8831: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
8832: itemkey => p_itemkey,

Line 8831: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

8827:
8828: l_preparer_resp_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
8829: itemkey => p_itemkey,
8830: aname => 'RESP_ID');
8831: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
8832: itemkey => p_itemkey,
8833: aname => 'APPLICATION_ID');
8834:
8835: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 05.' ;

Line 8859: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8855: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress ' ||l_progress || 'When the response is made from email using guest user feature');
8856: END IF;
8857: --
8858:
8859: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8860: itemkey => p_itemkey,
8861: aname => 'RESPONDER_USER_ID',
8862: avalue => l_responder_id);
8863: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 8863: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8859: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8860: itemkey => p_itemkey,
8861: aname => 'RESPONDER_USER_ID',
8862: avalue => l_responder_id);
8863: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8864: itemkey => p_itemkey,
8865: aname => 'RESPONDER_RESP_ID',
8866: avalue => l_preparer_resp_id);
8867: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 8867: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8863: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8864: itemkey => p_itemkey,
8865: aname => 'RESPONDER_RESP_ID',
8866: avalue => l_preparer_resp_id);
8867: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8868: itemkey => p_itemkey,
8869: aname => 'RESPONDER_APPL_ID',
8870: avalue => l_preparer_appl_id);
8871: ELSE

Line 8888: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8884: IF (g_fnd_debug = 'Y') THEN
8885: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,l_api_name,'l_progress '||l_progress || 'When the response is made from the default worklist');
8886: END IF;
8887: --
8888: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8889: itemkey => p_itemkey,
8890: aname => 'RESPONDER_USER_ID',
8891: avalue => l_responder_id);
8892: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 8892: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8888: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8889: itemkey => p_itemkey,
8890: aname => 'RESPONDER_USER_ID',
8891: avalue => l_responder_id);
8892: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8893: itemkey => p_itemkey,
8894: aname => 'RESPONDER_RESP_ID',
8895: avalue => l_preparer_resp_id);
8896: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 8896: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8892: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8893: itemkey => p_itemkey,
8894: aname => 'RESPONDER_RESP_ID',
8895: avalue => l_preparer_resp_id);
8896: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8897: itemkey => p_itemkey,
8898: aname => 'RESPONDER_APPL_ID',
8899: avalue => l_preparer_appl_id);
8900: else

Line 8919: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8915: END IF;
8916: --
8917:
8918: if ( l_preserved_ctx = 'TRUE') then
8919: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8920: itemkey => p_itemkey,
8921: aname => 'RESPONDER_USER_ID',
8922: avalue => l_responder_id);
8923: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 8923: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8919: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8920: itemkey => p_itemkey,
8921: aname => 'RESPONDER_USER_ID',
8922: avalue => l_responder_id);
8923: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8924: itemkey => p_itemkey,
8925: aname => 'RESPONDER_RESP_ID',
8926: avalue => l_session_resp_id);
8927: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 8927: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8923: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8924: itemkey => p_itemkey,
8925: aname => 'RESPONDER_RESP_ID',
8926: avalue => l_session_resp_id);
8927: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8928: itemkey => p_itemkey,
8929: aname => 'RESPONDER_APPL_ID',
8930: avalue => l_session_appl_id);
8931: else

Line 8932: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8928: itemkey => p_itemkey,
8929: aname => 'RESPONDER_APPL_ID',
8930: avalue => l_session_appl_id);
8931: else
8932: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8933: itemkey => p_itemkey,
8934: aname => 'RESPONDER_USER_ID',
8935: avalue => l_responder_id);
8936: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 8936: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8932: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8933: itemkey => p_itemkey,
8934: aname => 'RESPONDER_USER_ID',
8935: avalue => l_responder_id);
8936: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8937: itemkey => p_itemkey,
8938: aname => 'RESPONDER_RESP_ID',
8939: avalue => l_preparer_resp_id);
8940: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 8940: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

8936: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8937: itemkey => p_itemkey,
8938: aname => 'RESPONDER_RESP_ID',
8939: avalue => l_preparer_resp_id);
8940: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
8941: itemkey => p_itemkey,
8942: aname => 'RESPONDER_APPL_ID',
8943: avalue => l_preparer_appl_id);
8944: end if;

Line 8950: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

8946: end if;
8947: end if;
8948: end if;
8949:
8950: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
8951: return;
8952: end if;
8953:
8954:

Line 9042: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

9038: END IF;
9039: --
9040:
9041:
9042: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9043: itemkey => p_itemkey,
9044: aname => 'ORG_ID');
9045: l_session_user_id := fnd_global.user_id;
9046: l_session_resp_id := fnd_global.resp_id;

Line 9056: l_responder_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

9052: IF (l_session_resp_id = -1) THEN
9053: l_session_resp_id := NULL;
9054: END IF;
9055:
9056: l_responder_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
9057: itemkey => p_itemkey,
9058: aname => 'RESPONDER_USER_ID');
9059:
9060: --

Line 9089: if (wf_engine.preserved_context = TRUE) then

9085: -- context. This is required since the mailer/bckgrnd ps carries the
9086: -- context from the last wf processed and hence even if the context values
9087: -- are present, they might not be correct.
9088:
9089: if (wf_engine.preserved_context = TRUE) then
9090: resultout := 'TRUE';
9091: else
9092: resultout:= 'NOTSET';
9093: end if;

Line 9115: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

9111: if l_responder_id is not null then
9112:
9113: l_user_id_to_set := l_responder_id;
9114:
9115: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9116: itemkey => p_itemkey,
9117: aname => 'RESPONDER_RESP_ID');
9118: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9119: itemkey => p_itemkey,

Line 9118: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

9114:
9115: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9116: itemkey => p_itemkey,
9117: aname => 'RESPONDER_RESP_ID');
9118: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9119: itemkey => p_itemkey,
9120: aname => 'RESPONDER_APPL_ID');
9121: --
9122: l_progress := '020 selection fn responder id not null';

Line 9137: l_user_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

9133: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.PO_ChangeOrderWF_PVT.PO_SUPCHG_SELECTOR.invoked','l_progress3 : '||l_progress);
9134: END IF;
9135: --
9136: else
9137: l_user_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9138: itemkey => p_itemkey,
9139: aname => 'USER_ID');
9140: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9141: itemkey => p_itemkey,

Line 9140: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

9136: else
9137: l_user_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9138: itemkey => p_itemkey,
9139: aname => 'USER_ID');
9140: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9141: itemkey => p_itemkey,
9142: aname => 'RESP_ID');
9143: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9144: itemkey => p_itemkey,

Line 9143: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

9139: aname => 'USER_ID');
9140: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9141: itemkey => p_itemkey,
9142: aname => 'RESP_ID');
9143: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
9144: itemkey => p_itemkey,
9145: aname => 'APPLICATION_ID');
9146: --
9147: l_progress := '040 selector fn responder id null';