APPS.AMS_PARTYIMPORT_PVT dependencies on AMS_PARTY_SOURCES

Line 105: SELECT ams_party_sources_s.NEXTVAL

101: l_party_rec Party_Rec_Type := p_party_rec;
102: l_dummy NUMBER; -- Capture the exit condition for ID existence loop.
103:
104: CURSOR c_seq IS
105: SELECT ams_party_sources_s.NEXTVAL
106: FROM dual;
107:
108: CURSOR c_id_exists (x_id IN NUMBER) IS
109: SELECT 1

Line 112: FROM ams_party_sources

108: CURSOR c_id_exists (x_id IN NUMBER) IS
109: SELECT 1
110: FROM dual
111: WHERE EXISTS (SELECT 1
112: FROM ams_party_sources
113: WHERE party_sources_id = x_id);
114: BEGIN
115: --------------------- initialize -----------------------
116: SAVEPOINT Create_Party;

Line 195: INSERT INTO ams_party_sources (

191:
192: AMS_Utility_PVT.debug_message (l_full_name || ': Insert');
193: END IF;
194:
195: INSERT INTO ams_party_sources (
196: party_sources_id,
197: party_id,
198: import_source_line_id,
199: object_version_number,

Line 833: DELETE FROM ams_party_sources

829:
830: x_return_status := FND_API.g_ret_sts_success;
831:
832: ------------------------ delete ------------------------
833: DELETE FROM ams_party_sources
834: WHERE party_sources_id = p_party_sources_id
835: AND object_version_number = p_object_version;
836:
837: IF (SQL%NOTFOUND) THEN

Line 931: FROM ams_party_sources

927: -- and perform comparison in the body and raise the
928: -- exception there.
929: CURSOR c_lock_req IS
930: SELECT object_version_number
931: FROM ams_party_sources
932: WHERE party_sources_id = p_party_sources_id
933: AND object_version_number = p_object_version
934: FOR UPDATE NOWAIT;
935: BEGIN

Line 1114: UPDATE ams_party_sources

1110: END IF;
1111: END IF;
1112:
1113: -------------------------- update --------------------
1114: UPDATE ams_party_sources
1115: SET
1116: party_sources_id = l_party_rec.party_sources_id,
1117: party_id = l_party_rec.party_id,
1118: import_source_line_id = l_party_rec.import_source_line_id,

Line 1995: FROM ams_party_sources

1991: )
1992: IS
1993: CURSOR c_party IS
1994: SELECT *
1995: FROM ams_party_sources
1996: WHERE party_sources_id = p_party_rec.party_sources_id;
1997:
1998: l_party_rec c_party%ROWTYPE;
1999: BEGIN

Line 3435: 'ams_party_sources',

3431: IF p_validation_mode = JTF_PLSQL_API.g_create
3432: AND p_party_rec.party_sources_id IS NOT NULL
3433: THEN
3434: IF AMS_Utility_PVT.check_uniqueness (
3435: 'ams_party_sources',
3436: 'party_sources_id = ' || p_party_rec.party_sources_id
3437: ) = FND_API.g_false
3438: THEN
3439: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3824: l_party_sources_rec Party_Rec_Type := NULL; -- PL/SQL record representing AMS_PARTY_SOURCES

3820: L_KEY_ID_COLUMN CONSTANT VARCHAR2(30) := 'IMPORT_SOURCE_LINE_ID';
3821:
3822: l_return_status VARCHAR2(1);
3823:
3824: l_party_sources_rec Party_Rec_Type := NULL; -- PL/SQL record representing AMS_PARTY_SOURCES
3825: l_party_sources_id NUMBER;
3826: l_person_rec HZ_Party_V2Pub.person_rec_type;
3827: l_party_id NUMBER;
3828: l_party_number VARCHAR2(30);