APPS.IGIDOSL dependencies on WF_NOTIFICATION

Line 16: ## copied FROM WF_NOTIFICATION package

12: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
13:
14: /* ============== WORKFLOW VARAIBLES =================
15: ## Variables for framing and coloring the Table.
16: ## copied FROM WF_NOTIFICATION package
17: ## /fnddev/fnd/11.5/patch/115/sql/wfntfb.pls
18: ##
19: */
20:

Line 558: l_picked_role wf_notifications.responder%TYPE;

554: funcmode VARCHAR2,
555: result OUT NOCOPY VARCHAR2)
556: IS
557:
558: l_picked_role wf_notifications.responder%TYPE;
559:
560: BEGIN
561:
562: /* =============== START DEBUG LOG ================ */

Line 636: l_creator_name wf_notifications.responder%TYPE

632: funcmode VARCHAR2,
633: result OUT NOCOPY VARCHAR2)
634: IS
635:
636: l_creator_name wf_notifications.responder%TYPE
637: := Wf_Engine.GetItemAttrText (itemtype => itemtype,
638: itemkey => itemkey,
639: aname => 'CREATOR_NAME');
640:

Line 656: l_picked_role wf_notifications.responder%TYPE;

652: :=Wf_Engine.GetItemAttrNumber (itemtype => ItemType,
653: itemkey => ItemKey,
654: aname => 'DOSSIER_ID');
655:
656: l_picked_role wf_notifications.responder%TYPE;
657: l_error VARCHAR2(1000) ;
658: l_position_structure_id per_position_structures.position_structure_id%TYPE ;
659: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;
660: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;

Line 1426: l_creator_name wf_notifications.responder%TYPE

1422: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1423: itemkey => itemkey,
1424: aname => 'DOSSIER_NUM');
1425:
1426: l_creator_name wf_notifications.responder%TYPE
1427: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1428: itemkey => itemkey,
1429: aname => 'CREATOR_NAME');
1430: BEGIN

Line 1498: l_creator_name wf_notifications.responder%TYPE

1494: funcmode IN VARCHAR2,
1495: result OUT NOCOPY VARCHAR2)
1496: IS
1497:
1498: l_creator_name wf_notifications.responder%TYPE
1499: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1500: itemkey => itemkey,
1501: aname => 'CREATOR_NAME');
1502:

Line 1529: l_nid := Wf_Notification.Send(

1525: result := 'COMPLETE' ;
1526: return;
1527: END IF ;
1528:
1529: l_nid := Wf_Notification.Send(
1530: l_creator_name
1531: , itemtype
1532: ,'ALL_APPROVED'
1533: , null

Line 1596: l_creator_name wf_notifications.responder%TYPE

1592: funcmode IN VARCHAR2,
1593: result OUT NOCOPY VARCHAR2)
1594: IS
1595:
1596: l_creator_name wf_notifications.responder%TYPE
1597: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1598: itemkey => itemkey,
1599: aname => 'CREATOR_NAME');
1600:

Line 1628: l_nid := Wf_Notification.Send(

1624: result := 'COMPLETE' ;
1625: return;
1626: END IF ;
1627:
1628: l_nid := Wf_Notification.Send(
1629: l_creator_name
1630: , itemtype
1631: ,'AUTHORISER_REJECTION'
1632: , null

Line 1889: l_next_authoriser wf_notifications.responder%TYPE ;

1885: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1886: itemkey => itemkey,
1887: aname => 'PARENT_POSITION_ID');
1888:
1889: l_next_authoriser wf_notifications.responder%TYPE ;
1890: l_pos NUMBER := 0;
1891:
1892: no_next_authoriser EXCEPTION ;
1893:

Line 2220: WF_NOTIFICATION.WriteToClob(Document,l_table_header);

2216: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg4',
2217: ' l_table_header --> ' || substr(l_table_header,1,3800));
2218: /* =============== END DEBUG LOG ================== */
2219:
2220: WF_NOTIFICATION.WriteToClob(Document,l_table_header);
2221:
2222: /* =============== START DEBUG LOG ================ */
2223: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg5',
2224: ' ** END FRAMEDOSTABLE ** ');

Line 2267: WF_NOTIFICATION.WriteToClob(Document,l_frame_total);

2263: DEBUG_LOG_STRING (l_proc_level, 'AddTotalToTable.Msg3',
2264: ' l_frame_total --> ' || substr(l_frame_total,1,3900));
2265: /* =============== END DEBUG LOG ================== */
2266:
2267: WF_NOTIFICATION.WriteToClob(Document,l_frame_total);
2268:
2269: /* =============== START DEBUG LOG ================ */
2270: DEBUG_LOG_STRING (l_proc_level, 'AddTotalToTable.Msg4',
2271: ' ** END ADDTOTALTOTABLE ** ');

Line 2536: WF_NOTIFICATION.WriteToClob(Document,l_trx_detail);

2532: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg22',
2533: ' dest_rec.amount --> ' || l_dest_formatted_amount);
2534: /* =============== END DEBUG LOG ================== */
2535:
2536: WF_NOTIFICATION.WriteToClob(Document,l_trx_detail);
2537:
2538: /* =============== START DEBUG LOG ================ */
2539: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg23',
2540: ' l_trx_detail updated to clob ');

Line 2577: WF_NOTIFICATION.WriteToClob(Document,l_trx_detail);

2573: ' Out of loop ' ) ;
2574: /* =============== END DEBUG LOG ================== */
2575:
2576: l_trx_detail := '
';
2577: WF_NOTIFICATION.WriteToClob(Document,l_trx_detail);
2578:
2579:
2580: /* =============== START DEBUG LOG ================ */
2581: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg26',