APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_PR_HEADER_HOLDS

Line 46: INSERT INTO WSH_PR_HEADER_HOLDS (

42: PRAGMA AUTONOMOUS_TRANSACTION;
43:
44: BEGIN
45:
46: INSERT INTO WSH_PR_HEADER_HOLDS (
47: batch_id,
48: header_id,
49: status )
50: VALUES (

Line 1107: FROM wsh_pr_header_holds

1103: AND source_line_id = p_source_line_id;
1104:
1105: CURSOR get_pr_credit_cache IS
1106: SELECT status
1107: FROM wsh_pr_header_holds
1108: WHERE header_id = p_source_header_id
1109: AND batch_id = WSH_PICK_LIST.G_BATCH_ID;
1110:
1111: l_header_id NUMBER := p_source_header_id;

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

1248: IF g_good_header_ids.EXISTS(l_good_index) THEN
1249: l_skip_header_flag := 'Y';
1250: END IF;
1251:
1252: -- Check if Header exists in WSH_PR_HEADER_HOLDS Table for Pick Release process
1253: IF (l_skip_header_flag = 'N') AND (p_activity_type = 'PICK') AND (WSH_PICK_LIST.G_BATCH_ID IS NOT NULL)
1254: AND (WSH_PICK_LIST.G_PICK_REL_PARALLEL) THEN
1255: OPEN get_pr_credit_cache;
1256: FETCH get_pr_credit_cache INTO l_cache_status;