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.ASO_PUBLISH_MISC_INT dependencies on HZ_PARTIES

Line 7: Cursor c_hz_parties(p_party_id NUMBER) IS

3:
4:
5: GET_MESSAGE_ERROR EXCEPTION;
6:
7: Cursor c_hz_parties(p_party_id NUMBER) IS
8: SELECT Party_Name,Person_First_Name,Person_Middle_Name,Person_Last_name,party_type,Person_title
9: FROM hz_parties
10: WHERE party_id = p_party_id;
11:

Line 9: FROM hz_parties

5: GET_MESSAGE_ERROR EXCEPTION;
6:
7: Cursor c_hz_parties(p_party_id NUMBER) IS
8: SELECT Party_Name,Person_First_Name,Person_Middle_Name,Person_Last_name,party_type,Person_title
9: FROM hz_parties
10: WHERE party_id = p_party_id;
11:
12: Cursor c_quote_header (p_quote_id NUMBER) IS
13: SELECT org_id,party_id, quote_name, quote_number, quote_version, quote_password,

Line 927: from hz_relationships l,hz_parties p

923:
924:
925: Cursor c_b2b_contact(pPartyId Number) IS
926: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type
927: from hz_relationships l,hz_parties p
928: where l.party_id = pPartyId
929: and l.subject_id = p.party_id
930: and l.subject_type = 'PERSON'
931: and l.subject_table_name = 'HZ_PARTIES';

Line 931: and l.subject_table_name = 'HZ_PARTIES';

927: from hz_relationships l,hz_parties p
928: where l.party_id = pPartyId
929: and l.subject_id = p.party_id
930: and l.subject_type = 'PERSON'
931: and l.subject_table_name = 'HZ_PARTIES';
932:
933: Begin
934:
935: FOR c_quote_rec In c_quote_header(to_number(document_id)) LOOP

Line 940: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

936: l_party_id := c_quote_rec.party_id;
937: l_order_id := c_quote_rec.order_id;
938: END LOOP;
939:
940: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
941: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
942: For c_b2b_contact_rec in c_b2b_contact(l_party_id) Loop
943: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
944: End Loop;

Line 941: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then

937: l_order_id := c_quote_rec.order_id;
938: END LOOP;
939:
940: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
941: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
942: For c_b2b_contact_rec in c_b2b_contact(l_party_id) Loop
943: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
944: End Loop;
945: Else

Line 946: l_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));

942: For c_b2b_contact_rec in c_b2b_contact(l_party_id) Loop
943: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
944: End Loop;
945: Else
946: l_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));
947: End If;
948: END LOOP;
949:
950: document := l_first_name;

Line 974: from hz_relationships l,hz_parties p

970: l_order_id number;
971:
972: Cursor c_b2b_contact(pPartyId Number) IS
973: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type
974: from hz_relationships l,hz_parties p
975: where l.party_id = pPartyId
976: and l.subject_id = p.party_id
977: and l.subject_type = 'PERSON'
978: and l.subject_table_name = 'HZ_PARTIES';

Line 978: and l.subject_table_name = 'HZ_PARTIES';

974: from hz_relationships l,hz_parties p
975: where l.party_id = pPartyId
976: and l.subject_id = p.party_id
977: and l.subject_type = 'PERSON'
978: and l.subject_table_name = 'HZ_PARTIES';
979:
980: Begin
981:
982: FOR c_quote_rec In c_quote_header(to_number(document_id)) LOOP

Line 987: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

983: l_party_id := c_quote_rec.party_id;
984: l_order_id := c_quote_rec.order_id;
985: END LOOP;
986:
987: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
988: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
989: For c_b2b_contact_rec in c_b2b_contact(l_party_id) Loop
990: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
991: End Loop;

Line 988: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then

984: l_order_id := c_quote_rec.order_id;
985: END LOOP;
986:
987: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
988: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
989: For c_b2b_contact_rec in c_b2b_contact(l_party_id) Loop
990: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
991: End Loop;
992: Else

Line 993: l_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));

989: For c_b2b_contact_rec in c_b2b_contact(l_party_id) Loop
990: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
991: End Loop;
992: Else
993: l_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));
994: End If;
995: END LOOP;
996:
997: document := l_last_name;

Line 1015: l_person_title HZ_PARTIES.PERSON_TITLE%TYPE;

1011: ) IS
1012:
1013: l_party_id number;
1014: l_order_id number;
1015: l_person_title HZ_PARTIES.PERSON_TITLE%TYPE;
1016:
1017: Cursor c_b2b_contact(pPartyId Number) IS
1018: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type,p.person_title
1019: from hz_relationships l,hz_parties p

Line 1019: from hz_relationships l,hz_parties p

1015: l_person_title HZ_PARTIES.PERSON_TITLE%TYPE;
1016:
1017: Cursor c_b2b_contact(pPartyId Number) IS
1018: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type,p.person_title
1019: from hz_relationships l,hz_parties p
1020: where l.party_id = pPartyId
1021: and l.subject_id = p.party_id
1022: and l.subject_table_name = 'HZ_PARTIES'
1023: and l.subject_type = 'PERSON';

Line 1022: and l.subject_table_name = 'HZ_PARTIES'

1018: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type,p.person_title
1019: from hz_relationships l,hz_parties p
1020: where l.party_id = pPartyId
1021: and l.subject_id = p.party_id
1022: and l.subject_table_name = 'HZ_PARTIES'
1023: and l.subject_type = 'PERSON';
1024:
1025: Begin
1026:

Line 1032: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

1028: l_party_id := c_quote_rec.party_id;
1029: l_order_id := c_quote_rec.order_id;
1030: END LOOP;
1031:
1032: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
1033: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
1034: For c_b2b_contact_rec in c_b2b_contact(l_party_id) Loop
1035: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
1036: End Loop;

Line 1033: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then

1029: l_order_id := c_quote_rec.order_id;
1030: END LOOP;
1031:
1032: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
1033: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
1034: For c_b2b_contact_rec in c_b2b_contact(l_party_id) Loop
1035: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
1036: End Loop;
1037: Else

Line 1038: l_person_title := upper(rtrim(c_hz_parties_rec.person_title));

1034: For c_b2b_contact_rec in c_b2b_contact(l_party_id) Loop
1035: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
1036: End Loop;
1037: Else
1038: l_person_title := upper(rtrim(c_hz_parties_rec.person_title));
1039: End If;
1040: END LOOP;
1041:
1042: document := l_person_title;

Line 1082: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP

1078: l_PartyType Varchar2(30);
1079: l_UserType Varchar2(30) := 'B2B';
1080: BEGIN
1081:
1082: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP
1083: l_PartyType := rtrim(c_hz_parties_rec.party_type);
1084: END LOOP;
1085:
1086: If l_PartyType = 'PERSON' Then

Line 1083: l_PartyType := rtrim(c_hz_parties_rec.party_type);

1079: l_UserType Varchar2(30) := 'B2B';
1080: BEGIN
1081:
1082: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP
1083: l_PartyType := rtrim(c_hz_parties_rec.party_type);
1084: END LOOP;
1085:
1086: If l_PartyType = 'PERSON' Then
1087: l_userType := 'B2C';

Line 1337: from hz_relationships l,hz_parties p

1333: AND nvl(status,'A') = 'A';
1334:
1335: Cursor C_B2b_Contact(l_party_id Number) IS
1336: Select p.party_id Person_Party_id
1337: from hz_relationships l,hz_parties p
1338: where l.party_id = l_party_id
1339: and l.subject_id = p.party_id
1340: and l.subject_table_name = 'HZ_PARTIES'
1341: and l.subject_type = 'PERSON';

Line 1340: and l.subject_table_name = 'HZ_PARTIES'

1336: Select p.party_id Person_Party_id
1337: from hz_relationships l,hz_parties p
1338: where l.party_id = l_party_id
1339: and l.subject_id = p.party_id
1340: and l.subject_table_name = 'HZ_PARTIES'
1341: and l.subject_type = 'PERSON';
1342:
1343: BEGIN
1344: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;