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.AMS_WEB_TRACK_PVT dependencies on AMS_WEB_RECOMMS

Line 1448: SELECT ams_web_recomms_s.NEXTVAL

1444: l_org_id NUMBER := FND_API.G_MISS_NUM;
1445: l_web_recomm_id NUMBER;
1446: l_dummy NUMBER;
1447: CURSOR c_id IS
1448: SELECT ams_web_recomms_s.NEXTVAL
1449: FROM dual;
1450:
1451: CURSOR c_id_exists (l_id IN NUMBER) IS
1452: SELECT 1

Line 1453: FROM AMS_WEB_RECOMMS

1449: FROM dual;
1450:
1451: CURSOR c_id_exists (l_id IN NUMBER) IS
1452: SELECT 1
1453: FROM AMS_WEB_RECOMMS
1454: WHERE web_recomm_id = l_id;
1455: BEGIN
1456: -- Standard Start of API savepoint
1457: SAVEPOINT create_web_recomms_pvt;

Line 1539: -- Invoke table handler(Ams_Web_Recomms_Pkg.Insert_Row)

1535:
1536: -- Debug Message
1537: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
1538:
1539: -- Invoke table handler(Ams_Web_Recomms_Pkg.Insert_Row)
1540: Ams_Web_Recomms_Pkg.Insert_Row(
1541: px_web_recomm_id => l_web_recomm_id,
1542: p_web_tracking_id => p_web_recomms_rec.web_tracking_id,
1543: p_recomm_object_id => p_web_recomms_rec.recomm_object_id,

Line 1540: Ams_Web_Recomms_Pkg.Insert_Row(

1536: -- Debug Message
1537: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
1538:
1539: -- Invoke table handler(Ams_Web_Recomms_Pkg.Insert_Row)
1540: Ams_Web_Recomms_Pkg.Insert_Row(
1541: px_web_recomm_id => l_web_recomm_id,
1542: p_web_tracking_id => p_web_recomms_rec.web_tracking_id,
1543: p_recomm_object_id => p_web_recomms_rec.recomm_object_id,
1544: p_recomm_type => p_web_recomms_rec.recomm_type,

Line 1689: FROM AMS_WEB_RECOMMS

1685:
1686:
1687: CURSOR c_get_web_recomms(web_recomm_id NUMBER) IS
1688: SELECT *
1689: FROM AMS_WEB_RECOMMS
1690: WHERE web_recomm_id = p_web_recomms_rec.web_recomm_id;
1691: -- Hint: Developer need to provide Where clause
1692:
1693:

Line 1792: -- Invoke table handler(Ams_Web_Recomms_Pkg.Update_Row)

1788:
1789: -- Debug Message
1790: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
1791:
1792: -- Invoke table handler(Ams_Web_Recomms_Pkg.Update_Row)
1793: Ams_Web_Recomms_Pkg.Update_Row(
1794: p_web_recomm_id => p_web_recomms_rec.web_recomm_id,
1795: p_web_tracking_id => p_web_recomms_rec.web_tracking_id,
1796: p_recomm_object_id => p_web_recomms_rec.recomm_object_id,

Line 1793: Ams_Web_Recomms_Pkg.Update_Row(

1789: -- Debug Message
1790: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
1791:
1792: -- Invoke table handler(Ams_Web_Recomms_Pkg.Update_Row)
1793: Ams_Web_Recomms_Pkg.Update_Row(
1794: p_web_recomm_id => p_web_recomms_rec.web_recomm_id,
1795: p_web_tracking_id => p_web_recomms_rec.web_tracking_id,
1796: p_recomm_object_id => p_web_recomms_rec.recomm_object_id,
1797: p_recomm_type => p_web_recomms_rec.recomm_type,

Line 1971: -- Invoke table handler(Ams_Web_Recomms_Pkg.Delete_Row)

1967: --
1968: -- Debug Message
1969: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1970:
1971: -- Invoke table handler(Ams_Web_Recomms_Pkg.Delete_Row)
1972: Ams_Web_Recomms_Pkg.Delete_Row(
1973: p_web_recomm_id => p_web_recomm_id,
1974: p_object_version_number => p_object_version_number );
1975: --

Line 1972: Ams_Web_Recomms_Pkg.Delete_Row(

1968: -- Debug Message
1969: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1970:
1971: -- Invoke table handler(Ams_Web_Recomms_Pkg.Delete_Row)
1972: Ams_Web_Recomms_Pkg.Delete_Row(
1973: p_web_recomm_id => p_web_recomm_id,
1974: p_object_version_number => p_object_version_number );
1975: --
1976: -- End of API body

Line 2120: Ams_Web_Recomms_Pkg.Lock_Row(l_web_recomm_id,p_object_version);

2116: x_return_status := FND_API.G_RET_STS_SUCCESS;
2117:
2118:
2119: ------------------------ lock -------------------------
2120: Ams_Web_Recomms_Pkg.Lock_Row(l_web_recomm_id,p_object_version);
2121:
2122:
2123: -------------------- finish --------------------------
2124: FND_MSG_PUB.count_and_get(

Line 2186: 'ams_web_recomms',

2182: IF p_validation_mode = JTF_PLSQL_API.g_create
2183: AND p_web_recomms_rec.web_recomm_id IS NOT NULL
2184: THEN
2185: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2186: 'ams_web_recomms',
2187: 'web_recomm_id = ''' || p_web_recomms_rec.web_recomm_id ||''''
2188: );
2189: END IF;
2190:

Line 2333: FROM ams_web_recomms

2329: l_return_status VARCHAR2(1);
2330:
2331: CURSOR c_complete IS
2332: SELECT *
2333: FROM ams_web_recomms
2334: WHERE web_recomm_id = p_web_recomms_rec.web_recomm_id;
2335: l_web_recomms_rec c_complete%ROWTYPE;
2336: BEGIN
2337: x_complete_rec := p_web_recomms_rec;

Line 2866: -- dbms_output.put_line('before inserting into AMS_Web_Recomms web recomm id '|| l_web_recomm_id );

2862: p_web_recomms_rec => l_web_recomms_rec,
2863: x_web_recomm_id => l_web_recomm_id
2864: );
2865:
2866: -- dbms_output.put_line('before inserting into AMS_Web_Recomms web recomm id '|| l_web_recomm_id );
2867: --insert_log_mesg('Web Recomm Id ::::'||l_web_recomm_id);
2868:
2869: IF l_web_recomm_id IS NULL THEN
2870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN