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.CSP_REQUIREMENT_HEADERS_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 1: PACKAGE BODY CSP_REQUIREMENT_HEADERS_PKG as

1: PACKAGE BODY CSP_REQUIREMENT_HEADERS_PKG as
2: /* $Header: csptrqhb.pls 120.2.12020000.2 2012/07/18 08:04:57 kgambhir ship $ */
3: -- Start of Comments
4: -- Package name : CSP_REQUIREMENT_HEADERS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_REQUIREMENT_HEADERS_PKG

1: PACKAGE BODY CSP_REQUIREMENT_HEADERS_PKG as
2: /* $Header: csptrqhb.pls 120.2.12020000.2 2012/07/18 08:04:57 kgambhir ship $ */
3: -- Start of Comments
4: -- Package name : CSP_REQUIREMENT_HEADERS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_REQUIREMENT_HEADERS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_REQUIREMENT_HEADERS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptrqhb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_REQUIREMENT_HEADER_ID IN OUT NOCOPY NUMBER,

Line 55: CURSOR C2 IS SELECT CSP_REQUIREMENT_HEADERS_S1.nextval FROM sys.dual;

51: p_SHIP_TO_CONTACT_ID NUMBER,
52: p_DML_MODE VARCHAR2)
53:
54: IS
55: CURSOR C2 IS SELECT CSP_REQUIREMENT_HEADERS_S1.nextval FROM sys.dual;
56: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
57: l_return_status varchar2(100);
58: l_msg_count NUMBER;
59: l_msg_data varchar2(1000);

Line 56: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;

52: p_DML_MODE VARCHAR2)
53:
54: IS
55: CURSOR C2 IS SELECT CSP_REQUIREMENT_HEADERS_S1.nextval FROM sys.dual;
56: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
57: l_return_status varchar2(100);
58: l_msg_count NUMBER;
59: l_msg_data varchar2(1000);
60: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.INSERT_ROW';

Line 60: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.INSERT_ROW';

56: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
57: l_return_status varchar2(100);
58: l_msg_count NUMBER;
59: l_msg_data varchar2(1000);
60: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.INSERT_ROW';
61: l_dml_mode varchar2(10) :=p_DML_MODE;
62: BEGIN
63: l_requirement_header.REQUIREMENT_HEADER_ID := px_REQUIREMENT_HEADER_ID;
64: l_requirement_header.CREATED_BY := p_CREATED_BY;

Line 106: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

102: l_dml_mode := 'BOTH';
103: END IF;
104: --Pre hook
105: IF l_dml_mode <> 'POST' THEN
106: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
107: 'Insert_Row',
108: 'B', 'C') THEN
109:
110: csp_requirement_headers_cuhk.Create_requirement_header_Pre

Line 110: csp_requirement_headers_cuhk.Create_requirement_header_Pre

106: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
107: 'Insert_Row',
108: 'B', 'C') THEN
109:
110: csp_requirement_headers_cuhk.Create_requirement_header_Pre
111: ( px_requirement_header => l_requirement_header,
112: x_return_status => l_return_status,
113: x_msg_count => l_msg_count,
114: x_msg_data => l_msg_data

Line 128: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

124:
125:
126: -- Pre call to the Vertical Type User Hook
127: --
128: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
129: 'Insert_Row',
130: 'B', 'V') THEN
131: csp_requirement_headers_vuhk.Create_requirement_header_Pre
132: ( px_requirement_header => l_requirement_header,

Line 131: csp_requirement_headers_vuhk.Create_requirement_header_Pre

127: --
128: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
129: 'Insert_Row',
130: 'B', 'V') THEN
131: csp_requirement_headers_vuhk.Create_requirement_header_Pre
132: ( px_requirement_header => l_requirement_header,
133: x_return_status => l_return_status,
134: x_msg_count => l_msg_count,
135: x_msg_data => l_msg_data

Line 147: csp_requirement_headers_iuhk.Create_requirement_header_Pre

143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145: END IF;
146:
147: csp_requirement_headers_iuhk.Create_requirement_header_Pre
148: ( x_return_status => l_return_status
149: ) ;
150: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
151: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 166: INSERT INTO CSP_REQUIREMENT_HEADERS(

162: END IF;
163: l_requirement_header.REQUIREMENT_HEADER_ID := px_REQUIREMENT_HEADER_ID;
164: user_hooks_rec.REQUIREMENT_HEADER_ID := l_requirement_header.REQUIREMENT_HEADER_ID;
165: IF l_dml_mode = 'BOTH' THEN
166: INSERT INTO CSP_REQUIREMENT_HEADERS(
167: REQUIREMENT_HEADER_ID,
168: CREATED_BY,
169: CREATION_DATE,
170: LAST_UPDATED_BY,

Line 247: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

243: END IF;
244:
245: --Post hook
246: IF l_dml_mode <> 'PRE' THEN
247: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
248: 'Insert_Row',
249: 'A', 'C') THEN
250:
251: csp_requirement_headers_cuhk.Create_requirement_header_post

Line 251: csp_requirement_headers_cuhk.Create_requirement_header_post

247: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
248: 'Insert_Row',
249: 'A', 'C') THEN
250:
251: csp_requirement_headers_cuhk.Create_requirement_header_post
252: ( px_requirement_header => l_requirement_header,
253: x_return_status => l_return_status,
254: x_msg_count => l_msg_count,
255: x_msg_data => l_msg_data

Line 271: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

267:
268:
269: -- Post call to the Vertical Type User Hook
270: --
271: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
272: 'Insert_Row',
273: 'A', 'V') THEN
274:
275: csp_requirement_headers_vuhk.Create_requirement_header_post

Line 275: csp_requirement_headers_vuhk.Create_requirement_header_post

271: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
272: 'Insert_Row',
273: 'A', 'V') THEN
274:
275: csp_requirement_headers_vuhk.Create_requirement_header_post
276: ( px_requirement_header => l_requirement_header,
277: x_return_status => l_return_status,
278: x_msg_count => l_msg_count,
279: x_msg_data => l_msg_data

Line 289: csp_requirement_headers_iuhk.Create_requirement_header_post

285: FND_MSG_PUB.Add;
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288: END IF;
289: csp_requirement_headers_iuhk.Create_requirement_header_post
290: ( x_return_status => l_return_status
291: ) ;
292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
293: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 343: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;

339: p_SHIP_TO_CONTACT_ID NUMBER,
340: p_DML_MODE VARCHAR2)
341:
342: IS
343: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
344: l_return_status varchar2(100);
345: l_msg_count NUMBER;
346: l_msg_data varchar2(1000);
347: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.UPDATE_ROW';

Line 347: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.UPDATE_ROW';

343: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
344: l_return_status varchar2(100);
345: l_msg_count NUMBER;
346: l_msg_data varchar2(1000);
347: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.UPDATE_ROW';
348: l_dml_mode varchar2(10) := p_dml_mode;
349: BEGIN
350: l_requirement_header.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;
351: l_requirement_header.CREATED_BY := p_CREATED_BY;

Line 393: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

389: l_dml_mode := 'BOTH';
390: END IF;
391:
392: IF L_dml_mode <> 'POST' THEN
393: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
394: 'Update_Row',
395: 'B', 'C') THEN
396:
397: csp_requirement_headers_cuhk.update_requirement_header_Pre

Line 397: csp_requirement_headers_cuhk.update_requirement_header_Pre

393: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
394: 'Update_Row',
395: 'B', 'C') THEN
396:
397: csp_requirement_headers_cuhk.update_requirement_header_Pre
398: ( px_requirement_header => l_requirement_header,
399: x_return_status => l_return_status,
400: x_msg_count => l_msg_count,
401: x_msg_data => l_msg_data

Line 415: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

411:
412:
413: -- Pre call to the Vertical Type User Hook
414: --
415: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
416: 'Update_Row',
417: 'B', 'V') THEN
418: csp_requirement_headers_vuhk.update_requirement_header_Pre
419: ( px_requirement_header => l_requirement_header,

Line 418: csp_requirement_headers_vuhk.update_requirement_header_Pre

414: --
415: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
416: 'Update_Row',
417: 'B', 'V') THEN
418: csp_requirement_headers_vuhk.update_requirement_header_Pre
419: ( px_requirement_header => l_requirement_header,
420: x_return_status => l_return_status,
421: x_msg_count => l_msg_count,
422: x_msg_data => l_msg_data

Line 434: csp_requirement_headers_iuhk.update_requirement_header_Pre

430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: END IF;
432: END IF;
433: user_hooks_rec.REQUIREMENT_HEADER_ID := l_requirement_header.REQUIREMENT_HEADER_ID;
434: csp_requirement_headers_iuhk.update_requirement_header_Pre
435: ( x_return_status => l_return_status
436: ) ;
437: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
438: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 447: Update CSP_REQUIREMENT_HEADERS

443: END IF;
444: END IF;
445:
446: IF l_dml_mode = 'BOTH' THEN
447: Update CSP_REQUIREMENT_HEADERS
448: SET
449: CREATED_BY = decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_header.CREATED_BY),
450: CREATION_DATE = decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_header.CREATION_DATE),
451: LAST_UPDATED_BY = decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_header.LAST_UPDATED_BY),

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

489: End If;
490: END IF;
491: --Post hook
492: IF l_dml_mode <> 'PRE' THEN
493: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
494: 'Update_Row',
495: 'A', 'C') THEN
496:
497: csp_requirement_headers_cuhk.update_requirement_header_post

Line 497: csp_requirement_headers_cuhk.update_requirement_header_post

493: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
494: 'Update_Row',
495: 'A', 'C') THEN
496:
497: csp_requirement_headers_cuhk.update_requirement_header_post
498: ( px_requirement_header => l_requirement_header,
499: x_return_status => l_return_status,
500: x_msg_count => l_msg_count,
501: x_msg_data => l_msg_data

Line 515: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

511:
512:
513: -- Pre call to the Vertical Type User Hook
514: --
515: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
516: 'Update_Row',
517: 'A', 'V') THEN
518: csp_requirement_headers_vuhk.update_requirement_header_post
519: ( px_requirement_header => l_requirement_header,

Line 518: csp_requirement_headers_vuhk.update_requirement_header_post

514: --
515: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
516: 'Update_Row',
517: 'A', 'V') THEN
518: csp_requirement_headers_vuhk.update_requirement_header_post
519: ( px_requirement_header => l_requirement_header,
520: x_return_status => l_return_status,
521: x_msg_count => l_msg_count,
522: x_msg_data => l_msg_data

Line 533: csp_requirement_headers_iuhk.update_requirement_header_post

529: FND_MSG_PUB.Add;
530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: END IF;
532: END IF;
533: csp_requirement_headers_iuhk.update_requirement_header_post
534: ( x_return_status => l_return_status
535: ) ;
536: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
537: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 553: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.DELETE_ROW';

549: IS
550: l_return_status varchar2(100);
551: l_msg_count NUMBER;
552: l_msg_data varchar2(1000);
553: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.DELETE_ROW';
554: l_dml_mode varchar2(10) := p_DML_MODE;
555: BEGIN
556: IF l_dml_mode is null THEN
557: l_dml_mode := 'BOTH';

Line 561: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

557: l_dml_mode := 'BOTH';
558: END IF;
559:
560: IF l_dml_mode <> 'POST' THEN
561: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
562: 'Delete_Row',
563: 'B', 'C') THEN
564:
565: csp_requirement_headers_cuhk.Delete_requirement_header_pre

Line 565: csp_requirement_headers_cuhk.Delete_requirement_header_pre

561: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
562: 'Delete_Row',
563: 'B', 'C') THEN
564:
565: csp_requirement_headers_cuhk.Delete_requirement_header_pre
566: (
567: p_header_id => p_REQUIREMENT_HEADER_ID,
568: x_return_status => l_return_status,
569: x_msg_count => l_msg_count,

Line 584: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

580:
581:
582: -- Pre call to the Vertical Type User Hook
583: --
584: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
585: 'Delete_Row',
586: 'B', 'V') THEN
587: csp_requirement_headers_vuhk.Delete_requirement_header_pre
588: (

Line 587: csp_requirement_headers_vuhk.Delete_requirement_header_pre

583: --
584: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
585: 'Delete_Row',
586: 'B', 'V') THEN
587: csp_requirement_headers_vuhk.Delete_requirement_header_pre
588: (
589: p_header_id => p_REQUIREMENT_HEADER_ID,
590: x_return_status => l_return_status,
591: x_msg_count => l_msg_count,

Line 604: csp_requirement_headers_iuhk.delete_requirement_header_Pre

600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602: END IF;
603: user_hooks_rec.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;
604: csp_requirement_headers_iuhk.delete_requirement_header_Pre
605: ( x_return_status => l_return_status
606: ) ;
607: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
608: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 617: DELETE FROM CSP_REQUIREMENT_HEADERS

613: END IF;
614: END IF;
615:
616: IF l_dml_mode = 'BOTH' THEN
617: DELETE FROM CSP_REQUIREMENT_HEADERS
618: WHERE REQUIREMENT_HEADER_ID = p_REQUIREMENT_HEADER_ID;
619: If (SQL%NOTFOUND) then
620: RAISE NO_DATA_FOUND;
621: End If;

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

621: End If;
622: END IF;
623:
624: IF l_dml_mode <> 'PRE' THEN
625: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
626: 'Delete_Row',
627: 'A', 'C') THEN
628:
629: csp_requirement_headers_cuhk.Delete_requirement_header_post

Line 629: csp_requirement_headers_cuhk.Delete_requirement_header_post

625: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
626: 'Delete_Row',
627: 'A', 'C') THEN
628:
629: csp_requirement_headers_cuhk.Delete_requirement_header_post
630: (
631: p_header_id => p_REQUIREMENT_HEADER_ID,
632: x_return_status => l_return_status,
633: x_msg_count => l_msg_count,

Line 648: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

644:
645:
646: -- Pre call to the Vertical Type User Hook
647: --
648: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
649: 'Delete_Row',
650: 'A', 'V') THEN
651: csp_requirement_headers_vuhk.Delete_requirement_header_post
652: (

Line 651: csp_requirement_headers_vuhk.Delete_requirement_header_post

647: --
648: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
649: 'Delete_Row',
650: 'A', 'V') THEN
651: csp_requirement_headers_vuhk.Delete_requirement_header_post
652: (
653: p_header_id => p_REQUIREMENT_HEADER_ID,
654: x_return_status => l_return_status,
655: x_msg_count => l_msg_count,

Line 667: csp_requirement_headers_iuhk.delete_requirement_header_post

663: FND_MSG_PUB.Add;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666: END IF;
667: csp_requirement_headers_iuhk.delete_requirement_header_post
668: ( x_return_status => l_return_status
669: ) ;
670: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
671: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 722: FROM CSP_REQUIREMENT_HEADERS

718:
719: IS
720: CURSOR C IS
721: SELECT *
722: FROM CSP_REQUIREMENT_HEADERS
723: WHERE REQUIREMENT_HEADER_ID = p_REQUIREMENT_HEADER_ID
724: FOR UPDATE of REQUIREMENT_HEADER_ID NOWAIT;
725: Recinfo C%ROWTYPE;
726: BEGIN

Line 853: End CSP_REQUIREMENT_HEADERS_PKG;

849: APP_EXCEPTION.RAISE_EXCEPTION;
850: End If;
851: END Lock_Row;
852:
853: End CSP_REQUIREMENT_HEADERS_PKG;