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

Line 36: l_jtf_note_contexts_table jtf_notes_pub.jtf_note_contexts_tbl_type;

32: l_return_status VARCHAR2(1);
33: l_msg_count NUMBER;
34: l_msg_data VARCHAR2(32767);
35: l_source_object_id NUMBER;
36: l_jtf_note_contexts_table jtf_notes_pub.jtf_note_contexts_tbl_type;
37: i number;
38: p_note_id number;
39:
40: BEGIN

Line 77: l_jtf_note_contexts_table(i).note_context_type := p_contexts_tbl(i).CONTEXT_TYPE;

73: -- IF PG_DEBUG < 10 THEN
74: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
75: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: loop = ' || i);
76: END IF;
77: l_jtf_note_contexts_table(i).note_context_type := p_contexts_tbl(i).CONTEXT_TYPE;
78: l_jtf_note_contexts_table(i).note_context_type_id := p_contexts_tbl(i).CONTEXT_ID;
79: l_jtf_note_contexts_table(i).last_update_date := sysdate;
80: l_jtf_note_contexts_table(i).creation_date := sysdate;
81: l_jtf_note_contexts_table(i).last_updated_by := FND_GLOBAL.USER_ID;

Line 78: l_jtf_note_contexts_table(i).note_context_type_id := p_contexts_tbl(i).CONTEXT_ID;

74: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
75: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: loop = ' || i);
76: END IF;
77: l_jtf_note_contexts_table(i).note_context_type := p_contexts_tbl(i).CONTEXT_TYPE;
78: l_jtf_note_contexts_table(i).note_context_type_id := p_contexts_tbl(i).CONTEXT_ID;
79: l_jtf_note_contexts_table(i).last_update_date := sysdate;
80: l_jtf_note_contexts_table(i).creation_date := sysdate;
81: l_jtf_note_contexts_table(i).last_updated_by := FND_GLOBAL.USER_ID;
82: l_jtf_note_contexts_table(i).created_by := FND_GLOBAL.USER_ID;

Line 79: l_jtf_note_contexts_table(i).last_update_date := sysdate;

75: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: loop = ' || i);
76: END IF;
77: l_jtf_note_contexts_table(i).note_context_type := p_contexts_tbl(i).CONTEXT_TYPE;
78: l_jtf_note_contexts_table(i).note_context_type_id := p_contexts_tbl(i).CONTEXT_ID;
79: l_jtf_note_contexts_table(i).last_update_date := sysdate;
80: l_jtf_note_contexts_table(i).creation_date := sysdate;
81: l_jtf_note_contexts_table(i).last_updated_by := FND_GLOBAL.USER_ID;
82: l_jtf_note_contexts_table(i).created_by := FND_GLOBAL.USER_ID;
83: l_jtf_note_contexts_table(i).last_update_login := FND_GLOBAL.USER_ID;

Line 80: l_jtf_note_contexts_table(i).creation_date := sysdate;

76: END IF;
77: l_jtf_note_contexts_table(i).note_context_type := p_contexts_tbl(i).CONTEXT_TYPE;
78: l_jtf_note_contexts_table(i).note_context_type_id := p_contexts_tbl(i).CONTEXT_ID;
79: l_jtf_note_contexts_table(i).last_update_date := sysdate;
80: l_jtf_note_contexts_table(i).creation_date := sysdate;
81: l_jtf_note_contexts_table(i).last_updated_by := FND_GLOBAL.USER_ID;
82: l_jtf_note_contexts_table(i).created_by := FND_GLOBAL.USER_ID;
83: l_jtf_note_contexts_table(i).last_update_login := FND_GLOBAL.USER_ID;
84: -- IF PG_DEBUG < 10 THEN

Line 81: l_jtf_note_contexts_table(i).last_updated_by := FND_GLOBAL.USER_ID;

77: l_jtf_note_contexts_table(i).note_context_type := p_contexts_tbl(i).CONTEXT_TYPE;
78: l_jtf_note_contexts_table(i).note_context_type_id := p_contexts_tbl(i).CONTEXT_ID;
79: l_jtf_note_contexts_table(i).last_update_date := sysdate;
80: l_jtf_note_contexts_table(i).creation_date := sysdate;
81: l_jtf_note_contexts_table(i).last_updated_by := FND_GLOBAL.USER_ID;
82: l_jtf_note_contexts_table(i).created_by := FND_GLOBAL.USER_ID;
83: l_jtf_note_contexts_table(i).last_update_login := FND_GLOBAL.USER_ID;
84: -- IF PG_DEBUG < 10 THEN
85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 82: l_jtf_note_contexts_table(i).created_by := FND_GLOBAL.USER_ID;

78: l_jtf_note_contexts_table(i).note_context_type_id := p_contexts_tbl(i).CONTEXT_ID;
79: l_jtf_note_contexts_table(i).last_update_date := sysdate;
80: l_jtf_note_contexts_table(i).creation_date := sysdate;
81: l_jtf_note_contexts_table(i).last_updated_by := FND_GLOBAL.USER_ID;
82: l_jtf_note_contexts_table(i).created_by := FND_GLOBAL.USER_ID;
83: l_jtf_note_contexts_table(i).last_update_login := FND_GLOBAL.USER_ID;
84: -- IF PG_DEBUG < 10 THEN
85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
86: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type);

Line 83: l_jtf_note_contexts_table(i).last_update_login := FND_GLOBAL.USER_ID;

79: l_jtf_note_contexts_table(i).last_update_date := sysdate;
80: l_jtf_note_contexts_table(i).creation_date := sysdate;
81: l_jtf_note_contexts_table(i).last_updated_by := FND_GLOBAL.USER_ID;
82: l_jtf_note_contexts_table(i).created_by := FND_GLOBAL.USER_ID;
83: l_jtf_note_contexts_table(i).last_update_login := FND_GLOBAL.USER_ID;
84: -- IF PG_DEBUG < 10 THEN
85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
86: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type);
87: END IF;

Line 86: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type);

82: l_jtf_note_contexts_table(i).created_by := FND_GLOBAL.USER_ID;
83: l_jtf_note_contexts_table(i).last_update_login := FND_GLOBAL.USER_ID;
84: -- IF PG_DEBUG < 10 THEN
85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
86: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type);
87: END IF;
88: -- IF PG_DEBUG < 10 THEN
89: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
90: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type_id);

Line 90: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type_id);

86: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type);
87: END IF;
88: -- IF PG_DEBUG < 10 THEN
89: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
90: iex_debug_pub.LogMessage(G_PKG_NAME || '.Create_Note: ' || l_jtf_note_contexts_table(i).note_context_type_id);
91: END IF;
92: END LOOP;
93:
94: -- IF PG_DEBUG < 10 THEN

Line 118: p_jtf_note_contexts_tab => l_jtf_note_contexts_table,

114: x_jtf_note_id => x_note_id,
115: X_Return_Status => l_Return_Status,
116: X_Msg_Count => l_Msg_Count,
117: X_Msg_Data => l_Msg_Data,
118: p_jtf_note_contexts_tab => l_jtf_note_contexts_table,
119: p_note_type => p_note_type);
120:
121: -- IF PG_DEBUG < 10 THEN
122: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 339: 'AND a.jtf_note_id IN (SELECT jtf_note_id FROM jtf_note_contexts WHERE ' ;

335: 'WHERE (a.note_status <> ''P'' or a.created_by = ' || l_fnd_user_id || ') ' ||
336: 'AND a.source_object_code = b.object_code ' ||
337: 'AND b.object_code = tl.object_code ' ||
338: 'AND tl.language = userenv(''LANG'') ' ||
339: 'AND a.jtf_note_id IN (SELECT jtf_note_id FROM jtf_note_contexts WHERE ' ;
340:
341: l_length := length(l_sql_stmt);
342: iex_debug_pub.LogMessage(l_proc_name || ':before create l_sql_stmt:' || l_count, l_length);
343:

Line 444: FROM jtf_note_contexts notes, ar_payment_schedules ps

440: -- AND p.party_type = 'ORGANIZATION';
441:
442: CURSOR c_note_trx(x_jtf_note_id NUMBER) IS
443: SELECT ps.trx_number
444: FROM jtf_note_contexts notes, ar_payment_schedules ps
445: WHERE jtf_note_id = x_jtf_note_id
446: AND note_context_type = 'IEX_INVOICES'
447: AND ps.payment_schedule_id = note_context_type_id;
448:

Line 451: FROM jtf_note_contexts notes, hz_parties p

447: AND ps.payment_schedule_id = note_context_type_id;
448:
449: CURSOR c_note_party(x_jtf_note_id NUMBER) IS
450: SELECT p.party_name
451: FROM jtf_note_contexts notes, hz_parties p
452: WHERE jtf_note_id = x_jtf_note_id
453: AND note_context_type = 'PARTY'
454: AND note_context_type_id = p.party_id
455: AND p.party_type = 'ORGANIZATION';