236: -- for create - event_name || srp_paygroup_id
237: l_key := l_event_name || '-' || p_srp_plan_assign_id;
238:
239: -- build parameter list as appropriate
240: wf_event.AddParameterToList('SRP_PLAN_ASSIGN_ID',p_srp_plan_assign_id,l_list);
241: wf_event.AddParameterToList('SRP_ROLE_ID',p_srp_role_id,l_list);
242: wf_event.AddParameterToList('ROLE_PLAN_ID',p_role_plan_id,l_list);
243: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan_id,l_list);
244: wf_event.AddParameterToList('ROLE_ID',p_role_id,l_list);
237: l_key := l_event_name || '-' || p_srp_plan_assign_id;
238:
239: -- build parameter list as appropriate
240: wf_event.AddParameterToList('SRP_PLAN_ASSIGN_ID',p_srp_plan_assign_id,l_list);
241: wf_event.AddParameterToList('SRP_ROLE_ID',p_srp_role_id,l_list);
242: wf_event.AddParameterToList('ROLE_PLAN_ID',p_role_plan_id,l_list);
243: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan_id,l_list);
244: wf_event.AddParameterToList('ROLE_ID',p_role_id,l_list);
245: wf_event.AddParameterToList('SALESREP_ID',p_salesrep_id,l_list);
238:
239: -- build parameter list as appropriate
240: wf_event.AddParameterToList('SRP_PLAN_ASSIGN_ID',p_srp_plan_assign_id,l_list);
241: wf_event.AddParameterToList('SRP_ROLE_ID',p_srp_role_id,l_list);
242: wf_event.AddParameterToList('ROLE_PLAN_ID',p_role_plan_id,l_list);
243: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan_id,l_list);
244: wf_event.AddParameterToList('ROLE_ID',p_role_id,l_list);
245: wf_event.AddParameterToList('SALESREP_ID',p_salesrep_id,l_list);
246: wf_event.AddParameterToList('START_DATE',p_start_date,l_list);
239: -- build parameter list as appropriate
240: wf_event.AddParameterToList('SRP_PLAN_ASSIGN_ID',p_srp_plan_assign_id,l_list);
241: wf_event.AddParameterToList('SRP_ROLE_ID',p_srp_role_id,l_list);
242: wf_event.AddParameterToList('ROLE_PLAN_ID',p_role_plan_id,l_list);
243: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan_id,l_list);
244: wf_event.AddParameterToList('ROLE_ID',p_role_id,l_list);
245: wf_event.AddParameterToList('SALESREP_ID',p_salesrep_id,l_list);
246: wf_event.AddParameterToList('START_DATE',p_start_date,l_list);
247: wf_event.AddParameterToList('END_DATE',p_end_date,l_list);
240: wf_event.AddParameterToList('SRP_PLAN_ASSIGN_ID',p_srp_plan_assign_id,l_list);
241: wf_event.AddParameterToList('SRP_ROLE_ID',p_srp_role_id,l_list);
242: wf_event.AddParameterToList('ROLE_PLAN_ID',p_role_plan_id,l_list);
243: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan_id,l_list);
244: wf_event.AddParameterToList('ROLE_ID',p_role_id,l_list);
245: wf_event.AddParameterToList('SALESREP_ID',p_salesrep_id,l_list);
246: wf_event.AddParameterToList('START_DATE',p_start_date,l_list);
247: wf_event.AddParameterToList('END_DATE',p_end_date,l_list);
248:
241: wf_event.AddParameterToList('SRP_ROLE_ID',p_srp_role_id,l_list);
242: wf_event.AddParameterToList('ROLE_PLAN_ID',p_role_plan_id,l_list);
243: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan_id,l_list);
244: wf_event.AddParameterToList('ROLE_ID',p_role_id,l_list);
245: wf_event.AddParameterToList('SALESREP_ID',p_salesrep_id,l_list);
246: wf_event.AddParameterToList('START_DATE',p_start_date,l_list);
247: wf_event.AddParameterToList('END_DATE',p_end_date,l_list);
248:
249: -- Raise Event
242: wf_event.AddParameterToList('ROLE_PLAN_ID',p_role_plan_id,l_list);
243: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan_id,l_list);
244: wf_event.AddParameterToList('ROLE_ID',p_role_id,l_list);
245: wf_event.AddParameterToList('SALESREP_ID',p_salesrep_id,l_list);
246: wf_event.AddParameterToList('START_DATE',p_start_date,l_list);
247: wf_event.AddParameterToList('END_DATE',p_end_date,l_list);
248:
249: -- Raise Event
250: wf_event.raise
243: wf_event.AddParameterToList('COMP_PLAN_ID',p_comp_plan_id,l_list);
244: wf_event.AddParameterToList('ROLE_ID',p_role_id,l_list);
245: wf_event.AddParameterToList('SALESREP_ID',p_salesrep_id,l_list);
246: wf_event.AddParameterToList('START_DATE',p_start_date,l_list);
247: wf_event.AddParameterToList('END_DATE',p_end_date,l_list);
248:
249: -- Raise Event
250: wf_event.raise
251: (p_event_name => l_event_name,
246: wf_event.AddParameterToList('START_DATE',p_start_date,l_list);
247: wf_event.AddParameterToList('END_DATE',p_end_date,l_list);
248:
249: -- Raise Event
250: wf_event.raise
251: (p_event_name => l_event_name,
252: p_event_key => l_key,
253: p_parameters => l_list);
254: