DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PVT dependencies on WF_EVENT

Line 856: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);

852: l_key := l_event_name || '-' || p_pmt_plan_assign_rec.srp_pmt_plan_id;
853:
854: -- build parameter list as appropriate
855: IF (p_operation = 'Add') THEN
856: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
857: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
858: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
859: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
860: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);

Line 857: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);

853:
854: -- build parameter list as appropriate
855: IF (p_operation = 'Add') THEN
856: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
857: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
858: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
859: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
860: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
861: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);

Line 858: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);

854: -- build parameter list as appropriate
855: IF (p_operation = 'Add') THEN
856: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
857: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
858: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
859: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
860: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
861: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
862: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);

Line 859: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);

855: IF (p_operation = 'Add') THEN
856: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
857: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
858: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
859: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
860: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
861: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
862: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
863: ELSIF (p_operation = 'Update') THEN

Line 860: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);

856: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
857: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
858: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
859: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
860: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
861: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
862: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
863: ELSIF (p_operation = 'Update') THEN
864: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;

Line 861: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);

857: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
858: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
859: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
860: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
861: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
862: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
863: ELSIF (p_operation = 'Update') THEN
864: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
865: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);

Line 862: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);

858: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
859: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
860: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
861: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
862: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
863: ELSIF (p_operation = 'Update') THEN
864: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
865: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
866: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);

Line 865: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);

861: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
862: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
863: ELSIF (p_operation = 'Update') THEN
864: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
865: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
866: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
867: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
868: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
869: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);

Line 866: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);

862: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
863: ELSIF (p_operation = 'Update') THEN
864: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
865: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
866: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
867: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
868: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
869: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
870: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);

Line 867: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);

863: ELSIF (p_operation = 'Update') THEN
864: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
865: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
866: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
867: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
868: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
869: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
870: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
871: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);

Line 868: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);

864: l_key := l_key || '-' || p_pmt_plan_assign_rec.object_version_number;
865: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
866: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
867: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
868: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
869: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
870: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
871: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
872: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);

Line 869: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);

865: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
866: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
867: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
868: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
869: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
870: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
871: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
872: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
873: ELSIF (p_operation = 'Remove') THEN

Line 870: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);

866: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,l_list);
867: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
868: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
869: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
870: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
871: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
872: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
873: ELSIF (p_operation = 'Remove') THEN
874: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);

Line 871: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);

867: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,l_list);
868: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
869: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
870: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
871: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
872: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
873: ELSIF (p_operation = 'Remove') THEN
874: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
875: END IF;

Line 872: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);

868: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,l_list);
869: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,l_list);
870: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
871: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
872: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
873: ELSIF (p_operation = 'Remove') THEN
874: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
875: END IF;
876:

Line 874: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);

870: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,l_list);
871: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,l_list);
872: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,l_list);
873: ELSIF (p_operation = 'Remove') THEN
874: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
875: END IF;
876:
877: -- Raise Event
878: wf_event.raise

Line 878: wf_event.raise

874: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);
875: END IF;
876:
877: -- Raise Event
878: wf_event.raise
879: (p_event_name => l_event_name,
880: p_event_key => l_key,
881: p_parameters => l_list);
882: