[Home] [Help]
2639: l_loginid := fnd_global.login_id;
2640: l_sys_date := SYSDATE;
2641:
2642: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
2643: INSERT INTO mtl_unit_transactions
2644: (
2645: transaction_id
2646: , last_update_date
2647: , last_updated_by
2848:
2849: IF (p_transaction_temp_id > 0) THEN
2850: --Bug 2067223 paranthesis are added in the where clause
2851: -- of the select statement
2852: INSERT INTO mtl_unit_transactions
2853: (
2854: transaction_id
2855: , last_update_date
2856: , last_updated_by
3038: WHERE transaction_temp_id = p_transaction_temp_id
3039: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
3040: /* Bug 3622025 -- Added the LPAD function in the above where clause */
3041: ELSE
3042: INSERT INTO mtl_unit_transactions
3043: (
3044: transaction_id
3045: , last_update_date
3046: , last_updated_by
5468: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
5469: IF (l_debug = 1) THEN
5470: invtrace('p_transaction_action_id = 3 and g_firstscan is false');
5471: END IF;
5472: INSERT INTO mtl_unit_transactions
5473: (
5474: transaction_id
5475: , last_update_date
5476: , last_updated_by
5709: invtrace('from serial =. ' || p_fm_serial_number);
5710: invtrace('to serial =. ' || p_to_serial_number);
5711: END IF;
5712:
5713: INSERT INTO mtl_unit_transactions
5714: (
5715: transaction_id
5716: , last_update_date
5717: , last_updated_by
5915: invtrace('from serial =. ' || p_fm_serial_number);
5916: invtrace('to serial =. ' || p_to_serial_number);
5917: END IF;
5918:
5919: INSERT INTO mtl_unit_transactions
5920: (
5921: transaction_id
5922: , last_update_date
5923: , last_updated_by
6115: IF (l_debug = 1) THEN
6116: invtrace('no transaction temp id');
6117: END IF;
6118:
6119: INSERT INTO mtl_unit_transactions
6120: (
6121: transaction_id
6122: , last_update_date
6123: , last_updated_by