APPS.PA_OBJECT_REGIONS_PKG dependencies on PA_OBJECT_REGIONS

Line 1: PACKAGE BODY PA_OBJECT_REGIONS_PKG AS

1: PACKAGE BODY PA_OBJECT_REGIONS_PKG AS
2: --$Header: PAAPORHB.pls 120.1 2005/07/01 16:58:37 appldev noship $
3:
4: procedure INSERT_ROW (
5:

Line 19: cursor C is select ROWID from PA_OBJECT_REGIONS

15: )
16: is
17: l_rowid ROWID;
18:
19: cursor C is select ROWID from PA_OBJECT_REGIONS
20: where object_ID = p_object_id
21: AND object_type = p_object_type
22: AND placeholder_reg_code = P_PLACEHOLDER_REG_CODE ;
23:

Line 26: insert into PA_OBJECT_REGIONS (

22: AND placeholder_reg_code = P_PLACEHOLDER_REG_CODE ;
23:
24: BEGIN
25:
26: insert into PA_OBJECT_REGIONS (
27: OBJECT_ID,
28: OBJECT_TYPE,
29: PLACEHOLDER_REG_CODE,
30: REPLACEMENT_REG_CODE,

Line 75: update PA_OBJECT_REGIONS set

71: )
72: is
73: begin
74:
75: update PA_OBJECT_REGIONS set
76: OBJECT_ID = p_object_id,
77: OBJECT_TYPE = p_object_type,
78: PLACEHOLDER_REG_CODE = P_PLACEHOLDER_REG_CODE,
79: REPLACEMENT_REG_CODE = P_REPLACEMENT_REG_CODE,

Line 115: DELETE FROM PA_OBJECT_REGIONS

111: is
112: Begin
113: --x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: DELETE FROM PA_OBJECT_REGIONS
116: where object_ID = p_object_id
117: AND object_type = p_object_type
118: AND PLACEHOLDER_REG_CODE = P_PLACEHOLDER_REG_CODE ;
119:

Line 127: END PA_OBJECT_REGIONS_PKG;

123: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: RAISE;
125: End DELETE_ROW;
126:
127: END PA_OBJECT_REGIONS_PKG;