DBA Data[Home] [Help]

APPS.FND_OAM_DSCFG_API_PKG dependencies on FND_OAM_DSCFG_PROPERTIES_PKG

Line 170: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_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);

Line 176: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 182: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 188: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 195: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 204: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 251: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 257: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 264: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 272: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 317: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 323: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 330: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 379: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 387: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 396: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 405: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 413: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 458: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 466: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 474: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 482: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 528: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 536: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 544: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 552: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 560: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 716: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => p_parent_type,

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,

Line 731: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 745: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 759: FND_OAM_DSCFG_PROPERTIES_PKG.ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 773: FND_OAM_DSCFG_PROPERTIES_PKG.GET_PROPERTY_CANONICAL_VALUE(p_parent_type => p_parent_type,

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;

Line 785: FND_OAM_DSCFG_PROPERTIES_PKG.GET_PROPERTY_VALUE(p_parent_type => G_TYPE_OBJECT,

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;

Line 797: FND_OAM_DSCFG_PROPERTIES_PKG.GET_PROPERTY_VALUE(p_parent_type => G_TYPE_OBJECT,

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;

Line 809: FND_OAM_DSCFG_PROPERTIES_PKG.GET_PROPERTY_VALUE(p_parent_type => G_TYPE_OBJECT,

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;

Line 824: FND_OAM_DSCFG_PROPERTIES_PKG.SET_OR_ADD_PROPERTY(p_parent_type => p_parent_type,

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,

Line 840: FND_OAM_DSCFG_PROPERTIES_PKG.SET_OR_ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 855: FND_OAM_DSCFG_PROPERTIES_PKG.SET_OR_ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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

Line 870: FND_OAM_DSCFG_PROPERTIES_PKG.SET_OR_ADD_PROPERTY(p_parent_type => G_TYPE_OBJECT,

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