[Home] [Help]
PACKAGE: APPS.CN_WKSHT_CT_UP_PUB
Source
1 PACKAGE CN_WKSHT_CT_UP_PUB AUTHID CURRENT_USER as
2 -- $Header: cnvwkcds.pls 115.6 2002/11/21 21:20:12 hlchen ship $
3 --============================================================================
4 TYPE srp_pmt_plans_rec_type IS RECORD
5 (PMT_PLAN_NAME cn_pmt_plans.name%TYPE := CN_API.G_MISS_CHAR,
6 SALESREP_TYPE VARCHAR2(100) := CN_API.G_MISS_CHAR,
7 EMP_NUM VARCHAR2(30) := CN_API.G_MISS_CHAR,
8 START_DATE cn_srp_pmt_plans.start_date%TYPE
9 := CN_API.G_MISS_DATE,
10 END_DATE cn_srp_pmt_plans.end_date%TYPE
11 := CN_API.G_MISS_DATE,
12 MINIMUM_AMOUNT cn_srp_pmt_plans.minimum_amount%TYPE
13 := CN_API.G_MISS_NUM,
14 MAXIMUM_AMOUNT cn_srp_pmt_plans.maximum_amount%TYPE
15 := CN_API.G_MISS_NUM,
16 MAX_RECOVERY_AMOUNT cn_srp_pmt_plans.max_recovery_amount%TYPE
17 := CN_API.G_MISS_NUM,
18 ATTRIBUTE_CATEGORY cn_srp_pmt_plans.attribute_category%TYPE
19 := CN_API.G_MISS_CHAR,
20 ATTRIBUTE1 cn_srp_pmt_plans.attribute1%TYPE
21 := CN_API.G_MISS_CHAR,
22 ATTRIBUTE2 cn_srp_pmt_plans.attribute2%TYPE
23 := CN_API.G_MISS_CHAR,
24 ATTRIBUTE3 cn_srp_pmt_plans.attribute3%TYPE
25 := CN_API.G_MISS_CHAR,
26 ATTRIBUTE4 cn_srp_pmt_plans.attribute4%TYPE
27 := CN_API.G_MISS_CHAR,
28 ATTRIBUTE5 cn_srp_pmt_plans.attribute5%TYPE
29 := CN_API.G_MISS_CHAR,
30 ATTRIBUTE6 cn_srp_pmt_plans.attribute6%TYPE
31 := CN_API.G_MISS_CHAR,
32 ATTRIBUTE7 cn_srp_pmt_plans.attribute7%TYPE
33 := CN_API.G_MISS_CHAR,
34 ATTRIBUTE8 cn_srp_pmt_plans.attribute8%TYPE
35 := CN_API.G_MISS_CHAR,
36 ATTRIBUTE9 cn_srp_pmt_plans.attribute9%TYPE
37 := CN_API.G_MISS_CHAR,
38 ATTRIBUTE10 cn_srp_pmt_plans.attribute10%TYPE
39 := CN_API.G_MISS_CHAR,
40 ATTRIBUTE11 cn_srp_pmt_plans.attribute11%TYPE
41 := CN_API.G_MISS_CHAR,
42 ATTRIBUTE12 cn_srp_pmt_plans.attribute12%TYPE
43 := CN_API.G_MISS_CHAR,
44 ATTRIBUTE13 cn_srp_pmt_plans.attribute13%TYPE
45 := CN_API.G_MISS_CHAR,
46 ATTRIBUTE14 cn_srp_pmt_plans.attribute14%TYPE
47 := CN_API.G_MISS_CHAR,
48 ATTRIBUTE15 cn_srp_pmt_plans.attribute15%TYPE
49 := CN_API.G_MISS_CHAR
50 );
51
52 G_MISS_SRP_PMT_PLANS_REC srp_pmt_plans_rec_type;
53
54 Procedure Create_delete_Wrkhst
55 ( p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2,
57 p_commit IN VARCHAR2,
58 p_validation_level IN NUMBER,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_salesrep_id IN NUMBER,
63 p_srp_pmt_asgn_id IN NUMBER,
64 p_payrun_id IN NUMBER,
65 x_status OUT NOCOPY VARCHAR2,
66 x_loading_status OUT NOCOPY VARCHAR2
67 ) ;
68 Procedure Apply_payment_plan_upd
69 ( p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2,
71 p_commit IN VARCHAR2,
72 p_validation_level IN NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_salesrep_id IN NUMBER,
77 p_srp_pmt_asgn_id IN NUMBER,
78 p_payrun_id IN NUMBER,
79 p_old_srp_pmt_plans_rec IN srp_pmt_plans_rec_type := G_MISS_SRP_PMT_PLANS_REC,
80 p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type :=G_MISS_SRP_PMT_PLANS_REC,
81 x_status OUT NOCOPY VARCHAR2,
82 x_loading_status OUT NOCOPY VARCHAR2
83 ) ;
84 Procedure Apply_payment_plan_cre
85 ( p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2,
87 p_commit IN VARCHAR2,
88 p_validation_level IN NUMBER,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_salesrep_id IN NUMBER,
93 p_srp_pmt_asgn_id IN NUMBER,
94 p_payrun_id IN NUMBER,
95 p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type := G_MISS_SRP_PMT_PLANS_REC,
96 x_status OUT NOCOPY VARCHAR2,
97 x_loading_status OUT NOCOPY VARCHAR2
98 ) ;
99
100 Procedure Apply_payment_plan_del
101 ( p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2,
103 p_commit IN VARCHAR2,
104 p_validation_level IN NUMBER,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_salesrep_id IN NUMBER,
109 p_srp_pmt_asgn_id IN NUMBER,
110 p_payrun_id IN NUMBER,
111 p_srp_pmt_plans_rec IN srp_pmt_plans_rec_type := G_MISS_SRP_PMT_PLANS_REC,
112 x_status OUT NOCOPY VARCHAR2,
113 x_loading_status OUT NOCOPY VARCHAR2
114 ) ;
115
116
117 END CN_WKSHT_CT_UP_PUB;