DBA Data[Home] [Help]

APPS.CS_CHG_WF_EVENT_PKG dependencies on WF_EVENT

Line 1: PACKAGE BODY CS_CHG_WF_EVENT_PKG AS

1: PACKAGE BODY CS_CHG_WF_EVENT_PKG AS
2: /* $Header: cswfchgb.pls 115.0 2003/08/25 22:53:42 cnemalik noship $ */
3:
4:
5: PROCEDURE Raise_SubmitCharges_Event(

Line 70: wf_event.AddParameterToList(p_name => 'ESTIMATE_DETAIL_ID',

66: This section sets the Event Parameter List. These parameters are
67: converted to workflow item attributes.
68: *******************************************************************/
69:
70: wf_event.AddParameterToList(p_name => 'ESTIMATE_DETAIL_ID',
71: p_value => p_est_detail_rec.Estimate_Detail_Id,
72: p_parameterlist => l_param_list);
73:
74: wf_event.AddParameterToList(p_name => 'INCIDENT_ID',

Line 74: wf_event.AddParameterToList(p_name => 'INCIDENT_ID',

70: wf_event.AddParameterToList(p_name => 'ESTIMATE_DETAIL_ID',
71: p_value => p_est_detail_rec.Estimate_Detail_Id,
72: p_parameterlist => l_param_list);
73:
74: wf_event.AddParameterToList(p_name => 'INCIDENT_ID',
75: p_value => p_est_detail_rec.Incident_ID,
76: p_parameterlist => l_param_list);
77:
78: wf_event.AddParameterToList(p_name => 'USER_ID',

Line 78: wf_event.AddParameterToList(p_name => 'USER_ID',

74: wf_event.AddParameterToList(p_name => 'INCIDENT_ID',
75: p_value => p_est_detail_rec.Incident_ID,
76: p_parameterlist => l_param_list);
77:
78: wf_event.AddParameterToList(p_name => 'USER_ID',
79: p_value => p_USER_ID,
80: p_parameterlist => l_param_list);
81:
82: wf_event.AddParameterToList(p_name => 'RESP_ID',

Line 82: wf_event.AddParameterToList(p_name => 'RESP_ID',

78: wf_event.AddParameterToList(p_name => 'USER_ID',
79: p_value => p_USER_ID,
80: p_parameterlist => l_param_list);
81:
82: wf_event.AddParameterToList(p_name => 'RESP_ID',
83: p_value => p_RESP_ID,
84: p_parameterlist => l_param_list);
85:
86: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',

Line 86: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',

82: wf_event.AddParameterToList(p_name => 'RESP_ID',
83: p_value => p_RESP_ID,
84: p_parameterlist => l_param_list);
85:
86: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
87: p_value => p_RESP_APPL_ID,
88: p_parameterlist => l_param_list);
89:
90: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',

Line 90: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',

86: wf_event.AddParameterToList(p_name => 'RESP_APPL_ID',
87: p_value => p_RESP_APPL_ID,
88: p_parameterlist => l_param_list);
89:
90: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',
91: p_value => l_initiator_role,
92: p_parameterlist => l_param_list);
93:
94: wf_event.AddParameterToList(p_name => 'MANUAL_LAUNCH',

Line 94: wf_event.AddParameterToList(p_name => 'MANUAL_LAUNCH',

90: wf_event.AddParameterToList(p_name => 'INITIATOR_ROLE',
91: p_value => l_initiator_role,
92: p_parameterlist => l_param_list);
93:
94: wf_event.AddParameterToList(p_name => 'MANUAL_LAUNCH',
95: p_value => p_wf_manual_launch,
96: p_parameterlist => l_param_list);
97:
98: wf_event.AddParameterToList(p_name => 'ORG_ID',

Line 98: wf_event.AddParameterToList(p_name => 'ORG_ID',

94: wf_event.AddParameterToList(p_name => 'MANUAL_LAUNCH',
95: p_value => p_wf_manual_launch,
96: p_parameterlist => l_param_list);
97:
98: wf_event.AddParameterToList(p_name => 'ORG_ID',
99: p_value => p_est_detail_rec.org_id,
100: p_parameterlist => l_param_list);
101:
102: wf_event.AddParameterToList(p_name => 'ORDER_HEADER_ID',

Line 102: wf_event.AddParameterToList(p_name => 'ORDER_HEADER_ID',

98: wf_event.AddParameterToList(p_name => 'ORG_ID',
99: p_value => p_est_detail_rec.org_id,
100: p_parameterlist => l_param_list);
101:
102: wf_event.AddParameterToList(p_name => 'ORDER_HEADER_ID',
103: p_value => p_est_detail_rec.order_header_id,
104: p_parameterlist => l_param_list);
105:
106: wf_event.AddParameterToList(p_name => 'ORDER_LINE_ID',

Line 106: wf_event.AddParameterToList(p_name => 'ORDER_LINE_ID',

102: wf_event.AddParameterToList(p_name => 'ORDER_HEADER_ID',
103: p_value => p_est_detail_rec.order_header_id,
104: p_parameterlist => l_param_list);
105:
106: wf_event.AddParameterToList(p_name => 'ORDER_LINE_ID',
107: p_value => p_est_detail_rec.order_line_id,
108: p_parameterlist => l_param_list);
109:
110: wf_event.AddParameterToList(p_name => 'ORDER_LINE_TYPE_ID',

Line 110: wf_event.AddParameterToList(p_name => 'ORDER_LINE_TYPE_ID',

106: wf_event.AddParameterToList(p_name => 'ORDER_LINE_ID',
107: p_value => p_est_detail_rec.order_line_id,
108: p_parameterlist => l_param_list);
109:
110: wf_event.AddParameterToList(p_name => 'ORDER_LINE_TYPE_ID',
111: p_value => p_est_detail_rec.line_type_id,
112: p_parameterlist => l_param_list);
113:
114: wf_event.AddParameterToList(p_name => 'ORIGINAL_SOURCE_CODE',

Line 114: wf_event.AddParameterToList(p_name => 'ORIGINAL_SOURCE_CODE',

110: wf_event.AddParameterToList(p_name => 'ORDER_LINE_TYPE_ID',
111: p_value => p_est_detail_rec.line_type_id,
112: p_parameterlist => l_param_list);
113:
114: wf_event.AddParameterToList(p_name => 'ORIGINAL_SOURCE_CODE',
115: p_value => p_est_detail_rec.original_source_code,
116: p_parameterlist => l_param_list);
117:
118: wf_event.AddParameterToList(p_name => 'SOURCE_CODE',

Line 118: wf_event.AddParameterToList(p_name => 'SOURCE_CODE',

114: wf_event.AddParameterToList(p_name => 'ORIGINAL_SOURCE_CODE',
115: p_value => p_est_detail_rec.original_source_code,
116: p_parameterlist => l_param_list);
117:
118: wf_event.AddParameterToList(p_name => 'SOURCE_CODE',
119: p_value => p_est_detail_rec.source_code,
120: p_parameterlist => l_param_list);
121:
122:

Line 125: wf_event.AddParameterToList(p_name => 'WF_ADMINISTRATOR',

121:
122:
123: BEGIN
124:
125: wf_event.AddParameterToList(p_name => 'WF_ADMINISTRATOR',
126: p_value => l_initiator_role,
127: p_parameterlist => l_param_list);
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN

Line 146: wf_event.raise(p_event_name => 'oracle.apps.cs.chg.Charges.submitted',

142: l_event_key := p_Estimate_Detail_Id ||'-'||to_char(l_event_id) || '-EVT';
143:
144: --RAISE the WF Business event.
145:
146: wf_event.raise(p_event_name => 'oracle.apps.cs.chg.Charges.submitted',
147: p_event_key => l_event_key,
148: p_parameters => l_param_list);
149: l_param_list.DELETE;
150:

Line 167: END CS_CHG_WF_EVENT_PKG;

163:
164:
165:
166:
167: END CS_CHG_WF_EVENT_PKG;