APPS.PV_PRGM_PMT_MODE_PKG dependencies on PV_PROGRAM_PAYMENT_MODE

Line 58: INSERT INTO PV_PROGRAM_PAYMENT_MODE(

54: IS
55:
56: BEGIN
57:
58: INSERT INTO PV_PROGRAM_PAYMENT_MODE(
59: program_payment_mode_id
60: ,program_id
61: ,geo_hierarchy_id
62: ,mode_of_payment

Line 127: Update PV_PROGRAM_PAYMENT_MODE

123: IS
124:
125: BEGIN
126:
127: Update PV_PROGRAM_PAYMENT_MODE
128: SET
129: -- program_payment_mode_id = DECODE( p_program_payment_mode_id, FND_API.g_miss_num, program_payment_mode_id, p_program_payment_mode_id)
130: -- ,program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
131: -- ,geo_hierarchy_id = DECODE( p_geo_hierarchy_id, FND_API.g_miss_num, geo_hierarchy_id, p_geo_hierarchy_id)

Line 184: DELETE FROM PV_PROGRAM_PAYMENT_MODE

180: IS
181:
182: BEGIN
183:
184: DELETE FROM PV_PROGRAM_PAYMENT_MODE
185: WHERE program_payment_mode_id = p_program_payment_mode_id
186: AND object_version_number = p_object_version_number;
187:
188: IF (SQL%NOTFOUND) THEN

Line 229: FROM PV_PROGRAM_PAYMENT_MODE

225:
226: IS
227: CURSOR C IS
228: SELECT *
229: FROM PV_PROGRAM_PAYMENT_MODE
230: WHERE PROGRAM_PAYMENT_MODE_ID = px_program_payment_mode_id
231: FOR UPDATE of PROGRAM_PAYMENT_MODE_ID NOWAIT;
232: Recinfo C%ROWTYPE;
233: BEGIN