APPS.AMS_METRICS_ALL_PKG dependencies on AMS_METRICS_ALL_B

Line 54: cursor C is select ROWID from AMS_METRICS_ALL_B

50: X_LAST_UPDATE_DATE in DATE,
51: X_LAST_UPDATED_BY in NUMBER,
52: X_LAST_UPDATE_LOGIN in NUMBER
53: ) is
54: cursor C is select ROWID from AMS_METRICS_ALL_B
55: where METRIC_ID = X_METRIC_ID
56: ;
57: l_rowid VARCHAR2(1000);
58: begin

Line 59: insert into AMS_METRICS_ALL_B (

55: where METRIC_ID = X_METRIC_ID
56: ;
57: l_rowid VARCHAR2(1000);
58: begin
59: insert into AMS_METRICS_ALL_B (
60: METRIC_ID,
61: OBJECT_VERSION_NUMBER,
62: ARC_METRIC_USED_FOR_OBJECT,
63: METRIC_CALCULATION_TYPE,

Line 208: from AMS_METRICS_ALL_B

204: FORMULA,
205: DISPLAY_TYPE,
206: TARGET_TYPE,
207: DENORM_CODE
208: from AMS_METRICS_ALL_B
209: where METRIC_ID = X_METRIC_ID
210: for update of METRIC_ID nowait;
211: recinfo c%rowtype;
212:

Line 330: update AMS_METRICS_ALL_B set

326: X_LAST_UPDATED_BY in NUMBER,
327: X_LAST_UPDATE_LOGIN in NUMBER
328: ) is
329: begin
330: update AMS_METRICS_ALL_B set
331: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
332: ARC_METRIC_USED_FOR_OBJECT = X_ARC_METRIC_USED_FOR_OBJECT,
333: METRIC_CALCULATION_TYPE = X_METRIC_CALCULATION_TYPE,
334: APPLICATION_ID = X_APPLICATION_ID,

Line 388: delete from AMS_METRICS_ALL_B

384: if (sql%notfound) then
385: raise no_data_found;
386: end if;
387:
388: delete from AMS_METRICS_ALL_B
389: where METRIC_ID = X_METRIC_ID;
390:
391: if (sql%notfound) then
392: raise no_data_found;

Line 402: from AMS_METRICS_ALL_B B

398: begin
399: delete from AMS_METRICS_ALL_TL T
400: where not exists
401: (select NULL
402: from AMS_METRICS_ALL_B B
403: where B.METRIC_ID = T.METRIC_ID
404: );
405:
406: update AMS_METRICS_ALL_TL T set (

Line 525: from AMS_METRICS_ALL_B

521: l_db_luby_id NUMBER;
522:
523: cursor c_db_data_details is
524: select last_updated_by, object_version_number
525: from AMS_METRICS_ALL_B
526: where metric_id = X_METRIC_ID;
527:
528: cursor c_chk_mtc_exists is
529: select 'x'

Line 530: from AMS_METRICS_ALL_B

526: where metric_id = X_METRIC_ID;
527:
528: cursor c_chk_mtc_exists is
529: select 'x'
530: from AMS_METRICS_ALL_B
531: where metric_id = X_METRIC_ID;
532:
533: cursor c_get_mtcid is
534: select AMS_METRICS_ALL_B_S.nextval

Line 534: select AMS_METRICS_ALL_B_S.nextval

530: from AMS_METRICS_ALL_B
531: where metric_id = X_METRIC_ID;
532:
533: cursor c_get_mtcid is
534: select AMS_METRICS_ALL_B_S.nextval
535: from dual;
536:
537: BEGIN
538: