APPS.XLA_UPGRADE_PUB dependencies on XLA_SUBLEDGERS

Line 29: | XLA_SUBLEDGERS instead of populating l_application_name from |

25: | 16-May-06 Jorge Larre Add pre_upgrade_set_status_code |
26: | 19-May-06 Jorge Larre Add the call to AR upgrade program as per |
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. |

Line 1010: l_source_name xla_subledgers.je_source_name%TYPE;

1006: p_number_of_workers IN NUMBER,
1007: p_batch_size IN NUMBER)
1008: IS
1009: l_application_id NUMBER;
1010: l_source_name xla_subledgers.je_source_name%TYPE;
1011: l_application_name fnd_application_vl.application_name%TYPE;
1012: l_ledger_id NUMBER;
1013: l_period_name VARCHAR2(15);
1014: l_upgraded_period_name VARCHAR2(15);

Line 1734: FROM xla_subledgers

1730: -- Upgdate the GL Journal's JE_FROM_SLA_FLAG as Upgraded.
1731: IF p_application_id NOT IN (200,275) THEN
1732: SELECT je_source_name
1733: INTO l_source_name
1734: FROM xla_subledgers
1735: WHERE application_id = p_application_id;
1736:
1737: fnd_file.Put_line(fnd_file.LOG,'*Source name : '|| l_source_name);
1738:

Line 1765: FROM xla_subledgers xsu

1761: AND a.je_from_sla_flag IS NULL
1762: AND a.je_source <> 'Project Accounting'
1763: AND a.actual_flag = 'A'
1764: AND EXISTS (SELECT 1
1765: FROM xla_subledgers xsu
1766: WHERE xsu.je_source_name = a.je_source);
1767:
1768: fnd_file.Put_line(fnd_file.LOG,'*Flags updated to U : '||To_char(SQL%ROWCOUNT));
1769:

Line 1950: --l_source_name XLA_SUBLEDGERS.JE_SOURCE_NAME%TYPE;

1946: -- p_number_of_workers IN NUMBER,
1947: -- p_batch_size IN NUMBER) IS
1948:
1949: --l_application_id NUMBER;
1950: --l_source_name XLA_SUBLEDGERS.JE_SOURCE_NAME%TYPE;
1951: --l_application_name FND_APPLICATION_VL.APPLICATION_NAME%TYPE;
1952: --l_ledger_id NUMBER;
1953: --l_period_name VARCHAR2(15) ;
1954: --l_batch_size NUMBER;

Line 2263: -- FROM XLA_SUBLEDGERS

2259: -- IF p_application_id <> 707 THEN
2260:
2261: -- SELECT je_source_name
2262: -- INTO l_source_name
2263: -- FROM XLA_SUBLEDGERS
2264: -- WHERE application_id = p_application_id;
2265:
2266: --fnd_file.put_line(fnd_file.log, '*Source name : '|| l_source_name);
2267: