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.CSF_DEBRIEF_HEADERS_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 1: PACKAGE BODY CSF_DEBRIEF_HEADERS_PKG as

1: PACKAGE BODY CSF_DEBRIEF_HEADERS_PKG as
2: /* $Header: csftdbhb.pls 120.5.12010000.2 2008/08/05 18:05:14 syenduri ship $ */
3: -- Start of Comments
4: -- Package name : CSF_DEBRIEF_HEADERS_PKG
5: -- Purpose :

Line 4: -- Package name : CSF_DEBRIEF_HEADERS_PKG

1: PACKAGE BODY CSF_DEBRIEF_HEADERS_PKG as
2: /* $Header: csftdbhb.pls 120.5.12010000.2 2008/08/05 18:05:14 syenduri ship $ */
3: -- Start of Comments
4: -- Package name : CSF_DEBRIEF_HEADERS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_HEADERS_PKG';

5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_HEADERS_PKG';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csftdbfb.pls';
11:
12: PROCEDURE Insert_Row(
13: px_DEBRIEF_HEADER_ID IN OUT NOCOPY NUMBER,

Line 48: CURSOR C2 IS SELECT CSF_DEBRIEF_HEADERS_S1.nextval FROM sys.dual;

44: p_DML_mode VARCHAR2
45: )
46:
47: IS
48: CURSOR C2 IS SELECT CSF_DEBRIEF_HEADERS_S1.nextval FROM sys.dual;
49: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.INSERT_ROW';
50: l_debrief_header CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
51: l_return_status varchar2(100);
52: l_msg_count NUMBER;

Line 49: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.INSERT_ROW';

45: )
46:
47: IS
48: CURSOR C2 IS SELECT CSF_DEBRIEF_HEADERS_S1.nextval FROM sys.dual;
49: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.INSERT_ROW';
50: l_debrief_header CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
51: l_return_status varchar2(100);
52: l_msg_count NUMBER;
53: l_msg_data varchar2(1000);

Line 93: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

89: l_dml_mode := 'BOTH';
90: END IF;
91:
92: IF l_dml_mode <> 'POST' THEN
93: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
94: 'Insert_Row',
95: 'B', 'C') THEN
96:
97: csf_debrief_headers_cuhk.Create_debrief_header_Pre

Line 97: csf_debrief_headers_cuhk.Create_debrief_header_Pre

93: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
94: 'Insert_Row',
95: 'B', 'C') THEN
96:
97: csf_debrief_headers_cuhk.Create_debrief_header_Pre
98: ( px_debrief_header => l_debrief_header,
99: x_return_status => l_return_status,
100: x_msg_count => l_msg_count,
101: x_msg_data => l_msg_data

Line 116: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

112:
113:
114: -- Pre call to the Vertical Type User Hook
115: --
116: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
117: 'Insert_Row',
118: 'B', 'V') THEN
119: csf_debrief_headers_vuhk.Create_debrief_header_Pre
120: ( px_debrief_header => l_debrief_header,

Line 119: csf_debrief_headers_vuhk.Create_debrief_header_Pre

115: --
116: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
117: 'Insert_Row',
118: 'B', 'V') THEN
119: csf_debrief_headers_vuhk.Create_debrief_header_Pre
120: ( px_debrief_header => l_debrief_header,
121: x_return_status => l_return_status,
122: x_msg_count => l_msg_count,
123: x_msg_data => l_msg_data

Line 134: csf_debrief_headers_iuhk.Create_debrief_header_Pre

130: FND_MSG_PUB.Add;
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133: END IF;
134: csf_debrief_headers_iuhk.Create_debrief_header_Pre
135: ( x_return_status => l_return_status
136: ) ;
137:
138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 158: INSERT INTO CSF_DEBRIEF_HEADERS(

154: l_debrief_header.DEBRIEF_HEADER_ID := px_DEBRIEF_HEADER_ID;
155: user_hooks_rec.DEBRIEF_HEADER_ID := l_debrief_header.DEBRIEF_HEADER_ID;
156:
157: IF l_dml_mode = 'BOTH' THEN
158: INSERT INTO CSF_DEBRIEF_HEADERS(
159: DEBRIEF_HEADER_ID,
160: DEBRIEF_NUMBER,
161: DEBRIEF_DATE,
162: DEBRIEF_STATUS_ID,

Line 226: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

222: );
223: END IF;
224:
225: IF l_dml_mode <> 'PRE' THEN
226: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
227: 'Insert_Row',
228: 'A', 'C') THEN
229:
230: csf_debrief_headers_cuhk.Create_debrief_header_post

Line 230: csf_debrief_headers_cuhk.Create_debrief_header_post

226: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
227: 'Insert_Row',
228: 'A', 'C') THEN
229:
230: csf_debrief_headers_cuhk.Create_debrief_header_post
231: ( px_debrief_header => l_debrief_header,
232: x_return_status => l_return_status,
233: x_msg_count => l_msg_count,
234: x_msg_data => l_msg_data

Line 249: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

245:
246:
247: -- Pre call to the Vertical Type User Hook
248: --
249: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
250: 'Insert_Row',
251: 'A', 'V') THEN
252: csf_debrief_headers_vuhk.Create_debrief_header_post
253: ( px_debrief_header => l_debrief_header,

Line 252: csf_debrief_headers_vuhk.Create_debrief_header_post

248: --
249: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
250: 'Insert_Row',
251: 'A', 'V') THEN
252: csf_debrief_headers_vuhk.Create_debrief_header_post
253: ( px_debrief_header => l_debrief_header,
254: x_return_status => l_return_status,
255: x_msg_count => l_msg_count,
256: x_msg_data => l_msg_data

Line 267: csf_debrief_headers_iuhk.Create_debrief_header_post

263: FND_MSG_PUB.Add;
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: END IF;
267: csf_debrief_headers_iuhk.Create_debrief_header_post
268: ( x_return_status => l_return_status
269: ) ;
270:
271: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 331: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.UPDATE_ROW';

327: p_DML_mode VARCHAR2
328: )
329:
330: IS
331: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.UPDATE_ROW';
332: l_debrief_header CSF_DEBRIEF_PUB.DEBRIEF_Rec_Type;
333: l_return_status varchar2(100);
334: l_msg_count NUMBER;
335: l_msg_data varchar2(1000);

Line 374: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

370: l_dml_mode := 'BOTH';
371: end if;
372:
373: if l_dml_mode <> 'POST' then
374: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
375: 'Update_Row',
376: 'B', 'C') THEN
377:
378: csf_debrief_headers_cuhk.update_debrief_header_Pre

Line 378: csf_debrief_headers_cuhk.update_debrief_header_Pre

374: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
375: 'Update_Row',
376: 'B', 'C') THEN
377:
378: csf_debrief_headers_cuhk.update_debrief_header_Pre
379: ( px_debrief_header => l_debrief_header,
380: x_return_status => l_return_status,
381: x_msg_count => l_msg_count,
382: x_msg_data => l_msg_data

Line 397: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

393:
394:
395: -- Pre call to the Vertical Type User Hook
396: --
397: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
398: 'Update_Row',
399: 'B', 'V') THEN
400: csf_debrief_headers_vuhk.update_debrief_header_Pre
401: ( px_debrief_header => l_debrief_header,

Line 400: csf_debrief_headers_vuhk.update_debrief_header_Pre

396: --
397: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
398: 'Update_Row',
399: 'B', 'V') THEN
400: csf_debrief_headers_vuhk.update_debrief_header_Pre
401: ( px_debrief_header => l_debrief_header,
402: x_return_status => l_return_status,
403: x_msg_count => l_msg_count,
404: x_msg_data => l_msg_data

Line 416: csf_debrief_headers_iuhk.update_debrief_header_Pre

412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414: END IF;
415: user_hooks_rec.DEBRIEF_HEADER_ID := l_debrief_header.DEBRIEF_HEADER_ID;
416: csf_debrief_headers_iuhk.update_debrief_header_Pre
417: ( x_return_status => l_return_status
418: ) ;
419:
420: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 430: Update CSF_DEBRIEF_HEADERS

426: END IF;
427:
428: if l_dml_mode = 'BOTH' then
429:
430: Update CSF_DEBRIEF_HEADERS
431: SET
432: DEBRIEF_NUMBER = decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, DEBRIEF_NUMBER, l_debrief_header.DEBRIEF_NUMBER),
433: DEBRIEF_DATE = decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, DEBRIEF_DATE, l_debrief_header.DEBRIEF_DATE),
434: DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),

Line 470: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

466: End If;
467: end if;
468:
469: if l_dml_mode <> 'PRE' then
470: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
471: 'Update_Row',
472: 'A', 'C') THEN
473:
474: csf_debrief_headers_cuhk.update_debrief_header_post

Line 474: csf_debrief_headers_cuhk.update_debrief_header_post

470: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
471: 'Update_Row',
472: 'A', 'C') THEN
473:
474: csf_debrief_headers_cuhk.update_debrief_header_post
475: ( px_debrief_header => l_debrief_header,
476: x_return_status => l_return_status,
477: x_msg_count => l_msg_count,
478: x_msg_data => l_msg_data

Line 493: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

489:
490:
491: -- Pre call to the Vertical Type User Hook
492: --
493: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
494: 'Update_Row',
495: 'A', 'V') THEN
496: csf_debrief_headers_vuhk.update_debrief_header_post
497: ( px_debrief_header => l_debrief_header,

Line 496: csf_debrief_headers_vuhk.update_debrief_header_post

492: --
493: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
494: 'Update_Row',
495: 'A', 'V') THEN
496: csf_debrief_headers_vuhk.update_debrief_header_post
497: ( px_debrief_header => l_debrief_header,
498: x_return_status => l_return_status,
499: x_msg_count => l_msg_count,
500: x_msg_data => l_msg_data

Line 511: csf_debrief_headers_iuhk.update_debrief_header_post

507: FND_MSG_PUB.Add;
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510: END IF;
511: csf_debrief_headers_iuhk.update_debrief_header_post
512: ( x_return_status => l_return_status
513: ) ;
514:
515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 531: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.DELETE_ROW';

527: IS
528: l_return_status varchar2(100);
529: l_msg_count NUMBER;
530: l_msg_data varchar2(1000);
531: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_HEADERS_PKG.DELETE_ROW';
532: l_dml_mode varchar2(10) := p_DML_mode;
533: BEGIN
534:
535: if l_dml_mode is null then

Line 540: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

536: l_dml_mode := 'BOTH';
537: end if;
538:
539: if l_dml_mode <> 'POST' then
540: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
541: 'Delete_Row',
542: 'B', 'C') THEN
543:
544: csf_debrief_headers_cuhk.delete_debrief_header_Pre

Line 544: csf_debrief_headers_cuhk.delete_debrief_header_Pre

540: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
541: 'Delete_Row',
542: 'B', 'C') THEN
543:
544: csf_debrief_headers_cuhk.delete_debrief_header_Pre
545: ( p_header_id => p_DEBRIEF_HEADER_ID,
546: x_return_status => l_return_status,
547: x_msg_count => l_msg_count,
548: x_msg_data => l_msg_data

Line 562: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

558: END IF;
559:
560: -- Pre call to the Vertical Type User Hook
561: --
562: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
563: 'Delete_Row',
564: 'B', 'V') THEN
565: csf_debrief_headers_vuhk.delete_debrief_header_Pre
566: ( p_header_id => p_DEBRIEF_HEADER_ID,

Line 565: csf_debrief_headers_vuhk.delete_debrief_header_Pre

561: --
562: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
563: 'Delete_Row',
564: 'B', 'V') THEN
565: csf_debrief_headers_vuhk.delete_debrief_header_Pre
566: ( p_header_id => p_DEBRIEF_HEADER_ID,
567: x_return_status => l_return_status,
568: x_msg_count => l_msg_count,
569: x_msg_data => l_msg_data

Line 581: csf_debrief_headers_iuhk.delete_debrief_header_Pre

577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579: END IF;
580: user_hooks_rec.DEBRIEF_HEADER_ID := p_DEBRIEF_HEADER_ID;
581: csf_debrief_headers_iuhk.delete_debrief_header_Pre
582: ( x_return_status => l_return_status
583: ) ;
584:
585: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 594: DELETE FROM CSF_DEBRIEF_HEADERS

590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END IF;
592:
593: if l_dml_mode = 'BOTH' then
594: DELETE FROM CSF_DEBRIEF_HEADERS
595: WHERE DEBRIEF_HEADER_ID = p_DEBRIEF_HEADER_ID;
596: If (SQL%NOTFOUND) then
597: RAISE NO_DATA_FOUND;
598: End If;

Line 602: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

598: End If;
599: end if;
600:
601: if l_dml_mode <> 'PRE' then
602: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
603: 'Delete_Row',
604: 'A', 'C') THEN
605:
606: csf_debrief_headers_cuhk.delete_debrief_header_Post

Line 606: csf_debrief_headers_cuhk.delete_debrief_header_Post

602: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
603: 'Delete_Row',
604: 'A', 'C') THEN
605:
606: csf_debrief_headers_cuhk.delete_debrief_header_Post
607: ( p_header_id => p_DEBRIEF_HEADER_ID,
608: x_return_status => l_return_status,
609: x_msg_count => l_msg_count,
610: x_msg_data => l_msg_data

Line 625: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',

621:
622:
623: -- Pre call to the Vertical Type User Hook
624: --
625: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
626: 'Delete_Row',
627: 'A', 'V') THEN
628: csf_debrief_headers_vuhk.delete_debrief_header_post
629: ( p_header_id => p_DEBRIEF_HEADER_ID,

Line 628: csf_debrief_headers_vuhk.delete_debrief_header_post

624: --
625: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_HEADERS_PKG',
626: 'Delete_Row',
627: 'A', 'V') THEN
628: csf_debrief_headers_vuhk.delete_debrief_header_post
629: ( p_header_id => p_DEBRIEF_HEADER_ID,
630: x_return_status => l_return_status,
631: x_msg_count => l_msg_count,
632: x_msg_data => l_msg_data

Line 643: csf_debrief_headers_iuhk.Delete_debrief_header_post

639: FND_MSG_PUB.Add;
640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
641: END IF;
642: END IF;
643: csf_debrief_headers_iuhk.Delete_debrief_header_post
644: ( x_return_status => l_return_status
645: ) ;
646:
647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 692: FROM CSF_DEBRIEF_HEADERS

688:
689: IS
690: CURSOR C IS
691: SELECT *
692: FROM CSF_DEBRIEF_HEADERS
693: WHERE DEBRIEF_HEADER_ID = p_DEBRIEF_HEADER_ID
694: FOR UPDATE of DEBRIEF_HEADER_ID NOWAIT;
695: Recinfo C%ROWTYPE;
696: BEGIN

Line 821: END CSF_DEBRIEF_HEADERS_PKG;

817: close resource_name;
818: return l_resource_name;
819: end;
820:
821: END CSF_DEBRIEF_HEADERS_PKG;