APPS.AS_SALES_LEAD_QUALS_PKG dependencies on AS_SALES_LEAD_QUALS_B

Line 20: cursor C is select ROWID from AS_SALES_LEAD_QUALS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from AS_SALES_LEAD_QUALS_B
21: where SEED_QUAL_ID = X_SEED_QUAL_ID
22: ;
23: begin
24: insert into AS_SALES_LEAD_QUALS_B (

Line 24: insert into AS_SALES_LEAD_QUALS_B (

20: cursor C is select ROWID from AS_SALES_LEAD_QUALS_B
21: where SEED_QUAL_ID = X_SEED_QUAL_ID
22: ;
23: begin
24: insert into AS_SALES_LEAD_QUALS_B (
25: SEED_QUAL_ID,
26: ENABLED_FLAG,
27: LOV_SQL,
28: RANGE_FLAG,

Line 110: from AS_SALES_LEAD_QUALS_B

106: RANGE_FLAG,
107: DATA_TYPE,
108: SOURCE_TABLE_NAME,
109: SOURCE_COLUMN_NAME
110: from AS_SALES_LEAD_QUALS_B
111: where SEED_QUAL_ID = X_SEED_QUAL_ID
112: for update of SEED_QUAL_ID nowait;
113: recinfo c%rowtype;
114:

Line 178: update AS_SALES_LEAD_QUALS_B set

174: X_LAST_UPDATED_BY in NUMBER,
175: X_LAST_UPDATE_LOGIN in NUMBER
176: ) is
177: begin
178: update AS_SALES_LEAD_QUALS_B set
179: ENABLED_FLAG = X_ENABLED_FLAG,
180: LOV_SQL = X_LOV_SQL,
181: RANGE_FLAG = X_RANGE_FLAG,
182: DATA_TYPE = X_DATA_TYPE,

Line 220: delete from AS_SALES_LEAD_QUALS_B

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: delete from AS_SALES_LEAD_QUALS_B
221: where SEED_QUAL_ID = X_SEED_QUAL_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 246: FROM AS_SALES_LEAD_QUALS_B

242:
243: -- FFANG 112700 FOR bug 1505582
244: CURSOR c_get_last_updated (c_SEED_QUAL_ID NUMBER) IS
245: SELECT last_updated_by
246: FROM AS_SALES_LEAD_QUALS_B
247: WHERE seed_qual_id = c_seed_qual_id;
248: l_last_updated_by NUMBER;
249: -- END FFANG 112700
250:

Line 308: from AS_SALES_LEAD_QUALS_B B

304: begin
305: delete from AS_SALES_LEAD_QUALS_TL T
306: where not exists
307: (select NULL
308: from AS_SALES_LEAD_QUALS_B B
309: where B.SEED_QUAL_ID = T.SEED_QUAL_ID
310: );
311:
312: update AS_SALES_LEAD_QUALS_TL T set (