APPS.JE_PT_CERTIFICATES_PKG dependencies on JE_PT_CERTIFICATES

Line 1: PACKAGE BODY je_pt_certificates_pkg AS

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,

Line 23: FROM JE_PT_CERTIFICATES

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

Line 29: INSERT INTO JE_PT_CERTIFICATES

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

Line 56: END je_pt_certificates_pkg;

52: , P_LAST_UPDATE_LOGIN
53: );
54: END IF;
55: END load_row;
56: END je_pt_certificates_pkg;
57: