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.OKL_CS_WF dependencies on OKL_EQUIPMENT_EXCHANGE_PUB

Line 137: okl_equipment_exchange_pub.exchange(

133: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,
134: itemkey => itemkey,
135: aname => 'TAS_ID');
136:
137: okl_equipment_exchange_pub.exchange(
138: p_api_version =>l_api_version,
139: p_init_msg_list =>fnd_api.g_false,
140: p_tas_id =>l_tas_id,
141: x_return_status =>l_return_status,

Line 248: x_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;

244: AS
245: l_restruct_role VARCHAR2(100);
246: l_contract_number VARCHAR2(120);
247: l_request_number NUMBER;
248: x_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;
249: l_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;
250:
251: l_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
252: x_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;

Line 249: l_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;

245: l_restruct_role VARCHAR2(100);
246: l_contract_number VARCHAR2(120);
247: l_request_number NUMBER;
248: x_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;
249: l_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;
250:
251: l_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
252: x_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
253:

Line 251: l_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;

247: l_request_number NUMBER;
248: x_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;
249: l_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;
250:
251: l_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
252: x_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
253:
254: l_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
255: x_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;

Line 252: x_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;

248: x_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;
249: l_thpv_tbl okl_equipment_exchange_pub.thpv_tbl_type;
250:
251: l_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
252: x_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
253:
254: l_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
255: x_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
256: l_no_data_found BOOLEAN;

Line 254: l_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;

250:
251: l_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
252: x_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
253:
254: l_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
255: x_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
256: l_no_data_found BOOLEAN;
257:
258: l_old_vendor VARCHAR2(240);

Line 255: x_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;

251: l_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
252: x_new_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
253:
254: l_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
255: x_old_talv_tbl okl_equipment_exchange_pub.talv_tbl_type;
256: l_no_data_found BOOLEAN;
257:
258: l_old_vendor VARCHAR2(240);
259: l_new_vendor VARCHAR2(240);

Line 269: x_thpv_tbl :=okl_equipment_exchange_pub.get_Tas_hdr_rec(l_thpv_tbl,l_no_data_found);

265: WHERE id=c_contract_id;
266: BEGIN
267:
268: l_thpv_tbl(1).id:= p_tas_id;
269: x_thpv_tbl :=okl_equipment_exchange_pub.get_Tas_hdr_rec(l_thpv_tbl,l_no_data_found);
270:
271: l_old_talv_tbl(1).tas_id := p_tas_id;
272: l_old_talv_tbl(1).tal_type := 'OAS';
273: x_old_talv_tbl :=okl_equipment_exchange_pub.get_tal_rec(l_old_talv_tbl,l_no_data_found);

Line 273: x_old_talv_tbl :=okl_equipment_exchange_pub.get_tal_rec(l_old_talv_tbl,l_no_data_found);

269: x_thpv_tbl :=okl_equipment_exchange_pub.get_Tas_hdr_rec(l_thpv_tbl,l_no_data_found);
270:
271: l_old_talv_tbl(1).tas_id := p_tas_id;
272: l_old_talv_tbl(1).tal_type := 'OAS';
273: x_old_talv_tbl :=okl_equipment_exchange_pub.get_tal_rec(l_old_talv_tbl,l_no_data_found);
274: l_new_talv_tbl(1).tas_id := p_tas_id;
275: l_new_talv_tbl(1).tal_type := 'NAS';
276: x_new_talv_tbl :=okl_equipment_exchange_pub.get_tal_rec(l_new_talv_tbl,l_no_data_found);
277:

Line 276: x_new_talv_tbl :=okl_equipment_exchange_pub.get_tal_rec(l_new_talv_tbl,l_no_data_found);

272: l_old_talv_tbl(1).tal_type := 'OAS';
273: x_old_talv_tbl :=okl_equipment_exchange_pub.get_tal_rec(l_old_talv_tbl,l_no_data_found);
274: l_new_talv_tbl(1).tas_id := p_tas_id;
275: l_new_talv_tbl(1).tal_type := 'NAS';
276: x_new_talv_tbl :=okl_equipment_exchange_pub.get_tal_rec(l_new_talv_tbl,l_no_data_found);
277:
278: OPEN okl_contract_number(x_new_talv_tbl(1).dnz_khr_id);
279: FETCH okl_contract_number INTO l_contract_number;
280: CLOSE okl_contract_number;

Line 339: l_old_vendor := okl_equipment_exchange_pub.get_vendor_name(x_old_talv_tbl(1).SUPPLIER_ID);

335: itemkey => itemkey,
336: aname => 'OLD_MANUFACTURER',
337: avalue => x_old_talv_tbl(1).MANUFACTURER_NAME);
338: IF x_old_talv_tbl(1).SUPPLIER_ID IS NOT NULL THEN
339: l_old_vendor := okl_equipment_exchange_pub.get_vendor_name(x_old_talv_tbl(1).SUPPLIER_ID);
340: wf_engine.SetItemAttrText ( itemtype=> itemtype,
341: itemkey => itemkey,
342: aname => 'OLD_VENDOR',
343: avalue => l_old_vendor);

Line 376: l_new_vendor := okl_equipment_exchange_pub.get_vendor_name(x_new_talv_tbl(1).SUPPLIER_ID);

372: itemkey => itemkey,
373: aname => 'NEW_MANUFACTURER',
374: avalue => x_new_talv_tbl(1).MANUFACTURER_NAME);
375: IF x_new_talv_tbl(1).SUPPLIER_ID IS NOT NULL THEN
376: l_new_vendor := okl_equipment_exchange_pub.get_vendor_name(x_new_talv_tbl(1).SUPPLIER_ID);
377: wf_engine.SetItemAttrText ( itemtype=> itemtype,
378: itemkey => itemkey,
379: aname => 'NEW_VENDOR',
380: avalue => l_new_vendor);

Line 397: l_exchange_type := okl_equipment_exchange_pub.get_exchange_type(l_tas_id);

393: if (funcmode = 'RUN') then
394: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,
395: itemkey => itemkey,
396: aname => 'TAS_ID');
397: l_exchange_type := okl_equipment_exchange_pub.get_exchange_type(l_tas_id);
398:
399: populate_notification_attribs(itemtype,itemkey,l_tas_id);
400:
401: if l_exchange_type IN ('LLT','LLP') THEN

Line 446: l_exchange_type := okl_equipment_exchange_pub.get_exchange_type(l_tas_id);

442: if (funcmode = 'RUN') then
443: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'TAS_ID');
446: l_exchange_type := okl_equipment_exchange_pub.get_exchange_type(l_tas_id);
447: IF l_exchange_type = 'LLT' THEN
448: resultout := 'COMPLETE:Y';
449: ELSE
450: resultout := 'COMPLETE:N';