[Home] [Help]
PACKAGE: APPS.OKL_INTERNAL_TO_EXTERNAL
Source
1 PACKAGE Okl_Internal_To_External AUTHID CURRENT_USER AS
2 /* $Header: OKLRIEXS.pls 120.5 2006/11/17 10:27:33 zrehman noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
7 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
8 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
9 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
10 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
11 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
12 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
13 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
14 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
15 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
16 ---------------------------------------------------------------------------
17 -- GLOBAL VARIABLES
18 ---------------------------------------------------------------------------
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INTERNAL_TO_EXTERNAL';
20 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
21
22 /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
23 --GLOBAL MESSAGES
24 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
25 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
27 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
28 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
29
30
31 --GLOBAL VARIABLES
32 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_INT_TO_EXT';
33 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
34
35 --fmiao 5209209 change
36 /*
37 PROCEDURE internal_to_external(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44 p_contract_number IN VARCHAR2 DEFAULT NULL
45 ); */
46
47 TYPE ie_rec_type1 IS RECORD
48 ( tai_id okl_trx_ar_invoices_v.id%TYPE
49 ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
50 ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
51 ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
52 ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
53 ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
54 ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
55 ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
56 ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
57 ,tai_description okl_trx_ar_invoices_v.description%TYPE
58 ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
59 ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
60 ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
61 ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
62 ,org_id okl_trx_ar_invoices_v.org_id%TYPE
63 ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
64 ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
65 ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
66 ,til_description okl_txd_ar_ln_dtls_v.description%TYPE
67 ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
68 ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
69 ,tld_id okl_txd_ar_ln_dtls_v.id%TYPE
70 ,amount okl_txd_ar_ln_dtls_v.amount%TYPE
71 ,tld_id_reverses okl_txd_ar_ln_dtls_v.TLD_ID_REVERSES%TYPE
72 ,sty_id okl_txd_ar_ln_dtls_v.sty_id%TYPE
73 ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE
74 ,sel_id okl_txd_ar_ln_dtls_v.sel_id%TYPE
75 ,inventory_item_id okl_txd_ar_ln_dtls_v.inventory_item_id%TYPE
76 ,inventory_org_id okl_txd_ar_ln_dtls_v.inventory_org_id%TYPE
77 );
78 TYPE ie_tbl_type1 IS TABLE OF ie_rec_type1
79 INDEX BY BINARY_INTEGER;
80
81 TYPE ie_rec_type2 IS RECORD
82 ( tai_id okl_trx_ar_invoices_v.id%TYPE
83 ,contract_id okl_trx_ar_invoices_v.khr_id%TYPE
84 ,trx_status_code okl_trx_ar_invoices_v.trx_status_code%TYPE
85 ,date_invoiced okl_trx_ar_invoices_v.date_invoiced%TYPE
86 ,ixx_id okl_trx_ar_invoices_v.ixx_id%TYPE
87 ,irm_id okl_trx_ar_invoices_v.irm_id%TYPE
88 ,irt_id okl_trx_ar_invoices_v.irt_id%TYPE
89 ,ibt_id okl_trx_ar_invoices_v.ibt_id%TYPE
90 ,set_of_books_id okl_trx_ar_invoices_v.set_of_books_id%TYPE
91 ,tai_description okl_trx_ar_invoices_v.description%TYPE
92 ,currency_code okl_trx_ar_invoices_v.currency_code%TYPE
93 ,currency_conversion_type okl_trx_ar_invoices_v.currency_conversion_type%TYPE
94 ,currency_conversion_rate okl_trx_ar_invoices_v.currency_conversion_rate%TYPE
95 ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
96 ,org_id okl_trx_ar_invoices_v.org_id%TYPE
97 ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
98 ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
99 ,til_id okl_txl_ar_inv_lns_v.id%TYPE
100 ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
101 ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
102 ,til_description okl_txl_ar_inv_lns_v.description%TYPE
103 ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
104 ,amount okl_txl_ar_inv_lns_v.amount%TYPE
105 ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE
106 ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE
107 ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE
108 ,inventory_item_id okl_txl_ar_inv_lns_v.inventory_item_id%TYPE
109 ,inventory_org_id okl_txl_ar_inv_lns_v.inventory_org_id%TYPE
110 ,bank_acct_id okl_txl_ar_inv_lns_v.bank_acct_id%TYPE
111 ,qte_id okl_trx_ar_invoices_v.qte_id%TYPE
112 );
113 TYPE ie_tbl_type2 IS TABLE OF ie_rec_type2
114 INDEX BY BINARY_INTEGER;
115
116
117 -- ----------------------------------------------------------------
118 -- Procedure
119 -- ----------------------------------------------------------------
120 PROCEDURE internal_to_external
121 ( p_api_version IN NUMBER
122 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
123 ,x_return_status OUT NOCOPY VARCHAR2
124 ,x_msg_count OUT NOCOPY NUMBER
125 ,x_msg_data OUT NOCOPY VARCHAR2
126 ,p_commit IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
127 ,p_contract_number IN VARCHAR2 DEFAULT NULL
128 ,p_assigned_process IN VARCHAR2 DEFAULT NULL
129 );
130 --fmiao 5209209 change end
131
132
133 END Okl_Internal_To_External;