[Home] [Help]
PACKAGE: APPS.OKL_MLA_CREATE_UPDATE_PUB
Source
1 PACKAGE OKL_MLA_CREATE_UPDATE_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPMCUS.pls 120.1 2006/11/22 15:11:07 zrehman noship $ */
3
4 -------------------------------------------------------------------------------
5 -- GLOBAL EXCEPTION
6 ---------------------------------------------------------------------------
7 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8
9 -- GLOBAL VARIABLES
10 ---------------------------------------------------------------------------
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_MLA_CREATE_UPDATE_PUB';
12 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
13 OKL_TEMP_TYPE_PROGRAM CONSTANT VARCHAR2(30) := 'PROGRAM';
14 OKL_TEMP_TYPE_LEASEAPP CONSTANT VARCHAR2(30) := 'LEASEAPP';
15 OKL_TEMP_TYPE_CONTRACT CONSTANT VARCHAR2(30) := 'CONTRACT';
16 ---------------------------------------------------------------------------
17
18
19 TYPE deal_rec_type is record (
20 chr_id okl_k_headers_full_v.id%type,
21 chr_contract_number okl_k_headers_full_v.contract_number%type,
22 chr_description okl_k_headers_full_v.description%type,
23 vers_version VARCHAR2(30),
24 chr_sts_code okl_k_headers_full_v.sts_code%type,
25 chr_start_date okl_k_headers_full_v.start_date%type,
26 chr_end_date okl_k_headers_full_v.end_date%type,
27 khr_term_duration okl_k_headers_full_v.term_duration%type,
28 chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
29 chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
30 chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
31 khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
32 khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
33 khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
34 khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
35 khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
36 khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
37 chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
38 chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
39 khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
40 khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
41 khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
42 khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
43 khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
44 mla_contract_number okl_k_headers_full_v.contract_number%type,
45 mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
46 mla_gvr_id okl_k_headers_full_v.id%type,
47 cust_id okc_k_party_roles_v.id%type,
48 cust_object1_id1 okc_k_party_roles_v.object1_id1%type,
49 cust_object1_id2 okc_k_party_roles_v.object1_id2%type,
50 cust_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type,
51 cust_name varchar2(250),
52 lessor_id okc_k_party_roles_v.id%type,
53 lessor_object1_id1 okc_k_party_roles_v.object1_id1%type,
54 lessor_object1_id2 okc_k_party_roles_v.object1_id2%type,
55 lessor_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type,
56 lessor_name varchar2(250),
57 chr_currency_code okl_k_headers_full_v.currency_code%type,
58 currency_name varchar2(250),
59 khr_pdt_id okl_k_headers_full_v.pdt_id%type,
60 product_name okl_products_v.name%type,
61 product_description okl_products_v.description%type,
62 khr_khr_id okl_k_headers_full_v.khr_id%type,
63 program_contract_number okl_k_headers_full_v.contract_number%type,
64 cl_contract_number okl_k_headers_full_v.contract_number%type,
65 cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
66 cl_gvr_id okl_k_headers_full_v.id%type,
67 rg_larles_id okc_rule_groups_v.id%type,
68 r_larles_id okc_rule_groups_v.id%type,
69 r_larles_rule_information1 okc_rules_v.rule_information1%type,
70 col_larles_form_left_prompt varchar2(250),
71 rg_LAREBL_id okc_rule_groups_v.id%type,
72 r_LAREBL_id okc_rule_groups_v.id%type,
73 r_LAREBL_rule_information1 okc_rules_v.rule_information1%type,
74 col_larebl_form_left_prompt varchar2(250),
75 chr_cust_acct_id okc_k_headers_b.cust_acct_id%type,
76 customer_account varchar2(250),
77 cust_site_description varchar2(250),
78 contact_id okc_contacts_v.id%type,
79 contact_object1_id1 okc_contacts_v.object1_id1%type,
80 contact_object1_id2 okc_contacts_v.object1_id2%type,
81 contact_jtot_object1_code okc_contacts_v.jtot_object1_code%type,
82 contact_name varchar2(250),
83 rg_LATOWN_id okc_rule_groups_v.id%type,
84 r_LATOWN_id okc_rule_groups_v.id%type,
85 r_LATOWN_rule_information1 okc_rules_v.rule_information1%type,
86 col_latown_form_left_prompt varchar2(250),
87 rg_LANNTF_id okc_rule_groups_v.id%type,
88 r_LANNTF_id okc_rule_groups_v.id%type,
89 r_LANNTF_rule_information1 okc_rules_v.rule_information1%type,
90 col_lanntf_form_left_prompt varchar2(250),
91 rg_LACPLN_id okc_rule_groups_v.id%type,
92 r_LACPLN_id okc_rule_groups_v.id%type,
93 r_LACPLN_rule_information1 okc_rules_v.rule_information1%type,
94 col_lacpln_form_left_prompt varchar2(250),
95 rg_LAPACT_id okc_rule_groups_v.id%type,
96 r_LAPACT_id okc_rule_groups_v.id%type,
97 r_LAPACT_rule_information1 okc_rules_v.rule_information1%type,
98 col_lapact_form_left_prompt varchar2(250),
99 khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type,
100 khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type,
101 khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type,
102 khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type,
103 legal_entity_id NUMBER
104 );
105
106 TYPE deal_tab_type is table of deal_rec_type INDEX BY BINARY_INTEGER;
107
108 TYPE party_rec_type is record (
109 id NUMBER := OKL_API.G_MISS_NUM
110 ,attribute_category OKL_K_PARTY_ROLES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
111 ,attribute1 OKL_K_PARTY_ROLES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
112 ,attribute2 OKL_K_PARTY_ROLES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
113 ,attribute3 OKL_K_PARTY_ROLES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
114 ,attribute4 OKL_K_PARTY_ROLES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
115 ,attribute5 OKL_K_PARTY_ROLES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
116 ,attribute6 OKL_K_PARTY_ROLES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
117 ,attribute7 OKL_K_PARTY_ROLES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
118 ,attribute8 OKL_K_PARTY_ROLES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
119 ,attribute9 OKL_K_PARTY_ROLES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
120 ,attribute10 OKL_K_PARTY_ROLES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
121 ,attribute11 OKL_K_PARTY_ROLES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
122 ,attribute12 OKL_K_PARTY_ROLES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
123 ,attribute13 OKL_K_PARTY_ROLES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
124 ,attribute14 OKL_K_PARTY_ROLES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
125 ,attribute15 OKL_K_PARTY_ROLES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
126 ,object1_id1 OKC_K_PARTY_ROLES_B.object1_id1%type := OKL_API.G_MISS_CHAR
127 ,object1_id2 OKC_K_PARTY_ROLES_B.object1_id2%type := OKL_API.G_MISS_CHAR
128 ,jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%type := OKL_API.G_MISS_CHAR
129 ,rle_code OKC_K_PARTY_ROLES_B.rle_code%type := OKL_API.G_MISS_CHAR
130 ,chr_id OKC_K_PARTY_ROLES_B.chr_id%type := OKL_API.G_MISS_NUM
131 ,dnz_chr_id OKC_K_PARTY_ROLES_B.dnz_chr_id%type := OKL_API.G_MISS_NUM
132 ,cle_id OKC_K_PARTY_ROLES_B.cle_id%type := OKL_API.G_MISS_NUM
133 );
134
135 TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;
136
137
138 TYPE upd_deal_rec_type is record (
139 chr_id okl_k_headers_full_v.id%type,
140 chr_contract_number okl_k_headers_full_v.contract_number%type,
141 chr_description okl_k_headers_full_v.description%type,
142 chr_start_date okl_k_headers_full_v.start_date%type,
143 chr_end_date okl_k_headers_full_v.end_date%type,
144 khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
145 chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
146 chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
147 chr_currency_code okl_k_headers_full_v.currency_code%type,
148 legal_entity_id NUMBER
149 );
150
151 TYPE upd_deal_tab_type is table of upd_deal_rec_type INDEX BY BINARY_INTEGER;
152
153 PROCEDURE update_deal(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_durv_rec IN upd_deal_rec_type,
160 x_durv_rec OUT NOCOPY upd_deal_rec_type
161 );
162
163
164 PROCEDURE create_deal(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_source_code IN VARCHAR2,
171 p_template_type IN VARCHAR2,
172 p_contract_number IN VARCHAR2,
173 p_scs_code IN VARCHAR2,
174 p_customer_id1 IN OUT NOCOPY VARCHAR2,
175 p_customer_id2 IN OUT NOCOPY VARCHAR2,
176 p_customer_code IN VARCHAR2,
177 p_customer_name IN VARCHAR2,
178 p_effective_from IN DATE,
179 p_program_name IN VARCHAR2,
180 p_program_id IN NUMBER,
181 p_org_id IN NUMBER,
182 p_organization_id IN NUMBER,
183 p_source_chr_id IN OUT NOCOPY NUMBER,
184 p_source_contract_number IN VARCHAR2,
185 x_chr_id OUT NOCOPY NUMBER,
186 p_legal_entity_id IN NUMBER);
187
188 PROCEDURE create_party(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_kpl_rec IN party_rec_type,
195 x_kpl_rec OUT NOCOPY party_rec_type
196 );
197
198
199 END OKL_MLA_CREATE_UPDATE_PUB;