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_NET_ACCRUAL_ENGINE_PVT dependencies on FND_DSQL

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

302: l_line_index := 1;
303: -- Currently NA qualifiers does not support grouping, each group has only 1 line
304: l_no_lines := 1;
305: --
306: FND_DSQL.add_text('(');
307: --
308: FOR j IN c_qualifiers(i.qualifier_id)
309: LOOP
310: --

Line 329: FND_DSQL.add_text(' INTERSECT ');

325: --
326: IF l_line_index < l_no_lines
327: THEN
328: --
329: FND_DSQL.add_text(' INTERSECT ');
330: l_line_index := l_line_index + 1;
331: --
332: END IF;
333: --

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

334: END IF;
335: --
336: END LOOP; -- c_qualifiers
337: --
338: FND_DSQL.add_text(')');
339: --
340: IF l_group_index < l_no_groups
341: THEN
342: --

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

339: --
340: IF l_group_index < l_no_groups
341: THEN
342: --
343: FND_DSQL.add_text(' UNION ');
344: l_group_index := l_group_index + 1;
345: --
346: END IF;
347: --

Line 352: -- FND_DSQL.add_text('(SELECT -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');

348: END LOOP; -- c_groups
349: --
350: ELSE
351: --
352: -- FND_DSQL.add_text('(SELECT -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
353: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
354: --
355: END IF;
356:

Line 353: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');

349: --
350: ELSE
351: --
352: -- FND_DSQL.add_text('(SELECT -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
353: FND_DSQL.add_text('(SELECT -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id,-1 cust_account_id, -1 cust_acct_site_id, -1 site_use_id,'' '' site_use_code FROM DUAL)');
354: --
355: END IF;
356:
357: IF p_calling_from_den = 'N' OR l_no_query_flag = 'N'

Line 360: x_party_stmt := FND_DSQL.get_text(FALSE);

356:
357: IF p_calling_from_den = 'N' OR l_no_query_flag = 'N'
358: THEN
359: --
360: x_party_stmt := FND_DSQL.get_text(FALSE);
361: --
362: ELSE
363: --
364: x_party_stmt := NULL;

Line 416: FND_DSQL.init;

412: --
413: x_return_status := FND_API.g_ret_sts_success;
414:
415: -- denorm parties
416: FND_DSQL.init;
417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');
418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');

Line 417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');

413: x_return_status := FND_API.g_ret_sts_success;
414:
415: -- denorm parties
416: FND_DSQL.init;
417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');
418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');

Line 418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');

414:
415: -- denorm parties
416: FND_DSQL.init;
417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');
418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');

Line 419: FND_DSQL.add_text('last_update_login,confidential_flag,');

415: -- denorm parties
416: FND_DSQL.init;
417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');
418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');

Line 420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');

416: FND_DSQL.init;
417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');
418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

Line 421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');

417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');
418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');

Line 422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');

418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);

Line 423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');

419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');

Line 424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');

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

421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');
429: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');

Line 426: FND_DSQL.add_bind(p_offer_id);

422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');
429: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');
430: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');

Line 427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');

423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');
429: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');
430: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');
431: FND_DSQL.add_text(' FROM (');

Line 428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');

424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');
429: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');
430: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');
431: FND_DSQL.add_text(' FROM (');
432:

Line 429: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');

425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');
429: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');
430: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');
431: FND_DSQL.add_text(' FROM (');
432:
433:

Line 430: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');

426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');
429: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');
430: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');
431: FND_DSQL.add_text(' FROM (');
432:
433:
434: ozf_utility_pvt.write_conc_log('-- Refresh_Parties (+)');

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

427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');
429: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');
430: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');
431: FND_DSQL.add_text(' FROM (');
432:
433:
434: ozf_utility_pvt.write_conc_log('-- Refresh_Parties (+)');
435:

Line 436: /* refresh parties would get all the parties for the offer_id and add to FND_DSQL*/

432:
433:
434: ozf_utility_pvt.write_conc_log('-- Refresh_Parties (+)');
435:
436: /* refresh parties would get all the parties for the offer_id and add to FND_DSQL*/
437: refresh_parties(p_offer_id => p_offer_id,
438: p_calling_from_den => 'Y',
439: x_return_status => x_return_status,
440: x_msg_count => x_msg_count,

Line 454: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');

450:
451: IF l_stmt_offer IS NOT NULL
452: THEN
453: --
454: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
455: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
456: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');

Line 455: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');

451: IF l_stmt_offer IS NOT NULL
452: THEN
453: --
454: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
455: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
456: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');
459: FND_DSQL.add_bind(p_offer_id);

Line 456: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');

452: THEN
453: --
454: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
455: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
456: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');
459: FND_DSQL.add_bind(p_offer_id);
460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');

Line 457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');

453: --
454: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
455: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
456: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');
459: FND_DSQL.add_bind(p_offer_id);
460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');
461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');

Line 458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');

454: -- FND_DSQL.add_text(' UNION select -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
455: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
456: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');
459: FND_DSQL.add_bind(p_offer_id);
460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');
461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');
462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');

Line 459: FND_DSQL.add_bind(p_offer_id);

455: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group, -1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');
456: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');
459: FND_DSQL.add_bind(p_offer_id);
460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');
461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');
462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');
463: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');

Line 460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');

456: FND_DSQL.add_text(' to_number(qualifier_attr_value) site_use_id, ');
457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');
459: FND_DSQL.add_bind(p_offer_id);
460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');
461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');
462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');
463: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
464: FND_DSQL.add_text(')');

Line 461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');

457: FND_DSQL.add_text(' qualifier_context||'':''||qualifier_attribute site_use_code ');
458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');
459: FND_DSQL.add_bind(p_offer_id);
460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');
461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');
462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');
463: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
464: FND_DSQL.add_text(')');
465:

Line 462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');

458: FND_DSQL.add_text(' FROM ozf_offer_qualifiers WHERE offer_id = ');
459: FND_DSQL.add_bind(p_offer_id);
460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');
461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');
462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');
463: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
464: FND_DSQL.add_text(')');
465:
466: l_denorm_csr := DBMS_SQL.open_cursor;

Line 463: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');

459: FND_DSQL.add_bind(p_offer_id);
460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');
461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');
462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');
463: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
464: FND_DSQL.add_text(')');
465:
466: l_denorm_csr := DBMS_SQL.open_cursor;
467: FND_DSQL.set_cursor(l_denorm_csr);

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

460: FND_DSQL.add_text(' and qualifier_context||'':''||qualifier_attribute not in ');
461: FND_DSQL.add_text(' (''CUSTOMER:PRICING_ATTRIBUTE11'',''CUSTOMER:QUALIFIER_ATTRIBUTE14'')');
462: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'') ');
463: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
464: FND_DSQL.add_text(')');
465:
466: l_denorm_csr := DBMS_SQL.open_cursor;
467: FND_DSQL.set_cursor(l_denorm_csr);
468: l_stmt_debug := FND_DSQL.get_text(TRUE);

Line 467: FND_DSQL.set_cursor(l_denorm_csr);

463: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
464: FND_DSQL.add_text(')');
465:
466: l_denorm_csr := DBMS_SQL.open_cursor;
467: FND_DSQL.set_cursor(l_denorm_csr);
468: l_stmt_debug := FND_DSQL.get_text(TRUE);
469: l_stmt_denorm := FND_DSQL.get_text(FALSE);
470: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
471: FND_DSQL.do_binds;

Line 468: l_stmt_debug := FND_DSQL.get_text(TRUE);

464: FND_DSQL.add_text(')');
465:
466: l_denorm_csr := DBMS_SQL.open_cursor;
467: FND_DSQL.set_cursor(l_denorm_csr);
468: l_stmt_debug := FND_DSQL.get_text(TRUE);
469: l_stmt_denorm := FND_DSQL.get_text(FALSE);
470: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
471: FND_DSQL.do_binds;
472: l_ignore := DBMS_SQL.execute(l_denorm_csr);

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

465:
466: l_denorm_csr := DBMS_SQL.open_cursor;
467: FND_DSQL.set_cursor(l_denorm_csr);
468: l_stmt_debug := FND_DSQL.get_text(TRUE);
469: l_stmt_denorm := FND_DSQL.get_text(FALSE);
470: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
471: FND_DSQL.do_binds;
472: l_ignore := DBMS_SQL.execute(l_denorm_csr);
473: dbms_sql.close_cursor(l_denorm_csr);

Line 471: FND_DSQL.do_binds;

467: FND_DSQL.set_cursor(l_denorm_csr);
468: l_stmt_debug := FND_DSQL.get_text(TRUE);
469: l_stmt_denorm := FND_DSQL.get_text(FALSE);
470: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
471: FND_DSQL.do_binds;
472: l_ignore := DBMS_SQL.execute(l_denorm_csr);
473: dbms_sql.close_cursor(l_denorm_csr);
474: --
475: END IF;

Line 594: FND_DSQL.init;

590: END IF;
591: --
592: END IF;
593:
594: FND_DSQL.init;
595: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
596: FND_DSQL.add_text('SELECT inventory_item_id,');
597: FND_DSQL.add_bind(l_product.product_level);
598: FND_DSQL.add_text(',');

Line 595: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');

591: --
592: END IF;
593:
594: FND_DSQL.init;
595: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
596: FND_DSQL.add_text('SELECT inventory_item_id,');
597: FND_DSQL.add_bind(l_product.product_level);
598: FND_DSQL.add_text(',');
599: FND_DSQL.add_bind(l_discount);

Line 596: FND_DSQL.add_text('SELECT inventory_item_id,');

592: END IF;
593:
594: FND_DSQL.init;
595: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
596: FND_DSQL.add_text('SELECT inventory_item_id,');
597: FND_DSQL.add_bind(l_product.product_level);
598: FND_DSQL.add_text(',');
599: FND_DSQL.add_bind(l_discount);
600: FND_DSQL.add_text(',');

Line 597: FND_DSQL.add_bind(l_product.product_level);

593:
594: FND_DSQL.init;
595: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
596: FND_DSQL.add_text('SELECT inventory_item_id,');
597: FND_DSQL.add_bind(l_product.product_level);
598: FND_DSQL.add_text(',');
599: FND_DSQL.add_bind(l_discount);
600: FND_DSQL.add_text(',');
601: FND_DSQL.add_bind(l_discount_type);

Line 598: FND_DSQL.add_text(',');

594: FND_DSQL.init;
595: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
596: FND_DSQL.add_text('SELECT inventory_item_id,');
597: FND_DSQL.add_bind(l_product.product_level);
598: FND_DSQL.add_text(',');
599: FND_DSQL.add_bind(l_discount);
600: FND_DSQL.add_text(',');
601: FND_DSQL.add_bind(l_discount_type);
602: FND_DSQL.add_text(',');

Line 599: FND_DSQL.add_bind(l_discount);

595: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
596: FND_DSQL.add_text('SELECT inventory_item_id,');
597: FND_DSQL.add_bind(l_product.product_level);
598: FND_DSQL.add_text(',');
599: FND_DSQL.add_bind(l_discount);
600: FND_DSQL.add_text(',');
601: FND_DSQL.add_bind(l_discount_type);
602: FND_DSQL.add_text(',');
603: FND_DSQL.add_bind(l_volume_from);

Line 600: FND_DSQL.add_text(',');

596: FND_DSQL.add_text('SELECT inventory_item_id,');
597: FND_DSQL.add_bind(l_product.product_level);
598: FND_DSQL.add_text(',');
599: FND_DSQL.add_bind(l_discount);
600: FND_DSQL.add_text(',');
601: FND_DSQL.add_bind(l_discount_type);
602: FND_DSQL.add_text(',');
603: FND_DSQL.add_bind(l_volume_from);
604: FND_DSQL.add_text(',');

Line 601: FND_DSQL.add_bind(l_discount_type);

597: FND_DSQL.add_bind(l_product.product_level);
598: FND_DSQL.add_text(',');
599: FND_DSQL.add_bind(l_discount);
600: FND_DSQL.add_text(',');
601: FND_DSQL.add_bind(l_discount_type);
602: FND_DSQL.add_text(',');
603: FND_DSQL.add_bind(l_volume_from);
604: FND_DSQL.add_text(',');
605: FND_DSQL.add_bind(l_volume_to);

Line 602: FND_DSQL.add_text(',');

598: FND_DSQL.add_text(',');
599: FND_DSQL.add_bind(l_discount);
600: FND_DSQL.add_text(',');
601: FND_DSQL.add_bind(l_discount_type);
602: FND_DSQL.add_text(',');
603: FND_DSQL.add_bind(l_volume_from);
604: FND_DSQL.add_text(',');
605: FND_DSQL.add_bind(l_volume_to);
606: FND_DSQL.add_text(',');

Line 603: FND_DSQL.add_bind(l_volume_from);

599: FND_DSQL.add_bind(l_discount);
600: FND_DSQL.add_text(',');
601: FND_DSQL.add_bind(l_discount_type);
602: FND_DSQL.add_text(',');
603: FND_DSQL.add_bind(l_volume_from);
604: FND_DSQL.add_text(',');
605: FND_DSQL.add_bind(l_volume_to);
606: FND_DSQL.add_text(',');
607: FND_DSQL.add_bind(l_volume_type);

Line 604: FND_DSQL.add_text(',');

600: FND_DSQL.add_text(',');
601: FND_DSQL.add_bind(l_discount_type);
602: FND_DSQL.add_text(',');
603: FND_DSQL.add_bind(l_volume_from);
604: FND_DSQL.add_text(',');
605: FND_DSQL.add_bind(l_volume_to);
606: FND_DSQL.add_text(',');
607: FND_DSQL.add_bind(l_volume_type);
608: FND_DSQL.add_text(',');

Line 605: FND_DSQL.add_bind(l_volume_to);

601: FND_DSQL.add_bind(l_discount_type);
602: FND_DSQL.add_text(',');
603: FND_DSQL.add_bind(l_volume_from);
604: FND_DSQL.add_text(',');
605: FND_DSQL.add_bind(l_volume_to);
606: FND_DSQL.add_text(',');
607: FND_DSQL.add_bind(l_volume_type);
608: FND_DSQL.add_text(',');
609: FND_DSQL.add_bind(l_product.uom_code);

Line 606: FND_DSQL.add_text(',');

602: FND_DSQL.add_text(',');
603: FND_DSQL.add_bind(l_volume_from);
604: FND_DSQL.add_text(',');
605: FND_DSQL.add_bind(l_volume_to);
606: FND_DSQL.add_text(',');
607: FND_DSQL.add_bind(l_volume_type);
608: FND_DSQL.add_text(',');
609: FND_DSQL.add_bind(l_product.uom_code);
610: FND_DSQL.add_text(' FROM (');

Line 607: FND_DSQL.add_bind(l_volume_type);

603: FND_DSQL.add_bind(l_volume_from);
604: FND_DSQL.add_text(',');
605: FND_DSQL.add_bind(l_volume_to);
606: FND_DSQL.add_text(',');
607: FND_DSQL.add_bind(l_volume_type);
608: FND_DSQL.add_text(',');
609: FND_DSQL.add_bind(l_product.uom_code);
610: FND_DSQL.add_text(' FROM (');
611:

Line 608: FND_DSQL.add_text(',');

604: FND_DSQL.add_text(',');
605: FND_DSQL.add_bind(l_volume_to);
606: FND_DSQL.add_text(',');
607: FND_DSQL.add_bind(l_volume_type);
608: FND_DSQL.add_text(',');
609: FND_DSQL.add_bind(l_product.uom_code);
610: FND_DSQL.add_text(' FROM (');
611:
612: IF l_product.product_level = 'FAMILY'

Line 609: FND_DSQL.add_bind(l_product.uom_code);

605: FND_DSQL.add_bind(l_volume_to);
606: FND_DSQL.add_text(',');
607: FND_DSQL.add_bind(l_volume_type);
608: FND_DSQL.add_text(',');
609: FND_DSQL.add_bind(l_product.uom_code);
610: FND_DSQL.add_text(' FROM (');
611:
612: IF l_product.product_level = 'FAMILY'
613: THEN

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

606: FND_DSQL.add_text(',');
607: FND_DSQL.add_bind(l_volume_type);
608: FND_DSQL.add_text(',');
609: FND_DSQL.add_bind(l_product.uom_code);
610: FND_DSQL.add_text(' FROM (');
611:
612: IF l_product.product_level = 'FAMILY'
613: THEN
614: --

Line 619: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');

615: IF l_func_area_id = 11
616: THEN
617: -- Functional Area is PRFA.
618: --
619: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
620: FND_DSQL.add_bind(l_org_id);
621: FND_DSQL.add_text(' AND epdhv.parent_id = ');
622: FND_DSQL.add_bind(l_product.product_id);
623: --

Line 620: FND_DSQL.add_bind(l_org_id);

616: THEN
617: -- Functional Area is PRFA.
618: --
619: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
620: FND_DSQL.add_bind(l_org_id);
621: FND_DSQL.add_text(' AND epdhv.parent_id = ');
622: FND_DSQL.add_bind(l_product.product_id);
623: --
624: ELSE

Line 621: FND_DSQL.add_text(' AND epdhv.parent_id = ');

617: -- Functional Area is PRFA.
618: --
619: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
620: FND_DSQL.add_bind(l_org_id);
621: FND_DSQL.add_text(' AND epdhv.parent_id = ');
622: FND_DSQL.add_bind(l_product.product_id);
623: --
624: ELSE
625: -- Functional Area id OMFA

Line 622: FND_DSQL.add_bind(l_product.product_id);

618: --
619: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
620: FND_DSQL.add_bind(l_org_id);
621: FND_DSQL.add_text(' AND epdhv.parent_id = ');
622: FND_DSQL.add_bind(l_product.product_id);
623: --
624: ELSE
625: -- Functional Area id OMFA
626: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');

Line 626: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');

622: FND_DSQL.add_bind(l_product.product_id);
623: --
624: ELSE
625: -- Functional Area id OMFA
626: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
627: FND_DSQL.add_bind(l_org_id);
628: FND_DSQL.add_text(' AND category_id = ');
629: FND_DSQL.add_bind(l_product.product_id);
630: --

Line 627: FND_DSQL.add_bind(l_org_id);

623: --
624: ELSE
625: -- Functional Area id OMFA
626: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
627: FND_DSQL.add_bind(l_org_id);
628: FND_DSQL.add_text(' AND category_id = ');
629: FND_DSQL.add_bind(l_product.product_id);
630: --
631: END IF;

Line 628: FND_DSQL.add_text(' AND category_id = ');

624: ELSE
625: -- Functional Area id OMFA
626: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
627: FND_DSQL.add_bind(l_org_id);
628: FND_DSQL.add_text(' AND category_id = ');
629: FND_DSQL.add_bind(l_product.product_id);
630: --
631: END IF;
632: --

Line 629: FND_DSQL.add_bind(l_product.product_id);

625: -- Functional Area id OMFA
626: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
627: FND_DSQL.add_bind(l_org_id);
628: FND_DSQL.add_text(' AND category_id = ');
629: FND_DSQL.add_bind(l_product.product_id);
630: --
631: END IF;
632: --
633: ELSIF l_product.product_level = 'PRODUCT'

Line 636: FND_DSQL.add_text('SELECT ');

632: --
633: ELSIF l_product.product_level = 'PRODUCT'
634: THEN
635: --
636: FND_DSQL.add_text('SELECT ');
637: FND_DSQL.add_bind(l_product.product_id);
638: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
639: --
640: END IF;

Line 637: FND_DSQL.add_bind(l_product.product_id);

633: ELSIF l_product.product_level = 'PRODUCT'
634: THEN
635: --
636: FND_DSQL.add_text('SELECT ');
637: FND_DSQL.add_bind(l_product.product_id);
638: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
639: --
640: END IF;
641:

Line 638: FND_DSQL.add_text(' inventory_item_id FROM DUAL');

634: THEN
635: --
636: FND_DSQL.add_text('SELECT ');
637: FND_DSQL.add_bind(l_product.product_id);
638: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
639: --
640: END IF;
641:
642: FOR l_exclusion IN c_exclusion(l_product.off_discount_product_id)

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

641:
642: FOR l_exclusion IN c_exclusion(l_product.off_discount_product_id)
643: LOOP
644: --
645: FND_DSQL.add_text(' MINUS ');
646:
647: IF l_exclusion.product_level = 'PRODUCT'
648: THEN
649: --

Line 650: FND_DSQL.add_text('SELECT ');

646:
647: IF l_exclusion.product_level = 'PRODUCT'
648: THEN
649: --
650: FND_DSQL.add_text('SELECT ');
651: FND_DSQL.add_bind(l_exclusion.product_id);
652: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
653: --
654: ELSIF l_exclusion.product_level = 'FAMILY'

Line 651: FND_DSQL.add_bind(l_exclusion.product_id);

647: IF l_exclusion.product_level = 'PRODUCT'
648: THEN
649: --
650: FND_DSQL.add_text('SELECT ');
651: FND_DSQL.add_bind(l_exclusion.product_id);
652: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
653: --
654: ELSIF l_exclusion.product_level = 'FAMILY'
655: THEN

Line 652: FND_DSQL.add_text(' inventory_item_id FROM DUAL');

648: THEN
649: --
650: FND_DSQL.add_text('SELECT ');
651: FND_DSQL.add_bind(l_exclusion.product_id);
652: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
653: --
654: ELSIF l_exclusion.product_level = 'FAMILY'
655: THEN
656: --

Line 661: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');

657: IF l_func_area_id = 11
658: THEN
659: -- Functional Area is PRFA.
660: --
661: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
662: FND_DSQL.add_bind(l_org_id);
663: FND_DSQL.add_text(' AND epdhv.parent_id = ');
664: FND_DSQL.add_bind(l_exclusion.product_id);
665: --

Line 662: FND_DSQL.add_bind(l_org_id);

658: THEN
659: -- Functional Area is PRFA.
660: --
661: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
662: FND_DSQL.add_bind(l_org_id);
663: FND_DSQL.add_text(' AND epdhv.parent_id = ');
664: FND_DSQL.add_bind(l_exclusion.product_id);
665: --
666: ELSE

Line 663: FND_DSQL.add_text(' AND epdhv.parent_id = ');

659: -- Functional Area is PRFA.
660: --
661: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
662: FND_DSQL.add_bind(l_org_id);
663: FND_DSQL.add_text(' AND epdhv.parent_id = ');
664: FND_DSQL.add_bind(l_exclusion.product_id);
665: --
666: ELSE
667: -- Functional Area id OMFA

Line 664: FND_DSQL.add_bind(l_exclusion.product_id);

660: --
661: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
662: FND_DSQL.add_bind(l_org_id);
663: FND_DSQL.add_text(' AND epdhv.parent_id = ');
664: FND_DSQL.add_bind(l_exclusion.product_id);
665: --
666: ELSE
667: -- Functional Area id OMFA
668: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');

Line 668: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');

664: FND_DSQL.add_bind(l_exclusion.product_id);
665: --
666: ELSE
667: -- Functional Area id OMFA
668: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
669: FND_DSQL.add_bind(l_org_id);
670: FND_DSQL.add_text(' AND category_id = ');
671: FND_DSQL.add_bind(l_exclusion.product_id);
672: --

Line 669: FND_DSQL.add_bind(l_org_id);

665: --
666: ELSE
667: -- Functional Area id OMFA
668: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
669: FND_DSQL.add_bind(l_org_id);
670: FND_DSQL.add_text(' AND category_id = ');
671: FND_DSQL.add_bind(l_exclusion.product_id);
672: --
673: END IF;

Line 670: FND_DSQL.add_text(' AND category_id = ');

666: ELSE
667: -- Functional Area id OMFA
668: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
669: FND_DSQL.add_bind(l_org_id);
670: FND_DSQL.add_text(' AND category_id = ');
671: FND_DSQL.add_bind(l_exclusion.product_id);
672: --
673: END IF;
674: --

Line 671: FND_DSQL.add_bind(l_exclusion.product_id);

667: -- Functional Area id OMFA
668: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
669: FND_DSQL.add_bind(l_org_id);
670: FND_DSQL.add_text(' AND category_id = ');
671: FND_DSQL.add_bind(l_exclusion.product_id);
672: --
673: END IF;
674: --
675: END IF;

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

675: END IF;
676: --
677: END LOOP;
678:
679: FND_DSQL.add_text(')');
680:
681: l_denorm_csr := DBMS_SQL.open_cursor;
682: FND_DSQL.set_cursor(l_denorm_csr);
683: l_stmt_debug := FND_DSQL.get_text(TRUE);

Line 682: FND_DSQL.set_cursor(l_denorm_csr);

678:
679: FND_DSQL.add_text(')');
680:
681: l_denorm_csr := DBMS_SQL.open_cursor;
682: FND_DSQL.set_cursor(l_denorm_csr);
683: l_stmt_debug := FND_DSQL.get_text(TRUE);
684: l_stmt_denorm := FND_DSQL.get_text(FALSE);
685: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
686: FND_DSQL.do_binds;

Line 683: l_stmt_debug := FND_DSQL.get_text(TRUE);

679: FND_DSQL.add_text(')');
680:
681: l_denorm_csr := DBMS_SQL.open_cursor;
682: FND_DSQL.set_cursor(l_denorm_csr);
683: l_stmt_debug := FND_DSQL.get_text(TRUE);
684: l_stmt_denorm := FND_DSQL.get_text(FALSE);
685: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
686: FND_DSQL.do_binds;
687: l_ignore := DBMS_SQL.execute(l_denorm_csr);

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

680:
681: l_denorm_csr := DBMS_SQL.open_cursor;
682: FND_DSQL.set_cursor(l_denorm_csr);
683: l_stmt_debug := FND_DSQL.get_text(TRUE);
684: l_stmt_denorm := FND_DSQL.get_text(FALSE);
685: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
686: FND_DSQL.do_binds;
687: l_ignore := DBMS_SQL.execute(l_denorm_csr);
688: dbms_sql.close_cursor(l_denorm_csr);

Line 686: FND_DSQL.do_binds;

682: FND_DSQL.set_cursor(l_denorm_csr);
683: l_stmt_debug := FND_DSQL.get_text(TRUE);
684: l_stmt_denorm := FND_DSQL.get_text(FALSE);
685: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
686: FND_DSQL.do_binds;
687: l_ignore := DBMS_SQL.execute(l_denorm_csr);
688: dbms_sql.close_cursor(l_denorm_csr);
689: --
690: END LOOP;

Line 774: FND_DSQL.init;

770: ozf_utility_pvt.write_conc_log('Functional Area for category: ' || l_func_area_id);
771: --
772: -- END IF;
773:
774: FND_DSQL.init;
775: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
776: FND_DSQL.add_text('SELECT inventory_item_id,');
777: FND_DSQL.add_bind(l_product.product_level);
778: FND_DSQL.add_text(',');

Line 775: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');

771: --
772: -- END IF;
773:
774: FND_DSQL.init;
775: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
776: FND_DSQL.add_text('SELECT inventory_item_id,');
777: FND_DSQL.add_bind(l_product.product_level);
778: FND_DSQL.add_text(',');
779: FND_DSQL.add_bind(l_discount.discount);

Line 776: FND_DSQL.add_text('SELECT inventory_item_id,');

772: -- END IF;
773:
774: FND_DSQL.init;
775: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
776: FND_DSQL.add_text('SELECT inventory_item_id,');
777: FND_DSQL.add_bind(l_product.product_level);
778: FND_DSQL.add_text(',');
779: FND_DSQL.add_bind(l_discount.discount);
780: FND_DSQL.add_text(',');

Line 777: FND_DSQL.add_bind(l_product.product_level);

773:
774: FND_DSQL.init;
775: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
776: FND_DSQL.add_text('SELECT inventory_item_id,');
777: FND_DSQL.add_bind(l_product.product_level);
778: FND_DSQL.add_text(',');
779: FND_DSQL.add_bind(l_discount.discount);
780: FND_DSQL.add_text(',');
781: FND_DSQL.add_bind(l_discount.discount_type);

Line 778: FND_DSQL.add_text(',');

774: FND_DSQL.init;
775: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
776: FND_DSQL.add_text('SELECT inventory_item_id,');
777: FND_DSQL.add_bind(l_product.product_level);
778: FND_DSQL.add_text(',');
779: FND_DSQL.add_bind(l_discount.discount);
780: FND_DSQL.add_text(',');
781: FND_DSQL.add_bind(l_discount.discount_type);
782: FND_DSQL.add_text(',');

Line 779: FND_DSQL.add_bind(l_discount.discount);

775: FND_DSQL.add_text('INSERT INTO ozf_na_products_temp(inventory_item_id,product_level,discount,discount_type,volume_from,volume_to,volume_type,uom) ');
776: FND_DSQL.add_text('SELECT inventory_item_id,');
777: FND_DSQL.add_bind(l_product.product_level);
778: FND_DSQL.add_text(',');
779: FND_DSQL.add_bind(l_discount.discount);
780: FND_DSQL.add_text(',');
781: FND_DSQL.add_bind(l_discount.discount_type);
782: FND_DSQL.add_text(',');
783: FND_DSQL.add_bind(l_discount.volume_from);

Line 780: FND_DSQL.add_text(',');

776: FND_DSQL.add_text('SELECT inventory_item_id,');
777: FND_DSQL.add_bind(l_product.product_level);
778: FND_DSQL.add_text(',');
779: FND_DSQL.add_bind(l_discount.discount);
780: FND_DSQL.add_text(',');
781: FND_DSQL.add_bind(l_discount.discount_type);
782: FND_DSQL.add_text(',');
783: FND_DSQL.add_bind(l_discount.volume_from);
784: FND_DSQL.add_text(',');

Line 781: FND_DSQL.add_bind(l_discount.discount_type);

777: FND_DSQL.add_bind(l_product.product_level);
778: FND_DSQL.add_text(',');
779: FND_DSQL.add_bind(l_discount.discount);
780: FND_DSQL.add_text(',');
781: FND_DSQL.add_bind(l_discount.discount_type);
782: FND_DSQL.add_text(',');
783: FND_DSQL.add_bind(l_discount.volume_from);
784: FND_DSQL.add_text(',');
785: FND_DSQL.add_bind(l_discount.volume_to);

Line 782: FND_DSQL.add_text(',');

778: FND_DSQL.add_text(',');
779: FND_DSQL.add_bind(l_discount.discount);
780: FND_DSQL.add_text(',');
781: FND_DSQL.add_bind(l_discount.discount_type);
782: FND_DSQL.add_text(',');
783: FND_DSQL.add_bind(l_discount.volume_from);
784: FND_DSQL.add_text(',');
785: FND_DSQL.add_bind(l_discount.volume_to);
786: FND_DSQL.add_text(',');

Line 783: FND_DSQL.add_bind(l_discount.volume_from);

779: FND_DSQL.add_bind(l_discount.discount);
780: FND_DSQL.add_text(',');
781: FND_DSQL.add_bind(l_discount.discount_type);
782: FND_DSQL.add_text(',');
783: FND_DSQL.add_bind(l_discount.volume_from);
784: FND_DSQL.add_text(',');
785: FND_DSQL.add_bind(l_discount.volume_to);
786: FND_DSQL.add_text(',');
787: FND_DSQL.add_bind(l_discount.volume_type);

Line 784: FND_DSQL.add_text(',');

780: FND_DSQL.add_text(',');
781: FND_DSQL.add_bind(l_discount.discount_type);
782: FND_DSQL.add_text(',');
783: FND_DSQL.add_bind(l_discount.volume_from);
784: FND_DSQL.add_text(',');
785: FND_DSQL.add_bind(l_discount.volume_to);
786: FND_DSQL.add_text(',');
787: FND_DSQL.add_bind(l_discount.volume_type);
788: FND_DSQL.add_text(',');

Line 785: FND_DSQL.add_bind(l_discount.volume_to);

781: FND_DSQL.add_bind(l_discount.discount_type);
782: FND_DSQL.add_text(',');
783: FND_DSQL.add_bind(l_discount.volume_from);
784: FND_DSQL.add_text(',');
785: FND_DSQL.add_bind(l_discount.volume_to);
786: FND_DSQL.add_text(',');
787: FND_DSQL.add_bind(l_discount.volume_type);
788: FND_DSQL.add_text(',');
789: FND_DSQL.add_bind(l_product.uom_code);

Line 786: FND_DSQL.add_text(',');

782: FND_DSQL.add_text(',');
783: FND_DSQL.add_bind(l_discount.volume_from);
784: FND_DSQL.add_text(',');
785: FND_DSQL.add_bind(l_discount.volume_to);
786: FND_DSQL.add_text(',');
787: FND_DSQL.add_bind(l_discount.volume_type);
788: FND_DSQL.add_text(',');
789: FND_DSQL.add_bind(l_product.uom_code);
790: FND_DSQL.add_text(' FROM (');

Line 787: FND_DSQL.add_bind(l_discount.volume_type);

783: FND_DSQL.add_bind(l_discount.volume_from);
784: FND_DSQL.add_text(',');
785: FND_DSQL.add_bind(l_discount.volume_to);
786: FND_DSQL.add_text(',');
787: FND_DSQL.add_bind(l_discount.volume_type);
788: FND_DSQL.add_text(',');
789: FND_DSQL.add_bind(l_product.uom_code);
790: FND_DSQL.add_text(' FROM (');
791:

Line 788: FND_DSQL.add_text(',');

784: FND_DSQL.add_text(',');
785: FND_DSQL.add_bind(l_discount.volume_to);
786: FND_DSQL.add_text(',');
787: FND_DSQL.add_bind(l_discount.volume_type);
788: FND_DSQL.add_text(',');
789: FND_DSQL.add_bind(l_product.uom_code);
790: FND_DSQL.add_text(' FROM (');
791:
792: IF l_product.product_level = 'FAMILY'

Line 789: FND_DSQL.add_bind(l_product.uom_code);

785: FND_DSQL.add_bind(l_discount.volume_to);
786: FND_DSQL.add_text(',');
787: FND_DSQL.add_bind(l_discount.volume_type);
788: FND_DSQL.add_text(',');
789: FND_DSQL.add_bind(l_product.uom_code);
790: FND_DSQL.add_text(' FROM (');
791:
792: IF l_product.product_level = 'FAMILY'
793: THEN

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

786: FND_DSQL.add_text(',');
787: FND_DSQL.add_bind(l_discount.volume_type);
788: FND_DSQL.add_text(',');
789: FND_DSQL.add_bind(l_product.uom_code);
790: FND_DSQL.add_text(' FROM (');
791:
792: IF l_product.product_level = 'FAMILY'
793: THEN
794: --

Line 799: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');

795: IF l_func_area_id = 11
796: THEN
797: -- Functional Area is PRFA.
798: --
799: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
800: FND_DSQL.add_bind(l_org_id);
801: FND_DSQL.add_text(' AND epdhv.parent_id = ');
802: FND_DSQL.add_bind(l_product.product_id);
803: --

Line 800: FND_DSQL.add_bind(l_org_id);

796: THEN
797: -- Functional Area is PRFA.
798: --
799: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
800: FND_DSQL.add_bind(l_org_id);
801: FND_DSQL.add_text(' AND epdhv.parent_id = ');
802: FND_DSQL.add_bind(l_product.product_id);
803: --
804: ELSE

Line 801: FND_DSQL.add_text(' AND epdhv.parent_id = ');

797: -- Functional Area is PRFA.
798: --
799: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
800: FND_DSQL.add_bind(l_org_id);
801: FND_DSQL.add_text(' AND epdhv.parent_id = ');
802: FND_DSQL.add_bind(l_product.product_id);
803: --
804: ELSE
805: -- Functional Area id OMFA

Line 802: FND_DSQL.add_bind(l_product.product_id);

798: --
799: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories mtl,eni_prod_denorm_hrchy_v epdhv WHERE mtl.category_set_id = epdhv.category_set_id AND mtl.category_id = epdhv.child_id AND mtl.organization_id = ');
800: FND_DSQL.add_bind(l_org_id);
801: FND_DSQL.add_text(' AND epdhv.parent_id = ');
802: FND_DSQL.add_bind(l_product.product_id);
803: --
804: ELSE
805: -- Functional Area id OMFA
806: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');

Line 806: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');

802: FND_DSQL.add_bind(l_product.product_id);
803: --
804: ELSE
805: -- Functional Area id OMFA
806: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
807: FND_DSQL.add_bind(l_org_id);
808: FND_DSQL.add_text(' AND category_id = ');
809: FND_DSQL.add_bind(l_product.product_id);
810: --

Line 807: FND_DSQL.add_bind(l_org_id);

803: --
804: ELSE
805: -- Functional Area id OMFA
806: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
807: FND_DSQL.add_bind(l_org_id);
808: FND_DSQL.add_text(' AND category_id = ');
809: FND_DSQL.add_bind(l_product.product_id);
810: --
811: END IF;

Line 808: FND_DSQL.add_text(' AND category_id = ');

804: ELSE
805: -- Functional Area id OMFA
806: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
807: FND_DSQL.add_bind(l_org_id);
808: FND_DSQL.add_text(' AND category_id = ');
809: FND_DSQL.add_bind(l_product.product_id);
810: --
811: END IF;
812: --

Line 809: FND_DSQL.add_bind(l_product.product_id);

805: -- Functional Area id OMFA
806: FND_DSQL.add_text('SELECT inventory_item_id FROM mtl_item_categories WHERE organization_id = ');
807: FND_DSQL.add_bind(l_org_id);
808: FND_DSQL.add_text(' AND category_id = ');
809: FND_DSQL.add_bind(l_product.product_id);
810: --
811: END IF;
812: --
813: ELSIF l_product.product_level = 'PRODUCT'

Line 816: FND_DSQL.add_text('SELECT ');

812: --
813: ELSIF l_product.product_level = 'PRODUCT'
814: THEN
815: --
816: FND_DSQL.add_text('SELECT ');
817: FND_DSQL.add_bind(l_product.product_id);
818: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
819: --
820: END IF;

Line 817: FND_DSQL.add_bind(l_product.product_id);

813: ELSIF l_product.product_level = 'PRODUCT'
814: THEN
815: --
816: FND_DSQL.add_text('SELECT ');
817: FND_DSQL.add_bind(l_product.product_id);
818: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
819: --
820: END IF;
821:

Line 818: FND_DSQL.add_text(' inventory_item_id FROM DUAL');

814: THEN
815: --
816: FND_DSQL.add_text('SELECT ');
817: FND_DSQL.add_bind(l_product.product_id);
818: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
819: --
820: END IF;
821:
822: FND_DSQL.add_text(')');

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

818: FND_DSQL.add_text(' inventory_item_id FROM DUAL');
819: --
820: END IF;
821:
822: FND_DSQL.add_text(')');
823:
824: l_denorm_csr := DBMS_SQL.open_cursor;
825: FND_DSQL.set_cursor(l_denorm_csr);
826: l_stmt_debug := FND_DSQL.get_text(TRUE);

Line 825: FND_DSQL.set_cursor(l_denorm_csr);

821:
822: FND_DSQL.add_text(')');
823:
824: l_denorm_csr := DBMS_SQL.open_cursor;
825: FND_DSQL.set_cursor(l_denorm_csr);
826: l_stmt_debug := FND_DSQL.get_text(TRUE);
827: l_stmt_denorm := FND_DSQL.get_text(FALSE);
828: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
829: FND_DSQL.do_binds;

Line 826: l_stmt_debug := FND_DSQL.get_text(TRUE);

822: FND_DSQL.add_text(')');
823:
824: l_denorm_csr := DBMS_SQL.open_cursor;
825: FND_DSQL.set_cursor(l_denorm_csr);
826: l_stmt_debug := FND_DSQL.get_text(TRUE);
827: l_stmt_denorm := FND_DSQL.get_text(FALSE);
828: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
829: FND_DSQL.do_binds;
830: l_ignore := DBMS_SQL.execute(l_denorm_csr);

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

823:
824: l_denorm_csr := DBMS_SQL.open_cursor;
825: FND_DSQL.set_cursor(l_denorm_csr);
826: l_stmt_debug := FND_DSQL.get_text(TRUE);
827: l_stmt_denorm := FND_DSQL.get_text(FALSE);
828: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
829: FND_DSQL.do_binds;
830: l_ignore := DBMS_SQL.execute(l_denorm_csr);
831: dbms_sql.close_cursor(l_denorm_csr);

Line 829: FND_DSQL.do_binds;

825: FND_DSQL.set_cursor(l_denorm_csr);
826: l_stmt_debug := FND_DSQL.get_text(TRUE);
827: l_stmt_denorm := FND_DSQL.get_text(FALSE);
828: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
829: FND_DSQL.do_binds;
830: l_ignore := DBMS_SQL.execute(l_denorm_csr);
831: dbms_sql.close_cursor(l_denorm_csr);
832:
833: