APPS.PO_CHANGEORDERWF_PVT dependencies on WF_ENGINE

Line 97: n_varname Wf_Engine.NameTabTyp;

93: l_supplier_username fnd_user.user_name%type;
94: l_requestor_username fnd_user.user_name%type;
95: l_requestor_disp_name varchar2(2000);
96:
97: n_varname Wf_Engine.NameTabTyp;
98: n_varval Wf_Engine.NumTabTyp;
99: t_varname Wf_Engine.NameTabTyp;
100: t_varval Wf_Engine.TextTabTyp;
101: BEGIN

Line 98: n_varval Wf_Engine.NumTabTyp;

94: l_requestor_username fnd_user.user_name%type;
95: l_requestor_disp_name varchar2(2000);
96:
97: n_varname Wf_Engine.NameTabTyp;
98: n_varval Wf_Engine.NumTabTyp;
99: t_varname Wf_Engine.NameTabTyp;
100: t_varval Wf_Engine.TextTabTyp;
101: BEGIN
102:

Line 99: t_varname Wf_Engine.NameTabTyp;

95: l_requestor_disp_name varchar2(2000);
96:
97: n_varname Wf_Engine.NameTabTyp;
98: n_varval Wf_Engine.NumTabTyp;
99: t_varname Wf_Engine.NameTabTyp;
100: t_varval Wf_Engine.TextTabTyp;
101: BEGIN
102:
103: if(p_requestor_id is null or p_chg_req_grp_id is null) then

Line 100: t_varval Wf_Engine.TextTabTyp;

96:
97: n_varname Wf_Engine.NameTabTyp;
98: n_varval Wf_Engine.NumTabTyp;
99: t_varname Wf_Engine.NameTabTyp;
100: t_varval Wf_Engine.TextTabTyp;
101: BEGIN
102:
103: if(p_requestor_id is null or p_chg_req_grp_id is null) then
104: return;

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

112: end if;
113:
114: l_progress := '001';
115:
116: wf_engine.createProcess ( ItemType => 'POSCHORD',
117: ItemKey => l_item_key,
118: Process => 'NOTIFY_REQUESTER_SUP_CHN');
119:
120: l_progress := '002';

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

156:
157:
158: l_progress := '004';
159:
160: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
161: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
162:
163: wf_engine.StartProcess( ItemType => 'POSCHORD',
164: ItemKey => l_item_key);

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

157:
158: l_progress := '004';
159:
160: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
161: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
162:
163: wf_engine.StartProcess( ItemType => 'POSCHORD',
164: ItemKey => l_item_key);
165: END IF;

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

159:
160: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
161: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
162:
163: wf_engine.StartProcess( ItemType => 'POSCHORD',
164: ItemKey => l_item_key);
165: END IF;
166: exception when others then
167: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 190: n_varname Wf_Engine.NameTabTyp;

186: l_planner_username fnd_user.user_name%type;
187: l_planner_disp_name varchar2(2000);
188: l_type_lookup_code po_headers_all.type_lookup_code%type;
189:
190: n_varname Wf_Engine.NameTabTyp;
191: n_varval Wf_Engine.NumTabTyp;
192: t_varname Wf_Engine.NameTabTyp;
193: t_varval Wf_Engine.TextTabTyp;
194:

Line 191: n_varval Wf_Engine.NumTabTyp;

187: l_planner_disp_name varchar2(2000);
188: l_type_lookup_code po_headers_all.type_lookup_code%type;
189:
190: n_varname Wf_Engine.NameTabTyp;
191: n_varval Wf_Engine.NumTabTyp;
192: t_varname Wf_Engine.NameTabTyp;
193: t_varval Wf_Engine.TextTabTyp;
194:
195: BEGIN

Line 192: t_varname Wf_Engine.NameTabTyp;

188: l_type_lookup_code po_headers_all.type_lookup_code%type;
189:
190: n_varname Wf_Engine.NameTabTyp;
191: n_varval Wf_Engine.NumTabTyp;
192: t_varname Wf_Engine.NameTabTyp;
193: t_varval Wf_Engine.TextTabTyp;
194:
195: BEGIN
196:

Line 193: t_varval Wf_Engine.TextTabTyp;

189:
190: n_varname Wf_Engine.NameTabTyp;
191: n_varval Wf_Engine.NumTabTyp;
192: t_varname Wf_Engine.NameTabTyp;
193: t_varval Wf_Engine.TextTabTyp;
194:
195: BEGIN
196:
197: if(p_planner_id is null or p_chg_req_grp_id is null) then

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

206: l_item_key := 'NPSC-'||to_char(p_planner_id)||'-'||to_char(p_release_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
207: end if;
208:
209: l_progress := '001';
210: wf_engine.createProcess ( ItemType => 'POSCHORD',
211: ItemKey => l_item_key,
212: Process => 'NOTIFY_PLANNER_SUP_CHN');
213:
214: l_progress := '002';

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

252:
253:
254: l_progress := '004';
255:
256: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
257: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
258:
259: wf_engine.StartProcess( ItemType => 'POSCHORD',
260: ItemKey => l_item_key);

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

253:
254: l_progress := '004';
255:
256: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
257: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
258:
259: wf_engine.StartProcess( ItemType => 'POSCHORD',
260: ItemKey => l_item_key);
261: END IF;

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

255:
256: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
257: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
258:
259: wf_engine.StartProcess( ItemType => 'POSCHORD',
260: ItemKey => l_item_key);
261: END IF;
262: exception when others then
263: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

846: SELECT po_acceptances_s.nextval into l_Acceptance_id FROM sys.dual;
847:
848: -- commented out the usage of accptance_type (FPI)
849: /*
850: l_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => p_itemtype,
851: itemkey => p_itemkey,
852: aname => 'ACCEPTANCE_LOOKUP_CODE');
853: */
854:

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

866: end if;
867: end if;
868: */
869:
870: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => p_itemtype,
871: itemkey => p_itemkey,
872: aname => 'DOCUMENT_ID');
873:
874: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => p_itemtype,

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

870: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => p_itemtype,
871: itemkey => p_itemkey,
872: aname => 'DOCUMENT_ID');
873:
874: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => p_itemtype,
875: itemkey => p_itemkey,
876: aname => 'DOCUMENT_TYPE');
877:
878: -- abort any outstanding acceptance notifications for any previous revision of the document.

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

912: ELSE
913: l_acc_po_header_id := NULL;
914: END IF;
915:
916: l_rspndr_usr_name := wf_engine.GetItemAttrText ( itemtype => p_itemtype,
917: itemkey => p_itemkey,
918: aname => 'SUPPLIER_USER_NAME');
919:
920: begin

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

1006: l_ntf_role_name varchar2(320);
1007: begin
1008:
1009: -- set the org context
1010: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1011: itemkey => itemkey,
1012: aname => 'ORG_ID');
1013:
1014: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

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

1015:
1016: fnd_message.set_name ('PO','PO_WF_REJECTED_VALUE');
1017: l_acceptance_result := fnd_message.get;
1018:
1019: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1020: itemkey => itemkey,
1021: aname => 'DOCUMENT_ID');
1022:
1023: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

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

1019: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1020: itemkey => itemkey,
1021: aname => 'DOCUMENT_ID');
1022:
1023: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
1024: itemkey => itemkey,
1025: aname => 'DOCUMENT_TYPE');
1026:
1027: -- commented out the usage of accptance_type (FPI)

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

1352: l_revision_num number;
1353: x_progress varchar2(3) := '000';
1354: l_return_status varchar2(1);
1355: BEGIN
1356: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => 'DOCUMENT_ID');
1359:
1360: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

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

1356: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1357: itemkey => itemkey,
1358: aname => 'DOCUMENT_ID');
1359:
1360: l_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'DOCUMENT_TYPE');
1363: x_progress := '001';
1364: if (l_document_type_code <> 'RELEASE') then

Line 5005: l_header_id := wf_engine.GetItemAttrNumber(

5001:
5002: l_itemtype := 'POSCHORD';
5003: l_itemkey := document_id;
5004:
5005: l_header_id := wf_engine.GetItemAttrNumber(
5006: itemtype => l_itemtype,
5007: itemkey => l_itemkey,
5008: aname => 'PO_HEADER_ID');
5009:

Line 5010: l_release_id := wf_engine.GetItemAttrNumber(

5006: itemtype => l_itemtype,
5007: itemkey => l_itemkey,
5008: aname => 'PO_HEADER_ID');
5009:
5010: l_release_id := wf_engine.GetItemAttrNumber(
5011: itemtype => l_itemtype,
5012: itemkey => l_itemkey,
5013: aname => 'PO_RELEASE_ID');
5014:

Line 5015: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(

5011: itemtype => l_itemtype,
5012: itemkey => l_itemkey,
5013: aname => 'PO_RELEASE_ID');
5014:
5015: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(
5016: itemtype => l_itemtype,
5017: itemkey => l_itemkey,
5018: aname => 'CHANGE_REQUEST_GROUP_ID');
5019:

Line 5020: l_ack_req_flag := wf_engine.GetItemAttrText(

5016: itemtype => l_itemtype,
5017: itemkey => l_itemkey,
5018: aname => 'CHANGE_REQUEST_GROUP_ID');
5019:
5020: l_ack_req_flag := wf_engine.GetItemAttrText(
5021: itemtype => l_itemtype,
5022: itemkey => l_itemkey,
5023: aname => 'ACKNOWLEDGE_REQ_FLAG');
5024:

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

5021: itemtype => l_itemtype,
5022: itemkey => l_itemkey,
5023: aname => 'ACKNOWLEDGE_REQ_FLAG');
5024:
5025: l_notif_usage := wf_engine.GetItemAttrText( -- RDP changes
5026: itemtype => l_itemtype,
5027: itemkey => l_itemKey,
5028: aname => 'NOTIF_USAGE');
5029:

Line 5225: l_header_id := wf_engine.GetItemAttrNumber(

5221:
5222: l_itemtype := 'POSCHORD';
5223: l_itemkey := document_id;
5224:
5225: l_header_id := wf_engine.GetItemAttrNumber(
5226: itemtype => l_itemtype,
5227: itemkey => l_itemkey,
5228: aname => 'PO_HEADER_ID');
5229:

Line 5230: l_release_id := wf_engine.GetItemAttrNumber(

5226: itemtype => l_itemtype,
5227: itemkey => l_itemkey,
5228: aname => 'PO_HEADER_ID');
5229:
5230: l_release_id := wf_engine.GetItemAttrNumber(
5231: itemtype => l_itemtype,
5232: itemkey => l_itemkey,
5233: aname => 'PO_RELEASE_ID');
5234:

Line 5235: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(

5231: itemtype => l_itemtype,
5232: itemkey => l_itemkey,
5233: aname => 'PO_RELEASE_ID');
5234:
5235: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(
5236: itemtype => l_itemtype,
5237: itemkey => l_itemkey,
5238: aname => 'CHANGE_REQUEST_GROUP_ID');
5239:

Line 5240: l_revision_num := wf_engine.GetItemAttrNumber(

5236: itemtype => l_itemtype,
5237: itemkey => l_itemkey,
5238: aname => 'CHANGE_REQUEST_GROUP_ID');
5239:
5240: l_revision_num := wf_engine.GetItemAttrNumber(
5241: itemtype => l_itemtype,
5242: itemkey => l_itemkey,
5243: aname => 'PO_REVISION_NUM');
5244:

Line 5409: l_header_id := wf_engine.GetItemAttrNumber(

5405:
5406: l_itemtype := 'POSCHORD';
5407: l_itemkey := document_id;
5408:
5409: l_header_id := wf_engine.GetItemAttrNumber(
5410: itemtype => l_itemtype,
5411: itemkey => l_itemkey,
5412: aname => 'PO_HEADER_ID');
5413:

Line 5414: l_release_id := wf_engine.GetItemAttrNumber(

5410: itemtype => l_itemtype,
5411: itemkey => l_itemkey,
5412: aname => 'PO_HEADER_ID');
5413:
5414: l_release_id := wf_engine.GetItemAttrNumber(
5415: itemtype => l_itemtype,
5416: itemkey => l_itemkey,
5417: aname => 'PO_RELEASE_ID');
5418:

Line 5419: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(

5415: itemtype => l_itemtype,
5416: itemkey => l_itemkey,
5417: aname => 'PO_RELEASE_ID');
5418:
5419: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(
5420: itemtype => l_itemtype,
5421: itemkey => l_itemkey,
5422: aname => 'CHANGE_REQUEST_GROUP_ID');
5423:

Line 5565: l_header_id := wf_engine.GetItemAttrNumber(

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

Line 5570: l_release_id := wf_engine.GetItemAttrNumber(

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

Line 5575: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(

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

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

5697: l_header_change number;
5698: l_retro_count number;
5699:
5700: BEGIN
5701: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5702: itemkey => itemkey,
5703: aname => 'CHANGE_REQUEST_GROUP_ID');
5704:
5705: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

5701: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5702: itemkey => itemkey,
5703: aname => 'CHANGE_REQUEST_GROUP_ID');
5704:
5705: l_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5706: itemkey => itemkey,
5707: aname => 'PO_HEADER_ID');
5708:
5709: select count(*) into l_retro_count

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

5730: and additional_changes is not null;
5731:
5732: if(l_temp is not null or l_header_change > 0 or l_retro_count > 0) then
5733: resultout := 'Y';
5734: wf_engine.SetItemAttrText(itemtype => itemtype, -- RDP if PRORATE,ADIITIONAL CHANGES , set the NOTIF_USAGE as BUYER_FYI
5735: itemkey => itemkey,
5736: aname => 'NOTIF_USAGE',
5737: avalue => 'BUYER_FYI');
5738:

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

5737: avalue => 'BUYER_FYI');
5738:
5739:
5740: if(l_header_change = 0) then -- RDP means no ADDITIONAL changes but PRORATE is required, set EXPLAIN_FYI
5741: wf_engine.SetItemAttrText ( itemtype => itemtype,
5742: itemkey => itemkey,
5743: aname => 'EXPLAIN_FYI',
5744: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_EXPLAIN_FYI'));
5745: else

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

5742: itemkey => itemkey,
5743: aname => 'EXPLAIN_FYI',
5744: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_EXPLAIN_FYI'));
5745: else
5746: wf_engine.SetItemAttrText ( itemtype => itemtype,
5747: itemkey => itemkey,
5748: aname => 'EXPLAIN_FYI',
5749: avalue => '');
5750: end if;

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

5750: end if;
5751:
5752: else
5753: resultout := 'N';
5754: wf_engine.SetItemAttrText ( itemtype => itemtype,
5755: itemkey => itemkey,
5756: aname => 'EXPLAIN_FYI',
5757: avalue => '');
5758:

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

5782:
5783: x_progress varchar2(3) := '000';
5784: BEGIN
5785:
5786: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5787: itemkey => itemkey,
5788: aname => 'PO_HEADER_ID');
5789: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5790: itemkey => itemkey,

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

5785:
5786: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5787: itemkey => itemkey,
5788: aname => 'PO_HEADER_ID');
5789: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5790: itemkey => itemkey,
5791: aname => 'PO_RELEASE_ID');
5792: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5793: itemkey => itemkey,

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

5788: aname => 'PO_HEADER_ID');
5789: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5790: itemkey => itemkey,
5791: aname => 'PO_RELEASE_ID');
5792: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5793: itemkey => itemkey,
5794: aname => 'PO_REVISION_NUM');
5795: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5796: itemkey => itemkey,

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

5791: aname => 'PO_RELEASE_ID');
5792: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5793: itemkey => itemkey,
5794: aname => 'PO_REVISION_NUM');
5795: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5796: itemkey => itemkey,
5797: aname => 'CHANGE_REQUEST_GROUP_ID');
5798:
5799:

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

5916: l_carryover_status varchar2(1);
5917: l_carryover_exception exception;
5918: BEGIN
5919:
5920: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5921: itemkey => itemkey,
5922: aname => 'DOCUMENT_ID');
5923: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
5924: itemkey => itemkey,

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

5919:
5920: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5921: itemkey => itemkey,
5922: aname => 'DOCUMENT_ID');
5923: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
5924: itemkey => itemkey,
5925: aname => 'DOCUMENT_TYPE');
5926: x_progress := '001';
5927: if(l_document_type = 'RELEASE') then

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

5968: l_document_type po_document_types_all.document_type_code%TYPE;
5969: l_acc_flag varchar2(1);
5970: x_progress varchar2(3) := '000';
5971: BEGIN
5972: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5973: itemkey => itemkey,
5974: aname => 'DOCUMENT_ID');
5975: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
5976: itemkey => itemkey,

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

5971: BEGIN
5972: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
5973: itemkey => itemkey,
5974: aname => 'DOCUMENT_ID');
5975: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
5976: itemkey => itemkey,
5977: aname => 'DOCUMENT_TYPE');
5978:
5979: if(l_document_type = 'RELEASE') then

Line 6066: t_varname Wf_Engine.NameTabTyp;

6062: u1 pls_integer := 0;
6063: --Bug 6722239 - End
6064:
6065: x_progress varchar2(100) := '000';
6066: t_varname Wf_Engine.NameTabTyp;
6067: t_varval Wf_Engine.TextTabTyp;
6068: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
6069: l_po_header_id po_headers_all.po_header_id%TYPE;
6070: l_id number;

Line 6067: t_varval Wf_Engine.TextTabTyp;

6063: --Bug 6722239 - End
6064:
6065: x_progress varchar2(100) := '000';
6066: t_varname Wf_Engine.NameTabTyp;
6067: t_varval Wf_Engine.TextTabTyp;
6068: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
6069: l_po_header_id po_headers_all.po_header_id%TYPE;
6070: l_id number;
6071: l_header_cancel varchar2(1);

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

6116: WHERE pcr.change_request_group_id = l_chg_req_grp_id_csr
6117: AND fndu.user_id = pcr.responded_by;
6118:
6119: BEGIN
6120: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6121: itemkey => itemkey,
6122: aname => 'DOCUMENT_ID');
6123:
6124: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,

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

6120: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6121: itemkey => itemkey,
6122: aname => 'DOCUMENT_ID');
6123:
6124: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6125: itemkey => itemkey,
6126: aname => 'DOCUMENT_TYPE');
6127:
6128: if(l_document_type = 'RELEASE') then

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

6551: t_varval(5) := 'BUYER_RESP';
6552: t_varname(6) := 'PO_STYLE_TYPE';
6553: t_varval(6) := l_po_style;
6554:
6555: Wf_Engine.SetItemAttrTextArray(itemtype, itemkey,t_varname,t_varval);
6556:
6557: exception when others then
6558: wf_core.context('PO_ChangeOrderWF_PVT','is_po_approved_by_hie',x_progress);
6559: raise;

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

6571: l_seq number;
6572: l_item_key varchar2(2000);
6573: x_progress varchar2(3) := '000';
6574: BEGIN
6575: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6576: itemkey => itemkey,
6577: aname => 'DOCUMENT_ID');
6578: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6579: itemkey => itemkey,

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

6574: BEGIN
6575: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6576: itemkey => itemkey,
6577: aname => 'DOCUMENT_ID');
6578: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6579: itemkey => itemkey,
6580: aname => 'DOCUMENT_TYPE');
6581:
6582:

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

6589: l_item_key := 'SC_PO'||'-'||l_document_id||'-'||l_seq;
6590: end if;
6591:
6592:
6593: wf_engine.SetItemAttrText ( itemtype => itemtype,
6594: itemkey => itemkey,
6595: aname => 'SUP_CHANGE_EVENT_KEY',
6596: avalue => l_item_key );
6597:

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

6624: where action_type = 'MODIFICATION'
6625: and change_request_group_id = grp_id;
6626:
6627: BEGIN
6628: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6629: itemkey => itemkey,
6630: aname => 'PO_HEADER_ID');
6631: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6632: itemkey => itemkey,

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

6627: BEGIN
6628: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6629: itemkey => itemkey,
6630: aname => 'PO_HEADER_ID');
6631: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6632: itemkey => itemkey,
6633: aname => 'PO_RELEASE_ID');
6634:
6635: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

6631: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6632: itemkey => itemkey,
6633: aname => 'PO_RELEASE_ID');
6634:
6635: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6636: itemkey => itemkey,
6637: aname => 'CHANGE_REQUEST_GROUP_ID');
6638: l_acc_req_flag := wf_engine.GetItemAttrText( itemtype => itemtype,
6639: itemkey => itemkey,

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

6634:
6635: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6636: itemkey => itemkey,
6637: aname => 'CHANGE_REQUEST_GROUP_ID');
6638: l_acc_req_flag := wf_engine.GetItemAttrText( itemtype => itemtype,
6639: itemkey => itemkey,
6640: aname => 'ACKNOWLEDGE_REQ_FLAG');
6641:
6642:

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

6671: end if;
6672: x_progress := '001';
6673: if(l_chg_req_grp_id is null) then
6674: resultout := 'N';
6675: wf_engine.SetItemAttrText ( itemtype => itemtype,
6676: itemkey => itemkey,
6677: aname => 'EXPLAIN_FYI',
6678: avalue => '');
6679:

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

6677: aname => 'EXPLAIN_FYI',
6678: avalue => '');
6679:
6680: if(l_acc_req_flag = 'Y') then -- RDP no changes just Acknowledged ( Set the NOTIF_USAGE as BUYER_ACK)
6681: wf_engine.SetItemAttrText ( itemtype => itemtype,
6682: itemkey => itemkey,
6683: aname => 'NOTIF_USAGE',
6684: avalue => 'BUYER_ACK');
6685: end if;

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

6712: x_progress varchar2(100) := '000';
6713: l_change_request_group_id number := null;
6714: BEGIN
6715:
6716: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6717: itemkey => itemkey,
6718: aname => 'DOCUMENT_ID');
6719: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6720: itemkey => itemkey,

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

6715:
6716: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
6717: itemkey => itemkey,
6718: aname => 'DOCUMENT_ID');
6719: l_document_type := wf_engine.GetItemAttrText(itemtype => itemtype,
6720: itemkey => itemkey,
6721: aname => 'DOCUMENT_TYPE');
6722:
6723:

Line 6861: n_varname Wf_Engine.NameTabTyp;

6857: l_po_style varchar2(10);
6858: x_return_status varchar2(1);
6859: x_complex_flag varchar2(1);
6860:
6861: n_varname Wf_Engine.NameTabTyp;
6862: n_varval Wf_Engine.NumTabTyp;
6863: t_varname Wf_Engine.NameTabTyp;
6864: t_varval Wf_Engine.TextTabTyp;
6865:

Line 6862: n_varval Wf_Engine.NumTabTyp;

6858: x_return_status varchar2(1);
6859: x_complex_flag varchar2(1);
6860:
6861: n_varname Wf_Engine.NameTabTyp;
6862: n_varval Wf_Engine.NumTabTyp;
6863: t_varname Wf_Engine.NameTabTyp;
6864: t_varval Wf_Engine.TextTabTyp;
6865:
6866:

Line 6863: t_varname Wf_Engine.NameTabTyp;

6859: x_complex_flag varchar2(1);
6860:
6861: n_varname Wf_Engine.NameTabTyp;
6862: n_varval Wf_Engine.NumTabTyp;
6863: t_varname Wf_Engine.NameTabTyp;
6864: t_varval Wf_Engine.TextTabTyp;
6865:
6866:
6867: --l_id number;

Line 6864: t_varval Wf_Engine.TextTabTyp;

6860:
6861: n_varname Wf_Engine.NameTabTyp;
6862: n_varval Wf_Engine.NumTabTyp;
6863: t_varname Wf_Engine.NameTabTyp;
6864: t_varval Wf_Engine.TextTabTyp;
6865:
6866:
6867: --l_id number;
6868: --l_header_cancel varchar2(1);

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

6893: l_document_id := p_header_id;
6894: l_item_key := 'NSCR'||'-'||to_char(p_header_id)||'-'||to_char(p_revision_num)||'-'||to_char(l_seq);
6895: end if;
6896:
6897: wf_engine.createProcess ( ItemType => 'POSCHORD',
6898: ItemKey => l_item_key,
6899: Process => 'CHG_RESPONDED_FYI_TO_SUPPLIER');
6900:
6901: l_progress := '001';

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

7022: t_varname(7) := '#WFM_HTMLAGENT';
7023: t_varval(7) := fnd_profile.value('POS_EXTERNAL_URL');
7024:
7025:
7026: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7027: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
7028: l_progress := '003';
7029: wf_engine.StartProcess( ItemType => 'POSCHORD',
7030: ItemKey => l_item_key);

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

7023: t_varval(7) := fnd_profile.value('POS_EXTERNAL_URL');
7024:
7025:
7026: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7027: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
7028: l_progress := '003';
7029: wf_engine.StartProcess( ItemType => 'POSCHORD',
7030: ItemKey => l_item_key);
7031:

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

7025:
7026: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7027: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
7028: l_progress := '003';
7029: wf_engine.StartProcess( ItemType => 'POSCHORD',
7030: ItemKey => l_item_key);
7031:
7032: exception when others then
7033: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

7300: select distinct wf_item_key
7301: into l_item_key
7302: from po_change_requests
7303: where change_request_group_id = p_chg_req_grp_id;
7304: wf_engine.completeActivity('POSCHORD',l_item_key,'NOTIFY_BUYER_OF_CHN', 'Abort');
7305: exception when others then
7306: null;
7307: end;
7308: end if;

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

7477: and msi.planner_code = mtp.planner_code
7478: and msi.organization_id = mtp.organization_id;
7479:
7480: BEGIN
7481: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7482: itemkey => itemkey,
7483: aname => 'PO_HEADER_ID');
7484: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7485: itemkey => itemkey,

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

7480: BEGIN
7481: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7482: itemkey => itemkey,
7483: aname => 'PO_HEADER_ID');
7484: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7485: itemkey => itemkey,
7486: aname => 'PO_RELEASE_ID');
7487: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7488: itemkey => itemkey,

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

7483: aname => 'PO_HEADER_ID');
7484: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7485: itemkey => itemkey,
7486: aname => 'PO_RELEASE_ID');
7487: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7488: itemkey => itemkey,
7489: aname => 'PO_REVISION_NUM');
7490:
7491: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

7487: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7488: itemkey => itemkey,
7489: aname => 'PO_REVISION_NUM');
7490:
7491: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7492: itemkey => itemkey,
7493: aname => 'CHANGE_REQUEST_GROUP_ID');
7494: if(l_release_id is null) then
7495: select agent_id

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

7559: l_return_status varchar2(1);
7560: l_doc_check_rec_type POS_ERR_TYPE;
7561:
7562: BEGIN
7563: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7564: itemkey => itemkey,
7565: aname => 'PO_HEADER_ID');
7566: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7567: itemkey => itemkey,

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

7562: BEGIN
7563: l_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7564: itemkey => itemkey,
7565: aname => 'PO_HEADER_ID');
7566: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7567: itemkey => itemkey,
7568: aname => 'PO_RELEASE_ID');
7569: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7570: itemkey => itemkey,

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

7565: aname => 'PO_HEADER_ID');
7566: l_release_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7567: itemkey => itemkey,
7568: aname => 'PO_RELEASE_ID');
7569: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7570: itemkey => itemkey,
7571: aname => 'PO_REVISION_NUM');
7572: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7573: itemkey => itemkey,

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

7568: aname => 'PO_RELEASE_ID');
7569: l_revision_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7570: itemkey => itemkey,
7571: aname => 'PO_REVISION_NUM');
7572: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7573: itemkey => itemkey,
7574: aname => 'CHANGE_REQUEST_GROUP_ID');
7575:
7576: x_progress := '001';

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

7595: l_notif_usage VARCHAR2(30);
7596:
7597: BEGIN
7598:
7599: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7600: itemkey => itemkey,
7601: aname => 'CHANGE_REQUEST_GROUP_ID');
7602:
7603: l_notif_usage := wf_engine.GetItemAttrText(itemtype =>itemtype,

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

7599: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7600: itemkey => itemkey,
7601: aname => 'CHANGE_REQUEST_GROUP_ID');
7602:
7603: l_notif_usage := wf_engine.GetItemAttrText(itemtype =>itemtype,
7604: itemkey => itemKey,
7605: aname => 'NOTIF_USAGE');
7606:
7607: IF( l_notif_usage = 'BUYER_AUTO_FYI') THEN

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

7646: l_req_hdr_id number;
7647: l_po_header_id number;
7648: BEGIN
7649:
7650: l_chg_req_grp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
7651: itemkey => itemkey,
7652: aname => 'CHANGE_REQUEST_GROUP_ID');
7653:
7654:

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

7651: itemkey => itemkey,
7652: aname => 'CHANGE_REQUEST_GROUP_ID');
7653:
7654:
7655: l_notif_usage := wf_engine.GetItemAttrText(itemtype => itemtype,
7656: itemkey => itemkey,
7657: aname => 'NOTIF_USAGE');
7658:
7659: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

7655: l_notif_usage := wf_engine.GetItemAttrText(itemtype => itemtype,
7656: itemkey => itemkey,
7657: aname => 'NOTIF_USAGE');
7658:
7659: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7660: itemkey => itemkey,
7661: aname => 'PO_HEADER_ID');
7662:
7663: -- Withdraw the lock from requisition , if the changes have been rejected by the requester

Line 7719: n_varname Wf_Engine.NameTabTyp;

7715: l_buyer_agent_id number;
7716: l_buyer_username fnd_user.user_name%TYPE;
7717: l_supplier_username fnd_user.user_name%TYPE;
7718: l_buyer_disp_name varchar2(2000);
7719: n_varname Wf_Engine.NameTabTyp;
7720: n_varval Wf_Engine.NumTabTyp;
7721: t_varname Wf_Engine.NameTabTyp;
7722: t_varval Wf_Engine.TextTabTyp;
7723: x_ret_status varchar2(1);

Line 7720: n_varval Wf_Engine.NumTabTyp;

7716: l_buyer_username fnd_user.user_name%TYPE;
7717: l_supplier_username fnd_user.user_name%TYPE;
7718: l_buyer_disp_name varchar2(2000);
7719: n_varname Wf_Engine.NameTabTyp;
7720: n_varval Wf_Engine.NumTabTyp;
7721: t_varname Wf_Engine.NameTabTyp;
7722: t_varval Wf_Engine.TextTabTyp;
7723: x_ret_status varchar2(1);
7724: x_complex_flag varchar2(1);

Line 7721: t_varname Wf_Engine.NameTabTyp;

7717: l_supplier_username fnd_user.user_name%TYPE;
7718: l_buyer_disp_name varchar2(2000);
7719: n_varname Wf_Engine.NameTabTyp;
7720: n_varval Wf_Engine.NumTabTyp;
7721: t_varname Wf_Engine.NameTabTyp;
7722: t_varval Wf_Engine.TextTabTyp;
7723: x_ret_status varchar2(1);
7724: x_complex_flag varchar2(1);
7725:

Line 7722: t_varval Wf_Engine.TextTabTyp;

7718: l_buyer_disp_name varchar2(2000);
7719: n_varname Wf_Engine.NameTabTyp;
7720: n_varval Wf_Engine.NumTabTyp;
7721: t_varname Wf_Engine.NameTabTyp;
7722: t_varval Wf_Engine.TextTabTyp;
7723: x_ret_status varchar2(1);
7724: x_complex_flag varchar2(1);
7725:
7726:

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

7742:
7743:
7744:
7745:
7746: wf_engine.createProcess ( ItemType => 'POSCHORD',
7747: ItemKey => l_item_key,
7748: Process => 'MAIN_PROCESS');
7749:
7750: l_progress := '001';

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

7756: into l_supplier_username
7757: from fnd_user
7758: where user_id = fnd_global.user_id;
7759:
7760: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7761: itemkey => l_item_key,
7762: aname => 'RESP_ID',
7763: avalue => fnd_global.RESP_ID);
7764:

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

7761: itemkey => l_item_key,
7762: aname => 'RESP_ID',
7763: avalue => fnd_global.RESP_ID);
7764:
7765: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7766: itemkey => l_item_key,
7767: aname => 'APPL_RESP_ID',
7768: avalue => fnd_global.RESP_APPL_ID);
7769:

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

7855: t_varval(5) := p_acc_req_flag;
7856: t_varname(6) := 'PO_STYLE_TYPE';
7857: t_varval(6) := l_po_style;
7858:
7859: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7860: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
7861:
7862:
7863:

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

7856: t_varname(6) := 'PO_STYLE_TYPE';
7857: t_varval(6) := l_po_style;
7858:
7859: Wf_Engine.SetItemAttrNumberArray('POSCHORD', l_item_key,n_varname,n_varval);
7860: Wf_Engine.SetItemAttrTextArray('POSCHORD', l_item_key,t_varname,t_varval);
7861:
7862:
7863:
7864: /*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 7874: wf_engine.StartProcess( ItemType => 'POSCHORD',

7870: where change_request_group_id = p_chg_req_grp_id;
7871: end if;
7872: l_progress := '004';
7873:
7874: wf_engine.StartProcess( ItemType => 'POSCHORD',
7875: ItemKey => l_item_key);
7876:
7877: x_return_status := FND_API.G_RET_STS_SUCCESS;
7878: exception when others then