APPS.PV_PARTNER_PGM_TYPE_PKG dependencies on PV_PARTNER_PROGRAM_TYPE_B

Line 60: INSERT INTO PV_PARTNER_PROGRAM_TYPE_B(

56: IS
57:
58: BEGIN
59:
60: INSERT INTO PV_PARTNER_PROGRAM_TYPE_B(
61: PROGRAM_TYPE_ID
62: ,active_flag
63: ,enabled_flag
64: ,object_version_number

Line 159: Update PV_PARTNER_PROGRAM_TYPE_B

155: PVX_Utility_PVT.debug_message('Within PV_PARTNER_PGM_TYPE_PKG.UPDATE_ROW API : object_version_number ' ||p_object_version_number );
156: END IF;
157:
158:
159: Update PV_PARTNER_PROGRAM_TYPE_B
160: SET
161: PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL, PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
162: ,active_flag = DECODE( p_active_flag, NULL, active_flag, FND_API.g_miss_char, NULL, p_active_flag)
163: ,enabled_flag = DECODE( p_enabled_flag, NULL, enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)

Line 233: DELETE FROM PV_PARTNER_PROGRAM_TYPE_B

229: END IF;
230: RAISE FND_API.g_exc_error;
231: END IF;
232:
233: DELETE FROM PV_PARTNER_PROGRAM_TYPE_B
234: WHERE PROGRAM_TYPE_ID = p_PROGRAM_TYPE_ID
235: AND object_version_number = p_object_version_number;
236:
237: IF (SQL%NOTFOUND) THEN

Line 277: FROM PV_PARTNER_PROGRAM_TYPE_B

273:
274: IS
275: CURSOR C IS
276: SELECT *
277: FROM PV_PARTNER_PROGRAM_TYPE_B
278: WHERE PROGRAM_TYPE_ID = px_PROGRAM_TYPE_ID
279: FOR UPDATE of PROGRAM_TYPE_ID NOWAIT;
280: Recinfo C%ROWTYPE;
281: