1 FUNCTION Get_Invalid_CP_Count
2 ( P_PHONE_NUMBER_S1 IN VARCHAR2
3 , P_REASON_CODE_S1 IN VARCHAR2
4 , P_PHONE_NUMBER_S2 IN VARCHAR2
5 , P_REASON_CODE_S2 IN VARCHAR2
6 , P_PHONE_NUMBER_S3 IN VARCHAR2
7 , P_REASON_CODE_S3 IN VARCHAR2
8 , P_PHONE_NUMBER_S4 IN VARCHAR2
9 , P_REASON_CODE_S4 IN VARCHAR2
10 , P_PHONE_NUMBER_S5 IN VARCHAR2
11 , P_REASON_CODE_S5 IN VARCHAR2
12 , P_PHONE_NUMBER_S6 IN VARCHAR2
13 , P_REASON_CODE_S6 IN VARCHAR2
14 )
15 RETURN NUMBER
16 IS
17 l_num_invalid_cps NUMBER(5);
18 BEGIN
19
20 l_num_invalid_cps := 0;
21
22 IF (P_PHONE_NUMBER_S1 IS NOT NULL AND P_REASON_CODE_S1 IS NULL) THEN
23 l_num_invalid_cps := l_num_invalid_cps + 1;
24 END IF;
25
26 IF (P_PHONE_NUMBER_S2 IS NOT NULL AND P_REASON_CODE_S2 IS NULL) THEN
27 l_num_invalid_cps := l_num_invalid_cps + 1;
28 END IF;
29
30 IF (P_PHONE_NUMBER_S3 IS NOT NULL AND P_REASON_CODE_S3 IS NULL) THEN
31 l_num_invalid_cps := l_num_invalid_cps + 1;
32 END IF;
33
34 IF (P_PHONE_NUMBER_S4 IS NOT NULL AND P_REASON_CODE_S4 IS NULL) THEN
35 l_num_invalid_cps := l_num_invalid_cps + 1;
36 END IF;
37
38 IF (P_PHONE_NUMBER_S5 IS NOT NULL AND P_REASON_CODE_S5 IS NULL) THEN
39 l_num_invalid_cps := l_num_invalid_cps + 1;
40 END IF;
41
42 IF (P_PHONE_NUMBER_S6 IS NOT NULL AND P_REASON_CODE_S6 IS NULL) THEN
43 l_num_invalid_cps := l_num_invalid_cps + 1;
44 END IF;
45
46 RETURN l_num_invalid_cps;
47
48 END Get_Invalid_CP_Count;