1: PACKAGE BODY JL_JLCOPWHR_XMLP_PKG AS
2: /* $Header: JLCOPWHRB.pls 120.1 2007/12/25 16:51:59 dwkrishn noship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: L_CHART_OF_ACCOUNTS_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5: INIT_FAILURE EXCEPTION;
6: BASE_CURR VARCHAR2(17);
7: PREC NUMBER;
8: BEGIN
12: DISTINCT
13: ( CHART_OF_ACCOUNTS_ID )
14: INTO L_CHART_OF_ACCOUNTS_ID
15: FROM
16: GL_SETS_OF_BOOKS G,
17: AP_SYSTEM_PARAMETERS A
18: WHERE G.SET_OF_BOOKS_ID = P_SOB_ID;
19: P_COA_ID := L_CHART_OF_ACCOUNTS_ID;
20: /*SRW.REFERENCE(P_COA_ID)*/NULL;
110: RETURN NULL;
111: END CF_VAT_AMOUNTFORMULA;
112:
113: FUNCTION GET_COMPANY_NAME RETURN BOOLEAN IS
114: L_CHART_OF_ACCOUNTS_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
115: L_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
116: L_REPORT_START_DATE DATE;
117: BEGIN
118: L_REPORT_START_DATE := SYSDATE;
111: END CF_VAT_AMOUNTFORMULA;
112:
113: FUNCTION GET_COMPANY_NAME RETURN BOOLEAN IS
114: L_CHART_OF_ACCOUNTS_ID GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
115: L_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
116: L_REPORT_START_DATE DATE;
117: BEGIN
118: L_REPORT_START_DATE := SYSDATE;
119: SELECT
120: NAME,
121: CHART_OF_ACCOUNTS_ID
122: INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
123: FROM
124: GL_SETS_OF_BOOKS G,
125: AP_SYSTEM_PARAMETERS_ALL A
126: WHERE G.SET_OF_BOOKS_ID = A.SET_OF_BOOKS_ID;
127: C_COMPANY_NAME_HEADER := L_NAME;
128: C_CHART_OF_ACCOUNTS_ID := L_CHART_OF_ACCOUNTS_ID;
202: START_DATE
203: INTO X_START_DATE
204: FROM
205: GL_PERIODS A,
206: GL_SETS_OF_BOOKS B
207: WHERE B.SET_OF_BOOKS_ID = P_SOB_ID
208: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
209: AND UPPER(A.PERIOD_NAME) = UPPER(P_PERIOD_FROM);
210: P_ACCOUNTING_DATE_FROM := X_START_DATE;
218: END_DATE
219: INTO X_END_DATE
220: FROM
221: GL_PERIODS A,
222: GL_SETS_OF_BOOKS B
223: WHERE B.SET_OF_BOOKS_ID = P_SOB_ID
224: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
225: AND UPPER(A.PERIOD_NAME) = UPPER(P_PERIOD_TO);
226: P_ACCOUNTING_DATE_TO := X_END_DATE;