1 PACKAGE CN_SRP_PRD_QUOTA_PUB AS
2 /*$Header: cnvspdbs.pls 120.2 2005/10/27 16:05:19 mblum noship $*/
3 /*#
4 * This procedure distributes the target for a plan element across the periods
5 * for which the plan element has been defined for a given salesperson.
6 * @rep:scope public
7 * @rep:product CN
8 * @rep:displayname Salesperson Period Quotas Distribution
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
12 */
13
14 -- period quota
15 TYPE srp_prd_quota_rec_type IS RECORD
16 (
17 PERIOD_NAME CN_PERIOD_STATUSES.PERIOD_NAME%TYPE := FND_API.G_MISS_CHAR,
18 PERIOD_TARGET NUMBER := FND_API.G_MISS_NUM,
19 PERIOD_PAYMENT NUMBER := FND_API.G_MISS_NUM,
20 PERFORMANCE_GOAL NUMBER := FND_API.G_MISS_NUM
21 );
22
23
24 TYPE srp_prd_quota_tbl_type IS
25 TABLE OF srp_prd_quota_rec_type INDEX BY BINARY_INTEGER ;
26
27 /*#
28 * This procedure distributes the target for a plan element across the periods
29 * for which the plan element has been defined for a given salesperson.
30 * @param p_api_version API Version
31 * @param p_init_msg_list Initialize Message List
32 * @param p_commit Commit after update
33 * @param p_validation_level Validation Level
34 * @param x_return_status Status of the update operation
35 * @param x_msg_count Number of error messages returned
36 * @param x_msg_data Error messages
37 * @param p_salesrep_name The salesperson for whom the target is to be distributed
38 * @param p_employee_number The employee number of the salesperson
39 * @param p_role_name The role to which the salesperson is assigned during the periods for which the user is distributing the targets
40 * @param p_cp_name The compensation plan that is assigned to the salesperson and which contains the plan element for which the user would like to distribute target
41 * @param p_srp_plan_start_date The start date of the compensation plan assignment to the salesrep
42 * @param p_srp_plan_end_date The end date of the compensation plan assignment to the salesrep
43 * @param p_pe_name The plan element for which the target has to be distributed
44 * @param p_target_amount The target amount that has to be distributed across the periods
45 * @param p_fixed_amount The fixed amount that has to be distributed for the periods
46 * @param p_performance_goal The performance goal that has to be distributed for the periods
47 * @param p_even_distribute The configuration parameter used to choose between even distribution and user configurable distribution. Y = even, N = user configurable
48 * @param p_srp_prd_quota_tbl Record of type prd_quota_tbl_type to store the user configured distribution if p_even_distribute is set to N
49 * @param p_org_id Organization ID
50 * @rep:scope public
51 * @rep:lifecycle active
52 * @rep:displayname Salesperson Period Quotas Distribution
53 */
54
55 PROCEDURE Distribute_Srp_Prd_Quota
56 ( p_api_version IN NUMBER := CN_API.G_MISS_NUM,
57 p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
58 p_commit IN VARCHAR2 := CN_API.G_FALSE,
59 p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
60 p_salesrep_name IN CN_SALESREPS.NAME%TYPE,
61 p_employee_number IN CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
62 p_role_name IN CN_ROLES.NAME%TYPE,
63 p_cp_name IN CN_COMP_PLANS.NAME%TYPE,
64 p_srp_plan_start_date IN CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,
65 p_srp_plan_end_date IN CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE,
66 p_pe_name IN CN_QUOTAS.NAME%TYPE,
67 p_target_amount IN CN_SRP_QUOTA_ASSIGNS.target%TYPE,
68 p_fixed_amount IN CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE,
69 p_performance_goal IN CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE,
70 p_even_distribute IN VARCHAR2,
71 p_srp_prd_quota_tbl IN srp_prd_quota_tbl_type,
72 p_org_id IN NUMBER := NULL,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2
76
77 );
78
79
80
81
82 END CN_SRP_PRD_QUOTA_PUB;