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.JTF_PREFAB_CACHE_PUB dependencies on JTF_PREFAB_HA_COMPS

Line 1188: p_ha_comp_id OUT NOCOPY jtf_prefab_ha_comps.ha_comp_id%TYPE,

1184: p_api_version IN NUMBER,
1185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1187:
1188: p_ha_comp_id OUT NOCOPY jtf_prefab_ha_comps.ha_comp_id%TYPE,
1189: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
1190: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
1191: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1192: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,

Line 1189: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,

1185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1187:
1188: p_ha_comp_id OUT NOCOPY jtf_prefab_ha_comps.ha_comp_id%TYPE,
1189: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
1190: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
1191: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1192: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1193: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,

Line 1190: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,

1186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1187:
1188: p_ha_comp_id OUT NOCOPY jtf_prefab_ha_comps.ha_comp_id%TYPE,
1189: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
1190: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
1191: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1192: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1193: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1194:

Line 1191: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,

1187:
1188: p_ha_comp_id OUT NOCOPY jtf_prefab_ha_comps.ha_comp_id%TYPE,
1189: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
1190: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
1191: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1192: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1193: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1194:
1195: p_object_version_number OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,

Line 1192: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,

1188: p_ha_comp_id OUT NOCOPY jtf_prefab_ha_comps.ha_comp_id%TYPE,
1189: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
1190: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
1191: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1192: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1193: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1194:
1195: p_object_version_number OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,
1196:

Line 1193: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,

1189: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
1190: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
1191: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1192: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1193: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1194:
1195: p_object_version_number OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,
1196:
1197: x_return_status OUT NOCOPY VARCHAR2,

Line 1195: p_object_version_number OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,

1191: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1192: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1193: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1194:
1195: p_object_version_number OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,
1196:
1197: x_return_status OUT NOCOPY VARCHAR2,
1198: x_msg_count OUT NOCOPY NUMBER,
1199: x_msg_data OUT NOCOPY VARCHAR2

Line 1206: SELECT jtf_prefab_ha_comps_s.NEXTVAL from dual;

1202: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_HA_COMP';
1203: l_api_version NUMBER := p_api_version;
1204:
1205: CURSOR sequence_cursor IS
1206: SELECT jtf_prefab_ha_comps_s.NEXTVAL from dual;
1207: BEGIN
1208: -- Standard Start of API savepoint
1209: SAVEPOINT INSERT_HA_COMP;
1210:

Line 1237: INSERT INTO jtf_prefab_ha_comps (ha_comp_id,

1233: FETCH sequence_cursor INTO p_ha_comp_id;
1234: CLOSE sequence_cursor;
1235: p_object_version_number := 1;
1236:
1237: INSERT INTO jtf_prefab_ha_comps (ha_comp_id,
1238: object_version_number,
1239: created_by,
1240: creation_date,
1241: last_updated_by,

Line 1313: p_ha_comp_id IN jtf_prefab_ha_comps.ha_comp_id%TYPE,

1309: p_api_version IN NUMBER,
1310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1311: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1312:
1313: p_ha_comp_id IN jtf_prefab_ha_comps.ha_comp_id%TYPE,
1314: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1315: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1316: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1317:

Line 1314: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,

1310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1311: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1312:
1313: p_ha_comp_id IN jtf_prefab_ha_comps.ha_comp_id%TYPE,
1314: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1315: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1316: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1317:
1318: p_object_version_number IN OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,

Line 1315: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,

1311: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1312:
1313: p_ha_comp_id IN jtf_prefab_ha_comps.ha_comp_id%TYPE,
1314: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1315: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1316: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1317:
1318: p_object_version_number IN OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,
1319:

Line 1316: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,

1312:
1313: p_ha_comp_id IN jtf_prefab_ha_comps.ha_comp_id%TYPE,
1314: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1315: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1316: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1317:
1318: p_object_version_number IN OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,
1319:
1320: x_return_status OUT NOCOPY VARCHAR2,

Line 1318: p_object_version_number IN OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,

1314: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
1315: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,
1316: p_cache_reload_flag IN jtf_prefab_ha_comps.cache_reload_flag%TYPE,
1317:
1318: p_object_version_number IN OUT NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,
1319:
1320: x_return_status OUT NOCOPY VARCHAR2,
1321: x_msg_count OUT NOCOPY NUMBER,
1322: x_msg_data OUT NOCOPY VARCHAR2

Line 1353: UPDATE jtf_prefab_ha_comps

1349:
1350: -- real logic --
1351: ----------------
1352:
1353: UPDATE jtf_prefab_ha_comps
1354: SET object_version_number = p_object_version_number,
1355: last_updated_by = G_USER_ID,
1356: last_update_date = SYSDATE,
1357: last_update_login = G_LOGIN_ID,

Line 1412: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,

1408: p_api_version IN NUMBER,
1409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1410: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1411:
1412: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
1413:
1414: p_object_version_number IN jtf_prefab_ha_comps.object_version_number%TYPE,
1415:
1416: x_return_status OUT NOCOPY VARCHAR2,

Line 1414: p_object_version_number IN jtf_prefab_ha_comps.object_version_number%TYPE,

1410: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1411:
1412: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
1413:
1414: p_object_version_number IN jtf_prefab_ha_comps.object_version_number%TYPE,
1415:
1416: x_return_status OUT NOCOPY VARCHAR2,
1417: x_msg_count OUT NOCOPY NUMBER,
1418: x_msg_data OUT NOCOPY VARCHAR2

Line 1448: DELETE FROM jtf_prefab_ha_comps

1444:
1445: -- real logic --
1446: ----------------
1447:
1448: DELETE FROM jtf_prefab_ha_comps
1449: WHERE host_app_id = p_host_app_id;
1450:
1451: -----------------------
1452: -- end of real logic --

Line 1500: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,

1496: p_api_version IN NUMBER,
1497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1498: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1499:
1500: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
1501:
1502: p_object_version_number IN jtf_prefab_ha_comps.object_version_number%TYPE,
1503:
1504: x_return_status OUT NOCOPY VARCHAR2,

Line 1502: p_object_version_number IN jtf_prefab_ha_comps.object_version_number%TYPE,

1498: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1499:
1500: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
1501:
1502: p_object_version_number IN jtf_prefab_ha_comps.object_version_number%TYPE,
1503:
1504: x_return_status OUT NOCOPY VARCHAR2,
1505: x_msg_count OUT NOCOPY NUMBER,
1506: x_msg_data OUT NOCOPY VARCHAR2

Line 1536: DELETE FROM jtf_prefab_ha_comps

1532:
1533: -- real logic --
1534: ----------------
1535:
1536: DELETE FROM jtf_prefab_ha_comps
1537: WHERE ca_comp_id = p_ca_comp_id;
1538:
1539: -----------------------
1540: -- end of real logic --