APPS.JE_JENOGEIS_XMLP_PKG dependencies on JE_NO_GEI_ASCIIS_T

Line 192: PROCEDURE P_INS_ASCII(P_LINE_NUMBER IN JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE

188: V_STRENG;
189: END;
190: END P_GEI_VIEW;
191:
192: PROCEDURE P_INS_ASCII(P_LINE_NUMBER IN JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE
193: ,P_TEXT IN JE_NO_GEI_ASCIIS_T.TEXT%TYPE) IS
194: BEGIN
195: INSERT INTO JE_NO_GEI_ASCIIS_T(LINE_NUMBER,TEXT)
196: VALUES (P_LINE_NUMBER

Line 193: ,P_TEXT IN JE_NO_GEI_ASCIIS_T.TEXT%TYPE) IS

189: END;
190: END P_GEI_VIEW;
191:
192: PROCEDURE P_INS_ASCII(P_LINE_NUMBER IN JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE
193: ,P_TEXT IN JE_NO_GEI_ASCIIS_T.TEXT%TYPE) IS
194: BEGIN
195: INSERT INTO JE_NO_GEI_ASCIIS_T(LINE_NUMBER,TEXT)
196: VALUES (P_LINE_NUMBER
197: ,P_TEXT);

Line 195: INSERT INTO JE_NO_GEI_ASCIIS_T(LINE_NUMBER,TEXT)

191:
192: PROCEDURE P_INS_ASCII(P_LINE_NUMBER IN JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE
193: ,P_TEXT IN JE_NO_GEI_ASCIIS_T.TEXT%TYPE) IS
194: BEGIN
195: INSERT INTO JE_NO_GEI_ASCIIS_T(LINE_NUMBER,TEXT)
196: VALUES (P_LINE_NUMBER
197: ,P_TEXT);
198: EXCEPTION
199: WHEN OTHERS THEN

Line 218: T_LINE_NUMBER JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE;

214: T_PERIOD_YEAR GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE;
215: T_PERIOD_NUM GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
216: T_SUM_INCOME GL_BALANCES.PERIOD_NET_DR%TYPE;
217: T_SUM_EXPENSE GL_BALANCES.PERIOD_NET_DR%TYPE;
218: T_LINE_NUMBER JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE;
219: T_TEXT JE_NO_GEI_ASCIIS_T.TEXT%TYPE;
220: T_SET_OF_BOOKS GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
221: T_DETAIL_TEMPL GL_BALANCES.TEMPLATE_ID%TYPE;
222: T_INCOME_ACCOUNT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

Line 219: T_TEXT JE_NO_GEI_ASCIIS_T.TEXT%TYPE;

215: T_PERIOD_NUM GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
216: T_SUM_INCOME GL_BALANCES.PERIOD_NET_DR%TYPE;
217: T_SUM_EXPENSE GL_BALANCES.PERIOD_NET_DR%TYPE;
218: T_LINE_NUMBER JE_NO_GEI_ASCIIS_T.LINE_NUMBER%TYPE;
219: T_TEXT JE_NO_GEI_ASCIIS_T.TEXT%TYPE;
220: T_SET_OF_BOOKS GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
221: T_DETAIL_TEMPL GL_BALANCES.TEMPLATE_ID%TYPE;
222: T_INCOME_ACCOUNT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
223: T_EXPENSE_ACCOUNT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

Line 298: DELETE FROM JE_NO_GEI_ASCIIS_T;

294: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
295: END IF;
296: END;
297: BEGIN
298: DELETE FROM JE_NO_GEI_ASCIIS_T;
299: EXCEPTION
300: WHEN OTHERS THEN
301: /*SRW.MESSAGE('101'
302: ,'Cant delete from JE_NO_GEI_ASCII_S.')*/NULL;