DBA Data[Home] [Help]

APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_RULES_PKG

Line 875: AHL_MC_RULES_PKG.INSERT_ROW (

871: p_rule_stmt_tbl=> p_rule_stmt_tbl,
872: x_rule_stmt_tbl=> l_rule_stmt_tbl);
873:
874: --Insert the Rule Record
875: AHL_MC_RULES_PKG.INSERT_ROW (
876: X_ROWID => l_row_id,
877: X_RULE_ID => p_x_rule_rec.rule_id,
878: X_OBJECT_VERSION_NUMBER => 1,
879: X_RULE_NAME => p_x_rule_rec.rule_name,

Line 1257: AHL_MC_RULES_PKG.UPDATE_ROW (

1253: p_rule_stmt_tbl=> p_rule_stmt_tbl,
1254: x_rule_stmt_tbl=> l_rule_stmt_tbl);
1255:
1256: --Update the Rule Record
1257: AHL_MC_RULES_PKG.UPDATE_ROW (
1258: X_RULE_ID => l_rule_rec.rule_id,
1259: X_OBJECT_VERSION_NUMBER => l_rule_rec.object_version_number +1,
1260: X_MC_HEADER_ID => l_rule_rec.mc_header_id,
1261: X_RULE_NAME => l_rule_rec.rule_name,

Line 1486: AHL_MC_RULES_PKG.DELETE_ROW ( X_RULE_ID => p_rule_rec.rule_id);

1482: RAISE FND_API.G_EXC_ERROR;
1483: END IF;
1484:
1485: --Delete the row record
1486: AHL_MC_RULES_PKG.DELETE_ROW ( X_RULE_ID => p_rule_rec.rule_id);
1487:
1488:
1489: --Update the status to Draft if approval rejected
1490: IF (l_status_code = 'APPROVAL_REJECTED')

Line 1606: AHL_MC_RULES_PKG.INSERT_ROW (

1602: INTO l_new_rule_id
1603: FROM dual;
1604:
1605: --Copy the Rule Record
1606: AHL_MC_RULES_PKG.INSERT_ROW (
1607: X_ROWID => l_row_id,
1608: X_RULE_ID => l_new_rule_id,
1609: X_OBJECT_VERSION_NUMBER => 1,
1610: X_RULE_NAME => l_rule_rec.rule_name,