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_POLICY_PUB dependencies on JTF_PREFAB_WSHP_POLICIES

Line 1252: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,

1248: p_api_version IN NUMBER,
1249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1251:
1252: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
1253: p_port IN jtf_prefab_wshp_policies.port%TYPE,
1254:
1255: p_object_version_number OUT NOCOPY jtf_prefab_wshp_policies.object_version_number%TYPE,
1256:

Line 1253: p_port IN jtf_prefab_wshp_policies.port%TYPE,

1249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1251:
1252: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
1253: p_port IN jtf_prefab_wshp_policies.port%TYPE,
1254:
1255: p_object_version_number OUT NOCOPY jtf_prefab_wshp_policies.object_version_number%TYPE,
1256:
1257: x_return_status OUT NOCOPY VARCHAR2,

Line 1255: p_object_version_number OUT NOCOPY jtf_prefab_wshp_policies.object_version_number%TYPE,

1251:
1252: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
1253: p_port IN jtf_prefab_wshp_policies.port%TYPE,
1254:
1255: p_object_version_number OUT NOCOPY jtf_prefab_wshp_policies.object_version_number%TYPE,
1256:
1257: x_return_status OUT NOCOPY VARCHAR2,
1258: x_msg_count OUT NOCOPY NUMBER,
1259: x_msg_data OUT NOCOPY VARCHAR2

Line 1291: INSERT INTO jtf_prefab_wshp_policies (wshp_policy_id,

1287: -- real logic --
1288: ----------------
1289: p_object_version_number := 1;
1290:
1291: INSERT INTO jtf_prefab_wshp_policies (wshp_policy_id,
1292: object_version_number,
1293: created_by,
1294: creation_date,
1295: last_updated_by,

Line 1301: VALUES (jtf_prefab_wshp_policies_s.NEXTVAL,

1297: last_update_login,
1298: -- security_group_id,
1299: wsh_po_id,
1300: port)
1301: VALUES (jtf_prefab_wshp_policies_s.NEXTVAL,
1302: p_object_version_number,
1303: G_USER_ID,
1304: SYSDATE,
1305: G_USER_ID,

Line 1361: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,

1357: p_api_version IN NUMBER,
1358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1360:
1361: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
1362: p_port IN jtf_prefab_wshp_policies.port%TYPE,
1363:
1364: p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,
1365:

Line 1362: p_port IN jtf_prefab_wshp_policies.port%TYPE,

1358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1360:
1361: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
1362: p_port IN jtf_prefab_wshp_policies.port%TYPE,
1363:
1364: p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,
1365:
1366: x_return_status OUT NOCOPY VARCHAR2,

Line 1364: p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,

1360:
1361: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
1362: p_port IN jtf_prefab_wshp_policies.port%TYPE,
1363:
1364: p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,
1365:
1366: x_return_status OUT NOCOPY VARCHAR2,
1367: x_msg_count OUT NOCOPY NUMBER,
1368: x_msg_data OUT NOCOPY VARCHAR2

Line 1398: DELETE FROM jtf_prefab_wshp_policies

1394:
1395: -- real logic --
1396: ----------------
1397:
1398: DELETE FROM jtf_prefab_wshp_policies
1399: WHERE wsh_po_id = p_wsh_po_id
1400: AND port = p_port;
1401:
1402: -----------------------

Line 1451: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,

1447: p_api_version IN NUMBER,
1448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1449: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1450:
1451: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
1452:
1453: p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,
1454:
1455: x_return_status OUT NOCOPY VARCHAR2,

Line 1453: p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,

1449: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1450:
1451: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
1452:
1453: p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,
1454:
1455: x_return_status OUT NOCOPY VARCHAR2,
1456: x_msg_count OUT NOCOPY NUMBER,
1457: x_msg_data OUT NOCOPY VARCHAR2

Line 1487: DELETE FROM jtf_prefab_wshp_policies

1483:
1484: -- real logic --
1485: ----------------
1486:
1487: DELETE FROM jtf_prefab_wshp_policies
1488: WHERE wsh_po_id = p_wsh_po_id;
1489:
1490: -----------------------
1491: -- end of real logic --