APPS.CS_SYSTEM_OPTIONS_PKG dependencies on CS_SYSTEM_OPTIONS

Line 1: PACKAGE BODY CS_SYSTEM_OPTIONS_PKG AS

1: PACKAGE BODY CS_SYSTEM_OPTIONS_PKG AS
2: /* $Header: cstsyopb.pls 120.0 2005/08/12 15:28:12 aneemuch noship $ */
3:
4: PROCEDURE INSERT_ROW (
5: P_SYSTEM_OPTION_ID IN NUMBER,

Line 34: INSERT INTO CS_SYSTEM_OPTIONS (

30: IS
31:
32: BEGIN
33:
34: INSERT INTO CS_SYSTEM_OPTIONS (
35: SYSTEM_OPTION_ID, SR_AGENT_SECURITY, SS_SRTYPE_RESTRICT,
36: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
37: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE1,
38: ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4,

Line 85: UPDATE CS_SYSTEM_OPTIONS set

81: P_ATTRIBUTE_CATEGORY IN VARCHAR2,
82: P_OBJECT_VERSION_NUMBER IN NUMBER )
83: IS
84: BEGIN
85: UPDATE CS_SYSTEM_OPTIONS set
86: SR_AGENT_SECURITY = P_SR_AGENT_SECURITY,
87: SS_SRTYPE_RESTRICT = P_SS_SRTYPE_RESTRICT,
88: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
89: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 121: delete from CS_SYSTEM_OPTIONS

117: PROCEDURE DELETE_ROW (
118: P_SYSTEM_OPTION_ID IN NUMBER )
119: IS
120: BEGIN
121: delete from CS_SYSTEM_OPTIONS
122: where SYSTEM_OPTION_ID = P_SYSTEM_OPTION_ID;
123:
124: if (sql%notfound) then
125: raise no_data_found;

Line 137: from cs_system_options

133: P_OBJECT_VERSION_NUMBER IN NUMBER)
134: IS
135: cursor c1 is
136: select 1
137: from cs_system_options
138: where SYSTEM_OPTION_ID = p_system_option_id
139: and object_version_number = p_object_version_number
140: for update of system_option_id nowait;
141:

Line 252: END CS_SYSTEM_OPTIONS_PKG;

248:
249: END LOAD_ROW;
250:
251:
252: END CS_SYSTEM_OPTIONS_PKG;