APPS.PV_PRGM_BENEFITS_PKG dependencies on PV_PROGRAM_BENEFITS

Line 6: -- PV_PROGRAM_BENEFITS_PKG

2: /* $Header: pvxtppbb.pls 115.9 2003/11/07 06:13:54 ktsao ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_PROGRAM_BENEFITS_PKG
7: -- Purpose
8: --
9: -- History
10: -- 28-FEB-2002 Jessica.Lee Created

Line 21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_PROGRAM_BENEFITS_PKG';

17: --
18: -- End of Comments
19: -- ===============================================================
20:
21: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_PROGRAM_BENEFITS_PKG';
22: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxtpbbb.pls';
23:
24:
25: -- ========================================================

Line 60: INSERT INTO PV_PROGRAM_BENEFITS(

56: IS
57:
58: BEGIN
59:
60: INSERT INTO PV_PROGRAM_BENEFITS(
61: program_benefits_id
62: ,program_id
63: ,benefit_code
64: ,benefit_id

Line 128: Update PV_PROGRAM_BENEFITS

124: )
125:
126: IS
127: BEGIN
128: Update PV_PROGRAM_BENEFITS
129: SET
130: -- program_benefits_id = DECODE( p_program_benefits_id, FND_API.g_miss_num, program_benefits_id, p_program_benefits_id)
131: -- ,program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
132: -- ,benefit_code = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)

Line 180: UPDATE PV_PROGRAM_BENEFITS

176: ,p_object_version_number NUMBER
177: )
178: IS
179: BEGIN
180: UPDATE PV_PROGRAM_BENEFITS
181: SET
182: --program_benefits_id = DECODE( p_program_benefits_id, NULL ,program_benefits_id, FND_API.g_miss_num, NULL , p_program_benefits_id)
183: delete_flag ='Y'
184: ,last_update_date = SYSDATE

Line 232: FROM PV_PROGRAM_BENEFITS

228:
229: IS
230: CURSOR C IS
231: SELECT *
232: FROM PV_PROGRAM_BENEFITS
233: WHERE PROGRAM_BENEFITS_ID = px_program_benefits_id
234: FOR UPDATE of PROGRAM_BENEFITS_ID NOWAIT;
235: Recinfo C%ROWTYPE;
236: