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.CSM_NOTES_EVENT_PKG dependencies on JTF_NOTES_B

Line 17: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';

13:
14: l_markdirty_failed EXCEPTION;
15:
16: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';
17: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
18: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';
19: g_notes_pk1_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
20: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');

Line 30: PROCEDURE INSERT_CSM_NOTES_ACC (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE,

26: g_omappings_pk1_name CONSTANT VARCHAR2(30) := 'MAPPING_ID';
27: g_omappings_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_OBJECT_MAPPINGS');
29:
30: PROCEDURE INSERT_CSM_NOTES_ACC (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE,
31: p_user_id fnd_user.user_id%TYPE)
32: IS
33:
34: BEGIN

Line 90: l_jtf_note_id jtf_notes_b.jtf_note_id%TYPE;

86: p_error_msg OUT NOCOPY VARCHAR2,
87: x_return_status IN OUT NOCOPY VARCHAR2)
88: IS
89: --Variable Declarations
90: l_jtf_note_id jtf_notes_b.jtf_note_id%TYPE;
91: l_user_found boolean;
92: l_source_object_code jtf_notes_b.source_object_code%TYPE;
93: l_userlist asg_download.user_list;
94: l_countlist asg_download.user_list;

Line 92: l_source_object_code jtf_notes_b.source_object_code%TYPE;

88: IS
89: --Variable Declarations
90: l_jtf_note_id jtf_notes_b.jtf_note_id%TYPE;
91: l_user_found boolean;
92: l_source_object_code jtf_notes_b.source_object_code%TYPE;
93: l_userlist asg_download.user_list;
94: l_countlist asg_download.user_list;
95: l_source_object_id jtf_notes_b.source_object_id%TYPE;
96:

Line 95: l_source_object_id jtf_notes_b.source_object_id%TYPE;

91: l_user_found boolean;
92: l_source_object_code jtf_notes_b.source_object_code%TYPE;
93: l_userlist asg_download.user_list;
94: l_countlist asg_download.user_list;
95: l_source_object_id jtf_notes_b.source_object_id%TYPE;
96:
97:
98: --Cursor Declarations
99: CURSOR c_csm_notes_csr (c_jtf_note_id jtf_notes_b.jtf_note_id%TYPE)

Line 99: CURSOR c_csm_notes_csr (c_jtf_note_id jtf_notes_b.jtf_note_id%TYPE)

95: l_source_object_id jtf_notes_b.source_object_id%TYPE;
96:
97:
98: --Cursor Declarations
99: CURSOR c_csm_notes_csr (c_jtf_note_id jtf_notes_b.jtf_note_id%TYPE)
100: IS
101: SELECT source_object_code,
102: source_object_id
103: FROM jtf_notes_b jtn

Line 103: FROM jtf_notes_b jtn

99: CURSOR c_csm_notes_csr (c_jtf_note_id jtf_notes_b.jtf_note_id%TYPE)
100: IS
101: SELECT source_object_code,
102: source_object_id
103: FROM jtf_notes_b jtn
104: WHERE jtn.jtf_note_id = c_jtf_note_id;
105:
106: CURSOR c_sr_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)
107: IS

Line 106: CURSOR c_sr_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)

102: source_object_id
103: FROM jtf_notes_b jtn
104: WHERE jtn.jtf_note_id = c_jtf_note_id;
105:
106: CURSOR c_sr_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)
107: IS
108: SELECT acc.user_id,acc.counter
109: FROM csm_incidents_all_acc acc
110: WHERE acc.incident_id = c_source_object_id;

Line 112: CURSOR c_task_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)

108: SELECT acc.user_id,acc.counter
109: FROM csm_incidents_all_acc acc
110: WHERE acc.incident_id = c_source_object_id;
111:
112: CURSOR c_task_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)
113: IS
114: SELECT acc.user_id,acc.counter
115: FROM csm_tasks_acc acc
116: WHERE acc.task_id = c_source_object_id;

Line 118: CURSOR c_ib_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)

114: SELECT acc.user_id,acc.counter
115: FROM csm_tasks_acc acc
116: WHERE acc.task_id = c_source_object_id;
117:
118: CURSOR c_ib_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)
119: IS
120: SELECT acc.user_id,acc.counter
121: FROM CSM_ITEM_INSTANCES_ACC acc
122: WHERE acc.INSTANCE_ID = c_source_object_id;

Line 124: CURSOR c_cst_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)

120: SELECT acc.user_id,acc.counter
121: FROM CSM_ITEM_INSTANCES_ACC acc
122: WHERE acc.INSTANCE_ID = c_source_object_id;
123:
124: CURSOR c_cst_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)
125: IS
126: SELECT acc.user_id,acc.counter
127: FROM CSM_PARTIES_ACC acc
128: WHERE acc.PARTY_ID = c_source_object_id;

Line 130: CURSOR c_contract_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)

126: SELECT acc.user_id,acc.counter
127: FROM CSM_PARTIES_ACC acc
128: WHERE acc.PARTY_ID = c_source_object_id;
129:
130: CURSOR c_contract_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)
131: IS
132: SELECT DISTINCT acc.user_id,acc.counter --distinct not removed as there is no primary key with contract service id
133: FROM csm_contr_headers_acc acc
134: WHERE acc.contract_service_id = c_source_object_id;

Line 136: CURSOR c_dbheader_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)

132: SELECT DISTINCT acc.user_id,acc.counter --distinct not removed as there is no primary key with contract service id
133: FROM csm_contr_headers_acc acc
134: WHERE acc.contract_service_id = c_source_object_id;
135:
136: CURSOR c_dbheader_notes(c_source_object_id jtf_notes_b.source_object_id%TYPE)
137: IS
138: SELECT acc.user_id,acc.counter
139: FROM csm_debrief_headers_acc acc
140: WHERE acc.debrief_header_id = c_source_object_id;

Line 223: l_jtf_note_id jtf_notes_b.jtf_note_id%TYPE;

219: p_error_msg OUT NOCOPY VARCHAR2,
220: x_return_status IN OUT NOCOPY VARCHAR2)
221: IS
222: --variable declarations
223: l_jtf_note_id jtf_notes_b.jtf_note_id%TYPE;
224: l_user_found boolean;
225:
226: --cursor declarations
227: CURSOR l_csm_notes_foreachuser_csr (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE) IS

Line 227: CURSOR l_csm_notes_foreachuser_csr (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE) IS

223: l_jtf_note_id jtf_notes_b.jtf_note_id%TYPE;
224: l_user_found boolean;
225:
226: --cursor declarations
227: CURSOR l_csm_notes_foreachuser_csr (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE) IS
228: SELECT acc.user_id,
229: acc.access_id
230: FROM csm_notes_acc acc
231: WHERE acc.jtf_note_id = p_jtf_note_id;

Line 278: FROM jtf_notes_b

274: IS
275: CURSOR l_notes_by_task_csr (p_sourceobjectcode VARCHAR2,
276: p_sourceobjectid NUMBER) IS
277: SELECT jtf_note_id
278: FROM jtf_notes_b
279: WHERE source_object_code = p_sourceobjectcode
280: AND source_object_id = p_sourceobjectid;
281:
282: BEGIN

Line 315: FROM jtf_notes_b notes, csm_notes_acc acc

311: CURSOR l_notes_by_task_csr (p_source_object_code VARCHAR2,
312: p_source_object_id NUMBER,
313: p_user_id NUMBER) IS
314: SELECT acc.jtf_note_id, acc.user_id
315: FROM jtf_notes_b notes, csm_notes_acc acc
316: WHERE notes.source_object_code = p_source_object_code
317: AND notes.source_object_id = p_source_object_id
318: AND notes.jtf_note_id = acc.jtf_note_id
319: AND acc.user_id = p_user_id;