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 103: v_from_alloc_code IN gl_aloc_mst.alloc_code%TYPE,

99: p_period_code IN VARCHAR2,
100: p_cost_type_id IN NUMBER,
101: p_fiscal_year IN VARCHAR2,
102: p_period_num IN NUMBER,
103: v_from_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
104: v_to_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
105: v_refresh_interface IN VARCHAR2
106: )
107: IS

Line 104: v_to_alloc_code IN gl_aloc_mst.alloc_code%TYPE,

100: p_cost_type_id IN NUMBER,
101: p_fiscal_year IN VARCHAR2,
102: p_period_num IN NUMBER,
103: v_from_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
104: v_to_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
105: v_refresh_interface IN VARCHAR2
106: )
107: IS
108: x_status NUMBER(10);

Line 297: FROM gl_aloc_mst

293: period_id = g_period_id AND
294: cost_type_id = g_cost_type_id
295: AND alloc_id IN (
296: SELECT alloc_id
297: FROM gl_aloc_mst
298: WHERE legal_entity_id = g_legal_entity_id
299: AND alloc_code between nvl(v_from_alloc_code,alloc_code)
300: AND nvl(v_to_alloc_code,alloc_code)
301: ); */

Line 310: FROM gl_aloc_mst m,gl_aloc_bas b

306: WHERE period_id = g_period_id
307: AND cost_type_id = g_cost_type_id
308: AND (alloc_id,line_no) NOT IN (
309: SELECT b.alloc_id, b.line_no
310: FROM gl_aloc_mst m,gl_aloc_bas b
311: WHERE m.alloc_id = b.alloc_id
312: AND m.legal_entity_id = g_legal_entity_id
313: AND b.delete_mark = 0
314: AND m.delete_mark = 0

Line 575: FROM gl_aloc_mst m, gl_aloc_bas b

571:
572: CURSOR cur_alloc_fixed_invalid IS
573: SELECT m.alloc_code alloc_code,
574: sum(b.fixed_percent) total_percentage
575: FROM gl_aloc_mst m, gl_aloc_bas b
576: WHERE m.alloc_id = b.alloc_id
577: AND m.legal_entity_id = g_legal_entity_id
578: AND b.alloc_method = 1
579: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code)

Line 713: gl_aloc_mst a

709: e.to_account_id as exp_to_account,
710: e.balance_type as exp_balance_type, e.exp_ytd_ptd
711: FROM
712: gl_aloc_exp e,
713: gl_aloc_mst a
714: WHERE
715: e.alloc_id = a.alloc_id
716: and a.legal_entity_id = g_legal_entity_id
717: and e.delete_mark = 0

Line 1160: FROM gl_aloc_mst m, gl_aloc_bas b

1156: b.basis_account_id,
1157: b.balance_type,
1158: b.bas_ytd_ptd,
1159: b.fixed_percent
1160: FROM gl_aloc_mst m, gl_aloc_bas b
1161: WHERE m.alloc_id = b.alloc_id
1162: AND m.legal_entity_id = g_legal_entity_id
1163: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)
1164: AND m.delete_mark = 0

Line 1232: FROM gl_aloc_mst m, gl_aloc_bas b

1228: SELECT m.alloc_id,
1229: b.line_no,
1230: b.alloc_method,
1231: b.fixed_percent
1232: FROM gl_aloc_mst m, gl_aloc_bas b
1233: WHERE m.alloc_id = b.alloc_id
1234: AND m.legal_entity_id = g_legal_entity_id
1235: AND b.alloc_method = 1
1236: AND m.alloc_code BETWEEN NVL(v_from_alloc_code,m.alloc_code) AND nvl(v_to_alloc_code,m.alloc_code)

Line 1260: from gl_aloc_mst m,gl_aloc_bas b

1256: and a.calendar_code = g_calendar_code
1257: AND a.period_code = g_period_code
1258: and a.alloc_id in (
1259: select m.alloc_id
1260: from gl_aloc_mst m,gl_aloc_bas b
1261: where m.legal_entity_id = g_legal_entity_id
1262: and m.alloc_id = b.alloc_id
1263: and b.alloc_method = 1
1264: and m.alloc_code between nvl(v_from_alloc_code,m.alloc_code)

Line 1340: FROM gl_aloc_mst m,gl_aloc_bas b

1336: AND i.period_code = g_period_code
1337: AND i.delete_mark = 0
1338: AND account_key_type = 0
1339: AND i.alloc_id IN (SELECT b.alloc_id
1340: FROM gl_aloc_mst m,gl_aloc_bas b
1341: where m.alloc_id = b.alloc_id
1342: AND m.legal_entity_id = g_legal_entity_id
1343: AND b.delete_mark = 0
1344: AND m.delete_mark = 0

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

1344: AND m.delete_mark = 0
1345: AND m.alloc_code BETWEEN nvl(v_from_alloc_code,m.alloc_code) and
1346: nvl(v_to_alloc_code ,m.alloc_code))
1347: ORDER BY alloc_id;
1348: CURSOR cur_alloc_code(v_alloc_id gl_aloc_mst.alloc_id%TYPE) IS
1349: SELECT alloc_code
1350: FROM gl_aloc_mst
1351: WHERE alloc_id = v_alloc_id;
1352:

Line 1350: FROM gl_aloc_mst

1346: nvl(v_to_alloc_code ,m.alloc_code))
1347: ORDER BY alloc_id;
1348: CURSOR cur_alloc_code(v_alloc_id gl_aloc_mst.alloc_id%TYPE) IS
1349: SELECT alloc_code
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;

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

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

Line 1358: x_alloc_code gl_aloc_mst.alloc_code%TYPE;

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