APPS.IEM_ARCH_REQUESTS_PVT dependencies on IEM_ARCH_REQUESTS

Line 1: PACKAGE BODY IEM_ARCH_REQUESTS_PVT as

1: PACKAGE BODY IEM_ARCH_REQUESTS_PVT as
2: /* $Header: iemarqvb.pls 115.0 2003/08/20 21:37:35 sboorela noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ARCH_REQUESTS_PVT ';
5:

Line 4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ARCH_REQUESTS_PVT ';

1: PACKAGE BODY IEM_ARCH_REQUESTS_PVT as
2: /* $Header: iemarqvb.pls 115.0 2003/08/20 21:37:35 sboorela noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ARCH_REQUESTS_PVT ';
5:
6: PROCEDURE create_item (p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 ,
8: p_commit IN VARCHAR2 ,

Line 38: INSERT INTO IEM_ARCH_REQUESTS

34: THEN
35: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
36: END IF;
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38: INSERT INTO IEM_ARCH_REQUESTS
39: (REQUEST_ID,
40: ARCH_CRITERIA,
41: EMAIL_ACCOUNT_ID,
42: FOLDER_NAME,

Line 131: update iem_arch_requests

127: THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131: update iem_arch_requests
132: set arch_count=decode(p_arch_count,null,arch_count,p_arch_count),
133: arch_size=decode(p_arch_size,null,arch_size,p_arch_size),
134: status=p_status,
135: arch_comment=decode(p_comment,null,arch_comment,p_comment)

Line 177: END IEM_ARCH_REQUESTS_PVT ;

173: );
174:
175: END update_item;
176:
177: END IEM_ARCH_REQUESTS_PVT ;