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 680: ,Fnd_Global.User_Id

676: , 'MIGRATED' -- RECORD_TYPE_CODE
677: , nvl(HRloc.Tax_Name, Fso.Vat_Code) -- TAX_CLASSIFICATION_CODE
678: ,'N' -- Self_Assess_Flag
679: ,'N' -- Allow_Offset_Tax_Flag
680: ,Fnd_Global.User_Id
681: ,Sysdate
682: ,Fnd_Global.User_Id
683: ,Sysdate
684: ,Fnd_Global.Conc_Login_Id

Line 682: ,Fnd_Global.User_Id

678: ,'N' -- Self_Assess_Flag
679: ,'N' -- Allow_Offset_Tax_Flag
680: ,Fnd_Global.User_Id
681: ,Sysdate
682: ,Fnd_Global.User_Id
683: ,Sysdate
684: ,Fnd_Global.Conc_Login_Id
685: ,1
686: FROM

Line 684: ,Fnd_Global.Conc_Login_Id

680: ,Fnd_Global.User_Id
681: ,Sysdate
682: ,Fnd_Global.User_Id
683: ,Sysdate
684: ,Fnd_Global.Conc_Login_Id
685: ,1
686: FROM
687: xle_entity_profiles XEP,
688: Hr_Locations_All HrLoc

Line 806: ,Fnd_Global.User_Id -- Who Column

802: ,'MIGRATED' -- RECORD_TYPE_CODE
803: ,nvl(HRloc.Tax_Name, Fso.Vat_Code) --TAX_CLASSIFICATION_CODE
804: ,'N' -- Self_Assess_Flag
805: ,'N' -- Allow_Offset_Tax_Flag
806: ,Fnd_Global.User_Id -- Who Column
807: ,Sysdate -- Who Column
808: ,Fnd_Global.User_Id -- Who Column
809: ,Sysdate -- Who Column
810: ,Fnd_Global.Conc_Login_Id -- Who Column

Line 808: ,Fnd_Global.User_Id -- Who Column

804: ,'N' -- Self_Assess_Flag
805: ,'N' -- Allow_Offset_Tax_Flag
806: ,Fnd_Global.User_Id -- Who Column
807: ,Sysdate -- Who Column
808: ,Fnd_Global.User_Id -- Who Column
809: ,Sysdate -- Who Column
810: ,Fnd_Global.Conc_Login_Id -- Who Column
811: ,1
812: FROM Hr_Locations_All HrLoc

Line 810: ,Fnd_Global.Conc_Login_Id -- Who Column

806: ,Fnd_Global.User_Id -- Who Column
807: ,Sysdate -- Who Column
808: ,Fnd_Global.User_Id -- Who Column
809: ,Sysdate -- Who Column
810: ,Fnd_Global.Conc_Login_Id -- Who Column
811: ,1
812: FROM Hr_Locations_All HrLoc
813: ,xle_etb_profiles XEP
814: ,xle_associations xa

Line 913: ,Fnd_Global.User_Id -- Who Column

909: ,'MIGRATED' -- RECORD_TYPE_CODE
910: ,nvl(HRloc.Tax_Name, Fso.Vat_Code) --TAX_CLASSIFICATION_CODE
911: ,'N' -- Self_Assess_Flag
912: ,'N' -- Allow_Offset_Tax_Flag
913: ,Fnd_Global.User_Id -- Who Column
914: ,Sysdate -- Who Column
915: ,Fnd_Global.User_Id -- Who Column
916: ,Sysdate -- Who Column
917: ,Fnd_Global.Conc_Login_Id -- Who Column

Line 915: ,Fnd_Global.User_Id -- Who Column

911: ,'N' -- Self_Assess_Flag
912: ,'N' -- Allow_Offset_Tax_Flag
913: ,Fnd_Global.User_Id -- Who Column
914: ,Sysdate -- Who Column
915: ,Fnd_Global.User_Id -- Who Column
916: ,Sysdate -- Who Column
917: ,Fnd_Global.Conc_Login_Id -- Who Column
918: ,1
919: FROM

Line 917: ,Fnd_Global.Conc_Login_Id -- Who Column

913: ,Fnd_Global.User_Id -- Who Column
914: ,Sysdate -- Who Column
915: ,Fnd_Global.User_Id -- Who Column
916: ,Sysdate -- Who Column
917: ,Fnd_Global.Conc_Login_Id -- Who Column
918: ,1
919: FROM
920: Hr_Locations_All HrLoc
921: ,xle_etb_profiles XEP

Line 1008: ,fnd_global.user_id

1004: ,hrloc.global_Attribute5
1005: ,hrloc.global_Attribute6
1006: ,hrloc.global_Attribute7
1007: ,'MIGRATED' -- Record Type
1008: ,fnd_global.user_id
1009: ,SYSDATE
1010: ,fnd_global.user_id
1011: ,SYSDATE
1012: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1010: ,fnd_global.user_id

1006: ,hrloc.global_Attribute7
1007: ,'MIGRATED' -- Record Type
1008: ,fnd_global.user_id
1009: ,SYSDATE
1010: ,fnd_global.user_id
1011: ,SYSDATE
1012: ,FND_GLOBAL.CONC_LOGIN_ID
1013: ,1
1014: FROM

Line 1012: ,FND_GLOBAL.CONC_LOGIN_ID

1008: ,fnd_global.user_id
1009: ,SYSDATE
1010: ,fnd_global.user_id
1011: ,SYSDATE
1012: ,FND_GLOBAL.CONC_LOGIN_ID
1013: ,1
1014: FROM
1015: zx_party_tax_profile PTP,
1016: Hr_Locations_All HrLoc,

Line 1107: ,fnd_global.user_id

1103: ,NULL -- Rep_Party_Tax_Name
1104: ,NULL -- Legal Registration_ID
1105: ,'Y' -- Default Registration Flag
1106: ,'MIGRATED' -- Record Type
1107: ,fnd_global.user_id
1108: ,SYSDATE
1109: ,fnd_global.user_id
1110: ,SYSDATE
1111: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1109: ,fnd_global.user_id

1105: ,'Y' -- Default Registration Flag
1106: ,'MIGRATED' -- Record Type
1107: ,fnd_global.user_id
1108: ,SYSDATE
1109: ,fnd_global.user_id
1110: ,SYSDATE
1111: ,FND_GLOBAL.CONC_LOGIN_ID
1112: ,1
1113: FROM

Line 1111: ,FND_GLOBAL.CONC_LOGIN_ID

1107: ,fnd_global.user_id
1108: ,SYSDATE
1109: ,fnd_global.user_id
1110: ,SYSDATE
1111: ,FND_GLOBAL.CONC_LOGIN_ID
1112: ,1
1113: FROM
1114: jl_br_company_infos jl
1115: ,gl_ledger_le_v gl

Line 1198: ,fnd_global.user_id

1194: ,NULL -- Rep_Party_Tax_Name
1195: ,NULL -- Legal Registration_ID
1196: ,'Y' -- Default Registration Flag
1197: ,'MIGRATED' -- Record Type
1198: ,fnd_global.user_id
1199: ,SYSDATE
1200: ,fnd_global.user_id
1201: ,SYSDATE
1202: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1200: ,fnd_global.user_id

1196: ,'Y' -- Default Registration Flag
1197: ,'MIGRATED' -- Record Type
1198: ,fnd_global.user_id
1199: ,SYSDATE
1200: ,fnd_global.user_id
1201: ,SYSDATE
1202: ,FND_GLOBAL.CONC_LOGIN_ID
1203: ,1
1204: FROM

Line 1202: ,FND_GLOBAL.CONC_LOGIN_ID

1198: ,fnd_global.user_id
1199: ,SYSDATE
1200: ,fnd_global.user_id
1201: ,SYSDATE
1202: ,FND_GLOBAL.CONC_LOGIN_ID
1203: ,1
1204: FROM
1205: jl_br_company_infos jl
1206: ,gl_ledger_le_v gl

Line 1273: ,fnd_global.user_id

1269: ,NULL -- Rep_Party_Tax_Name
1270: ,NULL -- Legal Registration_ID
1271: ,'Y' -- Default Registration Flag
1272: ,'MIGRATED' -- Record Type
1273: ,fnd_global.user_id
1274: ,SYSDATE
1275: ,fnd_global.user_id
1276: ,SYSDATE
1277: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1275: ,fnd_global.user_id

1271: ,'Y' -- Default Registration Flag
1272: ,'MIGRATED' -- Record Type
1273: ,fnd_global.user_id
1274: ,SYSDATE
1275: ,fnd_global.user_id
1276: ,SYSDATE
1277: ,FND_GLOBAL.CONC_LOGIN_ID
1278: ,1
1279: FROM

Line 1277: ,FND_GLOBAL.CONC_LOGIN_ID

1273: ,fnd_global.user_id
1274: ,SYSDATE
1275: ,fnd_global.user_id
1276: ,SYSDATE
1277: ,FND_GLOBAL.CONC_LOGIN_ID
1278: ,1
1279: FROM
1280: jl_br_company_infos jl
1281: ,gl_ledger_le_v gl

Line 1419: ,fnd_global.user_id -- Who Columns

1415: ,'MIGRATED' -- Record Type
1416: ,vat_code -- Tax Classification
1417: ,'N' -- Self_Assess_Flag
1418: ,nvl(offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
1419: ,fnd_global.user_id -- Who Columns
1420: ,SYSDATE -- Who Columns
1421: ,fnd_global.user_id -- Who Columns
1422: ,SYSDATE -- Who Columns
1423: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

Line 1421: ,fnd_global.user_id -- Who Columns

1417: ,'N' -- Self_Assess_Flag
1418: ,nvl(offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
1419: ,fnd_global.user_id -- Who Columns
1420: ,SYSDATE -- Who Columns
1421: ,fnd_global.user_id -- Who Columns
1422: ,SYSDATE -- Who Columns
1423: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1424: , 1
1425: FROM ap_suppliers PV

Line 1423: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

1419: ,fnd_global.user_id -- Who Columns
1420: ,SYSDATE -- Who Columns
1421: ,fnd_global.user_id -- Who Columns
1422: ,SYSDATE -- Who Columns
1423: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1424: , 1
1425: FROM ap_suppliers PV
1426: WHERE VENDOR_ID = nvl(p_party_ID,VENDOR_ID)
1427: AND not exists (select 1 from zx_party_tax_profile

Line 1492: ,fnd_global.user_id

1488: ,NULL -- Rep_Party_Tax_Name
1489: ,NULL -- Legal Registration_ID
1490: ,'Y' -- Default Registration Flag
1491: ,'MIGRATED' -- Record Type
1492: ,fnd_global.user_id
1493: ,SYSDATE
1494: ,fnd_global.user_id
1495: ,SYSDATE
1496: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1494: ,fnd_global.user_id

1490: ,'Y' -- Default Registration Flag
1491: ,'MIGRATED' -- Record Type
1492: ,fnd_global.user_id
1493: ,SYSDATE
1494: ,fnd_global.user_id
1495: ,SYSDATE
1496: ,FND_GLOBAL.CONC_LOGIN_ID
1497: ,1
1498: FROM ap_suppliers PV,

Line 1496: ,FND_GLOBAL.CONC_LOGIN_ID

1492: ,fnd_global.user_id
1493: ,SYSDATE
1494: ,fnd_global.user_id
1495: ,SYSDATE
1496: ,FND_GLOBAL.CONC_LOGIN_ID
1497: ,1
1498: FROM ap_suppliers PV,
1499: zx_party_tax_profile PTP
1500: WHERE

Line 1564: fnd_global.user_id,

1560: DESCRIPTION,
1561: ENABLED_FLAG,
1562: START_DATE_ACTIVE,
1563: END_DATE_ACTIVE,
1564: fnd_global.user_id,
1565: SYSDATE,
1566: fnd_global.user_id,
1567: fnd_global.conc_login_id,
1568: SYSDATE,

Line 1566: fnd_global.user_id,

1562: START_DATE_ACTIVE,
1563: END_DATE_ACTIVE,
1564: fnd_global.user_id,
1565: SYSDATE,
1566: fnd_global.user_id,
1567: fnd_global.conc_login_id,
1568: SYSDATE,
1569: SOURCE_LANG,
1570: SECURITY_GROUP_ID,

Line 1567: fnd_global.conc_login_id,

1563: END_DATE_ACTIVE,
1564: fnd_global.user_id,
1565: SYSDATE,
1566: fnd_global.user_id,
1567: fnd_global.conc_login_id,
1568: SYSDATE,
1569: SOURCE_LANG,
1570: SECURITY_GROUP_ID,
1571: VIEW_APPLICATION_ID,

Line 1723: ,fnd_global.user_id -- Who Columns

1719: ,'MIGRATED' -- Record Type
1720: ,VAT_CODE
1721: ,'N'
1722: ,ALLOW_OFFSET_TAX_FLAG
1723: ,fnd_global.user_id -- Who Columns
1724: ,SYSDATE -- Who Columns
1725: ,fnd_global.user_id -- Who Columns
1726: ,SYSDATE -- Who Columns
1727: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

Line 1725: ,fnd_global.user_id -- Who Columns

1721: ,'N'
1722: ,ALLOW_OFFSET_TAX_FLAG
1723: ,fnd_global.user_id -- Who Columns
1724: ,SYSDATE -- Who Columns
1725: ,fnd_global.user_id -- Who Columns
1726: ,SYSDATE -- Who Columns
1727: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1728: ,1)
1729: (SELECT

Line 1727: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

1723: ,fnd_global.user_id -- Who Columns
1724: ,SYSDATE -- Who Columns
1725: ,fnd_global.user_id -- Who Columns
1726: ,SYSDATE -- Who Columns
1727: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1728: ,1)
1729: (SELECT
1730: PVS.PARTY_SITE_ID PARTY_SITE_ID-- Party ID
1731: ,PVS.Vat_Registration_Num VAT_REGISTRATION_NUM

Line 1818: ,fnd_global.user_id

1814: ,NULL -- Rep_Party_Tax_Name
1815: ,NULL -- Legal Registration_ID
1816: ,'Y' -- Default Registration Flag
1817: ,'MIGRATED' -- Record Type
1818: ,fnd_global.user_id
1819: ,SYSDATE
1820: ,fnd_global.user_id
1821: ,SYSDATE
1822: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1820: ,fnd_global.user_id

1816: ,'Y' -- Default Registration Flag
1817: ,'MIGRATED' -- Record Type
1818: ,fnd_global.user_id
1819: ,SYSDATE
1820: ,fnd_global.user_id
1821: ,SYSDATE
1822: ,FND_GLOBAL.CONC_LOGIN_ID
1823: ,1
1824: )

Line 1822: ,FND_GLOBAL.CONC_LOGIN_ID

1818: ,fnd_global.user_id
1819: ,SYSDATE
1820: ,fnd_global.user_id
1821: ,SYSDATE
1822: ,FND_GLOBAL.CONC_LOGIN_ID
1823: ,1
1824: )
1825:
1826: (SELECT

Line 1920: , fnd_global.user_id -- Who Columns

1916: ,'MIGRATED' -- Record Type
1917: ,pvs.vat_code -- Tax Classification
1918: ,'N' -- Self_Assess_Flag
1919: , nvl(pv.offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
1920: , fnd_global.user_id -- Who Columns
1921: ,SYSDATE -- Who Columns
1922: ,fnd_global.user_id -- Who Columns
1923: ,SYSDATE -- Who Columns
1924: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

Line 1922: ,fnd_global.user_id -- Who Columns

1918: ,'N' -- Self_Assess_Flag
1919: , nvl(pv.offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
1920: , fnd_global.user_id -- Who Columns
1921: ,SYSDATE -- Who Columns
1922: ,fnd_global.user_id -- Who Columns
1923: ,SYSDATE -- Who Columns
1924: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1925: ,1
1926: FROM ap_supplier_sites_all Pvs,

Line 1924: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns

1920: , fnd_global.user_id -- Who Columns
1921: ,SYSDATE -- Who Columns
1922: ,fnd_global.user_id -- Who Columns
1923: ,SYSDATE -- Who Columns
1924: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1925: ,1
1926: FROM ap_supplier_sites_all Pvs,
1927: ap_suppliers Pv
1928: WHERE pvs.Vendor_Site_Id = nvl(P_Party_Id,pvs.Vendor_site_Id)

Line 1987: ,fnd_global.user_id

1983: ,NULL -- Rep_Party_Tax_Name
1984: ,NULL -- Legal Registration_ID
1985: ,'Y' -- Default Registration Flag
1986: ,'MIGRATED' -- Record Type
1987: ,fnd_global.user_id
1988: ,SYSDATE
1989: ,fnd_global.user_id
1990: ,SYSDATE
1991: ,FND_GLOBAL.CONC_LOGIN_ID

Line 1989: ,fnd_global.user_id

1985: ,'Y' -- Default Registration Flag
1986: ,'MIGRATED' -- Record Type
1987: ,fnd_global.user_id
1988: ,SYSDATE
1989: ,fnd_global.user_id
1990: ,SYSDATE
1991: ,FND_GLOBAL.CONC_LOGIN_ID
1992: ,1
1993: FROM ap_supplier_sites_all PVS,

Line 1991: ,FND_GLOBAL.CONC_LOGIN_ID

1987: ,fnd_global.user_id
1988: ,SYSDATE
1989: ,fnd_global.user_id
1990: ,SYSDATE
1991: ,FND_GLOBAL.CONC_LOGIN_ID
1992: ,1
1993: FROM ap_supplier_sites_all PVS,
1994: ap_suppliers PV,
1995: zx_party_tax_profile PTP

Line 2081: ,fnd_global.user_id

2077: ,NULL -- Rep_Party_Tax_Name
2078: ,NULL -- Legal Registration_ID
2079: ,'Y' -- Default Registration Flag
2080: ,'MIGRATED' -- Record Type
2081: ,fnd_global.user_id
2082: ,SYSDATE
2083: ,fnd_global.user_id
2084: ,SYSDATE
2085: ,FND_GLOBAL.CONC_LOGIN_ID

Line 2083: ,fnd_global.user_id

2079: ,'Y' -- Default Registration Flag
2080: ,'MIGRATED' -- Record Type
2081: ,fnd_global.user_id
2082: ,SYSDATE
2083: ,fnd_global.user_id
2084: ,SYSDATE
2085: ,FND_GLOBAL.CONC_LOGIN_ID
2086: ,1
2087: FROM ap_supplier_sites_all PVS,

Line 2085: ,FND_GLOBAL.CONC_LOGIN_ID

2081: ,fnd_global.user_id
2082: ,SYSDATE
2083: ,fnd_global.user_id
2084: ,SYSDATE
2085: ,FND_GLOBAL.CONC_LOGIN_ID
2086: ,1
2087: FROM ap_supplier_sites_all PVS,
2088: ap_suppliers PV,
2089: zx_party_tax_profile PTP

Line 2155: ,fnd_global.user_id

2151: ,NULL -- Rep_Party_Tax_Name
2152: ,NULL -- Legal Registration_ID
2153: ,'N' -- Default Registration Flag
2154: ,'MIGRATED' -- Record Type
2155: ,fnd_global.user_id
2156: ,SYSDATE
2157: ,fnd_global.user_id
2158: ,SYSDATE
2159: ,FND_GLOBAL.CONC_LOGIN_ID

Line 2157: ,fnd_global.user_id

2153: ,'N' -- Default Registration Flag
2154: ,'MIGRATED' -- Record Type
2155: ,fnd_global.user_id
2156: ,SYSDATE
2157: ,fnd_global.user_id
2158: ,SYSDATE
2159: ,FND_GLOBAL.CONC_LOGIN_ID
2160: ,1
2161: FROM ap_supplier_sites_all PVS,

Line 2159: ,FND_GLOBAL.CONC_LOGIN_ID

2155: ,fnd_global.user_id
2156: ,SYSDATE
2157: ,fnd_global.user_id
2158: ,SYSDATE
2159: ,FND_GLOBAL.CONC_LOGIN_ID
2160: ,1
2161: FROM ap_supplier_sites_all PVS,
2162: ap_suppliers PV,
2163: zx_party_tax_profile PTP

Line 2229: ,fnd_global.user_id

2225: ,NULL -- Rep_Party_Tax_Name
2226: ,NULL -- Legal Registration_ID
2227: ,'N' -- Default Registration Flag
2228: ,'MIGRATED' -- Record Type
2229: ,fnd_global.user_id
2230: ,SYSDATE
2231: ,fnd_global.user_id
2232: ,SYSDATE
2233: ,FND_GLOBAL.CONC_LOGIN_ID

Line 2231: ,fnd_global.user_id

2227: ,'N' -- Default Registration Flag
2228: ,'MIGRATED' -- Record Type
2229: ,fnd_global.user_id
2230: ,SYSDATE
2231: ,fnd_global.user_id
2232: ,SYSDATE
2233: ,FND_GLOBAL.CONC_LOGIN_ID
2234: ,1
2235: FROM ap_supplier_sites_all PVS,

Line 2233: ,FND_GLOBAL.CONC_LOGIN_ID

2229: ,fnd_global.user_id
2230: ,SYSDATE
2231: ,fnd_global.user_id
2232: ,SYSDATE
2233: ,FND_GLOBAL.CONC_LOGIN_ID
2234: ,1
2235: FROM ap_supplier_sites_all PVS,
2236: ap_suppliers PV,
2237: zx_party_tax_profile PTP

Line 2339: fnd_global.user_id, -- Created_By

2335: 'MIGRATED', -- Record_Type_Code
2336: Null, -- Tax_Classification_Code
2337: 'N', -- Self_Assess_Flag
2338: 'N', -- Allow_Offset_Tax_Flag
2339: fnd_global.user_id, -- Created_By
2340: SYSDATE, -- Creation_Date
2341: fnd_global.user_id, -- Last_Updated_By
2342: SYSDATE, -- Last_Update_Date
2343: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login

Line 2341: fnd_global.user_id, -- Last_Updated_By

2337: 'N', -- Self_Assess_Flag
2338: 'N', -- Allow_Offset_Tax_Flag
2339: fnd_global.user_id, -- Created_By
2340: SYSDATE, -- Creation_Date
2341: fnd_global.user_id, -- Last_Updated_By
2342: SYSDATE, -- Last_Update_Date
2343: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2344: 1
2345: FROM DUAL

Line 2343: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login

2339: fnd_global.user_id, -- Created_By
2340: SYSDATE, -- Creation_Date
2341: fnd_global.user_id, -- Last_Updated_By
2342: SYSDATE, -- Last_Update_Date
2343: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2344: 1
2345: FROM DUAL
2346: WHERE not exists ( select 1 from zx_party_tax_profile
2347: WHERE party_id = l_org_id and Party_Type_Code = 'OU'));

Line 2402: fnd_global.user_id, -- Created_By

2398: 'MIGRATED', -- Record_Type_Code
2399: Null, -- Tax_Classification_Code
2400: 'N', -- Self_Assess_Flag
2401: 'N', -- Allow_Offset_Tax_Flag
2402: fnd_global.user_id, -- Created_By
2403: SYSDATE, -- Creation_Date
2404: fnd_global.user_id, -- Last_Updated_By
2405: SYSDATE, -- Last_Update_Date
2406: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login

Line 2404: fnd_global.user_id, -- Last_Updated_By

2400: 'N', -- Self_Assess_Flag
2401: 'N', -- Allow_Offset_Tax_Flag
2402: fnd_global.user_id, -- Created_By
2403: SYSDATE, -- Creation_Date
2404: fnd_global.user_id, -- Last_Updated_By
2405: SYSDATE, -- Last_Update_Date
2406: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2407: 1
2408: FROM HR_OPERATING_UNITS

Line 2406: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login

2402: fnd_global.user_id, -- Created_By
2403: SYSDATE, -- Creation_Date
2404: fnd_global.user_id, -- Last_Updated_By
2405: SYSDATE, -- Last_Update_Date
2406: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2407: 1
2408: FROM HR_OPERATING_UNITS
2409: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =
2410: nvl(p_party_ID,HR_OPERATING_UNITS.ORGANIZATION_ID) and

Line 2506: fnd_global.user_id,

2502: 1,
2503: SYSDATE,
2504: NULL,
2505: 'MIGRATED',
2506: fnd_global.user_id,
2507: SYSDATE,
2508: fnd_global.user_id,
2509: SYSDATE,
2510: fnd_global.conc_login_id,

Line 2508: fnd_global.user_id,

2504: NULL,
2505: 'MIGRATED',
2506: fnd_global.user_id,
2507: SYSDATE,
2508: fnd_global.user_id,
2509: SYSDATE,
2510: fnd_global.conc_login_id,
2511: 1)
2512: SELECT '1' from dual

Line 2510: fnd_global.conc_login_id,

2506: fnd_global.user_id,
2507: SYSDATE,
2508: fnd_global.user_id,
2509: SYSDATE,
2510: fnd_global.conc_login_id,
2511: 1)
2512: SELECT '1' from dual
2513: WHERE NOT EXISTS
2514: (SELECT NULL

Line 2537: fnd_global.user_id ,

2533: VALUES (CLASSIFICATION_TYPE_ID,
2534: 'Supplier Type',
2535: LANGUAGE_CODE,
2536: userenv('LANG') ,
2537: fnd_global.user_id ,
2538: SYSDATE ,
2539: fnd_global.user_id ,
2540: SYSDATE ,
2541: fnd_global.conc_login_id)

Line 2539: fnd_global.user_id ,

2535: LANGUAGE_CODE,
2536: userenv('LANG') ,
2537: fnd_global.user_id ,
2538: SYSDATE ,
2539: fnd_global.user_id ,
2540: SYSDATE ,
2541: fnd_global.conc_login_id)
2542: SELECT
2543: fc_types.CLASSIFICATION_TYPE_ID ,

Line 2541: fnd_global.conc_login_id)

2537: fnd_global.user_id ,
2538: SYSDATE ,
2539: fnd_global.user_id ,
2540: SYSDATE ,
2541: fnd_global.conc_login_id)
2542: SELECT
2543: fc_types.CLASSIFICATION_TYPE_ID ,
2544: L.LANGUAGE_CODE
2545: FROM

Line 2589: fnd_global.user_id,

2585: null,
2586: null,
2587: null,
2588: 'MIGRATED',
2589: fnd_global.user_id,
2590: SYSDATE,
2591: fnd_global.user_id,
2592: SYSDATE,
2593: FND_GLOBAL.CONC_LOGIN_ID,

Line 2591: fnd_global.user_id,

2587: null,
2588: 'MIGRATED',
2589: fnd_global.user_id,
2590: SYSDATE,
2591: fnd_global.user_id,
2592: SYSDATE,
2593: FND_GLOBAL.CONC_LOGIN_ID,
2594: 1)
2595: SELECT '1' FROM DUAL

Line 2593: FND_GLOBAL.CONC_LOGIN_ID,

2589: fnd_global.user_id,
2590: SYSDATE,
2591: fnd_global.user_id,
2592: SYSDATE,
2593: FND_GLOBAL.CONC_LOGIN_ID,
2594: 1)
2595: SELECT '1' FROM DUAL
2596: WHERE NOT EXISTS
2597: (SELECT NULL

Line 2617: fnd_global.user_id,

2613: LANGUAGE,
2614: SOURCE_LANG)
2615: VALUES (CLASSIFICATION_ID,
2616: 'Supplier Type',
2617: fnd_global.user_id,
2618: SYSDATE,
2619: fnd_global.user_id,
2620: SYSDATE,
2621: FND_GLOBAL.CONC_LOGIN_ID,

Line 2619: fnd_global.user_id,

2615: VALUES (CLASSIFICATION_ID,
2616: 'Supplier Type',
2617: fnd_global.user_id,
2618: SYSDATE,
2619: fnd_global.user_id,
2620: SYSDATE,
2621: FND_GLOBAL.CONC_LOGIN_ID,
2622: LANGUAGE_CODE,
2623: userenv('LANG'))

Line 2621: FND_GLOBAL.CONC_LOGIN_ID,

2617: fnd_global.user_id,
2618: SYSDATE,
2619: fnd_global.user_id,
2620: SYSDATE,
2621: FND_GLOBAL.CONC_LOGIN_ID,
2622: LANGUAGE_CODE,
2623: userenv('LANG'))
2624: INTO ZX_FC_CODES_DENORM_B(
2625: CLASSIFICATION_TYPE_ID,

Line 2711: fnd_global.user_id,

2707: Null,
2708: Null,
2709: Null,
2710: Null,
2711: fnd_global.user_id,
2712: SYSDATE,
2713: fnd_global.user_id,
2714: FND_GLOBAL.CONC_LOGIN_ID,
2715: sysdate,

Line 2713: fnd_global.user_id,

2709: Null,
2710: Null,
2711: fnd_global.user_id,
2712: SYSDATE,
2713: fnd_global.user_id,
2714: FND_GLOBAL.CONC_LOGIN_ID,
2715: sysdate,
2716: FND_GLOBAL.CONC_REQUEST_ID,
2717: fnd_global.CONC_PROGRAM_ID,

Line 2714: FND_GLOBAL.CONC_LOGIN_ID,

2710: Null,
2711: fnd_global.user_id,
2712: SYSDATE,
2713: fnd_global.user_id,
2714: FND_GLOBAL.CONC_LOGIN_ID,
2715: sysdate,
2716: FND_GLOBAL.CONC_REQUEST_ID,
2717: fnd_global.CONC_PROGRAM_ID,
2718: 235,

Line 2716: FND_GLOBAL.CONC_REQUEST_ID,

2712: SYSDATE,
2713: fnd_global.user_id,
2714: FND_GLOBAL.CONC_LOGIN_ID,
2715: sysdate,
2716: FND_GLOBAL.CONC_REQUEST_ID,
2717: fnd_global.CONC_PROGRAM_ID,
2718: 235,
2719: FND_GLOBAL.CONC_LOGIN_ID,
2720: 'MIGRATED')

Line 2717: fnd_global.CONC_PROGRAM_ID,

2713: fnd_global.user_id,
2714: FND_GLOBAL.CONC_LOGIN_ID,
2715: sysdate,
2716: FND_GLOBAL.CONC_REQUEST_ID,
2717: fnd_global.CONC_PROGRAM_ID,
2718: 235,
2719: FND_GLOBAL.CONC_LOGIN_ID,
2720: 'MIGRATED')
2721: SELECT

Line 2719: FND_GLOBAL.CONC_LOGIN_ID,

2715: sysdate,
2716: FND_GLOBAL.CONC_REQUEST_ID,
2717: fnd_global.CONC_PROGRAM_ID,
2718: 235,
2719: FND_GLOBAL.CONC_LOGIN_ID,
2720: 'MIGRATED')
2721: SELECT
2722: TYPE.CLASSIFICATION_TYPE_ID,
2723: TYPE.CLASSIFICATION_TYPE_CODE,

Line 2833: fnd_global.user_id,

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

Line 2835: FND_GLOBAL.CONC_LOGIN_ID,

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

Line 2837: fnd_global.user_id,

2833: fnd_global.user_id,
2834: Sysdate,
2835: FND_GLOBAL.CONC_LOGIN_ID,
2836: Sysdate,
2837: fnd_global.user_id,
2838: Null,
2839: 1,
2840: 'EBTAX MIGRATION',
2841: 235,

Line 2848: fnd_global.PROG_APPL_ID,

2844: Null,
2845: Null,
2846: Null,
2847: NULL,
2848: fnd_global.PROG_APPL_ID,
2849: fnd_global.CONC_PROGRAM_ID
2850: FROM ap_suppliers POV ,
2851: ZX_PARTY_TAX_PROFILE PTP
2852: WHERE POV.PARTY_ID = PTP.PARTY_ID

Line 2849: fnd_global.CONC_PROGRAM_ID

2845: Null,
2846: Null,
2847: NULL,
2848: fnd_global.PROG_APPL_ID,
2849: fnd_global.CONC_PROGRAM_ID
2850: FROM ap_suppliers POV ,
2851: ZX_PARTY_TAX_PROFILE PTP
2852: WHERE POV.PARTY_ID = PTP.PARTY_ID
2853: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'

Line 2954: fnd_global.user_id,

2950: 'USER_ENTERED',
2951: Null,
2952: Sysdate,
2953: Null,
2954: fnd_global.user_id,
2955: Sysdate,
2956: FND_GLOBAL.CONC_LOGIN_ID,
2957: Sysdate,
2958: fnd_global.user_id,

Line 2956: FND_GLOBAL.CONC_LOGIN_ID,

2952: Sysdate,
2953: Null,
2954: fnd_global.user_id,
2955: Sysdate,
2956: FND_GLOBAL.CONC_LOGIN_ID,
2957: Sysdate,
2958: fnd_global.user_id,
2959: Null,
2960: Null,

Line 2958: fnd_global.user_id,

2954: fnd_global.user_id,
2955: Sysdate,
2956: FND_GLOBAL.CONC_LOGIN_ID,
2957: Sysdate,
2958: fnd_global.user_id,
2959: Null,
2960: Null,
2961: Null,
2962: 235,

Line 3017: CREATED_BY = fnd_global.user_id,

3013: ACTUAL_CONTENT_SOURCE = 'USER_ENTERED',
3014: IMPORTANCE_RANKING = Null,
3015: START_DATE_ACTIVE = SYSDATE,
3016: END_DATE_ACTIVE = Null,
3017: CREATED_BY = fnd_global.user_id,
3018: CREATION_DATE = SYSDATE,
3019: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3020: LAST_UPDATE_DATE = SYSDATE,
3021: LAST_UPDATED_BY = fnd_global.user_id,

Line 3019: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

3015: START_DATE_ACTIVE = SYSDATE,
3016: END_DATE_ACTIVE = Null,
3017: CREATED_BY = fnd_global.user_id,
3018: CREATION_DATE = SYSDATE,
3019: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3020: LAST_UPDATE_DATE = SYSDATE,
3021: LAST_UPDATED_BY = fnd_global.user_id,
3022: APPLICATION_ID = 235
3023: WHEN NOT MATCHED THEN INSERT

Line 3021: LAST_UPDATED_BY = fnd_global.user_id,

3017: CREATED_BY = fnd_global.user_id,
3018: CREATION_DATE = SYSDATE,
3019: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3020: LAST_UPDATE_DATE = SYSDATE,
3021: LAST_UPDATED_BY = fnd_global.user_id,
3022: APPLICATION_ID = 235
3023: WHEN NOT MATCHED THEN INSERT
3024: (
3025: CODE_ASSIGNMENT_ID,

Line 3065: fnd_global.user_id,

3061: 'USER_ENTERED',
3062: Null,
3063: Sysdate,
3064: Null,
3065: fnd_global.user_id,
3066: Sysdate,
3067: FND_GLOBAL.CONC_LOGIN_ID,
3068: Sysdate,
3069: fnd_global.user_id,

Line 3067: FND_GLOBAL.CONC_LOGIN_ID,

3063: Sysdate,
3064: Null,
3065: fnd_global.user_id,
3066: Sysdate,
3067: FND_GLOBAL.CONC_LOGIN_ID,
3068: Sysdate,
3069: fnd_global.user_id,
3070: Null,
3071: Null,

Line 3069: fnd_global.user_id,

3065: fnd_global.user_id,
3066: Sysdate,
3067: FND_GLOBAL.CONC_LOGIN_ID,
3068: Sysdate,
3069: fnd_global.user_id,
3070: Null,
3071: Null,
3072: Null,
3073: 235,

Line 3108: CREATED_BY = fnd_global.user_id,

3104: ACTUAL_CONTENT_SOURCE = 'USER_ENTERED',
3105: IMPORTANCE_RANKING = Null,
3106: START_DATE_ACTIVE = SYSDATE,
3107: END_DATE_ACTIVE = Null,
3108: CREATED_BY = fnd_global.user_id,
3109: CREATION_DATE = SYSDATE,
3110: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3111: LAST_UPDATE_DATE = SYSDATE,
3112: LAST_UPDATED_BY = fnd_global.user_id,

Line 3110: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

3106: START_DATE_ACTIVE = SYSDATE,
3107: END_DATE_ACTIVE = Null,
3108: CREATED_BY = fnd_global.user_id,
3109: CREATION_DATE = SYSDATE,
3110: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3111: LAST_UPDATE_DATE = SYSDATE,
3112: LAST_UPDATED_BY = fnd_global.user_id,
3113: APPLICATION_ID = 235
3114: WHERE

Line 3112: LAST_UPDATED_BY = fnd_global.user_id,

3108: CREATED_BY = fnd_global.user_id,
3109: CREATION_DATE = SYSDATE,
3110: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
3111: LAST_UPDATE_DATE = SYSDATE,
3112: LAST_UPDATED_BY = fnd_global.user_id,
3113: APPLICATION_ID = 235
3114: WHERE
3115: OWNER_TABLE_ID = p_party_tax_profile_id and
3116: CLASS_CATEGORY = p_fiscal_class_type_code and

Line 3223: fnd_global.user_id,

3219: DESCRIPTION,
3220: ENABLED_FLAG,
3221: START_DATE_ACTIVE,
3222: END_DATE_ACTIVE,
3223: fnd_global.user_id,
3224: SYSDATE,
3225: fnd_global.user_id,
3226: fnd_global.conc_login_id,
3227: SYSDATE,

Line 3225: fnd_global.user_id,

3221: START_DATE_ACTIVE,
3222: END_DATE_ACTIVE,
3223: fnd_global.user_id,
3224: SYSDATE,
3225: fnd_global.user_id,
3226: fnd_global.conc_login_id,
3227: SYSDATE,
3228: SOURCE_LANG,
3229: SECURITY_GROUP_ID,

Line 3226: fnd_global.conc_login_id,

3222: END_DATE_ACTIVE,
3223: fnd_global.user_id,
3224: SYSDATE,
3225: fnd_global.user_id,
3226: fnd_global.conc_login_id,
3227: SYSDATE,
3228: SOURCE_LANG,
3229: SECURITY_GROUP_ID,
3230: VIEW_APPLICATION_ID,