1: PACKAGE CN_SRP_PMT_PLANS_PVT AUTHID CURRENT_USER AS
2: /* $Header: cnvsppas.pls 120.4 2005/07/25 04:32:29 raramasa noship $ */
3:
4: TYPE pmt_plan_assign_rec IS RECORD
5: (srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE,
1: PACKAGE CN_SRP_PMT_PLANS_PVT AUTHID CURRENT_USER AS
2: /* $Header: cnvsppas.pls 120.4 2005/07/25 04:32:29 raramasa noship $ */
3:
4: TYPE pmt_plan_assign_rec IS RECORD
5: (srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE,
6: salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE,
7: org_id cn_srp_pmt_plans.org_id%TYPE,
8: pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE,
9: start_date cn_srp_pmt_plans.start_date%TYPE,
2: /* $Header: cnvsppas.pls 120.4 2005/07/25 04:32:29 raramasa noship $ */
3:
4: TYPE pmt_plan_assign_rec IS RECORD
5: (srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE,
6: salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE,
7: org_id cn_srp_pmt_plans.org_id%TYPE,
8: pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE,
9: start_date cn_srp_pmt_plans.start_date%TYPE,
10: end_date cn_srp_pmt_plans.end_date%TYPE,
3:
4: TYPE pmt_plan_assign_rec IS RECORD
5: (srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE,
6: salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE,
7: org_id cn_srp_pmt_plans.org_id%TYPE,
8: pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE,
9: start_date cn_srp_pmt_plans.start_date%TYPE,
10: end_date cn_srp_pmt_plans.end_date%TYPE,
11: minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
4: TYPE pmt_plan_assign_rec IS RECORD
5: (srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE,
6: salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE,
7: org_id cn_srp_pmt_plans.org_id%TYPE,
8: pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE,
9: start_date cn_srp_pmt_plans.start_date%TYPE,
10: end_date cn_srp_pmt_plans.end_date%TYPE,
11: minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
12: maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
5: (srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE,
6: salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE,
7: org_id cn_srp_pmt_plans.org_id%TYPE,
8: pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE,
9: start_date cn_srp_pmt_plans.start_date%TYPE,
10: end_date cn_srp_pmt_plans.end_date%TYPE,
11: minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
12: maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
13: srp_role_id cn_srp_pmt_plans.srp_role_id%TYPE,
6: salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE,
7: org_id cn_srp_pmt_plans.org_id%TYPE,
8: pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE,
9: start_date cn_srp_pmt_plans.start_date%TYPE,
10: end_date cn_srp_pmt_plans.end_date%TYPE,
11: minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
12: maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
13: srp_role_id cn_srp_pmt_plans.srp_role_id%TYPE,
14: role_pmt_plan_id cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
7: org_id cn_srp_pmt_plans.org_id%TYPE,
8: pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE,
9: start_date cn_srp_pmt_plans.start_date%TYPE,
10: end_date cn_srp_pmt_plans.end_date%TYPE,
11: minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
12: maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
13: srp_role_id cn_srp_pmt_plans.srp_role_id%TYPE,
14: role_pmt_plan_id cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
15: lock_flag cn_srp_pmt_plans.lock_flag%TYPE,
8: pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE,
9: start_date cn_srp_pmt_plans.start_date%TYPE,
10: end_date cn_srp_pmt_plans.end_date%TYPE,
11: minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
12: maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
13: srp_role_id cn_srp_pmt_plans.srp_role_id%TYPE,
14: role_pmt_plan_id cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
15: lock_flag cn_srp_pmt_plans.lock_flag%TYPE,
16: object_version_number cn_srp_pmt_plans.object_version_number%TYPE);
9: start_date cn_srp_pmt_plans.start_date%TYPE,
10: end_date cn_srp_pmt_plans.end_date%TYPE,
11: minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
12: maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
13: srp_role_id cn_srp_pmt_plans.srp_role_id%TYPE,
14: role_pmt_plan_id cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
15: lock_flag cn_srp_pmt_plans.lock_flag%TYPE,
16: object_version_number cn_srp_pmt_plans.object_version_number%TYPE);
17:
10: end_date cn_srp_pmt_plans.end_date%TYPE,
11: minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
12: maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
13: srp_role_id cn_srp_pmt_plans.srp_role_id%TYPE,
14: role_pmt_plan_id cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
15: lock_flag cn_srp_pmt_plans.lock_flag%TYPE,
16: object_version_number cn_srp_pmt_plans.object_version_number%TYPE);
17:
18: TYPE payrun_tbl IS TABLE OF cn_payruns.name%TYPE;
11: minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
12: maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
13: srp_role_id cn_srp_pmt_plans.srp_role_id%TYPE,
14: role_pmt_plan_id cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
15: lock_flag cn_srp_pmt_plans.lock_flag%TYPE,
16: object_version_number cn_srp_pmt_plans.object_version_number%TYPE);
17:
18: TYPE payrun_tbl IS TABLE OF cn_payruns.name%TYPE;
19:
12: maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
13: srp_role_id cn_srp_pmt_plans.srp_role_id%TYPE,
14: role_pmt_plan_id cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
15: lock_flag cn_srp_pmt_plans.lock_flag%TYPE,
16: object_version_number cn_srp_pmt_plans.object_version_number%TYPE);
17:
18: TYPE payrun_tbl IS TABLE OF cn_payruns.name%TYPE;
19:
20: -- --------------------------------------------------------------------------*
191: p_role_pmt_plan_id IN NUMBER,
192: x_loading_status OUT NOCOPY VARCHAR2
193: );
194:
195: END cn_srp_pmt_plans_pvt;