APPS.PFT_VAL_INDEX_FORMULA_PKG dependencies on PFT_VAL_INDEX_FORMULA_B

Line 16: cursor C is select ROWID from PFT_VAL_INDEX_FORMULA_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from PFT_VAL_INDEX_FORMULA_B
17: where VALUE_INDEX_FORMULA_ID = X_VALUE_INDEX_FORMULA_ID
18: ;
19: begin
20: insert into PFT_VAL_INDEX_FORMULA_B (

Line 20: insert into PFT_VAL_INDEX_FORMULA_B (

16: cursor C is select ROWID from PFT_VAL_INDEX_FORMULA_B
17: where VALUE_INDEX_FORMULA_ID = X_VALUE_INDEX_FORMULA_ID
18: ;
19: begin
20: insert into PFT_VAL_INDEX_FORMULA_B (
21: VALUE_INDEX_FORMULA_ID,
22: OBJECT_VERSION_NUMBER,
23: CREATION_DATE,
24: CREATED_BY,

Line 86: from PFT_VAL_INDEX_FORMULA_B

82: X_DESCRIPTION in VARCHAR2
83: ) is
84: cursor c is select
85: OBJECT_VERSION_NUMBER
86: from PFT_VAL_INDEX_FORMULA_B
87: where VALUE_INDEX_FORMULA_ID = X_VALUE_INDEX_FORMULA_ID
88: for update of VALUE_INDEX_FORMULA_ID nowait;
89: recinfo c%rowtype;
90:

Line 142: update PFT_VAL_INDEX_FORMULA_B set

138: X_LAST_UPDATED_BY in NUMBER,
139: X_LAST_UPDATE_LOGIN in NUMBER
140: ) is
141: begin
142: update PFT_VAL_INDEX_FORMULA_B set
143: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
144: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
146: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 179: delete from PFT_VAL_INDEX_FORMULA_B

175: if (sql%notfound) then
176: raise no_data_found;
177: end if;
178:
179: delete from PFT_VAL_INDEX_FORMULA_B
180: where VALUE_INDEX_FORMULA_ID = X_VALUE_INDEX_FORMULA_ID;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 193: from PFT_VAL_INDEX_FORMULA_B B

189: begin
190: delete from PFT_VAL_INDEX_FORMULA_TL T
191: where not exists
192: (select NULL
193: from PFT_VAL_INDEX_FORMULA_B B
194: where B.VALUE_INDEX_FORMULA_ID = T.VALUE_INDEX_FORMULA_ID
195: );
196:
197: update PFT_VAL_INDEX_FORMULA_TL T set (