DBA Data[Home] [Help]

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 361: fnd_global.user_id , -- CREATED_BY

357: SELECT
358: fl.LANGUAGE_CODE ,
359: USERENV('LANG') ,
360: l_tax ,
361: fnd_global.user_id , -- CREATED_BY
362: SYSDATE , -- CREATION_DATE
363: fnd_global.user_id , -- LAST_UPDATED_BY
364: SYSDATE , -- LAST_UPDATE_DATE
365: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

Line 363: fnd_global.user_id , -- LAST_UPDATED_BY

359: USERENV('LANG') ,
360: l_tax ,
361: fnd_global.user_id , -- CREATED_BY
362: SYSDATE , -- CREATION_DATE
363: fnd_global.user_id , -- LAST_UPDATED_BY
364: SYSDATE , -- LAST_UPDATE_DATE
365: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
366: ztb.tax_id
367: FROM ZX_TAXES_B ztb,

Line 365: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

361: fnd_global.user_id , -- CREATED_BY
362: SYSDATE , -- CREATION_DATE
363: fnd_global.user_id , -- LAST_UPDATED_BY
364: SYSDATE , -- LAST_UPDATE_DATE
365: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
366: ztb.tax_id
367: FROM ZX_TAXES_B ztb,
368: FND_LANGUAGES fl
369: WHERE fl.INSTALLED_FLAG IN ('I', 'B')

Line 469: fnd_global.user_id,

465: NULL,
466: NULL,
467: NULL,
468: SYSDATE,
469: fnd_global.user_id,
470: SYSDATE,
471: fnd_global.user_id,
472: fnd_global.conc_login_id,
473: fnd_global.conc_request_id ,-- Request Id

Line 471: fnd_global.user_id,

467: NULL,
468: SYSDATE,
469: fnd_global.user_id,
470: SYSDATE,
471: fnd_global.user_id,
472: fnd_global.conc_login_id,
473: fnd_global.conc_request_id ,-- Request Id
474: 1
475: );

Line 472: fnd_global.conc_login_id,

468: SYSDATE,
469: fnd_global.user_id,
470: SYSDATE,
471: fnd_global.user_id,
472: fnd_global.conc_login_id,
473: fnd_global.conc_request_id ,-- Request Id
474: 1
475: );
476:

Line 473: fnd_global.conc_request_id ,-- Request Id

469: fnd_global.user_id,
470: SYSDATE,
471: fnd_global.user_id,
472: fnd_global.conc_login_id,
473: fnd_global.conc_request_id ,-- Request Id
474: 1
475: );
476:
477: INSERT INTO ZX_STATUS_TL

Line 493: fnd_global.user_id , -- CREATED_BY

489: SELECT
490: fl.LANGUAGE_CODE ,
491: USERENV('LANG') ,
492: 'STANDARD' ,
493: fnd_global.user_id , -- CREATED_BY
494: SYSDATE , -- CREATION_DATE
495: fnd_global.user_id , -- LAST_UPDATED_BY
496: SYSDATE , -- LAST_UPDATE_DATE
497: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

Line 495: fnd_global.user_id , -- LAST_UPDATED_BY

491: USERENV('LANG') ,
492: 'STANDARD' ,
493: fnd_global.user_id , -- CREATED_BY
494: SYSDATE , -- CREATION_DATE
495: fnd_global.user_id , -- LAST_UPDATED_BY
496: SYSDATE , -- LAST_UPDATE_DATE
497: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
498: zsb.tax_status_id
499: FROM ZX_STATUS_B zsb,

Line 497: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN

493: fnd_global.user_id , -- CREATED_BY
494: SYSDATE , -- CREATION_DATE
495: fnd_global.user_id , -- LAST_UPDATED_BY
496: SYSDATE , -- LAST_UPDATE_DATE
497: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
498: zsb.tax_status_id
499: FROM ZX_STATUS_B zsb,
500: FND_LANGUAGES fl
501: WHERE fl.INSTALLED_FLAG IN ('I', 'B')

Line 2057: fnd_global.user_id,

2053: geography_element4_code,
2054: G_CREATED_BY_MODULE,
2055: country_code,
2056: 'PST',
2057: fnd_global.user_id,
2058: sysdate,
2059: fnd_global.user_id,
2060: sysdate,
2061: fnd_global.conc_login_id

Line 2059: fnd_global.user_id,

2055: country_code,
2056: 'PST',
2057: fnd_global.user_id,
2058: sysdate,
2059: fnd_global.user_id,
2060: sysdate,
2061: fnd_global.conc_login_id
2062: )
2063: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 2061: fnd_global.conc_login_id

2057: fnd_global.user_id,
2058: sysdate,
2059: fnd_global.user_id,
2060: sysdate,
2061: fnd_global.conc_login_id
2062: )
2063: INTO HZ_GEOGRAPHY_IDENTIFIERS
2064: (
2065: GEOGRAPHY_ID,

Line 2095: fnd_global.user_id,

2091: 'US',
2092: 'MASTER_REF',
2093: geography_type,
2094: G_CREATED_BY_MODULE,
2095: fnd_global.user_id,
2096: sysdate,
2097: fnd_global.user_id,
2098: sysdate,
2099: fnd_global.conc_login_id

Line 2097: fnd_global.user_id,

2093: geography_type,
2094: G_CREATED_BY_MODULE,
2095: fnd_global.user_id,
2096: sysdate,
2097: fnd_global.user_id,
2098: sysdate,
2099: fnd_global.conc_login_id
2100: )
2101: --Self

Line 2099: fnd_global.conc_login_id

2095: fnd_global.user_id,
2096: sysdate,
2097: fnd_global.user_id,
2098: sysdate,
2099: fnd_global.conc_login_id
2100: )
2101: --Self
2102: INTO hz_hierarchy_nodes
2103: (

Line 2141: fnd_global.user_id,

2137: start_date,
2138: end_date,
2139: 'A',
2140: null,
2141: fnd_global.user_id,
2142: sysdate,
2143: fnd_global.user_id,
2144: sysdate,
2145: fnd_global.conc_login_id,

Line 2143: fnd_global.user_id,

2139: 'A',
2140: null,
2141: fnd_global.user_id,
2142: sysdate,
2143: fnd_global.user_id,
2144: sysdate,
2145: fnd_global.conc_login_id,
2146: p_tax_content_source
2147: )

Line 2145: fnd_global.conc_login_id,

2141: fnd_global.user_id,
2142: sysdate,
2143: fnd_global.user_id,
2144: sysdate,
2145: fnd_global.conc_login_id,
2146: p_tax_content_source
2147: )
2148: WHEN (action_type = 'UPDATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN
2149: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 2181: fnd_global.user_id,

2177: 'US',
2178: 'MASTER_REF',
2179: geography_type,
2180: G_CREATED_BY_MODULE,
2181: fnd_global.user_id,
2182: sysdate,
2183: fnd_global.user_id,
2184: sysdate,
2185: fnd_global.conc_login_id

Line 2183: fnd_global.user_id,

2179: geography_type,
2180: G_CREATED_BY_MODULE,
2181: fnd_global.user_id,
2182: sysdate,
2183: fnd_global.user_id,
2184: sysdate,
2185: fnd_global.conc_login_id
2186: )
2187: WHEN (action_type = 'UPDATE' AND geography_type IN ('COUNTY','CITY') AND geography_name IS NOT NULL) THEN

Line 2185: fnd_global.conc_login_id

2181: fnd_global.user_id,
2182: sysdate,
2183: fnd_global.user_id,
2184: sysdate,
2185: fnd_global.conc_login_id
2186: )
2187: WHEN (action_type = 'UPDATE' AND geography_type IN ('COUNTY','CITY') AND geography_name IS NOT NULL) THEN
2188: INTO HZ_GEOGRAPHY_IDENTIFIERS
2189: (

Line 2220: fnd_global.user_id,

2216: 'US',
2217: 'MASTER_REF',
2218: geography_type,
2219: G_CREATED_BY_MODULE,
2220: fnd_global.user_id,
2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.conc_login_id

Line 2222: fnd_global.user_id,

2218: geography_type,
2219: G_CREATED_BY_MODULE,
2220: fnd_global.user_id,
2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.conc_login_id
2225: )
2226: WHEN (action_type = 'CREATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN

Line 2224: fnd_global.conc_login_id

2220: fnd_global.user_id,
2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.conc_login_id
2225: )
2226: WHEN (action_type = 'CREATE' AND geography_type = 'STATE' AND geography_name1 IS NOT NULL) THEN
2227: INTO HZ_GEOGRAPHY_IDENTIFIERS
2228: (

Line 2259: fnd_global.user_id,

2255: 'US',
2256: 'MASTER_REF',
2257: geography_type,
2258: G_CREATED_BY_MODULE,
2259: fnd_global.user_id,
2260: sysdate,
2261: fnd_global.user_id,
2262: sysdate,
2263: fnd_global.conc_login_id

Line 2261: fnd_global.user_id,

2257: geography_type,
2258: G_CREATED_BY_MODULE,
2259: fnd_global.user_id,
2260: sysdate,
2261: fnd_global.user_id,
2262: sysdate,
2263: fnd_global.conc_login_id
2264: )
2265: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 2263: fnd_global.conc_login_id

2259: fnd_global.user_id,
2260: sysdate,
2261: fnd_global.user_id,
2262: sysdate,
2263: fnd_global.conc_login_id
2264: )
2265: INTO HZ_GEOGRAPHY_IDENTIFIERS
2266: (
2267: GEOGRAPHY_ID,

Line 2297: fnd_global.user_id,

2293: 'US',
2294: 'MASTER_REF',
2295: geography_type,
2296: G_CREATED_BY_MODULE,
2297: fnd_global.user_id,
2298: sysdate,
2299: fnd_global.user_id,
2300: sysdate,
2301: fnd_global.conc_login_id

Line 2299: fnd_global.user_id,

2295: geography_type,
2296: G_CREATED_BY_MODULE,
2297: fnd_global.user_id,
2298: sysdate,
2299: fnd_global.user_id,
2300: sysdate,
2301: fnd_global.conc_login_id
2302: )
2303: WHEN (action_type = 'CREATE') THEN

Line 2301: fnd_global.conc_login_id

2297: fnd_global.user_id,
2298: sysdate,
2299: fnd_global.user_id,
2300: sysdate,
2301: fnd_global.conc_login_id
2302: )
2303: WHEN (action_type = 'CREATE') THEN
2304: INTO HZ_RELATIONSHIPS
2305: (

Line 2348: fnd_global.user_id,

2344: null,
2345: start_date,
2346: end_date,
2347: 'A',
2348: fnd_global.user_id,
2349: sysdate,
2350: fnd_global.user_id,
2351: sysdate,
2352: fnd_global.conc_login_id,

Line 2350: fnd_global.user_id,

2346: end_date,
2347: 'A',
2348: fnd_global.user_id,
2349: sysdate,
2350: fnd_global.user_id,
2351: sysdate,
2352: fnd_global.conc_login_id,
2353: G_CREATED_BY_MODULE,
2354: 'MASTER_REF',

Line 2352: fnd_global.conc_login_id,

2348: fnd_global.user_id,
2349: sysdate,
2350: fnd_global.user_id,
2351: sysdate,
2352: fnd_global.conc_login_id,
2353: G_CREATED_BY_MODULE,
2354: 'MASTER_REF',
2355: 1,
2356: G_CREATED_BY_MODULE,

Line 2406: fnd_global.user_id,

2402: null,
2403: start_date,
2404: end_date,
2405: 'A',
2406: fnd_global.user_id,
2407: sysdate,
2408: fnd_global.user_id,
2409: sysdate,
2410: fnd_global.conc_login_id,

Line 2408: fnd_global.user_id,

2404: end_date,
2405: 'A',
2406: fnd_global.user_id,
2407: sysdate,
2408: fnd_global.user_id,
2409: sysdate,
2410: fnd_global.conc_login_id,
2411: G_CREATED_BY_MODULE,
2412: 'MASTER_REF',

Line 2410: fnd_global.conc_login_id,

2406: fnd_global.user_id,
2407: sysdate,
2408: fnd_global.user_id,
2409: sysdate,
2410: fnd_global.conc_login_id,
2411: G_CREATED_BY_MODULE,
2412: 'MASTER_REF',
2413: 1,
2414: G_CREATED_BY_MODULE,

Line 2460: fnd_global.user_id,

2456: start_date,
2457: end_date,
2458: 'A',
2459: hz_relationships_s.nextval,
2460: fnd_global.user_id,
2461: sysdate,
2462: fnd_global.user_id,
2463: sysdate,
2464: fnd_global.conc_login_id,

Line 2462: fnd_global.user_id,

2458: 'A',
2459: hz_relationships_s.nextval,
2460: fnd_global.user_id,
2461: sysdate,
2462: fnd_global.user_id,
2463: sysdate,
2464: fnd_global.conc_login_id,
2465: p_tax_content_source
2466: )

Line 2464: fnd_global.conc_login_id,

2460: fnd_global.user_id,
2461: sysdate,
2462: fnd_global.user_id,
2463: sysdate,
2464: fnd_global.conc_login_id,
2465: p_tax_content_source
2466: )
2467: WHEN (action_type = 'CREATE' AND geography_type = 'COUNTY') THEN
2468: INTO hz_hierarchy_nodes

Line 2507: fnd_global.user_id,

2503: start_date,
2504: end_date,
2505: 'A',
2506: null ,
2507: fnd_global.user_id,
2508: sysdate,
2509: fnd_global.user_id,
2510: sysdate,
2511: fnd_global.conc_login_id,

Line 2509: fnd_global.user_id,

2505: 'A',
2506: null ,
2507: fnd_global.user_id,
2508: sysdate,
2509: fnd_global.user_id,
2510: sysdate,
2511: fnd_global.conc_login_id,
2512: p_tax_content_source
2513: )

Line 2511: fnd_global.conc_login_id,

2507: fnd_global.user_id,
2508: sysdate,
2509: fnd_global.user_id,
2510: sysdate,
2511: fnd_global.conc_login_id,
2512: p_tax_content_source
2513: )
2514: WHEN (action_type = 'CREATE' AND geography_type = 'CITY') THEN
2515: INTO hz_hierarchy_nodes

Line 2554: fnd_global.user_id,

2550: start_date,
2551: end_date,
2552: 'A',
2553: null ,
2554: fnd_global.user_id,
2555: sysdate,
2556: fnd_global.user_id,
2557: sysdate,
2558: fnd_global.conc_login_id,

Line 2556: fnd_global.user_id,

2552: 'A',
2553: null ,
2554: fnd_global.user_id,
2555: sysdate,
2556: fnd_global.user_id,
2557: sysdate,
2558: fnd_global.conc_login_id,
2559: p_tax_content_source
2560: )

Line 2558: fnd_global.conc_login_id,

2554: fnd_global.user_id,
2555: sysdate,
2556: fnd_global.user_id,
2557: sysdate,
2558: fnd_global.conc_login_id,
2559: p_tax_content_source
2560: )
2561: INTO hz_hierarchy_nodes
2562: (

Line 2600: fnd_global.user_id,

2596: start_date,
2597: end_date,
2598: 'A',
2599: null ,
2600: fnd_global.user_id,
2601: sysdate,
2602: fnd_global.user_id,
2603: sysdate,
2604: fnd_global.conc_login_id,

Line 2602: fnd_global.user_id,

2598: 'A',
2599: null ,
2600: fnd_global.user_id,
2601: sysdate,
2602: fnd_global.user_id,
2603: sysdate,
2604: fnd_global.conc_login_id,
2605: p_tax_content_source
2606: )

Line 2604: fnd_global.conc_login_id,

2600: fnd_global.user_id,
2601: sysdate,
2602: fnd_global.user_id,
2603: sysdate,
2604: fnd_global.conc_login_id,
2605: p_tax_content_source
2606: )
2607: select geography_id,
2608: geography_name,

Line 2931: fnd_global.user_id,

2927: 'N',
2928: G_CREATED_BY_MODULE,
2929: country_code,
2930: 'PST',
2931: fnd_global.user_id,
2932: sysdate,
2933: fnd_global.user_id,
2934: sysdate,
2935: fnd_global.conc_login_id

Line 2933: fnd_global.user_id,

2929: country_code,
2930: 'PST',
2931: fnd_global.user_id,
2932: sysdate,
2933: fnd_global.user_id,
2934: sysdate,
2935: fnd_global.conc_login_id
2936: )
2937: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 2935: fnd_global.conc_login_id

2931: fnd_global.user_id,
2932: sysdate,
2933: fnd_global.user_id,
2934: sysdate,
2935: fnd_global.conc_login_id
2936: )
2937: INTO HZ_GEOGRAPHY_IDENTIFIERS
2938: (
2939: GEOGRAPHY_ID,

Line 2969: fnd_global.user_id,

2965: 'US',
2966: 'TAX',
2967: zone_geography_type,
2968: G_CREATED_BY_MODULE,
2969: fnd_global.user_id,
2970: sysdate,
2971: fnd_global.user_id,
2972: sysdate,
2973: fnd_global.conc_login_id

Line 2971: fnd_global.user_id,

2967: zone_geography_type,
2968: G_CREATED_BY_MODULE,
2969: fnd_global.user_id,
2970: sysdate,
2971: fnd_global.user_id,
2972: sysdate,
2973: fnd_global.conc_login_id
2974: )
2975: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 2973: fnd_global.conc_login_id

2969: fnd_global.user_id,
2970: sysdate,
2971: fnd_global.user_id,
2972: sysdate,
2973: fnd_global.conc_login_id
2974: )
2975: INTO HZ_GEOGRAPHY_IDENTIFIERS
2976: (
2977: GEOGRAPHY_ID,

Line 3007: fnd_global.user_id,

3003: 'US',
3004: 'TAX',
3005: zone_geography_type,
3006: G_CREATED_BY_MODULE,
3007: fnd_global.user_id,
3008: sysdate,
3009: fnd_global.user_id,
3010: sysdate,
3011: fnd_global.conc_login_id

Line 3009: fnd_global.user_id,

3005: zone_geography_type,
3006: G_CREATED_BY_MODULE,
3007: fnd_global.user_id,
3008: sysdate,
3009: fnd_global.user_id,
3010: sysdate,
3011: fnd_global.conc_login_id
3012: )
3013: INTO HZ_RELATIONSHIPS

Line 3011: fnd_global.conc_login_id

3007: fnd_global.user_id,
3008: sysdate,
3009: fnd_global.user_id,
3010: sysdate,
3011: fnd_global.conc_login_id
3012: )
3013: INTO HZ_RELATIONSHIPS
3014: (
3015: RELATIONSHIP_ID,

Line 3057: fnd_global.user_id,

3053: null,
3054: start_date,
3055: end_date,
3056: 'A',
3057: fnd_global.user_id,
3058: sysdate,
3059: fnd_global.user_id,
3060: sysdate,
3061: fnd_global.conc_login_id,

Line 3059: fnd_global.user_id,

3055: end_date,
3056: 'A',
3057: fnd_global.user_id,
3058: sysdate,
3059: fnd_global.user_id,
3060: sysdate,
3061: fnd_global.conc_login_id,
3062: G_CREATED_BY_MODULE,
3063: 'TAX',

Line 3061: fnd_global.conc_login_id,

3057: fnd_global.user_id,
3058: sysdate,
3059: fnd_global.user_id,
3060: sysdate,
3061: fnd_global.conc_login_id,
3062: G_CREATED_BY_MODULE,
3063: 'TAX',
3064: 1,
3065: G_CREATED_BY_MODULE,

Line 3115: fnd_global.user_id,

3111: null,
3112: start_date,
3113: end_date,
3114: 'A',
3115: fnd_global.user_id,
3116: sysdate,
3117: fnd_global.user_id,
3118: sysdate,
3119: fnd_global.conc_login_id,

Line 3117: fnd_global.user_id,

3113: end_date,
3114: 'A',
3115: fnd_global.user_id,
3116: sysdate,
3117: fnd_global.user_id,
3118: sysdate,
3119: fnd_global.conc_login_id,
3120: G_CREATED_BY_MODULE,
3121: 'TAX',

Line 3119: fnd_global.conc_login_id,

3115: fnd_global.user_id,
3116: sysdate,
3117: fnd_global.user_id,
3118: sysdate,
3119: fnd_global.conc_login_id,
3120: G_CREATED_BY_MODULE,
3121: 'TAX',
3122: 1,
3123: G_CREATED_BY_MODULE,

Line 3168: fnd_global.user_id,

3164: inner_city_flag,
3165: precedence_level,
3166: 'Y',
3167: 1,
3168: fnd_global.user_id,
3169: sysdate,
3170: fnd_global.user_id,
3171: sysdate,
3172: fnd_global.conc_login_id

Line 3170: fnd_global.user_id,

3166: 'Y',
3167: 1,
3168: fnd_global.user_id,
3169: sysdate,
3170: fnd_global.user_id,
3171: sysdate,
3172: fnd_global.conc_login_id
3173: )
3174: SELECT v.geography_id,

Line 3172: fnd_global.conc_login_id

3168: fnd_global.user_id,
3169: sysdate,
3170: fnd_global.user_id,
3171: sysdate,
3172: fnd_global.conc_login_id
3173: )
3174: SELECT v.geography_id,
3175: v.geography_type,
3176: v.tax_regime_code,

Line 3509: fnd_global.user_id,

3505: za.EDISC_NON_REC_TAX_CCID,
3506: za.UNEDISC_NON_REC_TAX_CCID,
3507: za.FINCHRG_NON_REC_TAX_CCID,
3508: G_CREATED_BY_MODULE,
3509: fnd_global.user_id,
3510: sysdate,
3511: fnd_global.user_id,
3512: sysdate,
3513: fnd_global.conc_login_id

Line 3511: fnd_global.user_id,

3507: za.FINCHRG_NON_REC_TAX_CCID,
3508: G_CREATED_BY_MODULE,
3509: fnd_global.user_id,
3510: sysdate,
3511: fnd_global.user_id,
3512: sysdate,
3513: fnd_global.conc_login_id
3514: FROM ZX_JURISDICTIONS_B zjb,
3515: ZX_TAXES_B ztb,

Line 3513: fnd_global.conc_login_id

3509: fnd_global.user_id,
3510: sysdate,
3511: fnd_global.user_id,
3512: sysdate,
3513: fnd_global.conc_login_id
3514: FROM ZX_JURISDICTIONS_B zjb,
3515: ZX_TAXES_B ztb,
3516: ZX_ACCOUNTS za
3517: WHERE zjb.TAX_REGIME_CODE = p_tax_regime_code

Line 3576: fnd_global.user_id,

3572: DECODE(hg.geography_element4,null,'',SUBSTR(hg.geography_element4,1,30)||'-')
3573: FROM HZ_GEOGRAPHIES hg
3574: WHERE hg.GEOGRAPHY_ID = zjb.zone_geography_id))
3575: || zjb.TAX_JURISDICTION_CODE,
3576: fnd_global.user_id,
3577: sysdate,
3578: fnd_global.user_id,
3579: sysdate,
3580: fnd_global.conc_login_id,

Line 3578: fnd_global.user_id,

3574: WHERE hg.GEOGRAPHY_ID = zjb.zone_geography_id))
3575: || zjb.TAX_JURISDICTION_CODE,
3576: fnd_global.user_id,
3577: sysdate,
3578: fnd_global.user_id,
3579: sysdate,
3580: fnd_global.conc_login_id,
3581: fl.LANGUAGE_CODE,
3582: USERENV('LANG')

Line 3580: fnd_global.conc_login_id,

3576: fnd_global.user_id,
3577: sysdate,
3578: fnd_global.user_id,
3579: sysdate,
3580: fnd_global.conc_login_id,
3581: fl.LANGUAGE_CODE,
3582: USERENV('LANG')
3583: FROM ZX_JURISDICTIONS_B zjb,
3584: FND_LANGUAGES fl

Line 3638: LAST_UPDATED_BY = fnd_global.user_id,

3634: IF (ref_ranges.hgr_row_id IS NOT NULL)
3635: THEN
3636: UPDATE hz_geography_ranges
3637: SET END_DATE = ref_ranges.end_date,
3638: LAST_UPDATED_BY = fnd_global.user_id,
3639: LAST_UPDATE_DATE = sysdate,
3640: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
3641: WHERE ROWID = ref_ranges.hgr_row_id;
3642: ELSE

Line 3640: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

3636: UPDATE hz_geography_ranges
3637: SET END_DATE = ref_ranges.end_date,
3638: LAST_UPDATED_BY = fnd_global.user_id,
3639: LAST_UPDATE_DATE = sysdate,
3640: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
3641: WHERE ROWID = ref_ranges.hgr_row_id;
3642: ELSE
3643: INSERT WHEN (NOT EXISTS
3644: (SELECT 1 FROM HZ_GEOGRAPHY_RANGES

Line 3682: fnd_global.user_id,

3678: ref_ranges.geography_type,
3679: 'TAX',
3680: ref_ranges.master_ref_geography_id,
3681: G_CREATED_BY_MODULE,
3682: fnd_global.user_id,
3683: sysdate,
3684: fnd_global.user_id,
3685: sysdate,
3686: fnd_global.conc_login_id

Line 3684: fnd_global.user_id,

3680: ref_ranges.master_ref_geography_id,
3681: G_CREATED_BY_MODULE,
3682: fnd_global.user_id,
3683: sysdate,
3684: fnd_global.user_id,
3685: sysdate,
3686: fnd_global.conc_login_id
3687: )
3688: select sysdate from dual;

Line 3686: fnd_global.conc_login_id

3682: fnd_global.user_id,
3683: sysdate,
3684: fnd_global.user_id,
3685: sysdate,
3686: fnd_global.conc_login_id
3687: )
3688: select sysdate from dual;
3689: END IF;
3690: END LOOP;

Line 3728: fnd_global.user_id,

3724: zone_geography_type,
3725: 'TAX',
3726: geography_id,
3727: G_CREATED_BY_MODULE,
3728: fnd_global.user_id,
3729: sysdate,
3730: fnd_global.user_id,
3731: sysdate,
3732: fnd_global.conc_login_id

Line 3730: fnd_global.user_id,

3726: geography_id,
3727: G_CREATED_BY_MODULE,
3728: fnd_global.user_id,
3729: sysdate,
3730: fnd_global.user_id,
3731: sysdate,
3732: fnd_global.conc_login_id
3733: )
3734: SELECT

Line 3732: fnd_global.conc_login_id

3728: fnd_global.user_id,
3729: sysdate,
3730: fnd_global.user_id,
3731: sysdate,
3732: fnd_global.conc_login_id
3733: )
3734: SELECT
3735: zone_geography_id,
3736: '0000' zip_begin,

Line 3913: fnd_global.user_id,

3909: null,
3910: G_CREATED_BY_MODULE,
3911: country_code,
3912: 'PST',
3913: fnd_global.user_id,
3914: sysdate,
3915: fnd_global.user_id,
3916: sysdate,
3917: fnd_global.conc_login_id

Line 3915: fnd_global.user_id,

3911: country_code,
3912: 'PST',
3913: fnd_global.user_id,
3914: sysdate,
3915: fnd_global.user_id,
3916: sysdate,
3917: fnd_global.conc_login_id
3918: )
3919: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 3917: fnd_global.conc_login_id

3913: fnd_global.user_id,
3914: sysdate,
3915: fnd_global.user_id,
3916: sysdate,
3917: fnd_global.conc_login_id
3918: )
3919: INTO HZ_GEOGRAPHY_IDENTIFIERS
3920: (
3921: GEOGRAPHY_ID,

Line 3951: fnd_global.user_id,

3947: 'US',
3948: 'MASTER_REF',
3949: geography_type,
3950: G_CREATED_BY_MODULE,
3951: fnd_global.user_id,
3952: sysdate,
3953: fnd_global.user_id,
3954: sysdate,
3955: fnd_global.conc_login_id

Line 3953: fnd_global.user_id,

3949: geography_type,
3950: G_CREATED_BY_MODULE,
3951: fnd_global.user_id,
3952: sysdate,
3953: fnd_global.user_id,
3954: sysdate,
3955: fnd_global.conc_login_id
3956: )
3957: INTO HZ_GEOGRAPHY_IDENTIFIERS

Line 3955: fnd_global.conc_login_id

3951: fnd_global.user_id,
3952: sysdate,
3953: fnd_global.user_id,
3954: sysdate,
3955: fnd_global.conc_login_id
3956: )
3957: INTO HZ_GEOGRAPHY_IDENTIFIERS
3958: (
3959: GEOGRAPHY_ID,

Line 3989: fnd_global.user_id,

3985: 'US',
3986: 'MASTER_REF',
3987: geography_type,
3988: G_CREATED_BY_MODULE,
3989: fnd_global.user_id,
3990: sysdate,
3991: fnd_global.user_id,
3992: sysdate,
3993: fnd_global.conc_login_id

Line 3991: fnd_global.user_id,

3987: geography_type,
3988: G_CREATED_BY_MODULE,
3989: fnd_global.user_id,
3990: sysdate,
3991: fnd_global.user_id,
3992: sysdate,
3993: fnd_global.conc_login_id
3994: )
3995: INTO HZ_RELATIONSHIPS

Line 3993: fnd_global.conc_login_id

3989: fnd_global.user_id,
3990: sysdate,
3991: fnd_global.user_id,
3992: sysdate,
3993: fnd_global.conc_login_id
3994: )
3995: INTO HZ_RELATIONSHIPS
3996: (
3997: RELATIONSHIP_ID,

Line 4039: fnd_global.user_id,

4035: null,
4036: start_date,
4037: end_date,
4038: 'A',
4039: fnd_global.user_id,
4040: sysdate,
4041: fnd_global.user_id,
4042: sysdate,
4043: fnd_global.conc_login_id,

Line 4041: fnd_global.user_id,

4037: end_date,
4038: 'A',
4039: fnd_global.user_id,
4040: sysdate,
4041: fnd_global.user_id,
4042: sysdate,
4043: fnd_global.conc_login_id,
4044: G_CREATED_BY_MODULE,
4045: 'MASTER_REF',

Line 4043: fnd_global.conc_login_id,

4039: fnd_global.user_id,
4040: sysdate,
4041: fnd_global.user_id,
4042: sysdate,
4043: fnd_global.conc_login_id,
4044: G_CREATED_BY_MODULE,
4045: 'MASTER_REF',
4046: 1,
4047: G_CREATED_BY_MODULE,

Line 4097: fnd_global.user_id,

4093: null,
4094: start_date,
4095: end_date,
4096: 'A',
4097: fnd_global.user_id,
4098: sysdate,
4099: fnd_global.user_id,
4100: sysdate,
4101: fnd_global.conc_login_id,

Line 4099: fnd_global.user_id,

4095: end_date,
4096: 'A',
4097: fnd_global.user_id,
4098: sysdate,
4099: fnd_global.user_id,
4100: sysdate,
4101: fnd_global.conc_login_id,
4102: G_CREATED_BY_MODULE,
4103: 'MASTER_REF',

Line 4101: fnd_global.conc_login_id,

4097: fnd_global.user_id,
4098: sysdate,
4099: fnd_global.user_id,
4100: sysdate,
4101: fnd_global.conc_login_id,
4102: G_CREATED_BY_MODULE,
4103: 'MASTER_REF',
4104: 1,
4105: G_CREATED_BY_MODULE,

Line 4151: fnd_global.user_id,

4147: start_date,
4148: end_date,
4149: 'A',
4150: null,
4151: fnd_global.user_id,
4152: sysdate,
4153: fnd_global.user_id,
4154: sysdate,
4155: fnd_global.conc_login_id,

Line 4153: fnd_global.user_id,

4149: 'A',
4150: null,
4151: fnd_global.user_id,
4152: sysdate,
4153: fnd_global.user_id,
4154: sysdate,
4155: fnd_global.conc_login_id,
4156: p_tax_content_source
4157: )

Line 4155: fnd_global.conc_login_id,

4151: fnd_global.user_id,
4152: sysdate,
4153: fnd_global.user_id,
4154: sysdate,
4155: fnd_global.conc_login_id,
4156: p_tax_content_source
4157: )
4158: -- City
4159: INTO hz_hierarchy_nodes

Line 4198: fnd_global.user_id,

4194: start_date,
4195: end_date,
4196: 'A',
4197: hz_relationships_s.nextval,
4198: fnd_global.user_id,
4199: sysdate,
4200: fnd_global.user_id,
4201: sysdate,
4202: fnd_global.conc_login_id,

Line 4200: fnd_global.user_id,

4196: 'A',
4197: hz_relationships_s.nextval,
4198: fnd_global.user_id,
4199: sysdate,
4200: fnd_global.user_id,
4201: sysdate,
4202: fnd_global.conc_login_id,
4203: p_tax_content_source
4204: )

Line 4202: fnd_global.conc_login_id,

4198: fnd_global.user_id,
4199: sysdate,
4200: fnd_global.user_id,
4201: sysdate,
4202: fnd_global.conc_login_id,
4203: p_tax_content_source
4204: )
4205: -- County
4206: WHEN (geography_element3_id IS NOT NULL) THEN

Line 4246: fnd_global.user_id,

4242: start_date,
4243: end_date,
4244: 'A',
4245: null ,
4246: fnd_global.user_id,
4247: sysdate,
4248: fnd_global.user_id,
4249: sysdate,
4250: fnd_global.conc_login_id,

Line 4248: fnd_global.user_id,

4244: 'A',
4245: null ,
4246: fnd_global.user_id,
4247: sysdate,
4248: fnd_global.user_id,
4249: sysdate,
4250: fnd_global.conc_login_id,
4251: p_tax_content_source
4252: )

Line 4250: fnd_global.conc_login_id,

4246: fnd_global.user_id,
4247: sysdate,
4248: fnd_global.user_id,
4249: sysdate,
4250: fnd_global.conc_login_id,
4251: p_tax_content_source
4252: )
4253: WHEN (geography_element2_id IS NOT NULL) THEN
4254: INTO hz_hierarchy_nodes

Line 4293: fnd_global.user_id,

4289: start_date,
4290: end_date,
4291: 'A',
4292: null ,
4293: fnd_global.user_id,
4294: sysdate,
4295: fnd_global.user_id,
4296: sysdate,
4297: fnd_global.conc_login_id,

Line 4295: fnd_global.user_id,

4291: 'A',
4292: null ,
4293: fnd_global.user_id,
4294: sysdate,
4295: fnd_global.user_id,
4296: sysdate,
4297: fnd_global.conc_login_id,
4298: p_tax_content_source
4299: )

Line 4297: fnd_global.conc_login_id,

4293: fnd_global.user_id,
4294: sysdate,
4295: fnd_global.user_id,
4296: sysdate,
4297: fnd_global.conc_login_id,
4298: p_tax_content_source
4299: )
4300: WHEN (geography_element1_id IS NOT NULL) THEN
4301: INTO hz_hierarchy_nodes

Line 4340: fnd_global.user_id,

4336: start_date,
4337: end_date,
4338: 'A',
4339: null ,
4340: fnd_global.user_id,
4341: sysdate,
4342: fnd_global.user_id,
4343: sysdate,
4344: fnd_global.conc_login_id,

Line 4342: fnd_global.user_id,

4338: 'A',
4339: null ,
4340: fnd_global.user_id,
4341: sysdate,
4342: fnd_global.user_id,
4343: sysdate,
4344: fnd_global.conc_login_id,
4345: p_tax_content_source
4346: )

Line 4344: fnd_global.conc_login_id,

4340: fnd_global.user_id,
4341: sysdate,
4342: fnd_global.user_id,
4343: sysdate,
4344: fnd_global.conc_login_id,
4345: p_tax_content_source
4346: )
4347:
4348: select v.zip_code geography_name,

Line 4570: fnd_global.user_id,

4566: 'US',
4567: 'MASTER_REF',
4568: geography_type,
4569: G_CREATED_BY_MODULE,
4570: fnd_global.user_id,
4571: sysdate,
4572: fnd_global.user_id,
4573: sysdate,
4574: fnd_global.conc_login_id

Line 4572: fnd_global.user_id,

4568: geography_type,
4569: G_CREATED_BY_MODULE,
4570: fnd_global.user_id,
4571: sysdate,
4572: fnd_global.user_id,
4573: sysdate,
4574: fnd_global.conc_login_id
4575: )
4576: SELECT DISTINCT inter.geography_id,

Line 4574: fnd_global.conc_login_id

4570: fnd_global.user_id,
4571: sysdate,
4572: fnd_global.user_id,
4573: sysdate,
4574: fnd_global.conc_login_id
4575: )
4576: SELECT DISTINCT inter.geography_id,
4577: inter.geography_name geography_name,
4578: 'CITY' geography_type

Line 4853: fnd_global.user_id,

4849: v.PERCENTAGE_RATE,
4850: 'Y',
4851: 'Y',
4852: G_CREATED_BY_MODULE,
4853: fnd_global.user_id,
4854: sysdate,
4855: fnd_global.user_id,
4856: sysdate,
4857: fnd_global.conc_login_id

Line 4855: fnd_global.user_id,

4851: 'Y',
4852: G_CREATED_BY_MODULE,
4853: fnd_global.user_id,
4854: sysdate,
4855: fnd_global.user_id,
4856: sysdate,
4857: fnd_global.conc_login_id
4858: )
4859: WHEN MATCHED THEN

Line 4857: fnd_global.conc_login_id

4853: fnd_global.user_id,
4854: sysdate,
4855: fnd_global.user_id,
4856: sysdate,
4857: fnd_global.conc_login_id
4858: )
4859: WHEN MATCHED THEN
4860: UPDATE SET zrbt.PERCENTAGE_RATE = v.percentage_rate,
4861: zrbt.EFFECTIVE_TO = v.effective_to,

Line 4864: zrbt.LAST_UPDATED_BY = fnd_global.user_id,

4860: UPDATE SET zrbt.PERCENTAGE_RATE = v.percentage_rate,
4861: zrbt.EFFECTIVE_TO = v.effective_to,
4862: zrbt.DEFAULT_FLG_EFFECTIVE_TO = v.effective_to,
4863: zrbt.ACTIVE_FLAG = v.active_flag,
4864: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
4865: zrbt.LAST_UPDATE_DATE = sysdate,
4866: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
4867:
4868: l_rows_processed := SQL%ROWCOUNT;

Line 4866: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;

4862: zrbt.DEFAULT_FLG_EFFECTIVE_TO = v.effective_to,
4863: zrbt.ACTIVE_FLAG = v.active_flag,
4864: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
4865: zrbt.LAST_UPDATE_DATE = sysdate,
4866: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
4867:
4868: l_rows_processed := SQL%ROWCOUNT;
4869:
4870: -- added this to ensure that when we have two rate records with same effectivity, then

Line 5030: fnd_global.user_id,

5026: v.PERCENTAGE_RATE,
5027: 'Y',
5028: 'Y',
5029: G_CREATED_BY_MODULE,
5030: fnd_global.user_id,
5031: sysdate,
5032: fnd_global.user_id,
5033: sysdate,
5034: fnd_global.conc_login_id

Line 5032: fnd_global.user_id,

5028: 'Y',
5029: G_CREATED_BY_MODULE,
5030: fnd_global.user_id,
5031: sysdate,
5032: fnd_global.user_id,
5033: sysdate,
5034: fnd_global.conc_login_id
5035: )
5036: WHEN MATCHED THEN

Line 5034: fnd_global.conc_login_id

5030: fnd_global.user_id,
5031: sysdate,
5032: fnd_global.user_id,
5033: sysdate,
5034: fnd_global.conc_login_id
5035: )
5036: WHEN MATCHED THEN
5037: UPDATE SET zrbt.PERCENTAGE_RATE = v.percentage_rate,
5038: zrbt.EFFECTIVE_TO = v.effective_to,

Line 5040: zrbt.LAST_UPDATED_BY = fnd_global.user_id,

5036: WHEN MATCHED THEN
5037: UPDATE SET zrbt.PERCENTAGE_RATE = v.percentage_rate,
5038: zrbt.EFFECTIVE_TO = v.effective_to,
5039: zrbt.DEFAULT_FLG_EFFECTIVE_TO = v.effective_to,
5040: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
5041: zrbt.LAST_UPDATE_DATE = sysdate,
5042: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5043:
5044: l_rows_processed := SQL%ROWCOUNT;

Line 5042: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;

5038: zrbt.EFFECTIVE_TO = v.effective_to,
5039: zrbt.DEFAULT_FLG_EFFECTIVE_TO = v.effective_to,
5040: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
5041: zrbt.LAST_UPDATE_DATE = sysdate,
5042: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5043:
5044: l_rows_processed := SQL%ROWCOUNT;
5045:
5046: -- Create rates with NULL Jurisdiction codes

Line 5096: fnd_global.user_id,

5092: 0,
5093: 'Y',
5094: 'Y',
5095: G_CREATED_BY_MODULE,
5096: fnd_global.user_id,
5097: sysdate,
5098: fnd_global.user_id,
5099: sysdate,
5100: fnd_global.conc_login_id

Line 5098: fnd_global.user_id,

5094: 'Y',
5095: G_CREATED_BY_MODULE,
5096: fnd_global.user_id,
5097: sysdate,
5098: fnd_global.user_id,
5099: sysdate,
5100: fnd_global.conc_login_id
5101: )
5102: SELECT tax.TAX_REGIME_CODE TAX_REGIME_CODE,

Line 5100: fnd_global.conc_login_id

5096: fnd_global.user_id,
5097: sysdate,
5098: fnd_global.user_id,
5099: sysdate,
5100: fnd_global.conc_login_id
5101: )
5102: SELECT tax.TAX_REGIME_CODE TAX_REGIME_CODE,
5103: tax.TAX TAX,
5104: tax.EFFECTIVE_FROM EFFECTIVE_FROM

Line 5163: fnd_global.user_id,

5159: za.EDISC_NON_REC_TAX_CCID,
5160: za.UNEDISC_NON_REC_TAX_CCID,
5161: za.FINCHRG_NON_REC_TAX_CCID,
5162: G_CREATED_BY_MODULE,
5163: fnd_global.user_id,
5164: sysdate,
5165: fnd_global.user_id,
5166: sysdate,
5167: fnd_global.conc_login_id

Line 5165: fnd_global.user_id,

5161: za.FINCHRG_NON_REC_TAX_CCID,
5162: G_CREATED_BY_MODULE,
5163: fnd_global.user_id,
5164: sysdate,
5165: fnd_global.user_id,
5166: sysdate,
5167: fnd_global.conc_login_id
5168: FROM ZX_RATES_B zrb,
5169: ZX_JURISDICTIONS_B zjb,

Line 5167: fnd_global.conc_login_id

5163: fnd_global.user_id,
5164: sysdate,
5165: fnd_global.user_id,
5166: sysdate,
5167: fnd_global.conc_login_id
5168: FROM ZX_RATES_B zrb,
5169: ZX_JURISDICTIONS_B zjb,
5170: ZX_ACCOUNTS za
5171: WHERE zrb.TAX_REGIME_CODE = p_tax_regime_code

Line 5198: fnd_global.user_id,

5194: SOURCE_LANG
5195: )
5196: SELECT zrb.TAX_RATE_ID,
5197: zrb.TAX_RATE_CODE,
5198: fnd_global.user_id,
5199: sysdate,
5200: fnd_global.user_id,
5201: sysdate,
5202: fnd_global.conc_login_id,

Line 5200: fnd_global.user_id,

5196: SELECT zrb.TAX_RATE_ID,
5197: zrb.TAX_RATE_CODE,
5198: fnd_global.user_id,
5199: sysdate,
5200: fnd_global.user_id,
5201: sysdate,
5202: fnd_global.conc_login_id,
5203: fl.LANGUAGE_CODE,
5204: USERENV('LANG')

Line 5202: fnd_global.conc_login_id,

5198: fnd_global.user_id,
5199: sysdate,
5200: fnd_global.user_id,
5201: sysdate,
5202: fnd_global.conc_login_id,
5203: fl.LANGUAGE_CODE,
5204: USERENV('LANG')
5205: FROM ZX_RATES_B zrb,
5206: FND_LANGUAGES fl

Line 5693: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID,

5689: COUNTRY_CODE = l_country_code,
5690: VERSION_LOADED = TO_CHAR(l_last_run_version),
5691: CONTENT_FILE_LOCATION = l_file_location,
5692: CONTENT_FILE_NAME = l_file_name,
5693: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID,
5694: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
5695: PROGRAM_UPDATE_DATE = SYSDATE
5696: WHERE PROVIDER_ID = p_tax_content_source_id
5697: AND STANDARD_REGIME_CODE = p_tax_regime_code;

Line 5694: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,

5690: VERSION_LOADED = TO_CHAR(l_last_run_version),
5691: CONTENT_FILE_LOCATION = l_file_location,
5692: CONTENT_FILE_NAME = l_file_name,
5693: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID,
5694: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
5695: PROGRAM_UPDATE_DATE = SYSDATE
5696: WHERE PROVIDER_ID = p_tax_content_source_id
5697: AND STANDARD_REGIME_CODE = p_tax_regime_code;
5698:

Line 5737: FND_GLOBAL.CONC_PROGRAM_ID,

5733: '0',
5734: 'LOADER',
5735: l_file_location,
5736: l_file_name,
5737: FND_GLOBAL.CONC_PROGRAM_ID,
5738: FND_GLOBAL.PROG_APPL_ID,
5739: SYSDATE
5740: );
5741: ELSIF (SQL%ROWCOUNT <> 1)

Line 5738: FND_GLOBAL.PROG_APPL_ID,

5734: 'LOADER',
5735: l_file_location,
5736: l_file_name,
5737: FND_GLOBAL.CONC_PROGRAM_ID,
5738: FND_GLOBAL.PROG_APPL_ID,
5739: SYSDATE
5740: );
5741: ELSIF (SQL%ROWCOUNT <> 1)
5742: THEN