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.FND_OAM_DSCFG_COMPILER_PKG dependencies on FND_OAM_DSCFG_UTILS_PKG

Line 519: fnd_oam_debug.log(1, l_ctxt, 'Verdict: '||FND_OAM_DSCFG_UTILS_PKG.BOOLEAN_TO_CANONICAL(l_valid));

515: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_NEW_COLUMN_VALUE);
516: l_valid := FALSE;
517: END IF;
518:
519: fnd_oam_debug.log(1, l_ctxt, 'Verdict: '||FND_OAM_DSCFG_UTILS_PKG.BOOLEAN_TO_CANONICAL(l_valid));
520:
521: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
522: RETURN l_valid;
523: EXCEPTION

Line 568: l_dml_update_segment.weight_modifier := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

564: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WHERE_CLAUSE THEN
565: l_dml_update_segment.where_clause := l_prop.canonical_value;
566:
567: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT_MODIFIER THEN
568: l_dml_update_segment.weight_modifier := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
569:
570: ELSE
571: --defer to the common handler if none of the object_type-specific property names match.
572: IF NOT HANDLE_COMMON_PROPERTY(px_object,

Line 649: fnd_oam_debug.log(1, l_ctxt, 'Verdict: '||FND_OAM_DSCFG_UTILS_PKG.BOOLEAN_TO_CANONICAL(l_valid));

645: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME);
646: l_valid := FALSE;
647: END IF;
648:
649: fnd_oam_debug.log(1, l_ctxt, 'Verdict: '||FND_OAM_DSCFG_UTILS_PKG.BOOLEAN_TO_CANONICAL(l_valid));
650:
651: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
652: RETURN l_valid;
653: EXCEPTION

Line 692: l_dml_delete_stmt.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

688: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WHERE_CLAUSE THEN
689: l_dml_delete_stmt.where_clause := l_prop.canonical_value;
690:
691: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN
692: l_dml_delete_stmt.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
693:
694: ELSE
695: --defer to the common handler if none of the object_type-specific property names match.
696: IF NOT HANDLE_COMMON_PROPERTY(px_object,

Line 773: fnd_oam_debug.log(1, l_ctxt, 'Verdict: '||FND_OAM_DSCFG_UTILS_PKG.BOOLEAN_TO_CANONICAL(l_valid));

769: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME);
770: l_valid := FALSE;
771: END IF;
772:
773: fnd_oam_debug.log(1, l_ctxt, 'Verdict: '||FND_OAM_DSCFG_UTILS_PKG.BOOLEAN_TO_CANONICAL(l_valid));
774:
775: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
776: RETURN l_valid;
777: EXCEPTION

Line 813: l_dml_truncate_stmt.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

809: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
810: l_dml_truncate_stmt.table_name := l_prop.canonical_value;
811:
812: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN
813: l_dml_truncate_stmt.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
814:
815: ELSE
816: --defer to the common handler if none of the object_type-specific property names match.
817: IF NOT HANDLE_COMMON_PROPERTY(px_object,

Line 885: fnd_oam_debug.log(1, l_ctxt, 'Verdict: '||FND_OAM_DSCFG_UTILS_PKG.BOOLEAN_TO_CANONICAL(l_valid));

881: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_PLSQL_TEXT);
882: l_valid := FALSE;
883: END IF;
884:
885: fnd_oam_debug.log(1, l_ctxt, 'Verdict: '||FND_OAM_DSCFG_UTILS_PKG.BOOLEAN_TO_CANONICAL(l_valid));
886:
887: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
888: RETURN l_valid;
889: EXCEPTION

Line 928: l_plsql_text.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

924: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
925: l_plsql_text.table_name := l_prop.canonical_value;
926:
927: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN
928: l_plsql_text.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
929:
930: ELSE
931: --defer to the common handler if none of the object_type-specific property names match.
932: IF NOT HANDLE_COMMON_PROPERTY(px_object,

Line 1011: b_run.run_id := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1007: l_prop := px_object_props(k);
1008:
1009: CASE l_prop.property_name
1010: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_RUN_ID THEN
1011: b_run.run_id := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1012:
1013: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_RUN_MODE THEN
1014: b_run.run_mode := l_prop.canonical_value;
1015:

Line 1017: b_run.valid_check_interval := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1013: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_RUN_MODE THEN
1014: b_run.run_mode := l_prop.canonical_value;
1015:
1016: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_VALID_CHECK_INTERVAL THEN
1017: b_run.valid_check_interval := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1018:
1019: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_NUM_BUNDLES THEN
1020: b_run.num_bundles := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1021:

Line 1020: b_run.num_bundles := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1016: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_VALID_CHECK_INTERVAL THEN
1017: b_run.valid_check_interval := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1018:
1019: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_NUM_BUNDLES THEN
1020: b_run.num_bundles := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1021:
1022: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN
1023: b_run.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1024:

Line 1023: b_run.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1019: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_NUM_BUNDLES THEN
1020: b_run.num_bundles := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1021:
1022: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN
1023: b_run.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1024:
1025: ELSE
1026: --invalid property
1027: HANDLE_UNKNOWN_PROPERTY(l_ctxt,

Line 1097: l_bundle.bundle_id := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1093: l_prop := px_object_props(k);
1094:
1095: CASE l_prop.property_name
1096: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_BUNDLE_ID THEN
1097: l_bundle.bundle_id := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1098:
1099: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME THEN
1100: l_bundle.target_hostname := UPPER(l_prop.canonical_value);
1101:

Line 1103: l_bundle.workers_allowed := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1099: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME THEN
1100: l_bundle.target_hostname := UPPER(l_prop.canonical_value);
1101:
1102: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED THEN
1103: l_bundle.workers_allowed := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1104:
1105: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE THEN
1106: l_bundle.batch_size := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1107:

Line 1106: l_bundle.batch_size := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1102: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED THEN
1103: l_bundle.workers_allowed := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1104:
1105: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE THEN
1106: l_bundle.batch_size := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1107:
1108: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT THEN
1109: l_bundle.min_parallel_unit_weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1110:

Line 1109: l_bundle.min_parallel_unit_weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1105: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE THEN
1106: l_bundle.batch_size := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1107:
1108: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT THEN
1109: l_bundle.min_parallel_unit_weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1110:
1111: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN
1112: l_bundle.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1113:

Line 1112: l_bundle.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1108: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT THEN
1109: l_bundle.min_parallel_unit_weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1110:
1111: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN
1112: l_bundle.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1113:
1114: ELSE
1115: --invalid property
1116: HANDLE_UNKNOWN_PROPERTY(l_ctxt,

Line 1183: l_bundle.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);

1179: l_prop := px_object_props(k);
1180:
1181: CASE l_prop.property_name
1182: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN
1183: l_bundle.weight := FND_OAM_DSCFG_UTILS_PKG.CANONICAL_TO_NUMBER(l_prop.canonical_value);
1184:
1185: ELSE
1186: --invalid property
1187: HANDLE_UNKNOWN_PROPERTY(l_ctxt,

Line 2282: FND_OAM_DSCFG_UTILS_PKG.GET_TABLE_WEIGHT(l_delete_def.table_owner,

2278: l_stmt := 'DELETE FROM '||l_delete_def.table_owner||'.'||l_delete_def.table_name;
2279:
2280: --compute the weight
2281: l_weight := CEIL(NVL(l_delete_def.weight, B_DELETE_WEIGHT_MODIFIER *
2282: FND_OAM_DSCFG_UTILS_PKG.GET_TABLE_WEIGHT(l_delete_def.table_owner,
2283: l_delete_def.table_name)));
2284: --add the dml
2285: ADD_ENGINE_DML(p_unit_id,
2286: l_stmt,

Line 2359: l_table_weight := FND_OAM_DSCFG_UTILS_PKG.GET_TABLE_WEIGHT(p_table_owner,

2355: l_prefix_len := length(l_prefix);
2356: l_suffix_len := NVL(length(l_suffix), 0);
2357:
2358: --get the table weight
2359: l_table_weight := FND_OAM_DSCFG_UTILS_PKG.GET_TABLE_WEIGHT(p_table_owner,
2360: p_table_name);
2361:
2362: -- initialize pieces we use to identify the currently accumulating sql statement
2363: l_set_clause := l_initial_set_clause;

Line 2945: FND_OAM_DSCFG_UTILS_PKG.GET_TABLE_WEIGHT(l_table_owner,

2941: l_truncate_stmt := b_dml_truncate_stmts(l_object_id);
2942:
2943: --figure out the true weight to use
2944: l_weight := CEIL(NVL(l_truncate_stmt.weight, B_TRUNCATE_WEIGHT_MODIFIER *
2945: FND_OAM_DSCFG_UTILS_PKG.GET_TABLE_WEIGHT(l_table_owner,
2946: l_table_name)));
2947: BEGIN
2948: l_unit_id := NULL;
2949: --even though truncates don't use AD splitting, store the unit object owner/name to simplify reporting