118: AND object_type in (G_OTYPE_DML_UPDATE_SEGMENT,
119: G_OTYPE_DML_DELETE_STMT,
120: G_OTYPE_DML_TRUNCATE_STMT,
121: G_OTYPE_PLSQL_TEXT)) o,
122: fnd_oam_dscfg_properties p1,
123: fnd_oam_dscfg_properties p2
124: WHERE p1.parent_type = G_TYPE_OBJECT
125: AND p1.parent_id = o.object_id
126: AND p1.property_name = G_PROP_TABLE_OWNER
119: G_OTYPE_DML_DELETE_STMT,
120: G_OTYPE_DML_TRUNCATE_STMT,
121: G_OTYPE_PLSQL_TEXT)) o,
122: fnd_oam_dscfg_properties p1,
123: fnd_oam_dscfg_properties p2
124: WHERE p1.parent_type = G_TYPE_OBJECT
125: AND p1.parent_id = o.object_id
126: AND p1.property_name = G_PROP_TABLE_OWNER
127: AND p2.parent_type = G_TYPE_OBJECT
166: x_object_id => l_object_id);
167:
168: --now create properties for the arguments
169: --table owner
170: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
171: p_parent_id => l_object_id,
172: p_property_name => G_PROP_TABLE_OWNER,
173: p_varchar2_value => p_table_owner,
174: x_property_id => l_prop_id);
172: p_property_name => G_PROP_TABLE_OWNER,
173: p_varchar2_value => p_table_owner,
174: x_property_id => l_prop_id);
175: --table name
176: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
177: p_parent_id => l_object_id,
178: p_property_name => G_PROP_TABLE_NAME,
179: p_varchar2_value => p_table_name,
180: x_property_id => l_prop_id);
178: p_property_name => G_PROP_TABLE_NAME,
179: p_varchar2_value => p_table_name,
180: x_property_id => l_prop_id);
181: --column name
182: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
183: p_parent_id => l_object_id,
184: p_property_name => G_PROP_COLUMN_NAME,
185: p_varchar2_value => p_column_name,
186: x_property_id => l_prop_id);
184: p_property_name => G_PROP_COLUMN_NAME,
185: p_varchar2_value => p_column_name,
186: x_property_id => l_prop_id);
187: --new column value
188: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
189: p_parent_id => l_object_id,
190: p_property_name => G_PROP_NEW_COLUMN_VALUE,
191: p_varchar2_value => p_new_column_value,
192: x_property_id => l_prop_id);
191: p_varchar2_value => p_new_column_value,
192: x_property_id => l_prop_id);
193: --where clause, only if non-null
194: IF p_where_clause IS NOT NULL THEN
195: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
196: p_parent_id => l_object_id,
197: p_property_name => G_PROP_WHERE_CLAUSE,
198: p_varchar2_value => p_where_clause,
199: x_property_id => l_prop_id);
200: END IF;
201:
202: --weight_modifier, only if non-null
203: IF p_weight_modifier IS NOT NULL THEN
204: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
205: p_parent_id => l_object_id,
206: p_property_name => G_PROP_WEIGHT_MODIFIER,
207: p_varchar2_value => p_weight_modifier,
208: x_property_id => l_prop_id);
247: fnd_oam_debug.log(1, l_ctxt, 'Object Created: '||l_object_id);
248:
249: --now create properties for the arguments
250: --table owner
251: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
252: p_parent_id => l_object_id,
253: p_property_name => G_PROP_TABLE_OWNER,
254: p_varchar2_value => p_table_owner,
255: x_property_id => l_prop_id);
253: p_property_name => G_PROP_TABLE_OWNER,
254: p_varchar2_value => p_table_owner,
255: x_property_id => l_prop_id);
256: --table name
257: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
258: p_parent_id => l_object_id,
259: p_property_name => G_PROP_TABLE_NAME,
260: p_varchar2_value => p_table_name,
261: x_property_id => l_prop_id);
260: p_varchar2_value => p_table_name,
261: x_property_id => l_prop_id);
262: --where clause, only if non-null
263: IF p_where_clause IS NOT NULL THEN
264: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
265: p_parent_id => l_object_id,
266: p_property_name => G_PROP_WHERE_CLAUSE,
267: p_varchar2_value => p_where_clause,
268: x_property_id => l_prop_id);
268: x_property_id => l_prop_id);
269: END IF;
270:
271: IF p_weight IS NOT NULL THEN
272: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
273: p_parent_id => l_object_id,
274: p_property_name => G_PROP_WEIGHT,
275: p_number_value => p_weight,
276: x_property_id => l_prop_id);
313: x_object_id => l_object_id);
314:
315: --now create properties for the arguments
316: --table owner
317: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
318: p_parent_id => l_object_id,
319: p_property_name => G_PROP_TABLE_OWNER,
320: p_varchar2_value => p_table_owner,
321: x_property_id => l_prop_id);
319: p_property_name => G_PROP_TABLE_OWNER,
320: p_varchar2_value => p_table_owner,
321: x_property_id => l_prop_id);
322: --table name
323: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
324: p_parent_id => l_object_id,
325: p_property_name => G_PROP_TABLE_NAME,
326: p_varchar2_value => p_table_name,
327: x_property_id => l_prop_id);
326: p_varchar2_value => p_table_name,
327: x_property_id => l_prop_id);
328:
329: IF p_weight IS NOT NULL THEN
330: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
331: p_parent_id => l_object_id,
332: p_property_name => G_PROP_WEIGHT,
333: p_number_value => p_weight,
334: x_property_id => l_prop_id);
375: x_object_id => l_object_id);
376:
377: --now create properties for the arguments
378: --plsql_text
379: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
380: p_parent_id => l_object_id,
381: p_property_name => G_PROP_PLSQL_TEXT,
382: p_varchar2_value => p_plsql_text,
383: x_property_id => l_prop_id);
383: x_property_id => l_prop_id);
384:
385: -- optional table_owner for table-bound pl/sqls
386: IF p_table_owner IS NOT NULL THEN
387: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
388: p_parent_id => l_object_id,
389: p_property_name => G_PROP_TABLE_OWNER,
390: p_varchar2_value => p_table_owner,
391: x_property_id => l_prop_id);
392: END IF;
393:
394: -- optional table_name for table-bound pl/sqls
395: IF p_table_name IS NOT NULL THEN
396: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
397: p_parent_id => l_object_id,
398: p_property_name => G_PROP_TABLE_NAME,
399: p_varchar2_value => p_table_name,
400: x_property_id => l_prop_id);
401: END IF;
402:
403: -- optional primary_domain
404: IF p_primary_domain IS NOT NULL THEN
405: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
406: p_parent_id => l_object_id,
407: p_property_name => G_PROP_PRIMARY_DOMAIN,
408: p_varchar2_value => p_primary_domain,
409: x_property_id => l_prop_id);
409: x_property_id => l_prop_id);
410: END IF;
411:
412: IF p_weight IS NOT NULL THEN
413: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
414: p_parent_id => l_object_id,
415: p_property_name => G_PROP_WEIGHT,
416: p_number_value => p_weight,
417: x_property_id => l_prop_id);
454:
455: --now create properties for the arguments
456:
457: IF p_run_mode IS NOT NULL THEN
458: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
459: p_parent_id => l_object_id,
460: p_property_name => G_PROP_RUN_MODE,
461: p_varchar2_value => p_run_mode,
462: x_property_id => l_prop_id);
462: x_property_id => l_prop_id);
463: END IF;
464:
465: IF p_valid_check_interval IS NOT NULL THEN
466: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
467: p_parent_id => l_object_id,
468: p_property_name => G_PROP_VALID_CHECK_INTERVAL,
469: p_number_value => p_valid_check_interval,
470: x_property_id => l_prop_id);
470: x_property_id => l_prop_id);
471: END IF;
472:
473: IF p_num_bundles IS NOT NULL THEN
474: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
475: p_parent_id => l_object_id,
476: p_property_name => G_PROP_NUM_BUNDLES,
477: p_number_value => p_num_bundles,
478: x_property_id => l_prop_id);
478: x_property_id => l_prop_id);
479: END IF;
480:
481: IF p_weight IS NOT NULL THEN
482: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
483: p_parent_id => l_object_id,
484: p_property_name => G_PROP_WEIGHT,
485: p_number_value => p_weight,
486: x_property_id => l_prop_id);
524:
525: --now create properties for the arguments
526:
527: IF p_target_hostname IS NOT NULL THEN
528: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
529: p_parent_id => l_object_id,
530: p_property_name => G_PROP_TARGET_HOSTNAME,
531: p_varchar2_value => p_target_hostname,
532: x_property_id => l_prop_id);
532: x_property_id => l_prop_id);
533: END IF;
534:
535: IF p_workers_allowed IS NOT NULL THEN
536: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
537: p_parent_id => l_object_id,
538: p_property_name => G_PROP_WORKERS_ALLOWED,
539: p_number_value => p_workers_allowed,
540: x_property_id => l_prop_id);
540: x_property_id => l_prop_id);
541: END IF;
542:
543: IF p_batch_size IS NOT NULL THEN
544: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
545: p_parent_id => l_object_id,
546: p_property_name => G_PROP_BATCH_SIZE,
547: p_number_value => p_batch_size,
548: x_property_id => l_prop_id);
548: x_property_id => l_prop_id);
549: END IF;
550:
551: IF p_min_parallel_unit_weight IS NOT NULL THEN
552: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
553: p_parent_id => l_object_id,
554: p_property_name => G_PROP_MIN_PARALLEL_WEIGHT,
555: p_number_value => p_min_parallel_unit_weight,
556: x_property_id => l_prop_id);
556: x_property_id => l_prop_id);
557: END IF;
558:
559: IF p_weight IS NOT NULL THEN
560: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
561: p_parent_id => l_object_id,
562: p_property_name => G_PROP_WEIGHT,
563: p_number_value => p_weight,
564: x_property_id => l_prop_id);
712: p_canonical_value IN VARCHAR2,
713: x_property_id OUT NOCOPY NUMBER)
714: IS
715: BEGIN
716: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => p_parent_type,
717: p_parent_id => p_parent_id,
718: p_property_name => p_property_name,
719: p_datatype => p_datatype,
720: p_canonical_value => p_canonical_value,
727: p_varchar2_value IN VARCHAR2,
728: x_property_id OUT NOCOPY NUMBER)
729: IS
730: BEGIN
731: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
732: p_parent_id => p_object_id,
733: p_property_name => p_property_name,
734: p_varchar2_value => p_varchar2_value,
735: x_property_id => x_property_id);
741: p_number_value IN NUMBER,
742: x_property_id OUT NOCOPY NUMBER)
743: IS
744: BEGIN
745: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
746: p_parent_id => p_object_id,
747: p_property_name => p_property_name,
748: p_number_value => p_number_value,
749: x_property_id => x_property_id);
755: p_date_value IN DATE,
756: x_property_id OUT NOCOPY NUMBER)
757: IS
758: BEGIN
759: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
760: p_parent_id => p_object_id,
761: p_property_name => p_property_name,
762: p_date_value => p_date_value,
763: x_property_id => x_property_id);
769: p_property_name IN VARCHAR2,
770: x_canonical_value OUT NOCOPY VARCHAR2)
771: IS
772: BEGIN
773: FND_OAM_DSCFG_PROPERTIES_PKG.GET_PROPERTY_CANONICAL_VALUE(p_parent_type => p_parent_type,
774: p_parent_id => p_parent_id,
775: p_property_name => p_property_name,
776: x_canonical_value => x_canonical_value);
777: END;
781: p_property_name IN VARCHAR2,
782: x_varchar2_value OUT NOCOPY VARCHAR2)
783: IS
784: BEGIN
785: FND_OAM_DSCFG_PROPERTIES_PKG.GET_PROPERTY_VALUE(p_parent_type => G_TYPE_OBJECT,
786: p_parent_id => p_object_id,
787: p_property_name => p_property_name,
788: x_varchar2_value => x_varchar2_value);
789: END;
793: p_property_name IN VARCHAR2,
794: x_number_value OUT NOCOPY NUMBER)
795: IS
796: BEGIN
797: FND_OAM_DSCFG_PROPERTIES_PKG.GET_PROPERTY_VALUE(p_parent_type => G_TYPE_OBJECT,
798: p_parent_id => p_object_id,
799: p_property_name => p_property_name,
800: x_number_value => x_number_value);
801: END;
805: p_property_name IN VARCHAR2,
806: x_date_value OUT NOCOPY DATE)
807: IS
808: BEGIN
809: FND_OAM_DSCFG_PROPERTIES_PKG.GET_PROPERTY_VALUE(p_parent_type => G_TYPE_OBJECT,
810: p_parent_id => p_object_id,
811: p_property_name => p_property_name,
812: x_date_value => x_date_value);
813: END;
820: p_canonical_value IN VARCHAR2,
821: x_property_id OUT NOCOPY NUMBER)
822: IS
823: BEGIN
824: FND_OAM_DSCFG_PROPERTIES_PKG.SET_OR_ADD_PROPERTY(p_parent_type => p_parent_type,
825: p_parent_id => p_parent_id,
826: p_property_name => p_property_name,
827: p_datatype => p_datatype,
828: p_canonical_value => p_canonical_value,
836: p_varchar2_value IN VARCHAR2,
837: x_property_id OUT NOCOPY NUMBER)
838: IS
839: BEGIN
840: FND_OAM_DSCFG_PROPERTIES_PKG.SET_OR_ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
841: p_parent_id => p_object_id,
842: p_property_name => p_property_name,
843: p_varchar2_value => p_varchar2_value,
844: x_property_id => x_property_id);
851: p_number_value IN NUMBER,
852: x_property_id OUT NOCOPY NUMBER)
853: IS
854: BEGIN
855: FND_OAM_DSCFG_PROPERTIES_PKG.SET_OR_ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
856: p_parent_id => p_object_id,
857: p_property_name => p_property_name,
858: p_number_value => p_number_value,
859: x_property_id => x_property_id);
866: p_date_value IN DATE,
867: x_property_id OUT NOCOPY NUMBER)
868: IS
869: BEGIN
870: FND_OAM_DSCFG_PROPERTIES_PKG.SET_OR_ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,
871: p_parent_id => p_object_id,
872: p_property_name => p_property_name,
873: p_date_value => p_date_value,
874: x_property_id => x_property_id);