eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_METRIC_FORMULA_PVT dependencies on AMS_METRIC_FORMULAS

Line 96: SELECT AMS_METRIC_FORMULAS_s.NEXTVAL

92: l_dummy NUMBER;
93: l_rowid ROWID;
94:
95: CURSOR c_id IS
96: SELECT AMS_METRIC_FORMULAS_s.NEXTVAL
97: FROM dual;
98:
99: CURSOR c_id_exists (l_id IN NUMBER) IS
100: SELECT 1

Line 101: FROM AMS_METRIC_FORMULAS

97: FROM dual;
98:
99: CURSOR c_id_exists (l_id IN NUMBER) IS
100: SELECT 1
101: FROM AMS_METRIC_FORMULAS
102: WHERE METRIC_FORMULA_ID = l_id;
103:
104: CURSOR c_get_max_sequence (l_metric_id IN NUMBER) IS
105: select nvl(max(sequence),0)

Line 106: from ams_metric_formulas

102: WHERE METRIC_FORMULA_ID = l_id;
103:
104: CURSOR c_get_max_sequence (l_metric_id IN NUMBER) IS
105: select nvl(max(sequence),0)
106: from ams_metric_formulas
107: where metric_id = l_metric_id;
108:
109: l_metric_formula_rec met_formula_rec_type := p_met_formula_rec;
110: l_max_sequence number := null;

Line 220: Ams_Utility_Pvt.debug_message( 'Private API: Calling Ams_Metric_Formulas_Pkg.Insert_Row');

216:
217:
218: -- Debug Message
219: IF (AMS_DEBUG_HIGH_ON) THEN
220: Ams_Utility_Pvt.debug_message( 'Private API: Calling Ams_Metric_Formulas_Pkg.Insert_Row');
221: END IF;
222:
223: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Insert_Row)
224: Ams_Metric_Formulas_Pkg.Insert_Row(

Line 224: Ams_Metric_Formulas_Pkg.Insert_Row(

220: Ams_Utility_Pvt.debug_message( 'Private API: Calling Ams_Metric_Formulas_Pkg.Insert_Row');
221: END IF;
222:
223: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Insert_Row)
224: Ams_Metric_Formulas_Pkg.Insert_Row(
225: X_ROWID => l_rowid,
226: X_METRIC_FORMULA_ID => l_metric_formula_id,
227: X_METRIC_ID => l_metric_formula_rec.metric_id,
228: X_SOURCE_TYPE => l_metric_formula_rec.source_type,

Line 350: FROM AMS_METRIC_FORMULAS

346: token,
347: notation_type,
348: use_sub_id_flag,
349: sequence
350: FROM AMS_METRIC_FORMULAS
351: WHERE METRIC_FORMULA_ID = l_METRIC_FORMULA_ID;
352:
353: CURSOR c_get_max_sequence(l_metric_id NUMBER) is
354: select nvl(max(sequence),G_SEQUENCE_INCREMENT) from ams_metric_formulas

Line 354: select nvl(max(sequence),G_SEQUENCE_INCREMENT) from ams_metric_formulas

350: FROM AMS_METRIC_FORMULAS
351: WHERE METRIC_FORMULA_ID = l_METRIC_FORMULA_ID;
352:
353: CURSOR c_get_max_sequence(l_metric_id NUMBER) is
354: select nvl(max(sequence),G_SEQUENCE_INCREMENT) from ams_metric_formulas
355: where metric_id = l_metric_id;
356:
357: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_metric_formula';
358: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 492: Ams_Utility_Pvt.debug_message('Private API: Calling Ams_Metric_Formulas_Pkg.Update_Row, sequence='||l_tar_metric_formula_rec.sequence);

488: l_ref_metric_formula_rec.object_version_number + 1;
489:
490: -- Debug Message
491: IF (AMS_DEBUG_HIGH_ON) THEN
492: Ams_Utility_Pvt.debug_message('Private API: Calling Ams_Metric_Formulas_Pkg.Update_Row, sequence='||l_tar_metric_formula_rec.sequence);
493: END IF;
494:
495: -- Invoke table handler(Ams_Metric_Formulas_Pkg.Update_Row)
496: Ams_Metric_Formulas_Pkg.Update_Row(

Line 495: -- Invoke table handler(Ams_Metric_Formulas_Pkg.Update_Row)

491: IF (AMS_DEBUG_HIGH_ON) THEN
492: Ams_Utility_Pvt.debug_message('Private API: Calling Ams_Metric_Formulas_Pkg.Update_Row, sequence='||l_tar_metric_formula_rec.sequence);
493: END IF;
494:
495: -- Invoke table handler(Ams_Metric_Formulas_Pkg.Update_Row)
496: Ams_Metric_Formulas_Pkg.Update_Row(
497: X_METRIC_FORMULA_ID => l_tar_metric_formula_rec.METRIC_FORMULA_ID,
498: X_METRIC_ID => l_tar_metric_formula_rec.metric_id,
499: X_SOURCE_TYPE => l_tar_metric_formula_rec.source_type,

Line 496: Ams_Metric_Formulas_Pkg.Update_Row(

492: Ams_Utility_Pvt.debug_message('Private API: Calling Ams_Metric_Formulas_Pkg.Update_Row, sequence='||l_tar_metric_formula_rec.sequence);
493: END IF;
494:
495: -- Invoke table handler(Ams_Metric_Formulas_Pkg.Update_Row)
496: Ams_Metric_Formulas_Pkg.Update_Row(
497: X_METRIC_FORMULA_ID => l_tar_metric_formula_rec.METRIC_FORMULA_ID,
498: X_METRIC_ID => l_tar_metric_formula_rec.metric_id,
499: X_SOURCE_TYPE => l_tar_metric_formula_rec.source_type,
500: X_SOURCE_ID => l_tar_metric_formula_rec.source_id,

Line 641: AMS_METRIC_FORMULAS_PKG.Delete_Row(

637: Ams_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
638: END IF;
639:
640: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Delete_Row)
641: AMS_METRIC_FORMULAS_PKG.Delete_Row(
642: X_METRIC_FORMULA_ID => p_METRIC_FORMULA_ID);
643: --
644: -- End of API body
645: --

Line 729: FROM AMS_METRIC_FORMULAS

725: l_METRIC_FORMULA_ID NUMBER;
726:
727: CURSOR c_metric_formula IS
728: SELECT METRIC_FORMULA_ID
729: FROM AMS_METRIC_FORMULAS
730: WHERE METRIC_FORMULA_ID = p_METRIC_FORMULA_ID
731: AND object_version_number = p_object_version
732: FOR UPDATE NOWAIT;
733:

Line 844: select COUNT(1) from ams_metric_formulas

840: l_dummy NUMBER;
841:
842: cursor c_check_sequence_update(p_metric_formula_id number, p_metric_id number,
843: p_sequence NUMBER) IS
844: select COUNT(1) from ams_metric_formulas
845: where metric_id = p_metric_id
846: and metric_formula_id <> p_metric_formula_id
847: and sequence = p_sequence;
848:

Line 851: select COUNT(1) from ams_metric_formulas

847: and sequence = p_sequence;
848:
849: cursor c_check_sequence_new(p_metric_id number,
850: p_sequence NUMBER) IS
851: select COUNT(1) from ams_metric_formulas
852: where metric_id = p_metric_id
853: and sequence = p_sequence;
854: */
855: BEGIN

Line 863: 'AMS_METRIC_FORMULAS',

859: END IF;
860: x_return_status := FND_API.g_ret_sts_success;
861: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
862: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
863: 'AMS_METRIC_FORMULAS',
864: 'METRIC_FORMULA_ID = ' || p_metric_formula_rec.METRIC_FORMULA_ID
865: );
866: END IF;
867:

Line 1678: FROM ams_metric_formulas f, ams_metrics_vl m, ams_lookups opers,

1674: f.use_sub_id_flag ,
1675: f.source_value ,
1676: f.source_id,
1677: f.source_sub_id
1678: FROM ams_metric_formulas f, ams_metrics_vl m, ams_lookups opers,
1679: ams_categories_vl c, ams_categories_vl sc, ams_lookups delim,
1680: ams_lookups incsubcat, ams_lookups excsubcat
1681: WHERE f.metric_id = l_metric_id
1682: AND f.source_id = m.metric_id(+)

Line 1768: delete from ams_metric_formulas

1764: );
1765:
1766:
1767:
1768: delete from ams_metric_formulas
1769: where metric_id = p_metric_id
1770: and notation_type = 'POSTFIX';
1771:
1772: if g_source_type_tbl.count > 0 then

Line 1774: insert into ams_metric_formulas

1770: and notation_type = 'POSTFIX';
1771:
1772: if g_source_type_tbl.count > 0 then
1773: forall l_index in g_source_type_tbl.first..g_source_type_tbl.last
1774: insert into ams_metric_formulas
1775: (METRIC_FORMULA_ID ,
1776: LAST_UPDATE_DATE ,
1777: LAST_UPDATED_BY ,
1778: CREATION_DATE ,

Line 1792: (AMS_METRIC_FORMULAS_S.nextval,

1788: SOURCE_VALUE ,
1789: SOURCE_SUB_ID ,
1790: USE_SUB_ID_FLAG )
1791: values
1792: (AMS_METRIC_FORMULAS_S.nextval,
1793: sysdate,
1794: 0,
1795: sysdate,
1796: 0,