[Home] [Help]
346: END IF;
347:
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349:
350: SELECT Sysdate INTO l_today FROM dual;
351: l_user_id := fnd_global.user_id;
352: l_login_id := fnd_global.login_id;
353:
354: -- If p_move_order_type = 2 or 3 (include replenishment move orders) then
524: l_line_id := mo_line_rec.line_id;
525:
526: SELECT mtl_material_transactions_s.nextval
527: INTO l_txn_header_id
528: FROM dual;
529:
530: -- This code is used for auto detailing serial numbers
531:
532: SELECT serial_number_control_code into l_serial_control
629: l_line_number := 0; -- Initialize the line number
630:
631: SELECT csp_picklist_headers_s1.nextval
632: INTO l_picklist_header_id
633: FROM dual;
634:
635: CSP_PC_FORM_PICKHEADERS.Validate_And_Write (
636: P_Api_Version_Number => 1.0,
637: P_Init_Msg_List => FND_API.G_FALSE,
678: l_line_number := (l_line_number + 1);
679:
680: SELECT csp_picklist_lines_s1.nextval
681: INTO l_picklist_line_id
682: FROM dual;
683:
684: CSP_PC_FORM_PICKLINES.Validate_And_Write (
685: P_Api_Version_Number => 1.0
686: ,P_Init_Msg_List => FND_API.G_FALSE
2364: Function get_rs_cust_sequence return number
2365: IS
2366: l_sequence_number NUMBER;
2367: BEGIN
2368: SELECT CSP_RS_CUST_RELATIONS_s1.nextval into l_sequence_number from dual;
2369: return l_sequence_number;
2370: END get_rs_cust_sequence;
2371:
2372: FUNCTION get_assignment(p_task_id number)
2372: FUNCTION get_assignment(p_task_id number)
2373: return date IS
2374: cursor c_minutes is
2375: SELECT fnd_profile.value('CSF_UOM_MINUTES') minutes
2376: FROM dual;
2377:
2378: cursor c_task_assignment is
2379: select jta.last_update_date,
2380: jta.task_assignment_id,