1 PACKAGE ICX_DATATEMPLATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: ICX_DATATEMPLATE_PKG.pls 120.3.12020000.3 2013/04/18 12:37:39 rparise noship $ */
3
4 reqHeaderId NUMBER;
5
6 FUNCTION AfterPForm RETURN Boolean;
7 FUNCTION GET_UDA_ATTR_DESC_SQL(P_DOC_TYPE IN VARCHAR2, P_PK1_VALUE IN NUMBER, P_DATA_TYPE IN VARCHAR2, P_APPL_COL_NAME IN VARCHAR2,
8 P_END_USER_COL_NAME IN VARCHAR2, P_ATTR_GROUP IN VARCHAR2, P_ATTR_ID IN NUMBER)RETURN VARCHAR2;
9 FUNCTION GET_UDA_HEADER_XML RETURN XMLType;
10 FUNCTION GET_ADDRESSXML RETURN CLOB;
11 FUNCTION GET_CONTACTSXML RETURN CLOB;
12 FUNCTION GET_AUTH_OFFICER_XML RETURN CLOB;
13 FUNCTION GET_APPROPRIATION(CHARGE_ACCOUNT IN VARCHAR2) RETURN VARCHAR2;
14 FUNCTION GET_LIMITSH(CHARGE_ACCOUNT IN VARCHAR2) RETURN VARCHAR2;
15 FUNCTION GET_ADDRESS_FROM_LOCATION(P_LOCATION_ID IN NUMBER) RETURN VARCHAR2;
16 FUNCTION GET_FUNDSDATAXML RETURN CLOB;
17 FUNCTION GET_MIPR_ACC_ATTRIBUTES RETURN CLOB;
18 PROCEDURE GET_TEMPLATES_FOR_DD448(X_FACEPAGETEMPLATE OUT NOCOPY VARCHAR2, X_CONTPAGESTEMPLATE OUT NOCOPY VARCHAR2, x_datadef OUT NOCOPY VARCHAR2);
19 PROCEDURE GET_TEMPLATES_FOR_DD448_2(X_FACEPAGETEMPLATE OUT NOCOPY VARCHAR2, X_CONTPAGESTEMPLATE OUT NOCOPY VARCHAR2, x_datadef OUT NOCOPY VARCHAR2);
20 FUNCTION GET_ADDRESS_FROM_UDA_ATTR(P_REQ_HEADER_ID IN NUMBER, P_ADDRESS_TYPE IN VARCHAR2, P_COL_NAME IN VARCHAR2)RETURN VARCHAR2;
21 FUNCTION GET_MIPR_ACCEPTANCE_STATUS(P_REQ_HEADER_ID IN NUMBER) RETURN VARCHAR2;
22 END;
23