25: -----------------------------------------
26: --Public Variable Declarations
27: -----------------------------------------
28: -- bug fix 3062098 by lxzhang
29: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
30: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
31: L_MSG VARCHAR2(500);
32:
33: C_LINES_PER_INSERT CONSTANT NUMBER := 5000;
26: --Public Variable Declarations
27: -----------------------------------------
28: -- bug fix 3062098 by lxzhang
29: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
30: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
31: L_MSG VARCHAR2(500);
32:
33: C_LINES_PER_INSERT CONSTANT NUMBER := 5000;
34:
1244: THEN
1245: SELECT CHART_OF_ACCOUNTS_ID
1246: INTO L_CHART_OF_ACCOUNTS_ID
1247: FROM GL_SETS_OF_BOOKS
1248: WHERE SET_OF_BOOKS_ID = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
1249:
1250: -- Build the where clause for restricting the data to the
1251: -- balancing segments specified.
1252: -- L_WHERE_GL_FLEX'