DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_SRP_PMT_PLANS

Line 1: PACKAGE CN_SRP_PMT_PLANS_PVT AUTHID CURRENT_USER AS

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,

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

Line 6: salesrep_id cn_srp_pmt_plans.salesrep_id%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,

Line 7: org_id cn_srp_pmt_plans.org_id%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,

Line 8: pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%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,

Line 9: start_date cn_srp_pmt_plans.start_date%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,

Line 10: end_date cn_srp_pmt_plans.end_date%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,

Line 11: minimum_amount cn_srp_pmt_plans.minimum_amount%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,

Line 12: maximum_amount cn_srp_pmt_plans.maximum_amount%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);

Line 13: srp_role_id cn_srp_pmt_plans.srp_role_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);
17:

Line 14: role_pmt_plan_id cn_srp_pmt_plans.role_pmt_plan_id%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:
18: TYPE payrun_tbl IS TABLE OF cn_payruns.name%TYPE;

Line 15: lock_flag cn_srp_pmt_plans.lock_flag%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:

Line 16: object_version_number cn_srp_pmt_plans.object_version_number%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:
20: -- --------------------------------------------------------------------------*

Line 195: END cn_srp_pmt_plans_pvt;

191: p_role_pmt_plan_id IN NUMBER,
192: x_loading_status OUT NOCOPY VARCHAR2
193: );
194:
195: END cn_srp_pmt_plans_pvt;