APPS.PV_GE_TEMP_APPROVERS_PKG dependencies on PV_GE_TEMP_APPROVERS

Line 1: PACKAGE BODY Pv_Ge_Temp_Approvers_PKG as

1: PACKAGE BODY Pv_Ge_Temp_Approvers_PKG as
2: /* $Header: pvxtptab.pls 120.1 2006/01/25 15:42:36 ktsao noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- Pv_Ge_Temp_Approvers_PKG

2: /* $Header: pvxtptab.pls 120.1 2006/01/25 15:42:36 ktsao noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- Pv_Ge_Temp_Approvers_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 67: INSERT INTO pv_ge_temp_approvers(

63:
64: px_object_version_number := nvl(px_object_version_number, 1);
65:
66:
67: INSERT INTO pv_ge_temp_approvers(
68: entity_approver_id,
69: object_version_number,
70: arc_appr_for_entity_code,
71: appr_for_entity_id,

Line 128: Update pv_ge_temp_approvers

124: p_last_update_login NUMBER)
125:
126: IS
127: BEGIN
128: Update pv_ge_temp_approvers
129: SET
130: entity_approver_id = DECODE( p_entity_approver_id, null, entity_approver_id, FND_API.G_MISS_NUM, null, p_entity_approver_id),
131: object_version_number = nvl(p_object_version_number,0) + 1 ,
132: arc_appr_for_entity_code = DECODE( p_arc_appr_for_entity_code, null, arc_appr_for_entity_code, FND_API.g_miss_char, null, p_arc_appr_for_entity_code),

Line 172: DELETE FROM pv_ge_temp_approvers

168: p_entity_approver_id NUMBER,
169: p_object_version_number NUMBER)
170: IS
171: BEGIN
172: DELETE FROM pv_ge_temp_approvers
173: WHERE entity_approver_id = p_entity_approver_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_temp_approvers

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

Line 221: END Pv_Ge_Temp_Approvers_PKG;

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