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_NOTES_PUB dependencies on JTF_NOTE_CONTEXTS

Line 10: -- and JTF_NOTE_CONTEXTS table

6: PROCEDURE Create_note
7: ------------------------------------------------------------------------------
8: -- Create_note
9: -- Inserts a note record in the JTF_NOTES_B, JTF_NOTES_TL
10: -- and JTF_NOTE_CONTEXTS table
11: ------------------------------------------------------------------------------
12: ( p_parent_note_id IN NUMBER DEFAULT 9.99E125
13: , p_jtf_note_id IN NUMBER DEFAULT 9.99E125
14: , p_api_version IN NUMBER

Line 52: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type

48: , p_attribute14 IN VARCHAR2 DEFAULT NULL
49: , p_attribute15 IN VARCHAR2 DEFAULT NULL
50: , p_context IN VARCHAR2 DEFAULT NULL
51: , p_note_type IN VARCHAR2 DEFAULT NULL
52: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type
53: DEFAULT jtf_note_contexts_tab_dflt
54: )
55: IS
56: l_api_name CONSTANT VARCHAR2(30) := 'Create_note';

Line 53: DEFAULT jtf_note_contexts_tab_dflt

49: , p_attribute15 IN VARCHAR2 DEFAULT NULL
50: , p_context IN VARCHAR2 DEFAULT NULL
51: , p_note_type IN VARCHAR2 DEFAULT NULL
52: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type
53: DEFAULT jtf_note_contexts_tab_dflt
54: )
55: IS
56: l_api_name CONSTANT VARCHAR2(30) := 'Create_note';
57: l_api_name_full CONSTANT VARCHAR2(61) := g_pkg_name || '.' || l_api_name;

Line 126: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab

122: , p_attribute14 => p_attribute14
123: , p_attribute15 => p_attribute15
124: , p_context => p_context
125: , p_note_type => p_note_type
126: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab
127: , p_use_AOL_security => 'F'
128: );
129:
130: IF fnd_api.to_boolean(p_commit)

Line 197: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type

193: , p_notes_detail IN VARCHAR2 DEFAULT CHR(0)
194: , p_append_flag IN VARCHAR2 DEFAULT CHR(0)
195: , p_note_status IN VARCHAR2 DEFAULT 'I'
196: , p_note_type IN VARCHAR2 DEFAULT CHR(0)
197: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type
198: DEFAULT jtf_note_contexts_tab_dflt
199: )
200: IS
201: l_api_name CONSTANT VARCHAR2(30) := 'Update_note';

Line 198: DEFAULT jtf_note_contexts_tab_dflt

194: , p_append_flag IN VARCHAR2 DEFAULT CHR(0)
195: , p_note_status IN VARCHAR2 DEFAULT 'I'
196: , p_note_type IN VARCHAR2 DEFAULT CHR(0)
197: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type
198: DEFAULT jtf_note_contexts_tab_dflt
199: )
200: IS
201: l_api_name CONSTANT VARCHAR2(30) := 'Update_note';
202: l_api_version CONSTANT NUMBER := 1.0;

Line 254: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab

250: , p_notes_detail => p_notes_detail
251: , p_append_flag => p_append_flag
252: , p_note_status => p_note_status
253: , p_note_type => p_note_type
254: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab
255: , p_use_AOL_security => 'F'
256: );
257:
258: -- Standard check of p_commit

Line 384: FROM jtf_note_contexts

380: -- Cursor for retrieving from the table to verify insertion
381: CURSOR c_inserted
382: (b_note_context_id IN NUMBER
383: )IS SELECT 'x'
384: FROM jtf_note_contexts
385: WHERE note_context_id = b_note_context_id;
386:
387: -- Cursor that will check for duplicates
388: CURSOR c_duplicate

Line 393: FROM jtf_note_contexts

389: ( b_jtf_note_id IN NUMBER
390: , b_note_context_type IN VARCHAR2
391: , b_note_context_type_id IN NUMBER
392: )IS SELECT note_context_id
393: FROM jtf_note_contexts
394: WHERE jtf_note_id = b_jtf_note_id
395: AND note_context_type = b_note_context_type
396: AND note_context_type_id = b_note_context_type_id;
397:

Line 456: INSERT INTO jtf_note_contexts

452: FETCH c_duplicate INTO l_note_context_id;
453:
454: IF (c_duplicate%NOTFOUND)
455: THEN
456: INSERT INTO jtf_note_contexts
457: ( note_context_id
458: , jtf_note_id
459: , note_context_type_id
460: , note_context_type

Line 536: -- Updates a context record in the JTF_NOTE_CONTEXTS table

532: PROCEDURE Update_note_context
533: ------------------------------------------------------------------------------
534: -- Procedure : Update_note_context
535: --
536: -- Updates a context record in the JTF_NOTE_CONTEXTS table
537: ------------------------------------------------------------------------------
538: ( p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
539: , x_return_status OUT NOCOPY VARCHAR2
540: , p_note_context_id IN NUMBER

Line 557: FROM JTF_NOTE_CONTEXTS

553: l_note_context_type_id NUMBER;
554:
555: CURSOR lrec_note_context
556: IS SELECT *
557: FROM JTF_NOTE_CONTEXTS
558: WHERE note_context_id = p_note_context_id
559: FOR UPDATE OF note_context_id;
560:
561: l_context_rec lrec_note_context%ROWTYPE;

Line 624: UPDATE JTF_NOTE_CONTEXTS

620:
621: --
622: -- Perform the database operation.
623: --
624: UPDATE JTF_NOTE_CONTEXTS
625: SET last_updated_by = p_last_updated_by
626: , last_update_date = p_last_update_date
627: , last_update_login = p_last_update_login
628: , note_context_type_id = l_note_context_type_id

Line 960: -- and JTF_NOTE_CONTEXTS

956: -- API Name : Delete_Note will only work when the user is granted the
957: -- JTF_NOTE_DELETE privilege through AOL security framework
958: -- Type : Public
959: -- Usage : Deletes a note record in the table JTF_NOTES_B/JTF_NOTES_TL
960: -- and JTF_NOTE_CONTEXTS
961: -- Pre-reqs : None
962: -- Parameters :
963: -- p_api_version IN NUMBER Required
964: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

Line 1086: DELETE FROM jtf_note_contexts WHERE jtf_note_id = p_jtf_note_id;

1082:
1083: --
1084: -- Delete the note and it's references
1085: --
1086: DELETE FROM jtf_note_contexts WHERE jtf_note_id = p_jtf_note_id;
1087: DELETE FROM jtf_notes_tl WHERE jtf_note_id = p_jtf_note_id;
1088: DELETE FROM jtf_notes_b WHERE jtf_note_id = p_jtf_note_id;
1089:
1090: JTF_NOTES_EVENTS_PVT.RaiseDeleteNote

Line 1162: -- and JTF_NOTE_CONTEXTS table

1158: PROCEDURE Secure_Create_note
1159: ------------------------------------------------------------------------------
1160: -- Create_note
1161: -- Inserts a note record in the JTF_NOTES_B, JTF_NOTES_TL
1162: -- and JTF_NOTE_CONTEXTS table
1163: ------------------------------------------------------------------------------
1164: ( p_parent_note_id IN NUMBER DEFAULT 9.99E125
1165: , p_jtf_note_id IN NUMBER DEFAULT 9.99E125
1166: , p_api_version IN NUMBER

Line 1204: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type

1200: , p_attribute14 IN VARCHAR2 DEFAULT NULL
1201: , p_attribute15 IN VARCHAR2 DEFAULT NULL
1202: , p_context IN VARCHAR2 DEFAULT NULL
1203: , p_note_type IN VARCHAR2 DEFAULT NULL
1204: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type
1205: DEFAULT jtf_note_contexts_tab_dflt
1206: , p_use_AOL_security IN VARCHAR2 DEFAULT 'T'
1207:
1208: )

Line 1205: DEFAULT jtf_note_contexts_tab_dflt

1201: , p_attribute15 IN VARCHAR2 DEFAULT NULL
1202: , p_context IN VARCHAR2 DEFAULT NULL
1203: , p_note_type IN VARCHAR2 DEFAULT NULL
1204: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type
1205: DEFAULT jtf_note_contexts_tab_dflt
1206: , p_use_AOL_security IN VARCHAR2 DEFAULT 'T'
1207:
1208: )
1209: IS

Line 1336: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab

1332: , p_attribute14 => p_attribute14
1333: , p_attribute15 => p_attribute15
1334: , p_context => p_context
1335: , p_note_type => p_note_type
1336: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab
1337: , x_return_status => l_return_status
1338: );
1339:
1340: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 1395: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab

1391: , p_attribute14 => p_attribute14
1392: , p_attribute15 => p_attribute15
1393: , p_context => p_context
1394: , p_note_type => p_note_type
1395: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab
1396: , x_return_status => l_return_status
1397: );
1398:
1399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 1712: IF ( p_jtf_note_contexts_tab.COUNT > 0 )

1708: END IF;
1709: CLOSE l_insert_check_csr;
1710:
1711: -- Insert the contexts
1712: IF ( p_jtf_note_contexts_tab.COUNT > 0 )
1713: THEN
1714: FOR i IN 1..p_jtf_note_contexts_tab.COUNT
1715: LOOP
1716: create_note_context

Line 1714: FOR i IN 1..p_jtf_note_contexts_tab.COUNT

1710:
1711: -- Insert the contexts
1712: IF ( p_jtf_note_contexts_tab.COUNT > 0 )
1713: THEN
1714: FOR i IN 1..p_jtf_note_contexts_tab.COUNT
1715: LOOP
1716: create_note_context
1717: ( p_validation_level => p_validation_level
1718: , x_return_status => l_return_status

Line 1720: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date

1716: create_note_context
1717: ( p_validation_level => p_validation_level
1718: , x_return_status => l_return_status
1719: , p_jtf_note_id => l_jtf_note_id
1720: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
1721: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
1722: , p_creation_date => p_jtf_note_contexts_tab(i).creation_date
1723: , p_created_by => p_jtf_note_contexts_tab(i).created_by
1724: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login

Line 1721: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by

1717: ( p_validation_level => p_validation_level
1718: , x_return_status => l_return_status
1719: , p_jtf_note_id => l_jtf_note_id
1720: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
1721: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
1722: , p_creation_date => p_jtf_note_contexts_tab(i).creation_date
1723: , p_created_by => p_jtf_note_contexts_tab(i).created_by
1724: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
1725: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id

Line 1722: , p_creation_date => p_jtf_note_contexts_tab(i).creation_date

1718: , x_return_status => l_return_status
1719: , p_jtf_note_id => l_jtf_note_id
1720: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
1721: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
1722: , p_creation_date => p_jtf_note_contexts_tab(i).creation_date
1723: , p_created_by => p_jtf_note_contexts_tab(i).created_by
1724: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
1725: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
1726: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type

Line 1723: , p_created_by => p_jtf_note_contexts_tab(i).created_by

1719: , p_jtf_note_id => l_jtf_note_id
1720: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
1721: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
1722: , p_creation_date => p_jtf_note_contexts_tab(i).creation_date
1723: , p_created_by => p_jtf_note_contexts_tab(i).created_by
1724: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
1725: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
1726: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
1727: , x_note_context_id => l_note_context_id

Line 1724: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login

1720: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
1721: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
1722: , p_creation_date => p_jtf_note_contexts_tab(i).creation_date
1723: , p_created_by => p_jtf_note_contexts_tab(i).created_by
1724: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
1725: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
1726: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
1727: , x_note_context_id => l_note_context_id
1728: );

Line 1725: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id

1721: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
1722: , p_creation_date => p_jtf_note_contexts_tab(i).creation_date
1723: , p_created_by => p_jtf_note_contexts_tab(i).created_by
1724: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
1725: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
1726: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
1727: , x_note_context_id => l_note_context_id
1728: );
1729: IF (l_return_status <> fnd_api.g_ret_sts_success)

Line 1726: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type

1722: , p_creation_date => p_jtf_note_contexts_tab(i).creation_date
1723: , p_created_by => p_jtf_note_contexts_tab(i).created_by
1724: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
1725: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
1726: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
1727: , x_note_context_id => l_note_context_id
1728: );
1729: IF (l_return_status <> fnd_api.g_ret_sts_success)
1730: THEN

Line 1786: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab

1782: , p_attribute14 => p_attribute14
1783: , p_attribute15 => p_attribute15
1784: , p_context => p_context
1785: , p_note_type => p_note_type
1786: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab
1787: , x_return_status => l_return_status
1788: , p_jtf_note_id => l_jtf_note_id
1789: );
1790:

Line 1847: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab

1843: , p_attribute14 => p_attribute14
1844: , p_attribute15 => p_attribute15
1845: , p_context => p_context
1846: , p_note_type => p_note_type
1847: , p_jtf_note_contexts_tab => p_jtf_note_contexts_tab
1848: , x_return_status => l_return_status
1849: , p_jtf_note_id => l_jtf_note_id
1850: );
1851:

Line 2021: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type

2017: , p_notes_detail IN VARCHAR2 DEFAULT CHR(0)
2018: , p_append_flag IN VARCHAR2 DEFAULT CHR(0)
2019: , p_note_status IN VARCHAR2 DEFAULT 'I'
2020: , p_note_type IN VARCHAR2 DEFAULT CHR(0)
2021: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type
2022: DEFAULT jtf_note_contexts_tab_dflt
2023: , p_attribute1 IN VARCHAR2 DEFAULT CHR(0)
2024: , p_attribute2 IN VARCHAR2 DEFAULT CHR(0)
2025: , p_attribute3 IN VARCHAR2 DEFAULT CHR(0)

Line 2022: DEFAULT jtf_note_contexts_tab_dflt

2018: , p_append_flag IN VARCHAR2 DEFAULT CHR(0)
2019: , p_note_status IN VARCHAR2 DEFAULT 'I'
2020: , p_note_type IN VARCHAR2 DEFAULT CHR(0)
2021: , p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type
2022: DEFAULT jtf_note_contexts_tab_dflt
2023: , p_attribute1 IN VARCHAR2 DEFAULT CHR(0)
2024: , p_attribute2 IN VARCHAR2 DEFAULT CHR(0)
2025: , p_attribute3 IN VARCHAR2 DEFAULT CHR(0)
2026: , p_attribute4 IN VARCHAR2 DEFAULT CHR(0)

Line 2726: IF ( p_jtf_note_contexts_tab.COUNT > 0 )

2722:
2723: --
2724: -- Update the Note Context records
2725: --
2726: IF ( p_jtf_note_contexts_tab.COUNT > 0 )
2727: THEN
2728: FOR i IN 1..p_jtf_note_contexts_tab.COUNT
2729: LOOP
2730: Update_note_context

Line 2728: FOR i IN 1..p_jtf_note_contexts_tab.COUNT

2724: -- Update the Note Context records
2725: --
2726: IF ( p_jtf_note_contexts_tab.COUNT > 0 )
2727: THEN
2728: FOR i IN 1..p_jtf_note_contexts_tab.COUNT
2729: LOOP
2730: Update_note_context
2731: ( p_validation_level => p_validation_level
2732: , x_return_status => l_return_status

Line 2733: , p_note_context_id => p_jtf_note_contexts_tab(i).note_context_id

2729: LOOP
2730: Update_note_context
2731: ( p_validation_level => p_validation_level
2732: , x_return_status => l_return_status
2733: , p_note_context_id => p_jtf_note_contexts_tab(i).note_context_id
2734: , p_jtf_note_id => p_jtf_note_id
2735: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
2736: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
2737: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by

Line 2735: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id

2731: ( p_validation_level => p_validation_level
2732: , x_return_status => l_return_status
2733: , p_note_context_id => p_jtf_note_contexts_tab(i).note_context_id
2734: , p_jtf_note_id => p_jtf_note_id
2735: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
2736: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
2737: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
2738: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
2739: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login

Line 2736: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type

2732: , x_return_status => l_return_status
2733: , p_note_context_id => p_jtf_note_contexts_tab(i).note_context_id
2734: , p_jtf_note_id => p_jtf_note_id
2735: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
2736: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
2737: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
2738: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
2739: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
2740: );

Line 2737: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by

2733: , p_note_context_id => p_jtf_note_contexts_tab(i).note_context_id
2734: , p_jtf_note_id => p_jtf_note_id
2735: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
2736: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
2737: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
2738: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
2739: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
2740: );
2741:

Line 2738: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date

2734: , p_jtf_note_id => p_jtf_note_id
2735: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
2736: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
2737: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
2738: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
2739: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
2740: );
2741:
2742: IF (l_return_status <> fnd_api.g_ret_sts_success)

Line 2739: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login

2735: , p_note_context_type_id => p_jtf_note_contexts_tab(i).note_context_type_id
2736: , p_note_context_type => p_jtf_note_contexts_tab(i).note_context_type
2737: , p_last_updated_by => p_jtf_note_contexts_tab(i).last_updated_by
2738: , p_last_update_date => p_jtf_note_contexts_tab(i).last_update_date
2739: , p_last_update_login => p_jtf_note_contexts_tab(i).last_update_login
2740: );
2741:
2742: IF (l_return_status <> fnd_api.g_ret_sts_success)
2743: THEN