[Home] [Help]
2308: l_loginid := fnd_global.login_id;
2309: l_sys_date := SYSDATE;
2310:
2311: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
2312: INSERT INTO mtl_unit_transactions
2313: (
2314: transaction_id
2315: , last_update_date
2316: , last_updated_by
2517:
2518: IF (p_transaction_temp_id > 0) THEN
2519: --Bug 2067223 paranthesis are added in the where clause
2520: -- of the select statement
2521: INSERT INTO mtl_unit_transactions
2522: (
2523: transaction_id
2524: , last_update_date
2525: , last_updated_by
2707: WHERE transaction_temp_id = p_transaction_temp_id
2708: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
2709: /* Bug 3622025 -- Added the LPAD function in the above where clause */
2710: ELSE
2711: INSERT INTO mtl_unit_transactions
2712: (
2713: transaction_id
2714: , last_update_date
2715: , last_updated_by
5081: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
5082: IF (l_debug = 1) THEN
5083: invtrace('p_transaction_action_id = 3 and g_firstscan is false');
5084: END IF;
5085: INSERT INTO mtl_unit_transactions
5086: (
5087: transaction_id
5088: , last_update_date
5089: , last_updated_by
5322: invtrace('from serial =. ' || p_fm_serial_number);
5323: invtrace('to serial =. ' || p_to_serial_number);
5324: END IF;
5325:
5326: INSERT INTO mtl_unit_transactions
5327: (
5328: transaction_id
5329: , last_update_date
5330: , last_updated_by
5528: invtrace('from serial =. ' || p_fm_serial_number);
5529: invtrace('to serial =. ' || p_to_serial_number);
5530: END IF;
5531:
5532: INSERT INTO mtl_unit_transactions
5533: (
5534: transaction_id
5535: , last_update_date
5536: , last_updated_by
5728: IF (l_debug = 1) THEN
5729: invtrace('no transaction temp id');
5730: END IF;
5731:
5732: INSERT INTO mtl_unit_transactions
5733: (
5734: transaction_id
5735: , last_update_date
5736: , last_updated_by