APPS.INV_PR_PICK_SLIP_NUMBER dependencies on MTL_PICK_SLIP_NUMBERS

Line 1061: -- x_hash_string => Hash string to insert into mtl_pick_slip_numbers

1057: -- p_task_id => Task Id
1058:
1059: --
1060: -- Output Parameter
1061: -- x_hash_string => Hash string to insert into mtl_pick_slip_numbers
1062: -- x_error_message => Error message
1063: --
1064:
1065: PROCEDURE create_pick_slip_string(

Line 1174: -- update the table record for count. Table: MTL_PICK_SLIP_NUMBERS

1170: -- PROCEDURE GEN_PARALLEL_PICK_SLIP_NUMBER
1171: --
1172: -- Purpose
1173: -- Insert a new row with the new pick_slip_number generated or
1174: -- update the table record for count. Table: MTL_PICK_SLIP_NUMBERS
1175: -- This procedure is used by Shipping GET_PICK_SLIP_NUMBER_PARALLEL Procedure.
1176: --
1177:
1178: PROCEDURE gen_parallel_pick_slip_number

Line 1222: -- in MTL_PICK_SLIP_NUMBERS

1218: l_pick_slip_count := 0;
1219: l_pick_slip_number := NULL;
1220:
1221: -- Make "l_max_attempts" iterations to either INSERT or lock a record
1222: -- in MTL_PICK_SLIP_NUMBERS
1223: WHILE (l_num_attempts <= l_max_attempts AND (NOT l_success))
1224: LOOP
1225: -- {
1226: -- begin

Line 1244: INSERT INTO mtl_pick_slip_numbers

1240: inv_log_util.trace('l_num_attempts = ' || l_num_attempts,
1241: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);
1242: END IF;
1243: BEGIN
1244: INSERT INTO mtl_pick_slip_numbers
1245: ( id
1246: , pick_slip_batch_id
1247: , pick_slip_count
1248: , pick_slip_identifier

Line 1251: ) VALUES ( mtl_pick_slip_numbers_s.nextval

1247: , pick_slip_count
1248: , pick_slip_identifier
1249: , pick_slip_number
1250: , status
1251: ) VALUES ( mtl_pick_slip_numbers_s.nextval
1252: , l_batch_id
1253: , l_pick_slip_count
1254: , p_hash_string
1255: , wsh_pick_slip_numbers_s.nextval

Line 1278: FROM mtl_pick_slip_numbers

1274: SELECT pick_slip_number
1275: , pick_slip_count
1276: INTO l_pick_slip_number
1277: , l_pick_slip_count
1278: FROM mtl_pick_slip_numbers
1279: WHERE pick_slip_identifier = p_hash_string
1280: AND status = 1
1281: FOR UPDATE WAIT 5;
1282:

Line 1338: UPDATE mtl_pick_slip_numbers

1334: ELSE
1335: IF (l_pick_slip_count + 1) >= p_limit THEN
1336: l_pick_slip_status := 2;
1337: END IF;
1338: UPDATE mtl_pick_slip_numbers
1339: SET pick_slip_count = pick_slip_count + 1
1340: , status = l_pick_slip_status
1341: WHERE pick_slip_identifier = p_hash_string
1342: AND status = 1