APPS.ZX_PTP_MIGRATE_PKG dependencies on FND_GLOBAL

Line 149: fnd_global.user_id, --Created By

145: NULL, --Legal Registration Id
146: 'Y', --Default Registration Flag
147: NULL, --Account_Id
148: 'MIGRATED', --Record Type Code
149: fnd_global.user_id, --Created By
150: SYSDATE, --Creation Date
151: fnd_global.user_id, --Last Updated By
152: SYSDATE, --Last Update Date
153: FND_GLOBAL.CONC_LOGIN_ID, --Last_Update_Login

Line 151: fnd_global.user_id, --Last Updated By

147: NULL, --Account_Id
148: 'MIGRATED', --Record Type Code
149: fnd_global.user_id, --Created By
150: SYSDATE, --Creation Date
151: fnd_global.user_id, --Last Updated By
152: SYSDATE, --Last Update Date
153: FND_GLOBAL.CONC_LOGIN_ID, --Last_Update_Login
154: NULL, --Program Application Id
155: FND_GLOBAL.CONC_REQUEST_ID, --REQUEST_ID

Line 153: FND_GLOBAL.CONC_LOGIN_ID, --Last_Update_Login

149: fnd_global.user_id, --Created By
150: SYSDATE, --Creation Date
151: fnd_global.user_id, --Last Updated By
152: SYSDATE, --Last Update Date
153: FND_GLOBAL.CONC_LOGIN_ID, --Last_Update_Login
154: NULL, --Program Application Id
155: FND_GLOBAL.CONC_REQUEST_ID, --REQUEST_ID
156: FND_GLOBAL.CONC_PROGRAM_ID, --PROGRAM_ID
157: FND_GLOBAL.CONC_LOGIN_ID , --PROGRAM_LOGIN_ID

Line 155: FND_GLOBAL.CONC_REQUEST_ID, --REQUEST_ID

151: fnd_global.user_id, --Last Updated By
152: SYSDATE, --Last Update Date
153: FND_GLOBAL.CONC_LOGIN_ID, --Last_Update_Login
154: NULL, --Program Application Id
155: FND_GLOBAL.CONC_REQUEST_ID, --REQUEST_ID
156: FND_GLOBAL.CONC_PROGRAM_ID, --PROGRAM_ID
157: FND_GLOBAL.CONC_LOGIN_ID , --PROGRAM_LOGIN_ID
158: 1
159:

Line 156: FND_GLOBAL.CONC_PROGRAM_ID, --PROGRAM_ID

152: SYSDATE, --Last Update Date
153: FND_GLOBAL.CONC_LOGIN_ID, --Last_Update_Login
154: NULL, --Program Application Id
155: FND_GLOBAL.CONC_REQUEST_ID, --REQUEST_ID
156: FND_GLOBAL.CONC_PROGRAM_ID, --PROGRAM_ID
157: FND_GLOBAL.CONC_LOGIN_ID , --PROGRAM_LOGIN_ID
158: 1
159:
160: FROM ZX_PARTY_TAX_PROFILE

Line 157: FND_GLOBAL.CONC_LOGIN_ID , --PROGRAM_LOGIN_ID

153: FND_GLOBAL.CONC_LOGIN_ID, --Last_Update_Login
154: NULL, --Program Application Id
155: FND_GLOBAL.CONC_REQUEST_ID, --REQUEST_ID
156: FND_GLOBAL.CONC_PROGRAM_ID, --PROGRAM_ID
157: FND_GLOBAL.CONC_LOGIN_ID , --PROGRAM_LOGIN_ID
158: 1
159:
160: FROM ZX_PARTY_TAX_PROFILE
161:

Line 669: ,Fnd_Global.User_Id

665: , 'MIGRATED' -- RECORD_TYPE_CODE
666: , nvl(HRloc.Tax_Name, Fso.Vat_Code) -- TAX_CLASSIFICATION_CODE
667: ,'N' -- Self_Assess_Flag
668: ,'N' -- Allow_Offset_Tax_Flag
669: ,Fnd_Global.User_Id
670: ,Sysdate
671: ,Fnd_Global.User_Id
672: ,Sysdate
673: ,Fnd_Global.Conc_Login_Id

Line 671: ,Fnd_Global.User_Id

667: ,'N' -- Self_Assess_Flag
668: ,'N' -- Allow_Offset_Tax_Flag
669: ,Fnd_Global.User_Id
670: ,Sysdate
671: ,Fnd_Global.User_Id
672: ,Sysdate
673: ,Fnd_Global.Conc_Login_Id
674: ,1
675: FROM

Line 673: ,Fnd_Global.Conc_Login_Id

669: ,Fnd_Global.User_Id
670: ,Sysdate
671: ,Fnd_Global.User_Id
672: ,Sysdate
673: ,Fnd_Global.Conc_Login_Id
674: ,1
675: FROM
676: xle_entity_profiles XEP,
677: Hr_Locations_All HrLoc

Line 793: ,Fnd_Global.User_Id -- Who Column

789: ,'MIGRATED' -- RECORD_TYPE_CODE
790: ,nvl(HRloc.Tax_Name, Fso.Vat_Code) --TAX_CLASSIFICATION_CODE
791: ,'N' -- Self_Assess_Flag
792: ,'N' -- Allow_Offset_Tax_Flag
793: ,Fnd_Global.User_Id -- Who Column
794: ,Sysdate -- Who Column
795: ,Fnd_Global.User_Id -- Who Column
796: ,Sysdate -- Who Column
797: ,Fnd_Global.Conc_Login_Id -- Who Column

Line 795: ,Fnd_Global.User_Id -- Who Column

791: ,'N' -- Self_Assess_Flag
792: ,'N' -- Allow_Offset_Tax_Flag
793: ,Fnd_Global.User_Id -- Who Column
794: ,Sysdate -- Who Column
795: ,Fnd_Global.User_Id -- Who Column
796: ,Sysdate -- Who Column
797: ,Fnd_Global.Conc_Login_Id -- Who Column
798: ,1
799: FROM

Line 797: ,Fnd_Global.Conc_Login_Id -- Who Column

793: ,Fnd_Global.User_Id -- Who Column
794: ,Sysdate -- Who Column
795: ,Fnd_Global.User_Id -- Who Column
796: ,Sysdate -- Who Column
797: ,Fnd_Global.Conc_Login_Id -- Who Column
798: ,1
799: FROM
800: Hr_Locations_All HrLoc
801: ,xle_etb_profiles XEP

Line 888: ,fnd_global.user_id

884: ,hrloc.global_Attribute5
885: ,hrloc.global_Attribute6
886: ,hrloc.global_Attribute7
887: ,'MIGRATED' -- Record Type
888: ,fnd_global.user_id
889: ,SYSDATE
890: ,fnd_global.user_id
891: ,SYSDATE
892: ,FND_GLOBAL.CONC_LOGIN_ID

Line 890: ,fnd_global.user_id

886: ,hrloc.global_Attribute7
887: ,'MIGRATED' -- Record Type
888: ,fnd_global.user_id
889: ,SYSDATE
890: ,fnd_global.user_id
891: ,SYSDATE
892: ,FND_GLOBAL.CONC_LOGIN_ID
893: ,1
894: FROM

Line 892: ,FND_GLOBAL.CONC_LOGIN_ID

888: ,fnd_global.user_id
889: ,SYSDATE
890: ,fnd_global.user_id
891: ,SYSDATE
892: ,FND_GLOBAL.CONC_LOGIN_ID
893: ,1
894: FROM
895: zx_party_tax_profile PTP,
896: Hr_Locations_All HrLoc,

Line 987: ,fnd_global.user_id

983: ,NULL -- Rep_Party_Tax_Name
984: ,NULL -- Legal Registration_ID
985: ,'Y' -- Default Registration Flag
986: ,'MIGRATED' -- Record Type
987: ,fnd_global.user_id
988: ,SYSDATE
989: ,fnd_global.user_id
990: ,SYSDATE
991: ,FND_GLOBAL.CONC_LOGIN_ID

Line 989: ,fnd_global.user_id

985: ,'Y' -- Default Registration Flag
986: ,'MIGRATED' -- Record Type
987: ,fnd_global.user_id
988: ,SYSDATE
989: ,fnd_global.user_id
990: ,SYSDATE
991: ,FND_GLOBAL.CONC_LOGIN_ID
992: ,1
993: FROM

Line 991: ,FND_GLOBAL.CONC_LOGIN_ID

987: ,fnd_global.user_id
988: ,SYSDATE
989: ,fnd_global.user_id
990: ,SYSDATE
991: ,FND_GLOBAL.CONC_LOGIN_ID
992: ,1
993: FROM
994: jl_br_company_infos jl
995: ,gl_ledger_le_v gl

Line 1078: ,fnd_global.user_id

1074: ,NULL -- Rep_Party_Tax_Name
1075: ,NULL -- Legal Registration_ID
1076: ,'Y' -- Default Registration Flag
1077: ,'MIGRATED' -- Record Type
1078: ,fnd_global.user_id
1079: ,SYSDATE
1080: ,fnd_global.user_id
1081: ,SYSDATE
1082: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1080: ,fnd_global.user_id

1076: ,'Y' -- Default Registration Flag
1077: ,'MIGRATED' -- Record Type
1078: ,fnd_global.user_id
1079: ,SYSDATE
1080: ,fnd_global.user_id
1081: ,SYSDATE
1082: ,FND_GLOBAL.CONC_LOGIN_ID
1083: ,1
1084: FROM

Line 1082: ,FND_GLOBAL.CONC_LOGIN_ID

1078: ,fnd_global.user_id
1079: ,SYSDATE
1080: ,fnd_global.user_id
1081: ,SYSDATE
1082: ,FND_GLOBAL.CONC_LOGIN_ID
1083: ,1
1084: FROM
1085: jl_br_company_infos jl
1086: ,gl_ledger_le_v gl

Line 1153: ,fnd_global.user_id

1149: ,NULL -- Rep_Party_Tax_Name
1150: ,NULL -- Legal Registration_ID
1151: ,'Y' -- Default Registration Flag
1152: ,'MIGRATED' -- Record Type
1153: ,fnd_global.user_id
1154: ,SYSDATE
1155: ,fnd_global.user_id
1156: ,SYSDATE
1157: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1155: ,fnd_global.user_id

1151: ,'Y' -- Default Registration Flag
1152: ,'MIGRATED' -- Record Type
1153: ,fnd_global.user_id
1154: ,SYSDATE
1155: ,fnd_global.user_id
1156: ,SYSDATE
1157: ,FND_GLOBAL.CONC_LOGIN_ID
1158: ,1
1159: FROM

Line 1157: ,FND_GLOBAL.CONC_LOGIN_ID

1153: ,fnd_global.user_id
1154: ,SYSDATE
1155: ,fnd_global.user_id
1156: ,SYSDATE
1157: ,FND_GLOBAL.CONC_LOGIN_ID
1158: ,1
1159: FROM
1160: jl_br_company_infos jl
1161: ,gl_ledger_le_v gl

Line 1299: ,fnd_global.user_id -- Who Columns

1295: ,'MIGRATED' -- Record Type
1296: ,vat_code -- Tax Classification
1297: ,'N' -- Self_Assess_Flag
1298: ,nvl(offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
1299: ,fnd_global.user_id -- Who Columns
1300: ,SYSDATE -- Who Columns
1301: ,fnd_global.user_id -- Who Columns
1302: ,SYSDATE -- Who Columns
1303: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

Line 1301: ,fnd_global.user_id -- Who Columns

1297: ,'N' -- Self_Assess_Flag
1298: ,nvl(offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
1299: ,fnd_global.user_id -- Who Columns
1300: ,SYSDATE -- Who Columns
1301: ,fnd_global.user_id -- Who Columns
1302: ,SYSDATE -- Who Columns
1303: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1304: , 1
1305: FROM ap_suppliers PV

Line 1303: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

1299: ,fnd_global.user_id -- Who Columns
1300: ,SYSDATE -- Who Columns
1301: ,fnd_global.user_id -- Who Columns
1302: ,SYSDATE -- Who Columns
1303: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1304: , 1
1305: FROM ap_suppliers PV
1306: WHERE VENDOR_ID = nvl(p_party_ID,VENDOR_ID)
1307: AND not exists (select 1 from zx_party_tax_profile

Line 1372: ,fnd_global.user_id

1368: ,NULL -- Rep_Party_Tax_Name
1369: ,NULL -- Legal Registration_ID
1370: ,'Y' -- Default Registration Flag
1371: ,'MIGRATED' -- Record Type
1372: ,fnd_global.user_id
1373: ,SYSDATE
1374: ,fnd_global.user_id
1375: ,SYSDATE
1376: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1374: ,fnd_global.user_id

1370: ,'Y' -- Default Registration Flag
1371: ,'MIGRATED' -- Record Type
1372: ,fnd_global.user_id
1373: ,SYSDATE
1374: ,fnd_global.user_id
1375: ,SYSDATE
1376: ,FND_GLOBAL.CONC_LOGIN_ID
1377: ,1
1378: FROM ap_suppliers PV,

Line 1376: ,FND_GLOBAL.CONC_LOGIN_ID

1372: ,fnd_global.user_id
1373: ,SYSDATE
1374: ,fnd_global.user_id
1375: ,SYSDATE
1376: ,FND_GLOBAL.CONC_LOGIN_ID
1377: ,1
1378: FROM ap_suppliers PV,
1379: zx_party_tax_profile PTP
1380: WHERE

Line 1444: fnd_global.user_id,

1440: DESCRIPTION,
1441: ENABLED_FLAG,
1442: START_DATE_ACTIVE,
1443: END_DATE_ACTIVE,
1444: fnd_global.user_id,
1445: SYSDATE,
1446: fnd_global.user_id,
1447: fnd_global.conc_login_id,
1448: SYSDATE,

Line 1446: fnd_global.user_id,

1442: START_DATE_ACTIVE,
1443: END_DATE_ACTIVE,
1444: fnd_global.user_id,
1445: SYSDATE,
1446: fnd_global.user_id,
1447: fnd_global.conc_login_id,
1448: SYSDATE,
1449: SOURCE_LANG,
1450: SECURITY_GROUP_ID,

Line 1447: fnd_global.conc_login_id,

1443: END_DATE_ACTIVE,
1444: fnd_global.user_id,
1445: SYSDATE,
1446: fnd_global.user_id,
1447: fnd_global.conc_login_id,
1448: SYSDATE,
1449: SOURCE_LANG,
1450: SECURITY_GROUP_ID,
1451: VIEW_APPLICATION_ID,

Line 1603: ,fnd_global.user_id -- Who Columns

1599: ,'MIGRATED' -- Record Type
1600: ,VAT_CODE
1601: ,'N'
1602: ,ALLOW_OFFSET_TAX_FLAG
1603: ,fnd_global.user_id -- Who Columns
1604: ,SYSDATE -- Who Columns
1605: ,fnd_global.user_id -- Who Columns
1606: ,SYSDATE -- Who Columns
1607: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

Line 1605: ,fnd_global.user_id -- Who Columns

1601: ,'N'
1602: ,ALLOW_OFFSET_TAX_FLAG
1603: ,fnd_global.user_id -- Who Columns
1604: ,SYSDATE -- Who Columns
1605: ,fnd_global.user_id -- Who Columns
1606: ,SYSDATE -- Who Columns
1607: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1608: ,1)
1609: (SELECT

Line 1607: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

1603: ,fnd_global.user_id -- Who Columns
1604: ,SYSDATE -- Who Columns
1605: ,fnd_global.user_id -- Who Columns
1606: ,SYSDATE -- Who Columns
1607: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1608: ,1)
1609: (SELECT
1610: PVS.PARTY_SITE_ID PARTY_SITE_ID-- Party ID
1611: ,PVS.Vat_Registration_Num VAT_REGISTRATION_NUM

Line 1698: ,fnd_global.user_id

1694: ,NULL -- Rep_Party_Tax_Name
1695: ,NULL -- Legal Registration_ID
1696: ,'Y' -- Default Registration Flag
1697: ,'MIGRATED' -- Record Type
1698: ,fnd_global.user_id
1699: ,SYSDATE
1700: ,fnd_global.user_id
1701: ,SYSDATE
1702: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1700: ,fnd_global.user_id

1696: ,'Y' -- Default Registration Flag
1697: ,'MIGRATED' -- Record Type
1698: ,fnd_global.user_id
1699: ,SYSDATE
1700: ,fnd_global.user_id
1701: ,SYSDATE
1702: ,FND_GLOBAL.CONC_LOGIN_ID
1703: ,1
1704: )

Line 1702: ,FND_GLOBAL.CONC_LOGIN_ID

1698: ,fnd_global.user_id
1699: ,SYSDATE
1700: ,fnd_global.user_id
1701: ,SYSDATE
1702: ,FND_GLOBAL.CONC_LOGIN_ID
1703: ,1
1704: )
1705:
1706: (SELECT

Line 1800: , fnd_global.user_id -- Who Columns

1796: ,'MIGRATED' -- Record Type
1797: ,pvs.vat_code -- Tax Classification
1798: ,'N' -- Self_Assess_Flag
1799: , nvl(pv.offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
1800: , fnd_global.user_id -- Who Columns
1801: ,SYSDATE -- Who Columns
1802: ,fnd_global.user_id -- Who Columns
1803: ,SYSDATE -- Who Columns
1804: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

Line 1802: ,fnd_global.user_id -- Who Columns

1798: ,'N' -- Self_Assess_Flag
1799: , nvl(pv.offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
1800: , fnd_global.user_id -- Who Columns
1801: ,SYSDATE -- Who Columns
1802: ,fnd_global.user_id -- Who Columns
1803: ,SYSDATE -- Who Columns
1804: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1805: ,1
1806: FROM ap_supplier_sites_all Pvs,

Line 1804: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

1800: , fnd_global.user_id -- Who Columns
1801: ,SYSDATE -- Who Columns
1802: ,fnd_global.user_id -- Who Columns
1803: ,SYSDATE -- Who Columns
1804: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1805: ,1
1806: FROM ap_supplier_sites_all Pvs,
1807: ap_suppliers Pv
1808: WHERE pvs.Vendor_Site_Id = nvl(P_Party_Id,pvs.Vendor_site_Id)

Line 1867: ,fnd_global.user_id

1863: ,NULL -- Rep_Party_Tax_Name
1864: ,NULL -- Legal Registration_ID
1865: ,'Y' -- Default Registration Flag
1866: ,'MIGRATED' -- Record Type
1867: ,fnd_global.user_id
1868: ,SYSDATE
1869: ,fnd_global.user_id
1870: ,SYSDATE
1871: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1869: ,fnd_global.user_id

1865: ,'Y' -- Default Registration Flag
1866: ,'MIGRATED' -- Record Type
1867: ,fnd_global.user_id
1868: ,SYSDATE
1869: ,fnd_global.user_id
1870: ,SYSDATE
1871: ,FND_GLOBAL.CONC_LOGIN_ID
1872: ,1
1873: FROM ap_supplier_sites_all PVS,

Line 1871: ,FND_GLOBAL.CONC_LOGIN_ID

1867: ,fnd_global.user_id
1868: ,SYSDATE
1869: ,fnd_global.user_id
1870: ,SYSDATE
1871: ,FND_GLOBAL.CONC_LOGIN_ID
1872: ,1
1873: FROM ap_supplier_sites_all PVS,
1874: ap_suppliers PV,
1875: zx_party_tax_profile PTP

Line 1961: ,fnd_global.user_id

1957: ,NULL -- Rep_Party_Tax_Name
1958: ,NULL -- Legal Registration_ID
1959: ,'Y' -- Default Registration Flag
1960: ,'MIGRATED' -- Record Type
1961: ,fnd_global.user_id
1962: ,SYSDATE
1963: ,fnd_global.user_id
1964: ,SYSDATE
1965: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1963: ,fnd_global.user_id

1959: ,'Y' -- Default Registration Flag
1960: ,'MIGRATED' -- Record Type
1961: ,fnd_global.user_id
1962: ,SYSDATE
1963: ,fnd_global.user_id
1964: ,SYSDATE
1965: ,FND_GLOBAL.CONC_LOGIN_ID
1966: ,1
1967: FROM ap_supplier_sites_all PVS,

Line 1965: ,FND_GLOBAL.CONC_LOGIN_ID

1961: ,fnd_global.user_id
1962: ,SYSDATE
1963: ,fnd_global.user_id
1964: ,SYSDATE
1965: ,FND_GLOBAL.CONC_LOGIN_ID
1966: ,1
1967: FROM ap_supplier_sites_all PVS,
1968: ap_suppliers PV,
1969: zx_party_tax_profile PTP

Line 2035: ,fnd_global.user_id

2031: ,NULL -- Rep_Party_Tax_Name
2032: ,NULL -- Legal Registration_ID
2033: ,'N' -- Default Registration Flag
2034: ,'MIGRATED' -- Record Type
2035: ,fnd_global.user_id
2036: ,SYSDATE
2037: ,fnd_global.user_id
2038: ,SYSDATE
2039: ,FND_GLOBAL.CONC_LOGIN_ID

Line 2037: ,fnd_global.user_id

2033: ,'N' -- Default Registration Flag
2034: ,'MIGRATED' -- Record Type
2035: ,fnd_global.user_id
2036: ,SYSDATE
2037: ,fnd_global.user_id
2038: ,SYSDATE
2039: ,FND_GLOBAL.CONC_LOGIN_ID
2040: ,1
2041: FROM ap_supplier_sites_all PVS,

Line 2039: ,FND_GLOBAL.CONC_LOGIN_ID

2035: ,fnd_global.user_id
2036: ,SYSDATE
2037: ,fnd_global.user_id
2038: ,SYSDATE
2039: ,FND_GLOBAL.CONC_LOGIN_ID
2040: ,1
2041: FROM ap_supplier_sites_all PVS,
2042: ap_suppliers PV,
2043: zx_party_tax_profile PTP

Line 2109: ,fnd_global.user_id

2105: ,NULL -- Rep_Party_Tax_Name
2106: ,NULL -- Legal Registration_ID
2107: ,'N' -- Default Registration Flag
2108: ,'MIGRATED' -- Record Type
2109: ,fnd_global.user_id
2110: ,SYSDATE
2111: ,fnd_global.user_id
2112: ,SYSDATE
2113: ,FND_GLOBAL.CONC_LOGIN_ID

Line 2111: ,fnd_global.user_id

2107: ,'N' -- Default Registration Flag
2108: ,'MIGRATED' -- Record Type
2109: ,fnd_global.user_id
2110: ,SYSDATE
2111: ,fnd_global.user_id
2112: ,SYSDATE
2113: ,FND_GLOBAL.CONC_LOGIN_ID
2114: ,1
2115: FROM ap_supplier_sites_all PVS,

Line 2113: ,FND_GLOBAL.CONC_LOGIN_ID

2109: ,fnd_global.user_id
2110: ,SYSDATE
2111: ,fnd_global.user_id
2112: ,SYSDATE
2113: ,FND_GLOBAL.CONC_LOGIN_ID
2114: ,1
2115: FROM ap_supplier_sites_all PVS,
2116: ap_suppliers PV,
2117: zx_party_tax_profile PTP

Line 2219: fnd_global.user_id, -- Created_By

2215: 'MIGRATED', -- Record_Type_Code
2216: Null, -- Tax_Classification_Code
2217: 'N', -- Self_Assess_Flag
2218: 'N', -- Allow_Offset_Tax_Flag
2219: fnd_global.user_id, -- Created_By
2220: SYSDATE, -- Creation_Date
2221: fnd_global.user_id, -- Last_Updated_By
2222: SYSDATE, -- Last_Update_Date
2223: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login

Line 2221: fnd_global.user_id, -- Last_Updated_By

2217: 'N', -- Self_Assess_Flag
2218: 'N', -- Allow_Offset_Tax_Flag
2219: fnd_global.user_id, -- Created_By
2220: SYSDATE, -- Creation_Date
2221: fnd_global.user_id, -- Last_Updated_By
2222: SYSDATE, -- Last_Update_Date
2223: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2224: 1
2225: FROM DUAL

Line 2223: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login

2219: fnd_global.user_id, -- Created_By
2220: SYSDATE, -- Creation_Date
2221: fnd_global.user_id, -- Last_Updated_By
2222: SYSDATE, -- Last_Update_Date
2223: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2224: 1
2225: FROM DUAL
2226: WHERE not exists ( select 1 from zx_party_tax_profile
2227: WHERE party_id = l_org_id and Party_Type_Code = 'OU'));

Line 2282: fnd_global.user_id, -- Created_By

2278: 'MIGRATED', -- Record_Type_Code
2279: Null, -- Tax_Classification_Code
2280: 'N', -- Self_Assess_Flag
2281: 'N', -- Allow_Offset_Tax_Flag
2282: fnd_global.user_id, -- Created_By
2283: SYSDATE, -- Creation_Date
2284: fnd_global.user_id, -- Last_Updated_By
2285: SYSDATE, -- Last_Update_Date
2286: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login

Line 2284: fnd_global.user_id, -- Last_Updated_By

2280: 'N', -- Self_Assess_Flag
2281: 'N', -- Allow_Offset_Tax_Flag
2282: fnd_global.user_id, -- Created_By
2283: SYSDATE, -- Creation_Date
2284: fnd_global.user_id, -- Last_Updated_By
2285: SYSDATE, -- Last_Update_Date
2286: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2287: 1
2288: FROM HR_OPERATING_UNITS

Line 2286: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login

2282: fnd_global.user_id, -- Created_By
2283: SYSDATE, -- Creation_Date
2284: fnd_global.user_id, -- Last_Updated_By
2285: SYSDATE, -- Last_Update_Date
2286: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2287: 1
2288: FROM HR_OPERATING_UNITS
2289: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =
2290: nvl(p_party_ID,HR_OPERATING_UNITS.ORGANIZATION_ID) and

Line 2386: fnd_global.user_id,

2382: 1,
2383: SYSDATE,
2384: NULL,
2385: 'MIGRATED',
2386: fnd_global.user_id,
2387: SYSDATE,
2388: fnd_global.user_id,
2389: SYSDATE,
2390: fnd_global.conc_login_id,

Line 2388: fnd_global.user_id,

2384: NULL,
2385: 'MIGRATED',
2386: fnd_global.user_id,
2387: SYSDATE,
2388: fnd_global.user_id,
2389: SYSDATE,
2390: fnd_global.conc_login_id,
2391: 1)
2392: SELECT '1' from dual

Line 2390: fnd_global.conc_login_id,

2386: fnd_global.user_id,
2387: SYSDATE,
2388: fnd_global.user_id,
2389: SYSDATE,
2390: fnd_global.conc_login_id,
2391: 1)
2392: SELECT '1' from dual
2393: WHERE NOT EXISTS
2394: (SELECT NULL

Line 2417: fnd_global.user_id ,

2413: VALUES (CLASSIFICATION_TYPE_ID,
2414: 'Supplier Type',
2415: LANGUAGE_CODE,
2416: userenv('LANG') ,
2417: fnd_global.user_id ,
2418: SYSDATE ,
2419: fnd_global.user_id ,
2420: SYSDATE ,
2421: fnd_global.conc_login_id)

Line 2419: fnd_global.user_id ,

2415: LANGUAGE_CODE,
2416: userenv('LANG') ,
2417: fnd_global.user_id ,
2418: SYSDATE ,
2419: fnd_global.user_id ,
2420: SYSDATE ,
2421: fnd_global.conc_login_id)
2422: SELECT
2423: fc_types.CLASSIFICATION_TYPE_ID ,

Line 2421: fnd_global.conc_login_id)

2417: fnd_global.user_id ,
2418: SYSDATE ,
2419: fnd_global.user_id ,
2420: SYSDATE ,
2421: fnd_global.conc_login_id)
2422: SELECT
2423: fc_types.CLASSIFICATION_TYPE_ID ,
2424: L.LANGUAGE_CODE
2425: FROM

Line 2469: fnd_global.user_id,

2465: null,
2466: null,
2467: null,
2468: 'MIGRATED',
2469: fnd_global.user_id,
2470: SYSDATE,
2471: fnd_global.user_id,
2472: SYSDATE,
2473: FND_GLOBAL.CONC_LOGIN_ID,

Line 2471: fnd_global.user_id,

2467: null,
2468: 'MIGRATED',
2469: fnd_global.user_id,
2470: SYSDATE,
2471: fnd_global.user_id,
2472: SYSDATE,
2473: FND_GLOBAL.CONC_LOGIN_ID,
2474: 1)
2475: SELECT '1' FROM DUAL

Line 2473: FND_GLOBAL.CONC_LOGIN_ID,

2469: fnd_global.user_id,
2470: SYSDATE,
2471: fnd_global.user_id,
2472: SYSDATE,
2473: FND_GLOBAL.CONC_LOGIN_ID,
2474: 1)
2475: SELECT '1' FROM DUAL
2476: WHERE NOT EXISTS
2477: (SELECT NULL

Line 2497: fnd_global.user_id,

2493: LANGUAGE,
2494: SOURCE_LANG)
2495: VALUES (CLASSIFICATION_ID,
2496: 'Supplier Type',
2497: fnd_global.user_id,
2498: SYSDATE,
2499: fnd_global.user_id,
2500: SYSDATE,
2501: FND_GLOBAL.CONC_LOGIN_ID,

Line 2499: fnd_global.user_id,

2495: VALUES (CLASSIFICATION_ID,
2496: 'Supplier Type',
2497: fnd_global.user_id,
2498: SYSDATE,
2499: fnd_global.user_id,
2500: SYSDATE,
2501: FND_GLOBAL.CONC_LOGIN_ID,
2502: LANGUAGE_CODE,
2503: userenv('LANG'))

Line 2501: FND_GLOBAL.CONC_LOGIN_ID,

2497: fnd_global.user_id,
2498: SYSDATE,
2499: fnd_global.user_id,
2500: SYSDATE,
2501: FND_GLOBAL.CONC_LOGIN_ID,
2502: LANGUAGE_CODE,
2503: userenv('LANG'))
2504: INTO ZX_FC_CODES_DENORM_B(
2505: CLASSIFICATION_TYPE_ID,

Line 2591: fnd_global.user_id,

2587: Null,
2588: Null,
2589: Null,
2590: Null,
2591: fnd_global.user_id,
2592: SYSDATE,
2593: fnd_global.user_id,
2594: FND_GLOBAL.CONC_LOGIN_ID,
2595: sysdate,

Line 2593: fnd_global.user_id,

2589: Null,
2590: Null,
2591: fnd_global.user_id,
2592: SYSDATE,
2593: fnd_global.user_id,
2594: FND_GLOBAL.CONC_LOGIN_ID,
2595: sysdate,
2596: FND_GLOBAL.CONC_REQUEST_ID,
2597: fnd_global.CONC_PROGRAM_ID,

Line 2594: FND_GLOBAL.CONC_LOGIN_ID,

2590: Null,
2591: fnd_global.user_id,
2592: SYSDATE,
2593: fnd_global.user_id,
2594: FND_GLOBAL.CONC_LOGIN_ID,
2595: sysdate,
2596: FND_GLOBAL.CONC_REQUEST_ID,
2597: fnd_global.CONC_PROGRAM_ID,
2598: 235,

Line 2596: FND_GLOBAL.CONC_REQUEST_ID,

2592: SYSDATE,
2593: fnd_global.user_id,
2594: FND_GLOBAL.CONC_LOGIN_ID,
2595: sysdate,
2596: FND_GLOBAL.CONC_REQUEST_ID,
2597: fnd_global.CONC_PROGRAM_ID,
2598: 235,
2599: FND_GLOBAL.CONC_LOGIN_ID,
2600: 'MIGRATED')

Line 2597: fnd_global.CONC_PROGRAM_ID,

2593: fnd_global.user_id,
2594: FND_GLOBAL.CONC_LOGIN_ID,
2595: sysdate,
2596: FND_GLOBAL.CONC_REQUEST_ID,
2597: fnd_global.CONC_PROGRAM_ID,
2598: 235,
2599: FND_GLOBAL.CONC_LOGIN_ID,
2600: 'MIGRATED')
2601: SELECT

Line 2599: FND_GLOBAL.CONC_LOGIN_ID,

2595: sysdate,
2596: FND_GLOBAL.CONC_REQUEST_ID,
2597: fnd_global.CONC_PROGRAM_ID,
2598: 235,
2599: FND_GLOBAL.CONC_LOGIN_ID,
2600: 'MIGRATED')
2601: SELECT
2602: TYPE.CLASSIFICATION_TYPE_ID,
2603: TYPE.CLASSIFICATION_TYPE_CODE,

Line 2713: fnd_global.user_id,

2709: 'USER_ENTERED',
2710: Null,
2711: Sysdate,
2712: Null,
2713: fnd_global.user_id,
2714: Sysdate,
2715: FND_GLOBAL.CONC_LOGIN_ID,
2716: Sysdate,
2717: fnd_global.user_id,

Line 2715: FND_GLOBAL.CONC_LOGIN_ID,

2711: Sysdate,
2712: Null,
2713: fnd_global.user_id,
2714: Sysdate,
2715: FND_GLOBAL.CONC_LOGIN_ID,
2716: Sysdate,
2717: fnd_global.user_id,
2718: Null,
2719: 1,

Line 2717: fnd_global.user_id,

2713: fnd_global.user_id,
2714: Sysdate,
2715: FND_GLOBAL.CONC_LOGIN_ID,
2716: Sysdate,
2717: fnd_global.user_id,
2718: Null,
2719: 1,
2720: 'EBTAX MIGRATION',
2721: 235,

Line 2728: fnd_global.PROG_APPL_ID,

2724: Null,
2725: Null,
2726: Null,
2727: NULL,
2728: fnd_global.PROG_APPL_ID,
2729: fnd_global.CONC_PROGRAM_ID
2730: FROM ap_suppliers POV ,
2731: ZX_PARTY_TAX_PROFILE PTP
2732: WHERE POV.PARTY_ID = PTP.PARTY_ID

Line 2729: fnd_global.CONC_PROGRAM_ID

2725: Null,
2726: Null,
2727: NULL,
2728: fnd_global.PROG_APPL_ID,
2729: fnd_global.CONC_PROGRAM_ID
2730: FROM ap_suppliers POV ,
2731: ZX_PARTY_TAX_PROFILE PTP
2732: WHERE POV.PARTY_ID = PTP.PARTY_ID
2733: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'

Line 2834: fnd_global.user_id,

2830: 'USER_ENTERED',
2831: Null,
2832: Sysdate,
2833: Null,
2834: fnd_global.user_id,
2835: Sysdate,
2836: FND_GLOBAL.CONC_LOGIN_ID,
2837: Sysdate,
2838: fnd_global.user_id,

Line 2836: FND_GLOBAL.CONC_LOGIN_ID,

2832: Sysdate,
2833: Null,
2834: fnd_global.user_id,
2835: Sysdate,
2836: FND_GLOBAL.CONC_LOGIN_ID,
2837: Sysdate,
2838: fnd_global.user_id,
2839: Null,
2840: Null,

Line 2838: fnd_global.user_id,

2834: fnd_global.user_id,
2835: Sysdate,
2836: FND_GLOBAL.CONC_LOGIN_ID,
2837: Sysdate,
2838: fnd_global.user_id,
2839: Null,
2840: Null,
2841: Null,
2842: 235,

Line 2897: CREATED_BY = fnd_global.user_id,

2893: ACTUAL_CONTENT_SOURCE = 'USER_ENTERED',
2894: IMPORTANCE_RANKING = Null,
2895: START_DATE_ACTIVE = SYSDATE,
2896: END_DATE_ACTIVE = Null,
2897: CREATED_BY = fnd_global.user_id,
2898: CREATION_DATE = SYSDATE,
2899: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
2900: LAST_UPDATE_DATE = SYSDATE,
2901: LAST_UPDATED_BY = fnd_global.user_id,

Line 2899: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

2895: START_DATE_ACTIVE = SYSDATE,
2896: END_DATE_ACTIVE = Null,
2897: CREATED_BY = fnd_global.user_id,
2898: CREATION_DATE = SYSDATE,
2899: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
2900: LAST_UPDATE_DATE = SYSDATE,
2901: LAST_UPDATED_BY = fnd_global.user_id,
2902: APPLICATION_ID = 235
2903: WHEN NOT MATCHED THEN INSERT

Line 2901: LAST_UPDATED_BY = fnd_global.user_id,

2897: CREATED_BY = fnd_global.user_id,
2898: CREATION_DATE = SYSDATE,
2899: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
2900: LAST_UPDATE_DATE = SYSDATE,
2901: LAST_UPDATED_BY = fnd_global.user_id,
2902: APPLICATION_ID = 235
2903: WHEN NOT MATCHED THEN INSERT
2904: (
2905: CODE_ASSIGNMENT_ID,

Line 2945: fnd_global.user_id,

2941: 'USER_ENTERED',
2942: Null,
2943: Sysdate,
2944: Null,
2945: fnd_global.user_id,
2946: Sysdate,
2947: FND_GLOBAL.CONC_LOGIN_ID,
2948: Sysdate,
2949: fnd_global.user_id,

Line 2947: FND_GLOBAL.CONC_LOGIN_ID,

2943: Sysdate,
2944: Null,
2945: fnd_global.user_id,
2946: Sysdate,
2947: FND_GLOBAL.CONC_LOGIN_ID,
2948: Sysdate,
2949: fnd_global.user_id,
2950: Null,
2951: Null,

Line 2949: fnd_global.user_id,

2945: fnd_global.user_id,
2946: Sysdate,
2947: FND_GLOBAL.CONC_LOGIN_ID,
2948: Sysdate,
2949: fnd_global.user_id,
2950: Null,
2951: Null,
2952: Null,
2953: 235,

Line 2988: CREATED_BY = fnd_global.user_id,

2984: ACTUAL_CONTENT_SOURCE = 'USER_ENTERED',
2985: IMPORTANCE_RANKING = Null,
2986: START_DATE_ACTIVE = SYSDATE,
2987: END_DATE_ACTIVE = Null,
2988: CREATED_BY = fnd_global.user_id,
2989: CREATION_DATE = SYSDATE,
2990: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
2991: LAST_UPDATE_DATE = SYSDATE,
2992: LAST_UPDATED_BY = fnd_global.user_id,

Line 2990: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

2986: START_DATE_ACTIVE = SYSDATE,
2987: END_DATE_ACTIVE = Null,
2988: CREATED_BY = fnd_global.user_id,
2989: CREATION_DATE = SYSDATE,
2990: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
2991: LAST_UPDATE_DATE = SYSDATE,
2992: LAST_UPDATED_BY = fnd_global.user_id,
2993: APPLICATION_ID = 235
2994: WHERE

Line 2992: LAST_UPDATED_BY = fnd_global.user_id,

2988: CREATED_BY = fnd_global.user_id,
2989: CREATION_DATE = SYSDATE,
2990: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
2991: LAST_UPDATE_DATE = SYSDATE,
2992: LAST_UPDATED_BY = fnd_global.user_id,
2993: APPLICATION_ID = 235
2994: WHERE
2995: OWNER_TABLE_ID = p_party_tax_profile_id and
2996: CLASS_CATEGORY = p_fiscal_class_type_code and

Line 3103: fnd_global.user_id,

3099: DESCRIPTION,
3100: ENABLED_FLAG,
3101: START_DATE_ACTIVE,
3102: END_DATE_ACTIVE,
3103: fnd_global.user_id,
3104: SYSDATE,
3105: fnd_global.user_id,
3106: fnd_global.conc_login_id,
3107: SYSDATE,

Line 3105: fnd_global.user_id,

3101: START_DATE_ACTIVE,
3102: END_DATE_ACTIVE,
3103: fnd_global.user_id,
3104: SYSDATE,
3105: fnd_global.user_id,
3106: fnd_global.conc_login_id,
3107: SYSDATE,
3108: SOURCE_LANG,
3109: SECURITY_GROUP_ID,

Line 3106: fnd_global.conc_login_id,

3102: END_DATE_ACTIVE,
3103: fnd_global.user_id,
3104: SYSDATE,
3105: fnd_global.user_id,
3106: fnd_global.conc_login_id,
3107: SYSDATE,
3108: SOURCE_LANG,
3109: SECURITY_GROUP_ID,
3110: VIEW_APPLICATION_ID,