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.AP_NOTES_PUB dependencies on AP_NOTES

Line 1: PACKAGE BODY AP_NOTES_PUB AS

1: PACKAGE BODY AP_NOTES_PUB AS
2: /* $Header: apwnotpb.pls 120.2.12010000.2 2008/08/06 07:51:20 rveliche ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='AP_NOTES_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):='AP_NOTES_PUB';

1: PACKAGE BODY AP_NOTES_PUB AS
2: /* $Header: apwnotpb.pls 120.2.12010000.2 2008/08/06 07:51:20 rveliche ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='AP_NOTES_PUB';
6: G_MODULE_PREFIX CONSTANT VARCHAR2(30):='ap.plsql.AP_NOTES_PUB.';
7: G_ENTER CONSTANT VARCHAR2(30):='ENTER';
8: G_EXIT CONSTANT VARCHAR2(30):='EXIT';
9:

Line 6: G_MODULE_PREFIX CONSTANT VARCHAR2(30):='ap.plsql.AP_NOTES_PUB.';

2: /* $Header: apwnotpb.pls 120.2.12010000.2 2008/08/06 07:51:20 rveliche ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='AP_NOTES_PUB';
6: G_MODULE_PREFIX CONSTANT VARCHAR2(30):='ap.plsql.AP_NOTES_PUB.';
7: G_ENTER CONSTANT VARCHAR2(30):='ENTER';
8: G_EXIT CONSTANT VARCHAR2(30):='EXIT';
9:
10:

Line 25: FROM ap_notes

21: Position INTEGER := 1;
22:
23: CURSOR c1
24: IS SELECT notes_detail
25: FROM ap_notes
26: WHERE note_id = p_note_id
27: FOR UPDATE;
28:
29: BEGIN

Line 135: select ap_notes_s.nextval into l_note_id from dual;

131: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
132: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Start of API body');
133: end if;
134:
135: select ap_notes_s.nextval into l_note_id from dual;
136: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
137: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'l_note_id='||l_note_id);
138: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
139: end if;

Line 138: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');

134:
135: select ap_notes_s.nextval into l_note_id from dual;
136: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
137: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'l_note_id='||l_note_id);
138: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
139: end if;
140: insert into AP_NOTES (
141: NOTE_ID,
142: SOURCE_OBJECT_CODE,

Line 140: insert into AP_NOTES (

136: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
137: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'l_note_id='||l_note_id);
138: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
139: end if;
140: insert into AP_NOTES (
141: NOTE_ID,
142: SOURCE_OBJECT_CODE,
143: SOURCE_OBJECT_ID,
144: ENTERED_BY,

Line 320: delete from AP_NOTES

316: IF p_note_type is null THEN
317: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
318: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type is null');
319: end if;
320: delete from AP_NOTES
321: where SOURCE_OBJECT_CODE = p_source_object_code
322: and SOURCE_OBJECT_ID = p_source_object_id
323: and NOTE_TYPE is null;
324: ELSIF p_note_type = G_ALL_NOTE_TYPES THEN

Line 328: delete from AP_NOTES

324: ELSIF p_note_type = G_ALL_NOTE_TYPES THEN
325: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
326: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type='||p_note_type||':deleting all notes');
327: end if;
328: delete from AP_NOTES
329: where SOURCE_OBJECT_CODE = p_source_object_code
330: and SOURCE_OBJECT_ID = p_source_object_id;
331: ELSE
332: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 335: delete from AP_NOTES

331: ELSE
332: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
333: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'p_note_type='||p_note_type||':deleting specific notes');
334: end if;
335: delete from AP_NOTES
336: where SOURCE_OBJECT_CODE = p_source_object_code
337: and SOURCE_OBJECT_ID = p_source_object_id
338: and NOTE_TYPE = p_note_type;
339: END IF;

Line 501: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');

497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:
500: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
501: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
502: end if;
503: insert into AP_NOTES (
504: NOTE_ID,
505: SOURCE_OBJECT_CODE,

Line 503: insert into AP_NOTES (

499:
500: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
501: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'Calling insert into AP_NOTES');
502: end if;
503: insert into AP_NOTES (
504: NOTE_ID,
505: SOURCE_OBJECT_CODE,
506: SOURCE_OBJECT_ID,
507: ENTERED_BY,

Line 519: AP_NOTES_S.nextval,

515: LAST_UPDATED_BY,
516: LAST_UPDATE_LOGIN
517: )
518: select
519: AP_NOTES_S.nextval,
520: p_new_source_object_code,
521: p_new_source_object_id,
522: ENTERED_BY,
523: ENTERED_DATE,

Line 532: from AP_NOTES

528: CREATED_BY,
529: LAST_UPDATE_DATE,
530: LAST_UPDATED_BY,
531: LAST_UPDATE_LOGIN
532: from AP_NOTES
533: where source_object_code = p_old_source_object_code
534: and source_object_id = p_old_source_object_id;
535:
536: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 590: END AP_NOTES_PUB;

586: END Copy_Notes;
587:
588:
589:
590: END AP_NOTES_PUB;