APPS.CN_SRP_PMT_PLANS_PUB dependencies on CN_SRP_PMT_PLANS

Line 1: PACKAGE CN_SRP_PMT_PLANS_PUB AUTHID CURRENT_USER AS

1: PACKAGE CN_SRP_PMT_PLANS_PUB AUTHID CURRENT_USER AS
2: /* $Header: cnpsppas.pls 120.2 2005/10/27 16:03:20 mblum noship $ */
3: /*#
4: * This procedure is used to create, update, and delete payment plan assignments for salesreps individually or in mass.
5: * @rep:scope public

Line 19: START_DATE cn_srp_pmt_plans.start_date%TYPE

15: TYPE srp_pmt_plans_rec_type IS RECORD
16: (PMT_PLAN_NAME cn_pmt_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,
18: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
19: START_DATE cn_srp_pmt_plans.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_srp_pmt_plans.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE

Line 21: END_DATE cn_srp_pmt_plans.end_date%TYPE

17: SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,
18: EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
19: START_DATE cn_srp_pmt_plans.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_srp_pmt_plans.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
24: := CN_API.G_MISS_NUM,
25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE

Line 23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE

19: START_DATE cn_srp_pmt_plans.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_srp_pmt_plans.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
24: := CN_API.G_MISS_NUM,
25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
26: := CN_API.G_MISS_NUM,
27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,

Line 25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE

21: END_DATE cn_srp_pmt_plans.end_date%TYPE
22: := CN_API.G_MISS_DATE,
23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
24: := CN_API.G_MISS_NUM,
25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
26: := CN_API.G_MISS_NUM,
27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,
28: OBJECT_VERSION_NUMBER cn_srp_pmt_plans.object_version_number%TYPE,
29: SRP_ROLE_ID cn_srp_pmt_plans.srp_role_id%TYPE,

Line 27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,

23: MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
24: := CN_API.G_MISS_NUM,
25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
26: := CN_API.G_MISS_NUM,
27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,
28: OBJECT_VERSION_NUMBER cn_srp_pmt_plans.object_version_number%TYPE,
29: SRP_ROLE_ID cn_srp_pmt_plans.srp_role_id%TYPE,
30: ROLE_PMT_PLAN_ID cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
31: LOCK_FLAG cn_srp_pmt_plans.lock_flag%TYPE);

Line 28: OBJECT_VERSION_NUMBER cn_srp_pmt_plans.object_version_number%TYPE,

24: := CN_API.G_MISS_NUM,
25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
26: := CN_API.G_MISS_NUM,
27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,
28: OBJECT_VERSION_NUMBER cn_srp_pmt_plans.object_version_number%TYPE,
29: SRP_ROLE_ID cn_srp_pmt_plans.srp_role_id%TYPE,
30: ROLE_PMT_PLAN_ID cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
31: LOCK_FLAG cn_srp_pmt_plans.lock_flag%TYPE);
32:

Line 29: SRP_ROLE_ID cn_srp_pmt_plans.srp_role_id%TYPE,

25: MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
26: := CN_API.G_MISS_NUM,
27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,
28: OBJECT_VERSION_NUMBER cn_srp_pmt_plans.object_version_number%TYPE,
29: SRP_ROLE_ID cn_srp_pmt_plans.srp_role_id%TYPE,
30: ROLE_PMT_PLAN_ID cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
31: LOCK_FLAG cn_srp_pmt_plans.lock_flag%TYPE);
32:
33: g_miss_srp_pmt_plans_rec srp_pmt_plans_rec_type;

Line 30: ROLE_PMT_PLAN_ID cn_srp_pmt_plans.role_pmt_plan_id%TYPE,

26: := CN_API.G_MISS_NUM,
27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,
28: OBJECT_VERSION_NUMBER cn_srp_pmt_plans.object_version_number%TYPE,
29: SRP_ROLE_ID cn_srp_pmt_plans.srp_role_id%TYPE,
30: ROLE_PMT_PLAN_ID cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
31: LOCK_FLAG cn_srp_pmt_plans.lock_flag%TYPE);
32:
33: g_miss_srp_pmt_plans_rec srp_pmt_plans_rec_type;
34:

Line 31: LOCK_FLAG cn_srp_pmt_plans.lock_flag%TYPE);

27: ORG_ID cn_srp_pmt_plans.org_id%TYPE := NULL,
28: OBJECT_VERSION_NUMBER cn_srp_pmt_plans.object_version_number%TYPE,
29: SRP_ROLE_ID cn_srp_pmt_plans.srp_role_id%TYPE,
30: ROLE_PMT_PLAN_ID cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
31: LOCK_FLAG cn_srp_pmt_plans.lock_flag%TYPE);
32:
33: g_miss_srp_pmt_plans_rec srp_pmt_plans_rec_type;
34:
35: TYPE srp_pmt_plans_tbl_type IS TABLE OF srp_pmt_plans_rec_type

Line 289: END CN_SRP_PMT_PLANS_PUB ;

285: p_role_pmt_plan_id IN NUMBER,
286: x_loading_status OUT NOCOPY VARCHAR2
287: );
288:
289: END CN_SRP_PMT_PLANS_PUB ;
290: