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

Line 600: l_cursor := dbms_sql.open_cursor;

596:
597: l_return_status := 'S';
598:
599: -- Get cursor handle
600: l_cursor := dbms_sql.open_cursor;
601:
602: -- Associate a sql statement with the cursor.
603:
604: l_stmt := 'BEGIN '||l_program_name ||

Line 613: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);

609: ' END;';
610:
611: -- parse the sql statemnt to check for any syntax or symantic errors
612:
613: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
614:
615: -- before executing the sql statement bind the variables
616:
617: dbms_sql.bind_variable(l_cursor,':Y',

Line 617: dbms_sql.bind_variable(l_cursor,':Y',

613: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
614:
615: -- before executing the sql statement bind the variables
616:
617: dbms_sql.bind_variable(l_cursor,':Y',
618: 'Y');
619: dbms_sql.bind_variable(l_cursor,':msg_count',
620: l_msg_count);
621: dbms_sql.bind_variable(l_cursor,':msg_data',

Line 619: dbms_sql.bind_variable(l_cursor,':msg_count',

615: -- before executing the sql statement bind the variables
616:
617: dbms_sql.bind_variable(l_cursor,':Y',
618: 'Y');
619: dbms_sql.bind_variable(l_cursor,':msg_count',
620: l_msg_count);
621: dbms_sql.bind_variable(l_cursor,':msg_data',
622: l_msg_data);
623: dbms_sql.bind_variable(l_cursor,':return_status',

Line 621: dbms_sql.bind_variable(l_cursor,':msg_data',

617: dbms_sql.bind_variable(l_cursor,':Y',
618: 'Y');
619: dbms_sql.bind_variable(l_cursor,':msg_count',
620: l_msg_count);
621: dbms_sql.bind_variable(l_cursor,':msg_data',
622: l_msg_data);
623: dbms_sql.bind_variable(l_cursor,':return_status',
624: l_return_status);
625: -- execute the statement

Line 623: dbms_sql.bind_variable(l_cursor,':return_status',

619: dbms_sql.bind_variable(l_cursor,':msg_count',
620: l_msg_count);
621: dbms_sql.bind_variable(l_cursor,':msg_data',
622: l_msg_data);
623: dbms_sql.bind_variable(l_cursor,':return_status',
624: l_return_status);
625: -- execute the statement
626: l_rows := dbms_sql.execute(l_cursor);
627:

Line 626: l_rows := dbms_sql.execute(l_cursor);

622: l_msg_data);
623: dbms_sql.bind_variable(l_cursor,':return_status',
624: l_return_status);
625: -- execute the statement
626: l_rows := dbms_sql.execute(l_cursor);
627:
628: -- retrieve the values for the output variables
629: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);
630: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);

Line 629: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);

625: -- execute the statement
626: l_rows := dbms_sql.execute(l_cursor);
627:
628: -- retrieve the values for the output variables
629: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);
630: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);
631: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);
632:
633: IF ( l_return_status <> 'S') THEN

Line 630: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);

626: l_rows := dbms_sql.execute(l_cursor);
627:
628: -- retrieve the values for the output variables
629: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);
630: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);
631: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);
632:
633: IF ( l_return_status <> 'S') THEN
634: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 631: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);

627:
628: -- retrieve the values for the output variables
629: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);
630: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);
631: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);
632:
633: IF ( l_return_status <> 'S') THEN
634: IF P_PA_DEBUG_MODE = 'Y' THEN
635: PA_DEBUG.g_err_stage := 'After executing Dynamic SQL () with error';

Line 643: dbms_sql.close_cursor(l_cursor);

639: IF P_PA_DEBUG_MODE = 'Y' THEN
640: PA_DEBUG.g_err_stage := 'After executing Dynamic SQL () with success';
641: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
642: END IF;
643: dbms_sql.close_cursor(l_cursor);
644: END IF;
645:
646: EXCEPTION
647: WHEN others THEN

Line 648: dbms_sql.close_cursor(l_cursor);

644: END IF;
645:
646: EXCEPTION
647: WHEN others THEN
648: dbms_sql.close_cursor(l_cursor);
649: pa_debug.write_file('LOG', 'Error executing Dynamic SQL () exception: Others '||sqlerrm);
650: END;
651: IF P_PA_DEBUG_MODE = 'Y' THEN
652: PA_DEBUG.write_file('LOG', 'End of Step 2 . . Called Business Event API to get the measure value');

Line 807: l_cursor := dbms_sql.open_cursor;

803:
804: l_return_status := 'S';
805:
806: -- Get cursor handle
807: l_cursor := dbms_sql.open_cursor;
808:
809: -- Associate a sql statement with the cursor.
810:
811: l_stmt := 'BEGIN '||l_program_name ||

Line 825: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);

821: ' END;';
822:
823: -- parse the sql statemnt to check for any syntax or symantic errors
824:
825: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
826:
827: -- before executing the sql statement bind the variables
828:
829: dbms_sql.bind_variable(l_cursor,':object_type',

Line 829: dbms_sql.bind_variable(l_cursor,':object_type',

825: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
826:
827: -- before executing the sql statement bind the variables
828:
829: dbms_sql.bind_variable(l_cursor,':object_type',
830: 'PA_PROJECTS');
831: dbms_sql.bind_variable(l_cursor,':object_list',
832: l_object_list(i));
833: dbms_sql.bind_variable(l_cursor,':measure_list',

Line 831: dbms_sql.bind_variable(l_cursor,':object_list',

827: -- before executing the sql statement bind the variables
828:
829: dbms_sql.bind_variable(l_cursor,':object_type',
830: 'PA_PROJECTS');
831: dbms_sql.bind_variable(l_cursor,':object_list',
832: l_object_list(i));
833: dbms_sql.bind_variable(l_cursor,':measure_list',
834: l_measure_list(j));
835: dbms_sql.bind_variable(l_cursor,':period_type',

Line 833: dbms_sql.bind_variable(l_cursor,':measure_list',

829: dbms_sql.bind_variable(l_cursor,':object_type',
830: 'PA_PROJECTS');
831: dbms_sql.bind_variable(l_cursor,':object_list',
832: l_object_list(i));
833: dbms_sql.bind_variable(l_cursor,':measure_list',
834: l_measure_list(j));
835: dbms_sql.bind_variable(l_cursor,':period_type',
836: l_period_type);
837: dbms_sql.bind_variable(l_cursor,':measure_value',

Line 835: dbms_sql.bind_variable(l_cursor,':period_type',

831: dbms_sql.bind_variable(l_cursor,':object_list',
832: l_object_list(i));
833: dbms_sql.bind_variable(l_cursor,':measure_list',
834: l_measure_list(j));
835: dbms_sql.bind_variable(l_cursor,':period_type',
836: l_period_type);
837: dbms_sql.bind_variable(l_cursor,':measure_value',
838: l_measure_value);
839: dbms_sql.bind_variable(l_cursor,':period_name',

Line 837: dbms_sql.bind_variable(l_cursor,':measure_value',

833: dbms_sql.bind_variable(l_cursor,':measure_list',
834: l_measure_list(j));
835: dbms_sql.bind_variable(l_cursor,':period_type',
836: l_period_type);
837: dbms_sql.bind_variable(l_cursor,':measure_value',
838: l_measure_value);
839: dbms_sql.bind_variable(l_cursor,':period_name',
840: l_period_name);
841: dbms_sql.bind_variable(l_cursor,':return_status',

Line 839: dbms_sql.bind_variable(l_cursor,':period_name',

835: dbms_sql.bind_variable(l_cursor,':period_type',
836: l_period_type);
837: dbms_sql.bind_variable(l_cursor,':measure_value',
838: l_measure_value);
839: dbms_sql.bind_variable(l_cursor,':period_name',
840: l_period_name);
841: dbms_sql.bind_variable(l_cursor,':return_status',
842: l_return_status);
843: dbms_sql.bind_variable(l_cursor,':msg_count',

Line 841: dbms_sql.bind_variable(l_cursor,':return_status',

837: dbms_sql.bind_variable(l_cursor,':measure_value',
838: l_measure_value);
839: dbms_sql.bind_variable(l_cursor,':period_name',
840: l_period_name);
841: dbms_sql.bind_variable(l_cursor,':return_status',
842: l_return_status);
843: dbms_sql.bind_variable(l_cursor,':msg_count',
844: l_msg_count);
845: dbms_sql.bind_variable(l_cursor,':msg_data',

Line 843: dbms_sql.bind_variable(l_cursor,':msg_count',

839: dbms_sql.bind_variable(l_cursor,':period_name',
840: l_period_name);
841: dbms_sql.bind_variable(l_cursor,':return_status',
842: l_return_status);
843: dbms_sql.bind_variable(l_cursor,':msg_count',
844: l_msg_count);
845: dbms_sql.bind_variable(l_cursor,':msg_data',
846: l_msg_data);
847:

Line 845: dbms_sql.bind_variable(l_cursor,':msg_data',

841: dbms_sql.bind_variable(l_cursor,':return_status',
842: l_return_status);
843: dbms_sql.bind_variable(l_cursor,':msg_count',
844: l_msg_count);
845: dbms_sql.bind_variable(l_cursor,':msg_data',
846: l_msg_data);
847:
848: -- execute the statement
849: l_rows := dbms_sql.execute(l_cursor);

Line 849: l_rows := dbms_sql.execute(l_cursor);

845: dbms_sql.bind_variable(l_cursor,':msg_data',
846: l_msg_data);
847:
848: -- execute the statement
849: l_rows := dbms_sql.execute(l_cursor);
850:
851: -- retrieve the values for the output variables
852: dbms_sql.variable_value(l_cursor, ':measure_value', l_measure_value);
853: dbms_sql.variable_value(l_cursor, ':period_name', l_period_name);

Line 852: dbms_sql.variable_value(l_cursor, ':measure_value', l_measure_value);

848: -- execute the statement
849: l_rows := dbms_sql.execute(l_cursor);
850:
851: -- retrieve the values for the output variables
852: dbms_sql.variable_value(l_cursor, ':measure_value', l_measure_value);
853: dbms_sql.variable_value(l_cursor, ':period_name', l_period_name);
854: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);
855: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);
856: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);

Line 853: dbms_sql.variable_value(l_cursor, ':period_name', l_period_name);

849: l_rows := dbms_sql.execute(l_cursor);
850:
851: -- retrieve the values for the output variables
852: dbms_sql.variable_value(l_cursor, ':measure_value', l_measure_value);
853: dbms_sql.variable_value(l_cursor, ':period_name', l_period_name);
854: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);
855: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);
856: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);
857:

Line 854: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);

850:
851: -- retrieve the values for the output variables
852: dbms_sql.variable_value(l_cursor, ':measure_value', l_measure_value);
853: dbms_sql.variable_value(l_cursor, ':period_name', l_period_name);
854: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);
855: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);
856: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);
857:
858: -- Check if the call to Get Measure Value API is successful

Line 855: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);

851: -- retrieve the values for the output variables
852: dbms_sql.variable_value(l_cursor, ':measure_value', l_measure_value);
853: dbms_sql.variable_value(l_cursor, ':period_name', l_period_name);
854: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);
855: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);
856: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);
857:
858: -- Check if the call to Get Measure Value API is successful
859: IF ( l_return_status <> 'S' ) THEN

Line 856: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);

852: dbms_sql.variable_value(l_cursor, ':measure_value', l_measure_value);
853: dbms_sql.variable_value(l_cursor, ':period_name', l_period_name);
854: dbms_sql.variable_value(l_cursor, ':return_status', l_return_status);
855: dbms_sql.variable_value(l_cursor, ':msg_count', l_msg_count);
856: dbms_sql.variable_value(l_cursor, ':msg_data', l_msg_data);
857:
858: -- Check if the call to Get Measure Value API is successful
859: IF ( l_return_status <> 'S' ) THEN
860: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 887: dbms_sql.close_cursor(l_cursor);

883: IF P_PA_DEBUG_MODE = 'Y' THEN
884: pa_debug.write_file('LOG','Updating PA_PERF_TEMP_OBJ_MEASURE () with success');
885: END IF;
886: END IF;
887: dbms_sql.close_cursor(l_cursor);
888: END IF;
889:
890: EXCEPTION
891: WHEN others THEN

Line 892: dbms_sql.close_cursor(l_cursor);

888: END IF;
889:
890: EXCEPTION
891: WHEN others THEN
892: dbms_sql.close_cursor(l_cursor);
893: pa_debug.write_file('LOG','Error executing Dynamic SQL () exception: Others '||sqlerrm);
894: END;
895: -- till here for dynamic SQL --
896: ELSE