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.CAC_NOTES_PVT dependencies on JTF_NOTE_CONTEXTS

Line 547: INSERT INTO JTF_NOTE_CONTEXTS

543: userenv('LANG')
544: from FND_LANGUAGES L
545: where L.INSTALLED_FLAG in ('I', 'B');
546:
547: INSERT INTO JTF_NOTE_CONTEXTS
548: ( NOTE_CONTEXT_ID,
549: JTF_NOTE_ID,
550: NOTE_CONTEXT_TYPE_ID,
551: NOTE_CONTEXT_TYPE,

Line 1153: DELETE FROM jtf_note_contexts WHERE jtf_note_id = p_jtf_note_id;

1149:
1150: --
1151: -- Delete the note and it's references
1152: --
1153: DELETE FROM jtf_note_contexts WHERE jtf_note_id = p_jtf_note_id;
1154: DELETE FROM jtf_notes_tl WHERE jtf_note_id = p_jtf_note_id;
1155: DELETE FROM jtf_notes_b WHERE jtf_note_id = p_jtf_note_id;
1156:
1157:

Line 1202: -- creates a record in the JTF_NOTE_CONTEXTS table.

1198:
1199: PROCEDURE create_note_context
1200: ------------------------------------------------------------------------------
1201: -- create_note_context
1202: -- creates a record in the JTF_NOTE_CONTEXTS table.
1203: ------------------------------------------------------------------------------
1204: ( p_note_context_id IN NUMBER
1205: , p_jtf_note_id IN NUMBER
1206: , p_note_context_type IN VARCHAR2

Line 1225: FROM jtf_note_contexts

1221: ( b_jtf_note_id IN NUMBER
1222: , b_note_context_type IN VARCHAR2
1223: , b_note_context_type_id IN NUMBER
1224: )IS SELECT note_context_id
1225: FROM jtf_note_contexts
1226: WHERE jtf_note_id = b_jtf_note_id
1227: AND note_context_type = b_note_context_type
1228: AND note_context_type_id = b_note_context_type_id;
1229:

Line 1265: INSERT INTO JTF_NOTE_CONTEXTS

1261: FETCH c_duplicate INTO x_note_context_id;
1262:
1263: IF (c_duplicate%NOTFOUND)
1264: THEN
1265: INSERT INTO JTF_NOTE_CONTEXTS
1266: (
1267: NOTE_CONTEXT_ID,
1268: JTF_NOTE_ID,
1269: NOTE_CONTEXT_TYPE_ID,

Line 1349: -- updates a record in the JTF_NOTE_CONTEXTS table.

1345:
1346: PROCEDURE update_note_context
1347: ------------------------------------------------------------------------------
1348: -- update_note_context
1349: -- updates a record in the JTF_NOTE_CONTEXTS table.
1350: ------------------------------------------------------------------------------
1351: ( p_note_context_id IN NUMBER
1352: , p_jtf_note_id IN NUMBER := NULL
1353: , p_note_context_type IN VARCHAR2 := NULL

Line 1387: UPDATE JTF_NOTE_CONTEXTS

1383: THEN
1384: RAISE fnd_api.g_exc_error;
1385: END IF;
1386:
1387: UPDATE JTF_NOTE_CONTEXTS
1388: SET
1389: JTF_NOTE_ID = NVL(p_jtf_note_id,JTF_NOTE_ID),
1390: NOTE_CONTEXT_TYPE_ID = NVL(p_note_context_type_id,NOTE_CONTEXT_TYPE_ID),
1391: NOTE_CONTEXT_TYPE = NVL(p_note_context_type,NOTE_CONTEXT_TYPE),

Line 1447: -- deletes a record in the JTF_NOTE_CONTEXTS table.

1443:
1444: PROCEDURE delete_note_context
1445: ------------------------------------------------------------------------------
1446: -- delete_note_context
1447: -- deletes a record in the JTF_NOTE_CONTEXTS table.
1448: ------------------------------------------------------------------------------
1449: ( p_note_context_id IN NUMBER
1450: , x_return_status OUT NOCOPY VARCHAR2
1451: , x_msg_count OUT NOCOPY NUMBER

Line 1466: DELETE FROM JTF_NOTE_CONTEXTS

1462:
1463: -- Initialize return status to SUCCESS
1464: x_return_status := fnd_api.g_ret_sts_success;
1465:
1466: DELETE FROM JTF_NOTE_CONTEXTS
1467: WHERE NOTE_CONTEXT_ID = p_note_context_id;
1468:
1469: fnd_msg_pub.count_and_get( p_encoded => 'F'
1470: , p_count => x_msg_count