APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_PR_HEADER_HOLDS

Line 52: INSERT INTO WSH_PR_HEADER_HOLDS (

48: PRAGMA AUTONOMOUS_TRANSACTION;
49:
50: BEGIN
51:
52: INSERT INTO WSH_PR_HEADER_HOLDS (
53: batch_id,
54: header_id,
55: status )
56: VALUES (

Line 1148: FROM wsh_pr_header_holds

1144: AND source_line_id = p_source_line_id;
1145:
1146: CURSOR get_pr_credit_cache IS
1147: SELECT status
1148: FROM wsh_pr_header_holds
1149: WHERE header_id = p_source_header_id
1150: AND batch_id = WSH_PICK_LIST.G_BATCH_ID;
1151:
1152: l_header_id NUMBER := p_source_header_id;

Line 1304: -- Check if Header exists in WSH_PR_HEADER_HOLDS Table for Pick Release process

1300: IF g_good_header_ids.EXISTS(l_good_index) THEN
1301: l_skip_header_flag := 'Y';
1302: END IF;
1303:
1304: -- Check if Header exists in WSH_PR_HEADER_HOLDS Table for Pick Release process
1305: IF (l_skip_header_flag = 'N') AND (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1306: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1307: OPEN get_pr_credit_cache;
1308: FETCH get_pr_credit_cache INTO l_cache_status;