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

Line 56: v_cursorID := DBMS_SQL.OPEN_CURSOR;

52:
53: IEB_SYNC_SERVER.SYNC_SERVER(p_language, x_return_status);
54:
55:
56: v_cursorID := DBMS_SQL.OPEN_CURSOR;
57:
58: v_selectStmt := 'select WBSVR_ID, WB_SERVER_NAME, LOG_FILE_NAME,
59: LOG_DBC_FILE_NAME, CCI_DBC_FILE_NAME, STAT_DUMP_SUNDAY_Y_N,
60: STAT_DUMP_MONDAY_Y_N, STAT_DUMP_TUESDAY_Y_N,

Line 65: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);

61: STAT_DUMP_WEDNESDAY_Y_N, DESCRIPTION
62: from IEB_WB_SERVERS
63: order by ' || p_order_by || ' ' || p_asc;
64:
65: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);
66:
67: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_serverId);
68: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_serverName, 80);
69: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_fileName, 256);

Line 67: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_serverId);

63: order by ' || p_order_by || ' ' || p_asc;
64:
65: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);
66:
67: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_serverId);
68: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_serverName, 80);
69: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_fileName, 256);
70: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_logDbcFileName, 256);
71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);

Line 68: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_serverName, 80);

64:
65: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);
66:
67: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_serverId);
68: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_serverName, 80);
69: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_fileName, 256);
70: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_logDbcFileName, 256);
71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);
72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);

Line 69: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_fileName, 256);

65: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);
66:
67: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_serverId);
68: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_serverName, 80);
69: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_fileName, 256);
70: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_logDbcFileName, 256);
71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);
72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);
73: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_monday, 1);

Line 70: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_logDbcFileName, 256);

66:
67: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_serverId);
68: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_serverName, 80);
69: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_fileName, 256);
70: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_logDbcFileName, 256);
71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);
72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);
73: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_monday, 1);
74: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_tuesday, 1);

Line 71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);

67: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_serverId);
68: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_serverName, 80);
69: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_fileName, 256);
70: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_logDbcFileName, 256);
71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);
72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);
73: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_monday, 1);
74: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_tuesday, 1);
75: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_wednesday,1);

Line 72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);

68: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_serverName, 80);
69: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_fileName, 256);
70: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_logDbcFileName, 256);
71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);
72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);
73: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_monday, 1);
74: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_tuesday, 1);
75: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_wednesday,1);
76: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_desc, 240);

Line 73: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_monday, 1);

69: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_fileName, 256);
70: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_logDbcFileName, 256);
71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);
72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);
73: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_monday, 1);
74: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_tuesday, 1);
75: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_wednesday,1);
76: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_desc, 240);
77:

Line 74: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_tuesday, 1);

70: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_logDbcFileName, 256);
71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);
72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);
73: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_monday, 1);
74: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_tuesday, 1);
75: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_wednesday,1);
76: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_desc, 240);
77:
78: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);

Line 75: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_wednesday,1);

71: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cciDbcFileName, 256);
72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);
73: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_monday, 1);
74: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_tuesday, 1);
75: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_wednesday,1);
76: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_desc, 240);
77:
78: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
79:

Line 76: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_desc, 240);

72: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_sunday, 1);
73: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_monday, 1);
74: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_tuesday, 1);
75: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_wednesday,1);
76: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_desc, 240);
77:
78: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
79:
80: x_wb_servers_list := SYSTEM.IEB_WB_SERVERS_DATA_NST();

Line 78: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);

74: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_tuesday, 1);
75: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_wednesday,1);
76: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_desc, 240);
77:
78: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
79:
80: x_wb_servers_list := SYSTEM.IEB_WB_SERVERS_DATA_NST();
81: loop
82: if DBMS_SQL.FETCH_ROWS(v_cursorID) = 0 then

Line 82: if DBMS_SQL.FETCH_ROWS(v_cursorID) = 0 then

78: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
79:
80: x_wb_servers_list := SYSTEM.IEB_WB_SERVERS_DATA_NST();
81: loop
82: if DBMS_SQL.FETCH_ROWS(v_cursorID) = 0 then
83: exit;
84: end if;
85:
86: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_serverId);

Line 86: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_serverId);

82: if DBMS_SQL.FETCH_ROWS(v_cursorID) = 0 then
83: exit;
84: end if;
85:
86: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_serverId);
87: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_serverName);
88: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_fileName);
89: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_logDbcFileName);
90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);

Line 87: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_serverName);

83: exit;
84: end if;
85:
86: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_serverId);
87: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_serverName);
88: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_fileName);
89: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_logDbcFileName);
90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);
91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);

Line 88: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_fileName);

84: end if;
85:
86: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_serverId);
87: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_serverName);
88: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_fileName);
89: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_logDbcFileName);
90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);
91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);
92: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_monday);

Line 89: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_logDbcFileName);

85:
86: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_serverId);
87: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_serverName);
88: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_fileName);
89: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_logDbcFileName);
90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);
91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);
92: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_monday);
93: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_tuesday);

Line 90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);

86: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_serverId);
87: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_serverName);
88: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_fileName);
89: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_logDbcFileName);
90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);
91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);
92: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_monday);
93: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_tuesday);
94: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_wednesday);

Line 91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);

87: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_serverName);
88: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_fileName);
89: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_logDbcFileName);
90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);
91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);
92: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_monday);
93: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_tuesday);
94: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_wednesday);
95: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_desc);

Line 92: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_monday);

88: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_fileName);
89: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_logDbcFileName);
90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);
91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);
92: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_monday);
93: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_tuesday);
94: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_wednesday);
95: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_desc);
96:

Line 93: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_tuesday);

89: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_logDbcFileName);
90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);
91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);
92: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_monday);
93: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_tuesday);
94: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_wednesday);
95: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_desc);
96:
97: x_wb_servers_list.EXTEND;

Line 94: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_wednesday);

90: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cciDbcFileName);
91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);
92: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_monday);
93: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_tuesday);
94: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_wednesday);
95: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_desc);
96:
97: x_wb_servers_list.EXTEND;
98: x_wb_servers_list(x_wb_servers_list.LAST) := SYSTEM.IEB_WB_SERVERS_DATA_OBJ(v_serverId,

Line 95: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_desc);

91: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_sunday);
92: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_monday);
93: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_tuesday);
94: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_wednesday);
95: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_desc);
96:
97: x_wb_servers_list.EXTEND;
98: x_wb_servers_list(x_wb_servers_list.LAST) := SYSTEM.IEB_WB_SERVERS_DATA_OBJ(v_serverId,
99: v_serverName,

Line 118: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

114: v_param1, v_param2,
115: v_param3, v_param4,
116: v_checkNew);
117: end loop;
118: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
119: EXCEPTION
120: WHEN fnd_api.g_exc_error THEN
121: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
122: x_return_status := fnd_api.g_ret_sts_error;

Line 121: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

117: end loop;
118: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
119: EXCEPTION
120: WHEN fnd_api.g_exc_error THEN
121: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
122: x_return_status := fnd_api.g_ret_sts_error;
123:
124: WHEN fnd_api.g_exc_unexpected_error THEN
125: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

Line 125: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

121: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
122: x_return_status := fnd_api.g_ret_sts_error;
123:
124: WHEN fnd_api.g_exc_unexpected_error THEN
125: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
126: x_return_status := fnd_api.g_ret_sts_unexp_error;
127:
128: WHEN OTHERS THEN
129: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

Line 129: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

125: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
126: x_return_status := fnd_api.g_ret_sts_unexp_error;
127:
128: WHEN OTHERS THEN
129: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
130: x_return_status := fnd_api.g_ret_sts_unexp_error;
131: END GET_WB_SERVER_LIST;
132:
133: PROCEDURE SYNC_SERVER (