446: l_key := l_event_name || '-' || p_paygroup_assign_rec.srp_pay_group_id;
447:
448: -- build parameter list as appropriate
449: IF (p_operation = 'Add') THEN
450: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
451: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
452: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
453: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
454: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
447:
448: -- build parameter list as appropriate
449: IF (p_operation = 'Add') THEN
450: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
451: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
452: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
453: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
454: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
455: ELSIF (p_operation = 'Update') THEN
448: -- build parameter list as appropriate
449: IF (p_operation = 'Add') THEN
450: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
451: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
452: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
453: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
454: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
455: ELSIF (p_operation = 'Update') THEN
456: l_key := l_key || '-' || p_paygroup_assign_rec.object_version_number;
449: IF (p_operation = 'Add') THEN
450: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
451: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
452: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
453: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
454: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
455: ELSIF (p_operation = 'Update') THEN
456: l_key := l_key || '-' || p_paygroup_assign_rec.object_version_number;
457: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
450: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
451: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
452: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
453: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
454: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
455: ELSIF (p_operation = 'Update') THEN
456: l_key := l_key || '-' || p_paygroup_assign_rec.object_version_number;
457: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
458: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
453: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
454: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
455: ELSIF (p_operation = 'Update') THEN
456: l_key := l_key || '-' || p_paygroup_assign_rec.object_version_number;
457: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
458: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
459: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
460: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
461: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
454: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
455: ELSIF (p_operation = 'Update') THEN
456: l_key := l_key || '-' || p_paygroup_assign_rec.object_version_number;
457: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
458: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
459: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
460: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
461: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
462: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
455: ELSIF (p_operation = 'Update') THEN
456: l_key := l_key || '-' || p_paygroup_assign_rec.object_version_number;
457: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
458: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
459: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
460: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
461: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
462: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
463: ELSIF (p_operation = 'Remove') THEN
456: l_key := l_key || '-' || p_paygroup_assign_rec.object_version_number;
457: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
458: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
459: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
460: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
461: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
462: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
463: ELSIF (p_operation = 'Remove') THEN
464: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
457: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
458: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
459: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
460: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
461: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
462: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
463: ELSIF (p_operation = 'Remove') THEN
464: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
465: END IF;
458: wf_event.AddParameterToList('SALESREP_ID',p_paygroup_assign_rec.salesrep_id,l_list);
459: wf_event.AddParameterToList('PAY_GROUP_ID',p_paygroup_assign_rec.pay_group_id,l_list);
460: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
461: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
462: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
463: ELSIF (p_operation = 'Remove') THEN
464: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
465: END IF;
466:
460: wf_event.AddParameterToList('START_DATE',p_paygroup_assign_rec.assignment_start_date,l_list);
461: wf_event.AddParameterToList('END_DATE',p_paygroup_assign_rec.assignment_end_date,l_list);
462: wf_event.AddParameterToList('LOCK_FLAG',p_paygroup_assign_rec.lock_flag,l_list);
463: ELSIF (p_operation = 'Remove') THEN
464: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
465: END IF;
466:
467: -- Raise Event
468: wf_event.raise
464: wf_event.AddParameterToList('SRP_PAY_GROUP_ID',p_paygroup_assign_rec.srp_pay_group_id,l_list);
465: END IF;
466:
467: -- Raise Event
468: wf_event.raise
469: (p_event_name => l_event_name,
470: p_event_key => l_key,
471: p_parameters => l_list);
472: