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.AML_LEAD_DEDUPE_PVT dependencies on DBMS_SQL

Line 405: l_cursor := DBMS_SQL.open_cursor;

401: values(sysdate, l_sql_string);
402: */
403:
404: --PARSE
405: l_cursor := DBMS_SQL.open_cursor;
406: DBMS_SQL.parse(l_cursor, l_sql_string, DBMS_SQL.native);
407:
408: --DEFINE_COLUMN
409: DBMS_SQL.define_column(l_cursor, 1, l_sales_lead_id);

Line 406: DBMS_SQL.parse(l_cursor, l_sql_string, DBMS_SQL.native);

402: */
403:
404: --PARSE
405: l_cursor := DBMS_SQL.open_cursor;
406: DBMS_SQL.parse(l_cursor, l_sql_string, DBMS_SQL.native);
407:
408: --DEFINE_COLUMN
409: DBMS_SQL.define_column(l_cursor, 1, l_sales_lead_id);
410:

Line 409: DBMS_SQL.define_column(l_cursor, 1, l_sales_lead_id);

405: l_cursor := DBMS_SQL.open_cursor;
406: DBMS_SQL.parse(l_cursor, l_sql_string, DBMS_SQL.native);
407:
408: --DEFINE_COLUMN
409: DBMS_SQL.define_column(l_cursor, 1, l_sales_lead_id);
410:
411: --BIND VARIABLES
412: DBMS_SQL.bind_variable(l_cursor, 'party_id', p_dup_rec.party_id);
413: DBMS_SQL.bind_variable(l_cursor, 'l_created_within_days', l_created_within_days);

Line 412: DBMS_SQL.bind_variable(l_cursor, 'party_id', p_dup_rec.party_id);

408: --DEFINE_COLUMN
409: DBMS_SQL.define_column(l_cursor, 1, l_sales_lead_id);
410:
411: --BIND VARIABLES
412: DBMS_SQL.bind_variable(l_cursor, 'party_id', p_dup_rec.party_id);
413: DBMS_SQL.bind_variable(l_cursor, 'l_created_within_days', l_created_within_days);
414:
415: IF l_promotion_code = 'Y' AND p_dup_rec.source_code IS NOT NULL THEN
416: DBMS_SQL.bind_variable(l_cursor, 'source_code', p_dup_rec.source_code);

Line 413: DBMS_SQL.bind_variable(l_cursor, 'l_created_within_days', l_created_within_days);

409: DBMS_SQL.define_column(l_cursor, 1, l_sales_lead_id);
410:
411: --BIND VARIABLES
412: DBMS_SQL.bind_variable(l_cursor, 'party_id', p_dup_rec.party_id);
413: DBMS_SQL.bind_variable(l_cursor, 'l_created_within_days', l_created_within_days);
414:
415: IF l_promotion_code = 'Y' AND p_dup_rec.source_code IS NOT NULL THEN
416: DBMS_SQL.bind_variable(l_cursor, 'source_code', p_dup_rec.source_code);
417: END IF;

Line 416: DBMS_SQL.bind_variable(l_cursor, 'source_code', p_dup_rec.source_code);

412: DBMS_SQL.bind_variable(l_cursor, 'party_id', p_dup_rec.party_id);
413: DBMS_SQL.bind_variable(l_cursor, 'l_created_within_days', l_created_within_days);
414:
415: IF l_promotion_code = 'Y' AND p_dup_rec.source_code IS NOT NULL THEN
416: DBMS_SQL.bind_variable(l_cursor, 'source_code', p_dup_rec.source_code);
417: END IF;
418:
419: IF l_vehicle_response_code = 'Y' THEN
420: DBMS_SQL.bind_variable(l_cursor, 'l_def_vrc', l_def_vrc);

Line 420: DBMS_SQL.bind_variable(l_cursor, 'l_def_vrc', l_def_vrc);

416: DBMS_SQL.bind_variable(l_cursor, 'source_code', p_dup_rec.source_code);
417: END IF;
418:
419: IF l_vehicle_response_code = 'Y' THEN
420: DBMS_SQL.bind_variable(l_cursor, 'l_def_vrc', l_def_vrc);
421: DBMS_SQL.bind_variable(l_cursor, 'vehicle_response_code', p_dup_rec.vehicle_response_code);
422: END IF;
423:
424: IF l_contact = 'Y' AND p_dup_rec.contact_id IS NOT NULL THEN

Line 421: DBMS_SQL.bind_variable(l_cursor, 'vehicle_response_code', p_dup_rec.vehicle_response_code);

417: END IF;
418:
419: IF l_vehicle_response_code = 'Y' THEN
420: DBMS_SQL.bind_variable(l_cursor, 'l_def_vrc', l_def_vrc);
421: DBMS_SQL.bind_variable(l_cursor, 'vehicle_response_code', p_dup_rec.vehicle_response_code);
422: END IF;
423:
424: IF l_contact = 'Y' AND p_dup_rec.contact_id IS NOT NULL THEN
425: DBMS_SQL.bind_variable(l_cursor, 'contact_id', p_dup_rec.contact_id);

Line 425: DBMS_SQL.bind_variable(l_cursor, 'contact_id', p_dup_rec.contact_id);

421: DBMS_SQL.bind_variable(l_cursor, 'vehicle_response_code', p_dup_rec.vehicle_response_code);
422: END IF;
423:
424: IF l_contact = 'Y' AND p_dup_rec.contact_id IS NOT NULL THEN
425: DBMS_SQL.bind_variable(l_cursor, 'contact_id', p_dup_rec.contact_id);
426: END IF;
427:
428: IF l_address = 'Y' AND p_dup_rec.party_site_id IS NOT NULL THEN
429: DBMS_SQL.bind_variable(l_cursor, 'party_site_id', p_dup_rec.party_site_id);

Line 429: DBMS_SQL.bind_variable(l_cursor, 'party_site_id', p_dup_rec.party_site_id);

425: DBMS_SQL.bind_variable(l_cursor, 'contact_id', p_dup_rec.contact_id);
426: END IF;
427:
428: IF l_address = 'Y' AND p_dup_rec.party_site_id IS NOT NULL THEN
429: DBMS_SQL.bind_variable(l_cursor, 'party_site_id', p_dup_rec.party_site_id);
430: END IF;
431:
432: IF l_note_type = 'Y' THEN
433: IF p_dup_rec.lead_note IS NOT NULL THEN

Line 434: DBMS_SQL.bind_variable(l_cursor, 'note_type', p_dup_rec.note_type);

430: END IF;
431:
432: IF l_note_type = 'Y' THEN
433: IF p_dup_rec.lead_note IS NOT NULL THEN
434: DBMS_SQL.bind_variable(l_cursor, 'note_type', p_dup_rec.note_type);
435: END IF;
436: DBMS_SQL.bind_variable(l_cursor, 'lead_note', p_dup_rec.lead_note);
437: END IF;
438:

Line 436: DBMS_SQL.bind_variable(l_cursor, 'lead_note', p_dup_rec.lead_note);

432: IF l_note_type = 'Y' THEN
433: IF p_dup_rec.lead_note IS NOT NULL THEN
434: DBMS_SQL.bind_variable(l_cursor, 'note_type', p_dup_rec.note_type);
435: END IF;
436: DBMS_SQL.bind_variable(l_cursor, 'lead_note', p_dup_rec.lead_note);
437: END IF;
438:
439: IF l_budget_status = 'Y' THEN
440: DBMS_SQL.bind_variable(l_cursor, 'l_def_budget_status', l_def_budget_status);

Line 440: DBMS_SQL.bind_variable(l_cursor, 'l_def_budget_status', l_def_budget_status);

436: DBMS_SQL.bind_variable(l_cursor, 'lead_note', p_dup_rec.lead_note);
437: END IF;
438:
439: IF l_budget_status = 'Y' THEN
440: DBMS_SQL.bind_variable(l_cursor, 'l_def_budget_status', l_def_budget_status);
441: DBMS_SQL.bind_variable(l_cursor, 'budget_status_code', p_dup_rec.budget_status_code);
442: END IF;
443:
444: IF l_purchase_amt = 'Y' AND p_dup_rec.purchase_amount IS NOT NULL THEN

Line 441: DBMS_SQL.bind_variable(l_cursor, 'budget_status_code', p_dup_rec.budget_status_code);

437: END IF;
438:
439: IF l_budget_status = 'Y' THEN
440: DBMS_SQL.bind_variable(l_cursor, 'l_def_budget_status', l_def_budget_status);
441: DBMS_SQL.bind_variable(l_cursor, 'budget_status_code', p_dup_rec.budget_status_code);
442: END IF;
443:
444: IF l_purchase_amt = 'Y' AND p_dup_rec.purchase_amount IS NOT NULL THEN
445: DBMS_SQL.bind_variable(l_cursor, 'purchase_amount', p_dup_rec.purchase_amount);

Line 445: DBMS_SQL.bind_variable(l_cursor, 'purchase_amount', p_dup_rec.purchase_amount);

441: DBMS_SQL.bind_variable(l_cursor, 'budget_status_code', p_dup_rec.budget_status_code);
442: END IF;
443:
444: IF l_purchase_amt = 'Y' AND p_dup_rec.purchase_amount IS NOT NULL THEN
445: DBMS_SQL.bind_variable(l_cursor, 'purchase_amount', p_dup_rec.purchase_amount);
446: END IF;
447:
448: IF l_budget_amt = 'Y' AND p_dup_rec.budget_amount IS NOT NULL THEN
449: DBMS_SQL.bind_variable(l_cursor, 'budget_amount', p_dup_rec.budget_amount);

Line 449: DBMS_SQL.bind_variable(l_cursor, 'budget_amount', p_dup_rec.budget_amount);

445: DBMS_SQL.bind_variable(l_cursor, 'purchase_amount', p_dup_rec.purchase_amount);
446: END IF;
447:
448: IF l_budget_amt = 'Y' AND p_dup_rec.budget_amount IS NOT NULL THEN
449: DBMS_SQL.bind_variable(l_cursor, 'budget_amount', p_dup_rec.budget_amount);
450: END IF;
451:
452: IF l_purchase_timeframe = 'Y' THEN
453: DBMS_SQL.bind_variable(l_cursor, 'l_def_decision_timeframe', l_def_decision_timeframe);

Line 453: DBMS_SQL.bind_variable(l_cursor, 'l_def_decision_timeframe', l_def_decision_timeframe);

449: DBMS_SQL.bind_variable(l_cursor, 'budget_amount', p_dup_rec.budget_amount);
450: END IF;
451:
452: IF l_purchase_timeframe = 'Y' THEN
453: DBMS_SQL.bind_variable(l_cursor, 'l_def_decision_timeframe', l_def_decision_timeframe);
454: DBMS_SQL.bind_variable(l_cursor, 'purchase_timeframe_code', p_dup_rec.purchase_timeframe_code);
455: END IF;
456:
457: IF l_project = 'Y' THEN

Line 454: DBMS_SQL.bind_variable(l_cursor, 'purchase_timeframe_code', p_dup_rec.purchase_timeframe_code);

450: END IF;
451:
452: IF l_purchase_timeframe = 'Y' THEN
453: DBMS_SQL.bind_variable(l_cursor, 'l_def_decision_timeframe', l_def_decision_timeframe);
454: DBMS_SQL.bind_variable(l_cursor, 'purchase_timeframe_code', p_dup_rec.purchase_timeframe_code);
455: END IF;
456:
457: IF l_project = 'Y' THEN
458: DBMS_SQL.bind_variable(l_cursor, 'project_code', p_dup_rec.project_code);

Line 458: DBMS_SQL.bind_variable(l_cursor, 'project_code', p_dup_rec.project_code);

454: DBMS_SQL.bind_variable(l_cursor, 'purchase_timeframe_code', p_dup_rec.purchase_timeframe_code);
455: END IF;
456:
457: IF l_project = 'Y' THEN
458: DBMS_SQL.bind_variable(l_cursor, 'project_code', p_dup_rec.project_code);
459: END IF;
460:
461: --EXECUTE CURSOR
462: l_cur_exec := DBMS_SQL.execute(l_cursor);

Line 462: l_cur_exec := DBMS_SQL.execute(l_cursor);

458: DBMS_SQL.bind_variable(l_cursor, 'project_code', p_dup_rec.project_code);
459: END IF;
460:
461: --EXECUTE CURSOR
462: l_cur_exec := DBMS_SQL.execute(l_cursor);
463:
464: l_sales_lead_id := null;
465:
466: IF l_product_interest = 'Y' AND p_dup_rec.category_id_tbl.COUNT > 0 THEN

Line 469: IF DBMS_SQL.fetch_rows(l_cursor)>0 THEN

465:
466: IF l_product_interest = 'Y' AND p_dup_rec.category_id_tbl.COUNT > 0 THEN
467:
468: LOOP
469: IF DBMS_SQL.fetch_rows(l_cursor)>0 THEN
470:
471: -- get column values of the row
472: DBMS_SQL.column_value(l_cursor, 1, l_sales_lead_id);
473:

Line 472: DBMS_SQL.column_value(l_cursor, 1, l_sales_lead_id);

468: LOOP
469: IF DBMS_SQL.fetch_rows(l_cursor)>0 THEN
470:
471: -- get column values of the row
472: DBMS_SQL.column_value(l_cursor, 1, l_sales_lead_id);
473:
474: category_tbl := p_dup_rec.category_id_tbl;
475: remove_duplicate (category_tbl);
476:

Line 493: l_line_cursor := DBMS_SQL.open_cursor;

489:
490: l_sql_lines := l_sql_string || l_from_clause || l_where_clause;
491:
492: --PARSE
493: l_line_cursor := DBMS_SQL.open_cursor;
494: DBMS_SQL.parse(l_line_cursor, l_sql_lines, DBMS_SQL.native);
495:
496: --DEFINE_COLUMN
497: DBMS_SQL.define_column(l_line_cursor, 1, l_count);

Line 494: DBMS_SQL.parse(l_line_cursor, l_sql_lines, DBMS_SQL.native);

490: l_sql_lines := l_sql_string || l_from_clause || l_where_clause;
491:
492: --PARSE
493: l_line_cursor := DBMS_SQL.open_cursor;
494: DBMS_SQL.parse(l_line_cursor, l_sql_lines, DBMS_SQL.native);
495:
496: --DEFINE_COLUMN
497: DBMS_SQL.define_column(l_line_cursor, 1, l_count);
498:

Line 497: DBMS_SQL.define_column(l_line_cursor, 1, l_count);

493: l_line_cursor := DBMS_SQL.open_cursor;
494: DBMS_SQL.parse(l_line_cursor, l_sql_lines, DBMS_SQL.native);
495:
496: --DEFINE_COLUMN
497: DBMS_SQL.define_column(l_line_cursor, 1, l_count);
498:
499: --BIND VARIABLES
500: DBMS_SQL.bind_variable(l_line_cursor, 'p_sales_lead_id', l_sales_lead_id);
501:

Line 500: DBMS_SQL.bind_variable(l_line_cursor, 'p_sales_lead_id', l_sales_lead_id);

496: --DEFINE_COLUMN
497: DBMS_SQL.define_column(l_line_cursor, 1, l_count);
498:
499: --BIND VARIABLES
500: DBMS_SQL.bind_variable(l_line_cursor, 'p_sales_lead_id', l_sales_lead_id);
501:
502: --EXECUTE CURSOR
503: l_line_cur_exec := DBMS_SQL.execute(l_line_cursor);
504: IF DBMS_SQL.fetch_rows(l_line_cursor)>0 THEN

Line 503: l_line_cur_exec := DBMS_SQL.execute(l_line_cursor);

499: --BIND VARIABLES
500: DBMS_SQL.bind_variable(l_line_cursor, 'p_sales_lead_id', l_sales_lead_id);
501:
502: --EXECUTE CURSOR
503: l_line_cur_exec := DBMS_SQL.execute(l_line_cursor);
504: IF DBMS_SQL.fetch_rows(l_line_cursor)>0 THEN
505: -- get column values of the row
506: DBMS_SQL.column_value(l_line_cursor, 1, l_count);
507: END IF;

Line 504: IF DBMS_SQL.fetch_rows(l_line_cursor)>0 THEN

500: DBMS_SQL.bind_variable(l_line_cursor, 'p_sales_lead_id', l_sales_lead_id);
501:
502: --EXECUTE CURSOR
503: l_line_cur_exec := DBMS_SQL.execute(l_line_cursor);
504: IF DBMS_SQL.fetch_rows(l_line_cursor)>0 THEN
505: -- get column values of the row
506: DBMS_SQL.column_value(l_line_cursor, 1, l_count);
507: END IF;
508:

Line 506: DBMS_SQL.column_value(l_line_cursor, 1, l_count);

502: --EXECUTE CURSOR
503: l_line_cur_exec := DBMS_SQL.execute(l_line_cursor);
504: IF DBMS_SQL.fetch_rows(l_line_cursor)>0 THEN
505: -- get column values of the row
506: DBMS_SQL.column_value(l_line_cursor, 1, l_count);
507: END IF;
508:
509: DebugMsg(to_char(l_sales_lead_id)||'-'||to_char(l_count)||'-'||to_char(category_tbl.COUNT));
510:

Line 511: DBMS_SQL.close_cursor(l_line_cursor); -- Added by bmuthukr to fix bug# 3737789.

507: END IF;
508:
509: DebugMsg(to_char(l_sales_lead_id)||'-'||to_char(l_count)||'-'||to_char(category_tbl.COUNT));
510:
511: DBMS_SQL.close_cursor(l_line_cursor); -- Added by bmuthukr to fix bug# 3737789.
512:
513: IF l_count = category_tbl.COUNT THEN
514: x_sales_lead_id := l_sales_lead_id;
515: EXIT;

Line 524: --DBMS_SQL.close_cursor(l_line_cursor);--The cursor should be closed inside its scope.

520: END IF;
521:
522: END LOOP;
523: --CLOSE C_find_dup_lead;
524: --DBMS_SQL.close_cursor(l_line_cursor);--The cursor should be closed inside its scope.
525: ELSE --product interest
526:
527: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
528: -- get column values of the row

Line 527: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

523: --CLOSE C_find_dup_lead;
524: --DBMS_SQL.close_cursor(l_line_cursor);--The cursor should be closed inside its scope.
525: ELSE --product interest
526:
527: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
528: -- get column values of the row
529: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_sales_lead_id);
530: END IF;
531: x_sales_lead_id := l_sales_lead_id;

Line 529: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_sales_lead_id);

525: ELSE --product interest
526:
527: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
528: -- get column values of the row
529: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_sales_lead_id);
530: END IF;
531: x_sales_lead_id := l_sales_lead_id;
532:
533: END IF;

Line 534: DBMS_SQL.close_cursor(l_cursor);

530: END IF;
531: x_sales_lead_id := l_sales_lead_id;
532:
533: END IF;
534: DBMS_SQL.close_cursor(l_cursor);
535:
536: END Check_dup_lead;
537:
538: --------------------------------------------------------------