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_PREFERENCE_PUB dependencies on HZ_PARTY_PREFERENCES

Line 47: FROM HZ_PARTY_PREFERENCES

43: end if;
44:
45: SELECT 1
46: INTO l_dummy
47: FROM HZ_PARTY_PREFERENCES
48: WHERE CATEGORY = p_category
49: AND PREFERENCE_CODE = p_preference_code
50: AND PARTY_ID = p_party_id
51: AND VALUE_VARCHAR2 = p_value_varchar2_o

Line 100: FROM HZ_PARTY_PREFERENCES

96: end if;
97:
98: SELECT 1
99: INTO l_dummy
100: FROM HZ_PARTY_PREFERENCES
101: WHERE CATEGORY = p_category
102: AND PREFERENCE_CODE = p_preference_code
103: AND PARTY_ID = p_party_id
104: AND ROWNUM = 1;

Line 321: select hz_party_preferences_s.nextval into l_party_preference_id from dual;

317: , p_value_date) = 'N')
318: THEN
319: -- the current preference value does not exist, so create
320: -- generate the party preference id from sequence
321: select hz_party_preferences_s.nextval into l_party_preference_id from dual;
322:
323: -- record the party_preference_id for integration service to call populate function
324: G_PPREF_ID := l_party_preference_id;
325:

Line 327: HZ_PARTY_PREFERENCES_PKG.insert_row

323: -- record the party_preference_id for integration service to call populate function
324: G_PPREF_ID := l_party_preference_id;
325:
326: -- call table handler to insert preference record
327: HZ_PARTY_PREFERENCES_PKG.insert_row
328: (X_ROWID => l_rowid,
329: X_PARTY_PREFERENCE_ID => l_party_preference_id,
330: X_PARTY_ID => p_party_id,
331: X_MODULE => p_module,

Line 538: from hz_party_preferences

534: -- first we have to identify which record should
535: -- be updated based on what value was passed.
536: select party_preference_id, object_version_number
537: into l_party_preference_id, o_object_version_number
538: from hz_party_preferences
539: where party_id = p_party_id
540: and category = p_category
541: and preference_code = p_preference_code
542: for update nowait;

Line 548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');

544: -- check if the object_version_numbers match
545: if o_object_version_number <> p_object_version_number
546: then
547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_ERROR;
551: end if;
552: l_object_version_number := o_object_version_number + 1;

Line 556: HZ_PARTY_PREFERENCES_PKG.update_row

552: l_object_version_number := o_object_version_number + 1;
553:
554: -- now call the update table handler to
555: -- update the record
556: HZ_PARTY_PREFERENCES_PKG.update_row
557: (X_PARTY_PREFERENCE_ID => l_party_preference_id
558: ,X_PARTY_ID => p_party_id
559: ,X_MODULE => p_module
560: ,X_CATEGORY => p_category

Line 618: from hz_party_preferences

614: p_value_varchar2 IS NOT NULL
615: then
616: select party_preference_id, object_version_number
617: into l_party_preference_id, o_object_version_number
618: from hz_party_preferences
619: where party_id = p_party_id
620: and category = p_category
621: and preference_code = p_preference_code
622: and value_varchar2 = p_value_varchar2

Line 629: from hz_party_preferences

625: p_value_number IS NOT NULL
626: then
627: select party_preference_id, object_version_number
628: into l_party_preference_id, o_object_version_number
629: from hz_party_preferences
630: where party_id = p_party_id
631: and category = p_category
632: and preference_code = p_preference_code
633: and value_number = p_value_number

Line 640: from hz_party_preferences

636: p_value_date IS NOT NULL
637: then
638: select party_preference_id, object_version_number
639: into l_party_preference_id, o_object_version_number
640: from hz_party_preferences
641: where party_id = p_party_id
642: and category = p_category
643: and preference_code = p_preference_code
644: and value_date = p_value_date

Line 652: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');

648: -- check if the object_version_numbers match
649: if o_object_version_number <> p_object_version_number
650: then
651: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
652: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_PREFERENCES');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: end if;
656: l_object_version_number := o_object_version_number + 1;

Line 660: HZ_PARTY_PREFERENCES_PKG.update_row

656: l_object_version_number := o_object_version_number + 1;
657:
658: -- now call the update table handler to
659: -- update the record
660: HZ_PARTY_PREFERENCES_PKG.update_row
661: (X_PARTY_PREFERENCE_ID => l_party_preference_id
662: ,X_PARTY_ID => p_party_id
663: ,X_MODULE => p_module
664: ,X_CATEGORY => p_category

Line 700: HZ_POPULATE_BOT_PKG.pop_hz_party_preferences(

696: ELSE
697: l_op := 'I';
698: l_ppref_id := G_PPREF_ID;
699: END IF;
700: HZ_POPULATE_BOT_PKG.pop_hz_party_preferences(
701: p_operation => l_op,
702: p_party_preference_id => l_ppref_id);
703: END IF;
704: END IF;

Line 808: DELETE FROM hz_party_preferences

804: p_value_number IS NULL) AND
805: (p_value_date = FND_API.G_MISS_DATE OR
806: p_value_date IS NULL)
807: then
808: DELETE FROM hz_party_preferences
809: WHERE party_id = p_party_id
810: AND category = p_category
811: AND preference_code = p_preference_code;
812:

Line 826: DELETE FROM hz_party_preferences

822: p_value_number IS NULL) AND
823: (p_value_date = FND_API.G_MISS_DATE OR
824: p_value_date IS NULL)
825: then
826: DELETE FROM hz_party_preferences
827: WHERE party_id = p_party_id
828: AND category = p_category
829: AND preference_code = p_preference_code
830: AND value_varchar2 = p_value_varchar2

Line 846: DELETE FROM hz_party_preferences

842: p_value_number IS NOT NULL) AND
843: (p_value_date = FND_API.G_MISS_DATE OR
844: p_value_date IS NULL)
845: then
846: DELETE FROM hz_party_preferences
847: WHERE party_id = p_party_id
848: AND category = p_category
849: AND preference_code = p_preference_code
850: AND value_number = p_value_number

Line 860: DELETE FROM hz_party_preferences

856: p_value_number IS NULL) AND
857: (p_value_date <> FND_API.G_MISS_DATE AND
858: p_value_date IS NOT NULL)
859: then
860: DELETE FROM hz_party_preferences
861: WHERE party_id = p_party_id
862: AND category = p_category
863: AND preference_code = p_preference_code
864: AND value_date = p_value_date

Line 939: FROM HZ_PARTY_PREFERENCES

935: x_return_status := l_return_status;
936:
937: OPEN x_preference_value FOR
938: SELECT *
939: FROM HZ_PARTY_PREFERENCES
940: WHERE CATEGORY = p_category
941: AND PREFERENCE_CODE = p_preference_code
942: AND PARTY_ID = p_party_id;
943:

Line 988: FROM HZ_PARTY_PREFERENCES

984: ) RETURN VARCHAR2
985: AS
986: CURSOR c_pref(pty NUMBER, cat VARCHAR2, pref VARCHAR2) IS
987: SELECT VALUE_VARCHAR2
988: FROM HZ_PARTY_PREFERENCES
989: WHERE CATEGORY = cat
990: AND PREFERENCE_CODE = pref
991: AND PARTY_ID = pty
992: AND VALUE_VARCHAR2 is not null;

Line 1047: FROM HZ_PARTY_PREFERENCES

1043: ) RETURN NUMBER
1044: AS
1045: CURSOR c_pref(pty NUMBER, cat VARCHAR2, pref VARCHAR2) IS
1046: SELECT VALUE_NUMBER
1047: FROM HZ_PARTY_PREFERENCES
1048: WHERE CATEGORY = cat
1049: AND PREFERENCE_CODE = pref
1050: AND PARTY_ID = pty
1051: AND VALUE_NUMBER is not null;

Line 1105: FROM HZ_PARTY_PREFERENCES

1101: ) RETURN DATE
1102: AS
1103: CURSOR c_pref(pty NUMBER, cat VARCHAR2, pref VARCHAR2) IS
1104: SELECT VALUE_DATE
1105: FROM HZ_PARTY_PREFERENCES
1106: WHERE CATEGORY = cat
1107: AND PREFERENCE_CODE = pref
1108: AND PARTY_ID = pty
1109: AND VALUE_DATE is not null;

Line 1182: FROM HZ_PARTY_PREFERENCES

1178: end if;
1179:
1180: SELECT 1
1181: INTO l_dummy
1182: FROM HZ_PARTY_PREFERENCES
1183: WHERE CATEGORY = p_category
1184: AND PREFERENCE_CODE = p_preference_code
1185: AND PARTY_ID = p_party_id
1186: AND VALUE_NUMBER = p_value_number

Line 1236: FROM HZ_PARTY_PREFERENCES

1232: end if;
1233:
1234: SELECT 1
1235: INTO l_dummy
1236: FROM HZ_PARTY_PREFERENCES
1237: WHERE CATEGORY = p_category
1238: AND PREFERENCE_CODE = p_preference_code
1239: AND PARTY_ID = p_party_id
1240: AND VALUE_DATE = p_value_date