APPS.PQH_SS_WORKFLOW dependencies on WF_NOTIFICATIONS

Line 245: FROM wf_notifications

241:
242: CURSOR cur_not IS
243: SELECT SUBSTR(context,1,INSTR(context,':',1)-1)
244: ,SUBSTR(context,INSTR(context,':')+1, ( INSTR(context,':',INSTR(context,':')+1 ) - INSTR(context,':')-1) )
245: FROM wf_notifications
246: WHERE notification_id = p_ntfId;
247: BEGIN
248: IF ( cur_ias%ISOPEN ) THEN
249: CLOSE cur_ias;

Line 2303: FROM wf_notifications wn, wf_message_attributes_vl wma

2299: ,p_itemType in varchar2) return varchar2 IS
2300: --
2301: CURSOR cur_ntf IS
2302: SELECT wma.display_name
2303: FROM wf_notifications wn, wf_message_attributes_vl wma
2304: WHERE wn.notification_id = p_ntfId
2305: AND wn.message_name = wma.message_name
2306: AND wma.message_type = p_itemType
2307: AND wma.name = 'EDIT_TXN_URL';

Line 2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;

2994: FUNCTION is_notification_closed (
2995: p_ntfId IN VARCHAR2 ) RETURN VARCHAR2 IS
2996: --
2997: l_isClosed VARCHAR2(10) := 'N';
2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

Line 2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;

2995: p_ntfId IN VARCHAR2 ) RETURN VARCHAR2 IS
2996: --
2997: l_isClosed VARCHAR2(10) := 'N';
2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

Line 3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;

2996: --
2997: l_isClosed VARCHAR2(10) := 'N';
2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3004: --

Line 3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;

2997: l_isClosed VARCHAR2(10) := 'N';
2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3004: --
3005: BEGIN

Line 3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

2998: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3004: --
3005: BEGIN
3006: --

Line 3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

2999: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3000: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3001: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3002: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3003: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3004: --
3005: BEGIN
3006: --
3007: -- Get notification recipient and status

Line 3239: * WF_notifications package with some modifications to cater

3235: * to the bottom of approval notifications. It also considers
3236: * RFC notifications and includes the record in building the
3237: * Workflow History.
3238: * This procedure internally uses two procedures copied from
3239: * WF_notifications package with some modifications to cater
3240: * to our specific need
3241: */
3242: PROCEDURE approval_history (
3243: document_id in varchar2,