APPS.OKI_LOAD_RAG_PVT dependencies on OKI_RENEWAL_AGING

Line 54: FROM oki_renewal_aging rag

50: , p_customer_party_id IN NUMBER
51: , p_scs_code IN VARCHAR2
52: ) IS
53: SELECT rowid
54: FROM oki_renewal_aging rag
55: WHERE rag.period_set_name = p_period_set_name
56: AND rag.period_name = p_period_name
57: AND rag.authoring_org_id = p_authoring_org_id
58: AND rag.customer_party_id = p_customer_party_id

Line 93: SELECT oki_renewal_aging_s1.nextval seq

89: l_sequence NUMBER := NULL ;
90:
91: -- Cursor declaration
92: CURSOR l_seq_num IS
93: SELECT oki_renewal_aging_s1.nextval seq
94: FROM dual ;
95: rec_l_seq_num l_seq_num%ROWTYPE ;
96:
97: BEGIN

Line 111: INSERT INTO oki_renewal_aging

107: END IF ;
108: l_sequence := rec_l_seq_num.seq ;
109: CLOSE l_seq_num ;
110:
111: INSERT INTO oki_renewal_aging
112: ( id
113: , period_set_name
114: , period_name
115: , period_type

Line 159: , value => 'OKI_RENEWAL_AGING');

155: fnd_message.set_name( application => 'OKI'
156: , name => 'OKI_TABLE_LOAD_FAILURE');
157:
158: fnd_message.set_token( token => 'TABLE_NAME'
159: , value => 'OKI_RENEWAL_AGING');
160:
161: fnd_file.put_line( which => fnd_file.log
162: , buff => fnd_message.get);
163:

Line 192: UPDATE oki_renewal_aging SET

188:
189: -- initialize return code to success
190: x_retcode := '0';
191:
192: UPDATE oki_renewal_aging SET
193: age_group1 = p_age_group1
194: , age_group2 = p_age_group2
195: , age_group3 = p_age_group3
196: , age_group4 = p_age_group4

Line 1084: l_table_name CONSTANT VARCHAR2(30) := 'OKI_RENEWAL_AGING' ;

1080:
1081: -- Constant declaration
1082:
1083: -- Name of the table for which data is being inserted
1084: l_table_name CONSTANT VARCHAR2(30) := 'OKI_RENEWAL_AGING' ;
1085:
1086:
1087:
1088: -- Local variable declaration