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.HZ_MAP_PARTY_PUB dependencies on HZ_PARTY_V2PUB

Line 110: l_organization_rec OUT NOCOPY HZ_PARTY_V2PUB.organization_rec_type

106:
107:
108: procedure do_assign_org_record(
109: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
110: l_organization_rec OUT NOCOPY HZ_PARTY_V2PUB.organization_rec_type
111: );
112:
113:
114: procedure do_assign_location_record(

Line 121: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

117: );
118:
119: procedure do_assign_credit_ratings(
120: p_interface_rec IN HZ_PARTY_INTERFACE%ROWTYPE,
121: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
122: --l_credit_ratings_rec OUT NOCOPY HZ_PARTY_INFO_PUB.CREDIT_RATINGS_REC_TYPE
123: l_credit_ratings_rec OUT NOCOPY HZ_PARTY_INFO_V2PUB.CREDIT_RATING_REC_TYPE
124: );
125:

Line 155: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

151: p_tca_value IN VARCHAR2
152: );
153:
154: PROCEDURE check_new_duns(
155: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
156: x_return_status OUT NOCOPY VARCHAR2
157: );
158:
159: /*===========================================================================+

Line 1235: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;

1231: WHERE NVL(group_id, FND_API.G_MISS_NUM) = NVL(p_group_id, FND_API.G_MISS_NUM)
1232: AND status = 'N';
1233:
1234: l_interface_rec HZ_PARTY_INTERFACE%ROWTYPE;
1235: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
1236: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
1237: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
1238:
1239: l_displayed_duns_party_id NUMBER := NULL;

Line 2057: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

2053:
2054: -- Bug 3223595 : Added new procedure check_new_duns
2055:
2056: PROCEDURE check_new_duns(
2057: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
2058: x_return_status OUT NOCOPY VARCHAR2
2059: ) IS
2060:
2061: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;

Line 2305: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;

2301: procedure do_map(
2302: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
2303: x_return_status IN OUT NOCOPY VARCHAR2
2304: ) IS
2305: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
2306: l_location_rec hz_location_v2pub.location_rec_type;
2307: --l_credit_ratings_rec hz_party_info_pub.credit_ratings_rec_type;
2308: l_credit_ratings_rec hz_party_info_v2pub.credit_rating_rec_type;
2309: --l_fin_rep_rec hz_org_info_pub.financial_reports_rec_type;

Line 2461: l_location_rec.actual_content_source := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;

2457: /*
2458: IF l_is_new_party THEN
2459: -- store actual_content_source = 'USER ENTERED'
2460: l_location_rec.location_id := NULL;
2461: l_location_rec.actual_content_source := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
2462: --MOSR Changes. Create MOSR mapping for Party_site
2463: l_location_rec.orig_system_reference := l_organization_rec.duns_number_c;
2464: store_location( l_location_rec,
2465: p_interface_rec.party_id,

Line 2702: l_organization_rec OUT NOCOPY HZ_PARTY_V2PUB.organization_rec_type

2698: +===========================================================================*/
2699:
2700: procedure do_assign_org_record(
2701: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
2702: l_organization_rec OUT NOCOPY HZ_PARTY_V2PUB.organization_rec_type
2703: ) IS
2704: BEGIN
2705:
2706: -- set default value to SIC_CODE_TYPE when purchase 'Commercial Credit Score' GDP

Line 2903: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

2899: END do_assign_location_record;
2900:
2901: procedure do_assign_credit_ratings(
2902: p_interface_rec IN HZ_PARTY_INTERFACE%ROWTYPE,
2903: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
2904: --l_credit_ratings_rec OUT NOCOPY HZ_PARTY_INFO_PUB.CREDIT_RATINGS_REC_TYPE
2905: l_credit_ratings_rec OUT NOCOPY HZ_PARTY_INFO_V2PUB.CREDIT_RATING_REC_TYPE
2906: ) IS
2907: BEGIN

Line 3225: p_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.organization_rec_type,

3221: |
3222: +===========================================================================*/
3223:
3224: procedure store_org(
3225: p_organization_rec IN OUT NOCOPY HZ_PARTY_V2PUB.organization_rec_type,
3226: x_organization_profile_id OUT NOCOPY NUMBER,
3227: x_return_status IN OUT NOCOPY VARCHAR2
3228: ) IS
3229: l_msg_count NUMBER;

Line 3277: AND actual_content_source = HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE

3273:
3274: SELECT 'Y' INTO l_ue_exist
3275: FROM hz_organization_profiles
3276: WHERE party_id = p_organization_rec.party_rec.party_id
3277: AND actual_content_source = HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE
3278: AND effective_end_date is null
3279: AND ROWNUM = 1;
3280:
3281: EXCEPTION

Line 3331: HZ_PARTY_V2PUB.create_organization(

3327: p_organization_rec.party_rec.orig_system := 'DNB';
3328: END IF;
3329: p_organization_rec.party_rec.orig_system_reference := p_organization_rec.DUNS_NUMBER_C;
3330:
3331: HZ_PARTY_V2PUB.create_organization(
3332: 'F',
3333: p_organization_rec,
3334: x_return_status,
3335: l_msg_count,

Line 3394: HZ_PARTY_V2PUB.update_organization(

3390: --p_organization_rec.party_rec.orig_system_reference := NULL;
3391: p_organization_rec.created_by_module := NULL;
3392: p_organization_rec.application_id := NULL;
3393:
3394: HZ_PARTY_V2PUB.update_organization(
3395: 'F',
3396: p_organization_rec,
3397: l_object_version_number,
3398: x_organization_profile_id,

Line 3509: -- p_code_assignment_rec.content_source_type := NVL( p_interface_rec.content_source_type, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE);

3505: p_code_assignment_rec.owner_table_name := 'HZ_PARTIES';
3506: p_code_assignment_rec.owner_table_id := p_interface_rec.party_id;
3507: p_code_assignment_rec.class_category := p_interface_rec.sic_code_type;
3508: --bug 4169070
3509: -- p_code_assignment_rec.content_source_type := NVL( p_interface_rec.content_source_type, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE);
3510: p_code_assignment_rec.actual_content_source := NVL( p_interface_rec.content_source_type, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE);
3511: p_code_assignment_rec.start_date_active := l_start_date;
3512: p_code_assignment_rec.primary_flag := 'N';
3513: p_code_assignment_rec.created_by_module := 'TCA_DNB_MAPPING';

Line 3510: p_code_assignment_rec.actual_content_source := NVL( p_interface_rec.content_source_type, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE);

3506: p_code_assignment_rec.owner_table_id := p_interface_rec.party_id;
3507: p_code_assignment_rec.class_category := p_interface_rec.sic_code_type;
3508: --bug 4169070
3509: -- p_code_assignment_rec.content_source_type := NVL( p_interface_rec.content_source_type, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE);
3510: p_code_assignment_rec.actual_content_source := NVL( p_interface_rec.content_source_type, HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE);
3511: p_code_assignment_rec.start_date_active := l_start_date;
3512: p_code_assignment_rec.primary_flag := 'N';
3513: p_code_assignment_rec.created_by_module := 'TCA_DNB_MAPPING';
3514:

Line 3605: p_interface_rec.content_source_type <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN

3601:
3602: -- Change END for bug 3397674
3603:
3604: IF p_interface_rec.sic_code1 IS NOT NULL AND
3605: p_interface_rec.content_source_type <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN
3606:
3607: p_code_assignment_rec.code_assignment_id := null;
3608: p_code_assignment_rec.class_code := p_interface_rec.sic_code1;
3609: p_code_assignment_rec.primary_flag := 'Y';

Line 3627: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;

3623: /*
3624: IF p_is_new_party AND isMixNMatchEnabled = 'N' THEN
3625:
3626: -- store content_source_type = 'USER ENTERED'
3627: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
3628: store_classification (
3629: p_code_assignment_rec => p_code_assignment_rec,
3630: x_return_status => x_return_status
3631: );

Line 3664: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;

3660: /*
3661: IF p_is_new_party AND isMixNMatchEnabled = 'N' THEN
3662:
3663: -- store content_source_type = 'USER ENTERED'
3664: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
3665: store_classification (
3666: p_code_assignment_rec => p_code_assignment_rec,
3667: x_return_status => x_return_status
3668: );

Line 3700: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;

3696: END IF;
3697: /*
3698: IF p_is_new_party AND isMixNMatchEnabled = 'N' THEN
3699: -- store content_source_type = 'USER ENTERED'
3700: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
3701: store_classification (
3702: p_code_assignment_rec => p_code_assignment_rec,
3703: x_return_status => x_return_status
3704: );

Line 3736: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;

3732: END IF;
3733: /*
3734: IF p_is_new_party AND isMixNMatchEnabled = 'N' THEN
3735: -- store content_source_type = 'USER ENTERED'
3736: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
3737: store_classification (
3738: p_code_assignment_rec => p_code_assignment_rec,
3739: x_return_status => x_return_status
3740: );

Line 3773: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;

3769: END IF;
3770: /*
3771: IF p_is_new_party AND isMixNMatchEnabled = 'N' THEN
3772: -- store content_source_type = 'USER ENTERED'
3773: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
3774: store_classification (
3775: p_code_assignment_rec => p_code_assignment_rec,
3776: x_return_status => x_return_status
3777: );

Line 3812: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;

3808: END IF;
3809: /*
3810: IF p_is_new_party AND isMixNMatchEnabled = 'N' THEN
3811: -- store content_source_type = 'USER ENTERED'
3812: p_code_assignment_rec.content_source_type := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
3813: store_classification (
3814: p_code_assignment_rec => p_code_assignment_rec,
3815: x_return_status => x_return_status
3816: );

Line 3912: --IF p_code_assignment_rec.CONTENT_SOURCE_TYPE <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN

3908:
3909: --
3910: --Code Assignment already exist. Only need to update Code Assignment
3911: --bug 4169070
3912: --IF p_code_assignment_rec.CONTENT_SOURCE_TYPE <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN
3913:
3914: --4287144
3915: --IF p_code_assignment_rec.CONTENT_SOURCE_TYPE <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN
3916: IF (l_primary_flag <> p_code_assignment_rec.primary_flag) THEN

Line 3915: --IF p_code_assignment_rec.CONTENT_SOURCE_TYPE <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN

3911: --bug 4169070
3912: --IF p_code_assignment_rec.CONTENT_SOURCE_TYPE <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN
3913:
3914: --4287144
3915: --IF p_code_assignment_rec.CONTENT_SOURCE_TYPE <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN
3916: IF (l_primary_flag <> p_code_assignment_rec.primary_flag) THEN
3917:
3918: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_CLASSIFICATION: Code Assignment already exist, code_assignment_id=' || to_char(l_code_assignment_id));
3919: l_code_assignment_rec.code_assignment_id := l_code_assignment_id;

Line 4028: IF p_create_new = TRUE or p_location_rec.actual_content_source = HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN

4024: /* update location or create party_site or (create location and party site). */
4025:
4026: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_LOCATION (+) ');
4027: -- Bug 3417357 : if p_create_new = TRUE, we need to create new location
4028: IF p_create_new = TRUE or p_location_rec.actual_content_source = HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN
4029: -- actual_content_source = "USER_ENTERED" , create new location and party site
4030: l_create := TRUE;
4031: ELSE
4032: -- actual_content_source = "DNB"

Line 4501: IF p_contact_points_rec.actual_content_source <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN

4497: )
4498: WHERE r=1;
4499: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_CONTACT_POINT: contact point exists, contact_point_id =' || to_char(p_contact_points_rec.contact_point_id));
4500:
4501: IF p_contact_points_rec.actual_content_source <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN
4502: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_CONTACT_POINT: update contact point');
4503:
4504: p_contact_points_rec.orig_system := NULL;
4505: p_contact_points_rec.orig_system_reference := l_orig_system_reference;

Line 4858: IF p_fin_rep_rec.ACTUAL_CONTENT_SOURCE <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN

4854: p_fin_rep_rec.ISSUED_PERIOD := NULL;
4855:
4856: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_FINANCIAL_REPORT: Fin report already exists, contact_point_id =' || to_char(p_fin_rep_rec.financial_report_id));
4857:
4858: IF p_fin_rep_rec.ACTUAL_CONTENT_SOURCE <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE THEN
4859: --
4860: --Fin report already exists. Update it.
4861: --
4862: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_FINANCIAL_REPORT: update financial report for DNB');

Line 6111: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;

6107: AND ssm.status = 'A'
6108: AND rownum = 1;
6109:
6110:
6111: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
6112: l_location_rec hz_location_v2pub.location_rec_type;
6113: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
6114: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;
6115: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

Line 6205: HZ_PARTY_V2PUB.create_organization(

6201: l_profile := 'N';
6202: END IF;
6203:
6204: l_organization_rec.created_by_module := 'TCA_DNB_MAPPING';
6205: HZ_PARTY_V2PUB.create_organization(
6206: 'F',
6207: l_organization_rec,
6208: x_return_status,
6209: l_msg_count,