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_MST

Line 114: v_from_alloc_code IN gl_aloc_mst.alloc_code%TYPE,

110: p_period_code IN VARCHAR2,
111: p_cost_type_id IN NUMBER,
112: p_fiscal_year IN VARCHAR2,
113: p_period_num IN NUMBER,
114: v_from_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
115: v_to_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
116: v_refresh_interface IN VARCHAR2
117: )
118: IS

Line 115: v_to_alloc_code IN gl_aloc_mst.alloc_code%TYPE,

111: p_cost_type_id IN NUMBER,
112: p_fiscal_year IN VARCHAR2,
113: p_period_num IN NUMBER,
114: v_from_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
115: v_to_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
116: v_refresh_interface IN VARCHAR2
117: )
118: IS
119: x_status NUMBER(10);

Line 316: FROM gl_aloc_mst m,gl_aloc_bas b

312: AND cost_type_id = g_cost_type_id
313: AND nvl(gl_posted_ind, 0) <> 1
314: AND (alloc_id,line_no) IN
315: (SELECT b.alloc_id, b.line_no
316: FROM gl_aloc_mst m,gl_aloc_bas b
317: WHERE m.alloc_id = b.alloc_id
318: AND m.legal_entity_id = g_legal_entity_id
319: AND ( b.delete_mark = 1 OR m.delete_mark = 1)
320: AND m.alloc_code BETWEEN nvl(v_from_alloc_code,m.alloc_code) and

Line 341: FROM gl_aloc_mst

337: period_id = g_period_id AND
338: cost_type_id = g_cost_type_id
339: AND alloc_id IN (
340: SELECT alloc_id
341: FROM gl_aloc_mst
342: WHERE legal_entity_id = g_legal_entity_id
343: AND alloc_code between nvl(v_from_alloc_code,alloc_code)
344: AND nvl(v_to_alloc_code,alloc_code)
345: ); */

Line 356: FROM gl_aloc_mst m,gl_aloc_bas b

352: WHERE period_id = g_period_id
353: AND cost_type_id = g_cost_type_id
354: AND (alloc_id,line_no) NOT IN (
355: SELECT b.alloc_id, b.line_no
356: FROM gl_aloc_mst m,gl_aloc_bas b
357: WHERE m.alloc_id = b.alloc_id
358: AND m.legal_entity_id = g_legal_entity_id
359: AND b.delete_mark = 0
360: AND m.delete_mark = 0

Line 439: FROM gl_aloc_mst m,gl_aloc_bas b

435: AND cost_type_id = g_cost_type_id
436: AND nvl(gl_posted_ind, 0) <> 1 -- Bug 12561766
437: AND (alloc_id,line_no) IN (
438: SELECT b.alloc_id, b.line_no
439: FROM gl_aloc_mst m,gl_aloc_bas b
440: WHERE m.alloc_id = b.alloc_id
441: AND m.legal_entity_id = g_legal_entity_id
442: AND ( b.delete_mark = 1 OR m.delete_mark = 1)
443: AND m.alloc_code BETWEEN nvl(v_from_alloc_code,m.alloc_code) and

Line 646: FROM gl_aloc_mst m, gl_aloc_bas b

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
647: WHERE m.alloc_id = b.alloc_id
648: AND m.legal_entity_id = g_legal_entity_id
649: AND m.alloc_code BETWEEN nvl(v_from_alloc_code, m.alloc_code) AND
650: nvl(v_to_alloc_code, m.alloc_code)

Line 715: FROM gl_aloc_mst m, gl_aloc_bas b

711:
712: CURSOR cur_alloc_fixed_invalid IS
713: SELECT m.alloc_code alloc_code,
714: sum(b.fixed_percent) total_percentage
715: FROM gl_aloc_mst m, gl_aloc_bas b
716: WHERE m.alloc_id = b.alloc_id
717: AND m.legal_entity_id = g_legal_entity_id
718: AND b.alloc_method = 1
719: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code)

Line 853: gl_aloc_mst a

849: e.to_account_id as exp_to_account,
850: e.balance_type as exp_balance_type, e.exp_ytd_ptd
851: FROM
852: gl_aloc_exp e,
853: gl_aloc_mst a
854: WHERE
855: e.alloc_id = a.alloc_id
856: and a.legal_entity_id = g_legal_entity_id
857: and e.delete_mark = 0

Line 1393: FROM gl_aloc_mst m, gl_aloc_bas b

1389: b.basis_account_id,
1390: b.balance_type,
1391: b.bas_ytd_ptd,
1392: b.fixed_percent
1393: FROM gl_aloc_mst m, gl_aloc_bas b
1394: WHERE m.alloc_id = b.alloc_id
1395: AND m.legal_entity_id = g_legal_entity_id
1396: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)
1397: AND m.delete_mark = 0

Line 1465: FROM gl_aloc_mst m, gl_aloc_bas b

1461: SELECT m.alloc_id,
1462: b.line_no,
1463: b.alloc_method,
1464: b.fixed_percent
1465: FROM gl_aloc_mst m, gl_aloc_bas b
1466: WHERE m.alloc_id = b.alloc_id
1467: AND m.legal_entity_id = g_legal_entity_id
1468: AND b.alloc_method = 1
1469: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)

Line 1493: from gl_aloc_mst m,gl_aloc_bas b

1489: and a.calendar_code = g_calendar_code
1490: AND a.period_code = g_period_code
1491: and a.alloc_id in (
1492: select m.alloc_id
1493: from gl_aloc_mst m,gl_aloc_bas b
1494: where m.legal_entity_id = g_legal_entity_id
1495: and m.alloc_id = b.alloc_id
1496: and b.alloc_method = 1
1497: and m.alloc_code between nvl(v_from_alloc_code,m.alloc_code)

Line 1573: FROM gl_aloc_mst m,gl_aloc_bas b

1569: AND i.period_code = g_period_code
1570: AND i.delete_mark = 0
1571: AND account_key_type = 0
1572: AND i.alloc_id IN (SELECT b.alloc_id
1573: FROM gl_aloc_mst m,gl_aloc_bas b
1574: where m.alloc_id = b.alloc_id
1575: AND m.legal_entity_id = g_legal_entity_id
1576: AND b.delete_mark = 0
1577: AND m.delete_mark = 0

Line 1581: CURSOR cur_alloc_code(v_alloc_id gl_aloc_mst.alloc_id%TYPE) IS

1577: AND m.delete_mark = 0
1578: AND m.alloc_code BETWEEN nvl(v_from_alloc_code,m.alloc_code) and
1579: nvl(v_to_alloc_code ,m.alloc_code))
1580: ORDER BY alloc_id;
1581: CURSOR cur_alloc_code(v_alloc_id gl_aloc_mst.alloc_id%TYPE) IS
1582: SELECT alloc_code
1583: FROM gl_aloc_mst
1584: WHERE alloc_id = v_alloc_id;
1585:

Line 1583: FROM gl_aloc_mst

1579: nvl(v_to_alloc_code ,m.alloc_code))
1580: ORDER BY alloc_id;
1581: CURSOR cur_alloc_code(v_alloc_id gl_aloc_mst.alloc_id%TYPE) IS
1582: SELECT alloc_code
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;

Line 1586: x_prev_alloc_id gl_aloc_mst.alloc_id%TYPE DEFAULT -99;

1582: SELECT alloc_code
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;

Line 1591: x_alloc_code gl_aloc_mst.alloc_code%TYPE;

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
1595: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module||l_local_module||'.begin',' Starting..');