853: l_key := l_event_name || '-' || p_pmt_plan_assign_rec.srp_pmt_plan_id;
854:
855: -- build parameter list as appropriate
856: IF (p_operation = 'Add') THEN
857: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
858: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
859: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
860: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
861: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
854:
855: -- build parameter list as appropriate
856: IF (p_operation = 'Add') THEN
857: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
858: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
859: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
860: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
861: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
862: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
855: -- build parameter list as appropriate
856: IF (p_operation = 'Add') THEN
857: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
858: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
859: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
860: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
861: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
862: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
863: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
856: IF (p_operation = 'Add') THEN
857: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
858: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
859: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
860: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
861: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
862: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
863: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
864: ELSIF (p_operation = 'Update') THEN
857: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
858: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
859: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
860: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
861: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
862: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
863: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
864: ELSIF (p_operation = 'Update') THEN
865: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
858: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
859: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
860: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
861: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
862: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
863: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
864: ELSIF (p_operation = 'Update') THEN
865: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
866: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
859: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
860: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
861: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
862: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
863: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
864: ELSIF (p_operation = 'Update') THEN
865: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
866: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
867: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
862: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
863: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
864: ELSIF (p_operation = 'Update') THEN
865: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
866: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
867: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
868: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
869: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
870: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
863: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
864: ELSIF (p_operation = 'Update') THEN
865: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
866: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
867: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
868: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
869: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
870: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
871: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
864: ELSIF (p_operation = 'Update') THEN
865: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
866: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
867: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
868: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
869: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
870: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
871: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
872: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
865: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
866: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
867: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
868: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
869: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
870: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
871: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
872: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
873: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
866: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
867: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
868: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
869: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
870: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
871: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
872: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
873: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
874: ELSIF (p_operation = 'Remove') THEN
867: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
868: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
869: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
870: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
871: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
872: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
873: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
874: ELSIF (p_operation = 'Remove') THEN
875: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
868: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
869: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
870: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
871: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
872: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
873: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
874: ELSIF (p_operation = 'Remove') THEN
875: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
876: END IF;
869: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
870: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
871: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
872: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
873: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
874: ELSIF (p_operation = 'Remove') THEN
875: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
876: END IF;
877:
871: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
872: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
873: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
874: ELSIF (p_operation = 'Remove') THEN
875: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
876: END IF;
877:
878: -- Raise Event
879: wf_event.raise
875: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
876: END IF;
877:
878: -- Raise Event
879: wf_event.raise
880: (p_event_name => l_event_name,
881: p_event_key => l_key,
882: p_parameters => l_list);
883: