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 2326: FROM wf_notifications wn, wf_message_attributes_vl wma

2322: ,p_itemType in varchar2) return varchar2 IS
2323: --
2324: CURSOR cur_ntf IS
2325: SELECT wma.display_name
2326: FROM wf_notifications wn, wf_message_attributes_vl wma
2327: WHERE wn.notification_id = p_ntfId
2328: AND wn.message_name = wma.message_name
2329: AND wma.message_type = p_itemType
2330: AND wma.name = 'EDIT_TXN_URL';

Line 3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;

3026: FUNCTION is_notification_closed (
3027: p_ntfId IN VARCHAR2 ) RETURN VARCHAR2 IS
3028: --
3029: l_isClosed VARCHAR2(10) := 'N';
3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

Line 3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;

3027: p_ntfId IN VARCHAR2 ) RETURN VARCHAR2 IS
3028: --
3029: l_isClosed VARCHAR2(10) := 'N';
3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

Line 3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;

3028: --
3029: l_isClosed VARCHAR2(10) := 'N';
3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3036: --

Line 3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;

3029: l_isClosed VARCHAR2(10) := 'N';
3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3036: --
3037: BEGIN

Line 3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

3030: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3036: --
3037: BEGIN
3038: --

Line 3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

3031: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
3032: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
3033: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
3034: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
3035: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
3036: --
3037: BEGIN
3038: --
3039: -- Get notification recipient and status

Line 3271: * WF_notifications package with some modifications to cater

3267: * to the bottom of approval notifications. It also considers
3268: * RFC notifications and includes the record in building the
3269: * Workflow History.
3270: * This procedure internally uses two procedures copied from
3271: * WF_notifications package with some modifications to cater
3272: * to our specific need
3273: */
3274: PROCEDURE approval_history (
3275: document_id in varchar2,