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.ZX_FC_MIGRATE_PKG dependencies on FND_GLOBAL

Line 586: fnd_global.user_id,

582: 'N',
583: start_date_active,
584: NULL,
585: fnd.LOOKUP_CODE,
586: fnd_global.user_id,
587: SYSDATE,
588: fnd_global.user_id,
589: SYSDATE,
590: FND_GLOBAL.CONC_LOGIN_ID

Line 588: fnd_global.user_id,

584: NULL,
585: fnd.LOOKUP_CODE,
586: fnd_global.user_id,
587: SYSDATE,
588: fnd_global.user_id,
589: SYSDATE,
590: FND_GLOBAL.CONC_LOGIN_ID
591: FROM fnd_lookup_values fnd
592: WHERE lookup_type = l_lookup_type

Line 590: FND_GLOBAL.CONC_LOGIN_ID

586: fnd_global.user_id,
587: SYSDATE,
588: fnd_global.user_id,
589: SYSDATE,
590: FND_GLOBAL.CONC_LOGIN_ID
591: FROM fnd_lookup_values fnd
592: WHERE lookup_type = l_lookup_type
593: AND language=userenv('lang') -- Bug 6441455
594: AND enabled_flag = 'Y'

Line 617: fnd_global.user_id,

613: fnd.LANGUAGE,
614: fnd.source_lang,
615: fnd.Meaning,
616: SYSDATE,
617: fnd_global.user_id,
618: SYSDATE,
619: fnd_global.user_id,
620: FND_GLOBAL.CONC_LOGIN_ID
621: FROM fnd_lookup_values fnd, mtl_categories_b mtl

Line 619: fnd_global.user_id,

615: fnd.Meaning,
616: SYSDATE,
617: fnd_global.user_id,
618: SYSDATE,
619: fnd_global.user_id,
620: FND_GLOBAL.CONC_LOGIN_ID
621: FROM fnd_lookup_values fnd, mtl_categories_b mtl
622: WHERE lookup_type = l_lookup_type
623: AND FND.lookup_code = mtl.segment1

Line 620: FND_GLOBAL.CONC_LOGIN_ID

616: SYSDATE,
617: fnd_global.user_id,
618: SYSDATE,
619: fnd_global.user_id,
620: FND_GLOBAL.CONC_LOGIN_ID
621: FROM fnd_lookup_values fnd, mtl_categories_b mtl
622: WHERE lookup_type = l_lookup_type
623: AND FND.lookup_code = mtl.segment1
624: AND NOT EXISTS

Line 722: fnd_global.user_id,

718: 'STATISTICAL_CODE',
719: SYSDATE,
720: NULL,
721: 'MIGRATED',
722: fnd_global.user_id,
723: SYSDATE,
724: fnd_global.user_id,
725: SYSDATE,
726: FND_GLOBAL.CONC_LOGIN_ID,

Line 724: fnd_global.user_id,

720: NULL,
721: 'MIGRATED',
722: fnd_global.user_id,
723: SYSDATE,
724: fnd_global.user_id,
725: SYSDATE,
726: FND_GLOBAL.CONC_LOGIN_ID,
727: zx_fc_types_reg_assoc_s.nextval,
728: 1)

Line 726: FND_GLOBAL.CONC_LOGIN_ID,

722: fnd_global.user_id,
723: SYSDATE,
724: fnd_global.user_id,
725: SYSDATE,
726: FND_GLOBAL.CONC_LOGIN_ID,
727: zx_fc_types_reg_assoc_s.nextval,
728: 1)
729: SELECT unique tax_regime_code
730: FROM ZX_RATES_B rates,

Line 819: fnd_global.user_id,

815: 'FISCAL CLASSIFICATION CODE',--parent_classification_code
816: l_fc_id, --parent_classification_id
817: 'BR',
818: 'MIGRATED',
819: fnd_global.user_id,
820: SYSDATE,
821: fnd_global.user_id,
822: SYSDATE,
823: FND_GLOBAL.CONC_LOGIN_ID,

Line 821: fnd_global.user_id,

817: 'BR',
818: 'MIGRATED',
819: fnd_global.user_id,
820: SYSDATE,
821: fnd_global.user_id,
822: SYSDATE,
823: FND_GLOBAL.CONC_LOGIN_ID,
824: 1
825: FROM FND_LOOKUPS lookups

Line 823: FND_GLOBAL.CONC_LOGIN_ID,

819: fnd_global.user_id,
820: SYSDATE,
821: fnd_global.user_id,
822: SYSDATE,
823: FND_GLOBAL.CONC_LOGIN_ID,
824: 1
825: FROM FND_LOOKUPS lookups
826: WHERE lookups.LOOKUP_TYPE = 'JLZZ_AR_TX_FISCAL_CLASS_CODE'
827: AND NOT EXISTS -- this condition makes sure we dont duplicate data

Line 852: fnd_global.user_id,

848: CASE WHEN fc_name = UPPER(fc_name)
849: THEN Initcap(fc_name)
850: ELSE fc_name
851: END,
852: fnd_global.user_id,
853: SYSDATE,
854: fnd_global.user_id,
855: SYSDATE,
856: FND_GLOBAL.CONC_LOGIN_ID,

Line 854: fnd_global.user_id,

850: ELSE fc_name
851: END,
852: fnd_global.user_id,
853: SYSDATE,
854: fnd_global.user_id,
855: SYSDATE,
856: FND_GLOBAL.CONC_LOGIN_ID,
857: LANGUAGE,
858: SOURCE_LANGUAGE)

Line 856: FND_GLOBAL.CONC_LOGIN_ID,

852: fnd_global.user_id,
853: SYSDATE,
854: fnd_global.user_id,
855: SYSDATE,
856: FND_GLOBAL.CONC_LOGIN_ID,
857: LANGUAGE,
858: SOURCE_LANGUAGE)
859: INTO ZX_FC_CODES_DENORM_B(
860: CLASSIFICATION_TYPE_ID,

Line 947: fnd_global.user_id,

943: Null,
944: Null,
945: Null,
946: Null,
947: fnd_global.user_id,
948: SYSDATE,
949: fnd_global.user_id,
950: FND_GLOBAL.CONC_LOGIN_ID,
951: sysdate,

Line 949: fnd_global.user_id,

945: Null,
946: Null,
947: fnd_global.user_id,
948: SYSDATE,
949: fnd_global.user_id,
950: FND_GLOBAL.CONC_LOGIN_ID,
951: sysdate,
952: FND_GLOBAL.CONC_REQUEST_ID,
953: fnd_global.CONC_PROGRAM_ID,

Line 950: FND_GLOBAL.CONC_LOGIN_ID,

946: Null,
947: fnd_global.user_id,
948: SYSDATE,
949: fnd_global.user_id,
950: FND_GLOBAL.CONC_LOGIN_ID,
951: sysdate,
952: FND_GLOBAL.CONC_REQUEST_ID,
953: fnd_global.CONC_PROGRAM_ID,
954: 235,

Line 952: FND_GLOBAL.CONC_REQUEST_ID,

948: SYSDATE,
949: fnd_global.user_id,
950: FND_GLOBAL.CONC_LOGIN_ID,
951: sysdate,
952: FND_GLOBAL.CONC_REQUEST_ID,
953: fnd_global.CONC_PROGRAM_ID,
954: 235,
955: FND_GLOBAL.CONC_LOGIN_ID,
956: 'MIGRATED')

Line 953: fnd_global.CONC_PROGRAM_ID,

949: fnd_global.user_id,
950: FND_GLOBAL.CONC_LOGIN_ID,
951: sysdate,
952: FND_GLOBAL.CONC_REQUEST_ID,
953: fnd_global.CONC_PROGRAM_ID,
954: 235,
955: FND_GLOBAL.CONC_LOGIN_ID,
956: 'MIGRATED')
957:

Line 955: FND_GLOBAL.CONC_LOGIN_ID,

951: sysdate,
952: FND_GLOBAL.CONC_REQUEST_ID,
953: fnd_global.CONC_PROGRAM_ID,
954: 235,
955: FND_GLOBAL.CONC_LOGIN_ID,
956: 'MIGRATED')
957:
958: SELECT
959: FL.LOOKUP_CODE fc_code,

Line 1024: fnd_global.user_id,

1020: 'FISCAL_CLASSIFICATION',
1021: SYSDATE,
1022: NULL,
1023: 'MIGRATED',
1024: fnd_global.user_id,
1025: SYSDATE,
1026: fnd_global.user_id,
1027: SYSDATE,
1028: FND_GLOBAL.CONC_LOGIN_ID,

Line 1026: fnd_global.user_id,

1022: NULL,
1023: 'MIGRATED',
1024: fnd_global.user_id,
1025: SYSDATE,
1026: fnd_global.user_id,
1027: SYSDATE,
1028: FND_GLOBAL.CONC_LOGIN_ID,
1029: zx_fc_types_reg_assoc_s.nextval,
1030: 1)

Line 1028: FND_GLOBAL.CONC_LOGIN_ID,

1024: fnd_global.user_id,
1025: SYSDATE,
1026: fnd_global.user_id,
1027: SYSDATE,
1028: FND_GLOBAL.CONC_LOGIN_ID,
1029: zx_fc_types_reg_assoc_s.nextval,
1030: 1)
1031: SELECT
1032: unique tax_regime_code

Line 1141: fnd_global.user_id,

1137: null,----parent_classification_code
1138: null,----parent_classification_id
1139: 'BR',
1140: 'MIGRATED',
1141: fnd_global.user_id,
1142: SYSDATE,
1143: fnd_global.user_id,
1144: SYSDATE,
1145: FND_GLOBAL.CONC_LOGIN_ID,

Line 1143: fnd_global.user_id,

1139: 'BR',
1140: 'MIGRATED',
1141: fnd_global.user_id,
1142: SYSDATE,
1143: fnd_global.user_id,
1144: SYSDATE,
1145: FND_GLOBAL.CONC_LOGIN_ID,
1146: 1
1147: FROM JL_BR_AP_OPERATIONS JLBR

Line 1145: FND_GLOBAL.CONC_LOGIN_ID,

1141: fnd_global.user_id,
1142: SYSDATE,
1143: fnd_global.user_id,
1144: SYSDATE,
1145: FND_GLOBAL.CONC_LOGIN_ID,
1146: 1
1147: FROM JL_BR_AP_OPERATIONS JLBR
1148: WHERE NOT EXISTS
1149: -- this condition makes sure we dont duplicate data

Line 1173: fnd_global.user_id,

1169: CASE WHEN Meaning = UPPER(Meaning)
1170: THEN Initcap(Meaning)
1171: ELSE Meaning
1172: END,
1173: fnd_global.user_id,
1174: SYSDATE,
1175: fnd_global.user_id,
1176: SYSDATE,
1177: FND_GLOBAL.CONC_LOGIN_ID,

Line 1175: fnd_global.user_id,

1171: ELSE Meaning
1172: END,
1173: fnd_global.user_id,
1174: SYSDATE,
1175: fnd_global.user_id,
1176: SYSDATE,
1177: FND_GLOBAL.CONC_LOGIN_ID,
1178: lang_code,
1179: userenv('LANG'))

Line 1177: FND_GLOBAL.CONC_LOGIN_ID,

1173: fnd_global.user_id,
1174: SYSDATE,
1175: fnd_global.user_id,
1176: SYSDATE,
1177: FND_GLOBAL.CONC_LOGIN_ID,
1178: lang_code,
1179: userenv('LANG'))
1180: INTO ZX_FC_CODES_DENORM_B(
1181: CLASSIFICATION_TYPE_ID,

Line 1268: fnd_global.user_id,

1264: Null,
1265: Null,
1266: Null,
1267: Null,
1268: fnd_global.user_id,
1269: SYSDATE,
1270: fnd_global.user_id,
1271: FND_GLOBAL.CONC_LOGIN_ID,
1272: sysdate,

Line 1270: fnd_global.user_id,

1266: Null,
1267: Null,
1268: fnd_global.user_id,
1269: SYSDATE,
1270: fnd_global.user_id,
1271: FND_GLOBAL.CONC_LOGIN_ID,
1272: sysdate,
1273: FND_GLOBAL.CONC_REQUEST_ID,
1274: fnd_global.CONC_PROGRAM_ID,

Line 1271: FND_GLOBAL.CONC_LOGIN_ID,

1267: Null,
1268: fnd_global.user_id,
1269: SYSDATE,
1270: fnd_global.user_id,
1271: FND_GLOBAL.CONC_LOGIN_ID,
1272: sysdate,
1273: FND_GLOBAL.CONC_REQUEST_ID,
1274: fnd_global.CONC_PROGRAM_ID,
1275: 235,

Line 1273: FND_GLOBAL.CONC_REQUEST_ID,

1269: SYSDATE,
1270: fnd_global.user_id,
1271: FND_GLOBAL.CONC_LOGIN_ID,
1272: sysdate,
1273: FND_GLOBAL.CONC_REQUEST_ID,
1274: fnd_global.CONC_PROGRAM_ID,
1275: 235,
1276: FND_GLOBAL.CONC_LOGIN_ID,
1277: 'MIGRATED')

Line 1274: fnd_global.CONC_PROGRAM_ID,

1270: fnd_global.user_id,
1271: FND_GLOBAL.CONC_LOGIN_ID,
1272: sysdate,
1273: FND_GLOBAL.CONC_REQUEST_ID,
1274: fnd_global.CONC_PROGRAM_ID,
1275: 235,
1276: FND_GLOBAL.CONC_LOGIN_ID,
1277: 'MIGRATED')
1278: SELECT cfo_code Code,

Line 1276: FND_GLOBAL.CONC_LOGIN_ID,

1272: sysdate,
1273: FND_GLOBAL.CONC_REQUEST_ID,
1274: fnd_global.CONC_PROGRAM_ID,
1275: 235,
1276: FND_GLOBAL.CONC_LOGIN_ID,
1277: 'MIGRATED')
1278: SELECT cfo_code Code,
1279: NVL(cfo_description,cfo_code) Meaning,
1280: JLBR.creation_date ,

Line 1347: fnd_global.user_id,

1343: fc.classification_code,--parent_classification_code
1344: fc.classification_id, --parent_classification_id
1345: 'BR',
1346: 'MIGRATED',
1347: fnd_global.user_id,
1348: SYSDATE,
1349: fnd_global.user_id,
1350: SYSDATE,
1351: FND_GLOBAL.CONC_LOGIN_ID,

Line 1349: fnd_global.user_id,

1345: 'BR',
1346: 'MIGRATED',
1347: fnd_global.user_id,
1348: SYSDATE,
1349: fnd_global.user_id,
1350: SYSDATE,
1351: FND_GLOBAL.CONC_LOGIN_ID,
1352: 1
1353: FROM

Line 1351: FND_GLOBAL.CONC_LOGIN_ID,

1347: fnd_global.user_id,
1348: SYSDATE,
1349: fnd_global.user_id,
1350: SYSDATE,
1351: FND_GLOBAL.CONC_LOGIN_ID,
1352: 1
1353: FROM
1354: JL_BR_AP_OPERATIONS ap_op,
1355: ZX_FC_CODES_DENORM_B fc,

Line 1388: fnd_global.user_id,

1384: CASE WHEN Meaning = UPPER(Meaning)
1385: THEN Initcap(Meaning)
1386: ELSE Meaning
1387: END,
1388: fnd_global.user_id,
1389: SYSDATE,
1390: fnd_global.user_id,
1391: SYSDATE,
1392: FND_GLOBAL.CONC_LOGIN_ID,

Line 1390: fnd_global.user_id,

1386: ELSE Meaning
1387: END,
1388: fnd_global.user_id,
1389: SYSDATE,
1390: fnd_global.user_id,
1391: SYSDATE,
1392: FND_GLOBAL.CONC_LOGIN_ID,
1393: lang_code,
1394: userenv('LANG'))

Line 1392: FND_GLOBAL.CONC_LOGIN_ID,

1388: fnd_global.user_id,
1389: SYSDATE,
1390: fnd_global.user_id,
1391: SYSDATE,
1392: FND_GLOBAL.CONC_LOGIN_ID,
1393: lang_code,
1394: userenv('LANG'))
1395: INTO ZX_FC_CODES_DENORM_B(
1396: CLASSIFICATION_TYPE_ID,

Line 1483: fnd_global.user_id,

1479: Null,
1480: Null,
1481: Null,
1482: Null,
1483: fnd_global.user_id,
1484: SYSDATE,
1485: fnd_global.user_id,
1486: FND_GLOBAL.CONC_LOGIN_ID,
1487: sysdate,

Line 1485: fnd_global.user_id,

1481: Null,
1482: Null,
1483: fnd_global.user_id,
1484: SYSDATE,
1485: fnd_global.user_id,
1486: FND_GLOBAL.CONC_LOGIN_ID,
1487: sysdate,
1488: FND_GLOBAL.CONC_REQUEST_ID,
1489: fnd_global.CONC_PROGRAM_ID,

Line 1486: FND_GLOBAL.CONC_LOGIN_ID,

1482: Null,
1483: fnd_global.user_id,
1484: SYSDATE,
1485: fnd_global.user_id,
1486: FND_GLOBAL.CONC_LOGIN_ID,
1487: sysdate,
1488: FND_GLOBAL.CONC_REQUEST_ID,
1489: fnd_global.CONC_PROGRAM_ID,
1490: 235,

Line 1488: FND_GLOBAL.CONC_REQUEST_ID,

1484: SYSDATE,
1485: fnd_global.user_id,
1486: FND_GLOBAL.CONC_LOGIN_ID,
1487: sysdate,
1488: FND_GLOBAL.CONC_REQUEST_ID,
1489: fnd_global.CONC_PROGRAM_ID,
1490: 235,
1491: FND_GLOBAL.CONC_LOGIN_ID,
1492: 'MIGRATED')

Line 1489: fnd_global.CONC_PROGRAM_ID,

1485: fnd_global.user_id,
1486: FND_GLOBAL.CONC_LOGIN_ID,
1487: sysdate,
1488: FND_GLOBAL.CONC_REQUEST_ID,
1489: fnd_global.CONC_PROGRAM_ID,
1490: 235,
1491: FND_GLOBAL.CONC_LOGIN_ID,
1492: 'MIGRATED')
1493:

Line 1491: FND_GLOBAL.CONC_LOGIN_ID,

1487: sysdate,
1488: FND_GLOBAL.CONC_REQUEST_ID,
1489: fnd_global.CONC_PROGRAM_ID,
1490: 235,
1491: FND_GLOBAL.CONC_LOGIN_ID,
1492: 'MIGRATED')
1493:
1494: SELECT cfo_code Code,
1495: NVL(cfo_description,cfo_code) Meaning,

Line 1593: fnd_global.user_id,

1589: 'GUI TYPE', --parent_classification_code
1590: l_fc_id, --parent_classification_id
1591: 'TW',
1592: 'MIGRATED',
1593: fnd_global.user_id,
1594: SYSDATE,
1595: fnd_global.user_id,
1596: SYSDATE,
1597: FND_GLOBAL.CONC_LOGIN_ID,

Line 1595: fnd_global.user_id,

1591: 'TW',
1592: 'MIGRATED',
1593: fnd_global.user_id,
1594: SYSDATE,
1595: fnd_global.user_id,
1596: SYSDATE,
1597: FND_GLOBAL.CONC_LOGIN_ID,
1598: 1
1599:

Line 1597: FND_GLOBAL.CONC_LOGIN_ID,

1593: fnd_global.user_id,
1594: SYSDATE,
1595: fnd_global.user_id,
1596: SYSDATE,
1597: FND_GLOBAL.CONC_LOGIN_ID,
1598: 1
1599:
1600: FROM FND_LOOKUP_VALUES lookups
1601: WHERE lookups.lookup_type='JATW_GUI_TYPE'

Line 1629: fnd_global.user_id,

1625: CASE WHEN Meaning = UPPER(Meaning)
1626: THEN Initcap(Meaning)
1627: ELSE Meaning
1628: END,
1629: fnd_global.user_id,
1630: SYSDATE,
1631: fnd_global.user_id,
1632: SYSDATE,
1633: FND_GLOBAL.CONC_LOGIN_ID,

Line 1631: fnd_global.user_id,

1627: ELSE Meaning
1628: END,
1629: fnd_global.user_id,
1630: SYSDATE,
1631: fnd_global.user_id,
1632: SYSDATE,
1633: FND_GLOBAL.CONC_LOGIN_ID,
1634: language,
1635: source_lang)

Line 1633: FND_GLOBAL.CONC_LOGIN_ID,

1629: fnd_global.user_id,
1630: SYSDATE,
1631: fnd_global.user_id,
1632: SYSDATE,
1633: FND_GLOBAL.CONC_LOGIN_ID,
1634: language,
1635: source_lang)
1636:
1637: INTO ZX_FC_CODES_DENORM_B

Line 1725: fnd_global.user_id,

1721: Null,
1722: Null,
1723: Null,
1724: Null,
1725: fnd_global.user_id,
1726: SYSDATE,
1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,

Line 1727: fnd_global.user_id,

1723: Null,
1724: Null,
1725: fnd_global.user_id,
1726: SYSDATE,
1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,

Line 1728: FND_GLOBAL.CONC_LOGIN_ID,

1724: Null,
1725: fnd_global.user_id,
1726: SYSDATE,
1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,
1732: 235,

Line 1730: FND_GLOBAL.CONC_REQUEST_ID,

1726: SYSDATE,
1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,
1732: 235,
1733: FND_GLOBAL.CONC_LOGIN_ID,
1734: 'MIGRATED')

Line 1731: fnd_global.CONC_PROGRAM_ID,

1727: fnd_global.user_id,
1728: FND_GLOBAL.CONC_LOGIN_ID,
1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,
1732: 235,
1733: FND_GLOBAL.CONC_LOGIN_ID,
1734: 'MIGRATED')
1735: SELECT

Line 1733: FND_GLOBAL.CONC_LOGIN_ID,

1729: sysdate,
1730: FND_GLOBAL.CONC_REQUEST_ID,
1731: fnd_global.CONC_PROGRAM_ID,
1732: 235,
1733: FND_GLOBAL.CONC_LOGIN_ID,
1734: 'MIGRATED')
1735: SELECT
1736: lookup_code,
1737: meaning,

Line 1865: fnd_global.user_id,

1861: Null,
1862: Null,
1863: 'MIGRATED',
1864: zx_fc_country_defaults_s.nextval,
1865: fnd_global.user_id,
1866: SYSDATE,
1867: fnd_global.user_id,
1868: SYSDATE,
1869: FND_GLOBAL.CONC_LOGIN_ID,

Line 1867: fnd_global.user_id,

1863: 'MIGRATED',
1864: zx_fc_country_defaults_s.nextval,
1865: fnd_global.user_id,
1866: SYSDATE,
1867: fnd_global.user_id,
1868: SYSDATE,
1869: FND_GLOBAL.CONC_LOGIN_ID,
1870: 1
1871: FROM ZX_FC_TYPES_B

Line 1869: FND_GLOBAL.CONC_LOGIN_ID,

1865: fnd_global.user_id,
1866: SYSDATE,
1867: fnd_global.user_id,
1868: SYSDATE,
1869: FND_GLOBAL.CONC_LOGIN_ID,
1870: 1
1871: FROM ZX_FC_TYPES_B
1872: WHERE
1873: classification_type_code = 'STATISTICAL_CODE'

Line 1905: fnd_global.user_id,

1901: Null,
1902: Null,
1903: 'MIGRATED',
1904: zx_fc_country_defaults_s.nextval,
1905: fnd_global.user_id,
1906: SYSDATE,
1907: fnd_global.user_id,
1908: SYSDATE,
1909: FND_GLOBAL.CONC_LOGIN_ID,

Line 1907: fnd_global.user_id,

1903: 'MIGRATED',
1904: zx_fc_country_defaults_s.nextval,
1905: fnd_global.user_id,
1906: SYSDATE,
1907: fnd_global.user_id,
1908: SYSDATE,
1909: FND_GLOBAL.CONC_LOGIN_ID,
1910: 1
1911: FROM ZX_FC_TYPES_B

Line 1909: FND_GLOBAL.CONC_LOGIN_ID,

1905: fnd_global.user_id,
1906: SYSDATE,
1907: fnd_global.user_id,
1908: SYSDATE,
1909: FND_GLOBAL.CONC_LOGIN_ID,
1910: 1
1911: FROM ZX_FC_TYPES_B
1912: WHERE
1913: classification_type_code = 'STATISTICAL_CODE'

Line 1945: fnd_global.user_id,

1941: Null,
1942: Null,
1943: 'MIGRATED',
1944: zx_fc_country_defaults_s.nextval,
1945: fnd_global.user_id,
1946: SYSDATE,
1947: fnd_global.user_id,
1948: SYSDATE,
1949: FND_GLOBAL.CONC_LOGIN_ID,

Line 1947: fnd_global.user_id,

1943: 'MIGRATED',
1944: zx_fc_country_defaults_s.nextval,
1945: fnd_global.user_id,
1946: SYSDATE,
1947: fnd_global.user_id,
1948: SYSDATE,
1949: FND_GLOBAL.CONC_LOGIN_ID,
1950: 1
1951: FROM ZX_FC_TYPES_B

Line 1949: FND_GLOBAL.CONC_LOGIN_ID,

1945: fnd_global.user_id,
1946: SYSDATE,
1947: fnd_global.user_id,
1948: SYSDATE,
1949: FND_GLOBAL.CONC_LOGIN_ID,
1950: 1
1951: FROM ZX_FC_TYPES_B
1952: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1953: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'

Line 1984: fnd_global.user_id,

1980: Null,
1981: Null,
1982: 'MIGRATED',
1983: zx_fc_country_defaults_s.nextval,
1984: fnd_global.user_id,
1985: SYSDATE,
1986: fnd_global.user_id,
1987: SYSDATE,
1988: FND_GLOBAL.CONC_LOGIN_ID,

Line 1986: fnd_global.user_id,

1982: 'MIGRATED',
1983: zx_fc_country_defaults_s.nextval,
1984: fnd_global.user_id,
1985: SYSDATE,
1986: fnd_global.user_id,
1987: SYSDATE,
1988: FND_GLOBAL.CONC_LOGIN_ID,
1989: 1
1990: FROM ZX_FC_TYPES_B

Line 1988: FND_GLOBAL.CONC_LOGIN_ID,

1984: fnd_global.user_id,
1985: SYSDATE,
1986: fnd_global.user_id,
1987: SYSDATE,
1988: FND_GLOBAL.CONC_LOGIN_ID,
1989: 1
1990: FROM ZX_FC_TYPES_B
1991: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1992: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'

Line 2020: fnd_global.user_id,

2016: Null,
2017: Null,
2018: 'MIGRATED',
2019: zx_fc_country_defaults_s.nextval,
2020: fnd_global.user_id,
2021: SYSDATE,
2022: fnd_global.user_id,
2023: SYSDATE,
2024: FND_GLOBAL.CONC_LOGIN_ID,

Line 2022: fnd_global.user_id,

2018: 'MIGRATED',
2019: zx_fc_country_defaults_s.nextval,
2020: fnd_global.user_id,
2021: SYSDATE,
2022: fnd_global.user_id,
2023: SYSDATE,
2024: FND_GLOBAL.CONC_LOGIN_ID,
2025: 1
2026: FROM ZX_FC_TYPES_B

Line 2024: FND_GLOBAL.CONC_LOGIN_ID,

2020: fnd_global.user_id,
2021: SYSDATE,
2022: fnd_global.user_id,
2023: SYSDATE,
2024: FND_GLOBAL.CONC_LOGIN_ID,
2025: 1
2026: FROM ZX_FC_TYPES_B
2027: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
2028: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'

Line 2096: fnd_global.user_id,

2092: p_country_code,
2093: 'SEEDED',
2094: 120,
2095: SYSDATE,
2096: fnd_global.user_id,
2097: SYSDATE,
2098: FND_GLOBAL.CONC_LOGIN_ID,
2099: 1
2100: FROM DUAL

Line 2098: FND_GLOBAL.CONC_LOGIN_ID,

2094: 120,
2095: SYSDATE,
2096: fnd_global.user_id,
2097: SYSDATE,
2098: FND_GLOBAL.CONC_LOGIN_ID,
2099: 1
2100: FROM DUAL
2101: WHERE NOT EXISTS
2102: (select NULL from ZX_FC_CODES_B Codes where

Line 2126: fnd_global.user_id,

2122: CASE WHEN p_classification_name = UPPER(p_classification_name)
2123: THEN Initcap(p_classification_name)
2124: ELSE p_classification_name
2125: END,
2126: fnd_global.user_id,
2127: SYSDATE,
2128: fnd_global.user_id,
2129: SYSDATE,
2130: FND_GLOBAL.CONC_LOGIN_ID,

Line 2128: fnd_global.user_id,

2124: ELSE p_classification_name
2125: END,
2126: fnd_global.user_id,
2127: SYSDATE,
2128: fnd_global.user_id,
2129: SYSDATE,
2130: FND_GLOBAL.CONC_LOGIN_ID,
2131: lang_code,
2132: userenv('LANG'))

Line 2130: FND_GLOBAL.CONC_LOGIN_ID,

2126: fnd_global.user_id,
2127: SYSDATE,
2128: fnd_global.user_id,
2129: SYSDATE,
2130: FND_GLOBAL.CONC_LOGIN_ID,
2131: lang_code,
2132: userenv('LANG'))
2133: INTO ZX_FC_CODES_DENORM_B
2134: (CLASSIFICATION_TYPE_ID,

Line 2223: fnd_global.user_id,

2219: Null,
2220: Null,
2221: 120,
2222: SYSDATE,
2223: fnd_global.user_id,
2224: FND_GLOBAL.CONC_LOGIN_ID,
2225: sysdate,
2226: FND_GLOBAL.CONC_REQUEST_ID,
2227: fnd_global.CONC_PROGRAM_ID,

Line 2224: FND_GLOBAL.CONC_LOGIN_ID,

2220: Null,
2221: 120,
2222: SYSDATE,
2223: fnd_global.user_id,
2224: FND_GLOBAL.CONC_LOGIN_ID,
2225: sysdate,
2226: FND_GLOBAL.CONC_REQUEST_ID,
2227: fnd_global.CONC_PROGRAM_ID,
2228: 235,

Line 2226: FND_GLOBAL.CONC_REQUEST_ID,

2222: SYSDATE,
2223: fnd_global.user_id,
2224: FND_GLOBAL.CONC_LOGIN_ID,
2225: sysdate,
2226: FND_GLOBAL.CONC_REQUEST_ID,
2227: fnd_global.CONC_PROGRAM_ID,
2228: 235,
2229: FND_GLOBAL.CONC_LOGIN_ID,
2230: 'SEEDED')

Line 2227: fnd_global.CONC_PROGRAM_ID,

2223: fnd_global.user_id,
2224: FND_GLOBAL.CONC_LOGIN_ID,
2225: sysdate,
2226: FND_GLOBAL.CONC_REQUEST_ID,
2227: fnd_global.CONC_PROGRAM_ID,
2228: 235,
2229: FND_GLOBAL.CONC_LOGIN_ID,
2230: 'SEEDED')
2231: select

Line 2229: FND_GLOBAL.CONC_LOGIN_ID,

2225: sysdate,
2226: FND_GLOBAL.CONC_REQUEST_ID,
2227: fnd_global.CONC_PROGRAM_ID,
2228: 235,
2229: FND_GLOBAL.CONC_LOGIN_ID,
2230: 'SEEDED')
2231: select
2232: language_code lang_code, fc_codes.classification_id
2233: from

Line 2321: fnd_global.user_id,

2317: p_ancestor_code,----parent_classification_code
2318: p_parent_fc_id,-----parent_classification_id
2319: p_country_code,
2320: 'MIGRATED',
2321: fnd_global.user_id,
2322: SYSDATE,
2323: fnd_global.user_id,
2324: SYSDATE,
2325: FND_GLOBAL.CONC_LOGIN_ID,

Line 2323: fnd_global.user_id,

2319: p_country_code,
2320: 'MIGRATED',
2321: fnd_global.user_id,
2322: SYSDATE,
2323: fnd_global.user_id,
2324: SYSDATE,
2325: FND_GLOBAL.CONC_LOGIN_ID,
2326: 1
2327: FROM FND_LOOKUP_VALUES lookups

Line 2325: FND_GLOBAL.CONC_LOGIN_ID,

2321: fnd_global.user_id,
2322: SYSDATE,
2323: fnd_global.user_id,
2324: SYSDATE,
2325: FND_GLOBAL.CONC_LOGIN_ID,
2326: 1
2327: FROM FND_LOOKUP_VALUES lookups
2328: WHERE
2329: lookups.lookup_type=p_lookup_type

Line 2357: fnd_global.user_id,

2353: CASE WHEN Meaning = UPPER(Meaning)
2354: THEN Initcap(Meaning)
2355: ELSE Meaning
2356: END,
2357: fnd_global.user_id,
2358: SYSDATE,
2359: fnd_global.user_id,
2360: SYSDATE,
2361: FND_GLOBAL.CONC_LOGIN_ID,

Line 2359: fnd_global.user_id,

2355: ELSE Meaning
2356: END,
2357: fnd_global.user_id,
2358: SYSDATE,
2359: fnd_global.user_id,
2360: SYSDATE,
2361: FND_GLOBAL.CONC_LOGIN_ID,
2362: language,
2363: SOURCE_LANG)

Line 2361: FND_GLOBAL.CONC_LOGIN_ID,

2357: fnd_global.user_id,
2358: SYSDATE,
2359: fnd_global.user_id,
2360: SYSDATE,
2361: FND_GLOBAL.CONC_LOGIN_ID,
2362: language,
2363: SOURCE_LANG)
2364: INTO ZX_FC_CODES_DENORM_B(
2365: CLASSIFICATION_TYPE_ID,

Line 2456: fnd_global.user_id,

2452: Null,
2453: Null,
2454: Null,
2455: Null,
2456: fnd_global.user_id,
2457: SYSDATE,
2458: fnd_global.user_id,
2459: FND_GLOBAL.CONC_LOGIN_ID,
2460: sysdate,

Line 2458: fnd_global.user_id,

2454: Null,
2455: Null,
2456: fnd_global.user_id,
2457: SYSDATE,
2458: fnd_global.user_id,
2459: FND_GLOBAL.CONC_LOGIN_ID,
2460: sysdate,
2461: FND_GLOBAL.CONC_REQUEST_ID,
2462: fnd_global.CONC_PROGRAM_ID,

Line 2459: FND_GLOBAL.CONC_LOGIN_ID,

2455: Null,
2456: fnd_global.user_id,
2457: SYSDATE,
2458: fnd_global.user_id,
2459: FND_GLOBAL.CONC_LOGIN_ID,
2460: sysdate,
2461: FND_GLOBAL.CONC_REQUEST_ID,
2462: fnd_global.CONC_PROGRAM_ID,
2463: 235,

Line 2461: FND_GLOBAL.CONC_REQUEST_ID,

2457: SYSDATE,
2458: fnd_global.user_id,
2459: FND_GLOBAL.CONC_LOGIN_ID,
2460: sysdate,
2461: FND_GLOBAL.CONC_REQUEST_ID,
2462: fnd_global.CONC_PROGRAM_ID,
2463: 235,
2464: FND_GLOBAL.CONC_LOGIN_ID,
2465: 'MIGRATED')

Line 2462: fnd_global.CONC_PROGRAM_ID,

2458: fnd_global.user_id,
2459: FND_GLOBAL.CONC_LOGIN_ID,
2460: sysdate,
2461: FND_GLOBAL.CONC_REQUEST_ID,
2462: fnd_global.CONC_PROGRAM_ID,
2463: 235,
2464: FND_GLOBAL.CONC_LOGIN_ID,
2465: 'MIGRATED')
2466: SELECT lookup_code,

Line 2464: FND_GLOBAL.CONC_LOGIN_ID,

2460: sysdate,
2461: FND_GLOBAL.CONC_REQUEST_ID,
2462: fnd_global.CONC_PROGRAM_ID,
2463: 235,
2464: FND_GLOBAL.CONC_LOGIN_ID,
2465: 'MIGRATED')
2466: SELECT lookup_code,
2467: Meaning,
2468: Language,

Line 2573: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),

2569: fc.classification_code ,---parent_classification_code
2570: fc.classification_id, ---parent_classification_id
2571: p_country_code,
2572: p_record_type_code,
2573: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2574: SYSDATE,
2575: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2576: SYSDATE,
2577: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),

Line 2575: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),

2571: p_country_code,
2572: p_record_type_code,
2573: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2574: SYSDATE,
2575: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2576: SYSDATE,
2577: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2578: 1
2579: FROM

Line 2577: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),

2573: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2574: SYSDATE,
2575: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2576: SYSDATE,
2577: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2578: 1
2579: FROM
2580: ZX_FC_CODES_DENORM_B fc,
2581: ZX_EVENT_CLASSES_VL event,

Line 2619: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),

2615: CASE WHEN fl.Meaning = UPPER(fl.Meaning)
2616: THEN Initcap(fl.Meaning)
2617: ELSE fl.Meaning
2618: END,
2619: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2620: SYSDATE,
2621: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2622: SYSDATE,
2623: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),

Line 2621: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),

2617: ELSE fl.Meaning
2618: END,
2619: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2620: SYSDATE,
2621: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2622: SYSDATE,
2623: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2624: l.language_code,
2625: SOURCE_LANG

Line 2623: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),

2619: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2620: SYSDATE,
2621: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2622: SYSDATE,
2623: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2624: l.language_code,
2625: SOURCE_LANG
2626: FROM
2627: ZX_FC_CODES_DENORM_B fc,

Line 2745: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),

2741: Null,
2742: Null,
2743: Null,
2744: Null,
2745: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2746: SYSDATE,
2747: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2748: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2749: sysdate,

Line 2747: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),

2743: Null,
2744: Null,
2745: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2746: SYSDATE,
2747: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2748: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2749: sysdate,
2750: FND_GLOBAL.CONC_REQUEST_ID,
2751: fnd_global.CONC_PROGRAM_ID,

Line 2748: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),

2744: Null,
2745: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2746: SYSDATE,
2747: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2748: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2749: sysdate,
2750: FND_GLOBAL.CONC_REQUEST_ID,
2751: fnd_global.CONC_PROGRAM_ID,
2752: 235,

Line 2750: FND_GLOBAL.CONC_REQUEST_ID,

2746: SYSDATE,
2747: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2748: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2749: sysdate,
2750: FND_GLOBAL.CONC_REQUEST_ID,
2751: fnd_global.CONC_PROGRAM_ID,
2752: 235,
2753: FND_GLOBAL.CONC_LOGIN_ID,
2754: p_record_type_code

Line 2751: fnd_global.CONC_PROGRAM_ID,

2747: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2748: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2749: sysdate,
2750: FND_GLOBAL.CONC_REQUEST_ID,
2751: fnd_global.CONC_PROGRAM_ID,
2752: 235,
2753: FND_GLOBAL.CONC_LOGIN_ID,
2754: p_record_type_code
2755: FROM

Line 2753: FND_GLOBAL.CONC_LOGIN_ID,

2749: sysdate,
2750: FND_GLOBAL.CONC_REQUEST_ID,
2751: fnd_global.CONC_PROGRAM_ID,
2752: 235,
2753: FND_GLOBAL.CONC_LOGIN_ID,
2754: p_record_type_code
2755: FROM
2756: ZX_FC_CODES_DENORM_B fc,
2757: ZX_FC_CODES_b Codes,

Line 2858: fnd_global.user_id,

2854: p_country_code, --country_code
2855: 'SEEDED', --record_type_code
2856: 120,
2857: sysdate,
2858: fnd_global.user_id,
2859: sysdate,
2860: fnd_global.conc_login_id,
2861: 1
2862: FROM

Line 2860: fnd_global.conc_login_id,

2856: 120,
2857: sysdate,
2858: fnd_global.user_id,
2859: sysdate,
2860: fnd_global.conc_login_id,
2861: 1
2862: FROM
2863: ZX_FC_CODES_B fc,
2864: ZX_EVENT_CLASSES_B event

Line 2895: fnd_global.user_id,

2891: CASE WHEN p_classification_name = UPPER(p_classification_name)
2892: THEN Initcap(p_classification_name)
2893: ELSE p_classification_name
2894: END,
2895: fnd_global.user_id,
2896: sysdate,
2897: fnd_global.user_id,
2898: sysdate,
2899: fnd_global.conc_login_id,

Line 2897: fnd_global.user_id,

2893: ELSE p_classification_name
2894: END,
2895: fnd_global.user_id,
2896: sysdate,
2897: fnd_global.user_id,
2898: sysdate,
2899: fnd_global.conc_login_id,
2900: L.language_code,
2901: userenv('LANG')

Line 2899: fnd_global.conc_login_id,

2895: fnd_global.user_id,
2896: sysdate,
2897: fnd_global.user_id,
2898: sysdate,
2899: fnd_global.conc_login_id,
2900: L.language_code,
2901: userenv('LANG')
2902: FROM
2903: ZX_FC_CODES_B fcparent,

Line 3013: fnd_global.user_id,

3009: Null,
3010: Null,
3011: 120,
3012: sysdate,
3013: fnd_global.user_id,
3014: fnd_global.conc_login_id,
3015: sysdate,
3016: fnd_global.conc_request_id,
3017: fnd_global.conc_program_id,

Line 3014: fnd_global.conc_login_id,

3010: Null,
3011: 120,
3012: sysdate,
3013: fnd_global.user_id,
3014: fnd_global.conc_login_id,
3015: sysdate,
3016: fnd_global.conc_request_id,
3017: fnd_global.conc_program_id,
3018: 235,

Line 3016: fnd_global.conc_request_id,

3012: sysdate,
3013: fnd_global.user_id,
3014: fnd_global.conc_login_id,
3015: sysdate,
3016: fnd_global.conc_request_id,
3017: fnd_global.conc_program_id,
3018: 235,
3019: fnd_global.conc_login_id,
3020: 'SEEDED'

Line 3017: fnd_global.conc_program_id,

3013: fnd_global.user_id,
3014: fnd_global.conc_login_id,
3015: sysdate,
3016: fnd_global.conc_request_id,
3017: fnd_global.conc_program_id,
3018: 235,
3019: fnd_global.conc_login_id,
3020: 'SEEDED'
3021: FROM

Line 3019: fnd_global.conc_login_id,

3015: sysdate,
3016: fnd_global.conc_request_id,
3017: fnd_global.conc_program_id,
3018: 235,
3019: fnd_global.conc_login_id,
3020: 'SEEDED'
3021: FROM
3022: ZX_FC_CODES_B fc,
3023: ZX_FC_CODES_B zx,

Line 3081: fnd_global.user_id,

3077: 'STATISTICAL CODE',
3078: SYSDATE,
3079: NULL,
3080: 'MIGRATED',
3081: fnd_global.user_id,
3082: SYSDATE,
3083: fnd_global.user_id,
3084: SYSDATE,
3085: FND_GLOBAL.CONC_LOGIN_ID,

Line 3083: fnd_global.user_id,

3079: NULL,
3080: 'MIGRATED',
3081: fnd_global.user_id,
3082: SYSDATE,
3083: fnd_global.user_id,
3084: SYSDATE,
3085: FND_GLOBAL.CONC_LOGIN_ID,
3086: zx_fc_types_reg_assoc_s.nextval,
3087: 1)

Line 3085: FND_GLOBAL.CONC_LOGIN_ID,

3081: fnd_global.user_id,
3082: SYSDATE,
3083: fnd_global.user_id,
3084: SYSDATE,
3085: FND_GLOBAL.CONC_LOGIN_ID,
3086: zx_fc_types_reg_assoc_s.nextval,
3087: 1)
3088: Select unique
3089: tax_regime_code

Line 3149: fnd_global.user_id,

3145: p_owner_id_num,
3146: 1,
3147: 400,
3148: 'MIGRATED',
3149: fnd_global.user_id,
3150: SYSDATE,
3151: fnd_global.user_id,
3152: SYSDATE,
3153: FND_GLOBAL.CONC_LOGIN_ID,

Line 3151: fnd_global.user_id,

3147: 400,
3148: 'MIGRATED',
3149: fnd_global.user_id,
3150: SYSDATE,
3151: fnd_global.user_id,
3152: SYSDATE,
3153: FND_GLOBAL.CONC_LOGIN_ID,
3154: 1
3155: FROM dual

Line 3153: FND_GLOBAL.CONC_LOGIN_ID,

3149: fnd_global.user_id,
3150: SYSDATE,
3151: fnd_global.user_id,
3152: SYSDATE,
3153: FND_GLOBAL.CONC_LOGIN_ID,
3154: 1
3155: FROM dual
3156: WHERE NOT EXISTS
3157: (SELECT null from ZX_FC_TYPES_B

Line 3180: fnd_global.user_id,

3176: CASE WHEN p_classification_type_name = UPPER(p_classification_type_name)
3177: THEN Initcap(p_classification_type_name)
3178: ELSE p_classification_type_name
3179: END,
3180: fnd_global.user_id,
3181: SYSDATE,
3182: fnd_global.user_id,
3183: SYSDATE,
3184: FND_GLOBAL.CONC_LOGIN_ID,

Line 3182: fnd_global.user_id,

3178: ELSE p_classification_type_name
3179: END,
3180: fnd_global.user_id,
3181: SYSDATE,
3182: fnd_global.user_id,
3183: SYSDATE,
3184: FND_GLOBAL.CONC_LOGIN_ID,
3185: language_code,
3186: userenv('LANG')

Line 3184: FND_GLOBAL.CONC_LOGIN_ID,

3180: fnd_global.user_id,
3181: SYSDATE,
3182: fnd_global.user_id,
3183: SYSDATE,
3184: FND_GLOBAL.CONC_LOGIN_ID,
3185: language_code,
3186: userenv('LANG')
3187:
3188: FROM FND_LANGUAGES L,

Line 3244: FND_GLOBAL.USER_ID,

3240: 'Y', --INTERNAL_FLAG
3241: 'N', --RECORD_ONLY_FLAG
3242: NULL,
3243: SYSDATE,
3244: FND_GLOBAL.USER_ID,
3245: SYSDATE,
3246: FND_GLOBAL.USER_ID,
3247: FND_GLOBAL.CONC_LOGIN_ID,
3248: 1

Line 3246: FND_GLOBAL.USER_ID,

3242: NULL,
3243: SYSDATE,
3244: FND_GLOBAL.USER_ID,
3245: SYSDATE,
3246: FND_GLOBAL.USER_ID,
3247: FND_GLOBAL.CONC_LOGIN_ID,
3248: 1
3249: FROM dual
3250: WHERE NOT EXISTS

Line 3247: FND_GLOBAL.CONC_LOGIN_ID,

3243: SYSDATE,
3244: FND_GLOBAL.USER_ID,
3245: SYSDATE,
3246: FND_GLOBAL.USER_ID,
3247: FND_GLOBAL.CONC_LOGIN_ID,
3248: 1
3249: FROM dual
3250: WHERE NOT EXISTS
3251: (SELECT null from ZX_DETERMINING_FACTORS_B

Line 3274: FND_GLOBAL.USER_ID,

3270: ELSE p_classification_type_name
3271: END,
3272: NULL,
3273: SYSDATE,
3274: FND_GLOBAL.USER_ID,
3275: SYSDATE,
3276: FND_GLOBAL.USER_ID,
3277: FND_GLOBAL.CONC_LOGIN_ID,
3278: detFactors.DETERMINING_FACTOR_ID,

Line 3276: FND_GLOBAL.USER_ID,

3272: NULL,
3273: SYSDATE,
3274: FND_GLOBAL.USER_ID,
3275: SYSDATE,
3276: FND_GLOBAL.USER_ID,
3277: FND_GLOBAL.CONC_LOGIN_ID,
3278: detFactors.DETERMINING_FACTOR_ID,
3279: L.LANGUAGE_CODE,
3280: userenv('LANG')

Line 3277: FND_GLOBAL.CONC_LOGIN_ID,

3273: SYSDATE,
3274: FND_GLOBAL.USER_ID,
3275: SYSDATE,
3276: FND_GLOBAL.USER_ID,
3277: FND_GLOBAL.CONC_LOGIN_ID,
3278: detFactors.DETERMINING_FACTOR_ID,
3279: L.LANGUAGE_CODE,
3280: userenv('LANG')
3281:

Line 3341: fnd_global.user_id,

3337: p_tca_class,
3338: NULL,
3339: NULL,
3340: 'MIGRATED',
3341: fnd_global.user_id,
3342: SYSDATE,
3343: fnd_global.user_id,
3344: SYSDATE,
3345: FND_GLOBAL.CONC_LOGIN_ID,

Line 3343: fnd_global.user_id,

3339: NULL,
3340: 'MIGRATED',
3341: fnd_global.user_id,
3342: SYSDATE,
3343: fnd_global.user_id,
3344: SYSDATE,
3345: FND_GLOBAL.CONC_LOGIN_ID,
3346: 1
3347: FROM dual

Line 3345: FND_GLOBAL.CONC_LOGIN_ID,

3341: fnd_global.user_id,
3342: SYSDATE,
3343: fnd_global.user_id,
3344: SYSDATE,
3345: FND_GLOBAL.CONC_LOGIN_ID,
3346: 1
3347: FROM dual
3348: WHERE NOT EXISTS
3349: (SELECT null from ZX_FC_TYPES_B

Line 3372: fnd_global.user_id,

3368: CASE WHEN p_classification_type_name = UPPER(p_classification_type_name)
3369: THEN Initcap(p_classification_type_name)
3370: ELSE p_classification_type_name
3371: END,
3372: fnd_global.user_id,
3373: SYSDATE,
3374: fnd_global.user_id,
3375: SYSDATE,
3376: FND_GLOBAL.CONC_LOGIN_ID,

Line 3374: fnd_global.user_id,

3370: ELSE p_classification_type_name
3371: END,
3372: fnd_global.user_id,
3373: SYSDATE,
3374: fnd_global.user_id,
3375: SYSDATE,
3376: FND_GLOBAL.CONC_LOGIN_ID,
3377: language_code,
3378: userenv('LANG')

Line 3376: FND_GLOBAL.CONC_LOGIN_ID,

3372: fnd_global.user_id,
3373: SYSDATE,
3374: fnd_global.user_id,
3375: SYSDATE,
3376: FND_GLOBAL.CONC_LOGIN_ID,
3377: language_code,
3378: userenv('LANG')
3379:
3380: FROM FND_LANGUAGES L,

Line 3436: FND_GLOBAL.USER_ID,

3432: 'Y', --INTERNAL_FLAG
3433: 'N', --RECORD_ONLY_FLAG
3434: NULL,
3435: SYSDATE,
3436: FND_GLOBAL.USER_ID,
3437: SYSDATE,
3438: FND_GLOBAL.USER_ID,
3439: FND_GLOBAL.CONC_LOGIN_ID,
3440: 1

Line 3438: FND_GLOBAL.USER_ID,

3434: NULL,
3435: SYSDATE,
3436: FND_GLOBAL.USER_ID,
3437: SYSDATE,
3438: FND_GLOBAL.USER_ID,
3439: FND_GLOBAL.CONC_LOGIN_ID,
3440: 1
3441: FROM dual
3442: WHERE NOT EXISTS

Line 3439: FND_GLOBAL.CONC_LOGIN_ID,

3435: SYSDATE,
3436: FND_GLOBAL.USER_ID,
3437: SYSDATE,
3438: FND_GLOBAL.USER_ID,
3439: FND_GLOBAL.CONC_LOGIN_ID,
3440: 1
3441: FROM dual
3442: WHERE NOT EXISTS
3443: (SELECT null from ZX_DETERMINING_FACTORS_B

Line 3466: FND_GLOBAL.USER_ID,

3462: ELSE p_classification_type_name
3463: END,
3464: NULL,
3465: SYSDATE,
3466: FND_GLOBAL.USER_ID,
3467: SYSDATE,
3468: FND_GLOBAL.USER_ID,
3469: FND_GLOBAL.CONC_LOGIN_ID,
3470: detFactors.DETERMINING_FACTOR_ID,

Line 3468: FND_GLOBAL.USER_ID,

3464: NULL,
3465: SYSDATE,
3466: FND_GLOBAL.USER_ID,
3467: SYSDATE,
3468: FND_GLOBAL.USER_ID,
3469: FND_GLOBAL.CONC_LOGIN_ID,
3470: detFactors.DETERMINING_FACTOR_ID,
3471: L.LANGUAGE_CODE,
3472: userenv('LANG')

Line 3469: FND_GLOBAL.CONC_LOGIN_ID,

3465: SYSDATE,
3466: FND_GLOBAL.USER_ID,
3467: SYSDATE,
3468: FND_GLOBAL.USER_ID,
3469: FND_GLOBAL.CONC_LOGIN_ID,
3470: detFactors.DETERMINING_FACTOR_ID,
3471: L.LANGUAGE_CODE,
3472: userenv('LANG')
3473: FROM FND_LANGUAGES L,

Line 3524: fnd_global.user_id,

3520: 'ESTB_TAX_CLASSIFICATION',
3521: SYSDATE,
3522: NULL,
3523: 'MIGRATED',
3524: fnd_global.user_id,
3525: SYSDATE,
3526: fnd_global.user_id,
3527: SYSDATE,
3528: FND_GLOBAL.CONC_LOGIN_ID,

Line 3526: fnd_global.user_id,

3522: NULL,
3523: 'MIGRATED',
3524: fnd_global.user_id,
3525: SYSDATE,
3526: fnd_global.user_id,
3527: SYSDATE,
3528: FND_GLOBAL.CONC_LOGIN_ID,
3529: zx_fc_types_reg_assoc_s.nextval,
3530: 1)

Line 3528: FND_GLOBAL.CONC_LOGIN_ID,

3524: fnd_global.user_id,
3525: SYSDATE,
3526: fnd_global.user_id,
3527: SYSDATE,
3528: FND_GLOBAL.CONC_LOGIN_ID,
3529: zx_fc_types_reg_assoc_s.nextval,
3530: 1)
3531: SELECT unique rates.tax_regime_code
3532: FROM ZX_RATES_B rates,

Line 3584: NVL(FND_GLOBAL.USER_ID,-1),

3580: SYSDATE,
3581: null,
3582: 'Y',
3583: 'Y',
3584: NVL(FND_GLOBAL.USER_ID,-1),
3585: SYSDATE,
3586: NVL(FND_GLOBAL.USER_ID,-1),
3587: NVL(FND_GLOBAL.LOGIN_ID,-1),
3588: SYSDATE,

Line 3586: NVL(FND_GLOBAL.USER_ID,-1),

3582: 'Y',
3583: 'Y',
3584: NVL(FND_GLOBAL.USER_ID,-1),
3585: SYSDATE,
3586: NVL(FND_GLOBAL.USER_ID,-1),
3587: NVL(FND_GLOBAL.LOGIN_ID,-1),
3588: SYSDATE,
3589: FND_GLOBAL.CONC_REQUEST_ID,
3590: FND_GLOBAL.CONC_PROGRAM_ID,

Line 3587: NVL(FND_GLOBAL.LOGIN_ID,-1),

3583: 'Y',
3584: NVL(FND_GLOBAL.USER_ID,-1),
3585: SYSDATE,
3586: NVL(FND_GLOBAL.USER_ID,-1),
3587: NVL(FND_GLOBAL.LOGIN_ID,-1),
3588: SYSDATE,
3589: FND_GLOBAL.CONC_REQUEST_ID,
3590: FND_GLOBAL.CONC_PROGRAM_ID,
3591: FND_GLOBAL.PROG_APPL_ID,

Line 3589: FND_GLOBAL.CONC_REQUEST_ID,

3585: SYSDATE,
3586: NVL(FND_GLOBAL.USER_ID,-1),
3587: NVL(FND_GLOBAL.LOGIN_ID,-1),
3588: SYSDATE,
3589: FND_GLOBAL.CONC_REQUEST_ID,
3590: FND_GLOBAL.CONC_PROGRAM_ID,
3591: FND_GLOBAL.PROG_APPL_ID,
3592: SYSDATE
3593: FROM fnd_languages LV

Line 3590: FND_GLOBAL.CONC_PROGRAM_ID,

3586: NVL(FND_GLOBAL.USER_ID,-1),
3587: NVL(FND_GLOBAL.LOGIN_ID,-1),
3588: SYSDATE,
3589: FND_GLOBAL.CONC_REQUEST_ID,
3590: FND_GLOBAL.CONC_PROGRAM_ID,
3591: FND_GLOBAL.PROG_APPL_ID,
3592: SYSDATE
3593: FROM fnd_languages LV
3594: WHERE LV.INSTALLED_FLAG in ('I', 'B')

Line 3591: FND_GLOBAL.PROG_APPL_ID,

3587: NVL(FND_GLOBAL.LOGIN_ID,-1),
3588: SYSDATE,
3589: FND_GLOBAL.CONC_REQUEST_ID,
3590: FND_GLOBAL.CONC_PROGRAM_ID,
3591: FND_GLOBAL.PROG_APPL_ID,
3592: SYSDATE
3593: FROM fnd_languages LV
3594: WHERE LV.INSTALLED_FLAG in ('I', 'B')
3595: AND NOT EXISTS (SELECT 1 FROM HZ_CLASS_CODE_DENORM

Line 3640: fnd_global.user_id,

3636: 'USER_ENTERED',
3637: Null,
3638: start_date,
3639: Null,
3640: fnd_global.user_id,
3641: Sysdate,
3642: FND_GLOBAL.CONC_LOGIN_ID,
3643: Sysdate,
3644: fnd_global.user_id,

Line 3642: FND_GLOBAL.CONC_LOGIN_ID,

3638: start_date,
3639: Null,
3640: fnd_global.user_id,
3641: Sysdate,
3642: FND_GLOBAL.CONC_LOGIN_ID,
3643: Sysdate,
3644: fnd_global.user_id,
3645: Null,
3646: 1,

Line 3644: fnd_global.user_id,

3640: fnd_global.user_id,
3641: Sysdate,
3642: FND_GLOBAL.CONC_LOGIN_ID,
3643: Sysdate,
3644: fnd_global.user_id,
3645: Null,
3646: 1,
3647: 'EBTAX MIGRATION',
3648: 235,

Line 3655: fnd_global.PROG_APPL_ID,

3651: Null,
3652: Null,
3653: Null,
3654: NULL,
3655: fnd_global.PROG_APPL_ID,
3656: fnd_global.CONC_PROGRAM_ID)
3657: SELECT DISTINCT PTP.PARTY_TAX_PROFILE_ID party_tax_profile_id,
3658: POV.VENDOR_TYPE_LOOKUP_CODE fiscal_classification_code,
3659: MIN(POV.creation_date) start_date

Line 3656: fnd_global.CONC_PROGRAM_ID)

3652: Null,
3653: Null,
3654: NULL,
3655: fnd_global.PROG_APPL_ID,
3656: fnd_global.CONC_PROGRAM_ID)
3657: SELECT DISTINCT PTP.PARTY_TAX_PROFILE_ID party_tax_profile_id,
3658: POV.VENDOR_TYPE_LOOKUP_CODE fiscal_classification_code,
3659: MIN(POV.creation_date) start_date
3660: FROM ap_suppliers POV ,

Line 3702: last_updated_by = fnd_global.user_id,

3698: owner_id_num = l_category_set,
3699: start_position = 1,
3700: num_characters = 400,
3701: last_update_date = sysdate,
3702: last_updated_by = fnd_global.user_id,
3703: object_version_number = object_version_number + 1
3704: WHERE
3705: classification_type_code = 'INTENDED_USE' and
3706: classification_type_categ_code = 'INTENDED_USE_CLASSIFICATION';

Line 3749: fnd_global.user_id,

3745: 'STATISTICAL_CODE',
3746: SYSDATE,
3747: NULL,
3748: 'MIGRATED',
3749: fnd_global.user_id,
3750: SYSDATE,
3751: fnd_global.user_id,
3752: SYSDATE,
3753: FND_GLOBAL.CONC_LOGIN_ID,

Line 3751: fnd_global.user_id,

3747: NULL,
3748: 'MIGRATED',
3749: fnd_global.user_id,
3750: SYSDATE,
3751: fnd_global.user_id,
3752: SYSDATE,
3753: FND_GLOBAL.CONC_LOGIN_ID,
3754: zx_fc_types_reg_assoc_s.NEXTVAL,
3755: 1)

Line 3753: FND_GLOBAL.CONC_LOGIN_ID,

3749: fnd_global.user_id,
3750: SYSDATE,
3751: fnd_global.user_id,
3752: SYSDATE,
3753: FND_GLOBAL.CONC_LOGIN_ID,
3754: zx_fc_types_reg_assoc_s.NEXTVAL,
3755: 1)
3756: SELECT
3757: unique tax_regime_code

Line 3835: fnd_global.user_id,

3831: 'DEDUCTION TAX RULE',--parent_classification_code
3832: l_fc_id,--parent_classification_id
3833: 'FR',
3834: 'MIGRATED',
3835: fnd_global.user_id,
3836: SYSDATE,
3837: fnd_global.user_id,
3838: SYSDATE,
3839: FND_GLOBAL.CONC_LOGIN_ID,

Line 3837: fnd_global.user_id,

3833: 'FR',
3834: 'MIGRATED',
3835: fnd_global.user_id,
3836: SYSDATE,
3837: fnd_global.user_id,
3838: SYSDATE,
3839: FND_GLOBAL.CONC_LOGIN_ID,
3840: 1
3841: FROM

Line 3839: FND_GLOBAL.CONC_LOGIN_ID,

3835: fnd_global.user_id,
3836: SYSDATE,
3837: fnd_global.user_id,
3838: SYSDATE,
3839: FND_GLOBAL.CONC_LOGIN_ID,
3840: 1
3841: FROM
3842: FND_FLEX_VALUES V,
3843: fnd_flex_value_sets vs

Line 3873: fnd_global.user_id,

3869: CASE WHEN flex_value = UPPER(flex_value)
3870: THEN Initcap(flex_value)
3871: ELSE flex_value
3872: END,
3873: fnd_global.user_id,
3874: SYSDATE,
3875: fnd_global.user_id,
3876: SYSDATE,
3877: FND_GLOBAL.CONC_LOGIN_ID,

Line 3875: fnd_global.user_id,

3871: ELSE flex_value
3872: END,
3873: fnd_global.user_id,
3874: SYSDATE,
3875: fnd_global.user_id,
3876: SYSDATE,
3877: FND_GLOBAL.CONC_LOGIN_ID,
3878: lang_code,
3879: userenv('LANG'))

Line 3877: FND_GLOBAL.CONC_LOGIN_ID,

3873: fnd_global.user_id,
3874: SYSDATE,
3875: fnd_global.user_id,
3876: SYSDATE,
3877: FND_GLOBAL.CONC_LOGIN_ID,
3878: lang_code,
3879: userenv('LANG'))
3880: INTO ZX_FC_CODES_DENORM_B
3881: (CLASSIFICATION_TYPE_ID,

Line 3968: fnd_global.user_id,

3964: Null,
3965: Null,
3966: Null,
3967: Null,
3968: fnd_global.user_id,
3969: SYSDATE,
3970: fnd_global.user_id,
3971: FND_GLOBAL.CONC_LOGIN_ID,
3972: sysdate,

Line 3970: fnd_global.user_id,

3966: Null,
3967: Null,
3968: fnd_global.user_id,
3969: SYSDATE,
3970: fnd_global.user_id,
3971: FND_GLOBAL.CONC_LOGIN_ID,
3972: sysdate,
3973: FND_GLOBAL.CONC_REQUEST_ID,
3974: fnd_global.CONC_PROGRAM_ID,

Line 3971: FND_GLOBAL.CONC_LOGIN_ID,

3967: Null,
3968: fnd_global.user_id,
3969: SYSDATE,
3970: fnd_global.user_id,
3971: FND_GLOBAL.CONC_LOGIN_ID,
3972: sysdate,
3973: FND_GLOBAL.CONC_REQUEST_ID,
3974: fnd_global.CONC_PROGRAM_ID,
3975: 235,

Line 3973: FND_GLOBAL.CONC_REQUEST_ID,

3969: SYSDATE,
3970: fnd_global.user_id,
3971: FND_GLOBAL.CONC_LOGIN_ID,
3972: sysdate,
3973: FND_GLOBAL.CONC_REQUEST_ID,
3974: fnd_global.CONC_PROGRAM_ID,
3975: 235,
3976: FND_GLOBAL.CONC_LOGIN_ID,
3977: 'MIGRATED')

Line 3974: fnd_global.CONC_PROGRAM_ID,

3970: fnd_global.user_id,
3971: FND_GLOBAL.CONC_LOGIN_ID,
3972: sysdate,
3973: FND_GLOBAL.CONC_REQUEST_ID,
3974: fnd_global.CONC_PROGRAM_ID,
3975: 235,
3976: FND_GLOBAL.CONC_LOGIN_ID,
3977: 'MIGRATED')
3978: SELECT

Line 3976: FND_GLOBAL.CONC_LOGIN_ID,

3972: sysdate,
3973: FND_GLOBAL.CONC_REQUEST_ID,
3974: fnd_global.CONC_PROGRAM_ID,
3975: 235,
3976: FND_GLOBAL.CONC_LOGIN_ID,
3977: 'MIGRATED')
3978: SELECT
3979: flex_value,
3980: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')) start_date_active,

Line 4062: fnd_global.user_id,

4058: 'DOCUMENT TYPE',--parent_classification_code
4059: l_fc_id, --parent_classification_id
4060: 'CL',
4061: 'MIGRATED',
4062: fnd_global.user_id,
4063: SYSDATE,
4064: fnd_global.user_id,
4065: SYSDATE,
4066: FND_GLOBAL.CONC_LOGIN_ID,

Line 4064: fnd_global.user_id,

4060: 'CL',
4061: 'MIGRATED',
4062: fnd_global.user_id,
4063: SYSDATE,
4064: fnd_global.user_id,
4065: SYSDATE,
4066: FND_GLOBAL.CONC_LOGIN_ID,
4067: 1
4068:

Line 4066: FND_GLOBAL.CONC_LOGIN_ID,

4062: fnd_global.user_id,
4063: SYSDATE,
4064: fnd_global.user_id,
4065: SYSDATE,
4066: FND_GLOBAL.CONC_LOGIN_ID,
4067: 1
4068:
4069: FROM FND_LOOKUPS lookups
4070: WHERE

Line 4096: fnd_global.user_id,

4092: SOURCE_LANG)
4093: VALUES
4094: (classification_id,
4095: meaning,
4096: fnd_global.user_id,
4097: SYSDATE,
4098: fnd_global.user_id,
4099: SYSDATE,
4100: FND_GLOBAL.CONC_LOGIN_ID,

Line 4098: fnd_global.user_id,

4094: (classification_id,
4095: meaning,
4096: fnd_global.user_id,
4097: SYSDATE,
4098: fnd_global.user_id,
4099: SYSDATE,
4100: FND_GLOBAL.CONC_LOGIN_ID,
4101: language,
4102: source_lang)

Line 4100: FND_GLOBAL.CONC_LOGIN_ID,

4096: fnd_global.user_id,
4097: SYSDATE,
4098: fnd_global.user_id,
4099: SYSDATE,
4100: FND_GLOBAL.CONC_LOGIN_ID,
4101: language,
4102: source_lang)
4103:
4104: INTO ZX_FC_CODES_DENORM_B

Line 4193: fnd_global.user_id,

4189: Null,
4190: Null,
4191: Null,
4192: Null,
4193: fnd_global.user_id,
4194: SYSDATE,
4195: fnd_global.user_id,
4196: FND_GLOBAL.CONC_LOGIN_ID,
4197: sysdate,

Line 4195: fnd_global.user_id,

4191: Null,
4192: Null,
4193: fnd_global.user_id,
4194: SYSDATE,
4195: fnd_global.user_id,
4196: FND_GLOBAL.CONC_LOGIN_ID,
4197: sysdate,
4198: FND_GLOBAL.CONC_REQUEST_ID,
4199: fnd_global.CONC_PROGRAM_ID,

Line 4196: FND_GLOBAL.CONC_LOGIN_ID,

4192: Null,
4193: fnd_global.user_id,
4194: SYSDATE,
4195: fnd_global.user_id,
4196: FND_GLOBAL.CONC_LOGIN_ID,
4197: sysdate,
4198: FND_GLOBAL.CONC_REQUEST_ID,
4199: fnd_global.CONC_PROGRAM_ID,
4200: 235,

Line 4198: FND_GLOBAL.CONC_REQUEST_ID,

4194: SYSDATE,
4195: fnd_global.user_id,
4196: FND_GLOBAL.CONC_LOGIN_ID,
4197: sysdate,
4198: FND_GLOBAL.CONC_REQUEST_ID,
4199: fnd_global.CONC_PROGRAM_ID,
4200: 235,
4201: FND_GLOBAL.CONC_LOGIN_ID,
4202: 'MIGRATED')

Line 4199: fnd_global.CONC_PROGRAM_ID,

4195: fnd_global.user_id,
4196: FND_GLOBAL.CONC_LOGIN_ID,
4197: sysdate,
4198: FND_GLOBAL.CONC_REQUEST_ID,
4199: fnd_global.CONC_PROGRAM_ID,
4200: 235,
4201: FND_GLOBAL.CONC_LOGIN_ID,
4202: 'MIGRATED')
4203: SELECT

Line 4201: FND_GLOBAL.CONC_LOGIN_ID,

4197: sysdate,
4198: FND_GLOBAL.CONC_REQUEST_ID,
4199: fnd_global.CONC_PROGRAM_ID,
4200: 235,
4201: FND_GLOBAL.CONC_LOGIN_ID,
4202: 'MIGRATED')
4203: SELECT
4204: lookup_code,
4205: meaning,

Line 4307: fnd_global.user_id,

4303: 'FISCAL_CLASSIFICATION',
4304: SYSDATE,
4305: NULL,
4306: 'MIGRATED',
4307: fnd_global.user_id,
4308: SYSDATE,
4309: fnd_global.user_id,
4310: SYSDATE,
4311: FND_GLOBAL.CONC_LOGIN_ID,

Line 4309: fnd_global.user_id,

4305: NULL,
4306: 'MIGRATED',
4307: fnd_global.user_id,
4308: SYSDATE,
4309: fnd_global.user_id,
4310: SYSDATE,
4311: FND_GLOBAL.CONC_LOGIN_ID,
4312: zx_fc_types_reg_assoc_s.NEXTVAL,
4313: 1)

Line 4311: FND_GLOBAL.CONC_LOGIN_ID,

4307: fnd_global.user_id,
4308: SYSDATE,
4309: fnd_global.user_id,
4310: SYSDATE,
4311: FND_GLOBAL.CONC_LOGIN_ID,
4312: zx_fc_types_reg_assoc_s.NEXTVAL,
4313: 1)
4314:
4315: SELECT unique

Line 4372: fnd_global.user_id,

4368: event.tax_event_class_code, --parent_classification_code
4369: fc.classification_id, --parent_classification_id
4370: NULL, --country_code is null to share AR,BR,CO country
4371: 'MIGRATED', --record_type_code
4372: fnd_global.user_id,
4373: sysdate,
4374: fnd_global.user_id,
4375: sysdate,
4376: fnd_global.conc_login_id,

Line 4374: fnd_global.user_id,

4370: NULL, --country_code is null to share AR,BR,CO country
4371: 'MIGRATED', --record_type_code
4372: fnd_global.user_id,
4373: sysdate,
4374: fnd_global.user_id,
4375: sysdate,
4376: fnd_global.conc_login_id,
4377: 1
4378:

Line 4376: fnd_global.conc_login_id,

4372: fnd_global.user_id,
4373: sysdate,
4374: fnd_global.user_id,
4375: sysdate,
4376: fnd_global.conc_login_id,
4377: 1
4378:
4379: FROM
4380:

Line 4424: fnd_global.user_id,

4420: CASE WHEN fc_name = UPPER(fc_name)
4421: THEN Initcap(fc_name)
4422: ELSE fc_name
4423: END,
4424: fnd_global.user_id,
4425: sysdate,
4426: fnd_global.user_id,
4427: sysdate,
4428: fnd_global.conc_login_id,

Line 4426: fnd_global.user_id,

4422: ELSE fc_name
4423: END,
4424: fnd_global.user_id,
4425: sysdate,
4426: fnd_global.user_id,
4427: sysdate,
4428: fnd_global.conc_login_id,
4429: LANGUAGE,
4430: SOURCE_LANGUAGE)

Line 4428: fnd_global.conc_login_id,

4424: fnd_global.user_id,
4425: sysdate,
4426: fnd_global.user_id,
4427: sysdate,
4428: fnd_global.conc_login_id,
4429: LANGUAGE,
4430: SOURCE_LANGUAGE)
4431:
4432: INTO ZX_FC_CODES_DENORM_B(

Line 4520: fnd_global.user_id,

4516: Null,
4517: Null,
4518: Null,
4519: Null,
4520: fnd_global.user_id,
4521: sysdate,
4522: fnd_global.user_id,
4523: fnd_global.conc_login_id,
4524: sysdate,

Line 4522: fnd_global.user_id,

4518: Null,
4519: Null,
4520: fnd_global.user_id,
4521: sysdate,
4522: fnd_global.user_id,
4523: fnd_global.conc_login_id,
4524: sysdate,
4525: fnd_global.conc_request_id,
4526: fnd_global.conc_program_id,

Line 4523: fnd_global.conc_login_id,

4519: Null,
4520: fnd_global.user_id,
4521: sysdate,
4522: fnd_global.user_id,
4523: fnd_global.conc_login_id,
4524: sysdate,
4525: fnd_global.conc_request_id,
4526: fnd_global.conc_program_id,
4527: 235,

Line 4525: fnd_global.conc_request_id,

4521: sysdate,
4522: fnd_global.user_id,
4523: fnd_global.conc_login_id,
4524: sysdate,
4525: fnd_global.conc_request_id,
4526: fnd_global.conc_program_id,
4527: 235,
4528: fnd_global.conc_login_id,
4529: 'MIGRATED')

Line 4526: fnd_global.conc_program_id,

4522: fnd_global.user_id,
4523: fnd_global.conc_login_id,
4524: sysdate,
4525: fnd_global.conc_request_id,
4526: fnd_global.conc_program_id,
4527: 235,
4528: fnd_global.conc_login_id,
4529: 'MIGRATED')
4530: SELECT

Line 4528: fnd_global.conc_login_id,

4524: sysdate,
4525: fnd_global.conc_request_id,
4526: fnd_global.conc_program_id,
4527: 235,
4528: fnd_global.conc_login_id,
4529: 'MIGRATED')
4530: SELECT
4531: codes.fc_code,
4532: codes.fc_name,

Line 4900: fnd_global.user_id,

4896: 'LEASE_MGT_PROD_FISC_CLASS',
4897: SYSDATE,
4898: NULL,
4899: 'MIGRATED',
4900: fnd_global.user_id,
4901: SYSDATE,
4902: fnd_global.user_id,
4903: SYSDATE,
4904: FND_GLOBAL.CONC_LOGIN_ID,

Line 4902: fnd_global.user_id,

4898: NULL,
4899: 'MIGRATED',
4900: fnd_global.user_id,
4901: SYSDATE,
4902: fnd_global.user_id,
4903: SYSDATE,
4904: FND_GLOBAL.CONC_LOGIN_ID,
4905: zx_fc_types_reg_assoc_s.nextval,
4906: 1)

Line 4904: FND_GLOBAL.CONC_LOGIN_ID,

4900: fnd_global.user_id,
4901: SYSDATE,
4902: fnd_global.user_id,
4903: SYSDATE,
4904: FND_GLOBAL.CONC_LOGIN_ID,
4905: zx_fc_types_reg_assoc_s.nextval,
4906: 1)
4907: SELECT unique rates.tax_regime_code
4908: FROM ZX_RATES_B rates,

Line 5042: fnd_global.user_id,

5038: null,----parent_classification_code
5039: null,----parent_classification_id
5040: null,
5041: 'MIGRATED',
5042: fnd_global.user_id,
5043: SYSDATE,
5044: fnd_global.user_id,
5045: SYSDATE,
5046: FND_GLOBAL.CONC_LOGIN_ID,

Line 5044: fnd_global.user_id,

5040: null,
5041: 'MIGRATED',
5042: fnd_global.user_id,
5043: SYSDATE,
5044: fnd_global.user_id,
5045: SYSDATE,
5046: FND_GLOBAL.CONC_LOGIN_ID,
5047: 1
5048: FROM FND_LOOKUP_VALUES lookups

Line 5046: FND_GLOBAL.CONC_LOGIN_ID,

5042: fnd_global.user_id,
5043: SYSDATE,
5044: fnd_global.user_id,
5045: SYSDATE,
5046: FND_GLOBAL.CONC_LOGIN_ID,
5047: 1
5048: FROM FND_LOOKUP_VALUES lookups
5049: WHERE lookups.lookup_type='AR_TAX_TRX_BUSINESS_CATEGORY'
5050: AND LANGUAGE = userenv('LANG')

Line 5076: fnd_global.user_id,

5072: CASE WHEN Meaning = UPPER(Meaning)
5073: THEN Initcap(Meaning)
5074: ELSE Meaning
5075: END,
5076: fnd_global.user_id,
5077: SYSDATE,
5078: fnd_global.user_id,
5079: SYSDATE,
5080: FND_GLOBAL.CONC_LOGIN_ID,

Line 5078: fnd_global.user_id,

5074: ELSE Meaning
5075: END,
5076: fnd_global.user_id,
5077: SYSDATE,
5078: fnd_global.user_id,
5079: SYSDATE,
5080: FND_GLOBAL.CONC_LOGIN_ID,
5081: language,
5082: source_lang)

Line 5080: FND_GLOBAL.CONC_LOGIN_ID,

5076: fnd_global.user_id,
5077: SYSDATE,
5078: fnd_global.user_id,
5079: SYSDATE,
5080: FND_GLOBAL.CONC_LOGIN_ID,
5081: language,
5082: source_lang)
5083: INTO ZX_FC_CODES_DENORM_B(
5084: CLASSIFICATION_TYPE_ID,

Line 5171: fnd_global.user_id,

5167: Null,
5168: Null,
5169: Null,
5170: Null,
5171: fnd_global.user_id,
5172: SYSDATE,
5173: fnd_global.user_id,
5174: FND_GLOBAL.CONC_LOGIN_ID,
5175: sysdate,

Line 5173: fnd_global.user_id,

5169: Null,
5170: Null,
5171: fnd_global.user_id,
5172: SYSDATE,
5173: fnd_global.user_id,
5174: FND_GLOBAL.CONC_LOGIN_ID,
5175: sysdate,
5176: FND_GLOBAL.CONC_REQUEST_ID,
5177: fnd_global.CONC_PROGRAM_ID,

Line 5174: FND_GLOBAL.CONC_LOGIN_ID,

5170: Null,
5171: fnd_global.user_id,
5172: SYSDATE,
5173: fnd_global.user_id,
5174: FND_GLOBAL.CONC_LOGIN_ID,
5175: sysdate,
5176: FND_GLOBAL.CONC_REQUEST_ID,
5177: fnd_global.CONC_PROGRAM_ID,
5178: 235,

Line 5176: FND_GLOBAL.CONC_REQUEST_ID,

5172: SYSDATE,
5173: fnd_global.user_id,
5174: FND_GLOBAL.CONC_LOGIN_ID,
5175: sysdate,
5176: FND_GLOBAL.CONC_REQUEST_ID,
5177: fnd_global.CONC_PROGRAM_ID,
5178: 235,
5179: FND_GLOBAL.CONC_LOGIN_ID,
5180: 'MIGRATED')

Line 5177: fnd_global.CONC_PROGRAM_ID,

5173: fnd_global.user_id,
5174: FND_GLOBAL.CONC_LOGIN_ID,
5175: sysdate,
5176: FND_GLOBAL.CONC_REQUEST_ID,
5177: fnd_global.CONC_PROGRAM_ID,
5178: 235,
5179: FND_GLOBAL.CONC_LOGIN_ID,
5180: 'MIGRATED')
5181: SELECT

Line 5179: FND_GLOBAL.CONC_LOGIN_ID,

5175: sysdate,
5176: FND_GLOBAL.CONC_REQUEST_ID,
5177: fnd_global.CONC_PROGRAM_ID,
5178: 235,
5179: FND_GLOBAL.CONC_LOGIN_ID,
5180: 'MIGRATED')
5181: SELECT
5182: lookup_code,
5183: meaning,