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.AP_WEB_EXPENSE_WF dependencies on WF_NOTIFICATION

Line 8: -- copied from WF_NOTIFICATION package

4:
5: --
6: -- Private Variables
7: --
8: -- copied from WF_NOTIFICATION package
9: -- /fnddev/fnd/11.5/patch/115/sql/wfntfb.pls
10: --
11:
12: table_width varchar2(6) := '"100%"';

Line 972: WF_NOTIFICATION.WriteToClob(document, l_table_header);

968: end if;
969:
970: l_table_header := l_table_header || tr_end;
971:
972: WF_NOTIFICATION.WriteToClob(document, l_table_header);
973:
974: EXCEPTION
975: WHEN OTHERS THEN
976: IF (SQLCODE <> -20001) THEN

Line 1114: WF_NOTIFICATION.WriteToClob(document, l_table_row);

1110: end if;
1111:
1112: l_table_row := l_table_row || tr_end;
1113:
1114: WF_NOTIFICATION.WriteToClob(document, l_table_row);
1115: end if;
1116:
1117: END LOOP; /* ExpenseReportLinesCursor */
1118:

Line 1127: WF_NOTIFICATION.WriteToClob(document, l_table_row);

1123: end if;
1124:
1125: l_table_row := table_end || indent_end;
1126:
1127: WF_NOTIFICATION.WriteToClob(document, l_table_row);
1128:
1129: EXCEPTION
1130: WHEN OTHERS THEN
1131: IF (SQLCODE <> -20001) THEN

Line 9006: WF_NOTIFICATION.NewClob(l_temp_clob,document);

9002: BEGIN
9003:
9004: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateExpLines');
9005:
9006: WF_NOTIFICATION.NewClob(l_temp_clob,document);
9007: GenerateExpClobLines(document_id,
9008: display_type,
9009: l_temp_clob,
9010: document_type);

Line 9150: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

9146: p_adjustment_line := p_adjustment_line || td_number || to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || td_end;
9147: -- 'Credit Card Expense'
9148: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.credit_card_expense_disp, '&' || 'nbsp;') || td_end;
9149: -- 'Justification'
9150: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9151: -- 'Instructions'
9152: p_adjustment_line := p_adjustment_line || td_text;
9153: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9154: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

Line 9154: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

9150: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9151: -- 'Instructions'
9152: p_adjustment_line := p_adjustment_line || td_text;
9153: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9154: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';
9155: else
9156: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9157: end if;
9158: if (adjustment_rec.adjustment_reason_description is not null) then

Line 9159: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';

9155: else
9156: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9157: end if;
9158: if (adjustment_rec.adjustment_reason_description is not null) then
9159: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';
9160: else
9161: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9162: end if;
9163: if (adjustment_rec.adjustment_reason is not null) then

Line 9164: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9160: else
9161: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9162: end if;
9163: if (adjustment_rec.adjustment_reason is not null) then
9164: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9165: else
9166: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9167: end if;
9168: p_adjustment_line := p_adjustment_line || td_end;

Line 9173: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || adjustment_rec.amount || ' ' || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9169: p_adjustment_line := p_adjustment_line || tr_end;
9170: END IF;
9171: ELSIF p_adjustment_type = 'AUDIT' THEN
9172: IF (p_display_type = 'text/plain') THEN
9173: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || adjustment_rec.amount || ' ' || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9174: p_adjustment_line := p_adjustment_line || '
9175: ' || l_adjustment_line;
9176: ELSE -- HTML type
9177: p_adjustment_line := p_adjustment_line || tr_start;

Line 9186: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

9182: -- 'Amount'
9183: p_adjustment_line := p_adjustment_line || td_number ||
9184: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9185: -- 'Justification'
9186: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9187: -- 'Instructions'
9188: p_adjustment_line := p_adjustment_line || td_text;
9189: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9190: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

Line 9190: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

9186: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9187: -- 'Instructions'
9188: p_adjustment_line := p_adjustment_line || td_text;
9189: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9190: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';
9191: else
9192: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9193: end if;
9194: if (adjustment_rec.adjustment_reason_description is not null) then

Line 9195: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';

9191: else
9192: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9193: end if;
9194: if (adjustment_rec.adjustment_reason_description is not null) then
9195: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';
9196: else
9197: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9198: end if;
9199: if (adjustment_rec.adjustment_reason is not null) then

Line 9200: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9196: else
9197: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9198: end if;
9199: if (adjustment_rec.adjustment_reason is not null) then
9200: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9201: else
9202: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9203: end if;
9204: p_adjustment_line := p_adjustment_line || td_end;

Line 9209: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || adjustment_rec.amount || ' ' || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9205: p_adjustment_line := p_adjustment_line || tr_end;
9206: END IF;
9207: ELSE
9208: IF (p_display_type = 'text/plain') THEN
9209: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || adjustment_rec.amount || ' ' || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9210: p_adjustment_line := p_adjustment_line || '
9211: ' || l_adjustment_line;
9212: ELSE -- HTML type
9213: p_adjustment_line := p_adjustment_line || tr_start;

Line 9224: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

9220: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9221: -- 'Itemized Expense'
9222: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.itemized_expense_disp, '&' || 'nbsp;') || td_end;
9223: -- 'Justification'
9224: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9225: -- 'Instructions'
9226: p_adjustment_line := p_adjustment_line || td_text;
9227: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9228: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

Line 9228: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

9224: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9225: -- 'Instructions'
9226: p_adjustment_line := p_adjustment_line || td_text;
9227: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9228: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';
9229: else
9230: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9231: end if;
9232: if (adjustment_rec.adjustment_reason_description is not null) then

Line 9233: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';

9229: else
9230: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9231: end if;
9232: if (adjustment_rec.adjustment_reason_description is not null) then
9233: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';
9234: else
9235: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9236: end if;
9237: if (adjustment_rec.adjustment_reason is not null) then

Line 9238: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9234: else
9235: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9236: end if;
9237: if (adjustment_rec.adjustment_reason is not null) then
9238: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9239: else
9240: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9241: end if;
9242: p_adjustment_line := p_adjustment_line || td_end;

Line 9267: WF_NOTIFICATION.NewClob(l_temp_clob,document);

9263: l_message VARCHAR2(2000);
9264: l_temp_clob CLOB;
9265: l_colon NUMBER;--namrata
9266: BEGIN
9267: WF_NOTIFICATION.NewClob(l_temp_clob,document);
9268:
9269: GenerateAdjustmentInfoClob(document_id,
9270: display_type,
9271: l_temp_clob,

Line 9518: WF_NOTIFICATION.WriteToClob(document,l_document);

9514: l_currency,
9515: l_document);--namrata
9516:
9517: IF lengthb(l_document)>=l_document_max THEN
9518: WF_NOTIFICATION.WriteToClob(document,l_document);
9519: l_document:='';--namrata
9520: END IF;
9521:
9522:

Line 9562: WF_NOTIFICATION.WriteToClob(document,l_document);

9558: */
9559: END IF;
9560:
9561: IF l_document is not null THEN
9562: WF_NOTIFICATION.WriteToClob(document,l_document);
9563: END IF;
9564:
9565: document_type := display_type;
9566:

Line 10222: l_TransferNotificationID := WF_NOTIFICATION.SEND(

10218:
10219: -----------------------------------------
10220: l_debug_info := 'send notification Notify Preparer About Approval Request Transfer';
10221: -----------------------------------------
10222: l_TransferNotificationID := WF_NOTIFICATION.SEND(
10223: role => l_preparer_name,
10224: msg_type => 'APEXP',
10225: msg_name => 'OIE_PREPARER_TRANSFER',
10226: due_date => null,

Line 10236: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10232: if (l_TransferNotificationID is not null) then
10233: -----------------------------------------
10234: l_debug_info := 'set the notification attributes';
10235: -----------------------------------------
10236: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10237: 'DOCUMENT_NUMBER',
10238: WF_ENGINE.GetItemAttrText(p_item_type,
10239: p_item_key,
10240: 'DOCUMENT_NUMBER'));

Line 10242: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10238: WF_ENGINE.GetItemAttrText(p_item_type,
10239: p_item_key,
10240: 'DOCUMENT_NUMBER'));
10241:
10242: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10243: '#HDR_DISPLAY_TOTAL',
10244: WF_ENGINE.GetItemAttrText(p_item_type,
10245: p_item_key,
10246: 'DISPLAY_TOTAL'));

Line 10247: wf_notification.denormalize_notification(l_TransferNotificationID);

10243: '#HDR_DISPLAY_TOTAL',
10244: WF_ENGINE.GetItemAttrText(p_item_type,
10245: p_item_key,
10246: 'DISPLAY_TOTAL'));
10247: wf_notification.denormalize_notification(l_TransferNotificationID);
10248: end if;
10249:
10250: end if;
10251:

Line 10292: l_WFAdminNote := WF_NOTIFICATION.GetAttrText(l_notificationID,

10288:
10289: -----------------------------------------
10290: l_debug_info := 'Get WF Admin Note';
10291: -----------------------------------------
10292: l_WFAdminNote := WF_NOTIFICATION.GetAttrText(l_notificationID,
10293: 'WF_ADMIN_NOTE');
10294:
10295: /* Bug 2798344: The following code does got fire to raise a sql
10296: exception. However, it appears to be a bug than a desired feature.

Line 10895: l_payable_admin wf_notifications.recipient_role%TYPE;

10891: l_doc_cctr VARCHAR2(2000);
10892: l_preparer_name VARCHAR2(2000);
10893: l_employee_name VARCHAR2(2000);
10894: l_purpose VARCHAR2(2400);
10895: l_payable_admin wf_notifications.recipient_role%TYPE;
10896: l_currency VARCHAR2(50);
10897: l_total VARCHAR2(200);
10898: l_payment_due VARCHAR2(100);
10899: l_debug_info VARCHAR2(200);

Line 11470: WF_NOTIFICATION.WriteToClob(document,fnd_message.get);

11466: IF (l_payment = 'BOTH' and l_num_both_personal_lines > 0) THEN
11467: NULL;
11468: ELSE
11469: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_REPORT_SHORTPAID');
11470: WF_NOTIFICATION.WriteToClob(document,fnd_message.get);
11471: document_type := display_type;
11472: return;
11473: END IF;
11474: --Bug 2944363 End here.

Line 11579: WF_NOTIFICATION.WriteToClob(document,l_document);

11575: loop
11576:
11577: IF lengthb(l_document) >= l_document_max THEN
11578: -- Appends l_document to end of document (CLOB object)
11579: WF_NOTIFICATION.WriteToClob(document,l_document);
11580: l_document := '';
11581: --l_show_message := 'Y';
11582: --exit;
11583: END IF;

Line 11707: WF_NOTIFICATION.WriteToClob(document,l_document);

11703: EXIT WHEN XpenseLinesCursor%NOTFOUND;
11704:
11705: IF lengthb(l_document) >= l_document_max THEN
11706: -- Appends l_document to end of document (CLOB object)
11707: WF_NOTIFICATION.WriteToClob(document,l_document);
11708: l_document := '';
11709: --l_show_message := 'Y';
11710: --exit;
11711: END IF;

Line 11797: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;

11793: -- display Expense Type
11794: l_document := l_document || td_text || l_expense_type || td_end;
11795: -- display Merchant Name
11796: if ((l_is_cc_table) or (NOT l_is_cc_table and l_co_merchant_count > 0)) then
11797: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;
11798: end if;
11799:
11800: if (l_employee_project_enabled = 'Y') then
11801: -- display Project/Task only when Projects enabled

Line 11813: l_document := l_document || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(l_justification), '&' || 'nbsp;') || td_end;

11809: -- display Amount
11810: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
11811:
11812: -- display Justification
11813: l_document := l_document || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(l_justification), '&' || 'nbsp;') || td_end;
11814:
11815: if (l_line_accounting_enabled = 'Y') then
11816: l_document := l_document || td_text || nvl(l_flex_concatenated, '&' || 'nbsp;') || td_end;
11817: end if;

Line 11825: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;

11821: l_document := l_document || td_text || '&' || 'nbsp;' || td_end;
11822:
11823: -- display Merchant Name
11824: if ((l_is_cc_table) or (NOT l_is_cc_table and l_co_merchant_count > 0)) then
11825: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;
11826: end if;
11827:
11828: if (l_employee_project_enabled = 'Y') then
11829: -- display Project/Task only when Projects enabled

Line 12020: WF_NOTIFICATION.WriteToClob(document,l_document);

12016: EXIT WHEN PersonalLinesCursor%NOTFOUND;
12017:
12018: IF lengthb(l_document) >= l_document_max THEN
12019: -- Appends l_document to end of document (CLOB object)
12020: WF_NOTIFICATION.WriteToClob(document,l_document);
12021: l_document := '';
12022: --l_show_message := 'Y';
12023: --exit;
12024: END IF;

Line 12038: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;

12034: l_document := l_document || td_text || l_start_date || td_end;
12035:
12036: -- display Merchant
12037: --Bug 2942773: Add Merchant name value to personal expense table.
12038: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;
12039: -- display Amount
12040: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
12041: l_document := l_document || tr_end;
12042:

Line 12127: WF_NOTIFICATION.WriteToClob(document,l_document);

12123: l_cc_merchant_name;
12124: EXIT WHEN BothPayPersonalLinesCursor%NOTFOUND;
12125: IF lengthb(l_document) >= l_document_max THEN
12126: -- Appends l_document to end of document (CLOB object)
12127: WF_NOTIFICATION.WriteToClob(document,l_document);
12128: l_document := '';
12129: --l_show_message := 'Y';
12130: --exit;
12131: END IF;

Line 12138: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_cc_merchant_name) || td_end;

12134: l_document := l_document || tr_start;
12135: -- display Date
12136: l_document := l_document || td_text || l_cc_trxn_date || td_end;
12137: -- display Merchant
12138: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_cc_merchant_name) || td_end;
12139: -- display Amount
12140: l_document := l_document || td_number || LPAD(to_char(l_cc_expensed_amt, FND_CURRENCY.Get_Format_Mask(l_cc_curr_code,22)),14) || td_end;
12141: l_document := l_document || tr_end;
12142:

Line 12189: WF_NOTIFICATION.WriteToClob(document,l_document);

12185: /* Bug 3561386 : Should add l_document to the clob only if it is
12186: * not null.
12187: */
12188: IF l_document is not null then
12189: WF_NOTIFICATION.WriteToClob(document,l_document);
12190: END IF;
12191:
12192: document_type := display_type;
12193:

Line 14421: FROM wf_notifications

14417: IF ( l_ame_enabled <> 'Y' ) THEN
14418:
14419: BEGIN
14420: SELECT recipient_role INTO l_user_name
14421: FROM wf_notifications
14422: WHERE message_type = 'APEXP'
14423: AND message_name = 'OIE_REQ_EXPENSE_REPORT_APPRVL'
14424: AND ( item_key = p_item_key
14425: OR p_item_key = SubStr(context,7,length(p_item_key)) )

Line 15066: l_user_name wf_notifications.recipient_role%type;

15062:
15063: l_item_type wf_items.item_type%type;
15064: l_item_key wf_items.item_key%type;
15065: l_access_granted varchar2(1) := 'N';
15066: l_user_name wf_notifications.recipient_role%type;
15067:
15068: BEGIN
15069:
15070: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start CheckAccess');

Line 15075: from wf_notifications

15071:
15072: -- get the item type for the notif
15073: select message_type
15074: into l_item_type
15075: from wf_notifications
15076: where notification_id = p_ntf_id
15077: and rownum = 1;
15078:
15079: -- check the following:

Line 15162: from wf_notifications wfn ,

15158: /*
15159: -- 2. User has access to the NtfId
15160: select 'Y'
15161: into l_access_granted
15162: from wf_notifications wfn ,
15163: WF_USER_ROLES wur
15164: where wur.user_name = p_user_name
15165: and wfn.notification_id = p_ntf_id
15166: and ( wfn.recipient_role = wur.role_name

Line 16143: l_context wf_notifications.context%type;

16139: RETURN l_ExpAccountsUpdated;
16140: END IsExpAccountsUpdated;
16141:
16142: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
16143: l_context wf_notifications.context%type;
16144: l_temp_context wf_notifications.context%type;
16145: l_item_key wf_notifications.context%type;
16146: l_debug_info varchar2(200);
16147: BEGIN

Line 16144: l_temp_context wf_notifications.context%type;

16140: END IsExpAccountsUpdated;
16141:
16142: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
16143: l_context wf_notifications.context%type;
16144: l_temp_context wf_notifications.context%type;
16145: l_item_key wf_notifications.context%type;
16146: l_debug_info varchar2(200);
16147: BEGIN
16148: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');

Line 16145: l_item_key wf_notifications.context%type;

16141:
16142: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
16143: l_context wf_notifications.context%type;
16144: l_temp_context wf_notifications.context%type;
16145: l_item_key wf_notifications.context%type;
16146: l_debug_info varchar2(200);
16147: BEGIN
16148: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');
16149:

Line 16151: from wf_notifications

16147: BEGIN
16148: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');
16149:
16150: select context into l_context
16151: from wf_notifications
16152: where notification_id = p_notification_id;
16153:
16154: --l_context would have something like 'APEXP:22591-2:579934'
16155: