DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PVT dependencies on WF_EVENT

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

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);

Line 858: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,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);

Line 859: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,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);

Line 860: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,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

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

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;

Line 862: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,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;
866: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);

Line 863: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,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);

Line 866: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_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);

Line 867: wf_event.AddParameterToList('SALESREP_ID',p_pmt_plan_assign_rec.salesrep_id,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);

Line 868: wf_event.AddParameterToList('PMT_PLAN_ID',p_pmt_plan_assign_rec.pmt_plan_id,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);

Line 869: wf_event.AddParameterToList('START_DATE',p_pmt_plan_assign_rec.start_date,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);

Line 870: wf_event.AddParameterToList('END_DATE',p_pmt_plan_assign_rec.end_date,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

Line 871: wf_event.AddParameterToList('MINIMUM_AMOUNT',p_pmt_plan_assign_rec.minimum_amount,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
875: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,l_list);

Line 872: wf_event.AddParameterToList('MAXIMUM_AMOUNT',p_pmt_plan_assign_rec.maximum_amount,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;

Line 873: wf_event.AddParameterToList('LOCK_FLAG',p_pmt_plan_assign_rec.lock_flag,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;
877:

Line 875: wf_event.AddParameterToList('SRP_PMT_PLAN_ID',p_pmt_plan_assign_rec.srp_pmt_plan_id,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:
878: -- Raise Event
879: wf_event.raise

Line 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: