APPS.GMF_MIGRATION dependencies on GL_ALOC_INP

Line 9208: G_Table_name := 'GL_ALOC_INP';

9204:
9205: BEGIN
9206:
9207: G_Migration_run_id := P_migration_run_id;
9208: G_Table_name := 'GL_ALOC_INP';
9209: G_Context := 'Expense Allocation Inputs Migration';
9210: X_failure_count := 0;
9211:
9212: /********************************

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

9224: p_app_short_name => 'GMA'
9225: );
9226:
9227: /**********************************************************
9228: * Update a row in GL_ALOC_INP for Account Codes *
9229: **********************************************************/
9230:
9231: BEGIN
9232:

Line 9233: UPDATE gl_aloc_inp a

9229: **********************************************************/
9230:
9231: BEGIN
9232:
9233: UPDATE gl_aloc_inp a
9234: SET a.account_id = (
9235: SELECT gmf_migration.get_account_id(a.account_key, x.co_code)
9236: FROM gl_aloc_mst x
9237: WHERE x.alloc_id = a.alloc_id

Line 9291: FROM gl_aloc_inp

9287: **********************************************/
9288:
9289: SELECT count(*)
9290: INTO x_failure_count
9291: FROM gl_aloc_inp
9292: WHERE (account_id IS NULL AND account_key IS NOT NULL);
9293:
9294: IF nvl(x_failure_count,0) > 0 THEN
9295:

Line 9916: CURSOR c_gl_aloc_inp

9912: x.alloc_id,
9913: y.mina
9914: HAVING y.alloc_id <> y.mina;
9915:
9916: CURSOR c_gl_aloc_inp
9917: IS
9918: SELECT y.alloc_id,
9919: y.mina,
9920: count(x.alloc_id) cnt

Line 9921: FROM gl_aloc_inp x, (

9917: IS
9918: SELECT y.alloc_id,
9919: y.mina,
9920: count(x.alloc_id) cnt
9921: FROM gl_aloc_inp x, (
9922: SELECT a.alloc_id,
9923: (
9924: SELECT MIN(h.alloc_id)
9925: FROM gl_aloc_mst h

Line 9932: FROM gl_aloc_inp a

9928: FROM gl_aloc_mst i
9929: WHERE i.alloc_id = a.alloc_id
9930: )
9931: ) mina
9932: FROM gl_aloc_inp a
9933: GROUP BY a.alloc_id
9934: ) y
9935: WHERE x.alloc_id(+) = y.mina
9936: GROUP BY y.alloc_id,

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

10029: END IF;
10030: END LOOP;
10031:
10032: /******************************************************************
10033: * Deleting referenced records and updating records in GL_ALOC_INP *
10034: ******************************************************************/
10035:
10036: FOR i IN c_gl_aloc_inp LOOP
10037: IF i.cnt > 0 THEN

Line 10036: FOR i IN c_gl_aloc_inp LOOP

10032: /******************************************************************
10033: * Deleting referenced records and updating records in GL_ALOC_INP *
10034: ******************************************************************/
10035:
10036: FOR i IN c_gl_aloc_inp LOOP
10037: IF i.cnt > 0 THEN
10038: UPDATE gl_aloc_inp a
10039: SET a.delete_mark = 1
10040: WHERE a.alloc_id = i.alloc_id

Line 10038: UPDATE gl_aloc_inp a

10034: ******************************************************************/
10035:
10036: FOR i IN c_gl_aloc_inp LOOP
10037: IF i.cnt > 0 THEN
10038: UPDATE gl_aloc_inp a
10039: SET a.delete_mark = 1
10040: WHERE a.alloc_id = i.alloc_id
10041: AND a.delete_mark <> 1;
10042: ELSE

Line 10043: UPDATE gl_aloc_inp a

10039: SET a.delete_mark = 1
10040: WHERE a.alloc_id = i.alloc_id
10041: AND a.delete_mark <> 1;
10042: ELSE
10043: UPDATE gl_aloc_inp a
10044: SET a.alloc_id = i.mina
10045: WHERE a.alloc_id = i.alloc_id
10046: AND a.delete_mark <> 1;
10047: END IF;