APPS.OKI_LOAD_ETR_PVT dependencies on OKI_EXP_TO_RNWL

Line 33: g_bin_id VARCHAR2(30) := 'OKI_EXP_TO_RNWL_BIN' ;

29: g_green_checkmark NUMBER := 2 ;
30: g_green_up_arrow NUMBER := 3 ;
31:
32:
33: g_bin_id VARCHAR2(30) := 'OKI_EXP_TO_RNWL_BIN' ;
34:
35: --
36: -- Global cursor declaration
37: --

Line 51: FROM oki_exp_to_rnwl etr

47: , p_scs_code IN VARCHAR2
48: , p_measure_code IN VARCHAR2
49: ) IS
50: SELECT rowid
51: FROM oki_exp_to_rnwl etr
52: WHERE
53: etr.summary_build_date = p_summary_build_date
54: AND etr.authoring_org_id = p_authoring_org_id
55: AND etr.customer_party_id = p_customer_party_id

Line 63: --Procedure to insert records into the oki_exp_to_rnwl table.

59: rec_g_etr_csr g_etr_csr%ROWTYPE ;
60:
61: --------------------------------------------------------------------------------
62: --
63: --Procedure to insert records into the oki_exp_to_rnwl table.
64: --
65: --------------------------------------------------------------------------------
66:
67: PROCEDURE ins_exp_to_rnwl

Line 95: INSERT INTO oki_exp_to_rnwl

91:
92: -- initialize return code to success
93: x_retcode := '0';
94:
95: INSERT INTO oki_exp_to_rnwl
96: (
97: summary_build_date
98: , authoring_org_id
99: , organization_name

Line 143: , value => 'OKI_EXP_TO_RNWL' ) ;

139: fnd_message.set_name( application => 'OKI'
140: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
141:
142: fnd_message.set_token( token => 'TABLE_NAME'
143: , value => 'OKI_EXP_TO_RNWL' ) ;
144:
145: fnd_file.put_line( which => fnd_file.log
146: , buff => fnd_message.get ) ;
147:

Line 154: -- Procedure to update records in the oki_exp_to_rnwl table.

150: END ins_exp_to_rnwl ;
151:
152: --------------------------------------------------------------------------------
153: --
154: -- Procedure to update records in the oki_exp_to_rnwl table.
155: --
156: --------------------------------------------------------------------------------
157: PROCEDURE upd_exp_to_rnwl
158: (

Line 182: UPDATE oki_exp_to_rnwl SET

178:
179: -- initialize return code to success
180: x_retcode := '0';
181:
182: UPDATE oki_exp_to_rnwl SET
183: measure_value1 = p_measure_value1
184: , measure_value2 = p_measure_value2
185: , measure_value3 = p_measure_value3
186: , measure_code_meaning = p_measure_code_meaning

Line 2115: l_table_name CONSTANT VARCHAR2(30) := 'OKI_EXP_TO_RNWL' ;

2111:
2112: -- Constant declaration
2113:
2114: -- Name of the table for which data is being inserted
2115: l_table_name CONSTANT VARCHAR2(30) := 'OKI_EXP_TO_RNWL' ;
2116:
2117: -- Local variable declaration
2118:
2119: -- For capturing the return code, 0 = success, 1 = warning, 2 = error