[Home] [Help]
PACKAGE: APPS.DPP_SLA_CLAIM_EXTRACT_PUB
Source
1 PACKAGE DPP_SLA_CLAIM_EXTRACT_PUB AUTHID CURRENT_USER AS
2 /* $Header: dppclexs.pls 120.3 2008/01/11 10:05:11 sdasan noship $ */
3 -- -------------------------------------------------------
4 -- Record name claim_line_rec_type
5 -- Note: This is automatic generated record definition, it includes
6 -- all columns defined in the table, developer must manually add or
7 -- delete some of the attributes.
8 -- -------------------------------------------------------
9 TYPE claim_line_rec_type IS RECORD
10 (
11 claim_line_id NUMBER ,
12 object_version_number NUMBER ,
13 last_update_date DATE ,
14 last_updated_by NUMBER,
15 creation_date DATE,
16 created_by NUMBER,
17 last_update_login NUMBER,
18 request_id NUMBER,
19 program_application_id NUMBER,
20 program_update_date DATE,
21 program_id NUMBER,
22 created_from VARCHAR2(30),
23 claim_id NUMBER,
24 line_number NUMBER,
25 split_from_claim_line_id NUMBER,
26 amount NUMBER,
27 claim_currency_amount NUMBER,
28 acctd_amount NUMBER,
29 currency_code VARCHAR2(15),
30 exchange_rate_type VARCHAR2(30),
31 exchange_rate_date DATE ,
32 exchange_rate NUMBER,
33 set_of_books_id NUMBER,
34 valid_flag VARCHAR2(1),
35 source_object_id NUMBER,
36 source_object_class VARCHAR2(15),
37 source_object_type_id NUMBER,
38 source_object_line_id NUMBER,
39 plan_id NUMBER,
40 offer_id NUMBER,
41 utilization_id NUMBER,
42 payment_method VARCHAR2(15),
43 payment_reference_id NUMBER,
44 payment_reference_number VARCHAR2(15),
45 payment_reference_date DATE ,
46 voucher_id NUMBER,
47 voucher_number VARCHAR2(30),
48 payment_status VARCHAR2(30),
49 approved_flag VARCHAR2(1),
50 approved_date DATE ,
51 approved_by NUMBER,
52 settled_date DATE ,
53 settled_by NUMBER,
54 performance_complete_flag VARCHAR2(1),
55 performance_attached_flag VARCHAR2(1),
56 item_id NUMBER,
57 item_description VARCHAR2(240),
58 quantity NUMBER,
59 quantity_uom VARCHAR2(30),
60 rate NUMBER,
61 activity_type VARCHAR2(30),
62 activity_id NUMBER,
63 related_cust_account_id NUMBER,
64 relationship_type VARCHAR2(30),
65 earnings_associated_flag VARCHAR2(1),
66 comments VARCHAR2(2000),
67 tax_code VARCHAR2(50),
68 attribute_category VARCHAR2(30),
69 attribute1 VARCHAR2(150),
70 attribute2 VARCHAR2(150),
71 attribute3 VARCHAR2(150),
72 attribute4 VARCHAR2(150),
73 attribute5 VARCHAR2(150),
74 attribute6 VARCHAR2(150),
75 attribute7 VARCHAR2(150),
76 attribute8 VARCHAR2(150),
77 attribute9 VARCHAR2(150),
78 attribute10 VARCHAR2(150),
79 attribute11 VARCHAR2(150),
80 attribute12 VARCHAR2(150),
81 attribute13 VARCHAR2(150),
82 attribute14 VARCHAR2(150),
83 attribute15 VARCHAR2(150),
84 org_id NUMBER,
85 sale_date DATE,
86 item_type VARCHAR2(30),
87 tax_amount NUMBER,
88 claim_curr_tax_amount NUMBER,
89 activity_line_id NUMBER,
90 offer_type VARCHAR2(30),
91 prorate_earnings_flag VARCHAR2(1),
92 earnings_end_date DATE,
93 dpp_cust_account_id VARCHAR2(20)
94 );
95 TYPE claim_line_tbl_type is TABLE OF claim_line_rec_type
96 INDEX BY BINARY_INTEGER;
97
98 TYPE sla_line_rec_type IS RECORD
99 (
100 TRANSACTION_HEADER_ID NUMBER ,
101 TRANSACTION_LINE_ID NUMBER ,
102 BASE_TRANSACTION_HEADER_ID NUMBER ,
103 BASE_TRANSACTION_LINE_ID NUMBER ,
104 TRANSACTION_SUB_TYPE VARCHAR2(20),
105 CREATION_DATE DATE,
106 CREATED_BY NUMBER,
107 LAST_UPDATE_DATE DATE,
108 LAST_UPDATED_BY NUMBER,
109 LAST_UPDATE_LOGIN NUMBER
110 );
111
112
113
114
115 TYPE sla_line_tbl_type is TABLE OF sla_line_rec_type INDEX BY BINARY_INTEGER;
116
117 PROCEDURE Create_SLA_extract(
118 p_api_version_number IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_claim_id IN ozf_claims.claim_id%TYPE,
126 p_claim_line_tbl IN claim_line_tbl_type,
127 p_userid IN NUMBER
128 );
129
130
131 END DPP_SLA_CLAIM_EXTRACT_PUB;