eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_REFRESH_PVT dependencies on OKI_SALES_K_HDRS

Line 66: -- customer_name of oki_sales_k_hdrs are removed.

62: -- Tables oki_addresses and oki_expired_lines are obsoleted.
63: -- So, indexes of these tables are removed
64: -- 2. Indexes on columns which are not populated in the table are removed.
65: -- Index on salesrep_name of oki_k_salesrep and
66: -- customer_name of oki_sales_k_hdrs are removed.
67: -- 3. Index created on new column is_exp_not_renewed_yn of oki_cov_prd_lines table.
68: PROCEDURE create_indicies (p_object_name IN VARCHAR2
69: ,p_parm_rec IN index_info_csr%ROWTYPE) IS
70:

Line 95: IF p_object_name = 'OKI_SALES_K_HDRS' THEN

91: CLOSE c_default_index_info;
92: END IF;
93:
94: -- create the indexes
95: IF p_object_name = 'OKI_SALES_K_HDRS' THEN
96: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N1 ON';
97: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(IS_NEW_YN)'||' PARALLEL ';
98: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
99: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 96: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N1 ON';

92: END IF;
93:
94: -- create the indexes
95: IF p_object_name = 'OKI_SALES_K_HDRS' THEN
96: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N1 ON';
97: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(IS_NEW_YN)'||' PARALLEL ';
98: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
99: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
100: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 97: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(IS_NEW_YN)'||' PARALLEL ';

93:
94: -- create the indexes
95: IF p_object_name = 'OKI_SALES_K_HDRS' THEN
96: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N1 ON';
97: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(IS_NEW_YN)'||' PARALLEL ';
98: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
99: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
100: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
101: EXECUTE IMMEDIATE l_sql_string;

Line 102: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N2 ON';

98: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
99: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
100: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
101: EXECUTE IMMEDIATE l_sql_string;
102: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N2 ON';
103: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CLOSE_DATE)'||' PARALLEL ';
104: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
105: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
106: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 103: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CLOSE_DATE)'||' PARALLEL ';

99: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
100: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
101: EXECUTE IMMEDIATE l_sql_string;
102: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N2 ON';
103: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CLOSE_DATE)'||' PARALLEL ';
104: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
105: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
106: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
107: EXECUTE IMMEDIATE l_sql_string;

Line 108: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N3 ON';

104: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
105: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
106: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
107: EXECUTE IMMEDIATE l_sql_string;
108: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N3 ON';
109: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(END_DATE)'||' PARALLEL ';
110: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
111: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
112: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 109: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(END_DATE)'||' PARALLEL ';

105: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
106: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
107: EXECUTE IMMEDIATE l_sql_string;
108: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N3 ON';
109: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(END_DATE)'||' PARALLEL ';
110: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
111: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
112: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
113: EXECUTE IMMEDIATE l_sql_string;

Line 114: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N4 ON';

110: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
111: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
112: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
113: EXECUTE IMMEDIATE l_sql_string;
114: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N4 ON';
115: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CUSTOMER_PARTY_ID)'||' PARALLEL ';
116: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
117: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
118: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 115: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CUSTOMER_PARTY_ID)'||' PARALLEL ';

111: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
112: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
113: EXECUTE IMMEDIATE l_sql_string;
114: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N4 ON';
115: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CUSTOMER_PARTY_ID)'||' PARALLEL ';
116: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
117: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
118: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
119: EXECUTE IMMEDIATE l_sql_string;

Line 120: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N5 ON';

116: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
117: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
118: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
119: EXECUTE IMMEDIATE l_sql_string;
120: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N5 ON';
121: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(DATE_CANCELED)'||' PARALLEL ';
122: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
123: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
124: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 121: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(DATE_CANCELED)'||' PARALLEL ';

117: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
118: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
119: EXECUTE IMMEDIATE l_sql_string;
120: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N5 ON';
121: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(DATE_CANCELED)'||' PARALLEL ';
122: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
123: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
124: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
125: EXECUTE IMMEDIATE l_sql_string;

Line 126: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N6 ON';

122: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
123: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
124: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
125: EXECUTE IMMEDIATE l_sql_string;
126: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N6 ON';
127: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(START_DATE)'||' PARALLEL ';
128: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
129: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
130: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 127: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(START_DATE)'||' PARALLEL ';

123: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
124: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
125: EXECUTE IMMEDIATE l_sql_string;
126: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N6 ON';
127: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(START_DATE)'||' PARALLEL ';
128: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
129: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
130: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
131: EXECUTE IMMEDIATE l_sql_string;

Line 132: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N7 ON';

128: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
129: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
130: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
131: EXECUTE IMMEDIATE l_sql_string;
132: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N7 ON';
133: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(DATE_TERMINATED)'||' PARALLEL ';
134: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
135: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
136: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 133: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(DATE_TERMINATED)'||' PARALLEL ';

129: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
130: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
131: EXECUTE IMMEDIATE l_sql_string;
132: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N7 ON';
133: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(DATE_TERMINATED)'||' PARALLEL ';
134: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
135: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
136: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
137: EXECUTE IMMEDIATE l_sql_string;

Line 138: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N8 ON';

134: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
135: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
136: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
137: EXECUTE IMMEDIATE l_sql_string;
138: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N8 ON';
139: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(authoring_org_id)'||' PARALLEL ';
140: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
141: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
142: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 139: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(authoring_org_id)'||' PARALLEL ';

135: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
136: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
137: EXECUTE IMMEDIATE l_sql_string;
138: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N8 ON';
139: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(authoring_org_id)'||' PARALLEL ';
140: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
141: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
142: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
143: EXECUTE IMMEDIATE l_sql_string;

Line 144: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N9 ON';

140: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
141: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
142: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
143: EXECUTE IMMEDIATE l_sql_string;
144: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N9 ON';
145: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(date_approved)'
146: ||' PARALLEL ';
147: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
148: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 145: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(date_approved)'

141: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
142: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
143: EXECUTE IMMEDIATE l_sql_string;
144: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N9 ON';
145: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(date_approved)'
146: ||' PARALLEL ';
147: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
148: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
149: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 156: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N10 ON';

152: /* 11510 Changes
153: Commenting out creation of index as customer name is not be used
154: from this table.
155:
156: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N10 ON';
157: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(customer_name)'||' PARALLEL ';
158: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
159: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
160: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 157: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(customer_name)'||' PARALLEL ';

153: Commenting out creation of index as customer name is not be used
154: from this table.
155:
156: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N10 ON';
157: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(customer_name)'||' PARALLEL ';
158: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
159: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
160: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
161: EXECUTE IMMEDIATE l_sql_string;

Line 163: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N11 ON';

159: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
160: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
161: EXECUTE IMMEDIATE l_sql_string;
162: */
163: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N11 ON';
164: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(COMPLETE_CONTRACT_NUMBER)'
165: ||' PARALLEL ';
166: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
167: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 164: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(COMPLETE_CONTRACT_NUMBER)'

160: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
161: EXECUTE IMMEDIATE l_sql_string;
162: */
163: l_sql_string := 'CREATE INDEX OKI.OKI_SALES_K_HDRS_N11 ON';
164: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(COMPLETE_CONTRACT_NUMBER)'
165: ||' PARALLEL ';
166: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
167: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
168: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 170: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_SALES_K_HDRS_U1 ON';

166: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
167: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
168: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
169: EXECUTE IMMEDIATE l_sql_string;
170: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_SALES_K_HDRS_U1 ON';
171: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CHR_ID)'||' PARALLEL ';
172: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
173: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
174: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 171: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CHR_ID)'||' PARALLEL ';

167: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
168: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
169: EXECUTE IMMEDIATE l_sql_string;
170: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_SALES_K_HDRS_U1 ON';
171: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CHR_ID)'||' PARALLEL ';
172: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
173: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
174: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
175: EXECUTE IMMEDIATE l_sql_string;

Line 176: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_SALES_K_HDRS_U2 ON';

172: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
173: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
174: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
175: EXECUTE IMMEDIATE l_sql_string;
176: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_SALES_K_HDRS_U2 ON';
177: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CONTRACT_NUMBER,CONTRACT_NUMBER_MODIFIER)'||' PARALLEL ';
178: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
179: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
180: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 177: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CONTRACT_NUMBER,CONTRACT_NUMBER_MODIFIER)'||' PARALLEL ';

173: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
174: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
175: EXECUTE IMMEDIATE l_sql_string;
176: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_SALES_K_HDRS_U2 ON';
177: l_sql_string := l_sql_string||' OKI.OKI_SALES_K_HDRS(CONTRACT_NUMBER,CONTRACT_NUMBER_MODIFIER)'||' PARALLEL ';
178: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
179: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
180: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
181: EXECUTE IMMEDIATE l_sql_string;

Line 375: IF (p_object_name = 'OKI_SALES_K_HDRS')

371: fnd_file.put_line( which => fnd_file.log
372: , buff => l_sql_string);
373: fnd_file.put_line( which => fnd_file.log
374: , buff => ' ');
375: IF (p_object_name = 'OKI_SALES_K_HDRS')
376: THEN
377: FOR r_rec IN (SELECT dnz_chr_id, count(1) chr_count
378: FROM okc_k_party_roles_b
379: WHERE rle_code IN ('CUSTOMER','LICENSEE','BUYER')

Line 741: l_table_name := 'OKI_SALES_K_HDRS' ;

737: END IF ;
738:
739: l_table_owner := 'OKI' ;
740:
741: l_table_name := 'OKI_SALES_K_HDRS' ;
742: l_loc := 'Calling truncate_table with ' || l_table_owner || '.' || l_table_name ;
743: truncate_table( p_table_owner => l_table_owner
744: , p_table_name => l_table_name
745: , x_errbuf => x_errbuf

Line 821: l_table_name := 'OKI_SALES_K_HDRS' ;

817: -- Truncate failed, exit immediately.
818: RAISE l_excp_exit_immediate ;
819: END IF ;
820:
821: l_table_name := 'OKI_SALES_K_HDRS' ;
822: l_loc := 'Updating OKI_REFRESHS for || l_table_name' ;
823: -- update oki_refreshes
824: update_oki_refresh( p_object_name => l_table_name
825: , p_job_run_id => l_job_run_id

Line 1082: FROM oki_sales_k_hdrs shd

1078: , NULL
1079: , g_request_id
1080: , NULL --Major Version
1081: , NULL --Minor Version
1082: FROM oki_sales_k_hdrs shd
1083: MINUS
1084: SELECT
1085: p_job_run_id
1086: , khr.id

Line 1205: -- contracts to be inserted into OKI_SALES_K_HDRS table during inital load.

1201: /****************11510 changes for currency conversion new Procedure***********/
1202: ---------------------------------------------------------------------
1203: -- procedure initial_load_job_run_dtl
1204: -- Insert into the oki_job_run_dtl the list of
1205: -- contracts to be inserted into OKI_SALES_K_HDRS table during inital load.
1206: -- This table stores both the functional as well as base conversion rates for
1207: -- all the contracts inserted
1208: ---------------------------------------------------------------------
1209:

Line 1214: TYPE chr_id_tab_typ IS TABLE OF oki_sales_k_hdrs.chr_id%TYPE INDEX BY BINARY_INTEGER;

1210: PROCEDURE initial_load_job_run_dtl( p_job_run_id IN NUMBER
1211: , p_job_curr_start_date IN DATE
1212: , p_job_curr_end_date IN DATE
1213: ,x_retcode OUT NOCOPY VARCHAR2) IS
1214: TYPE chr_id_tab_typ IS TABLE OF oki_sales_k_hdrs.chr_id%TYPE INDEX BY BINARY_INTEGER;
1215: TYPE version_number_tab_typ IS TABLE OF oki_sales_k_hdrs.major_version%TYPE INDEX BY BINARY_INTEGER;
1216: TYPE date_tab_typ IS TABLE OF oki_sales_k_hdrs.start_date%TYPE INDEX BY BINARY_INTEGER;
1217: TYPE currency_tab_typ IS TABLE OF oki_sales_k_hdrs.currency_code%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE rate_tab_typ IS TABLE OF gl_daily_rates.conversion_rate%TYPE INDEX BY BINARY_INTEGER;

Line 1215: TYPE version_number_tab_typ IS TABLE OF oki_sales_k_hdrs.major_version%TYPE INDEX BY BINARY_INTEGER;

1211: , p_job_curr_start_date IN DATE
1212: , p_job_curr_end_date IN DATE
1213: ,x_retcode OUT NOCOPY VARCHAR2) IS
1214: TYPE chr_id_tab_typ IS TABLE OF oki_sales_k_hdrs.chr_id%TYPE INDEX BY BINARY_INTEGER;
1215: TYPE version_number_tab_typ IS TABLE OF oki_sales_k_hdrs.major_version%TYPE INDEX BY BINARY_INTEGER;
1216: TYPE date_tab_typ IS TABLE OF oki_sales_k_hdrs.start_date%TYPE INDEX BY BINARY_INTEGER;
1217: TYPE currency_tab_typ IS TABLE OF oki_sales_k_hdrs.currency_code%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE rate_tab_typ IS TABLE OF gl_daily_rates.conversion_rate%TYPE INDEX BY BINARY_INTEGER;
1219:

Line 1216: TYPE date_tab_typ IS TABLE OF oki_sales_k_hdrs.start_date%TYPE INDEX BY BINARY_INTEGER;

1212: , p_job_curr_end_date IN DATE
1213: ,x_retcode OUT NOCOPY VARCHAR2) IS
1214: TYPE chr_id_tab_typ IS TABLE OF oki_sales_k_hdrs.chr_id%TYPE INDEX BY BINARY_INTEGER;
1215: TYPE version_number_tab_typ IS TABLE OF oki_sales_k_hdrs.major_version%TYPE INDEX BY BINARY_INTEGER;
1216: TYPE date_tab_typ IS TABLE OF oki_sales_k_hdrs.start_date%TYPE INDEX BY BINARY_INTEGER;
1217: TYPE currency_tab_typ IS TABLE OF oki_sales_k_hdrs.currency_code%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE rate_tab_typ IS TABLE OF gl_daily_rates.conversion_rate%TYPE INDEX BY BINARY_INTEGER;
1219:
1220: TYPE sob_acct_period_tab_typ IS TABLE OF gl_sets_of_books.accounted_period_type%TYPE INDEX BY BINARY_INTEGER;

Line 1217: TYPE currency_tab_typ IS TABLE OF oki_sales_k_hdrs.currency_code%TYPE INDEX BY BINARY_INTEGER;

1213: ,x_retcode OUT NOCOPY VARCHAR2) IS
1214: TYPE chr_id_tab_typ IS TABLE OF oki_sales_k_hdrs.chr_id%TYPE INDEX BY BINARY_INTEGER;
1215: TYPE version_number_tab_typ IS TABLE OF oki_sales_k_hdrs.major_version%TYPE INDEX BY BINARY_INTEGER;
1216: TYPE date_tab_typ IS TABLE OF oki_sales_k_hdrs.start_date%TYPE INDEX BY BINARY_INTEGER;
1217: TYPE currency_tab_typ IS TABLE OF oki_sales_k_hdrs.currency_code%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE rate_tab_typ IS TABLE OF gl_daily_rates.conversion_rate%TYPE INDEX BY BINARY_INTEGER;
1219:
1220: TYPE sob_acct_period_tab_typ IS TABLE OF gl_sets_of_books.accounted_period_type%TYPE INDEX BY BINARY_INTEGER;
1221: TYPE sob_id_tab_typ IS TABLE OF gl_sets_of_books.set_of_books_id%TYPE INDEX BY BINARY_INTEGER;

Line 2342: -- Procedure to load data into oki_sales_k_hdrs

2338: END refresh_daily_rates;
2339:
2340: ---------------------------------------------------------------------
2341: --
2342: -- Procedure to load data into oki_sales_k_hdrs
2343: -- This procedure assumes the customer is always in HZ_PARTIES
2344: -- for a sell contract
2345: --
2346: ---------------------------------------------------------------------

Line 2386: OPEN index_info_csr('OKI_SALES_K_HDRS','OKI_SALES_K_HDRS_N1','OKI');

2382: l_init_job_run_date := fnd_conc_date.string_to_date('1900/01/01');
2383: l_sysdate := sysdate ;
2384:
2385: -- get representative index storage parms for later use
2386: OPEN index_info_csr('OKI_SALES_K_HDRS','OKI_SALES_K_HDRS_N1','OKI');
2387: FETCH index_info_csr INTO l_ind_rec;
2388: CLOSE index_info_csr;
2389: l_errpos := 1;
2390:

Line 2392: OPEN index_name_csr('OKI_SALES_K_HDRS');

2388: CLOSE index_info_csr;
2389: l_errpos := 1;
2390:
2391: -- drop indexes
2392: OPEN index_name_csr('OKI_SALES_K_HDRS');
2393: FETCH index_name_csr BULK COLLECT INTO l_index_tab;
2394: CLOSE index_name_csr;
2395:
2396: IF l_index_tab.first IS NOT NULL THEN

Line 2406: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SALES_K_HDRS';

2402:
2403: l_errpos := 2;
2404:
2405: -- truncate table
2406: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SALES_K_HDRS';
2407: EXECUTE IMMEDIATE l_sql_string;
2408: l_errpos := 3;
2409:
2410: /*

Line 2450: INSERT /+ append / INTO oki_sales_k_hdrs

2446:
2447: l_errpos := 4;
2448:
2449: -- insert data
2450: INSERT /*+ append */ INTO oki_sales_k_hdrs
2451: (
2452: chr_id,
2453: contract_number,
2454: contract_number_modifier,

Line 2712: UPDATE oki_sales_k_hdrs shd

2708: l_errpos := 5;
2709:
2710: /* 11510 Changes..
2711:
2712: UPDATE oki_sales_k_hdrs shd
2713: SET (close_period_num
2714: ,close_period_name
2715: ,close_quarter
2716: ,close_year) =

Line 2735: UPDATE oki_sales_k_hdrs shd

2731:
2732: l_errpos := 5.5;
2733:
2734:
2735: UPDATE oki_sales_k_hdrs shd
2736: SET (terminated_amount
2737: ,sob_terminated_amount
2738: ,base_terminated_amount) = (
2739: SELECT -SUM(bcl.amount),

Line 2752: create_indicies(p_object_name => 'OKI_SALES_K_HDRS'

2748: COMMIT;
2749: */
2750: l_errpos := 6;
2751: -- recreate indexes
2752: create_indicies(p_object_name => 'OKI_SALES_K_HDRS'
2753: ,p_parm_rec => l_ind_rec);
2754:
2755: /* Fetches distinct qualifiers before issuing update with subquery. */
2756: l_errpos := 6.25;

Line 2759: ,tabname => 'OKI_SALES_K_HDRS',percent=> 10);

2755: /* Fetches distinct qualifiers before issuing update with subquery. */
2756: l_errpos := 6.25;
2757: -- analyze table
2758: fnd_stats.gather_table_stats(ownname => 'OKI'
2759: ,tabname => 'OKI_SALES_K_HDRS',percent=> 10);
2760:
2761: l_errpos := 7;
2762:
2763: -- alter table back

Line 2764: l_sql_string := 'ALTER TABLE OKI.OKI_SALES_K_HDRS NOPARALLEL';

2760:
2761: l_errpos := 7;
2762:
2763: -- alter table back
2764: l_sql_string := 'ALTER TABLE OKI.OKI_SALES_K_HDRS NOPARALLEL';
2765: EXECUTE IMMEDIATE l_sql_string;
2766: l_errpos := 8;
2767:
2768: -- update oki_refreshes

Line 2769: update_oki_refresh( p_object_name => 'OKI_SALES_K_HDRS'

2765: EXECUTE IMMEDIATE l_sql_string;
2766: l_errpos := 8;
2767:
2768: -- update oki_refreshes
2769: update_oki_refresh( p_object_name => 'OKI_SALES_K_HDRS'
2770: , p_job_run_id => l_job_run_id
2771: , x_retcode => retcode);
2772: COMMIT;
2773: IF retcode = '2' THEN

Line 2784: ,value => 'OKI_SALES_K_HDRS');

2780:
2781: fnd_message.set_name(application => 'OKI'
2782: ,name => 'OKI_TABLE_LOAD_SUCCESS');
2783: fnd_message.set_token(token => 'TABLE_NAME'
2784: ,value => 'OKI_SALES_K_HDRS');
2785: fnd_file.put_line(which => fnd_file.log
2786: ,buff => fnd_message.get);
2787: l_errpos := 11;
2788:

Line 2794: ,value => 'OKI_SALES_K_HDRS');

2790: when l_no_update_refresh then
2791: fnd_message.set_name(application => 'OKI'
2792: ,name => 'OKI_TABLE_LOAD_FAILURE');
2793: fnd_message.set_token(token => 'TABLE_NAME'
2794: ,value => 'OKI_SALES_K_HDRS');
2795: fnd_file.put_line(which => fnd_file.log
2796: ,buff => fnd_message.get);
2797:
2798: fnd_file.put_line(which => fnd_file.log

Line 2808: , value => 'OKI_SALES_K_HDRS');

2804: retcode := '2';
2805: fnd_message.set_name( application => 'OKI'
2806: , name => 'OKI_TABLE_LOAD_FAILURE');
2807: fnd_message.set_token( token => 'TABLE_NAME'
2808: , value => 'OKI_SALES_K_HDRS');
2809: fnd_file.put_line( which => fnd_file.log
2810: , buff => fnd_message.get);
2811: fnd_file.put_line( which => fnd_file.log
2812: , buff => l_sqlcode || ' ' || l_sqlerrm);

Line 2815: create_indicies(p_object_name => 'OKI_SALES_K_HDRS'

2811: fnd_file.put_line( which => fnd_file.log
2812: , buff => l_sqlcode || ' ' || l_sqlerrm);
2813: -- try to get indexes back
2814: IF l_errpos < 6 THEN
2815: create_indicies(p_object_name => 'OKI_SALES_K_HDRS'
2816: ,p_parm_rec => l_ind_rec);
2817: ELSIF(l_errpos = 6 ) THEN
2818: -- truncate table
2819: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SALES_K_HDRS';

Line 2819: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SALES_K_HDRS';

2815: create_indicies(p_object_name => 'OKI_SALES_K_HDRS'
2816: ,p_parm_rec => l_ind_rec);
2817: ELSIF(l_errpos = 6 ) THEN
2818: -- truncate table
2819: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SALES_K_HDRS';
2820: EXECUTE IMMEDIATE l_sql_string;
2821: END IF;
2822:
2823: END refresh_sales_k_hdrs;

Line 2827: -- Procedure to load data into oki_sales_k_hdrs without a

2823: END refresh_sales_k_hdrs;
2824:
2825: ---------------------------------------------------------------------
2826: --
2827: -- Procedure to load data into oki_sales_k_hdrs without a
2828: -- complete refresh. This procedure assumes the customer is always
2829: -- in HZ_PARTIES for a sell contract
2830: --
2831: ---------------------------------------------------------------------

Line 2861: l_table_name := 'OKI_SALES_K_HDRS';

2857: l_table_name VARCHAR2(30) ;
2858:
2859: BEGIN
2860: l_retcode := '0' ;
2861: l_table_name := 'OKI_SALES_K_HDRS';
2862: l_loc := 'Calling process_refresh_check.' ;
2863:
2864: process_refresh_check(
2865: p_object_name => l_table_name

Line 2903: DELETE FROM oki_sales_k_hdrs shd

2899: RAISE l_excp_exit_immediate ;
2900: END IF ;
2901:
2902: l_loc := 'Deleting from ' || l_table_name ;
2903: DELETE FROM oki_sales_k_hdrs shd
2904: WHERE chr_id in ( SELECT /*+ index_ffs(jrd oki_job_run_dtl_u1)*/
2905: jrd.chr_id
2906: FROM oki_job_run_dtl jrd
2907: WHERE jrd.job_run_id = l_job_run_id ) ;

Line 2910: l_loc := 'Populating Table oki_sales_k_hdrs ' ;

2906: FROM oki_job_run_dtl jrd
2907: WHERE jrd.job_run_id = l_job_run_id ) ;
2908:
2909:
2910: l_loc := 'Populating Table oki_sales_k_hdrs ' ;
2911: INSERT INTO oki_sales_k_hdrs (
2912: chr_id
2913: , contract_number
2914: , contract_number_modifier

Line 2911: INSERT INTO oki_sales_k_hdrs (

2907: WHERE jrd.job_run_id = l_job_run_id ) ;
2908:
2909:
2910: l_loc := 'Populating Table oki_sales_k_hdrs ' ;
2911: INSERT INTO oki_sales_k_hdrs (
2912: chr_id
2913: , contract_number
2914: , contract_number_modifier
2915: , complete_contract_number

Line 3172: l_loc := 'Updating Table oki_sales_k_hdrs with forecast period details ' ;

3168: /* 11510 Changes End */
3169:
3170:
3171: /*
3172: l_loc := 'Updating Table oki_sales_k_hdrs with forecast period details ' ;
3173: UPDATE oki_sales_k_hdrs shd
3174: SET (close_period_num
3175: ,close_period_name
3176: ,close_quarter

Line 3173: UPDATE oki_sales_k_hdrs shd

3169:
3170:
3171: /*
3172: l_loc := 'Updating Table oki_sales_k_hdrs with forecast period details ' ;
3173: UPDATE oki_sales_k_hdrs shd
3174: SET (close_period_num
3175: ,close_period_name
3176: ,close_quarter
3177: ,close_year) =

Line 3199: l_loc := 'Updating Table oki_sales_k_hdrs with termination amount details ' ;

3195: )
3196: AND shd.close_date IS NOT NULL;
3197: COMMIT;
3198:
3199: l_loc := 'Updating Table oki_sales_k_hdrs with termination amount details ' ;
3200:
3201:
3202: UPDATE oki_sales_k_hdrs shd
3203: SET (terminated_amount

Line 3202: UPDATE oki_sales_k_hdrs shd

3198:
3199: l_loc := 'Updating Table oki_sales_k_hdrs with termination amount details ' ;
3200:
3201:
3202: UPDATE oki_sales_k_hdrs shd
3203: SET (terminated_amount
3204: ,sob_terminated_amount
3205: ,base_terminated_amount) = (
3206: SELECT -SUM(bcl.amount),

Line 3264: ,value => 'OKI_SALES_K_HDRS');

3260: WHEN l_no_update_refresh then
3261: fnd_message.set_name(application => 'OKI'
3262: ,name => 'OKI_TABLE_LOAD_FAILURE');
3263: fnd_message.set_token(token => 'TABLE_NAME'
3264: ,value => 'OKI_SALES_K_HDRS');
3265: fnd_file.put_line(which => fnd_file.log
3266: ,buff => fnd_message.get);
3267:
3268: fnd_file.put_line(which => fnd_file.log

Line 3279: , value => 'OKI_SALES_K_HDRS' ) ;

3275:
3276: fnd_message.set_name( application => 'OKI'
3277: , name => 'OKI_TABLE_LOAD_FAILURE' ) ;
3278: fnd_message.set_token( token => 'TABLE_NAME'
3279: , value => 'OKI_SALES_K_HDRS' ) ;
3280: fnd_file.put_line( which => fnd_file.log
3281: , buff => fnd_message.get ) ;
3282:
3283: -- Log the location within the procedure where the error occurred

Line 3524: ,oki_sales_k_hdrs shd

3520: ,cle.bill_to_site_use_id -- 11510 Changes
3521: ,cle.ship_to_site_use_id -- 11510 Changes
3522: FROM
3523: okc_k_lines_b cle
3524: ,oki_sales_k_hdrs shd
3525: ,okc_k_items cim
3526: ,okc_statuses_b sts
3527: ,oki_job_run_dtl jrd -- 11510 Changes
3528: WHERE 1=1

Line 3816: , oki_sales_k_hdrs shd

3812: , cle.bill_to_site_use_id -- 11510 Changes
3813: , cle.ship_to_site_use_id -- 11510 Changes
3814: FROM
3815: okc_k_lines_b cle
3816: , oki_sales_k_hdrs shd
3817: , okc_k_items cim
3818: , okc_statuses_b sts
3819: , oki_job_run_dtl jrd
3820: WHERE 1=1

Line 4796: oki_sales_k_hdrs shd

4792: ,ctt.attribute13
4793: ,ctt.attribute14
4794: ,ctt.attribute15
4795: FROM
4796: oki_sales_k_hdrs shd
4797: ,okc_contacts ctt
4798: WHERE 1=1
4799: AND ctt.cro_code = l_salesperson_code -- 11510 Changes
4800: AND ctt.dnz_chr_id = shd.chr_id

Line 5021: oki_sales_k_hdrs shd

5017: , ctt.attribute13
5018: , ctt.attribute14
5019: , ctt.attribute15
5020: FROM
5021: oki_sales_k_hdrs shd
5022: , okc_contacts ctt
5023: , oki_job_run_dtl jrd
5024: WHERE 1=1
5025: AND ctt.cro_code = l_salesperson_code -- 11510 Changes

Line 5313: from oki_job_run_dtl jrd, oki_sales_k_hdrs shd

5309: FROM oki_cov_prd_lines cpl
5310: where cpl.parent_cle_id = sil.cle_id
5311: )
5312: where sil.chr_id in (select shd.chr_id
5313: from oki_job_run_dtl jrd, oki_sales_k_hdrs shd
5314: where 1 =1
5315: and jrd.action_flag = 'I'
5316: and jrd.job_run_id = l_job_run_id
5317: and jrd.chr_id = shd.chr_id