71: RAISE fnd_api.g_exc_error;
72: END IF;
73:
74:
75: FUN_RULE_DETAILS_PKG.Insert_Row (
76: X_ROWID =>l_rowid,
77: X_RULE_DETAIL_ID =>p_rule_detail_rec.rule_detail_id,
78: X_RULE_OBJECT_ID =>p_rule_detail_rec.rule_object_id,
79: X_RULE_NAME =>p_rule_detail_rec.rule_name,
172: END IF;
173:
174: -- call to table-handler.
175:
176: FUN_RULE_DETAILS_PKG.Update_Row (
177: X_RULE_DETAIL_ID =>p_rule_detail_rec.rule_detail_id,
178: X_RULE_OBJECT_ID =>p_rule_detail_rec.rule_object_id,
179: X_RULE_NAME =>p_rule_detail_rec.rule_name,
180: X_SEQ =>p_rule_detail_rec.seq,
412: * DESCRIPTION
413: * Gets user defined Rules record.
414: *
415: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
416: * FUN_rule_details_PKG.Select_Row
417: *
418: * ARGUMENTS
419: * IN:
420: * p_init_msg_list Initialize message stack if it is set to
473:
474: x_rule_detail_rec.rule_detail_id := p_rule_detail_id;
475: x_rule_detail_rec.rule_object_id := p_rule_object_id;
476:
477: FUN_RULE_DETAILS_PKG.Select_Row (
478: X_RULE_NAME =>x_rule_detail_rec.rule_name,
479: X_RULE_DETAIL_ID =>x_rule_detail_rec.rule_detail_id,
480: X_RULE_OBJECT_ID =>x_rule_detail_rec.rule_object_id,
481: X_SEQ =>x_rule_detail_rec.seq,
585: WHERE rule_object_id = p_rule_object_id
586: AND rule_name = p_rule_name;
587:
588: -- call to table-handler.
589: FUN_RULE_DETAILS_PKG.Delete_Row (
590: X_RULE_DETAIL_ID => l_rule_detail_id
591: );
592:
593: