APPS.GMF_MIGRATION dependencies on GL_ALOC_EXP

Line 6208: G_Table_name := 'GL_ALOC_EXP';

6204:
6205: BEGIN
6206:
6207: G_Migration_run_id := P_migration_run_id;
6208: G_Table_name := 'GL_ALOC_EXP';
6209: G_Context := 'Expense Allocation Expenses Migration';
6210: X_failure_count := 0;
6211:
6212: /********************************

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

6225: );
6226:
6227:
6228: /**********************************************************
6229: * Update a row in GL_ALOC_EXP for Account Codes *
6230: **********************************************************/
6231:
6232: BEGIN
6233: UPDATE gl_aloc_exp a

Line 6233: UPDATE gl_aloc_exp a

6229: * Update a row in GL_ALOC_EXP for Account Codes *
6230: **********************************************************/
6231:
6232: BEGIN
6233: UPDATE gl_aloc_exp a
6234: SET (
6235: a.from_account_id,
6236: a.to_account_id
6237: )

Line 6296: FROM gl_aloc_exp

6292: **********************************************/
6293:
6294: SELECT count(*)
6295: INTO x_failure_count
6296: FROM gl_aloc_exp
6297: WHERE (
6298: (from_account_id IS NULL AND from_account IS NOT NULL)
6299: OR (to_account_id IS NULL AND to_account IS NOT NULL)
6300: );

Line 9891: CURSOR c_gl_aloc_exp

9887: x.alloc_id,
9888: y.mina
9889: HAVING y.alloc_id <> y.mina;
9890:
9891: CURSOR c_gl_aloc_exp
9892: IS
9893: SELECT y.alloc_id,
9894: y.mina,
9895: count(x.alloc_id) cnt

Line 9896: FROM gl_aloc_exp x, (

9892: IS
9893: SELECT y.alloc_id,
9894: y.mina,
9895: count(x.alloc_id) cnt
9896: FROM gl_aloc_exp x, (
9897: SELECT a.alloc_id,
9898: (
9899: SELECT MIN(h.alloc_id)
9900: FROM gl_aloc_mst h

Line 9907: FROM gl_aloc_exp a

9903: FROM gl_aloc_mst i
9904: WHERE i.alloc_id = a.alloc_id
9905: )
9906: ) mina
9907: FROM gl_aloc_exp a
9908: GROUP BY a.alloc_id
9909: ) y
9910: WHERE x.alloc_id(+) = y.mina
9911: GROUP BY y.alloc_id,

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

10011: END IF;
10012: END LOOP;
10013:
10014: /******************************************************************
10015: * Deleting referenced records and updating records in GL_ALOC_EXP *
10016: ******************************************************************/
10017:
10018: FOR i IN c_gl_aloc_exp LOOP
10019: IF i.cnt > 0 THEN

Line 10018: FOR i IN c_gl_aloc_exp LOOP

10014: /******************************************************************
10015: * Deleting referenced records and updating records in GL_ALOC_EXP *
10016: ******************************************************************/
10017:
10018: FOR i IN c_gl_aloc_exp LOOP
10019: IF i.cnt > 0 THEN
10020: UPDATE gl_aloc_exp a
10021: SET a.delete_mark = 1
10022: WHERE a.alloc_id = i.alloc_id

Line 10020: UPDATE gl_aloc_exp a

10016: ******************************************************************/
10017:
10018: FOR i IN c_gl_aloc_exp LOOP
10019: IF i.cnt > 0 THEN
10020: UPDATE gl_aloc_exp a
10021: SET a.delete_mark = 1
10022: WHERE a.alloc_id = i.alloc_id
10023: AND a.delete_mark <> 1;
10024: ELSE

Line 10025: UPDATE gl_aloc_exp a

10021: SET a.delete_mark = 1
10022: WHERE a.alloc_id = i.alloc_id
10023: AND a.delete_mark <> 1;
10024: ELSE
10025: UPDATE gl_aloc_exp a
10026: SET a.alloc_id = i.mina
10027: WHERE a.alloc_id = i.alloc_id
10028: AND a.delete_mark <> 1;
10029: END IF;