APPS.ASG_CONFIG_PKG dependencies on ASG_CONFIG

Line 1: PACKAGE BODY ASG_CONFIG_PKG as

1: PACKAGE BODY ASG_CONFIG_PKG as
2: /* $Header: asgpconb.pls 120.1 2005/08/12 02:48:54 saradhak noship $ */
3:
4: -- HISTORY
5: -- OCT 29, 2003 ytian Modified the update_row to handle the entries

Line 28: insert into ASG_CONFIG (

24:
25: begin
26:
27:
28: insert into ASG_CONFIG (
29: NAME,
30: VALUE,
31: DESCRIPTION,
32: CREATION_DATE,

Line 72: update asg_config set

68:
69: x_count number;
70:
71: begin
72: update asg_config set
73: NAME = X_NAME,
74: VALUE = x_VALUE,
75: DESCRIPTION = X_DESCRIPTION,
76: CREATION_DATE = X_CREATION_DATE,

Line 103: update asg_config set

99: begin
100:
101:
102: IF (x_RELEASE_VERSION IS NOT NULL ) THEN
103: update asg_config set
104: NAME = X_NAME,
105: VALUE = x_VALUE,
106: DESCRIPTION = X_DESCRIPTION,
107: CREATION_DATE = X_CREATION_DATE,

Line 119: select count(*) into x_count from asg_config

115:
116:
117: if (sql%notfound) then
118: begin
119: select count(*) into x_count from asg_config
120: where name = X_NAME;
121:
122: if (x_count = 0) then
123: raise no_data_found;

Line 133: select count(*) into x_count from asg_config

129: /* if the release-version not set, and if the record is not
130: existing, we should raise and then insert_row will catch
131: and insert it then. */
132: begin
133: select count(*) into x_count from asg_config
134: where name = X_NAME;
135:
136: if (x_count = 0) then
137: raise no_data_found;

Line 162: asg_config_pkg.UPDATE_ROW (

158: if (p_owner = 'SEED') then
159: l_user_id := 1;
160: end if;
161:
162: asg_config_pkg.UPDATE_ROW (
163: X_NAME => x_NAME,
164: X_VALUE => x_VALUE,
165: X_DESCRIPTION => x_DESCRIPTION,
166: X_CREATION_DATE => X_CREATION_DATE,

Line 199: asg_config_pkg.UPDATE_ROW (

195: if (p_owner = 'SEED') then
196: l_user_id := 1;
197: end if;
198:
199: asg_config_pkg.UPDATE_ROW (
200: X_NAME => x_NAME,
201: X_VALUE => x_VALUE,
202: X_DESCRIPTION => x_DESCRIPTION,
203: X_CREATION_DATE => X_CREATION_DATE,

Line 212: asg_config_pkg.insert_row (

208:
209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN
211:
212: asg_config_pkg.insert_row (
213: X_NAME => x_NAME,
214: X_VALUE => x_VALUE,
215: X_DESCRIPTION => x_DESCRIPTION,
216: X_CREATION_DATE => sysdate,

Line 224: END ASG_CONFIG_PKG;

220: X_RELEASE_VERSION => X_RELEASE_VERSION);
221:
222: END load_row;
223:
224: END ASG_CONFIG_PKG;