APPS.OE_APPROVALS_WF dependencies on WF_ENGINE

Line 57: l_aname wf_engine.nametabtyp;

53: --l_customer_number NUMBER;
54: l_customer_number varchar2(30) ;-- bug4575846
55: l_expiration_date DATE;
56:
57: l_aname wf_engine.nametabtyp;
58: l_avaluetext wf_engine.texttabtyp;
59:
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: BEGIN

Line 58: l_avaluetext wf_engine.texttabtyp;

54: l_customer_number varchar2(30) ;-- bug4575846
55: l_expiration_date DATE;
56:
57: l_aname wf_engine.nametabtyp;
58: l_avaluetext wf_engine.texttabtyp;
59:
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: BEGIN
62:

Line 86: l_sales_document_type_code := wf_engine.GetItemAttrText(

82: FROM OE_APPROVER_TRANSACTIONS
83: WHERE TRANSACTION_ID = l_transaction_id;
84:
85: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
86: l_sales_document_type_code := wf_engine.GetItemAttrText(
87: OE_GLOBALS.G_WFI_NGO,
88: l_transaction_id,
89: 'SALES_DOCUMENT_TYPE_CODE');
90: END IF;

Line 136: wf_engine.SetItemAttrText(itemtype,

132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add('Setting the role to->' || l_role, 1 ) ;
134: END IF;
135:
136: wf_engine.SetItemAttrText(itemtype,
137: itemkey,
138: 'NOTIFICATION_APPROVER',
139: l_role);
140:

Line 176: wf_engine.SetItemAttrText(itemtype,

172: app_exception.raise_exception;
173: END IF;
174:
175: IF l_attachment_location is NOT NULL THEN
176: wf_engine.SetItemAttrText(itemtype,
177: itemkey,
178: 'CONTRACT_ATTACHMENT',
179: l_attachment_location);
180: END IF;

Line 213: wf_engine.SetItemAttrTextArray( itemtype

209: l_avaluetext(2) := l_sold_to;
210: l_aname(3) := 'EXPIRATION_DATE';
211: l_avaluetext(3) := l_expiration_date;
212:
213: wf_engine.SetItemAttrTextArray( itemtype
214: , itemkey
215: , l_aname
216: , l_avaluetext
217: );

Line 331: l_aname wf_engine.nametabtyp;

327: --l_customer_number NUMBER;
328: l_customer_number varchar2(30); --bug4575846
329: l_expiration_date DATE;
330:
331: l_aname wf_engine.nametabtyp;
332: l_avaluetext wf_engine.texttabtyp;
333:
334: BEGIN
335:

Line 332: l_avaluetext wf_engine.texttabtyp;

328: l_customer_number varchar2(30); --bug4575846
329: l_expiration_date DATE;
330:
331: l_aname wf_engine.nametabtyp;
332: l_avaluetext wf_engine.texttabtyp;
333:
334: BEGIN
335:
336: --

Line 365: l_sales_document_type_code := wf_engine.GetItemAttrText(

361: WHERE TRANSACTION_ID = l_transaction_id);
362:
363:
364: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
365: l_sales_document_type_code := wf_engine.GetItemAttrText(
366: OE_GLOBALS.G_WFI_NGO,
367: l_transaction_id,
368: 'SALES_DOCUMENT_TYPE_CODE');
369: END IF;

Line 408: wf_engine.SetItemAttrText(itemtype,

404: OE_STANDARD_WF.Clear_Msg_Context;
405: return;
406:
407: else
408: wf_engine.SetItemAttrText(itemtype,
409: itemkey,
410: 'NOTIFICATION_APPROVER',
411: l_role);
412:

Line 449: wf_engine.SetItemAttrTextArray( itemtype

445: l_avaluetext(2) := l_sold_to;
446: l_aname(3) := 'EXPIRATION_DATE';
447: l_avaluetext(3) := l_expiration_date;
448:
449: wf_engine.SetItemAttrTextArray( itemtype
450: , itemkey
451: , l_aname
452: , l_avaluetext
453: );

Line 767: l_sales_document_type_code := wf_engine.GetItemAttrText(

763:
764: l_transaction_id := to_number(itemkey);
765:
766: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
767: l_sales_document_type_code := wf_engine.GetItemAttrText(
768: OE_GLOBALS.G_WFI_NGO,
769: l_transaction_id,
770: 'SALES_DOCUMENT_TYPE_CODE');
771: END IF;

Line 802: resultout := 'DEFERRED:'||to_char(sysdate+(TO_NUMBER(g_defer_min)/1440),wf_engine.date_format);

798: -- end data fix project
799: --app_exception.raise_exception;
800: --bug7386039
801:
802: resultout := 'DEFERRED:'||to_char(sysdate+(TO_NUMBER(g_defer_min)/1440),wf_engine.date_format);
803: return;
804:
805: END IF;
806:

Line 910: l_sales_document_type_code := wf_engine.GetItemAttrText(

906: IF nvl(OE_SYS_PARAMETERS.value('NO_RESPONSE_FROM_APPROVER'), 'CONTINUE') ='CONTINUE' THEN
907:
908: -- If the current approver is the last in the list, then still reject it.
909: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
910: l_sales_document_type_code := wf_engine.GetItemAttrText(
911: OE_GLOBALS.G_WFI_NGO,
912: l_transaction_id,
913: 'SALES_DOCUMENT_TYPE_CODE');
914: END IF;

Line 1077: resultout := 'DEFERRED:'||to_char(sysdate+(TO_NUMBER(g_defer_min)/1440),wf_engine.date_format);

1073: -- OE_STANDARD_WF.Clear_Msg_Context;
1074: -- end data fix project
1075: --app_exception.raise_exception;
1076: --bug7386039
1077: resultout := 'DEFERRED:'||to_char(sysdate+(TO_NUMBER(g_defer_min)/1440),wf_engine.date_format);
1078: return;
1079:
1080: END IF;
1081:

Line 1272: l_sales_document_type_code := wf_engine.GetItemAttrText(

1268: from WF_ITEM_ACTIVITY_STATUSES
1269: where NOTIFICATION_ID = to_number(document_id);
1270:
1271:
1272: l_sales_document_type_code := wf_engine.GetItemAttrText(
1273: OE_GLOBALS.G_WFI_NGO,
1274: to_char(l_transaction_id),
1275: 'SALES_DOCUMENT_TYPE_CODE');
1276: