APPS.WMS_RULE_FORM_PKG dependencies on DUAL

Line 195: SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual;

191: if fnd_api.to_boolean( p_init_msg_list ) then
192: fnd_msg_pub.initialize;
193: end if;
194:
195: SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual;
196:
197: validate_input
198: (
199: x_return_status => l_return_status

Line 235: SELECT Sysdate INTO l_date FROM dual;

231: raise fnd_api.g_exc_error;
232: end if;
233:
234: /* get who column information */
235: SELECT Sysdate INTO l_date FROM dual;
236: l_user_id := fnd_global.user_id;
237: l_login_id := fnd_global.login_id;
238:
239: /* call the table handler to do the insert */

Line 543: SELECT Sysdate INTO l_date FROM dual;

539: raise fnd_api.g_exc_error;
540: end if;
541:
542: /* get who column information */
543: SELECT Sysdate INTO l_date FROM dual;
544: l_user_id := fnd_global.user_id;
545: l_login_id := fnd_global.login_id;
546:
547: /* call the table handler to do the update */

Line 1117: SELECT SYSDATE INTO l_date FROM dual;

1113:
1114: -- Part of Bugfix 2279644
1115: /* Copy Rule_consistencies */
1116: -- IF x_copy_consistency_criteria_flag = 'Y' THEN
1117: SELECT SYSDATE INTO l_date FROM dual;
1118: OPEN l_orig_consistency_cur;
1119: WHILE TRUE LOOP
1120: FETCH l_orig_consistency_cur INTO l_consistency_rec;
1121: EXIT WHEN l_orig_consistency_cur%NOTFOUND;

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