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_FUZZY_PUB dependencies on HZ_PARTIES

Line 410: FROM hz_parties

406: p_is_duplicate OUT NOCOPY VARCHAR2)
407: IS
408: CURSOR C_Duplicate_Names (X_party_Name VARCHAR2) IS
409: SELECT party_id
410: FROM hz_parties
411: WHERE upper(party_name) = upper(X_party_Name);
412:
413: CURSOR C_Duplicate_Keys (X_party_Key VARCHAR2) IS
414: SELECT party_id

Line 415: FROM hz_parties

411: WHERE upper(party_name) = upper(X_party_Name);
412:
413: CURSOR C_Duplicate_Keys (X_party_Key VARCHAR2) IS
414: SELECT party_id
415: FROM hz_parties
416: WHERE customer_key = X_party_Key;
417:
418: BEGIN
419: -- if the request is not to use the keys then use match by party name

Line 601: FROM HZ_PARTIES

597: l_party_rec.PARTY_NAME,
598: l_party_rec.PARTY_TYPE,
599: l_party_rec.FIRST_NAME,
600: l_party_rec.LAST_NAME
601: FROM HZ_PARTIES
602: WHERE PARTY_ID = p_party_id;
603:
604: RETURN l_party_rec;
605:

Line 905: | update of HZ_PARTIES ,HZ_LOCATIONS tables. |

901: | |
902: | MODIFICATION HISTORY |
903: | Indrajit Sen 22-JUN-00 Created |
904: | Sisir 26-SEP-01 Bug No:1969345;Added who columns in the |
905: | update of HZ_PARTIES ,HZ_LOCATIONS tables. |
906: | Rajib R Borah 12-DEC-03 Bug 3142242.Reverted the changes done in |
907: | bug fix 1969345.Who columns should be updated|
908: | only when a business attribute is updated. |
909: +===========================================================================*/

Line 921: FROM hz_parties

917: IS
918: -- cursor to read all the party ids in the parties table.
919: CURSOR C_Party_Ids (l_party_id NUMBER) IS
920: SELECT party_id
921: FROM hz_parties
922: WHERE party_id > l_party_id
923: AND party_type in ('PERSON', 'ORGANIZATION', 'GROUP');
924:
925: -- cursor to read all the party ids in the parties table where customer_key is null.

Line 928: FROM hz_parties

924:
925: -- cursor to read all the party ids in the parties table where customer_key is null.
926: CURSOR C_Party_Ids_New_Rows (l_party_id NUMBER) IS
927: SELECT party_id
928: FROM hz_parties
929: WHERE customer_key is NULL
930: AND party_id > l_party_id
931: AND party_type in ('PERSON', 'ORGANIZATION', 'GROUP');
932:

Line 950: l_party_id HZ_PARTIES.PARTY_ID%TYPE ;

946: l_party_rec PARTY_REC_TYPE;
947: l_location_rec LOCATION_REC_TYPE;
948: l_key VARCHAR2(2000);
949: l_rec_count NUMBER := 0;
950: l_party_id HZ_PARTIES.PARTY_ID%TYPE ;
951: l_last_party_id HZ_PARTIES.PARTY_ID%TYPE := 0;
952: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE ;
953: l_last_location_id HZ_LOCATIONS.LOCATION_ID%TYPE := 0;
954: l_flag VARCHAR2(1);

Line 951: l_last_party_id HZ_PARTIES.PARTY_ID%TYPE := 0;

947: l_location_rec LOCATION_REC_TYPE;
948: l_key VARCHAR2(2000);
949: l_rec_count NUMBER := 0;
950: l_party_id HZ_PARTIES.PARTY_ID%TYPE ;
951: l_last_party_id HZ_PARTIES.PARTY_ID%TYPE := 0;
952: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE ;
953: l_last_location_id HZ_LOCATIONS.LOCATION_ID%TYPE := 0;
954: l_flag VARCHAR2(1);
955: BEGIN

Line 965: IF p_key_type = 'PARTY' -- generate keys for the hz_parties table

961: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Key type : '||p_key_type);
962: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Only new rows : '||p_new_rows);
963: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
964:
965: IF p_key_type = 'PARTY' -- generate keys for the hz_parties table
966: THEN
967: IF p_new_rows = 'Y'
968: THEN
969: LOOP

Line 999: UPDATE HZ_PARTIES

995: p_postal_code => NULL,
996: p_first_name => l_party_rec.first_name,
997: p_last_name => l_party_rec.last_name);
998: -- update the parties record with the new key
999: UPDATE HZ_PARTIES
1000: SET customer_key = l_key/*Bug 3142242
1001: ,LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1002: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
1003: PROGRAM_APPLICATION_ID=HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 1049: UPDATE HZ_PARTIES

1045: p_first_name => l_party_rec.first_name,
1046: p_last_name => l_party_rec.last_name);
1047:
1048: -- update the parties record with the new key
1049: UPDATE HZ_PARTIES
1050: SET customer_key = l_key/*Bug 3142242
1051: ,LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1052: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
1053: PROGRAM_APPLICATION_ID=HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 1230: l_party_key hz_parties.customer_key%TYPE;

1226: p_msg_data OUT NOCOPY VARCHAR2,
1227: p_party_id OUT NOCOPY NUMBER
1228: ) IS
1229:
1230: l_party_key hz_parties.customer_key%TYPE;
1231: l_party_id hz_parties.party_id%TYPE;
1232: l_party_name hz_parties.party_name%TYPE;
1233: l_subject_name hz_parties.party_name%TYPE;
1234: l_object_name hz_parties.party_name%TYPE;

Line 1231: l_party_id hz_parties.party_id%TYPE;

1227: p_party_id OUT NOCOPY NUMBER
1228: ) IS
1229:
1230: l_party_key hz_parties.customer_key%TYPE;
1231: l_party_id hz_parties.party_id%TYPE;
1232: l_party_name hz_parties.party_name%TYPE;
1233: l_subject_name hz_parties.party_name%TYPE;
1234: l_object_name hz_parties.party_name%TYPE;
1235: l_is_duplicate varchar2(10);

Line 1232: l_party_name hz_parties.party_name%TYPE;

1228: ) IS
1229:
1230: l_party_key hz_parties.customer_key%TYPE;
1231: l_party_id hz_parties.party_id%TYPE;
1232: l_party_name hz_parties.party_name%TYPE;
1233: l_subject_name hz_parties.party_name%TYPE;
1234: l_object_name hz_parties.party_name%TYPE;
1235: l_is_duplicate varchar2(10);
1236:

Line 1233: l_subject_name hz_parties.party_name%TYPE;

1229:
1230: l_party_key hz_parties.customer_key%TYPE;
1231: l_party_id hz_parties.party_id%TYPE;
1232: l_party_name hz_parties.party_name%TYPE;
1233: l_subject_name hz_parties.party_name%TYPE;
1234: l_object_name hz_parties.party_name%TYPE;
1235: l_is_duplicate varchar2(10);
1236:
1237: begin

Line 1234: l_object_name hz_parties.party_name%TYPE;

1230: l_party_key hz_parties.customer_key%TYPE;
1231: l_party_id hz_parties.party_id%TYPE;
1232: l_party_name hz_parties.party_name%TYPE;
1233: l_subject_name hz_parties.party_name%TYPE;
1234: l_object_name hz_parties.party_name%TYPE;
1235: l_is_duplicate varchar2(10);
1236:
1237: begin
1238: p_duplicate := fnd_api.g_false;

Line 1506: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,

1502: +===========================================================================*/
1503:
1504:
1505: PROCEDURE Fuzzy_Search_Party(
1506: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,
1507: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,
1508: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,
1509: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,
1510: p_party_tbl OUT NOCOPY PARTY_TBL_TYPE,

Line 1507: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,

1503:
1504:
1505: PROCEDURE Fuzzy_Search_Party(
1506: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,
1507: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,
1508: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,
1509: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,
1510: p_party_tbl OUT NOCOPY PARTY_TBL_TYPE,
1511: p_count OUT NOCOPY NUMBER) IS

Line 1508: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,

1504:
1505: PROCEDURE Fuzzy_Search_Party(
1506: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,
1507: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,
1508: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,
1509: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,
1510: p_party_tbl OUT NOCOPY PARTY_TBL_TYPE,
1511: p_count OUT NOCOPY NUMBER) IS
1512:

Line 1509: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,

1505: PROCEDURE Fuzzy_Search_Party(
1506: p_party_type IN HZ_PARTIES.PARTY_TYPE%TYPE,
1507: p_party_name IN HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,
1508: p_first_name IN HZ_PARTIES.PERSON_FIRST_NAME%TYPE DEFAULT NULL,
1509: p_last_name IN HZ_PARTIES.PERSON_LAST_NAME%TYPE DEFAULT NULL,
1510: p_party_tbl OUT NOCOPY PARTY_TBL_TYPE,
1511: p_count OUT NOCOPY NUMBER) IS
1512:
1513: l_first_name_key VARCHAR2(2000);

Line 1523: FROM hz_parties

1519:
1520: CURSOR c_org_parties (X_Party_Name_Key VARCHAR2)
1521: IS
1522: SELECT party_id
1523: FROM hz_parties
1524: WHERE customer_key like X_Party_Name_Key||'%'
1525: AND party_type = 'ORGANIZATION';
1526:
1527: CURSOR c_per_parties (X_First_Name_Key VARCHAR2, X_Last_Name_Key VARCHAR2)

Line 1530: FROM hz_parties

1526:
1527: CURSOR c_per_parties (X_First_Name_Key VARCHAR2, X_Last_Name_Key VARCHAR2)
1528: IS
1529: SELECT party_id
1530: FROM hz_parties
1531: WHERE customer_key like X_Last_Name_Key||'%'||X_First_Name_Key||'%'
1532: AND party_type = 'PERSON';
1533:
1534: begin