DBA Data[Home] [Help]

APPS.IGS_PS_WF_EVENT_PKG dependencies on WF_EVENT_T

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 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);