APPS.IBE_WF_MSG_MAPPING_PVT dependencies on IBE_WF_NOTIF_MSG_MAPS

Line 65: from ibe_wf_notif_msg_maps

61: l_msite_tbl WFMSG_TBL_TYPE;
62: cursor msite_csr(p_notif_setup_id IN NUMBER, p_msite_id IN NUMBER) IS
63: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
64: all_msite_flag, all_org_flag, all_user_Type_flag
65: from ibe_wf_notif_msg_maps
66: where notif_setup_id = p_notif_setup_id
67: and msite_id = p_msite_id
68: and enabled_flag = 'Y'; -- bug 7720550, scnagara
69:

Line 73: from ibe_wf_notif_msg_maps

69:
70: cursor msite_null_csr(p_notif_setup_id IN NUMBER, p_msite_id IN NUMBER) IS
71: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
72: all_msite_flag, all_org_flag, all_user_Type_flag
73: from ibe_wf_notif_msg_maps
74: where notif_setup_id = p_notif_setup_id
75: and msite_id is null
76: and enabled_flag = 'Y'; -- bug 7720550, scnagara
77:

Line 114: from ibe_wf_notif_msg_maps

110: l_msite_tbl WFMSG_TBL_TYPE;
111: cursor msite_csr(p_notif_setup_id IN NUMBER) IS
112: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
113: all_msite_flag, all_org_flag, all_user_Type_flag
114: from ibe_wf_notif_msg_maps
115: where notif_setup_id = p_notif_setup_id
116: and all_msite_flag = 'Y'
117: and enabled_flag = 'Y' ; -- bug 7720550, scnagara
118: l_idx NUMBER := 1;

Line 218: from IBE_WF_NOTIF_MSG_MAPS

214: x_enabled_flag OUT NOCOPY VARCHAR2,
215: p_notif_Setup_id IN NUMBER) IS
216: cursor default_msg(p_notif_setup_id IN NUMBER) is
217: select message_name, enabled_flag
218: from IBE_WF_NOTIF_MSG_MAPS
219: WHERE notif_setup_id = p_notif_setup_id
220: and default_msg_map_flag = 'Y';
221: l_wf_msg_name VARCHAR2(30);
222: l_enabled_flag VARCHAR2(1);

Line 375: from ibe_wf_notif_msg_maps

371: l_org_tbl WFMSG_TBL_TYPE;
372: cursor org_null_csr(p_notif_setup_id IN NUMBER, p_org_id IN NUMBER) IS
373: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
374: all_msite_flag, all_org_flag, all_user_Type_flag
375: from ibe_wf_notif_msg_maps
376: where notif_setup_id = p_notif_setup_id
377: and org_id is null;
378: cursor org_csr(p_notif_setup_id IN NUMBER, p_org_id IN NUMBER) IS
379: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,

Line 381: from ibe_wf_notif_msg_maps

377: and org_id is null;
378: cursor org_csr(p_notif_setup_id IN NUMBER, p_org_id IN NUMBER) IS
379: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
380: all_msite_flag, all_org_flag, all_user_Type_flag
381: from ibe_wf_notif_msg_maps
382: where notif_setup_id = p_notif_setup_id
383: and org_id = p_org_id;
384: l_idx NUMBER := 1;
385: l_wfmsg_rec WFMSG_REC_TYPE;

Line 420: from ibe_wf_notif_msg_maps

416: l_org_tbl WFMSG_TBL_TYPE;
417: cursor org_csr(p_notif_setup_id IN NUMBER) IS
418: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
419: all_msite_flag, all_org_flag, all_user_Type_flag
420: from ibe_wf_notif_msg_maps
421: where notif_setup_id = p_notif_setup_id
422: and all_org_flag = 'Y';
423: l_idx NUMBER := 1;
424: l_wfmsg_rec WFMSG_REC_TYPE;

Line 447: from ibe_wf_notif_msg_maps

443: l_user_type_tbl WFMSG_TBL_TYPE;
444: cursor user_type_csr(p_notif_setup_id IN NUMBER, p_user_type IN VARCHAR2) IS
445: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
446: all_msite_flag, all_org_flag, all_user_Type_flag
447: from ibe_wf_notif_msg_maps
448: where notif_setup_id = p_notif_setup_id
449: and user_type = p_user_type;
450: l_idx NUMBER := 1;
451: l_wfmsg_rec WFMSG_REC_TYPE;

Line 473: from ibe_wf_notif_msg_maps

469: l_user_type_tbl WFMSG_TBL_TYPE;
470: cursor user_type_csr(p_notif_setup_id IN NUMBER) IS
471: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
472: all_msite_flag, all_org_flag, all_user_Type_flag
473: from ibe_wf_notif_msg_maps
474: where notif_setup_id = p_notif_setup_id
475: and all_user_type_flag = 'Y';
476: l_idx NUMBER := 1;
477: l_wfmsg_rec WFMSG_REC_TYPE;

Line 649: from IBE_WF_NOTIF_MSG_MAPS

645: elsif( l_msite_id_flag = 'N' AND l_org_id_flag = 'N' AND l_user_type_flag = 'N' ) then
646: BEGIN
647: select message_name, enabled_flag
648: into l_wf_msg_name, l_enabled_flag
649: from IBE_WF_NOTIF_MSG_MAPS
650: where notif_setup_id = l_notif_setup_id
651: AND default_msg_map_flag <> 'Y'
652: and rownum < 2;
653: EXCEPTION