DBA Data[Home] [Help]

APPS.AR_ARBARL_XMLP_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 65: FROM RA_CUST_TRX_LINE_GL_DIST

61: LINES := 0;
62: IF NVL(CONC_REQUEST_ID,0) > 0 THEN
63: SELECT COUNT(*)
64: INTO LINES
65: FROM RA_CUST_TRX_LINE_GL_DIST
66: WHERE REQUEST_ID = CONC_REQUEST_ID
67: AND ACCOUNT_CLASS NOT IN ( 'UNEARN' , 'UNBILL' );
68:
69: P_CONC_REQUEST_ID := CONC_REQUEST_ID;

Line 124: RA_CUST_TRX_LINE_GL_DIST

120: WHERE exists (
121: SELECT
122: 'x'
123: FROM
124: RA_CUST_TRX_LINE_GL_DIST
125: WHERE REQUEST_ID = ID );
126: CHK VARCHAR2(30);
127: BEGIN
128: IF ID IS NULL THEN

Line 138: ,'Concurrent Request ' || TO_CHAR(ID) || ' alread used in ra_cust_trx_line_gl_dist')*/NULL;

134: FETCH SEL_REQUEST_ID
135: INTO CHK;
136: IF SEL_REQUEST_ID%FOUND THEN
137: /*SRW.MESSAGE('100'
138: ,'Concurrent Request ' || TO_CHAR(ID) || ' alread used in ra_cust_trx_line_gl_dist')*/NULL;
139: CLOSE SEL_REQUEST_ID;
140: RETURN (FALSE);
141: END IF;
142: CLOSE SEL_REQUEST_ID;