APPS.EDR_PSIG_DOC_PARAMS_PKG dependencies on EDR_PSIG_DOC_PARAMS_B

Line 17: cursor C is select ROWID from EDR_PSIG_DOC_PARAMS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from EDR_PSIG_DOC_PARAMS_B
18: where PARAMETER_ID = X_PARAMETER_ID
19: ;
20: begin
21: insert into EDR_PSIG_DOC_PARAMS_B (

Line 21: insert into EDR_PSIG_DOC_PARAMS_B (

17: cursor C is select ROWID from EDR_PSIG_DOC_PARAMS_B
18: where PARAMETER_ID = X_PARAMETER_ID
19: ;
20: begin
21: insert into EDR_PSIG_DOC_PARAMS_B (
22: PARAMETER_ID,
23: DOCUMENT_ID,
24: NAME,
25: VALUE,

Line 82: from EDR_PSIG_DOC_PARAMS_B

78: cursor c is select
79: DOCUMENT_ID,
80: NAME,
81: VALUE
82: from EDR_PSIG_DOC_PARAMS_B
83: where PARAMETER_ID = X_PARAMETER_ID
84: for update of PARAMETER_ID nowait;
85: recinfo c%rowtype;
86:

Line 142: update EDR_PSIG_DOC_PARAMS_B set

138: X_LAST_UPDATED_BY in NUMBER,
139: X_LAST_UPDATE_LOGIN in NUMBER
140: ) is
141: begin
142: update EDR_PSIG_DOC_PARAMS_B set
143: DOCUMENT_ID = X_DOCUMENT_ID,
144: NAME = X_NAME,
145: VALUE = X_VALUE,
146: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 180: delete from EDR_PSIG_DOC_PARAMS_B

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: delete from EDR_PSIG_DOC_PARAMS_B
181: where PARAMETER_ID = X_PARAMETER_ID;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 194: from EDR_PSIG_DOC_PARAMS_B B

190: begin
191: delete from EDR_PSIG_DOC_PARAMS_TL T
192: where not exists
193: (select NULL
194: from EDR_PSIG_DOC_PARAMS_B B
195: where B.PARAMETER_ID = T.PARAMETER_ID
196: );
197:
198: update EDR_PSIG_DOC_PARAMS_TL T set (