PACKAGE: APPS.CN_PERIOD_QUOTAS_PKG

Source

1 PACKAGE cn_period_quotas_pkg AS
2 /* $Header: cnprdqos.pls 120.2 2005/07/20 19:08:18 fmburu ship $ */
3 
4    /*
5    Date      Name          Description
6    ----------------------------------------------------------------------------+
7    20-JUL-99 S Kumar       Modified with the new design
8    Name
9 
10    Purpose
11 
12    Notes
13 
14    */
15    PROCEDURE begin_record (
16       x_operation                         VARCHAR2,
17       x_period_quota_id          IN OUT NOCOPY NUMBER,
18       x_period_id                         NUMBER,
19       x_quota_id                          NUMBER,
20       x_period_target                     NUMBER,
21       x_itd_target                        NUMBER,
22       x_period_payment                    NUMBER,
23       x_itd_payment                       NUMBER,
24       x_quarter_num                       NUMBER,
25       x_period_year                       NUMBER,
26       x_creation_date                     DATE,
27       x_last_update_date                  DATE,
28       x_last_update_login                 NUMBER,
29       x_last_updated_by                   NUMBER,
30       x_created_by                        NUMBER,
31       x_period_type_code                  VARCHAR2,
32       x_performance_goal                  NUMBER
33    );
34 
35    PROCEDURE INSERT_RECORD (
36       x_quota_id                          NUMBER
37    );
38 
39    PROCEDURE INSERT_RECORD (
40       x_period_quota_id          IN OUT NOCOPY NUMBER,
41       p_period_id                         NUMBER,
42       p_quota_id                          NUMBER,
43       p_period_target                     NUMBER,
44       p_itd_target                        NUMBER,
45       p_period_payment                    NUMBER,
46       p_itd_payment                       NUMBER,
47       p_quarter_num                       NUMBER,
48       p_period_year                       NUMBER,
49       p_creation_date                     DATE,
50       p_last_update_date                  DATE,
51       p_last_update_login                 NUMBER,
52       p_last_updated_by                   NUMBER,
53       p_created_by                        NUMBER,
54       p_period_type_code                  VARCHAR2,
55       p_performance_goal                  NUMBER
56    );
57 
58    PROCEDURE UPDATE_RECORD (
59       p_period_quota_id                   NUMBER,
60       p_quota_id                          NUMBER,
61       p_period_id                         NUMBER,
62       p_period_target                     NUMBER,
63       p_period_payment                    NUMBER,
64       p_performance_goal                  NUMBER,
65       p_last_update_date                  DATE,
66       p_last_update_login                 NUMBER,
67       p_last_updated_by                   NUMBER,
68       x_itd_target            OUT NOCOPY  NUMBER,
69       x_itd_payment_amount    OUT NOCOPY  NUMBER,
70       x_itd_performance_amount OUT NOCOPY  NUMBER,
71       x_object_version_number OUT NOCOPY  NUMBER
72    );
73 
74    PROCEDURE DELETE_RECORD (
75       x_quota_id                          NUMBER
76    );
77 
78    PROCEDURE distribute_target (
79       x_quota_id                          NUMBER
80    );
81 
82    PROCEDURE sync_itd_values (
83       x_quota_id                          NUMBER
84    );
85 
86    PROCEDURE populate_itd_values (
87       x_start_period_quota_id             NUMBER,
88       x_quota_id                          NUMBER
89    );
90 
91    FUNCTION previous_period (
92       p_start_date                        DATE,
93       p_org_id                            NUMBER
94    )
95       RETURN cn_acc_period_statuses_v.start_date%TYPE;
96 END cn_period_quotas_pkg;