APPS.PAY_AU_GENERIC_CODE_CALLER dependencies on DBMS_SQL

Line 564: -- will execute the module. The DBMS_SQL package will be used to

560:
561: get_module_parameters(p_module_id, l_parameter_store) ;
562:
563: -- build up a string that contains a PL/SQL block. The PL/SQL block
564: -- will execute the module. The DBMS_SQL package will be used to
565: -- execute the dynamically created PL/SQL block
566:
567: if p_mode = 'PROCEDURE'
568: then

Line 726: l_cursor_id := dbms_sql.open_cursor ;

722: hr_utility.trace(' ' || l_sql_stmt) ;
723:
724: -- open a cursor for the the dynamic pl/sql block
725:
726: l_cursor_id := dbms_sql.open_cursor ;
727:
728: -- parse the dynamic pl/sql block
729:
730: dbms_sql.parse(l_cursor_id, l_sql_stmt, 1) ;

Line 730: dbms_sql.parse(l_cursor_id, l_sql_stmt, 1) ;

726: l_cursor_id := dbms_sql.open_cursor ;
727:
728: -- parse the dynamic pl/sql block
729:
730: dbms_sql.parse(l_cursor_id, l_sql_stmt, 1) ;
731:
732: -- Now set values for the bind variables. The values for in or in/out
733: -- parameters should be in the PL/SQL table variable store. There will
734: -- be no values for the out parameters. The DBMS_SQL package requires

Line 734: -- be no values for the out parameters. The DBMS_SQL package requires

730: dbms_sql.parse(l_cursor_id, l_sql_stmt, 1) ;
731:
732: -- Now set values for the bind variables. The values for in or in/out
733: -- parameters should be in the PL/SQL table variable store. There will
734: -- be no values for the out parameters. The DBMS_SQL package requires
735: -- that these out parameter bind variables are initialised so the
736: -- l_num_out_bind_var_init, l_text_out_bind_var_init, and
737: -- l_date_out_bind_var_init variables are used for this purpose.
738:

Line 767: dbms_sql.bind_variable(l_cursor_id

763: then
764:
765: -- initialise an out number bind variable
766:
767: dbms_sql.bind_variable(l_cursor_id
768: ,':' || l_parameter_store(i).internal_name
769: ,l_num_out_bind_var_init) ;
770:
771: else

Line 775: dbms_sql.bind_variable(l_cursor_id

771: else
772:
773: -- bind an in or in/out number bind variable
774:
775: dbms_sql.bind_variable(l_cursor_id
776: ,':' || l_parameter_store(i).internal_name
777: ,to_number(l_variable_value)) ;
778:
779: end if ;

Line 790: dbms_sql.bind_variable(l_cursor_id

786: then
787:
788: -- initialise an out text bind variable
789:
790: dbms_sql.bind_variable(l_cursor_id
791: ,':' || l_parameter_store(i).internal_name
792: ,l_text_out_bind_var_init) ;
793:
794: else

Line 798: dbms_sql.bind_variable(l_cursor_id

794: else
795:
796: -- bind an in or in/out text bind variable
797:
798: dbms_sql.bind_variable(l_cursor_id
799: ,':' || l_parameter_store(i).internal_name
800: ,l_variable_value) ;
801:
802: end if ;

Line 813: dbms_sql.bind_variable(l_cursor_id

809: then
810:
811: -- initialise an out date bind variable
812:
813: dbms_sql.bind_variable(l_cursor_id
814: ,':' || l_parameter_store(i).internal_name
815: ,l_date_out_bind_var_init) ;
816:
817: else

Line 821: dbms_sql.bind_variable(l_cursor_id

817: else
818:
819: -- bind an in or in/out date bind variable
820:
821: dbms_sql.bind_variable(l_cursor_id
822: ,':' || l_parameter_store(i).internal_name
823: ,fnd_date.canonical_to_date(l_variable_value)) ;
824:
825: end if ;

Line 842: l_return_code := dbms_sql.execute(l_cursor_id) ;

838:
839: -- execute the dynamically created PL/SQL block. (Note that the return
840: -- code has no meaning when executing PL/SQL blocks and it is ignored).
841:
842: l_return_code := dbms_sql.execute(l_cursor_id) ;
843:
844: -- now we need to get the values of the bind variables associated with
845: -- output parameters. The function return appears to be a special case,
846: -- however, as long as it has been flagged as an output parameter its

Line 869: dbms_sql.variable_value(l_cursor_id

865: then
866:
867: l_number_variable_value := null ;
868:
869: dbms_sql.variable_value(l_cursor_id
870: ,':' || l_parameter_store(i).internal_name
871: ,l_number_variable_value) ;
872:
873: l_variable_value := to_char(l_number_variable_value) ;

Line 878: dbms_sql.variable_value(l_cursor_id

874:
875: elsif l_parameter_store(i).data_type = 'TEXT'
876: then
877:
878: dbms_sql.variable_value(l_cursor_id
879: ,':' || l_parameter_store(i).internal_name
880: ,l_variable_value) ;
881:
882: elsif l_parameter_store(i).data_type = 'DATE'

Line 886: dbms_sql.variable_value(l_cursor_id

882: elsif l_parameter_store(i).data_type = 'DATE'
883: then
884:
885: l_date_variable_value := null ;
886: dbms_sql.variable_value(l_cursor_id
887: ,':' || l_parameter_store(i).internal_name
888: ,l_date_variable_value) ;
889:
890: l_variable_value := fnd_date.date_to_canonical(l_date_variable_value) ;

Line 944: dbms_sql.close_cursor(l_cursor_id) ;

940:
941: -- the cursor that contains the dynamically created PL/SQL block
942: -- is now finished with so release it
943:
944: dbms_sql.close_cursor(l_cursor_id) ;
945:
946: hr_utility.trace('Out: ' || l_procedure_name) ;
947:
948: exception