DBA Data[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;