APPS.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on GL_INTERFACE

Line 51: g_user_je_category_name GL_INTERFACE.USER_JE_CATEGORY_NAME%TYPE;

47: g_chart_of_accounts_id NUMBER(15);
48: g_currency_code VARCHAR2(15);
49: g_curr_precision NUMBER;
50: g_step VARCHAR2(30);
51: g_user_je_category_name GL_INTERFACE.USER_JE_CATEGORY_NAME%TYPE;
52: g_user_je_source_name GL_INTERFACE.USER_JE_SOURCE_NAME%TYPE;
53: g_calendar_type FA_CALENDAR_TYPES.CALENDAR_TYPE%TYPE;
54: g_je_retirement_category FA_BOOK_CONTROLS.JE_RETIREMENT_CATEGORY%TYPE;
55: g_last_period_counter FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER%TYPE;

Line 52: g_user_je_source_name GL_INTERFACE.USER_JE_SOURCE_NAME%TYPE;

48: g_currency_code VARCHAR2(15);
49: g_curr_precision NUMBER;
50: g_step VARCHAR2(30);
51: g_user_je_category_name GL_INTERFACE.USER_JE_CATEGORY_NAME%TYPE;
52: g_user_je_source_name GL_INTERFACE.USER_JE_SOURCE_NAME%TYPE;
53: g_calendar_type FA_CALENDAR_TYPES.CALENDAR_TYPE%TYPE;
54: g_je_retirement_category FA_BOOK_CONTROLS.JE_RETIREMENT_CATEGORY%TYPE;
55: g_last_period_counter FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER%TYPE;
56: g_distribution_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;

Line 238: -- inserted in gl_interface table. --

234:
235:
236: ------------------------------------------------------------
237: -- Next two selects bring category y source name to be --
238: -- inserted in gl_interface table. --
239: ------------------------------------------------------------
240:
241:
242: SELECT user_je_category_name

Line 1243: -- Procedure: insert_gl_interface --

1239: END insert_retiremnt_jes;
1240:
1241:
1242: ------------------------------------------------------------
1243: -- Procedure: insert_gl_interface --
1244: -- --
1245: ------------------------------------------------------------
1246: PROCEDURE insert_gl_interface IS
1247: --

Line 1246: PROCEDURE insert_gl_interface IS

1242: ------------------------------------------------------------
1243: -- Procedure: insert_gl_interface --
1244: -- --
1245: ------------------------------------------------------------
1246: PROCEDURE insert_gl_interface IS
1247: --
1248: CURSOR jes_lines IS
1249: SELECT set_of_books_id,currency_code,adjustment_amount,
1250: code_combination_id,je_line_id,debit_credit_flag flag

Line 1255: l_group_id GL_INTERFACE.GROUP_ID%TYPE;

1251: FROM jl_zz_fa_retiremnt_jes
1252: WHERE request_id = x_request_id
1253: FOR UPDATE OF posting_flag;
1254:
1255: l_group_id GL_INTERFACE.GROUP_ID%TYPE;
1256: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GL_INTERFACE';
1257:
1258: BEGIN
1259:

Line 1256: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GL_INTERFACE';

1252: WHERE request_id = x_request_id
1253: FOR UPDATE OF posting_flag;
1254:
1255: l_group_id GL_INTERFACE.GROUP_ID%TYPE;
1256: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GL_INTERFACE';
1257:
1258: BEGIN
1259:
1260: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1268: x_char := 'Procedure insert_gl_interface';

1264: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1265: x_char := ' ';
1266: fnd_file.put_line (FND_FILE.LOG, x_char);
1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1268: x_char := 'Procedure insert_gl_interface';
1269: fnd_file.put_line (FND_FILE.LOG, x_char);
1270: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1271: END IF;
1272:

Line 1274: SELECT gl_interface_control_s.nextval

1270: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1271: END IF;
1272:
1273:
1274: SELECT gl_interface_control_s.nextval
1275: INTO l_group_id
1276: FROM sys.dual;
1277:
1278:

Line 1281: INSERT INTO gl_interface (

1277:
1278:
1279: FOR jes_lin_rec IN jes_lines
1280: LOOP
1281: INSERT INTO gl_interface (
1282: status,
1283: set_of_books_id,
1284: accounting_date,
1285: currency_code,

Line 1327: x_char := 'End of procedure insert_gl_interface';

1323: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1324: x_char := ' ';
1325: fnd_file.put_line (FND_FILE.LOG, x_char);
1326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1327: x_char := 'End of procedure insert_gl_interface';
1328: fnd_file.put_line (FND_FILE.LOG, x_char);
1329: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1330: END IF;
1331:

Line 1336: END insert_gl_interface;

1332: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1333: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
1334: END IF;
1335:
1336: END insert_gl_interface;
1337:
1338: ------------------------------------------------------------
1339: -- --
1340: -- Main Procedure - Code --

Line 1351: insert_gl_interface;

1347: current_period_reinstatements;
1348: current_period_retirements;
1349: adjust_previous_retirements;
1350: insert_retiremnt_jes;
1351: insert_gl_interface;
1352: COMMIT;
1353: retcode := '0';
1354:
1355: ------------------------------------------------------------