[Home] [Help]
PACKAGE: APPS.CN_PREPOSTDETAILS
Source
1 PACKAGE CN_PREPOSTDETAILS AUTHID CURRENT_USER AS
2 -- $Header: cntpdets.pls 115.7 2002/01/28 20:05:03 pkm ship $ --+
3
4 TYPE posting_detail_rec_type IS RECORD
5 (posting_detail_id cn_posting_details.posting_detail_id%TYPE,
6 posting_batch_id cn_posting_details.posting_batch_id%TYPE,
7 posting_type cn_posting_details.posting_type%TYPE,
8 trx_type cn_posting_details.trx_type%TYPE,
9 payee_salesrep_id cn_posting_details.payee_salesrep_id%TYPE,
10 role_id cn_posting_details.role_id%TYPE,
11 incentive_type_code cn_posting_details.incentive_type_code%TYPE,
12 credit_type_id cn_posting_details.credit_type_id%TYPE,
13 pay_period_id cn_posting_details.pay_period_id%TYPE,
14 amount cn_posting_details.amount%TYPE := 0,
15 commission_header_id cn_posting_details.commission_header_id%TYPE,
16 commission_line_id cn_posting_details.commission_line_id%TYPE,
17 srp_plan_assign_id cn_posting_details.srp_plan_assign_id%TYPE,
18 quota_id cn_posting_details.quota_id%TYPE,
19 status cn_posting_details.status%TYPE
20 := FND_API.G_MISS_CHAR,
21 loaded_date cn_posting_details.loaded_date%TYPE
22 := FND_API.G_MISS_DATE,
23 processed_date cn_posting_details.processed_date%TYPE,
24 credited_salesrep_id cn_posting_details.credited_salesrep_id%TYPE,
25 processed_period_id cn_posting_details.processed_period_id%TYPE,
26 quota_rule_id cn_posting_details.quota_rule_id%TYPE,
27 event_factor cn_posting_details.event_factor%TYPE,
28 payment_factor cn_posting_details.payment_factor%TYPE,
29 quota_factor cn_posting_details.quota_factor%TYPE,
30 pending_status cn_posting_details.pending_status%TYPE,
31 input_achieved cn_posting_details.input_achieved%TYPE,
32 rate_tier_id cn_posting_details.rate_tier_id%TYPE,
33 payee_line_id cn_posting_details.payee_line_id%TYPE,
34 cl_status cn_posting_details.cl_status%TYPE,
35 created_during cn_posting_details.created_during%TYPE,
36 commission_rate cn_posting_details.commission_rate%TYPE := 0,
37 hold_flag cn_posting_details.hold_flag%TYPE
38 := FND_API.G_MISS_CHAR,
39 paid_flag cn_posting_details.paid_flag%TYPE
40 := FND_API.G_MISS_CHAR,
41 payment_amount cn_posting_details.payment_amount%TYPE
42 := FND_API.G_MISS_NUM,
43 attribute_category cn_posting_details.attribute_category%TYPE
44 := FND_API.G_MISS_CHAR,
45 attribute1 cn_posting_details.attribute1%TYPE
46 := FND_API.G_MISS_CHAR,
47 attribute2 cn_posting_details.attribute2%TYPE
48 := FND_API.G_MISS_CHAR,
49 attribute3 cn_posting_details.attribute3%TYPE
50 := FND_API.G_MISS_CHAR,
51 attribute4 cn_posting_details.attribute4%TYPE
52 := FND_API.G_MISS_CHAR,
53 attribute5 cn_posting_details.attribute5%TYPE
54 := FND_API.G_MISS_CHAR,
55 attribute6 cn_posting_details.attribute6%TYPE
56 := FND_API.G_MISS_CHAR,
57 attribute7 cn_posting_details.attribute7%TYPE
58 := FND_API.G_MISS_CHAR,
59 attribute8 cn_posting_details.attribute8%TYPE
60 := FND_API.G_MISS_CHAR,
61 attribute9 cn_posting_details.attribute9%TYPE
62 := FND_API.G_MISS_CHAR,
63 attribute10 cn_posting_details.attribute10%TYPE
64 := FND_API.G_MISS_CHAR,
65 attribute11 cn_posting_details.attribute11%TYPE
66 := FND_API.G_MISS_CHAR,
67 attribute12 cn_posting_details.attribute12%TYPE
68 := FND_API.G_MISS_CHAR,
69 attribute13 cn_posting_details.attribute13%TYPE
70 := FND_API.G_MISS_CHAR,
71 attribute14 cn_posting_details.attribute14%TYPE
72 := FND_API.G_MISS_CHAR,
73 attribute15 cn_posting_details.attribute15%TYPE
74 := FND_API.G_MISS_CHAR,
75 created_by cn_posting_details.created_by%TYPE,
76 creation_date cn_posting_details.creation_date%TYPE,
77 last_update_login cn_posting_details.last_update_login%TYPE,
78 last_update_date cn_posting_details.last_update_date%TYPE,
79 last_updated_by cn_posting_details.last_updated_by%TYPE);
80
81 TYPE posting_detail_rec_tbl_type IS TABLE OF posting_detail_rec_type
82 INDEX BY BINARY_INTEGER;
83
84 PROCEDURE Begin_Record
85 (x_operation IN VARCHAR2,
86 x_rowid IN OUT VARCHAR2,
87 x_posting_detail_rec IN OUT posting_detail_rec_type,
88 x_program_type IN VARCHAR2);
89 END CN_PREPOSTDETAILS;