APPS.IBW_OE_PVT dependencies on IBW_GUEST_PARTY

Line 149: -- Insert record into ibw_guest_party table

145: WHERE user_name LIKE l_guest_username;
146:
147: l_start_time := sysdate;
148:
149: -- Insert record into ibw_guest_party table
150:
151: printLog('Populating ibw_guest_party_table');
152: SELECT COUNT(PERSON_PARTY_ID) --Changed by Venky
153: INTO l_guest_table_count

Line 151: printLog('Populating ibw_guest_party_table');

147: l_start_time := sysdate;
148:
149: -- Insert record into ibw_guest_party table
150:
151: printLog('Populating ibw_guest_party_table');
152: SELECT COUNT(PERSON_PARTY_ID) --Changed by Venky
153: INTO l_guest_table_count
154: FROM ibw_guest_party
155: WHERE rownum < 2;

Line 154: FROM ibw_guest_party

150:
151: printLog('Populating ibw_guest_party_table');
152: SELECT COUNT(PERSON_PARTY_ID) --Changed by Venky
153: INTO l_guest_table_count
154: FROM ibw_guest_party
155: WHERE rownum < 2;
156:
157: IF l_guest_table_count = 0
158: THEN

Line 159: INSERT INTO ibw_guest_party(CUSTOMER_ID

155: WHERE rownum < 2;
156:
157: IF l_guest_table_count = 0
158: THEN
159: INSERT INTO ibw_guest_party(CUSTOMER_ID
160: ,OBJECT_VERSION_NUMBER
161: ,PERSON_PARTY_ID
162: ,CREATED_BY
163: ,CREATION_DATE

Line 176: UPDATE ibw_guest_party

172: ,fnd_global.user_id
173: ,SYSDATE,fnd_profile.VALUE('LOGIN_ID'));
174:
175: ELSE
176: UPDATE ibw_guest_party
177: SET customer_id = l_guest_party_id
178: , person_party_id = l_guest_person_id;
179: END IF;
180: