eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TAX_CONTENT_UPLOAD dependencies on FND_GLOBAL

Line 327: fnd_global.user_id , -- CREATED_BY

323: NULL , -- COLL_TAX_AUTHORITY_ID
324: NULL , -- THRSHLD_CHK_TMPLT_CODE
325: NULL , -- DEF_PRIMARY_REC_RATE_CODE
326: NULL , -- DEF_SECONDARY_REC_RATE_CODE
327: fnd_global.user_id , -- CREATED_BY
328: SYSDATE , -- CREATION_DATE
329: fnd_global.user_id , -- LAST_UPDATED_BY
330: SYSDATE , -- LAST_UPDATE_DATE
331: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

Line 329: fnd_global.user_id , -- LAST_UPDATED_BY

325: NULL , -- DEF_PRIMARY_REC_RATE_CODE
326: NULL , -- DEF_SECONDARY_REC_RATE_CODE
327: fnd_global.user_id , -- CREATED_BY
328: SYSDATE , -- CREATION_DATE
329: fnd_global.user_id , -- LAST_UPDATED_BY
330: SYSDATE , -- LAST_UPDATE_DATE
331: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
332: fnd_global.conc_request_id , -- REQUEST_ID
333: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID

Line 331: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

327: fnd_global.user_id , -- CREATED_BY
328: SYSDATE , -- CREATION_DATE
329: fnd_global.user_id , -- LAST_UPDATED_BY
330: SYSDATE , -- LAST_UPDATE_DATE
331: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
332: fnd_global.conc_request_id , -- REQUEST_ID
333: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
334: fnd_global.conc_program_id , -- PROGRAM_ID
335: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID

Line 332: fnd_global.conc_request_id , -- REQUEST_ID

328: SYSDATE , -- CREATION_DATE
329: fnd_global.user_id , -- LAST_UPDATED_BY
330: SYSDATE , -- LAST_UPDATE_DATE
331: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
332: fnd_global.conc_request_id , -- REQUEST_ID
333: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
334: fnd_global.conc_program_id , -- PROGRAM_ID
335: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
336: p_tax_zone_type , -- OVERRIDE_GEOGRAPHY_TYPE

Line 333: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID

329: fnd_global.user_id , -- LAST_UPDATED_BY
330: SYSDATE , -- LAST_UPDATE_DATE
331: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
332: fnd_global.conc_request_id , -- REQUEST_ID
333: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
334: fnd_global.conc_program_id , -- PROGRAM_ID
335: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
336: p_tax_zone_type , -- OVERRIDE_GEOGRAPHY_TYPE
337: 1 , -- OBJECT_VERSION_NUMBER

Line 334: fnd_global.conc_program_id , -- PROGRAM_ID

330: SYSDATE , -- LAST_UPDATE_DATE
331: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
332: fnd_global.conc_request_id , -- REQUEST_ID
333: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
334: fnd_global.conc_program_id , -- PROGRAM_ID
335: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
336: p_tax_zone_type , -- OVERRIDE_GEOGRAPHY_TYPE
337: 1 , -- OBJECT_VERSION_NUMBER
338: 'CREATE_ACCOUNTS' , --TAX_ACCOUNT_CREATE_METHOD_CODE

Line 335: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID

331: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
332: fnd_global.conc_request_id , -- REQUEST_ID
333: fnd_global.prog_appl_id , -- PROGRAM_APPLICATION_ID
334: fnd_global.conc_program_id , -- PROGRAM_ID
335: fnd_global.conc_login_id , -- PROGRAM_LOGIN_ID
336: p_tax_zone_type , -- OVERRIDE_GEOGRAPHY_TYPE
337: 1 , -- OBJECT_VERSION_NUMBER
338: 'CREATE_ACCOUNTS' , --TAX_ACCOUNT_CREATE_METHOD_CODE
339: decode(l_tax,'STATE', NULL,'STATE') , --TAX_ACCOUNT_SOURCE_TAX

Line 373: fnd_global.user_id , -- CREATED_BY

369: SELECT
370: fl.LANGUAGE_CODE ,
371: USERENV('LANG') ,
372: l_tax ,
373: fnd_global.user_id , -- CREATED_BY
374: SYSDATE , -- CREATION_DATE
375: fnd_global.user_id , -- LAST_UPDATED_BY
376: SYSDATE , -- LAST_UPDATE_DATE
377: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

Line 375: fnd_global.user_id , -- LAST_UPDATED_BY

371: USERENV('LANG') ,
372: l_tax ,
373: fnd_global.user_id , -- CREATED_BY
374: SYSDATE , -- CREATION_DATE
375: fnd_global.user_id , -- LAST_UPDATED_BY
376: SYSDATE , -- LAST_UPDATE_DATE
377: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
378: ztb.tax_id
379: FROM ZX_TAXES_B ztb,

Line 377: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

373: fnd_global.user_id , -- CREATED_BY
374: SYSDATE , -- CREATION_DATE
375: fnd_global.user_id , -- LAST_UPDATED_BY
376: SYSDATE , -- LAST_UPDATE_DATE
377: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
378: ztb.tax_id
379: FROM ZX_TAXES_B ztb,
380: FND_LANGUAGES fl
381: WHERE fl.INSTALLED_FLAG IN ('I', 'B')

Line 486: fnd_global.user_id,

482: NULL,
483: NULL,
484: NULL,
485: SYSDATE,
486: fnd_global.user_id,
487: SYSDATE,
488: fnd_global.user_id,
489: fnd_global.conc_login_id,
490: fnd_global.conc_request_id ,-- Request Id

Line 488: fnd_global.user_id,

484: NULL,
485: SYSDATE,
486: fnd_global.user_id,
487: SYSDATE,
488: fnd_global.user_id,
489: fnd_global.conc_login_id,
490: fnd_global.conc_request_id ,-- Request Id
491: 1
492: );

Line 489: fnd_global.conc_login_id,

485: SYSDATE,
486: fnd_global.user_id,
487: SYSDATE,
488: fnd_global.user_id,
489: fnd_global.conc_login_id,
490: fnd_global.conc_request_id ,-- Request Id
491: 1
492: );
493:

Line 490: fnd_global.conc_request_id ,-- Request Id

486: fnd_global.user_id,
487: SYSDATE,
488: fnd_global.user_id,
489: fnd_global.conc_login_id,
490: fnd_global.conc_request_id ,-- Request Id
491: 1
492: );
493:
494: FND_FILE.PUT_LINE

Line 522: fnd_global.user_id , -- CREATED_BY

518: SELECT
519: fl.LANGUAGE_CODE ,
520: USERENV('LANG') ,
521: 'STANDARD' ,
522: fnd_global.user_id , -- CREATED_BY
523: SYSDATE , -- CREATION_DATE
524: fnd_global.user_id , -- LAST_UPDATED_BY
525: SYSDATE , -- LAST_UPDATE_DATE
526: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

Line 524: fnd_global.user_id , -- LAST_UPDATED_BY

520: USERENV('LANG') ,
521: 'STANDARD' ,
522: fnd_global.user_id , -- CREATED_BY
523: SYSDATE , -- CREATION_DATE
524: fnd_global.user_id , -- LAST_UPDATED_BY
525: SYSDATE , -- LAST_UPDATE_DATE
526: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
527: zsb.tax_status_id
528: FROM ZX_STATUS_B zsb,

Line 526: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

522: fnd_global.user_id , -- CREATED_BY
523: SYSDATE , -- CREATION_DATE
524: fnd_global.user_id , -- LAST_UPDATED_BY
525: SYSDATE , -- LAST_UPDATE_DATE
526: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
527: zsb.tax_status_id
528: FROM ZX_STATUS_B zsb,
529: FND_LANGUAGES fl
530: WHERE fl.INSTALLED_FLAG IN ('I', 'B')

Line 2346: fnd_global.user_id,

2342: geography_element4_code,
2343: G_CREATED_BY_MODULE,
2344: country_code,
2345: 'PST',
2346: fnd_global.user_id,
2347: sysdate,
2348: fnd_global.user_id,
2349: sysdate,
2350: fnd_global.conc_login_id

Line 2348: fnd_global.user_id,

2344: country_code,
2345: 'PST',
2346: fnd_global.user_id,
2347: sysdate,
2348: fnd_global.user_id,
2349: sysdate,
2350: fnd_global.conc_login_id
2351: )
2352: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 2350: fnd_global.conc_login_id

2346: fnd_global.user_id,
2347: sysdate,
2348: fnd_global.user_id,
2349: sysdate,
2350: fnd_global.conc_login_id
2351: )
2352: INTO HZ_GEOGRAPHY_IDENTIFIERS
2353: (
2354: GEOGRAPHY_ID,

Line 2384: fnd_global.user_id,

2380: 'US',
2381: 'MASTER_REF',
2382: geography_type,
2383: G_CREATED_BY_MODULE,
2384: fnd_global.user_id,
2385: sysdate,
2386: fnd_global.user_id,
2387: sysdate,
2388: fnd_global.conc_login_id

Line 2386: fnd_global.user_id,

2382: geography_type,
2383: G_CREATED_BY_MODULE,
2384: fnd_global.user_id,
2385: sysdate,
2386: fnd_global.user_id,
2387: sysdate,
2388: fnd_global.conc_login_id
2389: )
2390: --Self

Line 2388: fnd_global.conc_login_id

2384: fnd_global.user_id,
2385: sysdate,
2386: fnd_global.user_id,
2387: sysdate,
2388: fnd_global.conc_login_id
2389: )
2390: --Self
2391: INTO hz_hierarchy_nodes
2392: (

Line 2430: fnd_global.user_id,

2426: start_date,
2427: end_date,
2428: 'A',
2429: null,
2430: fnd_global.user_id,
2431: sysdate,
2432: fnd_global.user_id,
2433: sysdate,
2434: fnd_global.conc_login_id,

Line 2432: fnd_global.user_id,

2428: 'A',
2429: null,
2430: fnd_global.user_id,
2431: sysdate,
2432: fnd_global.user_id,
2433: sysdate,
2434: fnd_global.conc_login_id,
2435: p_tax_content_source
2436: )

Line 2434: fnd_global.conc_login_id,

2430: fnd_global.user_id,
2431: sysdate,
2432: fnd_global.user_id,
2433: sysdate,
2434: fnd_global.conc_login_id,
2435: p_tax_content_source
2436: )
2437: WHEN (action_type = 'UPDATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN
2438: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 2470: fnd_global.user_id,

2466: 'US',
2467: 'MASTER_REF',
2468: geography_type,
2469: G_CREATED_BY_MODULE,
2470: fnd_global.user_id,
2471: sysdate,
2472: fnd_global.user_id,
2473: sysdate,
2474: fnd_global.conc_login_id

Line 2472: fnd_global.user_id,

2468: geography_type,
2469: G_CREATED_BY_MODULE,
2470: fnd_global.user_id,
2471: sysdate,
2472: fnd_global.user_id,
2473: sysdate,
2474: fnd_global.conc_login_id
2475: )
2476: WHEN (action_type = 'UPDATE' AND geography_type IN ('COUNTY','CITY') AND geography_name IS NOT NULL) THEN

Line 2474: fnd_global.conc_login_id

2470: fnd_global.user_id,
2471: sysdate,
2472: fnd_global.user_id,
2473: sysdate,
2474: fnd_global.conc_login_id
2475: )
2476: WHEN (action_type = 'UPDATE' AND geography_type IN ('COUNTY','CITY') AND geography_name IS NOT NULL) THEN
2477: INTO HZ_GEOGRAPHY_IDENTIFIERS
2478: (

Line 2509: fnd_global.user_id,

2505: 'US',
2506: 'MASTER_REF',
2507: geography_type,
2508: G_CREATED_BY_MODULE,
2509: fnd_global.user_id,
2510: sysdate,
2511: fnd_global.user_id,
2512: sysdate,
2513: fnd_global.conc_login_id

Line 2511: fnd_global.user_id,

2507: geography_type,
2508: G_CREATED_BY_MODULE,
2509: fnd_global.user_id,
2510: sysdate,
2511: fnd_global.user_id,
2512: sysdate,
2513: fnd_global.conc_login_id
2514: )
2515: WHEN (action_type = 'CREATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN

Line 2513: fnd_global.conc_login_id

2509: fnd_global.user_id,
2510: sysdate,
2511: fnd_global.user_id,
2512: sysdate,
2513: fnd_global.conc_login_id
2514: )
2515: WHEN (action_type = 'CREATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN
2516: INTO HZ_GEOGRAPHY_IDENTIFIERS
2517: (

Line 2548: fnd_global.user_id,

2544: 'US',
2545: 'MASTER_REF',
2546: geography_type,
2547: G_CREATED_BY_MODULE,
2548: fnd_global.user_id,
2549: sysdate,
2550: fnd_global.user_id,
2551: sysdate,
2552: fnd_global.conc_login_id

Line 2550: fnd_global.user_id,

2546: geography_type,
2547: G_CREATED_BY_MODULE,
2548: fnd_global.user_id,
2549: sysdate,
2550: fnd_global.user_id,
2551: sysdate,
2552: fnd_global.conc_login_id
2553: )
2554: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 2552: fnd_global.conc_login_id

2548: fnd_global.user_id,
2549: sysdate,
2550: fnd_global.user_id,
2551: sysdate,
2552: fnd_global.conc_login_id
2553: )
2554: INTO HZ_GEOGRAPHY_IDENTIFIERS
2555: (
2556: GEOGRAPHY_ID,

Line 2586: fnd_global.user_id,

2582: 'US',
2583: 'MASTER_REF',
2584: geography_type,
2585: G_CREATED_BY_MODULE,
2586: fnd_global.user_id,
2587: sysdate,
2588: fnd_global.user_id,
2589: sysdate,
2590: fnd_global.conc_login_id

Line 2588: fnd_global.user_id,

2584: geography_type,
2585: G_CREATED_BY_MODULE,
2586: fnd_global.user_id,
2587: sysdate,
2588: fnd_global.user_id,
2589: sysdate,
2590: fnd_global.conc_login_id
2591: )
2592: WHEN (action_type = 'CREATE') THEN

Line 2590: fnd_global.conc_login_id

2586: fnd_global.user_id,
2587: sysdate,
2588: fnd_global.user_id,
2589: sysdate,
2590: fnd_global.conc_login_id
2591: )
2592: WHEN (action_type = 'CREATE') THEN
2593: INTO HZ_RELATIONSHIPS
2594: (

Line 2637: fnd_global.user_id,

2633: null,
2634: start_date,
2635: end_date,
2636: 'A',
2637: fnd_global.user_id,
2638: sysdate,
2639: fnd_global.user_id,
2640: sysdate,
2641: fnd_global.conc_login_id,

Line 2639: fnd_global.user_id,

2635: end_date,
2636: 'A',
2637: fnd_global.user_id,
2638: sysdate,
2639: fnd_global.user_id,
2640: sysdate,
2641: fnd_global.conc_login_id,
2642: G_CREATED_BY_MODULE,
2643: 'MASTER_REF',

Line 2641: fnd_global.conc_login_id,

2637: fnd_global.user_id,
2638: sysdate,
2639: fnd_global.user_id,
2640: sysdate,
2641: fnd_global.conc_login_id,
2642: G_CREATED_BY_MODULE,
2643: 'MASTER_REF',
2644: 1,
2645: G_CREATED_BY_MODULE,

Line 2695: fnd_global.user_id,

2691: null,
2692: start_date,
2693: end_date,
2694: 'A',
2695: fnd_global.user_id,
2696: sysdate,
2697: fnd_global.user_id,
2698: sysdate,
2699: fnd_global.conc_login_id,

Line 2697: fnd_global.user_id,

2693: end_date,
2694: 'A',
2695: fnd_global.user_id,
2696: sysdate,
2697: fnd_global.user_id,
2698: sysdate,
2699: fnd_global.conc_login_id,
2700: G_CREATED_BY_MODULE,
2701: 'MASTER_REF',

Line 2699: fnd_global.conc_login_id,

2695: fnd_global.user_id,
2696: sysdate,
2697: fnd_global.user_id,
2698: sysdate,
2699: fnd_global.conc_login_id,
2700: G_CREATED_BY_MODULE,
2701: 'MASTER_REF',
2702: 1,
2703: G_CREATED_BY_MODULE,

Line 2749: fnd_global.user_id,

2745: start_date,
2746: end_date,
2747: 'A',
2748: hz_relationships_s.nextval,
2749: fnd_global.user_id,
2750: sysdate,
2751: fnd_global.user_id,
2752: sysdate,
2753: fnd_global.conc_login_id,

Line 2751: fnd_global.user_id,

2747: 'A',
2748: hz_relationships_s.nextval,
2749: fnd_global.user_id,
2750: sysdate,
2751: fnd_global.user_id,
2752: sysdate,
2753: fnd_global.conc_login_id,
2754: p_tax_content_source
2755: )

Line 2753: fnd_global.conc_login_id,

2749: fnd_global.user_id,
2750: sysdate,
2751: fnd_global.user_id,
2752: sysdate,
2753: fnd_global.conc_login_id,
2754: p_tax_content_source
2755: )
2756: WHEN (action_type = 'CREATE' AND geography_type = 'COUNTY') THEN
2757: INTO hz_hierarchy_nodes

Line 2796: fnd_global.user_id,

2792: start_date,
2793: end_date,
2794: 'A',
2795: null ,
2796: fnd_global.user_id,
2797: sysdate,
2798: fnd_global.user_id,
2799: sysdate,
2800: fnd_global.conc_login_id,

Line 2798: fnd_global.user_id,

2794: 'A',
2795: null ,
2796: fnd_global.user_id,
2797: sysdate,
2798: fnd_global.user_id,
2799: sysdate,
2800: fnd_global.conc_login_id,
2801: p_tax_content_source
2802: )

Line 2800: fnd_global.conc_login_id,

2796: fnd_global.user_id,
2797: sysdate,
2798: fnd_global.user_id,
2799: sysdate,
2800: fnd_global.conc_login_id,
2801: p_tax_content_source
2802: )
2803: WHEN (action_type = 'CREATE' AND geography_type = 'CITY') THEN
2804: INTO hz_hierarchy_nodes

Line 2843: fnd_global.user_id,

2839: start_date,
2840: end_date,
2841: 'A',
2842: null ,
2843: fnd_global.user_id,
2844: sysdate,
2845: fnd_global.user_id,
2846: sysdate,
2847: fnd_global.conc_login_id,

Line 2845: fnd_global.user_id,

2841: 'A',
2842: null ,
2843: fnd_global.user_id,
2844: sysdate,
2845: fnd_global.user_id,
2846: sysdate,
2847: fnd_global.conc_login_id,
2848: p_tax_content_source
2849: )

Line 2847: fnd_global.conc_login_id,

2843: fnd_global.user_id,
2844: sysdate,
2845: fnd_global.user_id,
2846: sysdate,
2847: fnd_global.conc_login_id,
2848: p_tax_content_source
2849: )
2850: INTO hz_hierarchy_nodes
2851: (

Line 2889: fnd_global.user_id,

2885: start_date,
2886: end_date,
2887: 'A',
2888: null ,
2889: fnd_global.user_id,
2890: sysdate,
2891: fnd_global.user_id,
2892: sysdate,
2893: fnd_global.conc_login_id,

Line 2891: fnd_global.user_id,

2887: 'A',
2888: null ,
2889: fnd_global.user_id,
2890: sysdate,
2891: fnd_global.user_id,
2892: sysdate,
2893: fnd_global.conc_login_id,
2894: p_tax_content_source
2895: )

Line 2893: fnd_global.conc_login_id,

2889: fnd_global.user_id,
2890: sysdate,
2891: fnd_global.user_id,
2892: sysdate,
2893: fnd_global.conc_login_id,
2894: p_tax_content_source
2895: )
2896: SELECT geography_id,
2897: geography_name,

Line 3229: fnd_global.user_id,

3225: 'N',
3226: G_CREATED_BY_MODULE,
3227: country_code,
3228: 'PST',
3229: fnd_global.user_id,
3230: sysdate,
3231: fnd_global.user_id,
3232: sysdate,
3233: fnd_global.conc_login_id

Line 3231: fnd_global.user_id,

3227: country_code,
3228: 'PST',
3229: fnd_global.user_id,
3230: sysdate,
3231: fnd_global.user_id,
3232: sysdate,
3233: fnd_global.conc_login_id
3234: )
3235: WHEN (zone_geography_type IS NOT NULL AND zone_geography_id IS NOT NULL

Line 3233: fnd_global.conc_login_id

3229: fnd_global.user_id,
3230: sysdate,
3231: fnd_global.user_id,
3232: sysdate,
3233: fnd_global.conc_login_id
3234: )
3235: WHEN (zone_geography_type IS NOT NULL AND zone_geography_id IS NOT NULL
3236: AND existing_geography_id IS NULL and primary_flag = 'Y') THEN
3237: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 3269: fnd_global.user_id,

3265: 'US',
3266: 'TAX',
3267: zone_geography_type,
3268: G_CREATED_BY_MODULE,
3269: fnd_global.user_id,
3270: sysdate,
3271: fnd_global.user_id,
3272: sysdate,
3273: fnd_global.conc_login_id

Line 3271: fnd_global.user_id,

3267: zone_geography_type,
3268: G_CREATED_BY_MODULE,
3269: fnd_global.user_id,
3270: sysdate,
3271: fnd_global.user_id,
3272: sysdate,
3273: fnd_global.conc_login_id
3274: )
3275: WHEN (zone_geography_type IS NOT NULL AND zone_geography_id IS NOT NULL

Line 3273: fnd_global.conc_login_id

3269: fnd_global.user_id,
3270: sysdate,
3271: fnd_global.user_id,
3272: sysdate,
3273: fnd_global.conc_login_id
3274: )
3275: WHEN (zone_geography_type IS NOT NULL AND zone_geography_id IS NOT NULL
3276: AND existing_geography_id IS NULL and primary_flag = 'Y') THEN
3277: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 3309: fnd_global.user_id,

3305: 'US',
3306: 'TAX',
3307: zone_geography_type,
3308: G_CREATED_BY_MODULE,
3309: fnd_global.user_id,
3310: sysdate,
3311: fnd_global.user_id,
3312: sysdate,
3313: fnd_global.conc_login_id

Line 3311: fnd_global.user_id,

3307: zone_geography_type,
3308: G_CREATED_BY_MODULE,
3309: fnd_global.user_id,
3310: sysdate,
3311: fnd_global.user_id,
3312: sysdate,
3313: fnd_global.conc_login_id
3314: )
3315: WHEN (zone_geography_type IS NOT NULL AND zone_geography_id IS NOT NULL) THEN

Line 3313: fnd_global.conc_login_id

3309: fnd_global.user_id,
3310: sysdate,
3311: fnd_global.user_id,
3312: sysdate,
3313: fnd_global.conc_login_id
3314: )
3315: WHEN (zone_geography_type IS NOT NULL AND zone_geography_id IS NOT NULL) THEN
3316: INTO HZ_RELATIONSHIPS
3317: (

Line 3360: fnd_global.user_id,

3356: null,
3357: start_date,
3358: end_date,
3359: 'A',
3360: fnd_global.user_id,
3361: sysdate,
3362: fnd_global.user_id,
3363: sysdate,
3364: fnd_global.conc_login_id,

Line 3362: fnd_global.user_id,

3358: end_date,
3359: 'A',
3360: fnd_global.user_id,
3361: sysdate,
3362: fnd_global.user_id,
3363: sysdate,
3364: fnd_global.conc_login_id,
3365: G_CREATED_BY_MODULE,
3366: 'TAX',

Line 3364: fnd_global.conc_login_id,

3360: fnd_global.user_id,
3361: sysdate,
3362: fnd_global.user_id,
3363: sysdate,
3364: fnd_global.conc_login_id,
3365: G_CREATED_BY_MODULE,
3366: 'TAX',
3367: 1,
3368: G_CREATED_BY_MODULE,

Line 3419: fnd_global.user_id,

3415: null,
3416: start_date,
3417: end_date,
3418: 'A',
3419: fnd_global.user_id,
3420: sysdate,
3421: fnd_global.user_id,
3422: sysdate,
3423: fnd_global.conc_login_id,

Line 3421: fnd_global.user_id,

3417: end_date,
3418: 'A',
3419: fnd_global.user_id,
3420: sysdate,
3421: fnd_global.user_id,
3422: sysdate,
3423: fnd_global.conc_login_id,
3424: G_CREATED_BY_MODULE,
3425: 'TAX',

Line 3423: fnd_global.conc_login_id,

3419: fnd_global.user_id,
3420: sysdate,
3421: fnd_global.user_id,
3422: sysdate,
3423: fnd_global.conc_login_id,
3424: G_CREATED_BY_MODULE,
3425: 'TAX',
3426: 1,
3427: G_CREATED_BY_MODULE,

Line 3472: fnd_global.user_id,

3468: inner_city_flag,
3469: precedence_level,
3470: 'Y',
3471: 1,
3472: fnd_global.user_id,
3473: sysdate,
3474: fnd_global.user_id,
3475: sysdate,
3476: fnd_global.conc_login_id

Line 3474: fnd_global.user_id,

3470: 'Y',
3471: 1,
3472: fnd_global.user_id,
3473: sysdate,
3474: fnd_global.user_id,
3475: sysdate,
3476: fnd_global.conc_login_id
3477: )
3478: SELECT v.geography_id,

Line 3476: fnd_global.conc_login_id

3472: fnd_global.user_id,
3473: sysdate,
3474: fnd_global.user_id,
3475: sysdate,
3476: fnd_global.conc_login_id
3477: )
3478: SELECT v.geography_id,
3479: v.geography_type,
3480: v.tax_regime_code,

Line 3850: fnd_global.user_id,

3846: za.EDISC_NON_REC_TAX_CCID,
3847: za.UNEDISC_NON_REC_TAX_CCID,
3848: za.FINCHRG_NON_REC_TAX_CCID,
3849: G_CREATED_BY_MODULE,
3850: fnd_global.user_id,
3851: sysdate,
3852: fnd_global.user_id,
3853: sysdate,
3854: fnd_global.conc_login_id

Line 3852: fnd_global.user_id,

3848: za.FINCHRG_NON_REC_TAX_CCID,
3849: G_CREATED_BY_MODULE,
3850: fnd_global.user_id,
3851: sysdate,
3852: fnd_global.user_id,
3853: sysdate,
3854: fnd_global.conc_login_id
3855: FROM ZX_JURISDICTIONS_B zjb,
3856: ZX_TAXES_B ztb,

Line 3854: fnd_global.conc_login_id

3850: fnd_global.user_id,
3851: sysdate,
3852: fnd_global.user_id,
3853: sysdate,
3854: fnd_global.conc_login_id
3855: FROM ZX_JURISDICTIONS_B zjb,
3856: ZX_TAXES_B ztb,
3857: ZX_ACCOUNTS za
3858: WHERE zjb.TAX_REGIME_CODE = p_tax_regime_code

Line 3934: fnd_global.user_id,

3930: DECODE(hg.geography_element4,null,'',SUBSTR(hg.geography_element4,1,30)||'-')
3931: FROM HZ_GEOGRAPHIES hg
3932: WHERE hg.GEOGRAPHY_ID = zjb.zone_geography_id))
3933: || zjb.TAX_JURISDICTION_CODE,
3934: fnd_global.user_id,
3935: sysdate,
3936: fnd_global.user_id,
3937: sysdate,
3938: fnd_global.conc_login_id,

Line 3936: fnd_global.user_id,

3932: WHERE hg.GEOGRAPHY_ID = zjb.zone_geography_id))
3933: || zjb.TAX_JURISDICTION_CODE,
3934: fnd_global.user_id,
3935: sysdate,
3936: fnd_global.user_id,
3937: sysdate,
3938: fnd_global.conc_login_id,
3939: fl.LANGUAGE_CODE,
3940: USERENV('LANG')

Line 3938: fnd_global.conc_login_id,

3934: fnd_global.user_id,
3935: sysdate,
3936: fnd_global.user_id,
3937: sysdate,
3938: fnd_global.conc_login_id,
3939: fl.LANGUAGE_CODE,
3940: USERENV('LANG')
3941: FROM ZX_JURISDICTIONS_B zjb,
3942: FND_LANGUAGES fl

Line 4009: LAST_UPDATED_BY = fnd_global.user_id,

4005: hgr.start_date = ref_ranges.start_date)
4006: WHEN MATCHED THEN
4007: UPDATE
4008: SET END_DATE = ref_ranges.end_date,
4009: LAST_UPDATED_BY = fnd_global.user_id,
4010: LAST_UPDATE_DATE = sysdate,
4011: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
4012: WHEN NOT MATCHED THEN
4013: INSERT

Line 4011: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

4007: UPDATE
4008: SET END_DATE = ref_ranges.end_date,
4009: LAST_UPDATED_BY = fnd_global.user_id,
4010: LAST_UPDATE_DATE = sysdate,
4011: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
4012: WHEN NOT MATCHED THEN
4013: INSERT
4014: (
4015: GEOGRAPHY_ID,

Line 4045: fnd_global.user_id,

4041: ref_ranges.geography_type,
4042: 'TAX',
4043: ref_ranges.master_ref_geography_id,
4044: 'EBTAX_CONTENT_UPLOAD',
4045: fnd_global.user_id,
4046: sysdate,
4047: fnd_global.user_id,
4048: sysdate,
4049: fnd_global.conc_login_id

Line 4047: fnd_global.user_id,

4043: ref_ranges.master_ref_geography_id,
4044: 'EBTAX_CONTENT_UPLOAD',
4045: fnd_global.user_id,
4046: sysdate,
4047: fnd_global.user_id,
4048: sysdate,
4049: fnd_global.conc_login_id
4050: );
4051:

Line 4049: fnd_global.conc_login_id

4045: fnd_global.user_id,
4046: sysdate,
4047: fnd_global.user_id,
4048: sysdate,
4049: fnd_global.conc_login_id
4050: );
4051:
4052: -- Migrated regime case
4053: -- insert ranges for state/county/override jurisdictions too

Line 4088: fnd_global.user_id,

4084: zone_geography_type,
4085: 'TAX',
4086: geography_id,
4087: G_CREATED_BY_MODULE,
4088: fnd_global.user_id,
4089: sysdate,
4090: fnd_global.user_id,
4091: sysdate,
4092: fnd_global.conc_login_id

Line 4090: fnd_global.user_id,

4086: geography_id,
4087: G_CREATED_BY_MODULE,
4088: fnd_global.user_id,
4089: sysdate,
4090: fnd_global.user_id,
4091: sysdate,
4092: fnd_global.conc_login_id
4093: )
4094: SELECT

Line 4092: fnd_global.conc_login_id

4088: fnd_global.user_id,
4089: sysdate,
4090: fnd_global.user_id,
4091: sysdate,
4092: fnd_global.conc_login_id
4093: )
4094: SELECT
4095: zone_geography_id,
4096: '0000' zip_begin,

Line 4279: fnd_global.user_id,

4275: null,
4276: G_CREATED_BY_MODULE,
4277: country_code,
4278: 'PST',
4279: fnd_global.user_id,
4280: sysdate,
4281: fnd_global.user_id,
4282: sysdate,
4283: fnd_global.conc_login_id

Line 4281: fnd_global.user_id,

4277: country_code,
4278: 'PST',
4279: fnd_global.user_id,
4280: sysdate,
4281: fnd_global.user_id,
4282: sysdate,
4283: fnd_global.conc_login_id
4284: )
4285: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 4283: fnd_global.conc_login_id

4279: fnd_global.user_id,
4280: sysdate,
4281: fnd_global.user_id,
4282: sysdate,
4283: fnd_global.conc_login_id
4284: )
4285: INTO HZ_GEOGRAPHY_IDENTIFIERS
4286: (
4287: GEOGRAPHY_ID,

Line 4317: fnd_global.user_id,

4313: 'US',
4314: 'MASTER_REF',
4315: geography_type,
4316: G_CREATED_BY_MODULE,
4317: fnd_global.user_id,
4318: sysdate,
4319: fnd_global.user_id,
4320: sysdate,
4321: fnd_global.conc_login_id

Line 4319: fnd_global.user_id,

4315: geography_type,
4316: G_CREATED_BY_MODULE,
4317: fnd_global.user_id,
4318: sysdate,
4319: fnd_global.user_id,
4320: sysdate,
4321: fnd_global.conc_login_id
4322: )
4323: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 4321: fnd_global.conc_login_id

4317: fnd_global.user_id,
4318: sysdate,
4319: fnd_global.user_id,
4320: sysdate,
4321: fnd_global.conc_login_id
4322: )
4323: INTO HZ_GEOGRAPHY_IDENTIFIERS
4324: (
4325: GEOGRAPHY_ID,

Line 4355: fnd_global.user_id,

4351: 'US',
4352: 'MASTER_REF',
4353: geography_type,
4354: G_CREATED_BY_MODULE,
4355: fnd_global.user_id,
4356: sysdate,
4357: fnd_global.user_id,
4358: sysdate,
4359: fnd_global.conc_login_id

Line 4357: fnd_global.user_id,

4353: geography_type,
4354: G_CREATED_BY_MODULE,
4355: fnd_global.user_id,
4356: sysdate,
4357: fnd_global.user_id,
4358: sysdate,
4359: fnd_global.conc_login_id
4360: )
4361: INTO HZ_RELATIONSHIPS

Line 4359: fnd_global.conc_login_id

4355: fnd_global.user_id,
4356: sysdate,
4357: fnd_global.user_id,
4358: sysdate,
4359: fnd_global.conc_login_id
4360: )
4361: INTO HZ_RELATIONSHIPS
4362: (
4363: RELATIONSHIP_ID,

Line 4405: fnd_global.user_id,

4401: null,
4402: start_date,
4403: end_date,
4404: 'A',
4405: fnd_global.user_id,
4406: sysdate,
4407: fnd_global.user_id,
4408: sysdate,
4409: fnd_global.conc_login_id,

Line 4407: fnd_global.user_id,

4403: end_date,
4404: 'A',
4405: fnd_global.user_id,
4406: sysdate,
4407: fnd_global.user_id,
4408: sysdate,
4409: fnd_global.conc_login_id,
4410: G_CREATED_BY_MODULE,
4411: 'MASTER_REF',

Line 4409: fnd_global.conc_login_id,

4405: fnd_global.user_id,
4406: sysdate,
4407: fnd_global.user_id,
4408: sysdate,
4409: fnd_global.conc_login_id,
4410: G_CREATED_BY_MODULE,
4411: 'MASTER_REF',
4412: 1,
4413: G_CREATED_BY_MODULE,

Line 4463: fnd_global.user_id,

4459: null,
4460: start_date,
4461: end_date,
4462: 'A',
4463: fnd_global.user_id,
4464: sysdate,
4465: fnd_global.user_id,
4466: sysdate,
4467: fnd_global.conc_login_id,

Line 4465: fnd_global.user_id,

4461: end_date,
4462: 'A',
4463: fnd_global.user_id,
4464: sysdate,
4465: fnd_global.user_id,
4466: sysdate,
4467: fnd_global.conc_login_id,
4468: G_CREATED_BY_MODULE,
4469: 'MASTER_REF',

Line 4467: fnd_global.conc_login_id,

4463: fnd_global.user_id,
4464: sysdate,
4465: fnd_global.user_id,
4466: sysdate,
4467: fnd_global.conc_login_id,
4468: G_CREATED_BY_MODULE,
4469: 'MASTER_REF',
4470: 1,
4471: G_CREATED_BY_MODULE,

Line 4517: fnd_global.user_id,

4513: start_date,
4514: end_date,
4515: 'A',
4516: null,
4517: fnd_global.user_id,
4518: sysdate,
4519: fnd_global.user_id,
4520: sysdate,
4521: fnd_global.conc_login_id,

Line 4519: fnd_global.user_id,

4515: 'A',
4516: null,
4517: fnd_global.user_id,
4518: sysdate,
4519: fnd_global.user_id,
4520: sysdate,
4521: fnd_global.conc_login_id,
4522: p_tax_content_source
4523: )

Line 4521: fnd_global.conc_login_id,

4517: fnd_global.user_id,
4518: sysdate,
4519: fnd_global.user_id,
4520: sysdate,
4521: fnd_global.conc_login_id,
4522: p_tax_content_source
4523: )
4524: -- City
4525: INTO hz_hierarchy_nodes

Line 4564: fnd_global.user_id,

4560: start_date,
4561: end_date,
4562: 'A',
4563: hz_relationships_s.nextval,
4564: fnd_global.user_id,
4565: sysdate,
4566: fnd_global.user_id,
4567: sysdate,
4568: fnd_global.conc_login_id,

Line 4566: fnd_global.user_id,

4562: 'A',
4563: hz_relationships_s.nextval,
4564: fnd_global.user_id,
4565: sysdate,
4566: fnd_global.user_id,
4567: sysdate,
4568: fnd_global.conc_login_id,
4569: p_tax_content_source
4570: )

Line 4568: fnd_global.conc_login_id,

4564: fnd_global.user_id,
4565: sysdate,
4566: fnd_global.user_id,
4567: sysdate,
4568: fnd_global.conc_login_id,
4569: p_tax_content_source
4570: )
4571: -- County
4572: WHEN (geography_element3_id IS NOT NULL) THEN

Line 4612: fnd_global.user_id,

4608: start_date,
4609: end_date,
4610: 'A',
4611: null ,
4612: fnd_global.user_id,
4613: sysdate,
4614: fnd_global.user_id,
4615: sysdate,
4616: fnd_global.conc_login_id,

Line 4614: fnd_global.user_id,

4610: 'A',
4611: null ,
4612: fnd_global.user_id,
4613: sysdate,
4614: fnd_global.user_id,
4615: sysdate,
4616: fnd_global.conc_login_id,
4617: p_tax_content_source
4618: )

Line 4616: fnd_global.conc_login_id,

4612: fnd_global.user_id,
4613: sysdate,
4614: fnd_global.user_id,
4615: sysdate,
4616: fnd_global.conc_login_id,
4617: p_tax_content_source
4618: )
4619: WHEN (geography_element2_id IS NOT NULL) THEN
4620: INTO hz_hierarchy_nodes

Line 4659: fnd_global.user_id,

4655: start_date,
4656: end_date,
4657: 'A',
4658: null ,
4659: fnd_global.user_id,
4660: sysdate,
4661: fnd_global.user_id,
4662: sysdate,
4663: fnd_global.conc_login_id,

Line 4661: fnd_global.user_id,

4657: 'A',
4658: null ,
4659: fnd_global.user_id,
4660: sysdate,
4661: fnd_global.user_id,
4662: sysdate,
4663: fnd_global.conc_login_id,
4664: p_tax_content_source
4665: )

Line 4663: fnd_global.conc_login_id,

4659: fnd_global.user_id,
4660: sysdate,
4661: fnd_global.user_id,
4662: sysdate,
4663: fnd_global.conc_login_id,
4664: p_tax_content_source
4665: )
4666: WHEN (geography_element1_id IS NOT NULL) THEN
4667: INTO hz_hierarchy_nodes

Line 4706: fnd_global.user_id,

4702: start_date,
4703: end_date,
4704: 'A',
4705: null ,
4706: fnd_global.user_id,
4707: sysdate,
4708: fnd_global.user_id,
4709: sysdate,
4710: fnd_global.conc_login_id,

Line 4708: fnd_global.user_id,

4704: 'A',
4705: null ,
4706: fnd_global.user_id,
4707: sysdate,
4708: fnd_global.user_id,
4709: sysdate,
4710: fnd_global.conc_login_id,
4711: p_tax_content_source
4712: )

Line 4710: fnd_global.conc_login_id,

4706: fnd_global.user_id,
4707: sysdate,
4708: fnd_global.user_id,
4709: sysdate,
4710: fnd_global.conc_login_id,
4711: p_tax_content_source
4712: )
4713:
4714: select v.zip_code geography_name,

Line 4948: fnd_global.user_id,

4944: 'US',
4945: 'MASTER_REF',
4946: geography_type,
4947: G_CREATED_BY_MODULE,
4948: fnd_global.user_id,
4949: sysdate,
4950: fnd_global.user_id,
4951: sysdate,
4952: fnd_global.conc_login_id

Line 4950: fnd_global.user_id,

4946: geography_type,
4947: G_CREATED_BY_MODULE,
4948: fnd_global.user_id,
4949: sysdate,
4950: fnd_global.user_id,
4951: sysdate,
4952: fnd_global.conc_login_id
4953: )
4954: SELECT DISTINCT inter.geography_id,

Line 4952: fnd_global.conc_login_id

4948: fnd_global.user_id,
4949: sysdate,
4950: fnd_global.user_id,
4951: sysdate,
4952: fnd_global.conc_login_id
4953: )
4954: SELECT DISTINCT inter.geography_id,
4955: inter.geography_name geography_name,
4956: 'CITY' geography_type

Line 5269: fnd_global.user_id,

5265: v.PERCENTAGE_RATE,
5266: 'Y',
5267: 'Y',
5268: G_CREATED_BY_MODULE,
5269: fnd_global.user_id,
5270: sysdate,
5271: fnd_global.user_id,
5272: sysdate,
5273: fnd_global.conc_login_id

Line 5271: fnd_global.user_id,

5267: 'Y',
5268: G_CREATED_BY_MODULE,
5269: fnd_global.user_id,
5270: sysdate,
5271: fnd_global.user_id,
5272: sysdate,
5273: fnd_global.conc_login_id
5274: )
5275: WHEN MATCHED THEN

Line 5273: fnd_global.conc_login_id

5269: fnd_global.user_id,
5270: sysdate,
5271: fnd_global.user_id,
5272: sysdate,
5273: fnd_global.conc_login_id
5274: )
5275: WHEN MATCHED THEN
5276: UPDATE SET zrbt.PERCENTAGE_RATE = v.percentage_rate,
5277: zrbt.EFFECTIVE_TO = v.effective_to,

Line 5280: zrbt.LAST_UPDATED_BY = fnd_global.user_id,

5276: UPDATE SET zrbt.PERCENTAGE_RATE = v.percentage_rate,
5277: zrbt.EFFECTIVE_TO = v.effective_to,
5278: zrbt.DEFAULT_FLG_EFFECTIVE_TO = v.effective_to,
5279: zrbt.ACTIVE_FLAG = v.active_flag,
5280: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
5281: zrbt.LAST_UPDATE_DATE = sysdate,
5282: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5283:
5284: FND_FILE.PUT_LINE

Line 5282: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;

5278: zrbt.DEFAULT_FLG_EFFECTIVE_TO = v.effective_to,
5279: zrbt.ACTIVE_FLAG = v.active_flag,
5280: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
5281: zrbt.LAST_UPDATE_DATE = sysdate,
5282: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5283:
5284: FND_FILE.PUT_LINE
5285: (
5286: FND_FILE.LOG,

Line 5483: fnd_global.user_id,

5479: v.PERCENTAGE_RATE,
5480: 'Y',
5481: 'Y',
5482: G_CREATED_BY_MODULE,
5483: fnd_global.user_id,
5484: sysdate,
5485: fnd_global.user_id,
5486: sysdate,
5487: fnd_global.conc_login_id

Line 5485: fnd_global.user_id,

5481: 'Y',
5482: G_CREATED_BY_MODULE,
5483: fnd_global.user_id,
5484: sysdate,
5485: fnd_global.user_id,
5486: sysdate,
5487: fnd_global.conc_login_id
5488: )
5489: WHEN MATCHED THEN

Line 5487: fnd_global.conc_login_id

5483: fnd_global.user_id,
5484: sysdate,
5485: fnd_global.user_id,
5486: sysdate,
5487: fnd_global.conc_login_id
5488: )
5489: WHEN MATCHED THEN
5490: UPDATE SET zrbt.PERCENTAGE_RATE = v.percentage_rate,
5491: zrbt.EFFECTIVE_TO = v.effective_to,

Line 5493: zrbt.LAST_UPDATED_BY = fnd_global.user_id,

5489: WHEN MATCHED THEN
5490: UPDATE SET zrbt.PERCENTAGE_RATE = v.percentage_rate,
5491: zrbt.EFFECTIVE_TO = v.effective_to,
5492: zrbt.DEFAULT_FLG_EFFECTIVE_TO = v.effective_to,
5493: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
5494: zrbt.LAST_UPDATE_DATE = sysdate,
5495: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5496:
5497: FND_FILE.PUT_LINE

Line 5495: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;

5491: zrbt.EFFECTIVE_TO = v.effective_to,
5492: zrbt.DEFAULT_FLG_EFFECTIVE_TO = v.effective_to,
5493: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
5494: zrbt.LAST_UPDATE_DATE = sysdate,
5495: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5496:
5497: FND_FILE.PUT_LINE
5498: (
5499: FND_FILE.LOG,

Line 5562: fnd_global.user_id,

5558: 0,
5559: 'Y',
5560: 'Y',
5561: G_CREATED_BY_MODULE,
5562: fnd_global.user_id,
5563: sysdate,
5564: fnd_global.user_id,
5565: sysdate,
5566: fnd_global.conc_login_id

Line 5564: fnd_global.user_id,

5560: 'Y',
5561: G_CREATED_BY_MODULE,
5562: fnd_global.user_id,
5563: sysdate,
5564: fnd_global.user_id,
5565: sysdate,
5566: fnd_global.conc_login_id
5567: )
5568: SELECT tax.TAX_REGIME_CODE TAX_REGIME_CODE,

Line 5566: fnd_global.conc_login_id

5562: fnd_global.user_id,
5563: sysdate,
5564: fnd_global.user_id,
5565: sysdate,
5566: fnd_global.conc_login_id
5567: )
5568: SELECT tax.TAX_REGIME_CODE TAX_REGIME_CODE,
5569: tax.TAX TAX,
5570: tax.EFFECTIVE_FROM EFFECTIVE_FROM

Line 5642: fnd_global.user_id,

5638: za.EDISC_NON_REC_TAX_CCID,
5639: za.UNEDISC_NON_REC_TAX_CCID,
5640: za.FINCHRG_NON_REC_TAX_CCID,
5641: G_CREATED_BY_MODULE,
5642: fnd_global.user_id,
5643: sysdate,
5644: fnd_global.user_id,
5645: sysdate,
5646: fnd_global.conc_login_id

Line 5644: fnd_global.user_id,

5640: za.FINCHRG_NON_REC_TAX_CCID,
5641: G_CREATED_BY_MODULE,
5642: fnd_global.user_id,
5643: sysdate,
5644: fnd_global.user_id,
5645: sysdate,
5646: fnd_global.conc_login_id
5647: FROM ZX_RATES_B zrb,
5648: ZX_JURISDICTIONS_B zjb,

Line 5646: fnd_global.conc_login_id

5642: fnd_global.user_id,
5643: sysdate,
5644: fnd_global.user_id,
5645: sysdate,
5646: fnd_global.conc_login_id
5647: FROM ZX_RATES_B zrb,
5648: ZX_JURISDICTIONS_B zjb,
5649: ZX_ACCOUNTS za
5650: WHERE zrb.TAX_REGIME_CODE = p_tax_regime_code

Line 5689: fnd_global.user_id,

5685: SOURCE_LANG
5686: )
5687: SELECT zrb.TAX_RATE_ID,
5688: zrb.TAX_RATE_CODE,
5689: fnd_global.user_id,
5690: sysdate,
5691: fnd_global.user_id,
5692: sysdate,
5693: fnd_global.conc_login_id,

Line 5691: fnd_global.user_id,

5687: SELECT zrb.TAX_RATE_ID,
5688: zrb.TAX_RATE_CODE,
5689: fnd_global.user_id,
5690: sysdate,
5691: fnd_global.user_id,
5692: sysdate,
5693: fnd_global.conc_login_id,
5694: fl.LANGUAGE_CODE,
5695: USERENV('LANG')

Line 5693: fnd_global.conc_login_id,

5689: fnd_global.user_id,
5690: sysdate,
5691: fnd_global.user_id,
5692: sysdate,
5693: fnd_global.conc_login_id,
5694: fl.LANGUAGE_CODE,
5695: USERENV('LANG')
5696: FROM ZX_RATES_B zrb,
5697: FND_LANGUAGES fl

Line 6219: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID,

6215: COUNTRY_CODE = l_country_code,
6216: VERSION_LOADED = TO_CHAR(l_last_run_version),
6217: CONTENT_FILE_LOCATION = l_file_location,
6218: CONTENT_FILE_NAME = l_file_name,
6219: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID,
6220: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
6221: PROGRAM_UPDATE_DATE = SYSDATE
6222: WHERE PROVIDER_ID = p_tax_content_source_id
6223: AND STANDARD_REGIME_CODE = p_tax_regime_code;

Line 6220: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,

6216: VERSION_LOADED = TO_CHAR(l_last_run_version),
6217: CONTENT_FILE_LOCATION = l_file_location,
6218: CONTENT_FILE_NAME = l_file_name,
6219: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID,
6220: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
6221: PROGRAM_UPDATE_DATE = SYSDATE
6222: WHERE PROVIDER_ID = p_tax_content_source_id
6223: AND STANDARD_REGIME_CODE = p_tax_regime_code;
6224:

Line 6263: FND_GLOBAL.CONC_PROGRAM_ID,

6259: '0',
6260: 'LOADER',
6261: l_file_location,
6262: l_file_name,
6263: FND_GLOBAL.CONC_PROGRAM_ID,
6264: FND_GLOBAL.PROG_APPL_ID,
6265: SYSDATE
6266: );
6267: ELSIF (SQL%ROWCOUNT <> 1)

Line 6264: FND_GLOBAL.PROG_APPL_ID,

6260: 'LOADER',
6261: l_file_location,
6262: l_file_name,
6263: FND_GLOBAL.CONC_PROGRAM_ID,
6264: FND_GLOBAL.PROG_APPL_ID,
6265: SYSDATE
6266: );
6267: ELSIF (SQL%ROWCOUNT <> 1)
6268: THEN