[Home] [Help]
2589: sysdate,
2590: fnd_global.conc_login_id
2591: )
2592: WHEN (action_type = 'CREATE') THEN
2593: INTO HZ_RELATIONSHIPS
2594: (
2595: RELATIONSHIP_ID,
2596: SUBJECT_ID,
2597: SUBJECT_TYPE,
2620: ACTUAL_CONTENT_SOURCE
2621: )
2622: VALUES
2623: (
2624: hz_relationships_s.nextval,
2625: parent_geography_id,
2626: parent_geography_type,
2627: 'HZ_GEOGRAPHIES',
2628: geography_id,
2647: 'P',
2648: null,
2649: p_tax_content_source
2650: )
2651: INTO HZ_RELATIONSHIPS
2652: (
2653: RELATIONSHIP_ID,
2654: SUBJECT_ID,
2655: SUBJECT_TYPE,
2678: ACTUAL_CONTENT_SOURCE
2679: )
2680: VALUES
2681: (
2682: hz_relationships_s.nextval,
2683: geography_id,
2684: geography_type,
2685: 'HZ_GEOGRAPHIES',
2686: parent_geography_id,
2744: '',
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,
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: (
3318: RELATIONSHIP_ID,
3319: SUBJECT_ID,
3320: SUBJECT_TYPE,
3343: ACTUAL_CONTENT_SOURCE
3344: )
3345: VALUES
3346: (
3347: hz_relationships_s.nextval,
3348: zone_geography_id,
3349: zone_geography_type,
3350: 'HZ_GEOGRAPHIES',
3351: geography_id,
3371: null,
3372: p_tax_content_source
3373: )
3374: WHEN (zone_geography_type IS NOT NULL AND zone_geography_id IS NOT NULL) THEN
3375: INTO HZ_RELATIONSHIPS
3376: (
3377: RELATIONSHIP_ID,
3378: SUBJECT_ID,
3379: SUBJECT_TYPE,
3402: ACTUAL_CONTENT_SOURCE
3403: )
3404: VALUES
3405: (
3406: hz_relationships_s.nextval,
3407: geography_id,
3408: geography_type,
3409: 'HZ_GEOGRAPHIES',
3410: zone_geography_id,
3908: (SELECT SUBSTR(hg.geography_element2_code,1,2)||'-'||
3909: DECODE(hg.geography_element3,null,'',SUBSTR(hg.geography_element3,1,30)||'-')||
3910: DECODE(hg.geography_element4,null,'',SUBSTR(hg.geography_element4,1,30)||'-')
3911: FROM hz_geographies hg_zone,
3912: hz_relationships hr,
3913: hz_geographies hg,
3914: zx_data_upload_interface zd
3915: WHERE hg_zone.GEOGRAPHY_ID = zjb.zone_geography_id
3916: AND zd.zone_geography_id = hg_zone.GEOGRAPHY_ID
4357: fnd_global.user_id,
4358: sysdate,
4359: fnd_global.conc_login_id
4360: )
4361: INTO HZ_RELATIONSHIPS
4362: (
4363: RELATIONSHIP_ID,
4364: SUBJECT_ID,
4365: SUBJECT_TYPE,
4388: ACTUAL_CONTENT_SOURCE
4389: )
4390: VALUES
4391: (
4392: hz_relationships_s.nextval,
4393: parent_geography_id,
4394: parent_geography_type,
4395: 'HZ_GEOGRAPHIES',
4396: hz_geographies_s.nextval,
4415: 'P',
4416: null,
4417: p_tax_content_source
4418: )
4419: INTO HZ_RELATIONSHIPS
4420: (
4421: RELATIONSHIP_ID,
4422: SUBJECT_ID,
4423: SUBJECT_TYPE,
4446: ACTUAL_CONTENT_SOURCE
4447: )
4448: VALUES
4449: (
4450: hz_relationships_s.nextval,
4451: hz_geographies_s.nextval,
4452: geography_type,
4453: 'HZ_GEOGRAPHIES',
4454: parent_geography_id,
4559: '',
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,
4774: WHERE v.geography_id = g.geography_id
4775: AND g.country_code = 'US'
4776: AND NOT EXISTS ( SELECT /*+ordered */'1'
4777: FROM hz_geographies g1,
4778: hz_relationships rel
4779: WHERE rel.subject_id = g.geography_id
4780: AND rel.subject_type = g.geography_type
4781: AND rel.subject_table_name = 'HZ_GEOGRAPHIES'
4782: AND rel.object_id = g1.geography_id