APPS.AR_BPA_DATA_SRC_PARAMS_PKG dependencies on AR_BPA_DATA_SRC_PARAMS

Line 1: package body AR_BPA_DATA_SRC_PARAMS_PKG as

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

Line 18: cursor C is select ROWID from AR_BPA_DATA_SRC_PARAMS

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER,
16: X_ITEM_ID in NUMBER
17: ) is
18: cursor C is select ROWID from AR_BPA_DATA_SRC_PARAMS
19: where PARAM_ID = X_PARAM_ID
20: ;
21: begin
22: insert into AR_BPA_DATA_SRC_PARAMS (

Line 22: insert into AR_BPA_DATA_SRC_PARAMS (

18: cursor C is select ROWID from AR_BPA_DATA_SRC_PARAMS
19: where PARAM_ID = X_PARAM_ID
20: ;
21: begin
22: insert into AR_BPA_DATA_SRC_PARAMS (
23: PARAM_ID,
24: DATA_SOURCE_ID,
25: PARAM_NAME,
26: PARAM_TYPE,

Line 73: update AR_BPA_DATA_SRC_PARAMS set

69: X_LAST_UPDATE_LOGIN in NUMBER,
70: X_ITEM_ID in NUMBER
71: ) is
72: begin
73: update AR_BPA_DATA_SRC_PARAMS set
74: DATA_SOURCE_ID = X_DATA_SOURCE_ID,
75: PARAM_NAME = X_PARAM_NAME,
76: PARAM_TYPE = X_PARAM_TYPE,
77: PARAM_SEQUENCE = X_PARAM_SEQUENCE,

Line 94: delete from AR_BPA_DATA_SRC_PARAMS

90: procedure DELETE_ROW (
91: X_PARAM_ID in NUMBER
92: ) is
93: begin
94: delete from AR_BPA_DATA_SRC_PARAMS
95: where PARAM_ID = X_PARAM_ID;
96:
97: if (sql%notfound) then
98: raise no_data_found;

Line 122: AR_BPA_DATA_SRC_PARAMS_PKG.UPDATE_ROW (

118: if (X_OWNER = 'SEED') then
119: user_id := 1;
120: end if;
121:
122: AR_BPA_DATA_SRC_PARAMS_PKG.UPDATE_ROW (
123: X_DATA_SOURCE_ID => X_DATA_SOURCE_ID,
124: X_PARAM_ID => X_PARAM_ID,
125: X_PARAM_NAME => X_PARAM_NAME,
126: X_PARAM_SEQUENCE => X_PARAM_SEQUENCE,

Line 135: AR_BPA_DATA_SRC_PARAMS_PKG.INSERT_ROW (

131: X_LAST_UPDATE_LOGIN => 0,
132: X_ITEM_ID => X_ITEM_ID);
133: exception
134: when NO_DATA_FOUND then
135: AR_BPA_DATA_SRC_PARAMS_PKG.INSERT_ROW (
136: X_ROWID => row_id,
137: X_DATA_SOURCE_ID => X_DATA_SOURCE_ID,
138: X_PARAM_ID => X_PARAM_ID,
139: X_PARAM_NAME => X_PARAM_NAME,

Line 152: end AR_BPA_DATA_SRC_PARAMS_PKG;

148: X_ITEM_ID => X_ITEM_ID);
149: end;
150: end LOAD_ROW;
151:
152: end AR_BPA_DATA_SRC_PARAMS_PKG;