DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PUB dependencies on CN_PMT_PLANS

Line 27: x_pp_start_date OUT NOCOPY cn_pmt_plans.start_date%TYPE,

23: p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type,
24: x_srp_pmt_plans_row IN OUT NOCOPY cn_srp_pmt_plans%ROWTYPE ,
25: x_srp_start_date OUT NOCOPY cn_salesreps.start_date_active%TYPE,
26: x_srp_end_date OUT NOCOPY cn_salesreps.end_date_active%TYPE,
27: x_pp_start_date OUT NOCOPY cn_pmt_plans.start_date%TYPE,
28: x_pp_end_date OUT NOCOPY cn_pmt_plans.end_date%TYPE,
29: p_action IN VARCHAR2 := 'VALIDATE',
30: p_loading_status IN VARCHAR2,
31: x_loading_status OUT NOCOPY VARCHAR2

Line 28: x_pp_end_date OUT NOCOPY cn_pmt_plans.end_date%TYPE,

24: x_srp_pmt_plans_row IN OUT NOCOPY cn_srp_pmt_plans%ROWTYPE ,
25: x_srp_start_date OUT NOCOPY cn_salesreps.start_date_active%TYPE,
26: x_srp_end_date OUT NOCOPY cn_salesreps.end_date_active%TYPE,
27: x_pp_start_date OUT NOCOPY cn_pmt_plans.start_date%TYPE,
28: x_pp_end_date OUT NOCOPY cn_pmt_plans.end_date%TYPE,
29: p_action IN VARCHAR2 := 'VALIDATE',
30: p_loading_status IN VARCHAR2,
31: x_loading_status OUT NOCOPY VARCHAR2
32: )

Line 62: FROM cn_pmt_plans_all

58: start_date, end_date
59: INTO x_srp_pmt_plans_row.pmt_plan_id,
60: x_srp_pmt_plans_row.credit_type_id,
61: x_pp_start_date,x_pp_end_date
62: FROM cn_pmt_plans_all
63: WHERE name = p_srp_pmt_plans_rec.pmt_plan_name
64: AND org_id = p_srp_pmt_plans_rec.org_id;
65: EXCEPTION
66: WHEN NO_DATA_FOUND THEN

Line 160: l_pp_start_date cn_pmt_plans.start_date%TYPE;

156: l_dummy NUMBER;
157: l_dummy2 NUMBER;
158: l_srp_start_date cn_salesreps.start_date_active%TYPE;
159: l_srp_end_date cn_salesreps.end_date_active%TYPE;
160: l_pp_start_date cn_pmt_plans.start_date%TYPE;
161: l_pp_end_date cn_pmt_plans.end_date%TYPE;
162: l_pp_min cn_pmt_plans.minimum_amount%TYPE;
163: l_pp_max cn_pmt_plans.maximum_amount%TYPE;
164: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;

Line 161: l_pp_end_date cn_pmt_plans.end_date%TYPE;

157: l_dummy2 NUMBER;
158: l_srp_start_date cn_salesreps.start_date_active%TYPE;
159: l_srp_end_date cn_salesreps.end_date_active%TYPE;
160: l_pp_start_date cn_pmt_plans.start_date%TYPE;
161: l_pp_end_date cn_pmt_plans.end_date%TYPE;
162: l_pp_min cn_pmt_plans.minimum_amount%TYPE;
163: l_pp_max cn_pmt_plans.maximum_amount%TYPE;
164: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
165:

Line 162: l_pp_min cn_pmt_plans.minimum_amount%TYPE;

158: l_srp_start_date cn_salesreps.start_date_active%TYPE;
159: l_srp_end_date cn_salesreps.end_date_active%TYPE;
160: l_pp_start_date cn_pmt_plans.start_date%TYPE;
161: l_pp_end_date cn_pmt_plans.end_date%TYPE;
162: l_pp_min cn_pmt_plans.minimum_amount%TYPE;
163: l_pp_max cn_pmt_plans.maximum_amount%TYPE;
164: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
165:
166: -- Cursor to get the quota id and credit type id list from

Line 163: l_pp_max cn_pmt_plans.maximum_amount%TYPE;

159: l_srp_end_date cn_salesreps.end_date_active%TYPE;
160: l_pp_start_date cn_pmt_plans.start_date%TYPE;
161: l_pp_end_date cn_pmt_plans.end_date%TYPE;
162: l_pp_min cn_pmt_plans.minimum_amount%TYPE;
163: l_pp_max cn_pmt_plans.maximum_amount%TYPE;
164: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
165:
166: -- Cursor to get the quota id and credit type id list from
167: -- cn_srp_plan_assigns which falls into

Line 164: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;

160: l_pp_start_date cn_pmt_plans.start_date%TYPE;
161: l_pp_end_date cn_pmt_plans.end_date%TYPE;
162: l_pp_min cn_pmt_plans.minimum_amount%TYPE;
163: l_pp_max cn_pmt_plans.maximum_amount%TYPE;
164: l_payment_group_code cn_pmt_plans.payment_group_code%TYPE;
165:
166: -- Cursor to get the quota id and credit type id list from
167: -- cn_srp_plan_assigns which falls into
168: -- the date range for credit_type_id check.

Line 231: FROM cn_pmt_plans

227:
228: -- Get correct min/max amount if it's null
229: SELECT minimum_amount, maximum_amount
230: INTO l_pp_min, l_pp_max
231: FROM cn_pmt_plans
232: WHERE pmt_plan_id = x_srp_pmt_plans_row.pmt_plan_id;
233:
234: SELECT
235: Decode(p_srp_pmt_plans_rec.minimum_amount,FND_API.G_MISS_NUM,l_pp_min,

Line 654: l_pp_start_date cn_pmt_plans.start_date%TYPE;

650: l_start_date cn_srp_pmt_plans.start_date%TYPE;
651: l_end_date cn_srp_pmt_plans.end_date%TYPE;
652: l_srp_start_date cn_salesreps.start_date_active%TYPE;
653: l_srp_end_date cn_salesreps.end_date_active%TYPE;
654: l_pp_start_date cn_pmt_plans.start_date%TYPE;
655: l_pp_end_date cn_pmt_plans.end_date%TYPE;
656: l_action VARCHAR2(30) := 'UPDATE';
657: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
658: l_update_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;

Line 655: l_pp_end_date cn_pmt_plans.end_date%TYPE;

651: l_end_date cn_srp_pmt_plans.end_date%TYPE;
652: l_srp_start_date cn_salesreps.start_date_active%TYPE;
653: l_srp_end_date cn_salesreps.end_date_active%TYPE;
654: l_pp_start_date cn_pmt_plans.start_date%TYPE;
655: l_pp_end_date cn_pmt_plans.end_date%TYPE;
656: l_action VARCHAR2(30) := 'UPDATE';
657: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
658: l_update_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
659:

Line 1078: l_pp_start_date cn_pmt_plans.start_date%TYPE;

1074: l_spp_row cn_srp_pmt_plans%ROWTYPE;
1075:
1076: l_srp_start_date cn_salesreps.start_date_active%TYPE;
1077: l_srp_end_date cn_salesreps.end_date_active%TYPE;
1078: l_pp_start_date cn_pmt_plans.start_date%TYPE;
1079: l_pp_end_date cn_pmt_plans.end_date%TYPE;
1080:
1081: l_org_id NUMBER;
1082: l_status VARCHAR2(1);

Line 1079: l_pp_end_date cn_pmt_plans.end_date%TYPE;

1075:
1076: l_srp_start_date cn_salesreps.start_date_active%TYPE;
1077: l_srp_end_date cn_salesreps.end_date_active%TYPE;
1078: l_pp_start_date cn_pmt_plans.start_date%TYPE;
1079: l_pp_end_date cn_pmt_plans.end_date%TYPE;
1080:
1081: l_org_id NUMBER;
1082: l_status VARCHAR2(1);
1083: