APPS.CN_IMP_HEADERS_PVT dependencies on CN_IMP_HEADERS

Line 1: PACKAGE BODY CN_IMP_HEADERS_PVT AS

1: PACKAGE BODY CN_IMP_HEADERS_PVT AS
2: -- $Header: cnvimhrb.pls 115.7 2002/11/21 21:13:29 hlchen ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_IMP_HEADERS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvimhrb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_IMP_HEADERS_PVT';

1: PACKAGE BODY CN_IMP_HEADERS_PVT AS
2: -- $Header: cnvimhrb.pls 115.7 2002/11/21 21:13:29 hlchen ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_IMP_HEADERS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvimhrb.pls';
6:
7: -- Start of comments
8: -- API name : Create_Imp_header

Line 71: FROM cn_imp_headers

67: -- Check Name uniqueness
68: BEGIN
69: SELECT 1
70: INTO l_temp
71: FROM cn_imp_headers
72: WHERE name = p_imp_header.name
73: ;
74: EXCEPTION
75: WHEN no_data_found THEN

Line 87: -- Call API to create cn_imp_headers

83: END IF;
84: RAISE FND_API.G_EXC_ERROR ;
85: END IF;
86:
87: -- Call API to create cn_imp_headers
88: l_imp_header := p_imp_header ;
89: l_imp_header.status_code := 'NEW';
90:
91: SELECT cn_imp_headers_s.nextval

Line 91: SELECT cn_imp_headers_s.nextval

87: -- Call API to create cn_imp_headers
88: l_imp_header := p_imp_header ;
89: l_imp_header.status_code := 'NEW';
90:
91: SELECT cn_imp_headers_s.nextval
92: INTO x_imp_header_id
93: FROM sys.dual ;
94: l_imp_header.imp_header_id := x_imp_header_id ;
95:

Line 96: cn_imp_headers_pkg.insert_row

92: INTO x_imp_header_id
93: FROM sys.dual ;
94: l_imp_header.imp_header_id := x_imp_header_id ;
95:
96: cn_imp_headers_pkg.insert_row
97: (p_imp_headers_rec => l_imp_header);
98:
99: -- End of API body.
100:

Line 210: FROM cn_imp_headers

206: -- Check Name uniqueness
207: BEGIN
208: SELECT 1
209: INTO l_temp
210: FROM cn_imp_headers
211: WHERE imp_header_id <> p_imp_header.imp_header_id
212: AND name = p_imp_header.name
213: ;
214: EXCEPTION

Line 231: FROM cn_imp_headers

227: -- Check if record exists
228: BEGIN
229: SELECT imp_header_id,object_version_number
230: INTO l_imp_header.imp_header_id, l_imp_header.object_version_number
231: FROM cn_imp_headers
232: WHERE imp_header_id = p_imp_header.imp_header_id
233: FOR UPDATE OF imp_header_id NOWAIT ;
234: EXCEPTION
235: WHEN no_data_found THEN

Line 255: -- Call API to update cn_imp_headers

251: END IF;
252: RAISE FND_API.G_EXC_ERROR ;
253: END IF;
254:
255: -- Call API to update cn_imp_headers
256: cn_imp_headers_pkg.update_row
257: (p_imp_headers_rec => l_imp_header);
258:
259: -- End of API body.

Line 256: cn_imp_headers_pkg.update_row

252: RAISE FND_API.G_EXC_ERROR ;
253: END IF;
254:
255: -- Call API to update cn_imp_headers
256: cn_imp_headers_pkg.update_row
257: (p_imp_headers_rec => l_imp_header);
258:
259: -- End of API body.
260:

Line 380: FROM cn_imp_headers

376: BEGIN
377: SELECT imp_header_id,status_code,object_version_number,imp_map_id
378: INTO l_imp_header.imp_header_id,l_imp_header.status_code,
379: l_imp_header.object_version_number,l_imp_header.imp_map_id
380: FROM cn_imp_headers
381: WHERE imp_header_id = p_imp_header.imp_header_id
382: ;
383: EXCEPTION
384: WHEN no_data_found THEN

Line 418: FROM cn_imp_headers

414: -- check if mapping used by other imp_headers
415: BEGIN
416: l_temp := 0;
417: SELECT COUNT(1) INTO l_temp
418: FROM cn_imp_headers
419: WHERE imp_map_id = l_imp_header.imp_map_id
420: AND imp_header_id <> l_imp_header.imp_header_id
421: ;
422: EXCEPTION

Line 459: -- Call API to delete cn_imp_headers

455: WHEN no_data_found THEN
456: NULL;
457: END;
458:
459: -- Call API to delete cn_imp_headers
460: cn_imp_headers_pkg.delete_row
461: (p_imp_header_id => l_imp_header.imp_header_id);
462:
463: -- End of API body.

Line 460: cn_imp_headers_pkg.delete_row

456: NULL;
457: END;
458:
459: -- Call API to delete cn_imp_headers
460: cn_imp_headers_pkg.delete_row
461: (p_imp_header_id => l_imp_header.imp_header_id);
462:
463: -- End of API body.
464:

Line 541: END CN_IMP_HEADERS_PVT;

537:
538: END Get_Oerr_Msg;
539:
540:
541: END CN_IMP_HEADERS_PVT;