APPS.PV_PRGM_PTR_TYPES_PKG dependencies on PV_PROGRAM_PARTNER_TYPES

Line 59: INSERT INTO PV_PROGRAM_PARTNER_TYPES(

55: IS
56:
57: BEGIN
58:
59: INSERT INTO PV_PROGRAM_PARTNER_TYPES(
60: program_partner_types_id
61: ,PROGRAM_TYPE_ID
62: ,partner_type
63: ,last_update_date

Line 110: UPDATE PV_PROGRAM_PARTNER_TYPES

106: IS
107:
108: BEGIN
109:
110: UPDATE PV_PROGRAM_PARTNER_TYPES
111: SET
112: program_partner_types_id = DECODE( p_program_partner_types_id, NULL, program_partner_types_id, FND_API.g_miss_num, NULL, p_program_partner_types_id)
113: ,PROGRAM_TYPE_ID = DECODE( p_PROGRAM_TYPE_ID, NULL, PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
114: ,partner_type = DECODE( p_partner_type, NULL, partner_type, FND_API.g_miss_char, NULL, p_partner_type)

Line 154: DELETE FROM PV_PROGRAM_PARTNER_TYPES

150: IS
151:
152: BEGIN
153:
154: DELETE FROM PV_PROGRAM_PARTNER_TYPES
155: WHERE program_partner_types_id = p_program_partner_types_id
156: AND object_version_number = p_object_version_number;
157:
158: IF (SQL%NOTFOUND) THEN

Line 197: FROM PV_PROGRAM_PARTNER_TYPES

193:
194: IS
195: CURSOR C IS
196: SELECT *
197: FROM PV_PROGRAM_PARTNER_TYPES
198: WHERE PROGRAM_PARTNER_TYPES_ID = px_program_partner_types_id
199: FOR UPDATE of PROGRAM_PARTNER_TYPES_ID NOWAIT;
200: Recinfo C%ROWTYPE;
201: BEGIN