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.IGS_PS_WF_EVENT_PKG dependencies on WF_EVENT

Line 1: PACKAGE BODY IGS_PS_WF_EVENT_PKG AS

1: PACKAGE BODY IGS_PS_WF_EVENT_PKG AS
2: /* $Header: IGSPS82B.pls 120.2 2006/01/09 06:32:48 sommukhe ship $ */
3:
4: ------------------------------------------------------------------------------------
5: --Created by : smanglm ( Oracle IDC)

Line 30: l_wf_event_t WF_EVENT_T;

26: p_event_type IN VARCHAR2,
27: p_message OUT NOCOPY VARCHAR2
28: )
29: IS
30: l_wf_event_t WF_EVENT_T;
31: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
32:
33: --
34: -- cursor to fetch the usec_occur_id

Line 66: -- initialize the wf_event_t object

62: IS
63: l_key NUMBER;
64: BEGIN
65: --
66: -- initialize the wf_event_t object
67: --
68: WF_EVENT_T.Initialize(l_wf_event_t);
69: --
70: -- set the event name

Line 68: WF_EVENT_T.Initialize(l_wf_event_t);

64: BEGIN
65: --
66: -- initialize the wf_event_t object
67: --
68: WF_EVENT_T.Initialize(l_wf_event_t);
69: --
70: -- set the event name
71: --
72: l_wf_event_t.setEventName( pEventName => p_event_name);

Line 72: l_wf_event_t.setEventName( pEventName => p_event_name);

68: WF_EVENT_T.Initialize(l_wf_event_t);
69: --
70: -- set the event name
71: --
72: l_wf_event_t.setEventName( pEventName => p_event_name);
73: --
74: -- set the event key but before the select a number from sequenec
75: --
76: SELECT IGS_PS_USEC_WF_ITEM_KEY_S.NEXTVAL INTO l_key FROM dual;

Line 77: l_wf_event_t.setEventKey ( pEventKey => p_event_key||l_key );

73: --
74: -- set the event key but before the select a number from sequenec
75: --
76: SELECT IGS_PS_USEC_WF_ITEM_KEY_S.NEXTVAL INTO l_key FROM dual;
77: l_wf_event_t.setEventKey ( pEventKey => p_event_key||l_key );
78: --
79: -- set the parameter list
80: --
81: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );

Line 81: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );

77: l_wf_event_t.setEventKey ( pEventKey => p_event_key||l_key );
78: --
79: -- set the parameter list
80: --
81: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
82: --
83: -- now add the parameters to the parameter list
84: --
85: l_wf_event_t.AddParameterToList ( pName => 'ORG_ID', pValue => FND_PROFILE.VALUE('ORG_ID'));

Line 85: l_wf_event_t.AddParameterToList ( pName => 'ORG_ID', pValue => FND_PROFILE.VALUE('ORG_ID'));

81: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
82: --
83: -- now add the parameters to the parameter list
84: --
85: l_wf_event_t.AddParameterToList ( pName => 'ORG_ID', pValue => FND_PROFILE.VALUE('ORG_ID'));
86: l_wf_event_t.AddParameterToList ( pName => 'USER_ID', pValue => FND_PROFILE.VALUE('USER_ID'));
87: l_wf_event_t.AddParameterToList ( pName => 'RESP_ID', pValue => FND_PROFILE.VALUE('RESP_ID'));
88: l_wf_event_t.AddParameterToList ( pName => 'RESP_APPL_ID', pValue => FND_PROFILE.VALUE('RESP_APPL_ID'));
89: l_wf_event_t.AddParameterToList ( pName => 'UOO_ID', pValue => p_uoo_id);

Line 86: l_wf_event_t.AddParameterToList ( pName => 'USER_ID', pValue => FND_PROFILE.VALUE('USER_ID'));

82: --
83: -- now add the parameters to the parameter list
84: --
85: l_wf_event_t.AddParameterToList ( pName => 'ORG_ID', pValue => FND_PROFILE.VALUE('ORG_ID'));
86: l_wf_event_t.AddParameterToList ( pName => 'USER_ID', pValue => FND_PROFILE.VALUE('USER_ID'));
87: l_wf_event_t.AddParameterToList ( pName => 'RESP_ID', pValue => FND_PROFILE.VALUE('RESP_ID'));
88: l_wf_event_t.AddParameterToList ( pName => 'RESP_APPL_ID', pValue => FND_PROFILE.VALUE('RESP_APPL_ID'));
89: l_wf_event_t.AddParameterToList ( pName => 'UOO_ID', pValue => p_uoo_id);
90: l_wf_event_t.AddParameterToList ( pName => 'USEC_OCCUR_ID', pValue => p_usec_occur_id);

Line 87: l_wf_event_t.AddParameterToList ( pName => 'RESP_ID', pValue => FND_PROFILE.VALUE('RESP_ID'));

83: -- now add the parameters to the parameter list
84: --
85: l_wf_event_t.AddParameterToList ( pName => 'ORG_ID', pValue => FND_PROFILE.VALUE('ORG_ID'));
86: l_wf_event_t.AddParameterToList ( pName => 'USER_ID', pValue => FND_PROFILE.VALUE('USER_ID'));
87: l_wf_event_t.AddParameterToList ( pName => 'RESP_ID', pValue => FND_PROFILE.VALUE('RESP_ID'));
88: l_wf_event_t.AddParameterToList ( pName => 'RESP_APPL_ID', pValue => FND_PROFILE.VALUE('RESP_APPL_ID'));
89: l_wf_event_t.AddParameterToList ( pName => 'UOO_ID', pValue => p_uoo_id);
90: l_wf_event_t.AddParameterToList ( pName => 'USEC_OCCUR_ID', pValue => p_usec_occur_id);
91: l_wf_event_t.AddParameterToList ( pName => 'EVENT_TYPE', pValue => p_event_type);

Line 88: l_wf_event_t.AddParameterToList ( pName => 'RESP_APPL_ID', pValue => FND_PROFILE.VALUE('RESP_APPL_ID'));

84: --
85: l_wf_event_t.AddParameterToList ( pName => 'ORG_ID', pValue => FND_PROFILE.VALUE('ORG_ID'));
86: l_wf_event_t.AddParameterToList ( pName => 'USER_ID', pValue => FND_PROFILE.VALUE('USER_ID'));
87: l_wf_event_t.AddParameterToList ( pName => 'RESP_ID', pValue => FND_PROFILE.VALUE('RESP_ID'));
88: l_wf_event_t.AddParameterToList ( pName => 'RESP_APPL_ID', pValue => FND_PROFILE.VALUE('RESP_APPL_ID'));
89: l_wf_event_t.AddParameterToList ( pName => 'UOO_ID', pValue => p_uoo_id);
90: l_wf_event_t.AddParameterToList ( pName => 'USEC_OCCUR_ID', pValue => p_usec_occur_id);
91: l_wf_event_t.AddParameterToList ( pName => 'EVENT_TYPE', pValue => p_event_type);
92:

Line 89: l_wf_event_t.AddParameterToList ( pName => 'UOO_ID', pValue => p_uoo_id);

85: l_wf_event_t.AddParameterToList ( pName => 'ORG_ID', pValue => FND_PROFILE.VALUE('ORG_ID'));
86: l_wf_event_t.AddParameterToList ( pName => 'USER_ID', pValue => FND_PROFILE.VALUE('USER_ID'));
87: l_wf_event_t.AddParameterToList ( pName => 'RESP_ID', pValue => FND_PROFILE.VALUE('RESP_ID'));
88: l_wf_event_t.AddParameterToList ( pName => 'RESP_APPL_ID', pValue => FND_PROFILE.VALUE('RESP_APPL_ID'));
89: l_wf_event_t.AddParameterToList ( pName => 'UOO_ID', pValue => p_uoo_id);
90: l_wf_event_t.AddParameterToList ( pName => 'USEC_OCCUR_ID', pValue => p_usec_occur_id);
91: l_wf_event_t.AddParameterToList ( pName => 'EVENT_TYPE', pValue => p_event_type);
92:
93: --

Line 90: l_wf_event_t.AddParameterToList ( pName => 'USEC_OCCUR_ID', pValue => p_usec_occur_id);

86: l_wf_event_t.AddParameterToList ( pName => 'USER_ID', pValue => FND_PROFILE.VALUE('USER_ID'));
87: l_wf_event_t.AddParameterToList ( pName => 'RESP_ID', pValue => FND_PROFILE.VALUE('RESP_ID'));
88: l_wf_event_t.AddParameterToList ( pName => 'RESP_APPL_ID', pValue => FND_PROFILE.VALUE('RESP_APPL_ID'));
89: l_wf_event_t.AddParameterToList ( pName => 'UOO_ID', pValue => p_uoo_id);
90: l_wf_event_t.AddParameterToList ( pName => 'USEC_OCCUR_ID', pValue => p_usec_occur_id);
91: l_wf_event_t.AddParameterToList ( pName => 'EVENT_TYPE', pValue => p_event_type);
92:
93: --
94: -- raise the event

Line 91: l_wf_event_t.AddParameterToList ( pName => 'EVENT_TYPE', pValue => p_event_type);

87: l_wf_event_t.AddParameterToList ( pName => 'RESP_ID', pValue => FND_PROFILE.VALUE('RESP_ID'));
88: l_wf_event_t.AddParameterToList ( pName => 'RESP_APPL_ID', pValue => FND_PROFILE.VALUE('RESP_APPL_ID'));
89: l_wf_event_t.AddParameterToList ( pName => 'UOO_ID', pValue => p_uoo_id);
90: l_wf_event_t.AddParameterToList ( pName => 'USEC_OCCUR_ID', pValue => p_usec_occur_id);
91: l_wf_event_t.AddParameterToList ( pName => 'EVENT_TYPE', pValue => p_event_type);
92:
93: --
94: -- raise the event
95: --

Line 96: WF_EVENT.RAISE (p_event_name => p_event_name,

92:
93: --
94: -- raise the event
95: --
96: WF_EVENT.RAISE (p_event_name => p_event_name,
97: p_event_key => p_event_key||l_key,
98: p_event_data => NULL,
99: p_parameters => l_wf_parameter_list_t);
100: END raise_event;

Line 322: l_wf_event_t WF_EVENT_T;

318: --sommukhe 9-JAN-2006 Bug# 4869737,included call to igs_ge_gen_003.set_org_id.
319: -------------------------------------------------------------------------------------
320: AS
321: l_n_key NUMBER;
322: l_wf_event_t WF_EVENT_T;
323: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
324:
325: l_c_user_name fnd_user.user_name%TYPE:=fnd_global.user_name;
326: l_c_cal_type igs_ca_inst.cal_type%TYPE;

Line 366: -- initialize the wf_event_t object

362:
363: l_c_cal_type := RTRIM(SUBSTR(p_c_cal_inst,1,10));
364: l_n_cal_seq_num := TO_NUMBER(RTRIM(SUBSTR(p_c_cal_inst,14,19)));
365:
366: -- initialize the wf_event_t object
367: --
368: WF_EVENT_T.Initialize(l_wf_event_t);
369: --
370: -- set the event name

Line 368: WF_EVENT_T.Initialize(l_wf_event_t);

364: l_n_cal_seq_num := TO_NUMBER(RTRIM(SUBSTR(p_c_cal_inst,14,19)));
365:
366: -- initialize the wf_event_t object
367: --
368: WF_EVENT_T.Initialize(l_wf_event_t);
369: --
370: -- set the event name
371: --
372: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.ps.exceed.fac_workload');

Line 372: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.ps.exceed.fac_workload');

368: WF_EVENT_T.Initialize(l_wf_event_t);
369: --
370: -- set the event name
371: --
372: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.ps.exceed.fac_workload');
373: --
374: -- event key to identify uniquely
375: --
376: OPEN c_seq;

Line 382: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );

378: CLOSE c_seq;
379: --
380: -- set the parameter list
381: --
382: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
383: --
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);

Line 386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);

382: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
383: --
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);
388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event

Line 387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);

383: --
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);
388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event
391:

Line 388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);

384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);
388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event
391:
392: wf_event.raise (

Line 392: wf_event.raise (

388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event
391:
392: wf_event.raise (
393: p_event_name => 'oracle.apps.igs.ps.fac_workload.exceed',
394: p_event_key => 'FACEXCEEDWL'||l_n_key,
395: p_parameters => l_wf_parameter_list_t
396: );

Line 431: avalue => 'PLSQLCLOB:igs_ps_wf_event_pkg.generate_faculty_header/'|| itemtype || ':' || itemkey);

427:
428: wf_engine.SetItemAttrText(itemtype => itemtype,
429: itemkey => itemkey,
430: aname => 'IA_FAC_HEADER',
431: avalue => 'PLSQLCLOB:igs_ps_wf_event_pkg.generate_faculty_header/'|| itemtype || ':' || itemkey);
432:
433: wf_engine.SetItemAttrText(itemtype => itemtype,
434: itemkey => itemkey,
435: aname => 'IA_FAC_BODY',

Line 436: avalue => 'PLSQLCLOB:igs_ps_wf_event_pkg.generate_faculty_body/'|| itemtype || ':' || itemkey);

432:
433: wf_engine.SetItemAttrText(itemtype => itemtype,
434: itemkey => itemkey,
435: aname => 'IA_FAC_BODY',
436: avalue => 'PLSQLCLOB:igs_ps_wf_event_pkg.generate_faculty_body/'|| itemtype || ':' || itemkey);
437:
438:
439: Resultout:= 'COMPLETE:';
440: RETURN;

Line 630: END IGS_PS_WF_EVENT_PKG;

626: WF_NOTIFICATION.WriteToClob(document, l_c_document);
627:
628: END generate_faculty_body;
629:
630: END IGS_PS_WF_EVENT_PKG;