APPS.PV_GE_PTNR_RESPS_PKG dependencies on PV_GE_PTNR_RESPS

Line 1: PACKAGE BODY PV_Ge_Ptnr_Resps_PKG as

1: PACKAGE BODY PV_Ge_Ptnr_Resps_PKG as
2: /* $Header: pvxtgprb.pls 115.2 2003/11/18 22:51:17 ktsao noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_Ge_Ptnr_Resps_PKG

2: /* $Header: pvxtgprb.pls 115.2 2003/11/18 22:51:17 ktsao noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_Ge_Ptnr_Resps_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Ge_Ptnr_Resps_PKG';

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

Line 67: INSERT INTO pv_ge_ptnr_resps(

63:
64: px_object_version_number := nvl(px_object_version_number, 1);
65:
66:
67: INSERT INTO pv_ge_ptnr_resps(
68: ptnr_resp_id,
69: partner_id,
70: user_role_code,
71: program_id,

Line 128: Update pv_ge_ptnr_resps

124: p_last_update_login NUMBER)
125:
126: IS
127: BEGIN
128: Update pv_ge_ptnr_resps
129: SET
130: ptnr_resp_id = DECODE( p_ptnr_resp_id, null, ptnr_resp_id, FND_API.G_MISS_NUM, null, p_ptnr_resp_id),
131: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
132: user_role_code = DECODE( p_user_role_code, null, user_role_code, FND_API.g_miss_char, null, p_user_role_code),

Line 172: DELETE FROM pv_ge_ptnr_resps

168: p_ptnr_resp_id NUMBER,
169: p_object_version_number NUMBER)
170: IS
171: BEGIN
172: DELETE FROM pv_ge_ptnr_resps
173: WHERE ptnr_resp_id = p_ptnr_resp_id
174: AND object_version_number = p_object_version_number;
175: If (SQL%NOTFOUND) then
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 202: FROM pv_ge_ptnr_resps

198: p_object_version_number NUMBER)
199: IS
200: CURSOR C IS
201: SELECT *
202: FROM pv_ge_ptnr_resps
203: WHERE ptnr_resp_id = p_ptnr_resp_id
204: AND object_version_number = p_object_version_number
205: FOR UPDATE OF ptnr_resp_id NOWAIT;
206: Recinfo C%ROWTYPE;

Line 221: END PV_Ge_Ptnr_Resps_PKG;

217: END Lock_Row;
218:
219:
220:
221: END PV_Ge_Ptnr_Resps_PKG;