APPS.OTA_CERT_XMLP_PKG dependencies on DUAL

Line 37: from dual;

33: Function C_SUBSCRIPTION_START_DATE_p return varchar2 is
34: Begin
35: select fnd_date.date_to_displaydate(to_date(substr((P_SUBSCRIPTION_START_DATE),1,10),'yyyy/mm/dd'))
36: into C_SUBSCRIPTION_START_DATE
37: from dual;
38: return C_SUBSCRIPTION_START_DATE;
39: END;
40:
41: Function C_SUBSCRIPTION_END_DATE_p return varchar2 is

Line 45: from dual;

41: Function C_SUBSCRIPTION_END_DATE_p return varchar2 is
42: Begin
43: select fnd_date.date_to_displaydate(to_date(substr((P_SUBSCRIPTION_END_DATE),1,10),'yyyy/mm/dd'))
44: into C_SUBSCRIPTION_END_DATE
45: from dual;
46: return C_SUBSCRIPTION_END_DATE;
47: END;
48:
49: Function C_EXPIRY_FROM_DATE_p return varchar2 is

Line 53: from dual;

49: Function C_EXPIRY_FROM_DATE_p return varchar2 is
50: Begin
51: select fnd_date.date_to_displaydate(to_date(substr((P_EXPIRY_FROM_DATE),1,10),'yyyy/mm/dd'))
52: into C_EXPIRY_FROM_DATE
53: from dual;
54: return C_EXPIRY_FROM_DATE;
55: END;
56:
57: Function C_EXPIRY_TO_DATE_p return varchar2 is

Line 61: from dual;

57: Function C_EXPIRY_TO_DATE_p return varchar2 is
58: Begin
59: select fnd_date.date_to_displaydate(to_date(substr((P_EXPIRY_TO_DATE),1,10),'yyyy/mm/dd'))
60: into C_EXPIRY_TO_DATE
61: from dual;
62: return C_EXPIRY_TO_DATE;
63: END;
64:
65: END ota_cert_xmlp_pkg;