DBA Data[Home] [Help]

APPS.WMS_RULE_FORM_PKG dependencies on WMS_RULE_CONSISTENCIES

Line 919: FROM wms_rule_consistencies

915: ,attribute12
916: ,attribute13
917: ,attribute14
918: ,attribute15
919: FROM wms_rule_consistencies
920: WHERE rule_id = p_orig_rule_id;
921:
922: l_consistency_rec l_orig_consistency_cur%ROWTYPE;
923:

Line 1124: SELECT wms_rule_consistencies_s.NEXTVAL INTO l_consistency_id FROM dual;

1120: FETCH l_orig_consistency_cur INTO l_consistency_rec;
1121: EXIT WHEN l_orig_consistency_cur%NOTFOUND;
1122:
1123: l_consistency_rec.rule_id := l_rule_id;
1124: SELECT wms_rule_consistencies_s.NEXTVAL INTO l_consistency_id FROM dual;
1125: wms_rule_consistencies_pkg.insert_row
1126: (
1127: x_rowid => l_rowid
1128: ,x_consistency_id => l_consistency_id

Line 1125: wms_rule_consistencies_pkg.insert_row

1121: EXIT WHEN l_orig_consistency_cur%NOTFOUND;
1122:
1123: l_consistency_rec.rule_id := l_rule_id;
1124: SELECT wms_rule_consistencies_s.NEXTVAL INTO l_consistency_id FROM dual;
1125: wms_rule_consistencies_pkg.insert_row
1126: (
1127: x_rowid => l_rowid
1128: ,x_consistency_id => l_consistency_id
1129: ,x_rule_id => l_consistency_rec.rule_id