APPS.OKI_LOAD_SGR_PVT dependencies on OKI_SEQ_GROWTH_RATE

Line 64: FROM oki_seq_growth_rate sgr

60: , p_summary_build_date IN DATE
61: , p_period_type IN VARCHAR2
62: ) IS
63: SELECT rowid
64: FROM oki_seq_growth_rate sgr
65: WHERE sgr.period_set_name = p_period_set_name
66: AND sgr.period_name = p_period_name
67: AND sgr.authoring_org_id = p_authoring_org_id
68: AND sgr.seq_grw_rate_code = p_seq_grw_rate_code

Line 229: -- Procedure to insert records into the oki_seq_growth_rate table.

225: ;
226: rec_g_trmn_rnwl_csr g_trmn_rnwl_csr%ROWTYPE ;
227:
228: --------------------------------------------------------------------------------
229: -- Procedure to insert records into the oki_seq_growth_rate table.
230:
231: --------------------------------------------------------------------------------
232: PROCEDURE ins_seq_grw_rate
233: ( p_period_set_name IN VARCHAR2

Line 261: INSERT INTO oki_seq_growth_rate

257: BEGIN
258:
259: -- initialize return code to success
260: x_retcode := '0';
261: INSERT INTO oki_seq_growth_rate
262: ( period_set_name
263: , period_name
264: , period_type
265: , summary_build_date

Line 313: , value => 'OKI_SEQ_GROWTH_RATE' );

309: fnd_message.set_name( application => 'OKI'
310: , name => 'OKI_TABLE_LOAD_FAILURE' );
311:
312: fnd_message.set_token( token => 'TABLE_NAME'
313: , value => 'OKI_SEQ_GROWTH_RATE' );
314:
315: fnd_file.put_line( which => fnd_file.log
316: , buff => fnd_message.get );
317:

Line 324: -- Procedure to update records in the oki_seq_growth_rate table.

320:
321: END ins_seq_grw_rate ;
322:
323: --------------------------------------------------------------------------------
324: -- Procedure to update records in the oki_seq_growth_rate table.
325:
326: --------------------------------------------------------------------------------
327: PROCEDURE upd_seq_grw_rate
328: ( p_curr_base_contract_amount IN NUMBER

Line 348: UPDATE oki_seq_growth_rate SET

344:
345: -- initialize return code to success
346: x_retcode := '0';
347:
348: UPDATE oki_seq_growth_rate SET
349: curr_base_contract_amount = p_curr_base_contract_amount
350: , prev_base_contract_amount = p_prev_base_contract_amount
351: , curr_sob_contract_amount = p_curr_sob_contract_amount
352: , prev_sob_contract_amount = p_prev_sob_contract_amount

Line 4556: l_table_name CONSTANT VARCHAR2(30) := 'OKI_SEQ_GROWTH_RATE' ;

4552:
4553: -- Constant declaration
4554:
4555: -- Name of the table for which data is being inserted
4556: l_table_name CONSTANT VARCHAR2(30) := 'OKI_SEQ_GROWTH_RATE' ;
4557:
4558:
4559: -- Local variable declaration
4560: