DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on WF_NOTIFICATION

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

405: l_document := l_document || ConstructHeaderInfo(l_item_type,
406: l_item_key, l_change_request_group_id,
407: l_document_id, 'A');
408:
409: WF_NOTIFICATION.WriteToClob(document,l_document);
410: end if;
411:
412: l_document_3 := NULL;
413:

Line 416: WF_NOTIFICATION.WriteToClob(document,l_document_3);

412: l_document_3 := NULL;
413:
414: GetReqLinesDetailsLink(document_id, display_type, l_document_3, document_type);
415:
416: WF_NOTIFICATION.WriteToClob(document,l_document_3);
417: l_document_2 := NULL;
418:
419: GetActionHistoryHtml(document_id, display_type, l_document_2, document_type);
420:

Line 421: WF_NOTIFICATION.WriteToClob(document,l_document_2||NL);

417: l_document_2 := NULL;
418:
419: GetActionHistoryHtml(document_id, display_type, l_document_2, document_type);
420:
421: WF_NOTIFICATION.WriteToClob(document,l_document_2||NL);
422: -- l_document := l_document || l_document_3 || l_document_2 || NL ;
423:
424: else -- Text message
425: null;

Line 480: -- WF_NOTIFICATION.WriteToClob(document,'
aaa
');

476: where change_request_group_id=l_change_request_group_id;
477:
478:
479: BEGIN
480: -- WF_NOTIFICATION.WriteToClob(document,'
aaa
');
481: l_change_request_group_id :=to_number(document_id);
482: open l_get_wf_keys_csr;
483: fetch l_get_wf_keys_csr into l_item_type, l_item_key;
484: close l_get_wf_keys_csr;

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

548: if(wf_core.translate('WF_HEADER_ATTR') <> 'Y') then
549: l_document := l_document || ConstructHeaderInfo(l_item_type,
550: l_item_key, l_change_request_group_id,
551: l_document_id, 'R');
552: WF_NOTIFICATION.WriteToClob(document,l_document);
553: end if;
554:
555: l_document_3 := NULL;
556:

Line 558: WF_NOTIFICATION.WriteToClob(document,l_document_3);

554:
555: l_document_3 := NULL;
556:
557: GetReqLinesResponse(document_id, display_type, l_document_3, document_type);
558: WF_NOTIFICATION.WriteToClob(document,l_document_3);
559:
560: l_document_2 := NULL;
561:
562: GetActionHistoryHtml(l_item_type||':'||l_item_key, display_type, l_document_2, document_type);

Line 564: WF_NOTIFICATION.WriteToClob(document,l_document_2||NL);

560: l_document_2 := NULL;
561:
562: GetActionHistoryHtml(l_item_type||':'||l_item_key, display_type, l_document_2, document_type);
563:
564: WF_NOTIFICATION.WriteToClob(document,l_document_2||NL);
565: -- l_document := l_document || l_document_3 || l_document_2 || NL ;
566:
567: else -- Text message
568: null;

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

3482: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||': ' || l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| l_ship_city||' '||l_ship_state||' '||l_ship_zip || NL || NL;
3483:
3484: end if;
3485:
3486: WF_NOTIFICATION.WriteToClob(document,l_document);
3487:
3488: begin
3489: select count(1)
3490: into l_num_temp_labors

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

3631: l_document := fnd_message.get_string('PO','PO_WF_NOTIF_REQUEST_DETAILS') || NL || NL;
3632: end if;
3633:
3634: --document:=document||l_document;
3635: WF_NOTIFICATION.WriteToClob(document,l_document);
3636: open po_chg_req(l_grp_id);
3637: loop
3638: fetch po_chg_req
3639: into

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

3799: l_new_amount,
3800: l_has_temp_labor,
3801: display_type,
3802: l_document);
3803: WF_NOTIFICATION.WriteToClob(document,l_document);
3804: END LOOP;
3805: CLOSE PO_CHG_REQ;
3806:
3807: if (display_type = 'text/html' ) then

Line 3808: WF_NOTIFICATION.WriteToClob(document, '

');

3804: END LOOP;
3805: CLOSE PO_CHG_REQ;
3806:
3807: if (display_type = 'text/html' ) then
3808: WF_NOTIFICATION.WriteToClob(document, '

');
3809: end if;
3810:
3811: end if;
3812: END Get_Po_Chg_Approval_Notif;

Line 4001: -- Since WF notification can't set the org context, we need to set it here.

3997: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress);
3998: END IF;
3999: end if;
4000:
4001: -- Since WF notification can't set the org context, we need to set it here.
4002: PO_MOAC_UTILS_PVT.set_policy_context('S', p_org_id);
4003:
4004: open l_get_line_qty(p_group_id, p_line_id);
4005: fetch l_get_line_qty into l_line_total_qty;