eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_UPGRADE_PUB dependencies on GL_PERIOD_STATUSES

Line 741: update gl_period_statuses

737: if ( l_set_of_books_id is null ) then
738:
739: if (l_period_name is null and l_period_year is null) then
740:
741: update gl_period_statuses
742: set migration_status_code = 'U'
743: where application_id = l_application_id
744: and migration_status_code = 'P';
745:

Line 752: update gl_period_statuses

748: return p_status_code;
749:
750: elsif l_period_name is null then
751:
752: update gl_period_statuses
753: set migration_status_code = 'U'
754: where period_year = l_period_year
755: and migration_status_code = 'P'
756: and application_id = l_application_id;

Line 764: update gl_period_statuses

760: return p_status_code;
761:
762: elsif l_period_year is null then
763:
764: update gl_period_statuses
765: set migration_status_code = 'U'
766: where period_name = l_period_name
767: and migration_status_code = 'P'
768: and application_id = l_application_id;

Line 776: update gl_period_statuses

772: return p_status_code;
773:
774: elsif (l_period_name is not null and l_period_year is not null) then
775:
776: update gl_period_statuses
777: set migration_status_code = 'U'
778: where period_year = l_period_year
779: and period_name = l_period_name
780: and migration_status_code = 'P'

Line 795: update gl_period_statuses

791: /* Set_Of_Books_ID is not null */
792:
793: if (l_period_name is null and l_period_year is null) then
794:
795: update gl_period_statuses
796: set migration_status_code = 'U'
797: where application_id = l_application_id
798: and migration_status_code = 'P'
799: and ledger_id = l_set_of_books_id;

Line 807: update gl_period_statuses

803: return p_status_code;
804:
805: elsif l_period_name is null then
806:
807: update gl_period_statuses
808: set migration_status_code = 'U'
809: where period_year = l_period_year
810: and migration_status_code = 'P'
811: and ledger_id = l_set_of_books_id

Line 820: update gl_period_statuses

816: return p_status_code;
817:
818: elsif l_period_year is null then
819:
820: update gl_period_statuses
821: set migration_status_code = 'U'
822: where period_name = l_period_name
823: and migration_status_code = 'P'
824: and ledger_id = l_set_of_books_id

Line 833: update gl_period_statuses

829: return p_status_code;
830:
831: elsif (l_period_name is not null and l_period_year is not null) then
832:
833: update gl_period_statuses
834: set migration_status_code = 'U'
835: where period_year = l_period_year
836: and period_name = l_period_name
837: and migration_status_code = 'P'

Line 971: -- no rows in GL_PERIOD_STATUSES corresponding to Application ID 707.

967: -- l_application_id :=101;
968: -- END IF;
969:
970: -- Check with application id 707 is done separately, since there will be
971: -- no rows in GL_PERIOD_STATUSES corresponding to Application ID 707.
972: -- Associated Applications are 201 (PO) and 401 (INV).
973:
974: -- IF p_application_id = 707 then
975:

Line 976: -- Since Application ID 707 will have no rows in GL_PERIOD_STATUSES

972: -- Associated Applications are 201 (PO) and 401 (INV).
973:
974: -- IF p_application_id = 707 then
975:
976: -- Since Application ID 707 will have no rows in GL_PERIOD_STATUSES
977: -- we are getting the minimum of start date for one of the two
978: -- applications which are associated with Costing (707)
979:
980: -- SELECT start_date

Line 982: -- FROM gl_period_statuses

978: -- applications which are associated with Costing (707)
979:
980: -- SELECT start_date
981: -- INTO l_start_date
982: -- FROM gl_period_statuses
983: -- WHERE application_id = 401
984: -- AND ledger_id = p_ledger_id
985: -- AND period_name = p_period_name;
986:

Line 996: -- FROM gl_period_statuses

992: -- END IF;
993:
994: -- SELECT min(start_date)
995: -- INTO l_end_date
996: -- FROM gl_period_statuses
997: -- WHERE migration_status_code = 'U'
998: -- AND ledger_id = p_ledger_id
999: -- AND application_id = 401;
1000:

Line 1016: -- Updation of GL Period Statuses.

1012: -- IF l_end_date is NULL THEN
1013: -- RAISE NO_UPGRADE;
1014: -- END IF;
1015:
1016: -- Updation of GL Period Statuses.
1017:
1018: -- UPDATE gl_period_statuses
1019: -- SET migration_status_code = 'P'
1020: -- WHERE ledger_id = l_ledger_id

Line 1018: -- UPDATE gl_period_statuses

1014: -- END IF;
1015:
1016: -- Updation of GL Period Statuses.
1017:
1018: -- UPDATE gl_period_statuses
1019: -- SET migration_status_code = 'P'
1020: -- WHERE ledger_id = l_ledger_id
1021: -- AND (start_date >= l_start_date
1022: -- and end_date < l_end_date)

Line 1030: -- trace('Updated gl_period_statuses. '

1026:
1027: --fnd_file.put_line(fnd_file.log, '*Periods updated to P : '|| to_char(SQL%ROWCOUNT));
1028:
1029: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1030: -- trace('Updated gl_period_statuses. '
1031: -- , C_LEVEL_STATEMENT, l_Log_module);
1032: -- END IF;
1033:
1034: -- ELSE /*End for 707 Case and begin for all other applications*/

Line 1041: -- FROM gl_period_statuses

1037: -- has to be migrated.
1038:
1039: -- SELECT start_date
1040: -- INTO l_start_date
1041: -- FROM gl_period_statuses
1042: -- WHERE application_id = l_application_id
1043: -- AND ledger_id = p_ledger_id
1044: -- AND period_name = p_period_name;
1045:

Line 1058: -- FROM gl_period_statuses

1054: -- was migrated.
1055:
1056: -- SELECT min(start_date)
1057: -- INTO l_end_date
1058: -- FROM gl_period_statuses
1059: -- WHERE migration_status_code = 'U'
1060: -- AND ledger_id = p_ledger_id
1061: -- AND application_id = l_application_id;
1062:

Line 1074: -- UPDATE gl_period_statuses

1070: -- trace('Ending date of upgrade '|| l_end_date,
1071: -- C_LEVEL_STATEMENT, l_Log_module);
1072: -- END IF;
1073:
1074: -- UPDATE gl_period_statuses
1075: -- SET migration_status_code = 'P'
1076: -- WHERE application_id = l_application_id
1077: -- AND ledger_id = l_ledger_id
1078: -- AND (start_date >= l_start_date

Line 1086: -- trace('Updated gl_period_statuses',

1082:
1083: --fnd_file.put_line(fnd_file.log, '*Periods updated to P : '|| to_char(SQL%ROWCOUNT));
1084:
1085: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1086: -- trace('Updated gl_period_statuses',
1087: -- C_LEVEL_STATEMENT, l_Log_module);
1088: -- END IF;
1089:
1090: -- END IF;

Line 1214: -- FROM gl_period_statuses b

1210: -- SET a.je_from_sla_flag = 'U'
1211: -- WHERE (decode(a.je_source, l_source_name, p_application_id)
1212: -- ,ledger_id, period_name) in
1213: -- (SELECT application_id, ledger_id, period_name
1214: -- FROM gl_period_statuses b
1215: -- WHERE b.start_date >= l_start_date
1216: -- AND b.end_date < l_end_date
1217: -- AND b.ledger_id = l_ledger_id
1218: -- AND application_id = p_application_id)

Line 1235: -- FROM gl_period_statuses b

1231: -- SET a.je_from_sla_flag = 'U'
1232: -- WHERE (decode(a.je_source,'Purchasing',201,'Inventory',401)
1233: -- ,ledger_id, period_name) in
1234: -- (SELECT application_id, ledger_id, period_name
1235: -- FROM gl_period_statuses b
1236: -- WHERE b.start_date >= l_start_date
1237: -- AND b.end_date < l_end_date
1238: -- AND b.ledger_id = l_ledger_id
1239: -- AND application_id in (201,401))

Line 1256: -- UPDATE gl_period_statuses

1252: -- ELSE
1253:
1254: -- IF p_application_id = 707 THEN
1255:
1256: -- UPDATE gl_period_statuses
1257: -- SET migration_status_code = NULL
1258: -- WHERE ledger_id = l_ledger_id
1259: -- AND (start_date >= l_start_date
1260: -- and end_date < l_end_date)

Line 1269: -- UPDATE gl_period_statuses

1265: --fnd_file.put_line(fnd_file.log, '*Migration status code back to NULL : '|| to_char(SQL%ROWCOUNT));
1266:
1267: -- ELSE
1268:
1269: -- UPDATE gl_period_statuses
1270: -- SET migration_status_code = NULL
1271: -- WHERE application_id = l_application_id
1272: -- AND ledger_id = l_ledger_id
1273: -- AND (start_date >= l_start_date

Line 1759: FROM gl_period_statuses;

1755: p_start_date IN VARCHAR2
1756: ) IS
1757:
1758: CURSOR CUR_ALL_LEDGERS IS SELECT DISTINCT ledger_id
1759: FROM gl_period_statuses;
1760:
1761: l_migrate_all_ledgers VARCHAR2(30);
1762: l_ledger_id NUMBER;
1763: l_start_date date;

Line 1813: FROM gl_period_statuses

1809: IF l_migrate_all_ledgers = 'N' THEN
1810:
1811: SELECT min(start_date) - 1
1812: INTO l_end_date
1813: FROM gl_period_statuses
1814: WHERE migration_status_code = 'P'
1815: AND ledger_id = l_ledger_id
1816: AND application_id in (200,222,275,201,401,101,8721);
1817:

Line 1822: FROM gl_period_statuses

1818: IF l_end_date is NULL THEN
1819:
1820: SELECT max(end_date)
1821: INTO l_end_date
1822: FROM gl_period_statuses
1823: WHERE ledger_id = l_ledger_id
1824: AND application_id IN (200,222,275,201,401,101,8721);
1825: END IF;
1826:

Line 1827: UPDATE gl_period_statuses

1823: WHERE ledger_id = l_ledger_id
1824: AND application_id IN (200,222,275,201,401,101,8721);
1825: END IF;
1826:
1827: UPDATE gl_period_statuses
1828: SET migration_status_code = 'P'
1829: WHERE ledger_id = l_ledger_id
1830: AND (start_date >= l_start_date
1831: and end_date <= l_end_date)

Line 1845: FROM gl_period_statuses

1841: EXIT when CUR_ALL_LEDGERS%notfound;
1842:
1843: SELECT min(start_date) - 1
1844: INTO l_end_date
1845: FROM gl_period_statuses
1846: WHERE migration_status_code = 'P'
1847: AND ledger_id = l_all_ledgers.ledger_id
1848: AND application_id in (200,222,275,201,401,101,8721);
1849:

Line 1854: FROM gl_period_statuses

1850: IF l_end_date is NULL THEN
1851:
1852: SELECT max(end_date)
1853: INTO l_end_date
1854: FROM gl_period_statuses
1855: WHERE ledger_id = l_all_ledgers.ledger_id
1856: AND application_id in (200,222,275,201,401,101,8721);
1857:
1858: END IF;

Line 1860: -- Updation of GL Period Statuses.

1856: AND application_id in (200,222,275,201,401,101,8721);
1857:
1858: END IF;
1859:
1860: -- Updation of GL Period Statuses.
1861:
1862: UPDATE gl_period_statuses
1863: SET migration_status_code = 'P'
1864: WHERE ledger_id = l_all_ledgers.ledger_id

Line 1862: UPDATE gl_period_statuses

1858: END IF;
1859:
1860: -- Updation of GL Period Statuses.
1861:
1862: UPDATE gl_period_statuses
1863: SET migration_status_code = 'P'
1864: WHERE ledger_id = l_all_ledgers.ledger_id
1865: AND (start_date >= l_start_date
1866: and end_date <= l_end_date)

Line 1873: trace('Updated gl_period_statuses.'

1869: AND migration_status_code IS NULL;
1870:
1871:
1872: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1873: trace('Updated gl_period_statuses.'
1874: , C_LEVEL_STATEMENT, l_Log_module);
1875: END IF;
1876:
1877: END LOOP;