eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_GROUP_WF_PKG dependencies on EGO_GROUP_WF_PKG

Line 1: PACKAGE BODY EGO_GROUP_WF_PKG AS

1: PACKAGE BODY EGO_GROUP_WF_PKG AS
2: /* $Header: EGOPGWFB.pls 120.1 2006/01/31 01:40:19 vkeerthi noship $ */
3:
4: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'EGO_GROUP_WF_PKG';
5: G_USER_MAIL_PREFERENCE CONSTANT VARCHAR2(30) := 'MAILHTML';

Line 4: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'EGO_GROUP_WF_PKG';

1: PACKAGE BODY EGO_GROUP_WF_PKG AS
2: /* $Header: EGOPGWFB.pls 120.1 2006/01/31 01:40:19 vkeerthi noship $ */
3:
4: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'EGO_GROUP_WF_PKG';
5: G_USER_MAIL_PREFERENCE CONSTANT VARCHAR2(30) := 'MAILHTML';
6: G_ITEM_TYPE CONSTANT VARCHAR2(30) := 'EGOGROUP';
7: G_GROUP_OBJECT_NAME CONSTANT VARCHAR2(30) := 'EGO_GROUP';
8:

Line 213: x_names_tbl OUT NOCOPY EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE,

209: PROCEDURE Unmarshall_Xml
210: (
211: p_process_type IN NUMBER,
212: p_name_values_xml IN VARCHAR2,
213: x_names_tbl OUT NOCOPY EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE,
214: x_values_tbl OUT NOCOPY EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE
215: )
216: IS
217: ----------------------------------------------------------------------

Line 214: x_values_tbl OUT NOCOPY EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE

210: (
211: p_process_type IN NUMBER,
212: p_name_values_xml IN VARCHAR2,
213: x_names_tbl OUT NOCOPY EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE,
214: x_values_tbl OUT NOCOPY EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE
215: )
216: IS
217: ----------------------------------------------------------------------
218: -- Start OF comments

Line 235: -- IN : p_names_tbl OUT EGO_GROUP_WF_PKG..VARCHAR_TBL_TYPE

231:
232: -- IN : p_names_values_xml IN VARCHAR2 (Required)
233: -- name value pairs combination string
234:
235: -- IN : p_names_tbl OUT EGO_GROUP_WF_PKG..VARCHAR_TBL_TYPE
236: -- names table (generated after parsing p_names_values_xml)
237:
238: -- IN : p_values_tbl OUT EGO_GROUP_WF_PKG..VARCHAR_TBL_TYPE
239: -- values table (generated after parsing p_values_values_xml)

Line 238: -- IN : p_values_tbl OUT EGO_GROUP_WF_PKG..VARCHAR_TBL_TYPE

234:
235: -- IN : p_names_tbl OUT EGO_GROUP_WF_PKG..VARCHAR_TBL_TYPE
236: -- names table (generated after parsing p_names_values_xml)
237:
238: -- IN : p_values_tbl OUT EGO_GROUP_WF_PKG..VARCHAR_TBL_TYPE
239: -- values table (generated after parsing p_values_values_xml)
240: --
241: -- History :
242: -- 21-jul-2002 Sridhar Rajaparthi Creation

Line 247: l_names_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;

243: --
244: -- END OF comments
245: ----------------------------------------------------------------------
246:
247: l_names_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
248: l_values_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
249:
250: l_names_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
251: l_values_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;

Line 248: l_values_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;

244: -- END OF comments
245: ----------------------------------------------------------------------
246:
247: l_names_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
248: l_values_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
249:
250: l_names_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
251: l_values_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
252:

Line 250: l_names_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;

246:
247: l_names_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
248: l_values_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
249:
250: l_names_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
251: l_values_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
252:
253: --index for looping
254: i NUMBER;

Line 251: l_values_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;

247: l_names_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
248: l_values_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
249:
250: l_names_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
251: l_values_out_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
252:
253: --index for looping
254: i NUMBER;
255:

Line 530: l_names_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;

526: --
527: -- END OF comments
528: ----------------------------------------------------------------------
529:
530: l_names_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
531: l_values_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
532:
533: l_owner_id NUMBER;
534: l_owner_name HZ_PARTIES.PARTY_NAME%TYPE;

Line 531: l_values_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;

527: -- END OF comments
528: ----------------------------------------------------------------------
529:
530: l_names_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
531: l_values_tbl EGO_GROUP_WF_PKG.VARCHAR_TBL_TYPE;
532:
533: l_owner_id NUMBER;
534: l_owner_name HZ_PARTIES.PARTY_NAME%TYPE;
535: l_owner_user_name FND_USER.USER_NAME%TYPE;

Line 660: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Approval_Req_Doc/'

656: --This is a call for creating a PLSQL document.
657: --Add_GrpMem_Approval_Req_Doc gets the message from FND_NEW_MESSAGES
658: --and stubs in the token values, and is used as a approval notification
659: --for the owner
660: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Approval_Req_Doc/'
661: ||p_item_type||':'||p_item_key;
662: --set Owner Approval Request body as the item level attribute
663: wf_engine.SetItemAttrText( itemtype => p_item_type,
664: itemkey => p_item_key,

Line 683: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Approval_Msg_Doc/'

679: avalue => fnd_message.get);
680:
681: -- fix for 3096076 removing the reference of setting the attribute
682: -- and calling the package to dynamically create the document
683: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Approval_Msg_Doc/'
684: ||p_item_type||':'||p_item_key;
685: --set Reject Notification body as the item level attribute
686: wf_engine.SetItemAttrText( itemtype => p_item_type,
687: itemkey => p_item_key,

Line 726: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Reject_Msg_Doc/'

722: avalue => fnd_message.get);
723:
724: -- fix for 3096076 removing the reference of setting the attribute
725: -- and calling the package to dynamically create the document
726: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Reject_Msg_Doc/'
727: ||p_item_type||':'||p_item_key;
728: --set Reject Notification body as the item level attribute
729: wf_engine.SetItemAttrText( itemtype => p_item_type,
730: itemkey => p_item_key,

Line 780: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Unsub_Member_Owner_FYI_Doc/'

776:
777: -- fix for 3096076 removing the reference of setting the attribute
778: -- and calling the package to dynamically create the document
779: mdebug (' Remove Group Member Subject Set '|| fnd_message.get);
780: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Unsub_Member_Owner_FYI_Doc/'
781: ||p_item_type||':'||p_item_key;
782: --set Reject Notification body as the item level attribute
783: wf_engine.SetItemAttrText( itemtype => p_item_type,
784: itemkey => p_item_key,

Line 839: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Unsub_Member_Conf_Mem_Doc/'

835: avalue => fnd_message.get);
836:
837: -- fix for 3096076 removing the reference of setting the attribute
838: -- and calling the package to dynamically create the document
839: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Unsub_Member_Conf_Mem_Doc/'
840: ||p_item_type||':'||p_item_key;
841: --set Reject Notification body as the item level attribute
842: wf_engine.SetItemAttrText( itemtype => p_item_type,
843: itemkey => p_item_key,

Line 1176: mdebug (' EGO_GROUP_WF_PKG.Start_Delete_Group_Process ');

1172: SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
1173: FROM dual;
1174:
1175: BEGIN
1176: mdebug (' EGO_GROUP_WF_PKG.Start_Delete_Group_Process ');
1177: mdebug('1');
1178: OPEN get_item_key_id_c;
1179: FETCH get_item_key_id_c INTO l_item_key_id;
1180: CLOSE get_item_key_id_c;

Line 1705: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Del_Grp_Admin_Notif_Doc/'

1701: itemkey => p_item_key,
1702: aname => 'EGO_GROUP_DEL_MEM_NOTF_SUBJ',
1703: avalue => fnd_message.get);
1704:
1705: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Del_Grp_Admin_Notif_Doc/'
1706: ||p_item_type||':'||p_item_key;
1707:
1708: --set Owner Group Del Message body as the item level attribute
1709: wf_engine.SetItemAttrText(itemtype => p_item_type,

Line 1737: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Del_Grp_Mem_Notif_Doc/'

1733: -- --
1734: -- Send notifications to all members --
1735: -- --
1736: ------------------------------------------------
1737: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Del_Grp_Mem_Notif_Doc/'
1738: ||p_item_type||':'||p_item_key;
1739: --set Group Del Message body for Member as the item level attribute
1740: wf_engine.SetItemAttrText(itemtype => p_item_type,
1741: itemkey => p_item_key,

Line 2608: END EGO_GROUP_WF_PKG;

2604: END IF;
2605: RAISE;
2606: END create_grp_admin_wf_role;
2607:
2608: END EGO_GROUP_WF_PKG;