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 GL_ALOC_INP

Line 9472: CURSOR c_gl_aloc_inp

9468: /* USKUMARI Bug 14614554 */
9469: /**********
9470: * Cursors *
9471: **********/
9472: CURSOR c_gl_aloc_inp
9473: IS
9474: SELECT y.alloc_id,
9475: y.mina,
9476: count(x.alloc_id) cnt

Line 9477: FROM gl_aloc_inp x, (

9473: IS
9474: SELECT y.alloc_id,
9475: y.mina,
9476: count(x.alloc_id) cnt
9477: FROM gl_aloc_inp x, (
9478: SELECT a.alloc_id,
9479: (
9480: SELECT MIN(h.alloc_id)
9481: FROM gl_aloc_mst h

Line 9488: FROM gl_aloc_inp a

9484: FROM gl_aloc_mst i
9485: WHERE i.alloc_id = a.alloc_id
9486: )
9487: ) mina
9488: FROM gl_aloc_inp a
9489: GROUP BY a.alloc_id
9490: ) y
9491: WHERE x.alloc_id(+) = y.mina
9492: GROUP BY y.alloc_id,

Line 9510: * Deleting referenced records and updating records in GL_ALOC_INP *

9506: * we have to delete the records from those tables as well. *
9507: **************************************************************************************************************/
9508:
9509: /******************************************************************
9510: * Deleting referenced records and updating records in GL_ALOC_INP *
9511: ******************************************************************/
9512:
9513: FOR i IN c_gl_aloc_inp LOOP
9514: IF i.cnt > 0 THEN

Line 9513: FOR i IN c_gl_aloc_inp LOOP

9509: /******************************************************************
9510: * Deleting referenced records and updating records in GL_ALOC_INP *
9511: ******************************************************************/
9512:
9513: FOR i IN c_gl_aloc_inp LOOP
9514: IF i.cnt > 0 THEN
9515: UPDATE gl_aloc_inp a
9516: SET a.delete_mark = 1
9517: WHERE a.alloc_id = i.alloc_id

Line 9515: UPDATE gl_aloc_inp a

9511: ******************************************************************/
9512:
9513: FOR i IN c_gl_aloc_inp LOOP
9514: IF i.cnt > 0 THEN
9515: UPDATE gl_aloc_inp a
9516: SET a.delete_mark = 1
9517: WHERE a.alloc_id = i.alloc_id
9518: AND a.delete_mark <> 1;
9519: ELSE

Line 9520: UPDATE gl_aloc_inp a

9516: SET a.delete_mark = 1
9517: WHERE a.alloc_id = i.alloc_id
9518: AND a.delete_mark <> 1;
9519: ELSE
9520: UPDATE gl_aloc_inp a
9521: SET a.alloc_id = i.mina
9522: WHERE a.alloc_id = i.alloc_id
9523: AND a.delete_mark <> 1;
9524: END IF;

Line 9528: G_Table_name := 'GL_ALOC_INP';

9524: END IF;
9525: END LOOP;
9526:
9527: G_Migration_run_id := P_migration_run_id;
9528: G_Table_name := 'GL_ALOC_INP';
9529: G_Context := 'Expense Allocation Inputs Migration';
9530: X_failure_count := 0;
9531:
9532: /********************************

Line 9548: * Update a row in GL_ALOC_INP for Account Codes *

9544: p_app_short_name => 'GMA'
9545: );
9546:
9547: /**********************************************************
9548: * Update a row in GL_ALOC_INP for Account Codes *
9549: **********************************************************/
9550:
9551: BEGIN
9552:

Line 9553: UPDATE gl_aloc_inp a

9549: **********************************************************/
9550:
9551: BEGIN
9552:
9553: UPDATE gl_aloc_inp a
9554: SET a.account_id = (
9555: SELECT gmf_migration.get_account_id(a.account_key, x.co_code)
9556: FROM gl_aloc_mst x
9557: WHERE x.alloc_id = a.alloc_id

Line 9611: FROM gl_aloc_inp

9607: **********************************************/
9608:
9609: SELECT count(*)
9610: INTO x_failure_count
9611: FROM gl_aloc_inp
9612: WHERE (account_id IS NULL AND account_key IS NOT NULL);
9613:
9614: IF nvl(x_failure_count,0) > 0 THEN
9615:

Line 10244: CURSOR c_gl_aloc_inp

10240: y.mina
10241: HAVING y.alloc_id <> y.mina;
10242: /* USKUMARI Bug 14614554 */
10243: /*
10244: CURSOR c_gl_aloc_inp
10245: IS
10246: SELECT y.alloc_id,
10247: y.mina,
10248: count(x.alloc_id) cnt

Line 10249: FROM gl_aloc_inp x, (

10245: IS
10246: SELECT y.alloc_id,
10247: y.mina,
10248: count(x.alloc_id) cnt
10249: FROM gl_aloc_inp x, (
10250: SELECT a.alloc_id,
10251: (
10252: SELECT MIN(h.alloc_id)
10253: FROM gl_aloc_mst h

Line 10260: FROM gl_aloc_inp a

10256: FROM gl_aloc_mst i
10257: WHERE i.alloc_id = a.alloc_id
10258: )
10259: ) mina
10260: FROM gl_aloc_inp a
10261: GROUP BY a.alloc_id
10262: ) y
10263: WHERE x.alloc_id(+) = y.mina
10264: GROUP BY y.alloc_id,

Line 10362: * Deleting referenced records and updating records in GL_ALOC_INP *

10358: END LOOP;
10359:
10360: /* USKUMARI Bug 14614554 */
10361: /******************************************************************
10362: * Deleting referenced records and updating records in GL_ALOC_INP *
10363: ******************************************************************/
10364: /*
10365: FOR i IN c_gl_aloc_inp LOOP
10366: IF i.cnt > 0 THEN

Line 10365: FOR i IN c_gl_aloc_inp LOOP

10361: /******************************************************************
10362: * Deleting referenced records and updating records in GL_ALOC_INP *
10363: ******************************************************************/
10364: /*
10365: FOR i IN c_gl_aloc_inp LOOP
10366: IF i.cnt > 0 THEN
10367: UPDATE gl_aloc_inp a
10368: SET a.delete_mark = 1
10369: WHERE a.alloc_id = i.alloc_id

Line 10367: UPDATE gl_aloc_inp a

10363: ******************************************************************/
10364: /*
10365: FOR i IN c_gl_aloc_inp LOOP
10366: IF i.cnt > 0 THEN
10367: UPDATE gl_aloc_inp a
10368: SET a.delete_mark = 1
10369: WHERE a.alloc_id = i.alloc_id
10370: AND a.delete_mark <> 1;
10371: ELSE

Line 10372: UPDATE gl_aloc_inp a

10368: SET a.delete_mark = 1
10369: WHERE a.alloc_id = i.alloc_id
10370: AND a.delete_mark <> 1;
10371: ELSE
10372: UPDATE gl_aloc_inp a
10373: SET a.alloc_id = i.mina
10374: WHERE a.alloc_id = i.alloc_id
10375: AND a.delete_mark <> 1;
10376: END IF;