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_MIGRATION dependencies on GMF_FISCAL_POLICIES

Line 118: L_legal_entity_id gmf_fiscal_policies.legal_entity_id%TYPE;

114: /************************
115: * Local Variables *
116: ************************/
117:
118: L_legal_entity_id gmf_fiscal_policies.legal_entity_id%TYPE;
119:
120: /****************
121: * Cursors *
122: ****************/

Line 209: L_legal_entity_id gmf_fiscal_policies.legal_entity_id%TYPE;

205: /************************
206: * Local Variables *
207: ************************/
208:
209: L_legal_entity_id gmf_fiscal_policies.legal_entity_id%TYPE;
210:
211: /****************
212: * Cursors *
213: ****************/

Line 292: L_legal_entity_id gmf_fiscal_policies.legal_entity_id%TYPE;

288: /************************
289: * Local Variables *
290: ************************/
291:
292: L_legal_entity_id gmf_fiscal_policies.legal_entity_id%TYPE;
293:
294: /****************
295: * Cursors *
296: ****************/

Line 1738: * GL_PLCY_MST to GMF_FISCAL_POLICIES table. *

1734: * Migrate_Fiscal_policies_LE *
1735: * *
1736: * DESCRIPTION: *
1737: * This PL/SQL procedure is used to migrate the Fiscal Policies from *
1738: * GL_PLCY_MST to GMF_FISCAL_POLICIES table. *
1739: * *
1740: * PARAMETERS: *
1741: * P_migration_run_id - id to use to right to migration log *
1742: * x_exception_count - Number of exceptions occurred. *

Line 1798: G_Table_name := 'GMF_FISCAL_POLICIES';

1794:
1795: BEGIN
1796:
1797: G_Migration_run_id := P_migration_run_id;
1798: G_Table_name := 'GMF_FISCAL_POLICIES';
1799: G_Context := 'Fiscal Policies LE Migration';
1800: X_failure_count := 0;
1801:
1802: /********************************

Line 1819: * Insert a row into gmf_fiscal_policies *

1815: );
1816:
1817:
1818: /****************************************
1819: * Insert a row into gmf_fiscal_policies *
1820: ****************************************/
1821:
1822: FOR i IN Cur_get_fiscal_policies
1823: LOOP

Line 1855: FROM gmf_fiscal_policies

1851:
1852: BEGIN
1853: SELECT count(1)
1854: INTO l_le_count
1855: FROM gmf_fiscal_policies
1856: WHERE legal_entity_id = L_legal_entity_id;
1857: EXCEPTION
1858: WHEN no_data_found THEN
1859: l_le_count := 0;

Line 1869: INSERT INTO gmf_fiscal_policies

1865:
1866: IF L_legal_entity_id IS NOT NULL AND nvl(l_le_count,0) = 0 THEN
1867:
1868: BEGIN
1869: INSERT INTO gmf_fiscal_policies
1870: (
1871: LEGAL_ENTITY_ID,
1872: BASE_CURRENCY_CODE,
1873: LEDGER_ID,

Line 2170: G_Table_name := 'GMF_FISCAL_POLICIES';

2166:
2167: BEGIN
2168:
2169: G_Migration_run_id := P_migration_run_id;
2170: G_Table_name := 'GMF_FISCAL_POLICIES';
2171: G_Context := 'Fiscal Policies Migration - Others';
2172: X_failure_count := 0;
2173:
2174: /********************************

Line 2190: * Update a row in GMF_FISCAL_POLICIES for GL cost Types *

2186: p_app_short_name => 'GMA'
2187: );
2188:
2189: /********************************************************
2190: * Update a row in GMF_FISCAL_POLICIES for GL cost Types *
2191: ********************************************************/
2192:
2193: BEGIN
2194: UPDATE gmf_fiscal_policies a

Line 2194: UPDATE gmf_fiscal_policies a

2190: * Update a row in GMF_FISCAL_POLICIES for GL cost Types *
2191: ********************************************************/
2192:
2193: BEGIN
2194: UPDATE gmf_fiscal_policies a
2195: SET a.cost_type_id = (
2196: SELECT x.cost_type_id
2197: FROM cm_mthd_mst x
2198: WHERE x.cost_mthd_code = a.gl_cost_mthd

Line 2229: FROM gmf_fiscal_policies gfp

2225: gfp.last_updated_by,
2226: gfp.last_update_login,
2227: gfp.text_code,
2228: 0
2229: FROM gmf_fiscal_policies gfp
2230: WHERE NOT EXISTS (
2231: SELECT '1'
2232: FROM gmf_ledger_valuation_methods glvm
2233: WHERE glvm.legal_entity_id = gfp.legal_entity_id

Line 2284: FROM gmf_fiscal_policies

2280: **********************************************/
2281:
2282: SELECT count(*)
2283: INTO x_failure_count
2284: FROM gmf_fiscal_policies
2285: WHERE (cost_type_id IS NULL AND gl_cost_mthd IS NOT NULL);
2286:
2287: IF nvl(x_failure_count,0) > 0 THEN
2288:

Line 6545: l_legal_entity_id GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE;

6541: /******************
6542: * Local Variables *
6543: ******************/
6544:
6545: l_legal_entity_id GMF_FISCAL_POLICIES.LEGAL_ENTITY_ID%TYPE;
6546: l_adr_priority NUMBER := 10;
6547: l_adr_condition_priority NUMBER := 10;
6548: l_old_adr_condition_priority NUMBER := 10;
6549: l_adr_rule_code VARCHAR2(30);

Line 6665: FROM gmf_fiscal_policies a,

6661: e.chart_of_accounts_id,
6662: e.short_name,
6663: e.name,
6664: e.ledger_id
6665: FROM gmf_fiscal_policies a,
6666: gl_plcy_mst b,
6667: gmf_legal_entities c,
6668: mtl_parameters d,
6669: gl_ledgers e

Line 11906: gmf_fiscal_policies gfp,

11902: gfp.cost_basis
11903: from cm_mthd_mst cmm,
11904: cm_mthd_mst dcmm,
11905: gl_plcy_mst gpm,
11906: gmf_fiscal_policies gfp,
11907: xle_entity_profiles xep
11908: where gpm.co_code = a.co_code
11909: and gfp.legal_entity_id = gpm.legal_entity_id
11910: and xep.legal_entity_id = gfp.legal_entity_id