34: X_LAST_UPDATE_DATE in DATE,
35: X_LAST_UPDATED_BY in NUMBER,
36: X_LAST_UPDATE_LOGIN in NUMBER
37: ) is
38: cursor C is select ROWID from AS_SALES_STAGES_ALL_B
39: where SALES_STAGE_ID = X_SALES_STAGE_ID
40: ;
41: begin
42: insert into AS_SALES_STAGES_ALL_B (
38: cursor C is select ROWID from AS_SALES_STAGES_ALL_B
39: where SALES_STAGE_ID = X_SALES_STAGE_ID
40: ;
41: begin
42: insert into AS_SALES_STAGES_ALL_B (
43: USAGE_INDICATOR,
44: INTERNAL_UPGRADE_STAGE_ID,
45: ENABLED_FLAG,
46: START_DATE_ACTIVE,
196: ATTRIBUTE15,
197: MIN_WIN_PROBABILITY,
198: MAX_WIN_PROBABILITY,
199: APPLICABILITY
200: from AS_SALES_STAGES_ALL_B
201: where SALES_STAGE_ID = X_SALES_STAGE_ID
202: for update of SALES_STAGE_ID nowait;
203: recinfo c%rowtype;
204:
317: X_LAST_UPDATED_BY in NUMBER,
318: X_LAST_UPDATE_LOGIN in NUMBER
319: ) is
320: begin
321: update AS_SALES_STAGES_ALL_B set
322: USAGE_INDICATOR = X_USAGE_INDICATOR,
323: INTERNAL_UPGRADE_STAGE_ID = X_INTERNAL_UPGRADE_STAGE_ID,
324: ENABLED_FLAG = X_ENABLED_FLAG,
325: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
377: if (sql%notfound) then
378: raise no_data_found;
379: end if;
380:
381: delete from AS_SALES_STAGES_ALL_B
382: where SALES_STAGE_ID = X_SALES_STAGE_ID;
383:
384: if (sql%notfound) then
385: raise no_data_found;
423: row_id varchar2(64);
424:
425: cursor custom_exist(p_SALES_STAGE_ID NUMBER) is
426: select 'Y'
427: from AS_SALES_STAGES_ALL_B
428: where last_updated_by <> 1
429: and SALES_STAGE_ID = p_SALES_STAGE_ID;
430:
431: l_custom_exist varchar2(1) := 'N';
523: begin
524: delete from AS_SALES_STAGES_ALL_TL T
525: where not exists
526: (select NULL
527: from AS_SALES_STAGES_ALL_B B
528: where B.SALES_STAGE_ID = T.SALES_STAGE_ID
529: );
530:
531: update AS_SALES_STAGES_ALL_TL T set (