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 527: from AMS_METRICS_ALL_B

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

Line 532: from AMS_METRICS_ALL_B

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

Line 536: select AMS_METRICS_ALL_B_S.nextval

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