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:
69: cursor msite_null_csr(p_notif_setup_id IN NUMBER, p_msite_id IN NUMBER) IS

Line 72: from ibe_wf_notif_msg_maps

68:
69: cursor msite_null_csr(p_notif_setup_id IN NUMBER, p_msite_id IN NUMBER) IS
70: select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
71: all_msite_flag, all_org_flag, all_user_Type_flag
72: from ibe_wf_notif_msg_maps
73: where notif_setup_id = p_notif_setup_id
74: and msite_id is null;
75:
76: l_idx NUMBER := 1;

Line 112: from ibe_wf_notif_msg_maps

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

Line 215: from IBE_WF_NOTIF_MSG_MAPS

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

Line 372: from ibe_wf_notif_msg_maps

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

Line 378: from ibe_wf_notif_msg_maps

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

Line 417: from ibe_wf_notif_msg_maps

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

Line 444: from ibe_wf_notif_msg_maps

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

Line 470: from ibe_wf_notif_msg_maps

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

Line 646: from IBE_WF_NOTIF_MSG_MAPS

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