PACKAGE BODY: APPS.JE_PT_CERTIFICATES_PKG

Source

1 PACKAGE BODY je_pt_certificates_pkg AS
2 /* $Header: jeptlctb.pls 120.1 2011/10/03 09:27:42 rahulkum noship $ */
3 
4    PROCEDURE load_row (
5       p_apps_version                     IN   VARCHAR2,
6       p_key_version                      IN   NUMBER,
7       p_private_key                      IN   VARCHAR,
8       p_certification_app_date   IN   DATE,
9       p_certification_issue_date         IN   DATE,
10       p_certification_number             IN   VARCHAR2,
11       p_created_by                       IN   NUMBER,
12       p_creation_date                    IN   DATE,
13       p_last_updated_by                  IN   NUMBER,
14       p_last_update_date                 IN   DATE,
15       p_last_update_login                IN   NUMBER
16    )
17    IS
18    l_count NUMBER;
19    BEGIN
20 
21    SELECT count(1)
22    INTO l_count
23    FROM JE_PT_CERTIFICATES
24    WHERE apps_version = p_apps_version
25    AND   key_version = p_key_version;
26 
27    IF l_count = 0 THEN
28 
29 	   INSERT INTO JE_PT_CERTIFICATES
30 			( APPS_VERSION
31 			,KEY_VERSION
32 			,PRIVATE_KEY
33 			,CERTIFICATION_APPLICATION_DATE
34 			,CERTIFICATION_ISSUE_DATE
35 			,CERTIFICATION_NUMBER
36 			,CREATED_BY
37 			,CREATION_DATE
38 			,LAST_UPDATED_BY
39 			,LAST_UPDATE_DATE
40 			,LAST_UPDATE_LOGIN
41 			) VALUES
42 				(  P_APPS_VERSION
43 				, P_KEY_VERSION
44 				, P_PRIVATE_KEY
45 				, P_CERTIFICATION_APP_DATE
46 				, P_CERTIFICATION_ISSUE_DATE
47 				, P_CERTIFICATION_NUMBER
48 				, P_CREATED_BY
49 				, P_CREATION_DATE
50 				, P_LAST_UPDATED_BY
51 				, P_LAST_UPDATE_DATE
52 				, P_LAST_UPDATE_LOGIN
53 				);
54    END IF;
55    END load_row;
56 END je_pt_certificates_pkg;
57