APPS.OTA_CERT_XMLP_PKG dependencies on DUAL

Line 38: from dual;

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

Line 46: from dual;

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

Line 54: from dual;

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

Line 62: from dual;

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