eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_ALLOC_PROC dependencies on GL_ALOC_INP

Line 505: alloc_log_msg(C_LOG_FILE, 'Deleting rows from gl_aloc_inp for calendar '||

501: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
502: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module||'.begin','Delete interface');
503: END IF;
504:
505: alloc_log_msg(C_LOG_FILE, 'Deleting rows from gl_aloc_inp for calendar '||
506: g_calendar_code||' and period '||g_period_code || ' and cost type '||g_cost_mthd_code);
507:
508: DELETE
509: FROM gl_aloc_inp

Line 509: FROM gl_aloc_inp

505: alloc_log_msg(C_LOG_FILE, 'Deleting rows from gl_aloc_inp for calendar '||
506: g_calendar_code||' and period '||g_period_code || ' and cost type '||g_cost_mthd_code);
507:
508: DELETE
509: FROM gl_aloc_inp
510: WHERE calendar_code = g_calendar_code
511: AND period_code = g_period_code;
512:
513: v_status :=0;

Line 515: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Interface table gl_aloc_inp' );

511: AND period_code = g_period_code;
512:
513: v_status :=0;
514:
515: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Interface table gl_aloc_inp' );
516:
517: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module||'.end','Delete interface');
519: END IF;

Line 524: alloc_log_msg(C_LOG_FILE, '0 rows deleted from gl_aloc_inp');

520:
521: EXCEPTION
522:
523: WHEN NO_DATA_FOUND THEN
524: alloc_log_msg(C_LOG_FILE, '0 rows deleted from gl_aloc_inp');
525: v_status := 0;
526: WHEN OTHERS THEN
527: alloc_log_msg(C_LOG_FILE, to_char(SQLCODE) || ' ' || SQLERRM);
528: v_status := -1;

Line 1037: * Inserts a row in to gl_aloc_inp.

1033: * PROCEDURE
1034: * insert_alloc_inp
1035: *
1036: * DESCRIPTION
1037: * Inserts a row in to gl_aloc_inp.
1038: *
1039: * AUTHOR
1040: * Sukarna Reddy 09/18/98
1041: *

Line 1073: gl_aloc_inp

1069: END IF;
1070:
1071: INSERT
1072: INTO
1073: gl_aloc_inp
1074: (
1075: gl_aloc_inp_id,
1076: calendar_code,
1077: period_code,

Line 1075: gl_aloc_inp_id,

1071: INSERT
1072: INTO
1073: gl_aloc_inp
1074: (
1075: gl_aloc_inp_id,
1076: calendar_code,
1077: period_code,
1078: alloc_id,
1079: line_no,

Line 1094: gem5_gl_aloc_inp_id_s.nextval,

1090: text_code
1091: )
1092: VALUES
1093: (
1094: gem5_gl_aloc_inp_id_s.nextval,
1095: g_calendar_code,
1096: g_period_code,
1097: v_alloc_id,
1098: v_line_no,

Line 1250: alloc_log_msg( C_LOG_FILE, 'Deleting rows from Interface table gl_aloc_inp ...' );

1246: l_previous_module VARCHAR2(4000);
1247: BEGIN
1248: l_previous_module := g_calling_module;
1249: g_calling_module := g_calling_module||l_local_module;
1250: alloc_log_msg( C_LOG_FILE, 'Deleting rows from Interface table gl_aloc_inp ...' );
1251:
1252: BEGIN
1253: DELETE
1254: FROM gl_aloc_inp a

Line 1254: FROM gl_aloc_inp a

1250: alloc_log_msg( C_LOG_FILE, 'Deleting rows from Interface table gl_aloc_inp ...' );
1251:
1252: BEGIN
1253: DELETE
1254: FROM gl_aloc_inp a
1255: WHERE a.account_key_type = 0
1256: and a.calendar_code = g_calendar_code
1257: AND a.period_code = g_period_code
1258: and a.alloc_id in (

Line 1268: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Interface table gl_aloc_inp' );

1264: and m.alloc_code between nvl(v_from_alloc_code,m.alloc_code)
1265: and nvl(v_to_alloc_code,m.alloc_code)
1266: );
1267:
1268: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Interface table gl_aloc_inp' );
1269: EXCEPTION
1270: WHEN NO_DATA_FOUND THEN
1271: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_inp for fixed');
1272:

Line 1271: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_inp for fixed');

1267:
1268: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Interface table gl_aloc_inp' );
1269: EXCEPTION
1270: WHEN NO_DATA_FOUND THEN
1271: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_inp for fixed');
1272:
1273: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1274: THEN
1275: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,g_calling_module,'0 Rows deleted from gl_aloc_inp for fixed');

Line 1275: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,g_calling_module,'0 Rows deleted from gl_aloc_inp for fixed');

1271: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_inp for fixed');
1272:
1273: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1274: THEN
1275: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,g_calling_module,'0 Rows deleted from gl_aloc_inp for fixed');
1276: END IF;
1277: WHEN OTHERS THEN
1278: alloc_log_msg(C_LOG_FILE, to_char(SQLCODE) || ' ' || SQLERRM);
1279:

Line 1334: FROM gl_aloc_inp i

1330: x_status NUMBER; /*B7458002*/
1331:
1332: CURSOR cur_glaloc_inp IS
1333: SELECT *
1334: FROM gl_aloc_inp i
1335: WHERE i.calendar_code = g_calendar_code
1336: AND i.period_code = g_period_code
1337: AND i.delete_mark = 0
1338: AND account_key_type = 0

Line 1354: x_prev_basis_amount gl_aloc_inp.amount%TYPE DEFAULT -99;

1350: FROM gl_aloc_mst
1351: WHERE alloc_id = v_alloc_id;
1352:
1353: x_prev_alloc_id gl_aloc_mst.alloc_id%TYPE DEFAULT -99;
1354: x_prev_basis_amount gl_aloc_inp.amount%TYPE DEFAULT -99;
1355: x_expense_amount gl_aloc_inp.amount%TYPE;
1356: x_alloc_percent NUMBER;
1357: x_allocated_amount gl_aloc_inp.amount%type;
1358: x_alloc_code gl_aloc_mst.alloc_code%TYPE;

Line 1355: x_expense_amount gl_aloc_inp.amount%TYPE;

1351: WHERE alloc_id = v_alloc_id;
1352:
1353: x_prev_alloc_id gl_aloc_mst.alloc_id%TYPE DEFAULT -99;
1354: x_prev_basis_amount gl_aloc_inp.amount%TYPE DEFAULT -99;
1355: x_expense_amount gl_aloc_inp.amount%TYPE;
1356: x_alloc_percent NUMBER;
1357: x_allocated_amount gl_aloc_inp.amount%type;
1358: x_alloc_code gl_aloc_mst.alloc_code%TYPE;
1359: l_local_module VARCHAR2(80) := '.process_aloc_dtl';

Line 1357: x_allocated_amount gl_aloc_inp.amount%type;

1353: x_prev_alloc_id gl_aloc_mst.alloc_id%TYPE DEFAULT -99;
1354: x_prev_basis_amount gl_aloc_inp.amount%TYPE DEFAULT -99;
1355: x_expense_amount gl_aloc_inp.amount%TYPE;
1356: x_alloc_percent NUMBER;
1357: x_allocated_amount gl_aloc_inp.amount%type;
1358: x_alloc_code gl_aloc_mst.alloc_code%TYPE;
1359: l_local_module VARCHAR2(80) := '.process_aloc_dtl';
1360: BEGIN
1361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1375: FROM gl_aloc_inp

1371: alloc_log_msg(C_LOG_FILE, ' Allocation Code: ' || x_alloc_code);
1372:
1373: /* Select total basis amount for calculating percentage.*/
1374: SELECT sum(amount) INTO X_prev_basis_amount
1375: FROM gl_aloc_inp
1376: WHERE alloc_id = cur_alocinp_tmp.alloc_id
1377: AND calendar_code = g_calendar_code
1378: AND period_code = g_period_code
1379: AND account_key_type = 0;

Line 1385: FROM gl_aloc_inp

1381:
1382: /* Select total expense amount for allocation.*/
1383: SELECT sum(amount)
1384: INTO x_expense_amount
1385: FROM gl_aloc_inp
1386: WHERE alloc_id = cur_alocinp_tmp.alloc_id
1387: AND calendar_code = g_calendar_code
1388: AND period_code = g_period_code
1389: AND account_key_type = 1;