DBA Data[Home] [Help]

PACKAGE: APPS.OTA_CERT_XMLP_PKG

Source


1 PACKAGE ota_cert_xmlp_pkg AS
2 /* $Header: otacertxmlp.pkh 120.2 2008/01/08 10:04:48 aabalakr noship $ */
3 
4   P_CERTIFICATION_ID VARCHAR2(40);
5   P_LEARNER_NAME VARCHAR2(40);
6   P_SUBSCRIPTION_STATUS VARCHAR2(40);
7   P_SUBSCRIPTION_START_DATE varchar2(32767);
8   P_SUBSCRIPTION_END_DATE varchar2(32767);
9   P_EXPIRY_FROM_DATE varchar2(32767);
10   P_EXPIRY_TO_DATE varchar2(32767);
11 
12   C_CERTIFICATION_NAME varchar2(80);
13   C_SUBSCRIPTION_STATUS varchar2(80);
14   C_SUBSCRIPTION_START_DATE varchar2(20);
15   C_SUBSCRIPTION_END_DATE varchar2(20);
16   C_EXPIRY_FROM_DATE varchar2(20);
17   C_EXPIRY_TO_DATE varchar2(20);
18 
19 
20   Function C_CERTIFICATION_NAME_p return varchar2;
21   Function C_SUBSCRIPTION_STATUS_p return varchar2;
22   Function C_SUBSCRIPTION_START_DATE_p return varchar2;
23   Function C_SUBSCRIPTION_END_DATE_p return varchar2;
24   Function C_EXPIRY_FROM_DATE_p return varchar2;
25   Function C_EXPIRY_TO_DATE_p return varchar2;
26 
27 
28 END ota_cert_xmlp_pkg;
29