APPS.IGI_EXP_APPROVAL_PKG dependencies on WF_NOTIFICATION

Line 9: ## copied FROM WF_NOTIFICATION package

5:
6:
7: /* ============== WORKFLOW VARAIBLES =================
8: ## Variables for framing and coloring the Table.
9: ## copied FROM WF_NOTIFICATION package
10: ## /fnddev/fnd/11.5/patch/115/sql/wfntfb.pls
11: ##
12: */
13:

Line 243: WF_NOTIFICATION.WriteToClob(Document,l_table_details);

239: ' l_table_details --> ' || l_table_details);
240: -- =============== END DEBUG LOG ==================
241:
242: -- adding to the clob
243: WF_NOTIFICATION.WriteToClob(Document,l_table_details);
244:
245: -- Framing the DU list and adding it to the table.
246: LOOP
247:

Line 276: WF_NOTIFICATION.WriteToClob(Document, l_table_details);

272: DEBUG_LOG_STRING (l_proc_level, 'Create_du_list.Msg9',
273: ' Table details -- l_table_details --> ' || l_table_details);
274: -- =============== END DEBUG LOG ==================
275:
276: WF_NOTIFICATION.WriteToClob(Document, l_table_details);
277:
278: l_du_list := substr (l_du_list, l_instr+1);
279:
280: -- =============== START DEBUG LOG ================

Line 303: WF_NOTIFICATION.WriteToClob(Document,l_table_details);

299: DEBUG_LOG_STRING (l_proc_level, 'Create_du_list.Msg12',
300: ' End of table -- l_table_details --> ' || l_table_details);
301: -- =============== END DEBUG LOG ==================
302:
303: WF_NOTIFICATION.WriteToClob(Document,l_table_details);
304:
305: -- =============== START DEBUG LOG ================
306: DEBUG_LOG_STRING (l_proc_level, 'Create_du_list.Msg13',
307: ' ** END CREATE_DU_LIST ** ');

Line 340: FROM wf_notification_attributes

336: -- =============== END DEBUG LOG ==================
337:
338: SELECT text_value
339: INTO l_value
340: FROM wf_notification_attributes
341: WHERE notification_id = p_nid
342: AND name = 'TU_FORM';
343:
344: -- =============== START DEBUG LOG ================

Line 359: UPDATE wf_notification_attributes

355: ' l_new_value --> ' || l_new_value);
356: -- =============== END DEBUG LOG ==================
357:
358:
359: UPDATE wf_notification_attributes
360: SET text_value = l_new_value
361: WHERE notification_id = p_nid
362: AND name = 'TU_FORM';
363:

Line 366: ' Updating wf_notification_attributes ');

362: AND name = 'TU_FORM';
363:
364: -- =============== START DEBUG LOG ================
365: DEBUG_LOG_STRING (l_proc_level, 'set_tu_form_to_query.Msg4',
366: ' Updating wf_notification_attributes ');
367: DEBUG_LOG_STRING (l_proc_level, 'set_tu_form_to_query.Msg5',
368: ' ** END SET_TU_FORM_TO_QUERY ** ');
369: -- =============== END DEBUG LOG ==================
370:

Line 2470: l_user_or_pos := wf_notification.GetAttrText(l_nid,'RESULT');

2466: DEBUG_LOG_STRING (l_proc_level, 'Check_user_position.Msg3',
2467: ' l_nid --> ' || l_nid);
2468: -- =============== END DEBUG LOG ==================
2469:
2470: l_user_or_pos := wf_notification.GetAttrText(l_nid,'RESULT');
2471:
2472: -- =============== START DEBUG LOG ================
2473: DEBUG_LOG_STRING (l_proc_level, 'Check_user_position.Msg4',
2474: ' l_user_or_pos --> ' || l_user_or_pos);

Line 2485: l_picked_authorizer := wf_notification.GetAttrText(l_nid,'PICKED_AUTHORIZER');

2481: ' l_user_or_pos = USER ');
2482: -- =============== END DEBUG LOG ==================
2483:
2484: -- The notification responder chose to send approval request to chosen user
2485: l_picked_authorizer := wf_notification.GetAttrText(l_nid,'PICKED_AUTHORIZER');
2486:
2487: -- =============== START DEBUG LOG ================
2488: DEBUG_LOG_STRING (l_proc_level, 'Check_user_position.Msg6',
2489: ' GetAttrText PICKED_AUTHORIZER --> ' || l_picked_authorizer);