[Home] [Help]
PACKAGE: APPS.CN_QUOTAS_PKG
Source
1 PACKAGE cn_quotas_pkg AS
2 /* $Header: cnpliqos.pls 120.1.12000000.3 2007/10/09 20:17:54 rnagired ship $ */
3 --
4 --+
5 -- Purpose
6 --+
7 -- Notes
8 -- Called for Insert/Update/delete
9 --+
10 PROCEDURE begin_record (
11 x_operation VARCHAR2,
12 x_rowid IN OUT NOCOPY VARCHAR2,
13 x_quota_id IN OUT NOCOPY NUMBER,
14 x_object_version_number OUT NOCOPY NUMBER,
15 x_name VARCHAR2,
16 x_target NUMBER,
17 x_quota_type_code VARCHAR2,
18 x_period_type_code VARCHAR2,
19 x_usage_code VARCHAR2,
20 x_payment_amount NUMBER,
21 x_description VARCHAR2,
22 x_start_date DATE,
23 x_end_date DATE,
24 x_quota_status VARCHAR2,
25 x_start_num NUMBER,
26 x_end_num NUMBER,
27 x_program_type VARCHAR2,
28 --x_status_code varchar2 ,
29 x_last_update_date DATE,
30 x_last_updated_by NUMBER,
31 x_creation_date DATE,
32 x_created_by NUMBER,
33 x_last_update_login NUMBER,
34 x_incentive_type_code VARCHAR2,
35 x_credit_type_id NUMBER,
36 x_calc_formula_id NUMBER,
37 x_rt_sched_custom_flag VARCHAR2,
38 x_package_name VARCHAR2,
39 x_performance_goal NUMBER,
40 x_interval_type_id NUMBER,
41 x_payee_assign_flag VARCHAR2,
42 x_vesting_flag VARCHAR2,
43 x_quota_unspecified NUMBER,
44 x_addup_from_rev_class_flag VARCHAR2,
45 x_expense_account_id NUMBER,
46 x_liability_account_id NUMBER,
47 x_quota_group_code VARCHAR2,
48 --clku payment enhancement
49 x_payment_group_code VARCHAR2 := 'STANDARD',
50 --clku, bug 2854576
51 x_attribute_category VARCHAR2 := NULL,
52 x_attribute1 VARCHAR2,
53 x_attribute2 VARCHAR2,
54 x_attribute3 VARCHAR2,
55 x_attribute4 VARCHAR2,
56 x_attribute5 VARCHAR2,
57 x_attribute6 VARCHAR2,
58 x_attribute7 VARCHAR2,
59 x_attribute8 VARCHAR2,
60 x_attribute9 VARCHAR2,
61 x_attribute10 VARCHAR2,
62 x_attribute11 VARCHAR2,
63 x_attribute12 VARCHAR2,
64 x_attribute13 VARCHAR2,
65 x_attribute14 VARCHAR2,
66 x_attribute15 VARCHAR2,
67 -- fmburu r12
68 x_indirect_credit VARCHAR2,
69 x_org_id NUMBER,
70 x_salesrep_end_flag VARCHAR2
71 );
72
73 -- temp use
74 PROCEDURE UPDATE_RECORD (
75 x_quota_id NUMBER,
76 x_start_date DATE,
77 x_end_date DATE
78 );
79
80 -- Must be public as called by cn_comp_plans_pkg
81 PROCEDURE DELETE_RECORD (
82 x_quota_id NUMBER,
83 x_name VARCHAR2
84 );
85
86
87 END cn_quotas_pkg;