APPS.GMF_MIGRATION dependencies on GL_ALOC_EXP

Line 6285: G_Table_name := 'GL_ALOC_EXP';

6281:
6282: BEGIN
6283:
6284: G_Migration_run_id := P_migration_run_id;
6285: G_Table_name := 'GL_ALOC_EXP';
6286: G_Context := 'Expense Allocation Expenses Migration';
6287: X_failure_count := 0;
6288:
6289: /********************************

Line 6306: * Update a row in GL_ALOC_EXP for Account Codes *

6302: );
6303:
6304:
6305: /**********************************************************
6306: * Update a row in GL_ALOC_EXP for Account Codes *
6307: **********************************************************/
6308:
6309: BEGIN
6310: UPDATE gl_aloc_exp a

Line 6310: UPDATE gl_aloc_exp a

6306: * Update a row in GL_ALOC_EXP for Account Codes *
6307: **********************************************************/
6308:
6309: BEGIN
6310: UPDATE gl_aloc_exp a
6311: SET (
6312: a.from_account_id,
6313: a.to_account_id
6314: )

Line 6373: FROM gl_aloc_exp

6369: **********************************************/
6370:
6371: SELECT count(*)
6372: INTO x_failure_count
6373: FROM gl_aloc_exp
6374: WHERE (
6375: (from_account_id IS NULL AND from_account IS NOT NULL)
6376: OR (to_account_id IS NULL AND to_account IS NOT NULL)
6377: );

Line 10218: CURSOR c_gl_aloc_exp

10214: x.alloc_id,
10215: y.mina
10216: HAVING y.alloc_id <> y.mina;
10217:
10218: CURSOR c_gl_aloc_exp
10219: IS
10220: SELECT y.alloc_id,
10221: y.mina,
10222: count(x.alloc_id) cnt

Line 10223: FROM gl_aloc_exp x, (

10219: IS
10220: SELECT y.alloc_id,
10221: y.mina,
10222: count(x.alloc_id) cnt
10223: FROM gl_aloc_exp x, (
10224: SELECT a.alloc_id,
10225: (
10226: SELECT MIN(h.alloc_id)
10227: FROM gl_aloc_mst h

Line 10234: FROM gl_aloc_exp a

10230: FROM gl_aloc_mst i
10231: WHERE i.alloc_id = a.alloc_id
10232: )
10233: ) mina
10234: FROM gl_aloc_exp a
10235: GROUP BY a.alloc_id
10236: ) y
10237: WHERE x.alloc_id(+) = y.mina
10238: GROUP BY y.alloc_id,

Line 10343: * Deleting referenced records and updating records in GL_ALOC_EXP *

10339: END IF;
10340: END LOOP;
10341:
10342: /******************************************************************
10343: * Deleting referenced records and updating records in GL_ALOC_EXP *
10344: ******************************************************************/
10345:
10346: FOR i IN c_gl_aloc_exp LOOP
10347: IF i.cnt > 0 THEN

Line 10346: FOR i IN c_gl_aloc_exp LOOP

10342: /******************************************************************
10343: * Deleting referenced records and updating records in GL_ALOC_EXP *
10344: ******************************************************************/
10345:
10346: FOR i IN c_gl_aloc_exp LOOP
10347: IF i.cnt > 0 THEN
10348: UPDATE gl_aloc_exp a
10349: SET a.delete_mark = 1
10350: WHERE a.alloc_id = i.alloc_id

Line 10348: UPDATE gl_aloc_exp a

10344: ******************************************************************/
10345:
10346: FOR i IN c_gl_aloc_exp LOOP
10347: IF i.cnt > 0 THEN
10348: UPDATE gl_aloc_exp a
10349: SET a.delete_mark = 1
10350: WHERE a.alloc_id = i.alloc_id
10351: AND a.delete_mark <> 1;
10352: ELSE

Line 10353: UPDATE gl_aloc_exp a

10349: SET a.delete_mark = 1
10350: WHERE a.alloc_id = i.alloc_id
10351: AND a.delete_mark <> 1;
10352: ELSE
10353: UPDATE gl_aloc_exp a
10354: SET a.alloc_id = i.mina
10355: WHERE a.alloc_id = i.alloc_id
10356: AND a.delete_mark <> 1;
10357: END IF;