DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on FND_GLOBAL

Line 567: fnd_global.user_id,

563: 'N',
564: start_date_active,
565: NULL,
566: fnd.LOOKUP_CODE,
567: fnd_global.user_id,
568: SYSDATE,
569: fnd_global.user_id,
570: SYSDATE,
571: FND_GLOBAL.CONC_LOGIN_ID

Line 569: fnd_global.user_id,

565: NULL,
566: fnd.LOOKUP_CODE,
567: fnd_global.user_id,
568: SYSDATE,
569: fnd_global.user_id,
570: SYSDATE,
571: FND_GLOBAL.CONC_LOGIN_ID
572: FROM fnd_lookup_values fnd
573: WHERE lookup_type = l_lookup_type

Line 571: FND_GLOBAL.CONC_LOGIN_ID

567: fnd_global.user_id,
568: SYSDATE,
569: fnd_global.user_id,
570: SYSDATE,
571: FND_GLOBAL.CONC_LOGIN_ID
572: FROM fnd_lookup_values fnd
573: WHERE lookup_type = l_lookup_type
574: AND language=userenv('lang') -- Bug 6441455
575: AND enabled_flag = 'Y'

Line 596: fnd_global.user_id,

592: fnd.LANGUAGE,
593: fnd.source_lang,
594: fnd.Meaning,
595: SYSDATE,
596: fnd_global.user_id,
597: SYSDATE,
598: fnd_global.user_id,
599: FND_GLOBAL.CONC_LOGIN_ID
600: FROM fnd_lookup_values fnd, mtl_categories_b mtl

Line 598: fnd_global.user_id,

594: fnd.Meaning,
595: SYSDATE,
596: fnd_global.user_id,
597: SYSDATE,
598: fnd_global.user_id,
599: FND_GLOBAL.CONC_LOGIN_ID
600: FROM fnd_lookup_values fnd, mtl_categories_b mtl
601: WHERE lookup_type = l_lookup_type
602: AND FND.lookup_code = mtl.segment1

Line 599: FND_GLOBAL.CONC_LOGIN_ID

595: SYSDATE,
596: fnd_global.user_id,
597: SYSDATE,
598: fnd_global.user_id,
599: FND_GLOBAL.CONC_LOGIN_ID
600: FROM fnd_lookup_values fnd, mtl_categories_b mtl
601: WHERE lookup_type = l_lookup_type
602: AND FND.lookup_code = mtl.segment1
603: AND NOT EXISTS

Line 709: fnd_global.user_id,

705: 'STATISTICAL_CODE',
706: SYSDATE,
707: NULL,
708: 'MIGRATED',
709: fnd_global.user_id,
710: SYSDATE,
711: fnd_global.user_id,
712: SYSDATE,
713: FND_GLOBAL.CONC_LOGIN_ID,

Line 711: fnd_global.user_id,

707: NULL,
708: 'MIGRATED',
709: fnd_global.user_id,
710: SYSDATE,
711: fnd_global.user_id,
712: SYSDATE,
713: FND_GLOBAL.CONC_LOGIN_ID,
714: zx_fc_types_reg_assoc_s.nextval,
715: 1)

Line 713: FND_GLOBAL.CONC_LOGIN_ID,

709: fnd_global.user_id,
710: SYSDATE,
711: fnd_global.user_id,
712: SYSDATE,
713: FND_GLOBAL.CONC_LOGIN_ID,
714: zx_fc_types_reg_assoc_s.nextval,
715: 1)
716: SELECT unique tax_regime_code
717: FROM ZX_RATES_B rates,

Line 806: fnd_global.user_id,

802: 'FISCAL CLASSIFICATION CODE',--parent_classification_code
803: l_fc_id, --parent_classification_id
804: 'BR',
805: 'MIGRATED',
806: fnd_global.user_id,
807: SYSDATE,
808: fnd_global.user_id,
809: SYSDATE,
810: FND_GLOBAL.CONC_LOGIN_ID,

Line 808: fnd_global.user_id,

804: 'BR',
805: 'MIGRATED',
806: fnd_global.user_id,
807: SYSDATE,
808: fnd_global.user_id,
809: SYSDATE,
810: FND_GLOBAL.CONC_LOGIN_ID,
811: 1
812: FROM

Line 810: FND_GLOBAL.CONC_LOGIN_ID,

806: fnd_global.user_id,
807: SYSDATE,
808: fnd_global.user_id,
809: SYSDATE,
810: FND_GLOBAL.CONC_LOGIN_ID,
811: 1
812: FROM
813: FND_LOOKUPS lookups
814: WHERE

Line 840: fnd_global.user_id,

836: THEN Initcap(fc_name)
837: ELSE
838: fc_name
839: END,
840: fnd_global.user_id,
841: SYSDATE,
842: fnd_global.user_id,
843: SYSDATE,
844: FND_GLOBAL.CONC_LOGIN_ID,

Line 842: fnd_global.user_id,

838: fc_name
839: END,
840: fnd_global.user_id,
841: SYSDATE,
842: fnd_global.user_id,
843: SYSDATE,
844: FND_GLOBAL.CONC_LOGIN_ID,
845: LANGUAGE,
846: SOURCE_LANGUAGE)

Line 844: FND_GLOBAL.CONC_LOGIN_ID,

840: fnd_global.user_id,
841: SYSDATE,
842: fnd_global.user_id,
843: SYSDATE,
844: FND_GLOBAL.CONC_LOGIN_ID,
845: LANGUAGE,
846: SOURCE_LANGUAGE)
847: INTO ZX_FC_CODES_DENORM_B(
848: CLASSIFICATION_TYPE_ID,

Line 935: fnd_global.user_id,

931: Null,
932: Null,
933: Null,
934: Null,
935: fnd_global.user_id,
936: SYSDATE,
937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,

Line 937: fnd_global.user_id,

933: Null,
934: Null,
935: fnd_global.user_id,
936: SYSDATE,
937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,

Line 938: FND_GLOBAL.CONC_LOGIN_ID,

934: Null,
935: fnd_global.user_id,
936: SYSDATE,
937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,
942: 235,

Line 940: FND_GLOBAL.CONC_REQUEST_ID,

936: SYSDATE,
937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,
942: 235,
943: FND_GLOBAL.CONC_LOGIN_ID,
944: 'MIGRATED')

Line 941: fnd_global.CONC_PROGRAM_ID,

937: fnd_global.user_id,
938: FND_GLOBAL.CONC_LOGIN_ID,
939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,
942: 235,
943: FND_GLOBAL.CONC_LOGIN_ID,
944: 'MIGRATED')
945:

Line 943: FND_GLOBAL.CONC_LOGIN_ID,

939: sysdate,
940: FND_GLOBAL.CONC_REQUEST_ID,
941: fnd_global.CONC_PROGRAM_ID,
942: 235,
943: FND_GLOBAL.CONC_LOGIN_ID,
944: 'MIGRATED')
945:
946: SELECT
947: FL.LOOKUP_CODE fc_code,

Line 1013: fnd_global.user_id,

1009: 'FISCAL_CLASSIFICATION',
1010: SYSDATE,
1011: NULL,
1012: 'MIGRATED',
1013: fnd_global.user_id,
1014: SYSDATE,
1015: fnd_global.user_id,
1016: SYSDATE,
1017: FND_GLOBAL.CONC_LOGIN_ID,

Line 1015: fnd_global.user_id,

1011: NULL,
1012: 'MIGRATED',
1013: fnd_global.user_id,
1014: SYSDATE,
1015: fnd_global.user_id,
1016: SYSDATE,
1017: FND_GLOBAL.CONC_LOGIN_ID,
1018: zx_fc_types_reg_assoc_s.nextval,
1019: 1)

Line 1017: FND_GLOBAL.CONC_LOGIN_ID,

1013: fnd_global.user_id,
1014: SYSDATE,
1015: fnd_global.user_id,
1016: SYSDATE,
1017: FND_GLOBAL.CONC_LOGIN_ID,
1018: zx_fc_types_reg_assoc_s.nextval,
1019: 1)
1020: SELECT
1021: unique tax_regime_code

Line 1136: fnd_global.user_id,

1132: null,----parent_classification_code
1133: null,----parent_classification_id
1134: 'BR',
1135: 'MIGRATED',
1136: fnd_global.user_id,
1137: SYSDATE,
1138: fnd_global.user_id,
1139: SYSDATE,
1140: FND_GLOBAL.CONC_LOGIN_ID,

Line 1138: fnd_global.user_id,

1134: 'BR',
1135: 'MIGRATED',
1136: fnd_global.user_id,
1137: SYSDATE,
1138: fnd_global.user_id,
1139: SYSDATE,
1140: FND_GLOBAL.CONC_LOGIN_ID,
1141: 1
1142: FROM JL_BR_AP_OPERATIONS JLBR

Line 1140: FND_GLOBAL.CONC_LOGIN_ID,

1136: fnd_global.user_id,
1137: SYSDATE,
1138: fnd_global.user_id,
1139: SYSDATE,
1140: FND_GLOBAL.CONC_LOGIN_ID,
1141: 1
1142: FROM JL_BR_AP_OPERATIONS JLBR
1143: WHERE NOT EXISTS
1144: -- this condition makes sure we dont duplicate data

Line 1169: fnd_global.user_id,

1165: THEN Initcap(Meaning)
1166: ELSE
1167: Meaning
1168: END,
1169: fnd_global.user_id,
1170: SYSDATE,
1171: fnd_global.user_id,
1172: SYSDATE,
1173: FND_GLOBAL.CONC_LOGIN_ID,

Line 1171: fnd_global.user_id,

1167: Meaning
1168: END,
1169: fnd_global.user_id,
1170: SYSDATE,
1171: fnd_global.user_id,
1172: SYSDATE,
1173: FND_GLOBAL.CONC_LOGIN_ID,
1174: lang_code,
1175: userenv('LANG'))

Line 1173: FND_GLOBAL.CONC_LOGIN_ID,

1169: fnd_global.user_id,
1170: SYSDATE,
1171: fnd_global.user_id,
1172: SYSDATE,
1173: FND_GLOBAL.CONC_LOGIN_ID,
1174: lang_code,
1175: userenv('LANG'))
1176: INTO ZX_FC_CODES_DENORM_B(
1177: CLASSIFICATION_TYPE_ID,

Line 1264: fnd_global.user_id,

1260: Null,
1261: Null,
1262: Null,
1263: Null,
1264: fnd_global.user_id,
1265: SYSDATE,
1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,

Line 1266: fnd_global.user_id,

1262: Null,
1263: Null,
1264: fnd_global.user_id,
1265: SYSDATE,
1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,

Line 1267: FND_GLOBAL.CONC_LOGIN_ID,

1263: Null,
1264: fnd_global.user_id,
1265: SYSDATE,
1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,
1271: 235,

Line 1269: FND_GLOBAL.CONC_REQUEST_ID,

1265: SYSDATE,
1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,
1271: 235,
1272: FND_GLOBAL.CONC_LOGIN_ID,
1273: 'MIGRATED')

Line 1270: fnd_global.CONC_PROGRAM_ID,

1266: fnd_global.user_id,
1267: FND_GLOBAL.CONC_LOGIN_ID,
1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,
1271: 235,
1272: FND_GLOBAL.CONC_LOGIN_ID,
1273: 'MIGRATED')
1274: SELECT cfo_code Code,

Line 1272: FND_GLOBAL.CONC_LOGIN_ID,

1268: sysdate,
1269: FND_GLOBAL.CONC_REQUEST_ID,
1270: fnd_global.CONC_PROGRAM_ID,
1271: 235,
1272: FND_GLOBAL.CONC_LOGIN_ID,
1273: 'MIGRATED')
1274: SELECT cfo_code Code,
1275: cfo_description Meaning,
1276: JLBR.creation_date ,

Line 1344: fnd_global.user_id,

1340: fc.classification_code,--parent_classification_code
1341: fc.classification_id, --parent_classification_id
1342: 'BR',
1343: 'MIGRATED',
1344: fnd_global.user_id,
1345: SYSDATE,
1346: fnd_global.user_id,
1347: SYSDATE,
1348: FND_GLOBAL.CONC_LOGIN_ID,

Line 1346: fnd_global.user_id,

1342: 'BR',
1343: 'MIGRATED',
1344: fnd_global.user_id,
1345: SYSDATE,
1346: fnd_global.user_id,
1347: SYSDATE,
1348: FND_GLOBAL.CONC_LOGIN_ID,
1349: 1
1350: FROM

Line 1348: FND_GLOBAL.CONC_LOGIN_ID,

1344: fnd_global.user_id,
1345: SYSDATE,
1346: fnd_global.user_id,
1347: SYSDATE,
1348: FND_GLOBAL.CONC_LOGIN_ID,
1349: 1
1350: FROM
1351: JL_BR_AP_OPERATIONS ap_op,
1352: ZX_FC_CODES_DENORM_B fc,

Line 1385: fnd_global.user_id,

1381: THEN Initcap(Meaning)
1382: ELSE
1383: Meaning
1384: END,
1385: fnd_global.user_id,
1386: SYSDATE,
1387: fnd_global.user_id,
1388: SYSDATE,
1389: FND_GLOBAL.CONC_LOGIN_ID,

Line 1387: fnd_global.user_id,

1383: Meaning
1384: END,
1385: fnd_global.user_id,
1386: SYSDATE,
1387: fnd_global.user_id,
1388: SYSDATE,
1389: FND_GLOBAL.CONC_LOGIN_ID,
1390: lang_code,
1391: userenv('LANG'))

Line 1389: FND_GLOBAL.CONC_LOGIN_ID,

1385: fnd_global.user_id,
1386: SYSDATE,
1387: fnd_global.user_id,
1388: SYSDATE,
1389: FND_GLOBAL.CONC_LOGIN_ID,
1390: lang_code,
1391: userenv('LANG'))
1392: INTO ZX_FC_CODES_DENORM_B(
1393: CLASSIFICATION_TYPE_ID,

Line 1480: fnd_global.user_id,

1476: Null,
1477: Null,
1478: Null,
1479: Null,
1480: fnd_global.user_id,
1481: SYSDATE,
1482: fnd_global.user_id,
1483: FND_GLOBAL.CONC_LOGIN_ID,
1484: sysdate,

Line 1482: fnd_global.user_id,

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

Line 1483: FND_GLOBAL.CONC_LOGIN_ID,

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

Line 1485: FND_GLOBAL.CONC_REQUEST_ID,

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

Line 1486: fnd_global.CONC_PROGRAM_ID,

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

Line 1488: FND_GLOBAL.CONC_LOGIN_ID,

1484: sysdate,
1485: FND_GLOBAL.CONC_REQUEST_ID,
1486: fnd_global.CONC_PROGRAM_ID,
1487: 235,
1488: FND_GLOBAL.CONC_LOGIN_ID,
1489: 'MIGRATED')
1490:
1491: SELECT cfo_code Code,
1492: cfo_description Meaning,

Line 1592: fnd_global.user_id,

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

Line 1594: fnd_global.user_id,

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

Line 1596: FND_GLOBAL.CONC_LOGIN_ID,

1592: fnd_global.user_id,
1593: SYSDATE,
1594: fnd_global.user_id,
1595: SYSDATE,
1596: FND_GLOBAL.CONC_LOGIN_ID,
1597: 1
1598:
1599: FROM FND_LOOKUP_VALUES lookups
1600: WHERE

Line 1629: fnd_global.user_id,

1625: THEN Initcap(Meaning)
1626: ELSE
1627: 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: 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 1872: fnd_global.user_id,

1868: Null,
1869: Null,
1870: 'MIGRATED',
1871: zx_fc_country_defaults_s.nextval,
1872: fnd_global.user_id,
1873: SYSDATE,
1874: fnd_global.user_id,
1875: SYSDATE,
1876: FND_GLOBAL.CONC_LOGIN_ID,

Line 1874: fnd_global.user_id,

1870: 'MIGRATED',
1871: zx_fc_country_defaults_s.nextval,
1872: fnd_global.user_id,
1873: SYSDATE,
1874: fnd_global.user_id,
1875: SYSDATE,
1876: FND_GLOBAL.CONC_LOGIN_ID,
1877: 1
1878: FROM ZX_FC_TYPES_B

Line 1876: FND_GLOBAL.CONC_LOGIN_ID,

1872: fnd_global.user_id,
1873: SYSDATE,
1874: fnd_global.user_id,
1875: SYSDATE,
1876: FND_GLOBAL.CONC_LOGIN_ID,
1877: 1
1878: FROM ZX_FC_TYPES_B
1879: WHERE
1880: classification_type_code = 'STATISTICAL_CODE'

Line 1912: fnd_global.user_id,

1908: Null,
1909: Null,
1910: 'MIGRATED',
1911: zx_fc_country_defaults_s.nextval,
1912: fnd_global.user_id,
1913: SYSDATE,
1914: fnd_global.user_id,
1915: SYSDATE,
1916: FND_GLOBAL.CONC_LOGIN_ID,

Line 1914: fnd_global.user_id,

1910: 'MIGRATED',
1911: zx_fc_country_defaults_s.nextval,
1912: fnd_global.user_id,
1913: SYSDATE,
1914: fnd_global.user_id,
1915: SYSDATE,
1916: FND_GLOBAL.CONC_LOGIN_ID,
1917: 1
1918: FROM ZX_FC_TYPES_B

Line 1916: FND_GLOBAL.CONC_LOGIN_ID,

1912: fnd_global.user_id,
1913: SYSDATE,
1914: fnd_global.user_id,
1915: SYSDATE,
1916: FND_GLOBAL.CONC_LOGIN_ID,
1917: 1
1918: FROM ZX_FC_TYPES_B
1919: WHERE
1920: classification_type_code = 'STATISTICAL_CODE'

Line 1952: fnd_global.user_id,

1948: Null,
1949: Null,
1950: 'MIGRATED',
1951: zx_fc_country_defaults_s.nextval,
1952: fnd_global.user_id,
1953: SYSDATE,
1954: fnd_global.user_id,
1955: SYSDATE,
1956: FND_GLOBAL.CONC_LOGIN_ID,

Line 1954: fnd_global.user_id,

1950: 'MIGRATED',
1951: zx_fc_country_defaults_s.nextval,
1952: fnd_global.user_id,
1953: SYSDATE,
1954: fnd_global.user_id,
1955: SYSDATE,
1956: FND_GLOBAL.CONC_LOGIN_ID,
1957: 1
1958: FROM ZX_FC_TYPES_B

Line 1956: FND_GLOBAL.CONC_LOGIN_ID,

1952: fnd_global.user_id,
1953: SYSDATE,
1954: fnd_global.user_id,
1955: SYSDATE,
1956: FND_GLOBAL.CONC_LOGIN_ID,
1957: 1
1958: FROM ZX_FC_TYPES_B
1959: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1960: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'

Line 1991: fnd_global.user_id,

1987: Null,
1988: Null,
1989: 'MIGRATED',
1990: zx_fc_country_defaults_s.nextval,
1991: fnd_global.user_id,
1992: SYSDATE,
1993: fnd_global.user_id,
1994: SYSDATE,
1995: FND_GLOBAL.CONC_LOGIN_ID,

Line 1993: fnd_global.user_id,

1989: 'MIGRATED',
1990: zx_fc_country_defaults_s.nextval,
1991: fnd_global.user_id,
1992: SYSDATE,
1993: fnd_global.user_id,
1994: SYSDATE,
1995: FND_GLOBAL.CONC_LOGIN_ID,
1996: 1
1997: FROM ZX_FC_TYPES_B

Line 1995: FND_GLOBAL.CONC_LOGIN_ID,

1991: fnd_global.user_id,
1992: SYSDATE,
1993: fnd_global.user_id,
1994: SYSDATE,
1995: FND_GLOBAL.CONC_LOGIN_ID,
1996: 1
1997: FROM ZX_FC_TYPES_B
1998: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1999: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'

Line 2027: fnd_global.user_id,

2023: Null,
2024: Null,
2025: 'MIGRATED',
2026: zx_fc_country_defaults_s.nextval,
2027: fnd_global.user_id,
2028: SYSDATE,
2029: fnd_global.user_id,
2030: SYSDATE,
2031: FND_GLOBAL.CONC_LOGIN_ID,

Line 2029: fnd_global.user_id,

2025: 'MIGRATED',
2026: zx_fc_country_defaults_s.nextval,
2027: fnd_global.user_id,
2028: SYSDATE,
2029: fnd_global.user_id,
2030: SYSDATE,
2031: FND_GLOBAL.CONC_LOGIN_ID,
2032: 1
2033: FROM ZX_FC_TYPES_B

Line 2031: FND_GLOBAL.CONC_LOGIN_ID,

2027: fnd_global.user_id,
2028: SYSDATE,
2029: fnd_global.user_id,
2030: SYSDATE,
2031: FND_GLOBAL.CONC_LOGIN_ID,
2032: 1
2033: FROM ZX_FC_TYPES_B
2034: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
2035: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'

Line 2103: fnd_global.user_id,

2099: p_country_code,
2100: 'SEEDED',
2101: 120,
2102: SYSDATE,
2103: fnd_global.user_id,
2104: SYSDATE,
2105: FND_GLOBAL.CONC_LOGIN_ID,
2106: 1
2107: FROM DUAL

Line 2105: FND_GLOBAL.CONC_LOGIN_ID,

2101: 120,
2102: SYSDATE,
2103: fnd_global.user_id,
2104: SYSDATE,
2105: FND_GLOBAL.CONC_LOGIN_ID,
2106: 1
2107: FROM DUAL
2108: WHERE NOT EXISTS
2109: (select NULL from ZX_FC_CODES_B Codes where

Line 2133: fnd_global.user_id,

2129: THEN Initcap(p_classification_name)
2130: ELSE
2131: p_classification_name
2132: END,
2133: fnd_global.user_id,
2134: SYSDATE,
2135: fnd_global.user_id,
2136: SYSDATE,
2137: FND_GLOBAL.CONC_LOGIN_ID,

Line 2135: fnd_global.user_id,

2131: p_classification_name
2132: END,
2133: fnd_global.user_id,
2134: SYSDATE,
2135: fnd_global.user_id,
2136: SYSDATE,
2137: FND_GLOBAL.CONC_LOGIN_ID,
2138: lang_code,
2139: userenv('LANG'))

Line 2137: FND_GLOBAL.CONC_LOGIN_ID,

2133: fnd_global.user_id,
2134: SYSDATE,
2135: fnd_global.user_id,
2136: SYSDATE,
2137: FND_GLOBAL.CONC_LOGIN_ID,
2138: lang_code,
2139: userenv('LANG'))
2140: INTO ZX_FC_CODES_DENORM_B
2141: (CLASSIFICATION_TYPE_ID,

Line 2230: fnd_global.user_id,

2226: Null,
2227: Null,
2228: 120,
2229: SYSDATE,
2230: fnd_global.user_id,
2231: FND_GLOBAL.CONC_LOGIN_ID,
2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,

Line 2231: FND_GLOBAL.CONC_LOGIN_ID,

2227: Null,
2228: 120,
2229: SYSDATE,
2230: fnd_global.user_id,
2231: FND_GLOBAL.CONC_LOGIN_ID,
2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,
2235: 235,

Line 2233: FND_GLOBAL.CONC_REQUEST_ID,

2229: SYSDATE,
2230: fnd_global.user_id,
2231: FND_GLOBAL.CONC_LOGIN_ID,
2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,
2235: 235,
2236: FND_GLOBAL.CONC_LOGIN_ID,
2237: 'SEEDED')

Line 2234: fnd_global.CONC_PROGRAM_ID,

2230: fnd_global.user_id,
2231: FND_GLOBAL.CONC_LOGIN_ID,
2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,
2235: 235,
2236: FND_GLOBAL.CONC_LOGIN_ID,
2237: 'SEEDED')
2238: select

Line 2236: FND_GLOBAL.CONC_LOGIN_ID,

2232: sysdate,
2233: FND_GLOBAL.CONC_REQUEST_ID,
2234: fnd_global.CONC_PROGRAM_ID,
2235: 235,
2236: FND_GLOBAL.CONC_LOGIN_ID,
2237: 'SEEDED')
2238: select
2239: language_code lang_code, fc_codes.classification_id
2240: from

Line 2328: fnd_global.user_id,

2324: p_ancestor_code,----parent_classification_code
2325: p_parent_fc_id,-----parent_classification_id
2326: p_country_code,
2327: 'MIGRATED',
2328: fnd_global.user_id,
2329: SYSDATE,
2330: fnd_global.user_id,
2331: SYSDATE,
2332: FND_GLOBAL.CONC_LOGIN_ID,

Line 2330: fnd_global.user_id,

2326: p_country_code,
2327: 'MIGRATED',
2328: fnd_global.user_id,
2329: SYSDATE,
2330: fnd_global.user_id,
2331: SYSDATE,
2332: FND_GLOBAL.CONC_LOGIN_ID,
2333: 1
2334: FROM FND_LOOKUP_VALUES lookups

Line 2332: FND_GLOBAL.CONC_LOGIN_ID,

2328: fnd_global.user_id,
2329: SYSDATE,
2330: fnd_global.user_id,
2331: SYSDATE,
2332: FND_GLOBAL.CONC_LOGIN_ID,
2333: 1
2334: FROM FND_LOOKUP_VALUES lookups
2335: WHERE
2336: lookups.lookup_type=p_lookup_type

Line 2364: fnd_global.user_id,

2360: THEN Initcap(Meaning)
2361: ELSE
2362: Meaning
2363: END,
2364: fnd_global.user_id,
2365: SYSDATE,
2366: fnd_global.user_id,
2367: SYSDATE,
2368: FND_GLOBAL.CONC_LOGIN_ID,

Line 2366: fnd_global.user_id,

2362: Meaning
2363: END,
2364: fnd_global.user_id,
2365: SYSDATE,
2366: fnd_global.user_id,
2367: SYSDATE,
2368: FND_GLOBAL.CONC_LOGIN_ID,
2369: language,
2370: SOURCE_LANG)

Line 2368: FND_GLOBAL.CONC_LOGIN_ID,

2364: fnd_global.user_id,
2365: SYSDATE,
2366: fnd_global.user_id,
2367: SYSDATE,
2368: FND_GLOBAL.CONC_LOGIN_ID,
2369: language,
2370: SOURCE_LANG)
2371: INTO ZX_FC_CODES_DENORM_B(
2372: CLASSIFICATION_TYPE_ID,

Line 2463: fnd_global.user_id,

2459: Null,
2460: Null,
2461: Null,
2462: Null,
2463: fnd_global.user_id,
2464: SYSDATE,
2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,

Line 2465: fnd_global.user_id,

2461: Null,
2462: Null,
2463: fnd_global.user_id,
2464: SYSDATE,
2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,

Line 2466: FND_GLOBAL.CONC_LOGIN_ID,

2462: Null,
2463: fnd_global.user_id,
2464: SYSDATE,
2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,
2470: 235,

Line 2468: FND_GLOBAL.CONC_REQUEST_ID,

2464: SYSDATE,
2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,
2470: 235,
2471: FND_GLOBAL.CONC_LOGIN_ID,
2472: 'MIGRATED')

Line 2469: fnd_global.CONC_PROGRAM_ID,

2465: fnd_global.user_id,
2466: FND_GLOBAL.CONC_LOGIN_ID,
2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,
2470: 235,
2471: FND_GLOBAL.CONC_LOGIN_ID,
2472: 'MIGRATED')
2473: SELECT lookup_code,

Line 2471: FND_GLOBAL.CONC_LOGIN_ID,

2467: sysdate,
2468: FND_GLOBAL.CONC_REQUEST_ID,
2469: fnd_global.CONC_PROGRAM_ID,
2470: 235,
2471: FND_GLOBAL.CONC_LOGIN_ID,
2472: 'MIGRATED')
2473: SELECT lookup_code,
2474: Meaning,
2475: Language,

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

2576: fc.classification_code ,---parent_classification_code
2577: fc.classification_id, ---parent_classification_id
2578: p_country_code,
2579: p_record_type_code,
2580: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2581: SYSDATE,
2582: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2583: SYSDATE,
2584: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),

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

2578: p_country_code,
2579: p_record_type_code,
2580: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2581: SYSDATE,
2582: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2583: SYSDATE,
2584: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2585: 1
2586: FROM

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

2580: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2581: SYSDATE,
2582: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2583: SYSDATE,
2584: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2585: 1
2586: FROM
2587: ZX_FC_CODES_DENORM_B fc,
2588: ZX_EVENT_CLASSES_VL event,

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

2622: THEN Initcap(Meaning)
2623: ELSE
2624: Meaning
2625: END,
2626: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2627: SYSDATE,
2628: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2629: SYSDATE,
2630: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),

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

2624: Meaning
2625: END,
2626: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2627: SYSDATE,
2628: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2629: SYSDATE,
2630: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2631: language,
2632: SOURCE_LANG)

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

2626: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2627: SYSDATE,
2628: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2629: SYSDATE,
2630: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2631: language,
2632: SOURCE_LANG)
2633: INTO ZX_FC_CODES_DENORM_B(
2634: CLASSIFICATION_TYPE_ID,

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

2717: Null,
2718: Null,
2719: Null,
2720: Null,
2721: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2722: SYSDATE,
2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,

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

2719: Null,
2720: Null,
2721: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2722: SYSDATE,
2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,

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

2720: Null,
2721: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2722: SYSDATE,
2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,
2728: 235,

Line 2726: FND_GLOBAL.CONC_REQUEST_ID,

2722: SYSDATE,
2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,
2728: 235,
2729: FND_GLOBAL.CONC_LOGIN_ID,
2730: p_record_type_code)

Line 2727: fnd_global.CONC_PROGRAM_ID,

2723: decode(p_record_type_code, 'SEEDED', 120, fnd_global.user_id),
2724: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,
2728: 235,
2729: FND_GLOBAL.CONC_LOGIN_ID,
2730: p_record_type_code)
2731: SELECT

Line 2729: FND_GLOBAL.CONC_LOGIN_ID,

2725: sysdate,
2726: FND_GLOBAL.CONC_REQUEST_ID,
2727: fnd_global.CONC_PROGRAM_ID,
2728: 235,
2729: FND_GLOBAL.CONC_LOGIN_ID,
2730: p_record_type_code)
2731: SELECT
2732: lookup_code,
2733: meaning,

Line 2838: fnd_global.user_id,

2834: p_country_code, --country_code
2835: 'SEEDED', --record_type_code
2836: 120,
2837: sysdate,
2838: fnd_global.user_id,
2839: sysdate,
2840: fnd_global.conc_login_id,
2841: 1
2842: FROM

Line 2840: fnd_global.conc_login_id,

2836: 120,
2837: sysdate,
2838: fnd_global.user_id,
2839: sysdate,
2840: fnd_global.conc_login_id,
2841: 1
2842: FROM
2843: ZX_FC_CODES_B fc,
2844: ZX_EVENT_CLASSES_B event

Line 2876: fnd_global.user_id,

2872: THEN Initcap(p_classification_name)
2873: ELSE
2874: p_classification_name
2875: END,
2876: fnd_global.user_id,
2877: sysdate,
2878: fnd_global.user_id,
2879: sysdate,
2880: fnd_global.conc_login_id,

Line 2878: fnd_global.user_id,

2874: p_classification_name
2875: END,
2876: fnd_global.user_id,
2877: sysdate,
2878: fnd_global.user_id,
2879: sysdate,
2880: fnd_global.conc_login_id,
2881: lang_code,
2882: userenv('LANG'))

Line 2880: fnd_global.conc_login_id,

2876: fnd_global.user_id,
2877: sysdate,
2878: fnd_global.user_id,
2879: sysdate,
2880: fnd_global.conc_login_id,
2881: lang_code,
2882: userenv('LANG'))
2883:
2884: INTO ZX_FC_CODES_DENORM_B(

Line 2976: fnd_global.user_id,

2972: Null,
2973: Null,
2974: 120,
2975: sysdate,
2976: fnd_global.user_id,
2977: fnd_global.conc_login_id,
2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,

Line 2977: fnd_global.conc_login_id,

2973: Null,
2974: 120,
2975: sysdate,
2976: fnd_global.user_id,
2977: fnd_global.conc_login_id,
2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,
2981: 235,

Line 2979: fnd_global.conc_request_id,

2975: sysdate,
2976: fnd_global.user_id,
2977: fnd_global.conc_login_id,
2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,
2981: 235,
2982: fnd_global.conc_login_id,
2983: 'SEEDED')

Line 2980: fnd_global.conc_program_id,

2976: fnd_global.user_id,
2977: fnd_global.conc_login_id,
2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,
2981: 235,
2982: fnd_global.conc_login_id,
2983: 'SEEDED')
2984: SELECT

Line 2982: fnd_global.conc_login_id,

2978: sysdate,
2979: fnd_global.conc_request_id,
2980: fnd_global.conc_program_id,
2981: 235,
2982: fnd_global.conc_login_id,
2983: 'SEEDED')
2984: SELECT
2985: event.tax_event_class_code,
2986: event.tax_event_class_name name,

Line 3050: fnd_global.user_id,

3046: 'STATISTICAL CODE',
3047: SYSDATE,
3048: NULL,
3049: 'MIGRATED',
3050: fnd_global.user_id,
3051: SYSDATE,
3052: fnd_global.user_id,
3053: SYSDATE,
3054: FND_GLOBAL.CONC_LOGIN_ID,

Line 3052: fnd_global.user_id,

3048: NULL,
3049: 'MIGRATED',
3050: fnd_global.user_id,
3051: SYSDATE,
3052: fnd_global.user_id,
3053: SYSDATE,
3054: FND_GLOBAL.CONC_LOGIN_ID,
3055: zx_fc_types_reg_assoc_s.nextval,
3056: 1)

Line 3054: FND_GLOBAL.CONC_LOGIN_ID,

3050: fnd_global.user_id,
3051: SYSDATE,
3052: fnd_global.user_id,
3053: SYSDATE,
3054: FND_GLOBAL.CONC_LOGIN_ID,
3055: zx_fc_types_reg_assoc_s.nextval,
3056: 1)
3057: Select unique
3058: tax_regime_code

Line 3118: fnd_global.user_id,

3114: p_owner_id_num,
3115: 1,
3116: 400,
3117: 'MIGRATED',
3118: fnd_global.user_id,
3119: SYSDATE,
3120: fnd_global.user_id,
3121: SYSDATE,
3122: FND_GLOBAL.CONC_LOGIN_ID,

Line 3120: fnd_global.user_id,

3116: 400,
3117: 'MIGRATED',
3118: fnd_global.user_id,
3119: SYSDATE,
3120: fnd_global.user_id,
3121: SYSDATE,
3122: FND_GLOBAL.CONC_LOGIN_ID,
3123: 1
3124: FROM dual

Line 3122: FND_GLOBAL.CONC_LOGIN_ID,

3118: fnd_global.user_id,
3119: SYSDATE,
3120: fnd_global.user_id,
3121: SYSDATE,
3122: FND_GLOBAL.CONC_LOGIN_ID,
3123: 1
3124: FROM dual
3125: WHERE NOT EXISTS
3126: (SELECT null from ZX_FC_TYPES_B

Line 3150: fnd_global.user_id,

3146: THEN Initcap(p_classification_type_name)
3147: ELSE
3148: p_classification_type_name
3149: END,
3150: fnd_global.user_id,
3151: SYSDATE,
3152: fnd_global.user_id,
3153: SYSDATE,
3154: FND_GLOBAL.CONC_LOGIN_ID,

Line 3152: fnd_global.user_id,

3148: p_classification_type_name
3149: END,
3150: fnd_global.user_id,
3151: SYSDATE,
3152: fnd_global.user_id,
3153: SYSDATE,
3154: FND_GLOBAL.CONC_LOGIN_ID,
3155: language_code,
3156: userenv('LANG')

Line 3154: FND_GLOBAL.CONC_LOGIN_ID,

3150: fnd_global.user_id,
3151: SYSDATE,
3152: fnd_global.user_id,
3153: SYSDATE,
3154: FND_GLOBAL.CONC_LOGIN_ID,
3155: language_code,
3156: userenv('LANG')
3157:
3158: FROM FND_LANGUAGES L,

Line 3214: FND_GLOBAL.USER_ID,

3210: 'Y', --INTERNAL_FLAG
3211: 'N', --RECORD_ONLY_FLAG
3212: NULL,
3213: SYSDATE,
3214: FND_GLOBAL.USER_ID,
3215: SYSDATE,
3216: FND_GLOBAL.USER_ID,
3217: FND_GLOBAL.CONC_LOGIN_ID,
3218: 1

Line 3216: FND_GLOBAL.USER_ID,

3212: NULL,
3213: SYSDATE,
3214: FND_GLOBAL.USER_ID,
3215: SYSDATE,
3216: FND_GLOBAL.USER_ID,
3217: FND_GLOBAL.CONC_LOGIN_ID,
3218: 1
3219: FROM dual
3220: WHERE NOT EXISTS

Line 3217: FND_GLOBAL.CONC_LOGIN_ID,

3213: SYSDATE,
3214: FND_GLOBAL.USER_ID,
3215: SYSDATE,
3216: FND_GLOBAL.USER_ID,
3217: FND_GLOBAL.CONC_LOGIN_ID,
3218: 1
3219: FROM dual
3220: WHERE NOT EXISTS
3221: (SELECT null from ZX_DETERMINING_FACTORS_B

Line 3245: FND_GLOBAL.USER_ID,

3241: p_classification_type_name
3242: END,
3243: NULL,
3244: SYSDATE,
3245: FND_GLOBAL.USER_ID,
3246: SYSDATE,
3247: FND_GLOBAL.USER_ID,
3248: FND_GLOBAL.CONC_LOGIN_ID,
3249: detFactors.DETERMINING_FACTOR_ID,

Line 3247: FND_GLOBAL.USER_ID,

3243: NULL,
3244: SYSDATE,
3245: FND_GLOBAL.USER_ID,
3246: SYSDATE,
3247: FND_GLOBAL.USER_ID,
3248: FND_GLOBAL.CONC_LOGIN_ID,
3249: detFactors.DETERMINING_FACTOR_ID,
3250: L.LANGUAGE_CODE,
3251: userenv('LANG')

Line 3248: FND_GLOBAL.CONC_LOGIN_ID,

3244: SYSDATE,
3245: FND_GLOBAL.USER_ID,
3246: SYSDATE,
3247: FND_GLOBAL.USER_ID,
3248: FND_GLOBAL.CONC_LOGIN_ID,
3249: detFactors.DETERMINING_FACTOR_ID,
3250: L.LANGUAGE_CODE,
3251: userenv('LANG')
3252:

Line 3312: fnd_global.user_id,

3308: p_tca_class,
3309: NULL,
3310: NULL,
3311: 'MIGRATED',
3312: fnd_global.user_id,
3313: SYSDATE,
3314: fnd_global.user_id,
3315: SYSDATE,
3316: FND_GLOBAL.CONC_LOGIN_ID,

Line 3314: fnd_global.user_id,

3310: NULL,
3311: 'MIGRATED',
3312: fnd_global.user_id,
3313: SYSDATE,
3314: fnd_global.user_id,
3315: SYSDATE,
3316: FND_GLOBAL.CONC_LOGIN_ID,
3317: 1
3318: FROM dual

Line 3316: FND_GLOBAL.CONC_LOGIN_ID,

3312: fnd_global.user_id,
3313: SYSDATE,
3314: fnd_global.user_id,
3315: SYSDATE,
3316: FND_GLOBAL.CONC_LOGIN_ID,
3317: 1
3318: FROM dual
3319: WHERE NOT EXISTS
3320: (SELECT null from ZX_FC_TYPES_B

Line 3344: fnd_global.user_id,

3340: THEN Initcap(p_classification_type_name)
3341: ELSE
3342: p_classification_type_name
3343: END,
3344: fnd_global.user_id,
3345: SYSDATE,
3346: fnd_global.user_id,
3347: SYSDATE,
3348: FND_GLOBAL.CONC_LOGIN_ID,

Line 3346: fnd_global.user_id,

3342: p_classification_type_name
3343: END,
3344: fnd_global.user_id,
3345: SYSDATE,
3346: fnd_global.user_id,
3347: SYSDATE,
3348: FND_GLOBAL.CONC_LOGIN_ID,
3349: language_code,
3350: userenv('LANG')

Line 3348: FND_GLOBAL.CONC_LOGIN_ID,

3344: fnd_global.user_id,
3345: SYSDATE,
3346: fnd_global.user_id,
3347: SYSDATE,
3348: FND_GLOBAL.CONC_LOGIN_ID,
3349: language_code,
3350: userenv('LANG')
3351:
3352: FROM FND_LANGUAGES L,

Line 3408: FND_GLOBAL.USER_ID,

3404: 'Y', --INTERNAL_FLAG
3405: 'N', --RECORD_ONLY_FLAG
3406: NULL,
3407: SYSDATE,
3408: FND_GLOBAL.USER_ID,
3409: SYSDATE,
3410: FND_GLOBAL.USER_ID,
3411: FND_GLOBAL.CONC_LOGIN_ID,
3412: 1

Line 3410: FND_GLOBAL.USER_ID,

3406: NULL,
3407: SYSDATE,
3408: FND_GLOBAL.USER_ID,
3409: SYSDATE,
3410: FND_GLOBAL.USER_ID,
3411: FND_GLOBAL.CONC_LOGIN_ID,
3412: 1
3413: FROM dual
3414: WHERE NOT EXISTS

Line 3411: FND_GLOBAL.CONC_LOGIN_ID,

3407: SYSDATE,
3408: FND_GLOBAL.USER_ID,
3409: SYSDATE,
3410: FND_GLOBAL.USER_ID,
3411: FND_GLOBAL.CONC_LOGIN_ID,
3412: 1
3413: FROM dual
3414: WHERE NOT EXISTS
3415: (SELECT null from ZX_DETERMINING_FACTORS_B

Line 3439: FND_GLOBAL.USER_ID,

3435: p_classification_type_name
3436: END,
3437: NULL,
3438: SYSDATE,
3439: FND_GLOBAL.USER_ID,
3440: SYSDATE,
3441: FND_GLOBAL.USER_ID,
3442: FND_GLOBAL.CONC_LOGIN_ID,
3443: detFactors.DETERMINING_FACTOR_ID,

Line 3441: FND_GLOBAL.USER_ID,

3437: NULL,
3438: SYSDATE,
3439: FND_GLOBAL.USER_ID,
3440: SYSDATE,
3441: FND_GLOBAL.USER_ID,
3442: FND_GLOBAL.CONC_LOGIN_ID,
3443: detFactors.DETERMINING_FACTOR_ID,
3444: L.LANGUAGE_CODE,
3445: userenv('LANG')

Line 3442: FND_GLOBAL.CONC_LOGIN_ID,

3438: SYSDATE,
3439: FND_GLOBAL.USER_ID,
3440: SYSDATE,
3441: FND_GLOBAL.USER_ID,
3442: FND_GLOBAL.CONC_LOGIN_ID,
3443: detFactors.DETERMINING_FACTOR_ID,
3444: L.LANGUAGE_CODE,
3445: userenv('LANG')
3446: FROM FND_LANGUAGES L,

Line 3503: last_updated_by = fnd_global.user_id,

3499: owner_id_num = l_category_set,
3500: start_position = 1,
3501: num_characters = 400,
3502: last_update_date = sysdate,
3503: last_updated_by = fnd_global.user_id,
3504: object_version_number = object_version_number + 1
3505: WHERE
3506: classification_type_code = 'INTENDED_USE' and
3507: classification_type_categ_code = 'INTENDED_USE_CLASSIFICATION';

Line 3550: fnd_global.user_id,

3546: 'STATISTICAL_CODE',
3547: SYSDATE,
3548: NULL,
3549: 'MIGRATED',
3550: fnd_global.user_id,
3551: SYSDATE,
3552: fnd_global.user_id,
3553: SYSDATE,
3554: FND_GLOBAL.CONC_LOGIN_ID,

Line 3552: fnd_global.user_id,

3548: NULL,
3549: 'MIGRATED',
3550: fnd_global.user_id,
3551: SYSDATE,
3552: fnd_global.user_id,
3553: SYSDATE,
3554: FND_GLOBAL.CONC_LOGIN_ID,
3555: zx_fc_types_reg_assoc_s.NEXTVAL,
3556: 1)

Line 3554: FND_GLOBAL.CONC_LOGIN_ID,

3550: fnd_global.user_id,
3551: SYSDATE,
3552: fnd_global.user_id,
3553: SYSDATE,
3554: FND_GLOBAL.CONC_LOGIN_ID,
3555: zx_fc_types_reg_assoc_s.NEXTVAL,
3556: 1)
3557: SELECT
3558: unique tax_regime_code

Line 3636: fnd_global.user_id,

3632: 'DEDUCTION TAX RULE',--parent_classification_code
3633: l_fc_id,--parent_classification_id
3634: 'FR',
3635: 'MIGRATED',
3636: fnd_global.user_id,
3637: SYSDATE,
3638: fnd_global.user_id,
3639: SYSDATE,
3640: FND_GLOBAL.CONC_LOGIN_ID,

Line 3638: fnd_global.user_id,

3634: 'FR',
3635: 'MIGRATED',
3636: fnd_global.user_id,
3637: SYSDATE,
3638: fnd_global.user_id,
3639: SYSDATE,
3640: FND_GLOBAL.CONC_LOGIN_ID,
3641: 1
3642: FROM

Line 3640: FND_GLOBAL.CONC_LOGIN_ID,

3636: fnd_global.user_id,
3637: SYSDATE,
3638: fnd_global.user_id,
3639: SYSDATE,
3640: FND_GLOBAL.CONC_LOGIN_ID,
3641: 1
3642: FROM
3643: FND_FLEX_VALUES V,
3644: fnd_flex_value_sets vs

Line 3674: fnd_global.user_id,

3670: THEN Initcap(flex_value)
3671: ELSE
3672: flex_value
3673: END,
3674: fnd_global.user_id,
3675: SYSDATE,
3676: fnd_global.user_id,
3677: SYSDATE,
3678: FND_GLOBAL.CONC_LOGIN_ID,

Line 3676: fnd_global.user_id,

3672: flex_value
3673: END,
3674: fnd_global.user_id,
3675: SYSDATE,
3676: fnd_global.user_id,
3677: SYSDATE,
3678: FND_GLOBAL.CONC_LOGIN_ID,
3679: lang_code,
3680: userenv('LANG'))

Line 3678: FND_GLOBAL.CONC_LOGIN_ID,

3674: fnd_global.user_id,
3675: SYSDATE,
3676: fnd_global.user_id,
3677: SYSDATE,
3678: FND_GLOBAL.CONC_LOGIN_ID,
3679: lang_code,
3680: userenv('LANG'))
3681: INTO ZX_FC_CODES_DENORM_B
3682: (CLASSIFICATION_TYPE_ID,

Line 3769: fnd_global.user_id,

3765: Null,
3766: Null,
3767: Null,
3768: Null,
3769: fnd_global.user_id,
3770: SYSDATE,
3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,

Line 3771: fnd_global.user_id,

3767: Null,
3768: Null,
3769: fnd_global.user_id,
3770: SYSDATE,
3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,

Line 3772: FND_GLOBAL.CONC_LOGIN_ID,

3768: Null,
3769: fnd_global.user_id,
3770: SYSDATE,
3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,
3776: 235,

Line 3774: FND_GLOBAL.CONC_REQUEST_ID,

3770: SYSDATE,
3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,
3776: 235,
3777: FND_GLOBAL.CONC_LOGIN_ID,
3778: 'MIGRATED')

Line 3775: fnd_global.CONC_PROGRAM_ID,

3771: fnd_global.user_id,
3772: FND_GLOBAL.CONC_LOGIN_ID,
3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,
3776: 235,
3777: FND_GLOBAL.CONC_LOGIN_ID,
3778: 'MIGRATED')
3779: SELECT

Line 3777: FND_GLOBAL.CONC_LOGIN_ID,

3773: sysdate,
3774: FND_GLOBAL.CONC_REQUEST_ID,
3775: fnd_global.CONC_PROGRAM_ID,
3776: 235,
3777: FND_GLOBAL.CONC_LOGIN_ID,
3778: 'MIGRATED')
3779: SELECT
3780: flex_value,
3781: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')) start_date_active,

Line 3862: fnd_global.user_id,

3858: 'DOCUMENT TYPE',--parent_classification_code
3859: l_fc_id, --parent_classification_id
3860: 'CL',
3861: 'MIGRATED',
3862: fnd_global.user_id,
3863: SYSDATE,
3864: fnd_global.user_id,
3865: SYSDATE,
3866: FND_GLOBAL.CONC_LOGIN_ID,

Line 3864: fnd_global.user_id,

3860: 'CL',
3861: 'MIGRATED',
3862: fnd_global.user_id,
3863: SYSDATE,
3864: fnd_global.user_id,
3865: SYSDATE,
3866: FND_GLOBAL.CONC_LOGIN_ID,
3867: 1
3868:

Line 3866: FND_GLOBAL.CONC_LOGIN_ID,

3862: fnd_global.user_id,
3863: SYSDATE,
3864: fnd_global.user_id,
3865: SYSDATE,
3866: FND_GLOBAL.CONC_LOGIN_ID,
3867: 1
3868:
3869: FROM FND_LOOKUPS lookups
3870: WHERE

Line 3895: fnd_global.user_id,

3891: SOURCE_LANG)
3892: VALUES
3893: (classification_id,
3894: meaning,
3895: fnd_global.user_id,
3896: SYSDATE,
3897: fnd_global.user_id,
3898: SYSDATE,
3899: FND_GLOBAL.CONC_LOGIN_ID,

Line 3897: fnd_global.user_id,

3893: (classification_id,
3894: meaning,
3895: fnd_global.user_id,
3896: SYSDATE,
3897: fnd_global.user_id,
3898: SYSDATE,
3899: FND_GLOBAL.CONC_LOGIN_ID,
3900: language,
3901: source_lang)

Line 3899: FND_GLOBAL.CONC_LOGIN_ID,

3895: fnd_global.user_id,
3896: SYSDATE,
3897: fnd_global.user_id,
3898: SYSDATE,
3899: FND_GLOBAL.CONC_LOGIN_ID,
3900: language,
3901: source_lang)
3902:
3903: INTO ZX_FC_CODES_DENORM_B

Line 3992: fnd_global.user_id,

3988: Null,
3989: Null,
3990: Null,
3991: Null,
3992: fnd_global.user_id,
3993: SYSDATE,
3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,

Line 3994: fnd_global.user_id,

3990: Null,
3991: Null,
3992: fnd_global.user_id,
3993: SYSDATE,
3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,

Line 3995: FND_GLOBAL.CONC_LOGIN_ID,

3991: Null,
3992: fnd_global.user_id,
3993: SYSDATE,
3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,
3999: 235,

Line 3997: FND_GLOBAL.CONC_REQUEST_ID,

3993: SYSDATE,
3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,
3999: 235,
4000: FND_GLOBAL.CONC_LOGIN_ID,
4001: 'MIGRATED')

Line 3998: fnd_global.CONC_PROGRAM_ID,

3994: fnd_global.user_id,
3995: FND_GLOBAL.CONC_LOGIN_ID,
3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,
3999: 235,
4000: FND_GLOBAL.CONC_LOGIN_ID,
4001: 'MIGRATED')
4002: SELECT

Line 4000: FND_GLOBAL.CONC_LOGIN_ID,

3996: sysdate,
3997: FND_GLOBAL.CONC_REQUEST_ID,
3998: fnd_global.CONC_PROGRAM_ID,
3999: 235,
4000: FND_GLOBAL.CONC_LOGIN_ID,
4001: 'MIGRATED')
4002: SELECT
4003: lookup_code,
4004: meaning,

Line 4106: fnd_global.user_id,

4102: 'FISCAL_CLASSIFICATION',
4103: SYSDATE,
4104: NULL,
4105: 'MIGRATED',
4106: fnd_global.user_id,
4107: SYSDATE,
4108: fnd_global.user_id,
4109: SYSDATE,
4110: FND_GLOBAL.CONC_LOGIN_ID,

Line 4108: fnd_global.user_id,

4104: NULL,
4105: 'MIGRATED',
4106: fnd_global.user_id,
4107: SYSDATE,
4108: fnd_global.user_id,
4109: SYSDATE,
4110: FND_GLOBAL.CONC_LOGIN_ID,
4111: zx_fc_types_reg_assoc_s.NEXTVAL,
4112: 1)

Line 4110: FND_GLOBAL.CONC_LOGIN_ID,

4106: fnd_global.user_id,
4107: SYSDATE,
4108: fnd_global.user_id,
4109: SYSDATE,
4110: FND_GLOBAL.CONC_LOGIN_ID,
4111: zx_fc_types_reg_assoc_s.NEXTVAL,
4112: 1)
4113:
4114: SELECT unique

Line 4161: fnd_global.user_id,

4157: event.tax_event_class_code, --parent_classification_code
4158: fc.classification_id, --parent_classification_id
4159: NULL, --country_code is null to share AR,BR,CO country
4160: 'MIGRATED', --record_type_code
4161: fnd_global.user_id,
4162: sysdate,
4163: fnd_global.user_id,
4164: sysdate,
4165: fnd_global.conc_login_id,

Line 4163: fnd_global.user_id,

4159: NULL, --country_code is null to share AR,BR,CO country
4160: 'MIGRATED', --record_type_code
4161: fnd_global.user_id,
4162: sysdate,
4163: fnd_global.user_id,
4164: sysdate,
4165: fnd_global.conc_login_id,
4166: 1
4167:

Line 4165: fnd_global.conc_login_id,

4161: fnd_global.user_id,
4162: sysdate,
4163: fnd_global.user_id,
4164: sysdate,
4165: fnd_global.conc_login_id,
4166: 1
4167:
4168: FROM
4169:

Line 4213: fnd_global.user_id,

4209: THEN Initcap(fc_name)
4210: ELSE
4211: fc_name
4212: END,
4213: fnd_global.user_id,
4214: sysdate,
4215: fnd_global.user_id,
4216: sysdate,
4217: fnd_global.conc_login_id,

Line 4215: fnd_global.user_id,

4211: fc_name
4212: END,
4213: fnd_global.user_id,
4214: sysdate,
4215: fnd_global.user_id,
4216: sysdate,
4217: fnd_global.conc_login_id,
4218: LANGUAGE,
4219: SOURCE_LANGUAGE)

Line 4217: fnd_global.conc_login_id,

4213: fnd_global.user_id,
4214: sysdate,
4215: fnd_global.user_id,
4216: sysdate,
4217: fnd_global.conc_login_id,
4218: LANGUAGE,
4219: SOURCE_LANGUAGE)
4220:
4221: INTO ZX_FC_CODES_DENORM_B(

Line 4310: fnd_global.user_id,

4306: Null,
4307: Null,
4308: Null,
4309: Null,
4310: fnd_global.user_id,
4311: sysdate,
4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,

Line 4312: fnd_global.user_id,

4308: Null,
4309: Null,
4310: fnd_global.user_id,
4311: sysdate,
4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,

Line 4313: fnd_global.conc_login_id,

4309: Null,
4310: fnd_global.user_id,
4311: sysdate,
4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,
4317: 235,

Line 4315: fnd_global.conc_request_id,

4311: sysdate,
4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,
4317: 235,
4318: fnd_global.conc_login_id,
4319: 'MIGRATED')

Line 4316: fnd_global.conc_program_id,

4312: fnd_global.user_id,
4313: fnd_global.conc_login_id,
4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,
4317: 235,
4318: fnd_global.conc_login_id,
4319: 'MIGRATED')
4320: SELECT

Line 4318: fnd_global.conc_login_id,

4314: sysdate,
4315: fnd_global.conc_request_id,
4316: fnd_global.conc_program_id,
4317: 235,
4318: fnd_global.conc_login_id,
4319: 'MIGRATED')
4320: SELECT
4321: codes.fc_code,
4322: codes.fc_name,

Line 4676: fnd_global.user_id,

4672: 'LEASE_MGT_PROD_FISC_CLASS',
4673: SYSDATE,
4674: NULL,
4675: 'MIGRATED',
4676: fnd_global.user_id,
4677: SYSDATE,
4678: fnd_global.user_id,
4679: SYSDATE,
4680: FND_GLOBAL.CONC_LOGIN_ID,

Line 4678: fnd_global.user_id,

4674: NULL,
4675: 'MIGRATED',
4676: fnd_global.user_id,
4677: SYSDATE,
4678: fnd_global.user_id,
4679: SYSDATE,
4680: FND_GLOBAL.CONC_LOGIN_ID,
4681: zx_fc_types_reg_assoc_s.nextval,
4682: 1)

Line 4680: FND_GLOBAL.CONC_LOGIN_ID,

4676: fnd_global.user_id,
4677: SYSDATE,
4678: fnd_global.user_id,
4679: SYSDATE,
4680: FND_GLOBAL.CONC_LOGIN_ID,
4681: zx_fc_types_reg_assoc_s.nextval,
4682: 1)
4683: SELECT unique rates.tax_regime_code
4684: FROM ZX_RATES_B rates,

Line 4818: fnd_global.user_id,

4814: null,----parent_classification_code
4815: null,----parent_classification_id
4816: null,
4817: 'MIGRATED',
4818: fnd_global.user_id,
4819: SYSDATE,
4820: fnd_global.user_id,
4821: SYSDATE,
4822: FND_GLOBAL.CONC_LOGIN_ID,

Line 4820: fnd_global.user_id,

4816: null,
4817: 'MIGRATED',
4818: fnd_global.user_id,
4819: SYSDATE,
4820: fnd_global.user_id,
4821: SYSDATE,
4822: FND_GLOBAL.CONC_LOGIN_ID,
4823: 1
4824: FROM FND_LOOKUP_VALUES lookups

Line 4822: FND_GLOBAL.CONC_LOGIN_ID,

4818: fnd_global.user_id,
4819: SYSDATE,
4820: fnd_global.user_id,
4821: SYSDATE,
4822: FND_GLOBAL.CONC_LOGIN_ID,
4823: 1
4824: FROM FND_LOOKUP_VALUES lookups
4825: WHERE lookups.lookup_type='AR_TAX_TRX_BUSINESS_CATEGORY'
4826: AND LANGUAGE = userenv('LANG')

Line 4852: fnd_global.user_id,

4848: THEN Initcap(Meaning)
4849: ELSE
4850: Meaning
4851: END,
4852: fnd_global.user_id,
4853: SYSDATE,
4854: fnd_global.user_id,
4855: SYSDATE,
4856: FND_GLOBAL.CONC_LOGIN_ID,

Line 4854: fnd_global.user_id,

4850: Meaning
4851: END,
4852: fnd_global.user_id,
4853: SYSDATE,
4854: fnd_global.user_id,
4855: SYSDATE,
4856: FND_GLOBAL.CONC_LOGIN_ID,
4857: language,
4858: source_lang)

Line 4856: FND_GLOBAL.CONC_LOGIN_ID,

4852: fnd_global.user_id,
4853: SYSDATE,
4854: fnd_global.user_id,
4855: SYSDATE,
4856: FND_GLOBAL.CONC_LOGIN_ID,
4857: language,
4858: source_lang)
4859: INTO ZX_FC_CODES_DENORM_B(
4860: CLASSIFICATION_TYPE_ID,

Line 4947: fnd_global.user_id,

4943: Null,
4944: Null,
4945: Null,
4946: Null,
4947: fnd_global.user_id,
4948: SYSDATE,
4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,

Line 4949: fnd_global.user_id,

4945: Null,
4946: Null,
4947: fnd_global.user_id,
4948: SYSDATE,
4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,

Line 4950: FND_GLOBAL.CONC_LOGIN_ID,

4946: Null,
4947: fnd_global.user_id,
4948: SYSDATE,
4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,
4954: 235,

Line 4952: FND_GLOBAL.CONC_REQUEST_ID,

4948: SYSDATE,
4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,
4954: 235,
4955: FND_GLOBAL.CONC_LOGIN_ID,
4956: 'MIGRATED')

Line 4953: fnd_global.CONC_PROGRAM_ID,

4949: fnd_global.user_id,
4950: FND_GLOBAL.CONC_LOGIN_ID,
4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,
4954: 235,
4955: FND_GLOBAL.CONC_LOGIN_ID,
4956: 'MIGRATED')
4957: SELECT

Line 4955: FND_GLOBAL.CONC_LOGIN_ID,

4951: sysdate,
4952: FND_GLOBAL.CONC_REQUEST_ID,
4953: fnd_global.CONC_PROGRAM_ID,
4954: 235,
4955: FND_GLOBAL.CONC_LOGIN_ID,
4956: 'MIGRATED')
4957: SELECT
4958: lookup_code,
4959: meaning,