APPS.XLA_UPGRADE_PUB dependencies on GL_JE_HEADERS

Line 31: | GL_JE_HEADERS. |

27: | Herve Yu's confirmation by mail. |
28: | 25-May-06 Jorge Larre Bug 5222005: populate l_source_name from |
29: | XLA_SUBLEDGERS instead of populating l_application_name from |
30: | FND_APPLICATIONS_VL, and use it to select the lines to update in |
31: | GL_JE_HEADERS. |
32: | 17-Aug-2006 Jorge Larre Bug 5468416: Add a parameter of type VARCHAR2 |
33: | to call the Costing upgrade program. |
34: | 24-Aug-2006 Jorge Larre Bug 5473838: when calling the Costing upgrade |
35: | program, X_init_msg_list must be passed the value FND_API.G_FALSE. |

Line 1740: UPDATE gl_je_headers a

1736:
1737: fnd_file.Put_line(fnd_file.LOG,'*Source name : '|| l_source_name);
1738:
1739: FORALL i IN 1..g_array_ledger_id.COUNT
1740: UPDATE gl_je_headers a
1741: SET a.je_from_sla_flag = decode(a.reversed_je_header_id,null,'U','N') ,
1742: a.je_source = Decode(a.je_source,'Inventory','Cost Management',
1743: 'Purchasing','Cost Management',
1744: je_source),

Line 1771: Trace('Updated gl_je_headers',c_level_statement,l_log_module);

1767:
1768: fnd_file.Put_line(fnd_file.LOG,'*Flags updated to U : '||To_char(SQL%ROWCOUNT));
1769:
1770: IF (c_level_statement >= g_log_level) THEN
1771: Trace('Updated gl_je_headers',c_level_statement,l_log_module);
1772: END IF;
1773: END IF;
1774: ELSE
1775: -- Upgrade The Request Status as ERROR

Line 2253: -- Updating gl_je_headers

2249: -- END IF;
2250:
2251: -- END IF;
2252:
2253: -- Updating gl_je_headers
2254: -- Check to ensure rows are not updated if process errors out
2255:
2256: -- IF l_retcode = 0 THEN
2257: /* means no error in the upgrade */

Line 2268: -- UPDATE gl_je_headers a

2264: -- WHERE application_id = p_application_id;
2265:
2266: --fnd_file.put_line(fnd_file.log, '*Source name : '|| l_source_name);
2267:
2268: -- UPDATE gl_je_headers a
2269: -- SET a.je_from_sla_flag = 'U'
2270: -- WHERE (decode(a.je_source, l_source_name, p_application_id)
2271: -- ,ledger_id, period_name) in
2272: -- (SELECT application_id, ledger_id, period_name

Line 2283: -- trace('Updated gl_je_headers',

2279:
2280: --fnd_file.put_line(fnd_file.log, '*Flags updated to U : '|| to_char(SQL%ROWCOUNT));
2281:
2282: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2283: -- trace('Updated gl_je_headers',
2284: -- C_LEVEL_STATEMENT, l_Log_module);
2285: -- END IF;
2286:
2287: -- ELSE

Line 2289: -- UPDATE gl_je_headers a

2285: -- END IF;
2286:
2287: -- ELSE
2288:
2289: -- UPDATE gl_je_headers a
2290: -- SET a.je_from_sla_flag = 'U'
2291: -- WHERE (decode(a.je_source,'Purchasing',201,'Inventory',401)
2292: -- ,ledger_id, period_name) in
2293: -- (SELECT application_id, ledger_id, period_name

Line 2304: -- trace('Updated gl_je_headers',

2300:
2301: --fnd_file.put_line(fnd_file.log, '*Flags updated to U : '|| to_char(SQL%ROWCOUNT));
2302:
2303: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2304: -- trace('Updated gl_je_headers',
2305: -- C_LEVEL_STATEMENT, l_Log_module);
2306: -- END IF;
2307:
2308: -- COMMIT;