DBA Data[Home] [Help]

APPS.ZX_PTP_CUST_MIG_PKG dependencies on FND_GLOBAL

Line 5: l_Created_By zx_party_tax_profile.created_by%type := fnd_global.user_id;

1: PACKAGE BODY ZX_PTP_CUST_MIG_PKG AS
2: /* $Header: zxptpcustmigb.pls 120.22 2005/07/25 07:45:36 asengupt ship $ */
3:
4:
5: l_Created_By zx_party_tax_profile.created_by%type := fnd_global.user_id;
6: l_Creation_Date zx_party_tax_profile.creation_date%type := SYSDATE;
7: l_Last_Updated_By zx_party_tax_profile.last_updated_by%type := fnd_global.user_id;
8: l_Last_Update_Date zx_party_tax_profile.last_update_date%type := SYSDATE;
9: l_Last_Update_Login zx_party_tax_profile.last_update_login%type := FND_GLOBAL.CONC_LOGIN_ID;

Line 7: l_Last_Updated_By zx_party_tax_profile.last_updated_by%type := fnd_global.user_id;

3:
4:
5: l_Created_By zx_party_tax_profile.created_by%type := fnd_global.user_id;
6: l_Creation_Date zx_party_tax_profile.creation_date%type := SYSDATE;
7: l_Last_Updated_By zx_party_tax_profile.last_updated_by%type := fnd_global.user_id;
8: l_Last_Update_Date zx_party_tax_profile.last_update_date%type := SYSDATE;
9: l_Last_Update_Login zx_party_tax_profile.last_update_login%type := FND_GLOBAL.CONC_LOGIN_ID;
10: l_Request_Id zx_party_tax_profile.request_id%type := FND_GLOBAL.CONC_REQUEST_ID;
11: l_Program_Application_Id zx_party_tax_profile.program_application_id%type := 235;

Line 9: l_Last_Update_Login zx_party_tax_profile.last_update_login%type := FND_GLOBAL.CONC_LOGIN_ID;

5: l_Created_By zx_party_tax_profile.created_by%type := fnd_global.user_id;
6: l_Creation_Date zx_party_tax_profile.creation_date%type := SYSDATE;
7: l_Last_Updated_By zx_party_tax_profile.last_updated_by%type := fnd_global.user_id;
8: l_Last_Update_Date zx_party_tax_profile.last_update_date%type := SYSDATE;
9: l_Last_Update_Login zx_party_tax_profile.last_update_login%type := FND_GLOBAL.CONC_LOGIN_ID;
10: l_Request_Id zx_party_tax_profile.request_id%type := FND_GLOBAL.CONC_REQUEST_ID;
11: l_Program_Application_Id zx_party_tax_profile.program_application_id%type := 235;
12: l_Program_Id zx_party_tax_profile.program_id%type := FND_GLOBAL.CONC_PROGRAM_ID;
13: l_Program_Login_Id zx_party_tax_profile.program_login_id%type := FND_GLOBAL.CONC_LOGIN_ID;

Line 10: l_Request_Id zx_party_tax_profile.request_id%type := FND_GLOBAL.CONC_REQUEST_ID;

6: l_Creation_Date zx_party_tax_profile.creation_date%type := SYSDATE;
7: l_Last_Updated_By zx_party_tax_profile.last_updated_by%type := fnd_global.user_id;
8: l_Last_Update_Date zx_party_tax_profile.last_update_date%type := SYSDATE;
9: l_Last_Update_Login zx_party_tax_profile.last_update_login%type := FND_GLOBAL.CONC_LOGIN_ID;
10: l_Request_Id zx_party_tax_profile.request_id%type := FND_GLOBAL.CONC_REQUEST_ID;
11: l_Program_Application_Id zx_party_tax_profile.program_application_id%type := 235;
12: l_Program_Id zx_party_tax_profile.program_id%type := FND_GLOBAL.CONC_PROGRAM_ID;
13: l_Program_Login_Id zx_party_tax_profile.program_login_id%type := FND_GLOBAL.CONC_LOGIN_ID;
14:

Line 12: l_Program_Id zx_party_tax_profile.program_id%type := FND_GLOBAL.CONC_PROGRAM_ID;

8: l_Last_Update_Date zx_party_tax_profile.last_update_date%type := SYSDATE;
9: l_Last_Update_Login zx_party_tax_profile.last_update_login%type := FND_GLOBAL.CONC_LOGIN_ID;
10: l_Request_Id zx_party_tax_profile.request_id%type := FND_GLOBAL.CONC_REQUEST_ID;
11: l_Program_Application_Id zx_party_tax_profile.program_application_id%type := 235;
12: l_Program_Id zx_party_tax_profile.program_id%type := FND_GLOBAL.CONC_PROGRAM_ID;
13: l_Program_Login_Id zx_party_tax_profile.program_login_id%type := FND_GLOBAL.CONC_LOGIN_ID;
14:
15: ----The variables added below enable the ad_parallel_update feature to be used to imporve performance
16: l_worker_id NUMBER;

Line 13: l_Program_Login_Id zx_party_tax_profile.program_login_id%type := FND_GLOBAL.CONC_LOGIN_ID;

9: l_Last_Update_Login zx_party_tax_profile.last_update_login%type := FND_GLOBAL.CONC_LOGIN_ID;
10: l_Request_Id zx_party_tax_profile.request_id%type := FND_GLOBAL.CONC_REQUEST_ID;
11: l_Program_Application_Id zx_party_tax_profile.program_application_id%type := 235;
12: l_Program_Id zx_party_tax_profile.program_id%type := FND_GLOBAL.CONC_PROGRAM_ID;
13: l_Program_Login_Id zx_party_tax_profile.program_login_id%type := FND_GLOBAL.CONC_LOGIN_ID;
14:
15: ----The variables added below enable the ad_parallel_update feature to be used to imporve performance
16: l_worker_id NUMBER;
17: l_num_workers NUMBER;

Line 345: fnd_global.user_id ,

341: 'E' ,
342: 0 ,
343: 0 ,
344: SYSDATE ,
345: fnd_global.user_id ,
346: SYSDATE ,
347: fnd_global.user_id ,
348: fnd_global.conc_login_id
349: )

Line 347: fnd_global.user_id ,

343: 0 ,
344: SYSDATE ,
345: fnd_global.user_id ,
346: SYSDATE ,
347: fnd_global.user_id ,
348: fnd_global.conc_login_id
349: )
350: SELECT 1 FROM DUAL;
351:

Line 348: fnd_global.conc_login_id

344: SYSDATE ,
345: fnd_global.user_id ,
346: SYSDATE ,
347: fnd_global.user_id ,
348: fnd_global.conc_login_id
349: )
350: SELECT 1 FROM DUAL;
351:
352: INSERT INTO FND_LOOKUP_TYPES_TL

Line 375: fnd_global.user_id ,

371: L.LANGUAGE_CODE ,
372: userenv('LANG') ,
373: 'Tax Registrations Geo Type Classification',--MEANING
374: 'This lookup type has been created to migrate HZ_CUST_SITE_USES.TAX_CLASSIFICATION to tax registrations.' ,--DESCRIPTION
375: fnd_global.user_id ,
376: SYSDATE ,
377: fnd_global.user_id ,
378: SYSDATE ,
379: fnd_global.conc_login_id

Line 377: fnd_global.user_id ,

373: 'Tax Registrations Geo Type Classification',--MEANING
374: 'This lookup type has been created to migrate HZ_CUST_SITE_USES.TAX_CLASSIFICATION to tax registrations.' ,--DESCRIPTION
375: fnd_global.user_id ,
376: SYSDATE ,
377: fnd_global.user_id ,
378: SYSDATE ,
379: fnd_global.conc_login_id
380: FROM FND_LOOKUP_TYPES types, FND_LANGUAGES L
381: WHERE L.INSTALLED_FLAG in ('I', 'B')

Line 379: fnd_global.conc_login_id

375: fnd_global.user_id ,
376: SYSDATE ,
377: fnd_global.user_id ,
378: SYSDATE ,
379: fnd_global.conc_login_id
380: FROM FND_LOOKUP_TYPES types, FND_LANGUAGES L
381: WHERE L.INSTALLED_FLAG in ('I', 'B')
382: AND types.lookup_type = 'ZX_PTPTR_GEO_TYPE_CLASS'
383: AND not exists

Line 459: fnd_global.user_id ,

455: NULL ,--ATTRIBUTE14
456: NULL ,--ATTRIBUTE15
457: NULL ,--TAG
458: SYSDATE ,
459: fnd_global.user_id ,
460: SYSDATE ,
461: fnd_global.user_id ,
462: fnd_global.conc_login_id
463: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 461: fnd_global.user_id ,

457: NULL ,--TAG
458: SYSDATE ,
459: fnd_global.user_id ,
460: SYSDATE ,
461: fnd_global.user_id ,
462: fnd_global.conc_login_id
463: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
464: WHERE lk.lookup_type = 'AR_TAX_CLASSIFICATION'
465: and lk.language = 'US'

Line 462: fnd_global.conc_login_id

458: SYSDATE ,
459: fnd_global.user_id ,
460: SYSDATE ,
461: fnd_global.user_id ,
462: fnd_global.conc_login_id
463: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
464: WHERE lk.lookup_type = 'AR_TAX_CLASSIFICATION'
465: and lk.language = 'US'
466: and l.installed_flag in ('I', 'B')