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.OZF_CHECK_DUP_PROD_PVT dependencies on FND_DSQL

Line 69: FND_DSQL.add_text('SELECT TO_NUMBER(');

65: CLOSE c_get_sql;
66: -- special case, for item only.
67: IF l_stmt_1 is not null then
68: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN
69: FND_DSQL.add_text('SELECT TO_NUMBER(');
70: FND_DSQL.add_bind(p_attr_value);
71: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
72: ELSE
73: FND_DSQL.add_text(' ' || l_stmt_1);

Line 70: FND_DSQL.add_bind(p_attr_value);

66: -- special case, for item only.
67: IF l_stmt_1 is not null then
68: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN
69: FND_DSQL.add_text('SELECT TO_NUMBER(');
70: FND_DSQL.add_bind(p_attr_value);
71: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
72: ELSE
73: FND_DSQL.add_text(' ' || l_stmt_1);
74: END IF;

Line 71: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');

67: IF l_stmt_1 is not null then
68: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN
69: FND_DSQL.add_text('SELECT TO_NUMBER(');
70: FND_DSQL.add_bind(p_attr_value);
71: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
72: ELSE
73: FND_DSQL.add_text(' ' || l_stmt_1);
74: END IF;
75:

Line 73: FND_DSQL.add_text(' ' || l_stmt_1);

69: FND_DSQL.add_text('SELECT TO_NUMBER(');
70: FND_DSQL.add_bind(p_attr_value);
71: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
72: ELSE
73: FND_DSQL.add_text(' ' || l_stmt_1);
74: END IF;
75:
76: FND_DSQL.add_text(' ' || l_stmt_2);
77: FND_DSQL.add_text(' ' || l_stmt_3);

Line 76: FND_DSQL.add_text(' ' || l_stmt_2);

72: ELSE
73: FND_DSQL.add_text(' ' || l_stmt_1);
74: END IF;
75:
76: FND_DSQL.add_text(' ' || l_stmt_2);
77: FND_DSQL.add_text(' ' || l_stmt_3);
78: FND_DSQL.add_text(' ' || l_stmt_4);
79: FND_DSQL.add_text(' ' || l_stmt_5);
80: FND_DSQL.add_text(' ' || l_stmt_6);

Line 77: FND_DSQL.add_text(' ' || l_stmt_3);

73: FND_DSQL.add_text(' ' || l_stmt_1);
74: END IF;
75:
76: FND_DSQL.add_text(' ' || l_stmt_2);
77: FND_DSQL.add_text(' ' || l_stmt_3);
78: FND_DSQL.add_text(' ' || l_stmt_4);
79: FND_DSQL.add_text(' ' || l_stmt_5);
80: FND_DSQL.add_text(' ' || l_stmt_6);
81: FND_DSQL.add_text(' ' || l_stmt_7);

Line 78: FND_DSQL.add_text(' ' || l_stmt_4);

74: END IF;
75:
76: FND_DSQL.add_text(' ' || l_stmt_2);
77: FND_DSQL.add_text(' ' || l_stmt_3);
78: FND_DSQL.add_text(' ' || l_stmt_4);
79: FND_DSQL.add_text(' ' || l_stmt_5);
80: FND_DSQL.add_text(' ' || l_stmt_6);
81: FND_DSQL.add_text(' ' || l_stmt_7);
82: FND_DSQL.add_text(' ' || l_stmt_8);

Line 79: FND_DSQL.add_text(' ' || l_stmt_5);

75:
76: FND_DSQL.add_text(' ' || l_stmt_2);
77: FND_DSQL.add_text(' ' || l_stmt_3);
78: FND_DSQL.add_text(' ' || l_stmt_4);
79: FND_DSQL.add_text(' ' || l_stmt_5);
80: FND_DSQL.add_text(' ' || l_stmt_6);
81: FND_DSQL.add_text(' ' || l_stmt_7);
82: FND_DSQL.add_text(' ' || l_stmt_8);
83:

Line 80: FND_DSQL.add_text(' ' || l_stmt_6);

76: FND_DSQL.add_text(' ' || l_stmt_2);
77: FND_DSQL.add_text(' ' || l_stmt_3);
78: FND_DSQL.add_text(' ' || l_stmt_4);
79: FND_DSQL.add_text(' ' || l_stmt_5);
80: FND_DSQL.add_text(' ' || l_stmt_6);
81: FND_DSQL.add_text(' ' || l_stmt_7);
82: FND_DSQL.add_text(' ' || l_stmt_8);
83:
84: IF l_cond_id IS NOT NULL THEN

Line 81: FND_DSQL.add_text(' ' || l_stmt_7);

77: FND_DSQL.add_text(' ' || l_stmt_3);
78: FND_DSQL.add_text(' ' || l_stmt_4);
79: FND_DSQL.add_text(' ' || l_stmt_5);
80: FND_DSQL.add_text(' ' || l_stmt_6);
81: FND_DSQL.add_text(' ' || l_stmt_7);
82: FND_DSQL.add_text(' ' || l_stmt_8);
83:
84: IF l_cond_id IS NOT NULL THEN
85: IF INSTR(UPPER(l_stmt_1),'WHERE') > 0 OR INSTR(UPPER(l_stmt_2),'WHERE') > 0

Line 82: FND_DSQL.add_text(' ' || l_stmt_8);

78: FND_DSQL.add_text(' ' || l_stmt_4);
79: FND_DSQL.add_text(' ' || l_stmt_5);
80: FND_DSQL.add_text(' ' || l_stmt_6);
81: FND_DSQL.add_text(' ' || l_stmt_7);
82: FND_DSQL.add_text(' ' || l_stmt_8);
83:
84: IF l_cond_id IS NOT NULL THEN
85: IF INSTR(UPPER(l_stmt_1),'WHERE') > 0 OR INSTR(UPPER(l_stmt_2),'WHERE') > 0
86: OR INSTR(UPPER(l_stmt_3),'WHERE') > 0 OR INSTR(UPPER(l_stmt_4),'WHERE') > 0

Line 89: FND_DSQL.add_text(' AND ');

85: IF INSTR(UPPER(l_stmt_1),'WHERE') > 0 OR INSTR(UPPER(l_stmt_2),'WHERE') > 0
86: OR INSTR(UPPER(l_stmt_3),'WHERE') > 0 OR INSTR(UPPER(l_stmt_4),'WHERE') > 0
87: OR INSTR(UPPER(l_stmt_5),'WHERE') > 0 OR INSTR(UPPER(l_stmt_6),'WHERE') > 0
88: OR INSTR(UPPER(l_stmt_7),'WHERE') > 0 OR INSTR(UPPER(l_stmt_8),'WHERE') > 0 THEN
89: FND_DSQL.add_text(' AND ');
90: FND_DSQL.add_text(l_cond_id);
91: FND_DSQL.add_text(' = ');
92: FND_DSQL.add_bind(p_attr_value);
93: ELSE -- no WHERE clause, need to add WHERE

Line 90: FND_DSQL.add_text(l_cond_id);

86: OR INSTR(UPPER(l_stmt_3),'WHERE') > 0 OR INSTR(UPPER(l_stmt_4),'WHERE') > 0
87: OR INSTR(UPPER(l_stmt_5),'WHERE') > 0 OR INSTR(UPPER(l_stmt_6),'WHERE') > 0
88: OR INSTR(UPPER(l_stmt_7),'WHERE') > 0 OR INSTR(UPPER(l_stmt_8),'WHERE') > 0 THEN
89: FND_DSQL.add_text(' AND ');
90: FND_DSQL.add_text(l_cond_id);
91: FND_DSQL.add_text(' = ');
92: FND_DSQL.add_bind(p_attr_value);
93: ELSE -- no WHERE clause, need to add WHERE
94: FND_DSQL.add_text(' WHERE ');

Line 91: FND_DSQL.add_text(' = ');

87: OR INSTR(UPPER(l_stmt_5),'WHERE') > 0 OR INSTR(UPPER(l_stmt_6),'WHERE') > 0
88: OR INSTR(UPPER(l_stmt_7),'WHERE') > 0 OR INSTR(UPPER(l_stmt_8),'WHERE') > 0 THEN
89: FND_DSQL.add_text(' AND ');
90: FND_DSQL.add_text(l_cond_id);
91: FND_DSQL.add_text(' = ');
92: FND_DSQL.add_bind(p_attr_value);
93: ELSE -- no WHERE clause, need to add WHERE
94: FND_DSQL.add_text(' WHERE ');
95: FND_DSQL.add_text(l_cond_id);

Line 92: FND_DSQL.add_bind(p_attr_value);

88: OR INSTR(UPPER(l_stmt_7),'WHERE') > 0 OR INSTR(UPPER(l_stmt_8),'WHERE') > 0 THEN
89: FND_DSQL.add_text(' AND ');
90: FND_DSQL.add_text(l_cond_id);
91: FND_DSQL.add_text(' = ');
92: FND_DSQL.add_bind(p_attr_value);
93: ELSE -- no WHERE clause, need to add WHERE
94: FND_DSQL.add_text(' WHERE ');
95: FND_DSQL.add_text(l_cond_id);
96: FND_DSQL.add_text(' = ');

Line 94: FND_DSQL.add_text(' WHERE ');

90: FND_DSQL.add_text(l_cond_id);
91: FND_DSQL.add_text(' = ');
92: FND_DSQL.add_bind(p_attr_value);
93: ELSE -- no WHERE clause, need to add WHERE
94: FND_DSQL.add_text(' WHERE ');
95: FND_DSQL.add_text(l_cond_id);
96: FND_DSQL.add_text(' = ');
97: FND_DSQL.add_bind(p_attr_value);
98: END IF;

Line 95: FND_DSQL.add_text(l_cond_id);

91: FND_DSQL.add_text(' = ');
92: FND_DSQL.add_bind(p_attr_value);
93: ELSE -- no WHERE clause, need to add WHERE
94: FND_DSQL.add_text(' WHERE ');
95: FND_DSQL.add_text(l_cond_id);
96: FND_DSQL.add_text(' = ');
97: FND_DSQL.add_bind(p_attr_value);
98: END IF;
99: END IF;

Line 96: FND_DSQL.add_text(' = ');

92: FND_DSQL.add_bind(p_attr_value);
93: ELSE -- no WHERE clause, need to add WHERE
94: FND_DSQL.add_text(' WHERE ');
95: FND_DSQL.add_text(l_cond_id);
96: FND_DSQL.add_text(' = ');
97: FND_DSQL.add_bind(p_attr_value);
98: END IF;
99: END IF;
100: l_stmt := FND_DSQL.get_text(FALSE);

Line 97: FND_DSQL.add_bind(p_attr_value);

93: ELSE -- no WHERE clause, need to add WHERE
94: FND_DSQL.add_text(' WHERE ');
95: FND_DSQL.add_text(l_cond_id);
96: FND_DSQL.add_text(' = ');
97: FND_DSQL.add_bind(p_attr_value);
98: END IF;
99: END IF;
100: l_stmt := FND_DSQL.get_text(FALSE);
101: ELSE

Line 100: l_stmt := FND_DSQL.get_text(FALSE);

96: FND_DSQL.add_text(' = ');
97: FND_DSQL.add_bind(p_attr_value);
98: END IF;
99: END IF;
100: l_stmt := FND_DSQL.get_text(FALSE);
101: ELSE
102: l_stmt := NULL;
103: END IF;
104:

Line 202: FND_DSQL.init;

198:
199: FOR l_pbh_line IN c_pbh_lines LOOP
200: FOR l_product IN c_products(l_pbh_line.offer_discount_line_id, 'N') LOOP
201: l_stmt_temp := NULL;
202: FND_DSQL.init;
203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');

Line 203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');

199: FOR l_pbh_line IN c_pbh_lines LOOP
200: FOR l_product IN c_products(l_pbh_line.offer_discount_line_id, 'N') LOOP
201: l_stmt_temp := NULL;
202: FND_DSQL.init;
203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

Line 204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');

200: FOR l_product IN c_products(l_pbh_line.offer_discount_line_id, 'N') LOOP
201: l_stmt_temp := NULL;
202: FND_DSQL.init;
203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
208: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');

Line 205: FND_DSQL.add_text('last_updated_by,last_update_login,');

201: l_stmt_temp := NULL;
202: FND_DSQL.init;
203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
208: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
209: FND_DSQL.add_text('product_id,product_type');

Line 206: FND_DSQL.add_text('product_id,product_type) ');

202: FND_DSQL.init;
203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
208: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
209: FND_DSQL.add_text('product_id,product_type');
210: FND_DSQL.add_text(' FROM (');

Line 207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
208: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
209: FND_DSQL.add_text('product_id,product_type');
210: FND_DSQL.add_text(' FROM (');
211:

Line 208: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');

204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
208: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
209: FND_DSQL.add_text('product_id,product_type');
210: FND_DSQL.add_text(' FROM (');
211:
212: l_stmt_temp := get_sql(p_context => l_product.product_context

Line 209: FND_DSQL.add_text('product_id,product_type');

205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
208: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
209: FND_DSQL.add_text('product_id,product_type');
210: FND_DSQL.add_text(' FROM (');
211:
212: l_stmt_temp := get_sql(p_context => l_product.product_context
213: ,p_attribute => l_product.product_attribute

Line 210: FND_DSQL.add_text(' FROM (');

206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
208: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
209: FND_DSQL.add_text('product_id,product_type');
210: FND_DSQL.add_text(' FROM (');
211:
212: l_stmt_temp := get_sql(p_context => l_product.product_context
213: ,p_attribute => l_product.product_attribute
214: ,p_attr_value => l_product.product_attr_value

Line 217: FND_DSQL.add_text(')');

213: ,p_attribute => l_product.product_attribute
214: ,p_attr_value => l_product.product_attr_value
215: );
216:
217: FND_DSQL.add_text(')');
218:
219: IF l_stmt_temp IS NULL THEN
220: EXIT;
221: END IF;

Line 224: FND_DSQL.set_cursor(l_denorm_csr);

220: EXIT;
221: END IF;
222:
223: l_denorm_csr := DBMS_SQL.open_cursor;
224: FND_DSQL.set_cursor(l_denorm_csr);
225: l_stmt_denorm := FND_DSQL.get_text(FALSE);
226:
227: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
228: FND_DSQL.do_binds;

Line 225: l_stmt_denorm := FND_DSQL.get_text(FALSE);

221: END IF;
222:
223: l_denorm_csr := DBMS_SQL.open_cursor;
224: FND_DSQL.set_cursor(l_denorm_csr);
225: l_stmt_denorm := FND_DSQL.get_text(FALSE);
226:
227: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
228: FND_DSQL.do_binds;
229: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 228: FND_DSQL.do_binds;

224: FND_DSQL.set_cursor(l_denorm_csr);
225: l_stmt_denorm := FND_DSQL.get_text(FALSE);
226:
227: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
228: FND_DSQL.do_binds;
229: l_ignore := DBMS_SQL.execute(l_denorm_csr);
230: dbms_sql.close_cursor(l_denorm_csr);
231: END LOOP;
232: /*

Line 240: FND_DSQL.add_text(' MINUS (');

236:
237: l_excl_index := 1;
238:
239: IF l_products_count > 0 THEN -- start: sql for exclusions
240: FND_DSQL.add_text(' MINUS (');
241:
242: FOR l_product IN c_products(l_pbh_line.offer_discount_line_id, 'Y') LOOP
243: l_stmt_temp := NULL;
244:

Line 254: FND_DSQL.add_text(' UNION ');

250: IF l_stmt_temp IS NULL THEN
251: l_no_query_flag := 'Y';
252: ELSE
253: IF l_excl_index < l_products_count THEN
254: FND_DSQL.add_text(' UNION ');
255: l_excl_index := l_excl_index + 1;
256: END IF;
257: END IF;
258: END LOOP;

Line 260: FND_DSQL.add_text(')');

256: END IF;
257: END IF;
258: END LOOP;
259:
260: FND_DSQL.add_text(')');
261: END IF; -- end: sql for exclusions
262:
263: FND_DSQL.add_text(')');
264:

Line 263: FND_DSQL.add_text(')');

259:
260: FND_DSQL.add_text(')');
261: END IF; -- end: sql for exclusions
262:
263: FND_DSQL.add_text(')');
264:
265: IF l_pbh_index < l_pbh_lines_count THEN
266: FND_DSQL.add_text(' UNION ');
267: l_pbh_index := l_pbh_index + 1;

Line 266: FND_DSQL.add_text(' UNION ');

262:
263: FND_DSQL.add_text(')');
264:
265: IF l_pbh_index < l_pbh_lines_count THEN
266: FND_DSQL.add_text(' UNION ');
267: l_pbh_index := l_pbh_index + 1;
268: END IF;*/
269: END LOOP;
270:

Line 280: l_stmt_denorm := FND_DSQL.get_text(TRUE);

276: FND_MESSAGE.set_name('OZF', 'OZF_VO_PROD_STMT_FAILED');
277: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
278: FND_MSG_PUB.add;
279:
280: l_stmt_denorm := FND_DSQL.get_text(TRUE);
281: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
282: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
283: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));
284: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 751, 250));

Line 340: FND_DSQL.init;

336: THEN
337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339: /*
340: FND_DSQL.init;
341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');

Line 341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');

337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339: /*
340: FND_DSQL.init;
341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

Line 342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');

338: END IF;
339: /*
340: FND_DSQL.init;
341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
346: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');

Line 343: FND_DSQL.add_text('last_updated_by,last_update_login,');

339: /*
340: FND_DSQL.init;
341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
346: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
347: FND_DSQL.add_text('product_id,product_type');

Line 344: FND_DSQL.add_text('product_id,product_type) ');

340: FND_DSQL.init;
341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
346: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
347: FND_DSQL.add_text('product_id,product_type');
348: FND_DSQL.add_text(' FROM (');

Line 345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
346: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
347: FND_DSQL.add_text('product_id,product_type');
348: FND_DSQL.add_text(' FROM (');
349: */

Line 346: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');

342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
346: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
347: FND_DSQL.add_text('product_id,product_type');
348: FND_DSQL.add_text(' FROM (');
349: */
350: denorm_vo_products(p_api_version => l_api_version,

Line 347: FND_DSQL.add_text('product_id,product_type');

343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
346: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
347: FND_DSQL.add_text('product_id,product_type');
348: FND_DSQL.add_text(' FROM (');
349: */
350: denorm_vo_products(p_api_version => l_api_version,
351: p_init_msg_list => FND_API.g_true,

Line 348: FND_DSQL.add_text(' FROM (');

344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
346: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
347: FND_DSQL.add_text('product_id,product_type');
348: FND_DSQL.add_text(' FROM (');
349: */
350: denorm_vo_products(p_api_version => l_api_version,
351: p_init_msg_list => FND_API.g_true,
352: p_commit => FND_API.g_false,

Line 359: FND_DSQL.add_text(')');

355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_data,
357: x_product_stmt => l_stmt_product);
358: /*
359: FND_DSQL.add_text(')');
360:
361: ozf_utility_pvt.debug_message ('Denorm STMT status: ' || x_return_status);
362:
363: l_denorm_csr := DBMS_SQL.open_cursor;

Line 364: FND_DSQL.set_cursor(l_denorm_csr);

360:
361: ozf_utility_pvt.debug_message ('Denorm STMT status: ' || x_return_status);
362:
363: l_denorm_csr := DBMS_SQL.open_cursor;
364: FND_DSQL.set_cursor(l_denorm_csr);
365: l_stmt_denorm := FND_DSQL.get_text(FALSE);
366: ozf_utility_pvt.debug_message ('start STMT--------------------------------------------');
367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
368: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));

Line 365: l_stmt_denorm := FND_DSQL.get_text(FALSE);

361: ozf_utility_pvt.debug_message ('Denorm STMT status: ' || x_return_status);
362:
363: l_denorm_csr := DBMS_SQL.open_cursor;
364: FND_DSQL.set_cursor(l_denorm_csr);
365: l_stmt_denorm := FND_DSQL.get_text(FALSE);
366: ozf_utility_pvt.debug_message ('start STMT--------------------------------------------');
367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));
368: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 251, 250));
369: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 501, 250));

Line 377: FND_DSQL.do_binds;

373: RAISE FND_API.g_exc_unexpected_error;
374: END IF;
375:
376: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
377: FND_DSQL.do_binds;
378: l_ignore := DBMS_SQL.execute(l_denorm_csr);
379: dbms_sql.close_cursor(l_denorm_csr);
380: */
381: OPEN c_duplicate_prod_exists;