APPS.AR_BPA_URL_PARAMS_PKG dependencies on AR_BPA_URL_PARAMS

Line 1: package body AR_BPA_URL_PARAMS_PKG as

1: package body AR_BPA_URL_PARAMS_PKG as
2: /* $Header: ARBPURPB.pls 120.1 2004/12/03 01:45:27 orashid noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_URL_PARAM_ID in NUMBER,

Line 18: cursor C is select ROWID from AR_BPA_URL_PARAMS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from AR_BPA_URL_PARAMS
19: where URL_PARAM_ID = X_URL_PARAM_ID
20: ;
21: begin
22: insert into AR_BPA_URL_PARAMS (

Line 22: insert into AR_BPA_URL_PARAMS (

18: cursor C is select ROWID from AR_BPA_URL_PARAMS
19: where URL_PARAM_ID = X_URL_PARAM_ID
20: ;
21: begin
22: insert into AR_BPA_URL_PARAMS (
23: URL_PARAM_ID,
24: URL_ID,
25: PARAM_TYPE,
26: PARAM_NAME,

Line 77: from AR_BPA_URL_PARAMS

73: PARAM_NAME,
74: PARAM_VALUE,
75: ITEM_ID,
76: ENCRYPTED_FLAG
77: from AR_BPA_URL_PARAMS
78: where URL_PARAM_ID = X_URL_PARAM_ID
79: for update of URL_PARAM_ID nowait;
80: recinfo c%rowtype;
81:

Line 124: update AR_BPA_URL_PARAMS set

120: X_LAST_UPDATED_BY in NUMBER,
121: X_LAST_UPDATE_LOGIN in NUMBER
122: ) is
123: begin
124: update AR_BPA_URL_PARAMS set
125: URL_PARAM_ID = X_URL_PARAM_ID,
126: URL_ID = X_URL_ID,
127: PARAM_TYPE = X_PARAM_TYPE,
128: PARAM_NAME = X_PARAM_NAME,

Line 146: delete from AR_BPA_URL_PARAMS

142: procedure DELETE_ROW (
143: X_URL_PARAM_ID in NUMBER
144: ) is
145: begin
146: delete from AR_BPA_URL_PARAMS
147: where URL_PARAM_ID = X_URL_PARAM_ID;
148:
149: if (sql%notfound) then
150: raise no_data_found;

Line 174: AR_BPA_URL_PARAMS_PKG.UPDATE_ROW (

170: if (X_OWNER = 'SEED') then
171: user_id := 1;
172: end if;
173:
174: AR_BPA_URL_PARAMS_PKG.UPDATE_ROW (
175: X_URL_PARAM_ID => X_URL_PARAM_ID,
176: X_URL_ID => X_URL_ID,
177: X_PARAM_TYPE => X_PARAM_TYPE,
178: X_PARAM_NAME => X_PARAM_NAME,

Line 187: AR_BPA_URL_PARAMS_PKG.INSERT_ROW (

183: X_LAST_UPDATED_BY => user_id,
184: X_LAST_UPDATE_LOGIN => 0);
185: exception
186: when NO_DATA_FOUND then
187: AR_BPA_URL_PARAMS_PKG.INSERT_ROW (
188: X_ROWID => row_id,
189: X_URL_PARAM_ID => X_URL_PARAM_ID,
190: X_URL_ID => X_URL_ID,
191: X_PARAM_TYPE => X_PARAM_TYPE,

Line 204: end AR_BPA_URL_PARAMS_PKG;

200: X_LAST_UPDATE_LOGIN => 0);
201: end;
202: end LOAD_ROW;
203:
204: end AR_BPA_URL_PARAMS_PKG;