APPS.CSP_PICK_UTILS dependencies on CSP_PP_UTIL

Line 887: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;

883: SELECT transaction_temp_id, fm_serial_number, to_serial_number
884: FROM mtl_serial_numbers_temp
885: WHERE transaction_temp_id = l_temp_id_ref;
886: */
887: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;
888: l_tbl_index NUMBER := 1;
889: l_fm_prefix VARCHAR2(30);
890: l_to_prefix VARCHAR2(30);
891: l_fm_number VARCHAR2(30);

Line 911: csp_pp_util.split_prefix_num (

907: FETCH l_Get_Serial_Numbers_Csr Into l_msnt_tbl(l_tbl_index);
908: EXIT WHEN l_Get_Serial_Numbers_Csr%NOTFOUND;
909:
910: -- Analyze the serial number range
911: csp_pp_util.split_prefix_num (
912: p_serial_number => l_msnt_tbl(l_tbl_index).fm_serial_number
913: ,p_prefix => l_fm_prefix
914: ,x_num => l_fm_number
915: );

Line 917: csp_pp_util.split_prefix_num (

913: ,p_prefix => l_fm_prefix
914: ,x_num => l_fm_number
915: );
916:
917: csp_pp_util.split_prefix_num (
918: p_serial_number => l_msnt_tbl(l_tbl_index).to_serial_number
919: ,p_prefix => l_to_prefix
920: ,x_num => l_to_number
921: );

Line 1009: csp_pp_util.insert_msnt(

1005: l_msnt_tbl(l_tbl_index).serial_prefix := 1;
1006: l_msnt_tbl(l_tbl_index).creation_date := sysdate;
1007: l_msnt_tbl(l_tbl_index).last_update_date := sysdate;
1008:
1009: csp_pp_util.insert_msnt(
1010: x_return_status => l_return_status
1011: ,p_msnt_tbl => l_msnt_tbl
1012: ,p_msnt_tbl_size => 1
1013: );