APPS.IGW_PROP_LOCATIONS_TBH dependencies on IGW_PROP_LOCATIONS

Line 1: package body IGW_PROP_LOCATIONS_TBH as

1: package body IGW_PROP_LOCATIONS_TBH as
2: --$Header: igwtplcb.pls 115.6 2002/11/15 00:37:45 ashkumar ship $
3: procedure INSERT_ROW (
4: X_ROWID out NOCOPY ROWID,
5: X_PROPOSAL_ID in NUMBER,

Line 12: cursor C is select ROWID from IGW_PROP_LOCATIONS

8: X_MODE in VARCHAR2 default 'R',
9: X_RETURN_STATUS OUT NOCOPY VARCHAR2
10: ) is
11:
12: cursor C is select ROWID from IGW_PROP_LOCATIONS
13: where PROPOSAL_ID = X_PROPOSAL_ID
14: and (PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID or PARTY_ID = X_PARTY_ID);
15:
16: X_LAST_UPDATE_DATE DATE;

Line 40: insert into IGW_PROP_LOCATIONS (

36: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
37: app_exception.raise_exception;
38: end if;
39:
40: insert into IGW_PROP_LOCATIONS (
41: PROP_LOCATION_ID,
42: PROPOSAL_ID,
43: PERFORMING_ORGANIZATION_ID,
44: PARTY_ID,

Line 52: IGW_PROP_LOCATIONS_S.NEXTVAL,

48: LAST_UPDATE_DATE,
49: LAST_UPDATED_BY,
50: LAST_UPDATE_LOGIN
51: ) values (
52: IGW_PROP_LOCATIONS_S.NEXTVAL,
53: X_PROPOSAL_ID,
54: X_PERFORMING_ORGANIZATION_ID,
55: X_PARTY_ID,
56: 1,

Line 73: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_LOCATIONS_TBH'

69: end if;
70: close c;
71: EXCEPTION
72: WHEN OTHERS THEN
73: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_LOCATIONS_TBH'
74: ,p_procedure_name => 'INSERT_ROW' );
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: RAISE;
77: end INSERT_ROW;

Line 97: FROM IGW_PROP_LOCATIONS

93: l_row_id ROWID := x_rowid;
94:
95: CURSOR get_row_id IS
96: SELECT rowid
97: FROM IGW_PROP_LOCATIONS
98: WHERE proposal_id = x_proposal_id
99: AND (PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID or PARTY_ID = X_PARTY_ID);
100: begin
101:

Line 128: update IGW_PROP_LOCATIONS set

124: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
125: app_exception.raise_exception;
126: end if;
127:
128: update IGW_PROP_LOCATIONS set
129: PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID,
130: PARTY_ID = X_PARTY_ID,
131: RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER + 1,
132: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 146: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_LOCATIONS_TBH'

142: X_RETURN_STATUS := 'E';
143: end if;
144: EXCEPTION
145: WHEN OTHERS THEN
146: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_LOCATIONS_TBH'
147: ,p_procedure_name => 'UPDATE_ROW' );
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
149: RAISE;
150: end UPDATE_ROW;

Line 167: FROM IGW_PROP_LOCATIONS

163: l_row_id ROWID := x_rowid;
164:
165: CURSOR get_row_id IS
166: SELECT rowid
167: FROM IGW_PROP_LOCATIONS
168: WHERE proposal_id = x_proposal_id
169: AND (PERFORMING_ORGANIZATION_ID = X_PERFORMING_ORGANIZATION_ID or PARTY_ID = X_PARTY_ID);
170:
171: begin

Line 182: delete from IGW_PROP_LOCATIONS

178: CLOSE get_row_id;
179: END IF;
180:
181:
182: delete from IGW_PROP_LOCATIONS
183: where ROWID = L_ROW_ID
184: AND RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER;
185:
186: if (sql%notfound) then

Line 194: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_LOCATIONS_TBH'

190: end if;
191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROP_LOCATIONS_TBH'
195: ,p_procedure_name => 'DELETE_ROW' );
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE;
198: end DELETE_ROW;

Line 200: end IGW_PROP_LOCATIONS_TBH;

196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: RAISE;
198: end DELETE_ROW;
199:
200: end IGW_PROP_LOCATIONS_TBH;