DBA Data[Home] [Help]

APPS.FND_OID_USERS dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 110: l_orig_sys_rec hz_orig_system_ref_pub.orig_sys_reference_rec_type;

106: , x_return_status out nocopy varchar2
107: ) is
108:
109: l_module_source varchar2(256);
110: l_orig_sys_rec hz_orig_system_ref_pub.orig_sys_reference_rec_type;
111: l_tca_error exception;
112: x_person_rec hz_party_v2pub.person_rec_type;
113: x_msg_count number;
114: x_msg_data varchar2(2000);

Line 1135: hz_orig_system_ref_pub.get_owner_table_id(

1131: fnd_oid_users.get_orig_system_ref(
1132: p_ldap_message => p_ldap_message,
1133: p_tag => G_PERSON,
1134: x_reference => l_orig_system_reference);
1135: hz_orig_system_ref_pub.get_owner_table_id(
1136: p_orig_system => G_FND_OID_SYNCH
1137: , p_orig_system_reference => l_orig_system_reference
1138: , p_owner_table_name => G_HZ_PARTIES
1139: , x_owner_table_id => l_owner_table_id

Line 1174: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');

1170: when l_tca_error then
1171: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1172: then
1173: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1174: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1175: end if;
1176: when others then
1177: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1178: then

Line 1247: hz_orig_system_ref_pub.get_owner_table_id(

1243: p_ldap_message => p_ldap_message,
1244: p_tag => p_contact_point_type,
1245: x_reference => l_orig_system_reference);
1246: end if;
1247: hz_orig_system_ref_pub.get_owner_table_id(
1248: p_orig_system => G_FND_OID_SYNCH,
1249: p_orig_system_reference => l_orig_system_reference,
1250: p_owner_table_name => G_HZ_CONTACT_POINTS,
1251: x_owner_table_id => l_owner_table_id,

Line 1273: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');

1269: when l_tca_error then
1270: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1271: then
1272: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1273: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1274: end if;
1275: when others then
1276: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1277: then

Line 1430: hz_orig_system_ref_pub.get_owner_table_id(

1426: fnd_oid_users.get_orig_system_ref(
1427: p_ldap_message => p_ldap_message,
1428: p_tag => G_LOCATION,
1429: x_reference => l_orig_system_reference);
1430: hz_orig_system_ref_pub.get_owner_table_id(
1431: p_orig_system => G_FND_OID_SYNCH
1432: , p_orig_system_reference => l_orig_system_reference
1433: , p_owner_table_name => G_HZ_PARTY_SITES
1434: , x_owner_table_id => l_owner_table_id

Line 1464: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');

1460: when l_tca_error then
1461: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1462: then
1463: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source
1464: , 'Error calling hz_orig_system_ref_pub.get_owner_table_id');
1465: end if;
1466: when others then
1467: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1468: then

Line 1527: l_orig_sys_rec hz_orig_system_ref_pub.orig_sys_reference_rec_type;

1523: , x_return_status out nocopy varchar2
1524: ) is
1525:
1526: l_module_source varchar2(256);
1527: l_orig_sys_rec hz_orig_system_ref_pub.orig_sys_reference_rec_type;
1528: l_orig_system_reference varchar2(2000);
1529: l_owner_table_id number;
1530: l_tca_error exception;
1531: l_debug_level number;

Line 1559: hz_orig_system_ref_pub.get_owner_table_id(

1555: l_orig_sys_rec.status := p_status;
1556: l_orig_sys_rec.start_date_active := sysdate;
1557: l_orig_sys_rec.created_by_module := G_FND_OID_SYNCH;
1558:
1559: hz_orig_system_ref_pub.get_owner_table_id(
1560: p_orig_system => G_FND_OID_SYNCH,
1561: p_orig_system_reference => l_orig_system_reference,
1562: p_owner_table_name => p_owner_table_name,
1563: x_owner_table_id => l_owner_table_id,

Line 1589: hz_orig_system_ref_pub.create_orig_system_reference(

1585: end if;
1586:
1587: else
1588:
1589: hz_orig_system_ref_pub.create_orig_system_reference(
1590: p_init_msg_list => fnd_api.G_TRUE,
1591: p_orig_sys_reference_rec => l_orig_sys_rec,
1592: x_return_status => x_return_status,
1593: x_msg_count => x_msg_count,

Line 1644: l_orig_sys_rec hz_orig_system_ref_pub.orig_sys_reference_rec_type;

1640: ) is
1641:
1642: l_module_source varchar2(256);
1643: l_orig_system_reference varchar2(2000);
1644: l_orig_sys_rec hz_orig_system_ref_pub.orig_sys_reference_rec_type;
1645: l_orig_system_ref_id number;
1646: l_object_version_number number;
1647: l_tca_error exception;
1648: x_msg_count number;

Line 1680: hz_orig_system_ref_pub.update_orig_system_reference(

1676: l_orig_sys_rec.orig_system_reference := l_orig_system_reference;
1677: l_orig_sys_rec.owner_table_name := p_owner_table_name;
1678: l_orig_sys_rec.owner_table_id := p_owner_table_id;
1679:
1680: hz_orig_system_ref_pub.update_orig_system_reference(
1681: p_init_msg_list => fnd_api.G_TRUE,
1682: p_orig_sys_reference_rec => l_orig_sys_rec,
1683: p_object_version_number => l_object_version_number,
1684: x_return_status => x_return_status,