APPS.CSM_PAGE_PERZ_PKG dependencies on CSM_PAGE_PERZ

Line 1: PACKAGE BODY CSM_PAGE_PERZ_PKG AS

1: PACKAGE BODY CSM_PAGE_PERZ_PKG AS
2: /* $Header: csmlppb.pls 120.0 2005/11/29 23:49:42 utekumal noship $ */
3:
4: PROCEDURE INSERT_ROW
5: (

Line 17: INSERT INTO CSM_PAGE_PERZ

13: IS
14:
15: BEGIN
16: --Insert
17: INSERT INTO CSM_PAGE_PERZ
18: (PAGE_PERZ_ID,
19: FILE_NAME,
20: PAGE_NAME,
21: UIX_PAGE_SERVER_VERSION,

Line 28: VALUES(CSM_PAGE_PERZ_S.NEXTVAL,

24: LAST_UPDATED_BY,
25: CREATION_DATE,
26: CREATED_BY,
27: LAST_UPDATE_DATE)
28: VALUES(CSM_PAGE_PERZ_S.NEXTVAL,
29: X_FILE_NAME,
30: X_PAGE_NAME,
31: X_UIX_PAGE_SERVER_VERSION,
32: X_UIX_PAGE_CLIENT_VERSION,

Line 54: UPDATE CSM_PAGE_PERZ

50: IS
51:
52: BEGIN
53: --Update
54: UPDATE CSM_PAGE_PERZ
55: SET PAGE_NAME = X_PAGE_NAME,
56: UIX_PAGE_SERVER_VERSION = X_UIX_PAGE_SERVER_VERSION,
57: UIX_PAGE_CLIENT_VERSION = X_UIX_PAGE_CLIENT_VERSION,
58: MESSAGE_NAME = X_MESSAGE_NAME,

Line 79: FROM CSM_PAGE_PERZ CPP

75:
76:
77: CURSOR c_page_exists(b_file_name VARCHAR2) IS
78: SELECT 1
79: FROM CSM_PAGE_PERZ CPP
80: WHERE CPP.FILE_NAME = b_file_name;
81:
82: l_exists NUMBER;
83: