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

Line 998: l_cursorName := DBMS_SQL.Open_Cursor;

994: end if;
995: l_sql_stmt := l_sql_stmt||'); END;';
996:
997: --Opening the cursor and parsing
998: l_cursorName := DBMS_SQL.Open_Cursor;
999: DBMS_SQL.Parse(l_cursorName, l_sql_stmt, DBMS_SQL.NATIVE);
1000:
1001: --Binding the mandatory parameters.
1002: DBMS_SQL.Bind_Variable(l_cursorName, ':1', l_call_method);

Line 999: DBMS_SQL.Parse(l_cursorName, l_sql_stmt, DBMS_SQL.NATIVE);

995: l_sql_stmt := l_sql_stmt||'); END;';
996:
997: --Opening the cursor and parsing
998: l_cursorName := DBMS_SQL.Open_Cursor;
999: DBMS_SQL.Parse(l_cursorName, l_sql_stmt, DBMS_SQL.NATIVE);
1000:
1001: --Binding the mandatory parameters.
1002: DBMS_SQL.Bind_Variable(l_cursorName, ':1', l_call_method);
1003: DBMS_SQL.Bind_Variable(l_cursorName, ':2', p_lov_name);

Line 1002: DBMS_SQL.Bind_Variable(l_cursorName, ':1', l_call_method);

998: l_cursorName := DBMS_SQL.Open_Cursor;
999: DBMS_SQL.Parse(l_cursorName, l_sql_stmt, DBMS_SQL.NATIVE);
1000:
1001: --Binding the mandatory parameters.
1002: DBMS_SQL.Bind_Variable(l_cursorName, ':1', l_call_method);
1003: DBMS_SQL.Bind_Variable(l_cursorName, ':2', p_lov_name);
1004: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_start_row);
1005: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_number_rows);
1006: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_hidden_value);

Line 1003: DBMS_SQL.Bind_Variable(l_cursorName, ':2', p_lov_name);

999: DBMS_SQL.Parse(l_cursorName, l_sql_stmt, DBMS_SQL.NATIVE);
1000:
1001: --Binding the mandatory parameters.
1002: DBMS_SQL.Bind_Variable(l_cursorName, ':1', l_call_method);
1003: DBMS_SQL.Bind_Variable(l_cursorName, ':2', p_lov_name);
1004: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_start_row);
1005: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_number_rows);
1006: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_hidden_value);
1007: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_display_value);

Line 1004: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_start_row);

1000:
1001: --Binding the mandatory parameters.
1002: DBMS_SQL.Bind_Variable(l_cursorName, ':1', l_call_method);
1003: DBMS_SQL.Bind_Variable(l_cursorName, ':2', p_lov_name);
1004: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_start_row);
1005: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_number_rows);
1006: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_hidden_value);
1007: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_display_value);
1008: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_result);

Line 1005: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_number_rows);

1001: --Binding the mandatory parameters.
1002: DBMS_SQL.Bind_Variable(l_cursorName, ':1', l_call_method);
1003: DBMS_SQL.Bind_Variable(l_cursorName, ':2', p_lov_name);
1004: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_start_row);
1005: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_number_rows);
1006: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_hidden_value);
1007: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_display_value);
1008: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_result);
1009:

Line 1006: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_hidden_value);

1002: DBMS_SQL.Bind_Variable(l_cursorName, ':1', l_call_method);
1003: DBMS_SQL.Bind_Variable(l_cursorName, ':2', p_lov_name);
1004: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_start_row);
1005: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_number_rows);
1006: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_hidden_value);
1007: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_display_value);
1008: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_result);
1009:
1010: --Binding the optional parameters.

Line 1007: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_display_value);

1003: DBMS_SQL.Bind_Variable(l_cursorName, ':2', p_lov_name);
1004: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_start_row);
1005: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_number_rows);
1006: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_hidden_value);
1007: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_display_value);
1008: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_result);
1009:
1010: --Binding the optional parameters.
1011: if (p_param1 is not null) then

Line 1008: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_result);

1004: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_start_row);
1005: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_number_rows);
1006: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_hidden_value);
1007: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_display_value);
1008: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_result);
1009:
1010: --Binding the optional parameters.
1011: if (p_param1 is not null) then
1012: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_param1);

Line 1012: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_param1);

1008: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_result);
1009:
1010: --Binding the optional parameters.
1011: if (p_param1 is not null) then
1012: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_param1);
1013: end if;
1014: if (p_param2 is not null) then
1015: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_param2);
1016: end if;

Line 1015: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_param2);

1011: if (p_param1 is not null) then
1012: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_param1);
1013: end if;
1014: if (p_param2 is not null) then
1015: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_param2);
1016: end if;
1017: if (p_param3 is not null) then
1018: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_param3);
1019: end if;

Line 1018: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_param3);

1014: if (p_param2 is not null) then
1015: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_param2);
1016: end if;
1017: if (p_param3 is not null) then
1018: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_param3);
1019: end if;
1020: if (p_param4 is not null) then
1021: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_param4);
1022: end if;

Line 1021: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_param4);

1017: if (p_param3 is not null) then
1018: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_param3);
1019: end if;
1020: if (p_param4 is not null) then
1021: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_param4);
1022: end if;
1023: if (p_param5 is not null) then
1024: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_param5);
1025: end if;

Line 1024: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_param5);

1020: if (p_param4 is not null) then
1021: DBMS_SQL.Bind_Variable(l_cursorName, ':11', p_param4);
1022: end if;
1023: if (p_param5 is not null) then
1024: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_param5);
1025: end if;
1026:
1027: --Executing the cursor.
1028: l_cursorResult := DBMS_SQL.Execute(l_cursorName);

Line 1028: l_cursorResult := DBMS_SQL.Execute(l_cursorName);

1024: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_param5);
1025: end if;
1026:
1027: --Executing the cursor.
1028: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
1029:
1030: --Storing out variables into local variables.
1031: DBMS_SQL.Variable_Value(l_cursorName, ':5', l_hidden_value);
1032: DBMS_SQL.Variable_Value(l_cursorName, ':6', l_display_value);

Line 1031: DBMS_SQL.Variable_Value(l_cursorName, ':5', l_hidden_value);

1027: --Executing the cursor.
1028: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
1029:
1030: --Storing out variables into local variables.
1031: DBMS_SQL.Variable_Value(l_cursorName, ':5', l_hidden_value);
1032: DBMS_SQL.Variable_Value(l_cursorName, ':6', l_display_value);
1033: DBMS_SQL.Variable_Value(l_cursorName, ':7', l_result);
1034:
1035: --Closing the cursor

Line 1032: DBMS_SQL.Variable_Value(l_cursorName, ':6', l_display_value);

1028: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
1029:
1030: --Storing out variables into local variables.
1031: DBMS_SQL.Variable_Value(l_cursorName, ':5', l_hidden_value);
1032: DBMS_SQL.Variable_Value(l_cursorName, ':6', l_display_value);
1033: DBMS_SQL.Variable_Value(l_cursorName, ':7', l_result);
1034:
1035: --Closing the cursor
1036: DBMS_SQL.Close_Cursor(l_cursorName);

Line 1033: DBMS_SQL.Variable_Value(l_cursorName, ':7', l_result);

1029:
1030: --Storing out variables into local variables.
1031: DBMS_SQL.Variable_Value(l_cursorName, ':5', l_hidden_value);
1032: DBMS_SQL.Variable_Value(l_cursorName, ':6', l_display_value);
1033: DBMS_SQL.Variable_Value(l_cursorName, ':7', l_result);
1034:
1035: --Closing the cursor
1036: DBMS_SQL.Close_Cursor(l_cursorName);
1037:

Line 1036: DBMS_SQL.Close_Cursor(l_cursorName);

1032: DBMS_SQL.Variable_Value(l_cursorName, ':6', l_display_value);
1033: DBMS_SQL.Variable_Value(l_cursorName, ':7', l_result);
1034:
1035: --Closing the cursor
1036: DBMS_SQL.Close_Cursor(l_cursorName);
1037:
1038: end if;
1039:
1040: else