DBA Data[Home] [Help]

APPS.CSP_PP_UTIL dependencies on DUAL

Line 36: SELECT Sysdate INTO l_today FROM dual;

32: IF p_mtlt_tbl_size IS NULL OR p_mtlt_tbl_size < 1 THEN
33: RETURN;
34: END IF;
35: --
36: SELECT Sysdate INTO l_today FROM dual;
37: l_user_id := fnd_global.user_id;
38: l_login_id := fnd_global.login_id;
39: FOR l_counter IN 1..p_mtlt_tbl_size LOOP
40: INSERT INTO mtl_transaction_lots_temp

Line 123: SELECT Sysdate INTO l_today FROM dual;

119: IF p_msnt_tbl_size IS NULL OR p_msnt_tbl_size < 1 THEN
120: RETURN;
121: END IF;
122: --
123: SELECT Sysdate INTO l_today FROM dual;
124: l_user_id := fnd_global.user_id;
125: l_login_id := fnd_global.login_id;
126: FOR l_counter IN 1..p_msnt_tbl_size LOOP
127: INSERT INTO mtl_serial_numbers_temp