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_LINES_PKG dependencies on CSF_DEBRIEF_LINES

Line 1: PACKAGE BODY CSF_DEBRIEF_LINES_PKG as

1: PACKAGE BODY CSF_DEBRIEF_LINES_PKG as
2: /* $Header: csftdblb.pls 120.2.12010000.2 2008/08/05 18:21:24 syenduri ship $ */
3: -- Start of Comments
4: -- Package name : CSF_DEBRIEF_LINES_PKG
5: -- Purpose :

Line 4: -- Package name : CSF_DEBRIEF_LINES_PKG

1: PACKAGE BODY CSF_DEBRIEF_LINES_PKG as
2: /* $Header: csftdblb.pls 120.2.12010000.2 2008/08/05 18:21:24 syenduri ship $ */
3: -- Start of Comments
4: -- Package name : CSF_DEBRIEF_LINES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_LINES_PKG';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_LINES_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csftdblb.pls';
12:
13: PROCEDURE Insert_Row(
14: px_DEBRIEF_LINE_ID IN OUT NOCOPY NUMBER,

Line 85: CURSOR C2 IS SELECT CSF_DEBRIEF_LINES_S.nextval FROM sys.dual;

81: P_RETURN_DATE DATE,
82: p_DML_mode VARCHAR2)
83:
84: IS
85: CURSOR C2 IS SELECT CSF_DEBRIEF_LINES_S.nextval FROM sys.dual;
86:
87: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
88: l_return_status varchar2(100);
89: l_msg_count NUMBER;

Line 91: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.INSERT_ROW';

87: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
88: l_return_status varchar2(100);
89: l_msg_count NUMBER;
90: l_msg_data varchar2(1000);
91: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.INSERT_ROW';
92: l_dml_mode varchar2(10) := p_DML_mode;
93: BEGIN
94: --dbms_output.put_line('Inserting Row ');
95: l_debrief_line.DEBRIEF_LINE_ID:= px_DEBRIEF_LINE_ID ;

Line 170: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

166: l_dml_mode := 'BOTH';
167: end if;
168:
169: if l_dml_mode <> 'POST' then
170: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
171: 'Insert_Row',
172: 'B', 'C') THEN
173: --dbms_output.put_line('Calling csf_debrief_lines_cuhk.Create_debrief_line_Pre ');
174: csf_debrief_lines_cuhk.Create_debrief_line_Pre

Line 173: --dbms_output.put_line('Calling csf_debrief_lines_cuhk.Create_debrief_line_Pre ');

169: if l_dml_mode <> 'POST' then
170: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
171: 'Insert_Row',
172: 'B', 'C') THEN
173: --dbms_output.put_line('Calling csf_debrief_lines_cuhk.Create_debrief_line_Pre ');
174: csf_debrief_lines_cuhk.Create_debrief_line_Pre
175: ( px_debrief_line => l_debrief_line,
176: x_return_status => l_return_status,
177: x_msg_count => l_msg_count,

Line 174: csf_debrief_lines_cuhk.Create_debrief_line_Pre

170: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
171: 'Insert_Row',
172: 'B', 'C') THEN
173: --dbms_output.put_line('Calling csf_debrief_lines_cuhk.Create_debrief_line_Pre ');
174: csf_debrief_lines_cuhk.Create_debrief_line_Pre
175: ( px_debrief_line => l_debrief_line,
176: x_return_status => l_return_status,
177: x_msg_count => l_msg_count,
178: x_msg_data => l_msg_data

Line 180: --dbms_output.put_line('csf_debrief_lines_cuhk.Create_debrief_line_Pre Status '||l_return_status);

176: x_return_status => l_return_status,
177: x_msg_count => l_msg_count,
178: x_msg_data => l_msg_data
179: ) ;
180: --dbms_output.put_line('csf_debrief_lines_cuhk.Create_debrief_line_Pre Status '||l_return_status);
181: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
182: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
183: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
184: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

Line 194: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

190:
191: --dbms_output.put_line('Again Hook ');
192: -- Pre call to the Vertical Type User Hook
193: --
194: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
195: 'Insert_Row',
196: 'B', 'V') THEN
197: --dbms_output.put_line('Pre Called ');
198: csf_debrief_lines_vuhk.Create_debrief_line_Pre

Line 198: csf_debrief_lines_vuhk.Create_debrief_line_Pre

194: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
195: 'Insert_Row',
196: 'B', 'V') THEN
197: --dbms_output.put_line('Pre Called ');
198: csf_debrief_lines_vuhk.Create_debrief_line_Pre
199: ( px_debrief_line => l_debrief_line,
200: x_return_status => l_return_status,
201: x_msg_count => l_msg_count,
202: x_msg_data => l_msg_data

Line 214: --dbms_output.put_line('csf_debrief_lines_iuhk ');

210: FND_MSG_PUB.Add;
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213: END IF;
214: --dbms_output.put_line('csf_debrief_lines_iuhk ');
215:
216: csf_debrief_lines_iuhk.Create_debrief_line_Pre
217: ( x_return_status => l_return_status
218: ) ;

Line 216: csf_debrief_lines_iuhk.Create_debrief_line_Pre

212: END IF;
213: END IF;
214: --dbms_output.put_line('csf_debrief_lines_iuhk ');
215:
216: csf_debrief_lines_iuhk.Create_debrief_line_Pre
217: ( x_return_status => l_return_status
218: ) ;
219:
220: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);

Line 220: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);

216: csf_debrief_lines_iuhk.Create_debrief_line_Pre
217: ( x_return_status => l_return_status
218: ) ;
219:
220: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);
221: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
222: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
223: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
224: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

Line 245: INSERT INTO CSF_DEBRIEF_LINES(

241: l_debrief_line.DEBRIEF_LINE_ID:= px_DEBRIEF_LINE_ID ;
242: user_hooks_rec.DEBRIEF_LINE_ID := l_debrief_line.DEBRIEF_LINE_ID;
243:
244: if l_dml_mode = 'BOTH' then
245: INSERT INTO CSF_DEBRIEF_LINES(
246: DEBRIEF_LINE_ID,
247: DEBRIEF_HEADER_ID,
248: DEBRIEF_LINE_NUMBER,
249: SERVICE_DATE,

Line 388: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

384: end if;
385:
386: -- dbms_output.put_line('INSERTED ');
387: if l_dml_mode <> 'PRE' then
388: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
389: 'Insert_Row',
390: 'B', 'C') THEN
391: --dbms_output.put_line('CREATE LINE POST ');
392: csf_debrief_lines_cuhk.Create_debrief_line_post

Line 392: csf_debrief_lines_cuhk.Create_debrief_line_post

388: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
389: 'Insert_Row',
390: 'B', 'C') THEN
391: --dbms_output.put_line('CREATE LINE POST ');
392: csf_debrief_lines_cuhk.Create_debrief_line_post
393: ( px_debrief_line => l_debrief_line,
394: x_return_status => l_return_status,
395: x_msg_count => l_msg_count,
396: x_msg_data => l_msg_data

Line 411: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

407:
408:
409: -- Pre call to the Vertical Type User Hook
410: --
411: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
412: 'Insert_Row',
413: 'B', 'V') THEN
414: csf_debrief_lines_vuhk.Create_debrief_line_post
415: ( px_debrief_line => l_debrief_line,

Line 414: csf_debrief_lines_vuhk.Create_debrief_line_post

410: --
411: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
412: 'Insert_Row',
413: 'B', 'V') THEN
414: csf_debrief_lines_vuhk.Create_debrief_line_post
415: ( px_debrief_line => l_debrief_line,
416: x_return_status => l_return_status,
417: x_msg_count => l_msg_count,
418: x_msg_data => l_msg_data

Line 430: csf_debrief_lines_iuhk.Create_debrief_line_post

426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428: END IF;
429:
430: csf_debrief_lines_iuhk.Create_debrief_line_post
431: ( x_return_status => l_return_status
432: ) ;
433:
434: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 522: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.UPDATE_ROW';

518: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
519: l_return_status varchar2(100);
520: l_msg_count NUMBER;
521: l_msg_data varchar2(1000);
522: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.UPDATE_ROW';
523: l_dml_mode varchar2(10) := p_DML_mode;
524: BEGIN
525: l_debrief_line.DEBRIEF_LINE_ID:= p_DEBRIEF_LINE_ID ;
526: l_debrief_line.DEBRIEF_HEADER_ID:= p_DEBRIEF_HEADER_ID ;

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

598:
599:
600: if l_dml_mode <> 'POST' then
601:
602: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
603: 'Update_Row',
604: 'B', 'C') THEN
605:
606: csf_debrief_lines_cuhk.update_debrief_line_Pre

Line 606: csf_debrief_lines_cuhk.update_debrief_line_Pre

602: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
603: 'Update_Row',
604: 'B', 'C') THEN
605:
606: csf_debrief_lines_cuhk.update_debrief_line_Pre
607: ( px_debrief_line => l_debrief_line,
608: x_return_status => l_return_status,
609: x_msg_count => l_msg_count,
610: x_msg_data => l_msg_data

Line 624: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

620:
621:
622: -- Pre call to the Vertical Type User Hook
623: --
624: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
625: 'Insert_Row',
626: 'B', 'V') THEN
627: csf_debrief_lines_vuhk.update_debrief_line_Pre
628: ( px_debrief_line => l_debrief_line,

Line 627: csf_debrief_lines_vuhk.update_debrief_line_Pre

623: --
624: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
625: 'Insert_Row',
626: 'B', 'V') THEN
627: csf_debrief_lines_vuhk.update_debrief_line_Pre
628: ( px_debrief_line => l_debrief_line,
629: x_return_status => l_return_status,
630: x_msg_count => l_msg_count,
631: x_msg_data => l_msg_data

Line 643: csf_debrief_lines_iuhk.update_debrief_line_Pre

639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END IF;
641: END IF;
642: user_hooks_rec.DEBRIEF_LINE_ID := l_debrief_line.DEBRIEF_LINE_ID;
643: csf_debrief_lines_iuhk.update_debrief_line_Pre
644: ( x_return_status => l_return_status
645: ) ;
646:
647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 659: Update CSF_DEBRIEF_LINES

655: end if;
656:
657: if l_dml_mode = 'BOTH' then
658:
659: Update CSF_DEBRIEF_LINES
660: SET
661: DEBRIEF_HEADER_ID = decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, DEBRIEF_HEADER_ID, l_debrief_line.DEBRIEF_HEADER_ID),
662: DEBRIEF_LINE_NUMBER = decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, DEBRIEF_LINE_NUMBER, l_debrief_line.DEBRIEF_LINE_NUMBER),
663: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),

Line 740: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

736: end if;
737:
738: if l_dml_mode <> 'PRE' then
739:
740: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
741: 'Insert_Row',
742: 'A', 'C') THEN
743:
744: csf_debrief_lines_cuhk.update_debrief_line_Post

Line 744: csf_debrief_lines_cuhk.update_debrief_line_Post

740: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
741: 'Insert_Row',
742: 'A', 'C') THEN
743:
744: csf_debrief_lines_cuhk.update_debrief_line_Post
745: ( px_debrief_line => l_debrief_line,
746: x_return_status => l_return_status,
747: x_msg_count => l_msg_count,
748: x_msg_data => l_msg_data

Line 762: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

758:
759:
760: -- Pre call to the Vertical Type User Hook
761: --
762: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
763: 'Insert_Row',
764: 'A', 'V') THEN
765: csf_debrief_lines_vuhk.update_debrief_line_post
766: ( px_debrief_line => l_debrief_line,

Line 765: csf_debrief_lines_vuhk.update_debrief_line_post

761: --
762: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
763: 'Insert_Row',
764: 'A', 'V') THEN
765: csf_debrief_lines_vuhk.update_debrief_line_post
766: ( px_debrief_line => l_debrief_line,
767: x_return_status => l_return_status,
768: x_msg_count => l_msg_count,
769: x_msg_data => l_msg_data

Line 781: csf_debrief_lines_iuhk.update_debrief_line_post

777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779: END IF;
780:
781: csf_debrief_lines_iuhk.update_debrief_line_post
782: ( x_return_status => l_return_status
783: ) ;
784:
785: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 805: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.DELETE_ROW';

801: l_debrief_line CSF_DEBRIEF_PUB.DEBRIEF_LINE_Rec_Type;
802: l_return_status varchar2(100);
803: l_msg_count NUMBER;
804: l_msg_data varchar2(1000);
805: l_api_name_full varchar2(50) := 'CSF_DEBRIEF_LINES_PKG.DELETE_ROW';
806: l_dml_mode varchar2(10) := p_DML_mode;
807: BEGIN
808: if l_dml_mode is null then
809: l_dml_mode := 'BOTH';

Line 813: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

809: l_dml_mode := 'BOTH';
810: end if;
811:
812: if l_dml_mode <> 'POST' then
813: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
814: 'Delete_Row',
815: 'B', 'C') THEN
816:
817: csf_debrief_lines_cuhk.delete_debrief_line_Pre

Line 817: csf_debrief_lines_cuhk.delete_debrief_line_Pre

813: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
814: 'Delete_Row',
815: 'B', 'C') THEN
816:
817: csf_debrief_lines_cuhk.delete_debrief_line_Pre
818: ( p_line_id => p_DEBRIEF_LINE_ID,
819: x_return_status => l_return_status,
820: x_msg_count => l_msg_count,
821: x_msg_data => l_msg_data

Line 835: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

831:
832:
833: -- Pre call to the Vertical Type User Hook
834: --
835: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
836: 'Delete_Row',
837: 'B', 'V') THEN
838: csf_debrief_lines_vuhk.delete_debrief_line_Pre
839: ( p_line_id => p_DEBRIEF_LINE_ID,

Line 838: csf_debrief_lines_vuhk.delete_debrief_line_Pre

834: --
835: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
836: 'Delete_Row',
837: 'B', 'V') THEN
838: csf_debrief_lines_vuhk.delete_debrief_line_Pre
839: ( p_line_id => p_DEBRIEF_LINE_ID,
840: x_return_status => l_return_status,
841: x_msg_count => l_msg_count,
842: x_msg_data => l_msg_data

Line 854: csf_debrief_lines_iuhk.delete_debrief_line_Pre

850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: END IF;
853: user_hooks_rec.DEBRIEF_LINE_ID := p_DEBRIEF_LINE_ID;
854: csf_debrief_lines_iuhk.delete_debrief_line_Pre
855: ( x_return_status => l_return_status
856: ) ;
857:
858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 870: DELETE FROM CSF_DEBRIEF_LINES

866: end if;
867:
868: if l_dml_mode = 'BOTH' then
869:
870: DELETE FROM CSF_DEBRIEF_LINES
871: WHERE DEBRIEF_LINE_ID = p_DEBRIEF_LINE_ID;
872: If (SQL%NOTFOUND) then
873: RAISE NO_DATA_FOUND;
874: End If;

Line 879: IF jtf_usr_hks.Ok_To_Execute('CSF_debrief_lineS_PKG',

875: end if;
876:
877: if l_dml_mode <> 'PRE' then
878:
879: IF jtf_usr_hks.Ok_To_Execute('CSF_debrief_lineS_PKG',
880: 'Delete_Row',
881: 'A', 'C') THEN
882:
883: csf_debrief_lines_cuhk.delete_debrief_line_post

Line 883: csf_debrief_lines_cuhk.delete_debrief_line_post

879: IF jtf_usr_hks.Ok_To_Execute('CSF_debrief_lineS_PKG',
880: 'Delete_Row',
881: 'A', 'C') THEN
882:
883: csf_debrief_lines_cuhk.delete_debrief_line_post
884: ( p_line_id => p_DEBRIEF_LINE_ID,
885: x_return_status => l_return_status,
886: x_msg_count => l_msg_count,
887: x_msg_data => l_msg_data

Line 901: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',

897:
898:
899: -- Pre call to the Vertical Type User Hook
900: --
901: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
902: 'Insert_Row',
903: 'A', 'V') THEN
904: csf_debrief_lines_vuhk.delete_debrief_line_post
905: ( p_line_id => p_DEBRIEF_LINE_ID,

Line 904: csf_debrief_lines_vuhk.delete_debrief_line_post

900: --
901: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_LINES_PKG',
902: 'Insert_Row',
903: 'A', 'V') THEN
904: csf_debrief_lines_vuhk.delete_debrief_line_post
905: ( p_line_id => p_DEBRIEF_LINE_ID,
906: x_return_status => l_return_status,
907: x_msg_count => l_msg_count,
908: x_msg_data => l_msg_data

Line 920: csf_debrief_lines_iuhk.delete_debrief_line_post

916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918: END IF;
919:
920: csf_debrief_lines_iuhk.delete_debrief_line_post
921: ( x_return_status => l_return_status
922: ) ;
923:
924: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1009: FROM CSF_DEBRIEF_LINES

1005:
1006: IS
1007: CURSOR C IS
1008: SELECT *
1009: FROM CSF_DEBRIEF_LINES
1010: WHERE DEBRIEF_LINE_ID = p_DEBRIEF_LINE_ID
1011: FOR UPDATE of DEBRIEF_LINE_ID NOWAIT;
1012: Recinfo C%ROWTYPE;
1013: BEGIN

Line 1253: End CSF_DEBRIEF_LINES_PKG;

1249: return l_resource_name;
1250: end;
1251:
1252:
1253: End CSF_DEBRIEF_LINES_PKG;
1254: