APPS.OKI_LOAD_ENR_PVT dependencies on OKI_EXP_NOT_RENEWED

Line 58: FROM oki_exp_not_renewed enr

54: , p_contact_id IN VARCHAR2
55: , p_scs_code IN VARCHAR2
56: ) IS
57: SELECT rowid
58: FROM oki_exp_not_renewed enr
59: WHERE enr.period_set_name = p_period_set_name
60: AND enr.period_name = p_period_name
61: AND enr.authoring_org_id = p_authoring_org_id
62: AND enr.customer_party_id = p_customer_party_id

Line 99: SELECT oki_exp_not_renewed_s1.nextval seq

95: l_sequence NUMBER := NULL ;
96:
97: -- Cursor declaration
98: CURSOR l_seq_num IS
99: SELECT oki_exp_not_renewed_s1.nextval seq
100: FROM dual
101: ;
102: rec_l_seq_num l_seq_num%ROWTYPE ;
103:

Line 118: INSERT INTO oki_exp_not_renewed

114: END IF ;
115: l_sequence := rec_l_seq_num.seq ;
116: CLOSE l_seq_num ;
117:
118: INSERT INTO oki_exp_not_renewed
119: ( id
120: , period_set_name
121: , period_name
122: , period_type

Line 167: , value => 'OKI_EXP_NOT_RENEWED');

163: fnd_message.set_name( application => 'OKI'
164: , name => 'OKI_TABLE_LOAD_FAILURE');
165:
166: fnd_message.set_token( token => 'TABLE_NAME'
167: , value => 'OKI_EXP_NOT_RENEWED');
168:
169: fnd_file.put_line( which => fnd_file.log
170: , buff => fnd_message.get);
171:

Line 199: UPDATE oki_exp_not_renewed SET

195:
196: -- initialize return code to success
197: x_retcode := '0';
198:
199: UPDATE oki_exp_not_renewed SET
200: base_lost_amount = p_base_lost_amount
201: , contract_count = p_contract_count
202: , request_id = oki_load_enr_pvt.g_request_id
203: , program_application_id = oki_load_enr_pvt.g_program_application_id

Line 884: l_table_name CONSTANT VARCHAR2(30) := 'OKI_EXP_NOT_RENEWED' ;

880:
881: -- Constant declaration
882:
883: -- Name of the table for which data is being inserted
884: l_table_name CONSTANT VARCHAR2(30) := 'OKI_EXP_NOT_RENEWED' ;
885:
886:
887: -- Local variable declaration
888: