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

Line 42: 29/Sep/05 115.17 tjesumic adv condition changed into dbms_sql and bind variable

38: 05/02/04 115.13 nhunur removed the unwanted commits.
39: 01/Feb/05 115.14 tjesumic 300 elements allowed in a record
40: 21/Jun/05 115.15 tjesumic pernnserver , chg_rcd_merge added
41: 21/Jun/05 115.16 tjesumic no copy added in chg_rcd_merge
42: 29/Sep/05 115.17 tjesumic adv condition changed into dbms_sql and bind variable
43: 07/Now/05 115.18 tjesumic dynamic adv condition added
44: 02/Feb/06 115.19 tjesumic new exception added to restart the error person
45: 04/25/06 115.20 tjesumic new global qdded g_ext_adv_ct_validation
46: 04/27/06 115.21 tjesumic numeric validation is fixed

Line 396: l_cursor_name := dbms_sql.open_cursor;

392: begin
393: --execute immediate l_dynamic_condition using OUT l_condition;
394:
395: hr_utility.set_location(' parsing '|| l_cnt , 3);
396: l_cursor_name := dbms_sql.open_cursor;
397: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;
398: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
399: for i in 1 .. l_cnt
400: Loop

Line 397: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;

393: --execute immediate l_dynamic_condition using OUT l_condition;
394:
395: hr_utility.set_location(' parsing '|| l_cnt , 3);
396: l_cursor_name := dbms_sql.open_cursor;
397: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;
398: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
399: for i in 1 .. l_cnt
400: Loop
401:

Line 403: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_data(i).name,

399: for i in 1 .. l_cnt
400: Loop
401:
402: hr_utility.set_location(' bind data '|| l_ext_adv_data(i).name || l_ext_adv_data(i).value , 3);
403: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_data(i).name,
404: l_ext_adv_data(i).value);
405: end loop ;
406:
407:

Line 412: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_conditions(i).name,

408: for i in 1 .. l_cond_cnt
409: Loop
410:
411: hr_utility.set_location(' bind cond '|| l_ext_adv_conditions(i).name || l_ext_adv_conditions(i).value , 5);
412: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_conditions(i).name,
413: l_ext_adv_conditions(i).value);
414: end loop ;
415: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;
416: --

Line 415: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;

411: hr_utility.set_location(' bind cond '|| l_ext_adv_conditions(i).name || l_ext_adv_conditions(i).value , 5);
412: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_conditions(i).name,
413: l_ext_adv_conditions(i).value);
414: end loop ;
415: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;
416: --
417: l_cnt := dbms_sql.execute(l_cursor_name ) ;
418:
419: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;

Line 417: l_cnt := dbms_sql.execute(l_cursor_name ) ;

413: l_ext_adv_conditions(i).value);
414: end loop ;
415: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;
416: --
417: l_cnt := dbms_sql.execute(l_cursor_name ) ;
418:
419: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;
420:
421: dbms_sql.close_cursor(l_cursor_name);

Line 419: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;

415: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;
416: --
417: l_cnt := dbms_sql.execute(l_cursor_name ) ;
418:
419: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;
420:
421: dbms_sql.close_cursor(l_cursor_name);
422: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;
423:

Line 421: dbms_sql.close_cursor(l_cursor_name);

417: l_cnt := dbms_sql.execute(l_cursor_name ) ;
418:
419: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;
420:
421: dbms_sql.close_cursor(l_cursor_name);
422: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;
423:
424: exception
425: when others then

Line 422: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;

418:
419: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;
420:
421: dbms_sql.close_cursor(l_cursor_name);
422: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;
423:
424: exception
425: when others then
426: hr_utility.set_location( 'except ' || substr(sqlerrm,1,100), 99 ) ;

Line 430: IF dbms_sql.is_open(l_cursor_name) THEN

426: hr_utility.set_location( 'except ' || substr(sqlerrm,1,100), 99 ) ;
427: fnd_file.put_line(fnd_file.log,
428: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
429: fnd_file.put_line(fnd_file.log, l_dynamic_condition);
430: IF dbms_sql.is_open(l_cursor_name) THEN
431: dbms_sql.close_cursor(l_cursor_name);
432: end if ;
433:
434: raise; -- such that the error processing in ben_ext_thread occurs.

Line 431: dbms_sql.close_cursor(l_cursor_name);

427: fnd_file.put_line(fnd_file.log,
428: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
429: fnd_file.put_line(fnd_file.log, l_dynamic_condition);
430: IF dbms_sql.is_open(l_cursor_name) THEN
431: dbms_sql.close_cursor(l_cursor_name);
432: end if ;
433:
434: raise; -- such that the error processing in ben_ext_thread occurs.
435: end;

Line 724: l_cursor_name := dbms_sql.open_cursor;

720: l_dynamic_condition := l_dynamic_condition ||
721: ' then :l_condition := ''T''; else :l_condition := ''F''; end if; end;';
722: begin
723: --execute immediate l_dynamic_condition using OUT l_condition;
724: l_cursor_name := dbms_sql.open_cursor;
725: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;
726: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
727: for i in 1 .. l_cnt
728: Loop

Line 725: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;

721: ' then :l_condition := ''T''; else :l_condition := ''F''; end if; end;';
722: begin
723: --execute immediate l_dynamic_condition using OUT l_condition;
724: l_cursor_name := dbms_sql.open_cursor;
725: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;
726: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
727: for i in 1 .. l_cnt
728: Loop
729: hr_utility.set_location(' bind '|| l_ext_adv_data(i).name || l_ext_adv_data(i).value , 3);

Line 730: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_data(i).name,

726: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
727: for i in 1 .. l_cnt
728: Loop
729: hr_utility.set_location(' bind '|| l_ext_adv_data(i).name || l_ext_adv_data(i).value , 3);
730: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_data(i).name,
731: l_ext_adv_data(i).value);
732: end loop ;
733:
734: -- bind the values from conditions

Line 739: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_conditions(i).name,

735: for i in 1 .. l_cond_cnt
736: Loop
737:
738: hr_utility.set_location(' bind cond '|| l_ext_adv_conditions(i).name || l_ext_adv_conditions(i).value , 5);
739: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_conditions(i).name,
740: l_ext_adv_conditions(i).value);
741: end loop ;
742:
743: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;

Line 743: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;

739: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_conditions(i).name,
740: l_ext_adv_conditions(i).value);
741: end loop ;
742:
743: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;
744: --
745: l_cnt := dbms_sql.execute(l_cursor_name ) ;
746: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;
747: dbms_sql.close_cursor(l_cursor_name);

Line 745: l_cnt := dbms_sql.execute(l_cursor_name ) ;

741: end loop ;
742:
743: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;
744: --
745: l_cnt := dbms_sql.execute(l_cursor_name ) ;
746: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;
747: dbms_sql.close_cursor(l_cursor_name);
748: exception
749: when others then

Line 746: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;

742:
743: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;
744: --
745: l_cnt := dbms_sql.execute(l_cursor_name ) ;
746: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;
747: dbms_sql.close_cursor(l_cursor_name);
748: exception
749: when others then
750: -- this needs replaced with a message for translation.

Line 747: dbms_sql.close_cursor(l_cursor_name);

743: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;
744: --
745: l_cnt := dbms_sql.execute(l_cursor_name ) ;
746: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;
747: dbms_sql.close_cursor(l_cursor_name);
748: exception
749: when others then
750: -- this needs replaced with a message for translation.
751: fnd_file.put_line(fnd_file.log,

Line 754: If dbms_sql.is_open(l_cursor_name) THEN

750: -- this needs replaced with a message for translation.
751: fnd_file.put_line(fnd_file.log,
752: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
753: fnd_file.put_line(fnd_file.log, l_dynamic_condition);
754: If dbms_sql.is_open(l_cursor_name) THEN
755: dbms_sql.close_cursor(l_cursor_name);
756: end if ;
757: raise; -- such that the error processing in ben_ext_thread occurs.
758: end;

Line 755: dbms_sql.close_cursor(l_cursor_name);

751: fnd_file.put_line(fnd_file.log,
752: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
753: fnd_file.put_line(fnd_file.log, l_dynamic_condition);
754: If dbms_sql.is_open(l_cursor_name) THEN
755: dbms_sql.close_cursor(l_cursor_name);
756: end if ;
757: raise; -- such that the error processing in ben_ext_thread occurs.
758: end;
759: --

Line 760: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;

756: end if ;
757: raise; -- such that the error processing in ben_ext_thread occurs.
758: end;
759: --
760: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;
761: --
762: if l_condition = 'T' then
763:
764: if xer.sprs_cd = 'A' then -- rollback record