APPS.OKI_LOAD_YRA_PVT dependencies on OKI_YOY_RENEWAL_AMT

Line 44: FROM oki_yoy_renewal_amt yyr

40: , p_month IN VARCHAR2
41: , p_scs_code IN VARCHAR2
42: ) IS
43: SELECT rowid
44: FROM oki_yoy_renewal_amt yyr
45: WHERE yyr.period_set_name = p_period_set_name
46: AND yyr.period_name = p_period_name
47: AND yyr.authoring_org_id = p_authoring_org_id
48: AND yyr.year = p_year

Line 55: -- Procedure to insert records into the oki_yoy_renewal_amt table.

51: ;
52: rec_g_yra_csr g_yra_csr%ROWTYPE ;
53:
54: --------------------------------------------------------------------------------
55: -- Procedure to insert records into the oki_yoy_renewal_amt table.
56:
57: --------------------------------------------------------------------------------
58: PROCEDURE ins_yoy_rnwl
59: ( p_period_set_name IN VARCHAR2

Line 81: SELECT oki_yoy_renewal_amt_s1.nextval seq

77: l_sequence NUMBER := NULL ;
78:
79: -- Cursor declaration
80: CURSOR l_seq_num IS
81: SELECT oki_yoy_renewal_amt_s1.nextval seq
82: FROM dual
83: ;
84: rec_l_seq_num l_seq_num%ROWTYPE ;
85:

Line 100: INSERT INTO oki_yoy_renewal_amt

96: END IF ;
97: l_sequence := rec_l_seq_num.seq ;
98: CLOSE l_seq_num ;
99:
100: INSERT INTO oki_yoy_renewal_amt
101: ( id
102: , period_set_name
103: , period_name
104: , period_type

Line 142: , value => 'OKI_YOY_RENEWAL_AMT' );

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

Line 152: -- Procedure to update records in the oki_yoy_renewal_amt table.

148: , buff => l_sqlcode||' '||l_sqlerrm );
149: END ins_yoy_rnwl ;
150:
151: --------------------------------------------------------------------------------
152: -- Procedure to update records in the oki_yoy_renewal_amt table.
153:
154: --------------------------------------------------------------------------------
155: PROCEDURE upd_yoy_rnwl
156: ( p_base_contract_amount IN NUMBER

Line 173: UPDATE oki_yoy_renewal_amt SET

169:
170: -- initialize return code to success
171: x_retcode := '0';
172:
173: UPDATE oki_yoy_renewal_amt SET
174: base_contract_amount = p_base_contract_amount
175: , request_id = oki_load_yra_pvt.g_request_id
176: , program_application_id = oki_load_yra_pvt.g_program_application_id
177: , program_id = oki_load_yra_pvt.g_program_id

Line 763: l_table_name CONSTANT VARCHAR2(30) := 'OKI_YOY_RENEWAL_AMT' ;

759:
760: -- Constant declaration
761:
762: -- Name of the table for which data is being inserted
763: l_table_name CONSTANT VARCHAR2(30) := 'OKI_YOY_RENEWAL_AMT' ;
764:
765:
766: -- Local variable declaration
767: