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_API_PKG

Line 428: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_PRIMARY_DOMAIN THEN

424: l_ctxt VARCHAR2(60) := PKG_NAME||'HANDLE_COMMON_PROPERTY';
425: l_msg VARCHAR2(4000);
426: BEGIN
427: CASE px_prop.property_name
428: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_PRIMARY_DOMAIN THEN
429: --force all domains to be case insensitive
430: px_object.primary_domain := UPPER(TRIM(px_prop.canonical_value));
431:
432: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_ADDITIONAL_DOMAIN THEN

Line 432: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_ADDITIONAL_DOMAIN THEN

428: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_PRIMARY_DOMAIN THEN
429: --force all domains to be case insensitive
430: px_object.primary_domain := UPPER(TRIM(px_prop.canonical_value));
431:
432: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_ADDITIONAL_DOMAIN THEN
433: --the additional domain can't be null
434: IF px_prop.canonical_value IS NULL THEN
435: l_msg := 'Additional Domain properties cannot have NULL values.';
436: fnd_oam_debug.log(3, l_ctxt, l_msg);

Line 497: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER);

493:
494: --check for our properties, add messages for each not found
495: IF p_segment.table_owner IS NULL THEN
496: MARK_OBJECT_AS_ERRORED(px_object,
497: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER);
498: l_valid := FALSE;
499: END IF;
500:
501: IF p_segment.table_name IS NULL THEN

Line 503: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME);

499: END IF;
500:
501: IF p_segment.table_name IS NULL THEN
502: MARK_OBJECT_AS_ERRORED(px_object,
503: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME);
504: l_valid := FALSE;
505: END IF;
506:
507: IF p_segment.column_name IS NULL THEN

Line 509: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_COLUMN_NAME);

505: END IF;
506:
507: IF p_segment.column_name IS NULL THEN
508: MARK_OBJECT_AS_ERRORED(px_object,
509: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_COLUMN_NAME);
510: l_valid := FALSE;
511: END IF;
512:
513: IF p_segment.new_column_value IS NULL THEN

Line 515: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_NEW_COLUMN_VALUE);

511: END IF;
512:
513: IF p_segment.new_column_value IS NULL THEN
514: MARK_OBJECT_AS_ERRORED(px_object,
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));

Line 552: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN

548: WHILE k IS NOT NULL LOOP
549: l_prop := px_object_props(k);
550:
551: CASE l_prop.property_name
552: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN
553: l_dml_update_segment.table_owner := l_prop.canonical_value;
554:
555: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
556: l_dml_update_segment.table_name := l_prop.canonical_value;

Line 555: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN

551: CASE l_prop.property_name
552: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN
553: l_dml_update_segment.table_owner := l_prop.canonical_value;
554:
555: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
556: l_dml_update_segment.table_name := l_prop.canonical_value;
557:
558: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_COLUMN_NAME THEN
559: l_dml_update_segment.column_name := l_prop.canonical_value;

Line 558: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_COLUMN_NAME THEN

554:
555: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
556: l_dml_update_segment.table_name := l_prop.canonical_value;
557:
558: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_COLUMN_NAME THEN
559: l_dml_update_segment.column_name := l_prop.canonical_value;
560:
561: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_NEW_COLUMN_VALUE THEN
562: l_dml_update_segment.new_column_value := l_prop.canonical_value;

Line 561: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_NEW_COLUMN_VALUE THEN

557:
558: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_COLUMN_NAME THEN
559: l_dml_update_segment.column_name := l_prop.canonical_value;
560:
561: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_NEW_COLUMN_VALUE THEN
562: l_dml_update_segment.new_column_value := l_prop.canonical_value;
563:
564: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WHERE_CLAUSE THEN
565: l_dml_update_segment.where_clause := l_prop.canonical_value;

Line 564: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WHERE_CLAUSE THEN

560:
561: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_NEW_COLUMN_VALUE THEN
562: l_dml_update_segment.new_column_value := l_prop.canonical_value;
563:
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);

Line 567: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT_MODIFIER THEN

563:
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.

Line 639: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER);

635:
636: --check for our properties, add messages for each not found
637: IF p_stmt.table_owner IS NULL THEN
638: MARK_OBJECT_AS_ERRORED(px_object,
639: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER);
640: l_valid := FALSE;
641: END IF;
642:
643: IF p_stmt.table_name IS NULL THEN

Line 645: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME);

641: END IF;
642:
643: IF p_stmt.table_name IS NULL THEN
644: MARK_OBJECT_AS_ERRORED(px_object,
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));

Line 682: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN

678: WHILE k IS NOT NULL LOOP
679: l_prop := px_object_props(k);
680:
681: CASE l_prop.property_name
682: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN
683: l_dml_delete_stmt.table_owner := l_prop.canonical_value;
684:
685: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
686: l_dml_delete_stmt.table_name := l_prop.canonical_value;

Line 685: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN

681: CASE l_prop.property_name
682: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN
683: l_dml_delete_stmt.table_owner := l_prop.canonical_value;
684:
685: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
686: l_dml_delete_stmt.table_name := l_prop.canonical_value;
687:
688: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WHERE_CLAUSE THEN
689: l_dml_delete_stmt.where_clause := l_prop.canonical_value;

Line 688: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WHERE_CLAUSE THEN

684:
685: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
686: l_dml_delete_stmt.table_name := l_prop.canonical_value;
687:
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);

Line 691: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN

687:
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.

Line 763: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER);

759:
760: --check for our properties, add messages for each not found
761: IF p_stmt.table_owner IS NULL THEN
762: MARK_OBJECT_AS_ERRORED(px_object,
763: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER);
764: l_valid := FALSE;
765: END IF;
766:
767: IF p_stmt.table_name IS NULL THEN

Line 769: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME);

765: END IF;
766:
767: IF p_stmt.table_name IS NULL THEN
768: MARK_OBJECT_AS_ERRORED(px_object,
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));

Line 806: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN

802: WHILE k IS NOT NULL LOOP
803: l_prop := px_object_props(k);
804:
805: CASE l_prop.property_name
806: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN
807: l_dml_truncate_stmt.table_owner := l_prop.canonical_value;
808:
809: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
810: l_dml_truncate_stmt.table_name := l_prop.canonical_value;

Line 809: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN

805: CASE l_prop.property_name
806: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN
807: l_dml_truncate_stmt.table_owner := l_prop.canonical_value;
808:
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);

Line 812: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN

808:
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.

Line 881: 'Missing Property: '||FND_OAM_DSCFG_API_PKG.G_PROP_PLSQL_TEXT);

877:
878: --check for our properties, add messages for each not found
879: IF p_plsql.plsql_text IS NULL THEN
880: MARK_OBJECT_AS_ERRORED(px_object,
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));

Line 918: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_PLSQL_TEXT THEN

914: WHILE k IS NOT NULL LOOP
915: l_prop := px_object_props(k);
916:
917: CASE l_prop.property_name
918: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_PLSQL_TEXT THEN
919: l_plsql_text.plsql_text := l_prop.canonical_value;
920:
921: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN
922: l_plsql_text.table_owner := l_prop.canonical_value;

Line 921: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN

917: CASE l_prop.property_name
918: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_PLSQL_TEXT THEN
919: l_plsql_text.plsql_text := l_prop.canonical_value;
920:
921: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN
922: l_plsql_text.table_owner := l_prop.canonical_value;
923:
924: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN
925: l_plsql_text.table_name := l_prop.canonical_value;

Line 924: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_NAME THEN

920:
921: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TABLE_OWNER THEN
922: l_plsql_text.table_owner := l_prop.canonical_value;
923:
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);

Line 927: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN

923:
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.

Line 1010: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_RUN_ID THEN

1006: WHILE k IS NOT NULL LOOP
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;

Line 1013: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_RUN_MODE THEN

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:
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);

Line 1016: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_VALID_CHECK_INTERVAL THEN

1012:
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);

Line 1019: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_NUM_BUNDLES THEN

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:
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);

Line 1022: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN

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:
1025: ELSE
1026: --invalid property

Line 1096: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_BUNDLE_ID THEN

1092: WHILE k IS NOT NULL LOOP
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);

Line 1099: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME THEN

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:
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);

Line 1102: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED THEN

1098:
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);

Line 1105: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE THEN

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:
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);

Line 1108: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT THEN

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:
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);

Line 1111: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN

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:
1114: ELSE
1115: --invalid property

Line 1182: WHEN FND_OAM_DSCFG_API_PKG.G_PROP_WEIGHT THEN

1178: WHILE k IS NOT NULL LOOP
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

Line 1235: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT THEN

1231: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1232:
1233: --prepare the object and cache it in the object_type-specific cache
1234: CASE px_object.object_type
1235: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT THEN
1236: CACHE_DML_UPDATE_SEGMENT(px_object,
1237: px_object_props);
1238: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT THEN
1239: CACHE_DML_DELETE_STMT(px_object,

Line 1238: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT THEN

1234: CASE px_object.object_type
1235: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT THEN
1236: CACHE_DML_UPDATE_SEGMENT(px_object,
1237: px_object_props);
1238: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT THEN
1239: CACHE_DML_DELETE_STMT(px_object,
1240: px_object_props);
1241: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT THEN
1242: CACHE_DML_TRUNCATE_STMT(px_object,

Line 1241: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT THEN

1237: px_object_props);
1238: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT THEN
1239: CACHE_DML_DELETE_STMT(px_object,
1240: px_object_props);
1241: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT THEN
1242: CACHE_DML_TRUNCATE_STMT(px_object,
1243: px_object_props);
1244: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT THEN
1245: CACHE_PLSQL_TEXT(px_object,

Line 1244: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT THEN

1240: px_object_props);
1241: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT THEN
1242: CACHE_DML_TRUNCATE_STMT(px_object,
1243: px_object_props);
1244: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT THEN
1245: CACHE_PLSQL_TEXT(px_object,
1246: px_object_props);
1247: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN THEN
1248: CACHE_RUN(px_object,

Line 1247: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN THEN

1243: px_object_props);
1244: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT THEN
1245: CACHE_PLSQL_TEXT(px_object,
1246: px_object_props);
1247: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN THEN
1248: CACHE_RUN(px_object,
1249: px_object_props);
1250: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE THEN
1251: CACHE_BUNDLE(px_object,

Line 1250: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE THEN

1246: px_object_props);
1247: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN THEN
1248: CACHE_RUN(px_object,
1249: px_object_props);
1250: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE THEN
1251: CACHE_BUNDLE(px_object,
1252: px_object_props);
1253: --WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA THEN
1254: -- CACHE_DOMAIN_METADATA(px_object,

Line 1253: --WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA THEN

1249: px_object_props);
1250: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE THEN
1251: CACHE_BUNDLE(px_object,
1252: px_object_props);
1253: --WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA THEN
1254: -- CACHE_DOMAIN_METADATA(px_object,
1255: -- px_object_props);
1256: ELSE
1257: --unknown object type, add a message, set the errors flag

Line 1268: px_object.object_type NOT IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,

1264: END CASE;
1265:
1266: --check that the object came back with a primary domain
1267: IF px_object.primary_domain IS NULL AND
1268: px_object.object_type NOT IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1269: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE) THEN
1270: l_msg := 'Object has no primary domain - this is not allowed.';
1271: fnd_oam_debug.log(3, l_ctxt, l_msg);
1272: MARK_OBJECT_AS_ERRORED(px_object,

Line 1269: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE) THEN

1265:
1266: --check that the object came back with a primary domain
1267: IF px_object.primary_domain IS NULL AND
1268: px_object.object_type NOT IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1269: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE) THEN
1270: l_msg := 'Object has no primary domain - this is not allowed.';
1271: fnd_oam_debug.log(3, l_ctxt, l_msg);
1272: MARK_OBJECT_AS_ERRORED(px_object,
1273: l_msg);

Line 1345: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,

1341: SELECT object_id, object_type, target_type, target_id
1342: BULK COLLECT INTO l_object_ids, l_object_types, l_target_types, l_target_ids
1343: FROM fnd_oam_dscfg_objects
1344: WHERE config_instance_id = p_config_instance_id
1345: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1346: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1347: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1348: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1349: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,

Line 1346: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,

1342: BULK COLLECT INTO l_object_ids, l_object_types, l_target_types, l_target_ids
1343: FROM fnd_oam_dscfg_objects
1344: WHERE config_instance_id = p_config_instance_id
1345: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1346: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1347: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1348: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1349: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1350: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,

Line 1347: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,

1343: FROM fnd_oam_dscfg_objects
1344: WHERE config_instance_id = p_config_instance_id
1345: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1346: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1347: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1348: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1349: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1350: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1351: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA)

Line 1348: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,

1344: WHERE config_instance_id = p_config_instance_id
1345: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1346: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1347: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1348: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1349: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1350: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1351: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA)
1352: ORDER BY object_id DESC;

Line 1349: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,

1345: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1346: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1347: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1348: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1349: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1350: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1351: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA)
1352: ORDER BY object_id DESC;
1353: fnd_oam_debug.log(1, l_ctxt, '...Done');

Line 1350: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,

1346: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1347: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1348: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1349: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1350: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1351: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA)
1352: ORDER BY object_id DESC;
1353: fnd_oam_debug.log(1, l_ctxt, '...Done');
1354:

Line 1351: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA)

1347: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1348: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1349: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1350: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1351: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA)
1352: ORDER BY object_id DESC;
1353: fnd_oam_debug.log(1, l_ctxt, '...Done');
1354:
1355: -- since we can't use l_object_ids to only get the properties we want, duplicate the object conditions above

Line 1361: WHERE parent_type = FND_OAM_DSCFG_API_PKG.G_TYPE_OBJECT

1357: fnd_oam_debug.log(1, l_ctxt, 'Fetching all corresponding object properties...');
1358: SELECT property_id, parent_id, property_name, datatype, canonical_value
1359: BULK COLLECT INTO l_prop_ids, l_prop_object_ids, l_prop_names, l_datatypes, l_canonical_values
1360: FROM fnd_oam_dscfg_properties
1361: WHERE parent_type = FND_OAM_DSCFG_API_PKG.G_TYPE_OBJECT
1362: AND parent_id in (SELECT object_id
1363: FROM fnd_oam_dscfg_objects
1364: WHERE config_instance_id = p_config_instance_id
1365: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,

Line 1365: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,

1361: WHERE parent_type = FND_OAM_DSCFG_API_PKG.G_TYPE_OBJECT
1362: AND parent_id in (SELECT object_id
1363: FROM fnd_oam_dscfg_objects
1364: WHERE config_instance_id = p_config_instance_id
1365: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1366: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1367: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1368: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1369: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,

Line 1366: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,

1362: AND parent_id in (SELECT object_id
1363: FROM fnd_oam_dscfg_objects
1364: WHERE config_instance_id = p_config_instance_id
1365: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1366: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1367: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1368: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1369: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1370: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,

Line 1367: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,

1363: FROM fnd_oam_dscfg_objects
1364: WHERE config_instance_id = p_config_instance_id
1365: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1366: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1367: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1368: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1369: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1370: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1371: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA))

Line 1368: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,

1364: WHERE config_instance_id = p_config_instance_id
1365: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1366: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1367: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1368: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1369: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1370: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1371: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA))
1372: ORDER BY parent_id DESC, property_id DESC;

Line 1369: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,

1365: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1366: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1367: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1368: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1369: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1370: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1371: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA))
1372: ORDER BY parent_id DESC, property_id DESC;
1373: fnd_oam_debug.log(1, l_ctxt, '...Done');

Line 1370: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,

1366: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1367: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1368: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1369: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1370: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1371: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA))
1372: ORDER BY parent_id DESC, property_id DESC;
1373: fnd_oam_debug.log(1, l_ctxt, '...Done');
1374:

Line 1371: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA))

1367: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,
1368: FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT,
1369: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1370: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1371: FND_OAM_DSCFG_API_PKG.G_OTYPE_DOMAIN_METADATA))
1372: ORDER BY parent_id DESC, property_id DESC;
1373: fnd_oam_debug.log(1, l_ctxt, '...Done');
1374:
1375: --now we need to go through and create b_objects entries and b_ entries.

Line 1608: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,

1604:
1605: --see if we need to create a run object if none was cached on fetch
1606: IF b_run.object_id IS NULL THEN
1607: fnd_oam_debug.log(2, l_ctxt, 'Creating new run object');
1608: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN,
1609: x_object_id => b_run.object_id);
1610: fnd_oam_debug.log(2, l_ctxt, 'run object_id: '||b_run.object_id);
1611: --add an entry to the b_objects array so we can cache messages there
1612: b_objects(b_run.object_id) := CREATE_OBJECT_DEF(b_run.object_id,

Line 1613: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN);

1609: x_object_id => b_run.object_id);
1610: fnd_oam_debug.log(2, l_ctxt, 'run object_id: '||b_run.object_id);
1611: --add an entry to the b_objects array so we can cache messages there
1612: b_objects(b_run.object_id) := CREATE_OBJECT_DEF(b_run.object_id,
1613: FND_OAM_DSCFG_API_PKG.G_OTYPE_RUN);
1614: END IF;
1615:
1616: --validate the run mode
1617: IF b_run.run_mode IS NULL THEN

Line 1619: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,

1615:
1616: --validate the run mode
1617: IF b_run.run_mode IS NULL THEN
1618: b_run.run_mode := B_DEFAULT_RUN_MODE;
1619: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,
1620: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_RUN_MODE,
1621: p_varchar2_value => b_run.run_mode,
1622: x_property_id => l_property_id);
1623: ELSE

Line 1620: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_RUN_MODE,

1616: --validate the run mode
1617: IF b_run.run_mode IS NULL THEN
1618: b_run.run_mode := B_DEFAULT_RUN_MODE;
1619: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,
1620: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_RUN_MODE,
1621: p_varchar2_value => b_run.run_mode,
1622: x_property_id => l_property_id);
1623: ELSE
1624: IF b_run.run_mode NOT IN (FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL,

Line 1640: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,

1636:
1637: --default the valid_check_interval if not present
1638: IF b_run.valid_check_interval IS NULL THEN
1639: b_run.valid_check_interval := GET_DFLT_VALID_CHECK_INTERVAL;
1640: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,
1641: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_VALID_CHECK_INTERVAL,
1642: p_number_value => b_run.valid_check_interval,
1643: x_property_id => l_property_id);
1644: ELSE

Line 1641: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_VALID_CHECK_INTERVAL,

1637: --default the valid_check_interval if not present
1638: IF b_run.valid_check_interval IS NULL THEN
1639: b_run.valid_check_interval := GET_DFLT_VALID_CHECK_INTERVAL;
1640: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,
1641: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_VALID_CHECK_INTERVAL,
1642: p_number_value => b_run.valid_check_interval,
1643: x_property_id => l_property_id);
1644: ELSE
1645: IF b_run.valid_check_interval < 0 THEN

Line 1663: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,

1659: --defer the check if this is greater than the # of hosts in the instance until GENERATE_BUNDLES
1660: ELSE
1661: b_run.num_bundles := B_DEFAULT_NUM_BUNDLES;
1662: END IF;
1663: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,
1664: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_NUM_BUNDLES,
1665: p_number_value => b_run.num_bundles,
1666: x_property_id => l_property_id);
1667: ELSE

Line 1664: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_NUM_BUNDLES,

1660: ELSE
1661: b_run.num_bundles := B_DEFAULT_NUM_BUNDLES;
1662: END IF;
1663: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,
1664: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_NUM_BUNDLES,
1665: p_number_value => b_run.num_bundles,
1666: x_property_id => l_property_id);
1667: ELSE
1668: IF b_run.num_bundles < 1 THEN

Line 1737: FND_OAM_DSCFG_API_PKG.SET_OR_ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,

1733: RETURNING run_id INTO b_run.run_id;
1734: fnd_oam_debug.log(1, l_ctxt, 'Created new run_id: '||b_run.run_id);
1735:
1736: --store the run_id
1737: FND_OAM_DSCFG_API_PKG.SET_OR_ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,
1738: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_RUN_ID,
1739: p_number_value => b_run.run_id,
1740: x_property_id => l_property_id);
1741:

Line 1738: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_RUN_ID,

1734: fnd_oam_debug.log(1, l_ctxt, 'Created new run_id: '||b_run.run_id);
1735:
1736: --store the run_id
1737: FND_OAM_DSCFG_API_PKG.SET_OR_ADD_OBJECT_PROPERTY(p_object_id => b_run.object_id,
1738: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_RUN_ID,
1739: p_number_value => b_run.run_id,
1740: x_property_id => l_property_id);
1741:
1742: fnd_oam_debug.log(1, l_ctxt, 'Querying config_instance attributes');

Line 1880: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,

1876:
1877: --validate the workers_allowed
1878: IF b_bundles(k).workers_allowed IS NULL THEN
1879: b_bundles(k).workers_allowed := GET_DEFAULT_NUM_WORKERS;
1880: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,
1881: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED,
1882: p_number_value => b_bundles(k).workers_allowed,
1883: x_property_id => l_property_id);
1884: ELSE

Line 1881: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED,

1877: --validate the workers_allowed
1878: IF b_bundles(k).workers_allowed IS NULL THEN
1879: b_bundles(k).workers_allowed := GET_DEFAULT_NUM_WORKERS;
1880: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,
1881: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED,
1882: p_number_value => b_bundles(k).workers_allowed,
1883: x_property_id => l_property_id);
1884: ELSE
1885: IF b_bundles(k).workers_allowed < 1 THEN

Line 1898: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,

1894:
1895: --validate the batch_size
1896: IF b_bundles(k).batch_size IS NULL THEN
1897: b_bundles(k).batch_size := GET_DEFAULT_BATCH_SIZE;
1898: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,
1899: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE,
1900: p_number_value => b_bundles(k).batch_size,
1901: x_property_id => l_property_id);
1902: ELSE

Line 1899: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE,

1895: --validate the batch_size
1896: IF b_bundles(k).batch_size IS NULL THEN
1897: b_bundles(k).batch_size := GET_DEFAULT_BATCH_SIZE;
1898: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,
1899: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE,
1900: p_number_value => b_bundles(k).batch_size,
1901: x_property_id => l_property_id);
1902: ELSE
1903: IF b_bundles(k).batch_size < 1 THEN

Line 1916: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,

1912:
1913: --validate the min_parallel_unit_weight
1914: IF b_bundles(k).min_parallel_unit_weight IS NULL THEN
1915: b_bundles(k).min_parallel_unit_weight := GET_DFLT_MIN_PARALLEL_WEIGHT;
1916: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,
1917: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT,
1918: p_number_value => b_bundles(k).min_parallel_unit_weight,
1919: x_property_id => l_property_id);
1920: ELSE

Line 1917: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT,

1913: --validate the min_parallel_unit_weight
1914: IF b_bundles(k).min_parallel_unit_weight IS NULL THEN
1915: b_bundles(k).min_parallel_unit_weight := GET_DFLT_MIN_PARALLEL_WEIGHT;
1916: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,
1917: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT,
1918: p_number_value => b_bundles(k).min_parallel_unit_weight,
1919: x_property_id => l_property_id);
1920: ELSE
1921: IF b_bundles(k).min_parallel_unit_weight < 1 THEN

Line 1947: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,

1943: fnd_oam_debug.log(1, l_ctxt, 'Assigned host_name "'||l_host_name||'" to bundle_object_id: '||k);
1944: l_host_names.DELETE(l_host_names.FIRST);
1945: b_host_name_map(b_bundles(k).target_hostname) := k;
1946:
1947: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,
1948: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME,
1949: p_varchar2_value => b_bundles(k).target_hostname,
1950: x_property_id => l_property_id);
1951: END IF;

Line 1948: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME,

1944: l_host_names.DELETE(l_host_names.FIRST);
1945: b_host_name_map(b_bundles(k).target_hostname) := k;
1946:
1947: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => k,
1948: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME,
1949: p_varchar2_value => b_bundles(k).target_hostname,
1950: x_property_id => l_property_id);
1951: END IF;
1952:

Line 1964: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,

1960: l_bundles_to_create := b_run.num_bundles - b_bundles.COUNT;
1961: fnd_oam_debug.log(1, l_ctxt, 'Creating '||l_bundles_to_create||' bundle objects...');
1962: FOR k in 1..l_bundles_to_create LOOP
1963: --create a bundle object
1964: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1965: x_object_id => l_bundle_object_id);
1966: fnd_oam_debug.log(1, l_ctxt, 'Bundle object_id: '||l_bundle_object_id);
1967: b_objects(l_bundle_object_id) := CREATE_OBJECT_DEF(l_bundle_object_id,
1968: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE);

Line 1968: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE);

1964: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE,
1965: x_object_id => l_bundle_object_id);
1966: fnd_oam_debug.log(1, l_ctxt, 'Bundle object_id: '||l_bundle_object_id);
1967: b_objects(l_bundle_object_id) := CREATE_OBJECT_DEF(l_bundle_object_id,
1968: FND_OAM_DSCFG_API_PKG.G_OTYPE_BUNDLE);
1969:
1970: --use the next available host name
1971: b_bundles(l_bundle_object_id) := CREATE_BUNDLE_DEF(l_host_names(l_host_names.FIRST));
1972: l_host_names.DELETE(l_host_names.FIRST);

Line 1976: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,

1972: l_host_names.DELETE(l_host_names.FIRST);
1973: b_host_name_map(b_bundles(l_bundle_object_id).target_hostname) := l_bundle_object_id;
1974:
1975: --add properties for mandatory attributes
1976: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,
1977: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME,
1978: p_varchar2_value => b_bundles(l_bundle_object_id).target_hostname,
1979: x_property_id => l_property_id);
1980: fnd_oam_debug.log(1, l_ctxt, 'Target Hostname: '||b_bundles(l_bundle_object_id).target_hostname);

Line 1977: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME,

1973: b_host_name_map(b_bundles(l_bundle_object_id).target_hostname) := l_bundle_object_id;
1974:
1975: --add properties for mandatory attributes
1976: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,
1977: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME,
1978: p_varchar2_value => b_bundles(l_bundle_object_id).target_hostname,
1979: x_property_id => l_property_id);
1980: fnd_oam_debug.log(1, l_ctxt, 'Target Hostname: '||b_bundles(l_bundle_object_id).target_hostname);
1981: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,

Line 1981: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,

1977: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_TARGET_HOSTNAME,
1978: p_varchar2_value => b_bundles(l_bundle_object_id).target_hostname,
1979: x_property_id => l_property_id);
1980: fnd_oam_debug.log(1, l_ctxt, 'Target Hostname: '||b_bundles(l_bundle_object_id).target_hostname);
1981: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,
1982: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED,
1983: p_number_value => b_bundles(l_bundle_object_id).workers_allowed,
1984: x_property_id => l_property_id);
1985: fnd_oam_debug.log(1, l_ctxt, 'Workers Allowed: '||b_bundles(l_bundle_object_id).workers_allowed);

Line 1982: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED,

1978: p_varchar2_value => b_bundles(l_bundle_object_id).target_hostname,
1979: x_property_id => l_property_id);
1980: fnd_oam_debug.log(1, l_ctxt, 'Target Hostname: '||b_bundles(l_bundle_object_id).target_hostname);
1981: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,
1982: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED,
1983: p_number_value => b_bundles(l_bundle_object_id).workers_allowed,
1984: x_property_id => l_property_id);
1985: fnd_oam_debug.log(1, l_ctxt, 'Workers Allowed: '||b_bundles(l_bundle_object_id).workers_allowed);
1986: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,

Line 1986: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,

1982: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_WORKERS_ALLOWED,
1983: p_number_value => b_bundles(l_bundle_object_id).workers_allowed,
1984: x_property_id => l_property_id);
1985: fnd_oam_debug.log(1, l_ctxt, 'Workers Allowed: '||b_bundles(l_bundle_object_id).workers_allowed);
1986: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,
1987: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE,
1988: p_number_value => b_bundles(l_bundle_object_id).batch_size,
1989: x_property_id => l_property_id);
1990: fnd_oam_debug.log(1, l_ctxt, 'Batch Size: '||b_bundles(l_bundle_object_id).batch_size);

Line 1987: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE,

1983: p_number_value => b_bundles(l_bundle_object_id).workers_allowed,
1984: x_property_id => l_property_id);
1985: fnd_oam_debug.log(1, l_ctxt, 'Workers Allowed: '||b_bundles(l_bundle_object_id).workers_allowed);
1986: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,
1987: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE,
1988: p_number_value => b_bundles(l_bundle_object_id).batch_size,
1989: x_property_id => l_property_id);
1990: fnd_oam_debug.log(1, l_ctxt, 'Batch Size: '||b_bundles(l_bundle_object_id).batch_size);
1991: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,

Line 1991: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,

1987: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BATCH_SIZE,
1988: p_number_value => b_bundles(l_bundle_object_id).batch_size,
1989: x_property_id => l_property_id);
1990: fnd_oam_debug.log(1, l_ctxt, 'Batch Size: '||b_bundles(l_bundle_object_id).batch_size);
1991: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,
1992: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT,
1993: p_number_value => b_bundles(l_bundle_object_id).min_parallel_unit_weight,
1994: x_property_id => l_property_id);
1995: fnd_oam_debug.log(1, l_ctxt, 'Min Parallel Unit Weight: '||b_bundles(l_bundle_object_id).min_parallel_unit_weight);

Line 1992: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT,

1988: p_number_value => b_bundles(l_bundle_object_id).batch_size,
1989: x_property_id => l_property_id);
1990: fnd_oam_debug.log(1, l_ctxt, 'Batch Size: '||b_bundles(l_bundle_object_id).batch_size);
1991: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_bundle_object_id,
1992: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_MIN_PARALLEL_WEIGHT,
1993: p_number_value => b_bundles(l_bundle_object_id).min_parallel_unit_weight,
1994: x_property_id => l_property_id);
1995: fnd_oam_debug.log(1, l_ctxt, 'Min Parallel Unit Weight: '||b_bundles(l_bundle_object_id).min_parallel_unit_weight);
1996: END LOOP;

Line 2037: FND_OAM_DSCFG_API_PKG.SET_OR_ADD_OBJECT_PROPERTY(p_object_id => k,

2033: RETURNING bundle_id INTO b_bundles(k).bundle_id;
2034: fnd_oam_debug.log(1, l_ctxt, 'Bundle Object ID ('||k||') created bundle_id ('||b_bundles(k).bundle_id||')');
2035:
2036: --add the property for bundle id
2037: FND_OAM_DSCFG_API_PKG.SET_OR_ADD_OBJECT_PROPERTY(p_object_id => k,
2038: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BUNDLE_ID,
2039: p_number_value => b_bundles(k).bundle_id,
2040: x_property_id => l_property_id);
2041:

Line 2038: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BUNDLE_ID,

2034: fnd_oam_debug.log(1, l_ctxt, 'Bundle Object ID ('||k||') created bundle_id ('||b_bundles(k).bundle_id||')');
2035:
2036: --add the property for bundle id
2037: FND_OAM_DSCFG_API_PKG.SET_OR_ADD_OBJECT_PROPERTY(p_object_id => k,
2038: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_BUNDLE_ID,
2039: p_number_value => b_bundles(k).bundle_id,
2040: x_property_id => l_property_id);
2041:
2042: k := b_bundles.NEXT(k);

Line 2760: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT THEN

2756: l_object_id := b_primary_domains(p_primary_domain)(k);
2757: fnd_oam_debug.log(1, l_ctxt, 'Parsing object_id: '||l_object_id||'('||b_objects(l_object_id).object_type||')');
2758: --case the object type
2759: CASE b_objects(l_object_id).object_type
2760: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT THEN
2761: l_segment := b_dml_update_segments(l_object_id);
2762:
2763: --get the table_objects_def reference to update
2764: l_table_objects_def := GET_TABLE_OBJECTS_DEF(l_table_bound_map,

Line 2798: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT THEN

2794: END IF;
2795:
2796: --set the table_objects_def back
2797: l_table_bound_map(l_segment.table_owner)(l_segment.table_name) := l_table_objects_def;
2798: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT THEN
2799: l_delete_stmt := b_dml_delete_stmts(l_object_id);
2800:
2801: --get the table_objects_def reference to update
2802: l_table_objects_def := GET_TABLE_OBJECTS_DEF(l_table_bound_map,

Line 2823: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT THEN

2819: END IF;
2820:
2821: --set the table_objects_def back
2822: l_table_bound_map(l_delete_stmt.table_owner)(l_delete_stmt.table_name) := l_table_objects_def;
2823: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT THEN
2824: l_truncate_stmt := b_dml_truncate_stmts(l_object_id);
2825:
2826: --if the run mode isn't normal, truncates need to become deletes so they can be rolled back
2827: IF b_run.run_mode <> FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL THEN

Line 2877: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT THEN

2873: l_truncate_table_owner_map(l_truncate_stmt.table_owner) := l_truncate_table_name_map;
2874: END IF;
2875:
2876: END IF;
2877: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_PLSQL_TEXT THEN
2878: l_plsql := b_plsql_texts(l_object_id);
2879:
2880: --see if we've got a table owner and name, meaning the pl/sql is table bound
2881: IF l_plsql.table_owner IS NOT NULL and l_plsql.table_name IS NOT NULL THEN