PACKAGE: APPS.AP_WEB_MATCHING_RULE_PKG

Source

1 PACKAGE AP_WEB_MATCHING_RULE_PKG AUTHID CURRENT_USER as
2   /* $Header: apwmachs.pls 115.1 2003/10/17 00:11:29 kmizuta noship $ */
3 
4   --
5   -- Given a full name, the following two procedures
6   -- breaks it apart into first/last or first/middle/last.
7   PROCEDURE GET_EMPLOYEE_NAME2(p_employee_name IN VARCHAR2,
8                              p_first_name OUT NOCOPY VARCHAR2,
9                              p_last_name OUT NOCOPY VARCHAR2);
10   PROCEDURE GET_EMPLOYEE_NAME3(p_employee_name IN VARCHAR2,
11                              p_first_name OUT NOCOPY VARCHAR2,
12                              p_middle_name OUT NOCOPY VARCHAR2,
13                              p_last_name OUT NOCOPY VARCHAR2);
14 
15   --
16   -- If the procedures above are not used to build the SQL statement
17   -- and execute the matches, you should call the LOCK_CARD
18   -- just prior to populating AP_CARD_EMP_CANDIDATES and call
19   -- UNLOCK_CARD right after.
20   PROCEDURE LOCK_CARD(p_card_id NUMBER);
21   PROCEDURE UNLOCK_CARD;
22 
23   --
24   -- Execute query
25   PROCEDURE EXECUTE_QUERY(P_CARD_ID IN NUMBER,
26                         P_FIRST_NAME IN VARCHAR2,
27                         P_MIDDLE_NAME IN VARCHAR2,
28                         P_LAST_NAME IN VARCHAR2,
29                         P_NATIONAL_ID IN VARCHAR2,
30                         P_EMPLOYEE_NUM IN VARCHAR2);
31 
32   --
33   -- Default matching rule
34   PROCEDURE GET_EMPLOYEE_MATCHES(p_card_id IN NUMBER);
35 end;