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 65: * This account Id is now used to create record in gl_aloc_inp.

61: * for which process is being run.
62: * 14-Jul-2011 Pramod B.H. Bug#12600219
63: * (i)Modified procedure put_alloc_expenses(). Now passing new out parameter
64: * X_to_segment_ccid in the call to gmf_gl_get_balances.proc_gl_get_balances().
65: * This account Id is now used to create record in gl_aloc_inp.
66: * (ii)Now printing few existing debug messages (debug level 3) into
67: * the logfile itself instead of the output file.
68: * Bug 14178149 Prasad marad. Added a ref cursor object to the argument of
69: * proc_gl_get_balances just to maintain the state and ref_cursor cannot be declared

Line 626: * prasad marada bug13803220 deleting from gl_aloc)inp based on allocation code parameters

622: * v_status = 0 No rows to delete
623: * = -1 Fatal Error
624: * HISTORY
625: * Sukarna Reddy Modified code for convergence July 20
626: * prasad marada bug13803220 deleting from gl_aloc)inp based on allocation code parameters
627: ****************************************************************************/
628:
629: PROCEDURE delete_interface(v_from_alloc_code VARCHAR2,
630: v_to_alloc_code VARCHAR2,

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

634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module||'.begin','Delete interface');
636: END IF;
637:
638: alloc_log_msg(C_LOG_FILE, 'Deleting rows from gl_aloc_inp for calendar '||g_calendar_code ||
639: ' and period '||g_period_code || ' and cost type '||g_cost_mthd_code ||' From Alloc code '||v_from_alloc_code ||'To Alloc code '||v_to_alloc_code );
640:
641: DELETE
642: FROM gl_aloc_inp

Line 642: FROM gl_aloc_inp

638: alloc_log_msg(C_LOG_FILE, 'Deleting rows from gl_aloc_inp for calendar '||g_calendar_code ||
639: ' and period '||g_period_code || ' and cost type '||g_cost_mthd_code ||' From Alloc code '||v_from_alloc_code ||'To Alloc code '||v_to_alloc_code );
640:
641: DELETE
642: FROM gl_aloc_inp
643: WHERE calendar_code = g_calendar_code
644: AND period_code = g_period_code
645: AND alloc_id IN (SELECT b.alloc_id
646: FROM gl_aloc_mst m, gl_aloc_bas b

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

651: );
652:
653: v_status :=0;
654:
655: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Interface table gl_aloc_inp' );
656:
657: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,c_module||l_local_module||'.end','Delete interface');
659: END IF;

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

660:
661: EXCEPTION
662:
663: WHEN NO_DATA_FOUND THEN
664: alloc_log_msg(C_LOG_FILE, '0 rows deleted from gl_aloc_inp');
665: v_status := 0;
666: WHEN OTHERS THEN
667: alloc_log_msg(C_LOG_FILE, to_char(SQLCODE) || ' ' || SQLERRM);
668: v_status := -1;

Line 1209: /*Bug#12600219 (START) - Inserting X_to_segment_ccid itself into gl_aloc_inp **/

1205: END IF;
1206: END IF;
1207: **/
1208:
1209: /*****Bug#12600219 (START) - Inserting X_to_segment_ccid itself into gl_aloc_inp ******/
1210: IF (X_to_segment_ccid > 0) THEN
1211: insert_alloc_inp(v_alloc_id,
1212: v_line_no,
1213: v_account_type,

Line 1251: alloc_log_msg(C_LOG_FILE, ' WARNING: Incorrect X_to_segment_ccid, NOT inserting into gl_aloc_inp : '||to_char(X_to_segment_ccid));

1247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Finished Calling FND_FLEX_EXT.GET_SEGMENTS() API');
1248: END IF;
1249: /* Now, fetching account using ccid just to display it in log (END)*/
1250: ELSE
1251: alloc_log_msg(C_LOG_FILE, ' WARNING: Incorrect X_to_segment_ccid, NOT inserting into gl_aloc_inp : '||to_char(X_to_segment_ccid));
1252: END IF;
1253:
1254: /*****Bug#12600219 (END) - Inserting X_to_segment_ccid itself into gl_aloc_inp ******/
1255:

Line 1254: /*Bug#12600219 (END) - Inserting X_to_segment_ccid itself into gl_aloc_inp **/

1250: ELSE
1251: alloc_log_msg(C_LOG_FILE, ' WARNING: Incorrect X_to_segment_ccid, NOT inserting into gl_aloc_inp : '||to_char(X_to_segment_ccid));
1252: END IF;
1253:
1254: /*****Bug#12600219 (END) - Inserting X_to_segment_ccid itself into gl_aloc_inp ******/
1255:
1256: END IF;
1257: /* end SSCHINCH */
1258: END LOOP;

Line 1270: * Inserts a row in to gl_aloc_inp.

1266: * PROCEDURE
1267: * insert_alloc_inp
1268: *
1269: * DESCRIPTION
1270: * Inserts a row in to gl_aloc_inp.
1271: *
1272: * AUTHOR
1273: * Sukarna Reddy 09/18/98
1274: *

Line 1306: gl_aloc_inp

1302: END IF;
1303:
1304: INSERT
1305: INTO
1306: gl_aloc_inp
1307: (
1308: gl_aloc_inp_id,
1309: calendar_code,
1310: period_code,

Line 1308: gl_aloc_inp_id,

1304: INSERT
1305: INTO
1306: gl_aloc_inp
1307: (
1308: gl_aloc_inp_id,
1309: calendar_code,
1310: period_code,
1311: alloc_id,
1312: line_no,

Line 1327: gem5_gl_aloc_inp_id_s.nextval,

1323: text_code
1324: )
1325: VALUES
1326: (
1327: gem5_gl_aloc_inp_id_s.nextval,
1328: g_calendar_code,
1329: g_period_code,
1330: v_alloc_id,
1331: v_line_no,

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

1479: l_previous_module VARCHAR2(4000);
1480: BEGIN
1481: l_previous_module := g_calling_module;
1482: g_calling_module := g_calling_module||l_local_module;
1483: alloc_log_msg( C_LOG_FILE, 'Deleting rows from Interface table gl_aloc_inp ...' );
1484:
1485: BEGIN
1486: DELETE
1487: FROM gl_aloc_inp a

Line 1487: FROM gl_aloc_inp a

1483: alloc_log_msg( C_LOG_FILE, 'Deleting rows from Interface table gl_aloc_inp ...' );
1484:
1485: BEGIN
1486: DELETE
1487: FROM gl_aloc_inp a
1488: WHERE a.account_key_type = 0
1489: and a.calendar_code = g_calendar_code
1490: AND a.period_code = g_period_code
1491: and a.alloc_id in (

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

1497: and m.alloc_code between nvl(v_from_alloc_code,m.alloc_code)
1498: and nvl(v_to_alloc_code,m.alloc_code)
1499: );
1500:
1501: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Interface table gl_aloc_inp' );
1502: EXCEPTION
1503: WHEN NO_DATA_FOUND THEN
1504: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_inp for fixed');
1505:

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

1500:
1501: alloc_log_msg( C_LOG_FILE, TO_CHAR(SQL%ROWCOUNT) || ' Rows deleted from Interface table gl_aloc_inp' );
1502: EXCEPTION
1503: WHEN NO_DATA_FOUND THEN
1504: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_inp for fixed');
1505:
1506: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1507: THEN
1508: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,g_calling_module,'0 Rows deleted from gl_aloc_inp for fixed');

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

1504: alloc_log_msg(C_LOG_FILE, '0 Rows deleted from gl_aloc_inp for fixed');
1505:
1506: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1507: THEN
1508: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,g_calling_module,'0 Rows deleted from gl_aloc_inp for fixed');
1509: END IF;
1510: WHEN OTHERS THEN
1511: alloc_log_msg(C_LOG_FILE, to_char(SQLCODE) || ' ' || SQLERRM);
1512:

Line 1567: FROM gl_aloc_inp i

1563: x_status NUMBER; /*B7458002*/
1564:
1565: CURSOR cur_glaloc_inp IS
1566: SELECT *
1567: FROM gl_aloc_inp i
1568: WHERE i.calendar_code = g_calendar_code
1569: AND i.period_code = g_period_code
1570: AND i.delete_mark = 0
1571: AND account_key_type = 0

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

1583: FROM gl_aloc_mst
1584: WHERE alloc_id = v_alloc_id;
1585:
1586: x_prev_alloc_id gl_aloc_mst.alloc_id%TYPE DEFAULT -99;
1587: x_prev_basis_amount gl_aloc_inp.amount%TYPE DEFAULT -99;
1588: x_expense_amount gl_aloc_inp.amount%TYPE;
1589: x_alloc_percent NUMBER;
1590: x_allocated_amount gl_aloc_inp.amount%type;
1591: x_alloc_code gl_aloc_mst.alloc_code%TYPE;

Line 1588: x_expense_amount gl_aloc_inp.amount%TYPE;

1584: WHERE alloc_id = v_alloc_id;
1585:
1586: x_prev_alloc_id gl_aloc_mst.alloc_id%TYPE DEFAULT -99;
1587: x_prev_basis_amount gl_aloc_inp.amount%TYPE DEFAULT -99;
1588: x_expense_amount gl_aloc_inp.amount%TYPE;
1589: x_alloc_percent NUMBER;
1590: x_allocated_amount gl_aloc_inp.amount%type;
1591: x_alloc_code gl_aloc_mst.alloc_code%TYPE;
1592: l_local_module VARCHAR2(80) := '.process_aloc_dtl';

Line 1590: x_allocated_amount gl_aloc_inp.amount%type;

1586: x_prev_alloc_id gl_aloc_mst.alloc_id%TYPE DEFAULT -99;
1587: x_prev_basis_amount gl_aloc_inp.amount%TYPE DEFAULT -99;
1588: x_expense_amount gl_aloc_inp.amount%TYPE;
1589: x_alloc_percent NUMBER;
1590: x_allocated_amount gl_aloc_inp.amount%type;
1591: x_alloc_code gl_aloc_mst.alloc_code%TYPE;
1592: l_local_module VARCHAR2(80) := '.process_aloc_dtl';
1593: BEGIN
1594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1608: FROM gl_aloc_inp

1604: alloc_log_msg(C_LOG_FILE, ' Allocation Code: ' || x_alloc_code);
1605:
1606: /* Select total basis amount for calculating percentage.*/
1607: SELECT sum(amount) INTO X_prev_basis_amount
1608: FROM gl_aloc_inp
1609: WHERE alloc_id = cur_alocinp_tmp.alloc_id
1610: AND calendar_code = g_calendar_code
1611: AND period_code = g_period_code
1612: AND account_key_type = 0;

Line 1618: FROM gl_aloc_inp

1614:
1615: /* Select total expense amount for allocation.*/
1616: SELECT sum(amount)
1617: INTO x_expense_amount
1618: FROM gl_aloc_inp
1619: WHERE alloc_id = cur_alocinp_tmp.alloc_id
1620: AND calendar_code = g_calendar_code
1621: AND period_code = g_period_code
1622: AND account_key_type = 1;