[Home] [Help]
1287: END IF;
1288: ELSE
1289: -- if serial number is not null and ref text is null then
1290: -- simply add the serial number with short mesg prefix and without a semi colon
1291: -- 240 is the length of the reference column in the wip_transactions table
1292: IF p_x_prd_resrc_txn_tbl(i).REFERENCE IS NOT NULL THEN
1293: l_str_len := 240 - (length(p_x_prd_resrc_txn_tbl(i).serial_number) + length(l_short_mesg) + 2);
1294: l_ahl_res_txn_tbl(l_ctr).reference := substr(p_x_prd_resrc_txn_tbl(i).REFERENCE, 1, l_str_len) || '; ' || l_short_mesg || p_x_prd_resrc_txn_tbl(i).serial_number;
1295: ELSE
1895: c_employee_id NUMBER )
1896: IS
1897:
1898: SELECT NVL( SUM( transaction_quantity ), 0 )
1899: FROM WIP_TRANSACTIONS
1900: WHERE wip_entity_id = c_wip_entity_id
1901: AND operation_seq_num = c_operation_seq_num
1902: AND resource_seq_num = c_resource_seq_num
1903: AND employee_id = c_employee_id;