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.1 2006/03/13 16:50:52 phegde noship $ */
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.1 2006/03/13 16:50:52 phegde noship $ */
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 53: CURSOR C2 IS SELECT CSP_REQUIREMENT_HEADERS_S1.nextval FROM sys.dual;

49: p_TIMEZONE_ID NUMBER,
50: p_DESTINATION_SUBINVENTORY varchar2)
51:
52: IS
53: CURSOR C2 IS SELECT CSP_REQUIREMENT_HEADERS_S1.nextval FROM sys.dual;
54: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
55: l_return_status varchar2(100);
56: l_msg_count NUMBER;
57: l_msg_data varchar2(1000);

Line 54: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;

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

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

54: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
55: l_return_status varchar2(100);
56: l_msg_count NUMBER;
57: l_msg_data varchar2(1000);
58: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.INSERT_ROW';
59: BEGIN
60: l_requirement_header.REQUIREMENT_HEADER_ID := px_REQUIREMENT_HEADER_ID;
61: l_requirement_header.CREATED_BY := p_CREATED_BY;
62: l_requirement_header.CREATION_DATE := p_CREATION_DATE;

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

92: l_requirement_header.RESOURCE_ID := p_RESOURCE_ID ;
93: l_requirement_header.RESOURCE_TYPE := p_RESOURCE_TYPE;
94: l_requirement_header.TIMEZONE_ID := p_TIMEZONE_ID;
95: l_requirement_header.DESTINATION_SUBINVENTORY := p_DESTINATION_SUBINVENTORY;
96: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
97: 'Insert_Row',
98: 'B', 'C') THEN
99:
100: csp_requirement_headers_cuhk.Create_requirement_header_Pre

Line 100: csp_requirement_headers_cuhk.Create_requirement_header_Pre

96: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
97: 'Insert_Row',
98: 'B', 'C') THEN
99:
100: csp_requirement_headers_cuhk.Create_requirement_header_Pre
101: ( px_requirement_header => l_requirement_header,
102: x_return_status => l_return_status,
103: x_msg_count => l_msg_count,
104: x_msg_data => l_msg_data

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

114:
115:
116: -- Pre call to the Vertical Type User Hook
117: --
118: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
119: 'Insert_Row',
120: 'B', 'V') THEN
121: csp_requirement_headers_vuhk.Create_requirement_header_Pre
122: ( px_requirement_header => l_requirement_header,

Line 121: csp_requirement_headers_vuhk.Create_requirement_header_Pre

117: --
118: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
119: 'Insert_Row',
120: 'B', 'V') THEN
121: csp_requirement_headers_vuhk.Create_requirement_header_Pre
122: ( px_requirement_header => l_requirement_header,
123: x_return_status => l_return_status,
124: x_msg_count => l_msg_count,
125: x_msg_data => l_msg_data

Line 137: csp_requirement_headers_iuhk.Create_requirement_header_Pre

133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135: END IF;
136:
137: csp_requirement_headers_iuhk.Create_requirement_header_Pre
138: ( x_return_status => l_return_status
139: ) ;
140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
141: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 154: INSERT INTO CSP_REQUIREMENT_HEADERS(

150: CLOSE C2;
151: End If;
152: l_requirement_header.REQUIREMENT_HEADER_ID := px_REQUIREMENT_HEADER_ID;
153: user_hooks_rec.REQUIREMENT_HEADER_ID := l_requirement_header.REQUIREMENT_HEADER_ID;
154: INSERT INTO CSP_REQUIREMENT_HEADERS(
155: REQUIREMENT_HEADER_ID,
156: CREATED_BY,
157: CREATION_DATE,
158: LAST_UPDATED_BY,

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

226: --decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TIMEZONE_ID),
227: decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.DESTINATION_SUBINVENTORY)
228: );
229:
230: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
231: 'Insert_Row',
232: 'A', 'C') THEN
233:
234: csp_requirement_headers_cuhk.Create_requirement_header_post

Line 234: csp_requirement_headers_cuhk.Create_requirement_header_post

230: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
231: 'Insert_Row',
232: 'A', 'C') THEN
233:
234: csp_requirement_headers_cuhk.Create_requirement_header_post
235: ( px_requirement_header => l_requirement_header,
236: x_return_status => l_return_status,
237: x_msg_count => l_msg_count,
238: x_msg_data => l_msg_data

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

250:
251:
252: -- Post call to the Vertical Type User Hook
253: --
254: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
255: 'Insert_Row',
256: 'A', 'V') THEN
257:
258: csp_requirement_headers_vuhk.Create_requirement_header_post

Line 258: csp_requirement_headers_vuhk.Create_requirement_header_post

254: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
255: 'Insert_Row',
256: 'A', 'V') THEN
257:
258: csp_requirement_headers_vuhk.Create_requirement_header_post
259: ( px_requirement_header => l_requirement_header,
260: x_return_status => l_return_status,
261: x_msg_count => l_msg_count,
262: x_msg_data => l_msg_data

Line 272: csp_requirement_headers_iuhk.Create_requirement_header_post

268: FND_MSG_PUB.Add;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271: END IF;
272: csp_requirement_headers_iuhk.Create_requirement_header_post
273: ( x_return_status => l_return_status
274: ) ;
275: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
276: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 324: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;

320: p_TIMEZONE_ID NUMBER,
321: P_DESTINATION_SUBINVENTORY VARCHAR2)
322:
323: IS
324: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
325: l_return_status varchar2(100);
326: l_msg_count NUMBER;
327: l_msg_data varchar2(1000);
328: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.UPDATE_ROW';

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

324: l_requirement_header CSP_REQUIREMENT_HEADERS_PVT.Requirement_header_Rec_Type;
325: l_return_status varchar2(100);
326: l_msg_count NUMBER;
327: l_msg_data varchar2(1000);
328: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.UPDATE_ROW';
329: BEGIN
330: l_requirement_header.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;
331: l_requirement_header.CREATED_BY := p_CREATED_BY;
332: l_requirement_header.CREATION_DATE := p_CREATION_DATE;

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

362: l_requirement_header.RESOURCE_ID := p_RESOURCE_ID ;
363: l_requirement_header.RESOURCE_TYPE := p_RESOURCE_TYPE;
364: l_requirement_header.TIMEZONE_ID := p_TIMEZONE_ID;
365: l_requirement_header.DESTINATION_SUBINVENTORY := p_DESTINATION_SUBINVENTORY;
366: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
367: 'Update_Row',
368: 'B', 'C') THEN
369:
370: csp_requirement_headers_cuhk.update_requirement_header_Pre

Line 370: csp_requirement_headers_cuhk.update_requirement_header_Pre

366: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
367: 'Update_Row',
368: 'B', 'C') THEN
369:
370: csp_requirement_headers_cuhk.update_requirement_header_Pre
371: ( px_requirement_header => l_requirement_header,
372: x_return_status => l_return_status,
373: x_msg_count => l_msg_count,
374: x_msg_data => l_msg_data

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

384:
385:
386: -- Pre call to the Vertical Type User Hook
387: --
388: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
389: 'Update_Row',
390: 'B', 'V') THEN
391: csp_requirement_headers_vuhk.update_requirement_header_Pre
392: ( px_requirement_header => l_requirement_header,

Line 391: csp_requirement_headers_vuhk.update_requirement_header_Pre

387: --
388: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
389: 'Update_Row',
390: 'B', 'V') THEN
391: csp_requirement_headers_vuhk.update_requirement_header_Pre
392: ( px_requirement_header => l_requirement_header,
393: x_return_status => l_return_status,
394: x_msg_count => l_msg_count,
395: x_msg_data => l_msg_data

Line 407: csp_requirement_headers_iuhk.update_requirement_header_Pre

403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END IF;
405: END IF;
406: user_hooks_rec.REQUIREMENT_HEADER_ID := l_requirement_header.REQUIREMENT_HEADER_ID;
407: csp_requirement_headers_iuhk.update_requirement_header_Pre
408: ( x_return_status => l_return_status
409: ) ;
410: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
411: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 417: Update CSP_REQUIREMENT_HEADERS

413: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
414: FND_MSG_PUB.Add;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: Update CSP_REQUIREMENT_HEADERS
418: SET
419: CREATED_BY = decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_header.CREATED_BY),
420: CREATION_DATE = decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_header.CREATION_DATE),
421: 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 459: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

455:
456: If (SQL%NOTFOUND) then
457: RAISE NO_DATA_FOUND;
458: End If;
459: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
460: 'Update_Row',
461: 'A', 'C') THEN
462:
463: csp_requirement_headers_cuhk.update_requirement_header_post

Line 463: csp_requirement_headers_cuhk.update_requirement_header_post

459: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
460: 'Update_Row',
461: 'A', 'C') THEN
462:
463: csp_requirement_headers_cuhk.update_requirement_header_post
464: ( px_requirement_header => l_requirement_header,
465: x_return_status => l_return_status,
466: x_msg_count => l_msg_count,
467: x_msg_data => l_msg_data

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

477:
478:
479: -- Pre call to the Vertical Type User Hook
480: --
481: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
482: 'Update_Row',
483: 'A', 'V') THEN
484: csp_requirement_headers_vuhk.update_requirement_header_post
485: ( px_requirement_header => l_requirement_header,

Line 484: csp_requirement_headers_vuhk.update_requirement_header_post

480: --
481: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
482: 'Update_Row',
483: 'A', 'V') THEN
484: csp_requirement_headers_vuhk.update_requirement_header_post
485: ( px_requirement_header => l_requirement_header,
486: x_return_status => l_return_status,
487: x_msg_count => l_msg_count,
488: x_msg_data => l_msg_data

Line 499: csp_requirement_headers_iuhk.update_requirement_header_post

495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498: END IF;
499: csp_requirement_headers_iuhk.update_requirement_header_post
500: ( x_return_status => l_return_status
501: ) ;
502: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
503: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

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

513: IS
514: l_return_status varchar2(100);
515: l_msg_count NUMBER;
516: l_msg_data varchar2(1000);
517: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.DELETE_ROW';
518: BEGIN
519: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
520: 'Delete_Row',
521: 'B', 'C') THEN

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

515: l_msg_count NUMBER;
516: l_msg_data varchar2(1000);
517: l_api_name_full varchar2(50) := 'CSP_REQUIREMENT_HEADERS_PKG.DELETE_ROW';
518: BEGIN
519: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
520: 'Delete_Row',
521: 'B', 'C') THEN
522:
523: csp_requirement_headers_cuhk.Delete_requirement_header_pre

Line 523: csp_requirement_headers_cuhk.Delete_requirement_header_pre

519: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
520: 'Delete_Row',
521: 'B', 'C') THEN
522:
523: csp_requirement_headers_cuhk.Delete_requirement_header_pre
524: (
525: p_header_id => p_REQUIREMENT_HEADER_ID,
526: x_return_status => l_return_status,
527: x_msg_count => l_msg_count,

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

538:
539:
540: -- Pre call to the Vertical Type User Hook
541: --
542: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
543: 'Delete_Row',
544: 'B', 'V') THEN
545: csp_requirement_headers_vuhk.Delete_requirement_header_pre
546: (

Line 545: csp_requirement_headers_vuhk.Delete_requirement_header_pre

541: --
542: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
543: 'Delete_Row',
544: 'B', 'V') THEN
545: csp_requirement_headers_vuhk.Delete_requirement_header_pre
546: (
547: p_header_id => p_REQUIREMENT_HEADER_ID,
548: x_return_status => l_return_status,
549: x_msg_count => l_msg_count,

Line 562: csp_requirement_headers_iuhk.delete_requirement_header_Pre

558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
559: END IF;
560: END IF;
561: user_hooks_rec.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;
562: csp_requirement_headers_iuhk.delete_requirement_header_Pre
563: ( x_return_status => l_return_status
564: ) ;
565: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
566: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 572: DELETE FROM CSP_REQUIREMENT_HEADERS

568: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
569: FND_MSG_PUB.Add;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: DELETE FROM CSP_REQUIREMENT_HEADERS
573: WHERE REQUIREMENT_HEADER_ID = p_REQUIREMENT_HEADER_ID;
574: If (SQL%NOTFOUND) then
575: RAISE NO_DATA_FOUND;
576: End If;

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

573: WHERE REQUIREMENT_HEADER_ID = p_REQUIREMENT_HEADER_ID;
574: If (SQL%NOTFOUND) then
575: RAISE NO_DATA_FOUND;
576: End If;
577: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
578: 'Delete_Row',
579: 'A', 'C') THEN
580:
581: csp_requirement_headers_cuhk.Delete_requirement_header_post

Line 581: csp_requirement_headers_cuhk.Delete_requirement_header_post

577: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
578: 'Delete_Row',
579: 'A', 'C') THEN
580:
581: csp_requirement_headers_cuhk.Delete_requirement_header_post
582: (
583: p_header_id => p_REQUIREMENT_HEADER_ID,
584: x_return_status => l_return_status,
585: x_msg_count => l_msg_count,

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

596:
597:
598: -- Pre call to the Vertical Type User Hook
599: --
600: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
601: 'Delete_Row',
602: 'A', 'V') THEN
603: csp_requirement_headers_vuhk.Delete_requirement_header_post
604: (

Line 603: csp_requirement_headers_vuhk.Delete_requirement_header_post

599: --
600: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
601: 'Delete_Row',
602: 'A', 'V') THEN
603: csp_requirement_headers_vuhk.Delete_requirement_header_post
604: (
605: p_header_id => p_REQUIREMENT_HEADER_ID,
606: x_return_status => l_return_status,
607: x_msg_count => l_msg_count,

Line 619: csp_requirement_headers_iuhk.delete_requirement_header_post

615: FND_MSG_PUB.Add;
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618: END IF;
619: csp_requirement_headers_iuhk.delete_requirement_header_post
620: ( x_return_status => l_return_status
621: ) ;
622: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
623: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');

Line 672: FROM CSP_REQUIREMENT_HEADERS

668:
669: IS
670: CURSOR C IS
671: SELECT *
672: FROM CSP_REQUIREMENT_HEADERS
673: WHERE REQUIREMENT_HEADER_ID = p_REQUIREMENT_HEADER_ID
674: FOR UPDATE of REQUIREMENT_HEADER_ID NOWAIT;
675: Recinfo C%ROWTYPE;
676: BEGIN

Line 800: End CSP_REQUIREMENT_HEADERS_PKG;

796: APP_EXCEPTION.RAISE_EXCEPTION;
797: End If;
798: END Lock_Row;
799:
800: End CSP_REQUIREMENT_HEADERS_PKG;