APPS.PA_PROJECT_PARTIES_PKG dependencies on PA_PROJECT_PARTIES

Line 1: package body PA_PROJECT_PARTIES_PKG as

1: package body PA_PROJECT_PARTIES_PKG as
2: /* $Header: PARPPTBB.pls 120.1 2005/08/19 16:58:25 mwasowic noship $ */
3:
4:
5: procedure INSERT_ROW (

Line 22: cursor C is select project_party_id from PA_PROJECT_PARTIES

18: X_CREATED_BY in NUMBER,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select project_party_id from PA_PROJECT_PARTIES
23: where PROJECT_PARTY_ID = X_PROJECT_PARTY_ID ;
24: x_party c%rowtype;
25:
26: begin

Line 27: select pa_project_parties_s.nextval into x_project_party_id

23: where PROJECT_PARTY_ID = X_PROJECT_PARTY_ID ;
24: x_party c%rowtype;
25:
26: begin
27: select pa_project_parties_s.nextval into x_project_party_id
28: from dual;
29:
30: insert into PA_PROJECT_PARTIES (
31: PROJECT_PARTY_ID,

Line 30: insert into PA_PROJECT_PARTIES (

26: begin
27: select pa_project_parties_s.nextval into x_project_party_id
28: from dual;
29:
30: insert into PA_PROJECT_PARTIES (
31: PROJECT_PARTY_ID,
32: OBJECT_ID,
33: OBJECT_TYPE,
34: PROJECT_ID,

Line 80: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PKG',

76: close c;
77:
78: EXCEPTION when others then
79: rollback;
80: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PKG',
81: p_procedure_name => 'INSERT_ROW',
82: p_error_text => SUBSTRB(SQLERRM,1,240));
83: raise;
84: end INSERT_ROW;

Line 112: from PA_PROJECT_PARTIES

108: START_DATE_ACTIVE,
109: END_DATE_ACTIVE,
110: SCHEDULED_FLAG,
111: PROJECT_PARTY_ID
112: from PA_PROJECT_PARTIES
113: where PROJECT_PARTY_ID = X_PROJECT_PARTY_ID
114: for update of PROJECT_PARTY_ID nowait;
115: begin
116: for tlinfo in c1 loop

Line 160: update PA_PROJECT_PARTIES set

156: ) is
157: begin
158: x_return_status := 'S';
159: if pa_install.is_prm_licensed() <> 'Y' then
160: update PA_PROJECT_PARTIES set
161: RESOURCE_SOURCE_ID = X_RESOURCE_SOURCE_ID,
162: RESOURCE_TYPE_ID = X_RESOURCE_TYPE_ID,
163: PROJECT_ROLE_ID = X_PROJECT_ROLE_ID,
164: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 175: update PA_PROJECT_PARTIES set

171: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
172: where PROJECT_PARTY_ID = X_PROJECT_PARTY_ID
173: and record_version_number = nvl(x_record_version_number,record_version_number);
174: else
175: update PA_PROJECT_PARTIES set
176: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
177: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
178: SCHEDULED_FLAG = X_SCHEDULED_FLAG,
179: GRANT_ID = nvl(X_GRANT_ID,GRANT_ID),

Line 195: -- fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PKG');

191:
192: Exception
193: when no_data_found then
194: -- fnd_message.set_name('PA','PA_XC_RECORD_CHANGED');
195: -- fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PKG');
196: -- fnd_message.set_token('PROCEDURE_NAME','UPDATE_ROW');
197: -- fnd_msg_pub.add;
198: x_return_status := 'N';
199: -- raise;

Line 202: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PKG',

198: x_return_status := 'N';
199: -- raise;
200: when others then
201: rollback;
202: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PKG',
203: p_procedure_name => 'UPDATE_ROW',
204: p_error_text => SUBSTRB(SQLERRM,1,240));
205: raise;
206:

Line 217: delete from pa_project_parties

213: X_record_version_number in NUMBER
214: ) is
215: begin
216: if x_project_party_id is null then
217: delete from pa_project_parties
218: where project_id = x_project_id;
219: else
220: delete from PA_PROJECT_PARTIES
221: where PROJECT_PARTY_ID = X_PROJECT_PARTY_ID

Line 220: delete from PA_PROJECT_PARTIES

216: if x_project_party_id is null then
217: delete from pa_project_parties
218: where project_id = x_project_id;
219: else
220: delete from PA_PROJECT_PARTIES
221: where PROJECT_PARTY_ID = X_PROJECT_PARTY_ID
222: and record_version_number = nvl(x_record_version_number,record_version_number);
223: end if;
224:

Line 232: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PKG');

228:
229: Exception
230: when no_data_found then
231: fnd_message.set_name('PA','PA_XC_RECORD_CHANGED');
232: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PKG');
233: --fnd_message.set_token('PROCEDURE_NAME','DELETE_ROW');
234: fnd_msg_pub.add;
235: when others then
236: rollback;

Line 237: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PKG',

233: --fnd_message.set_token('PROCEDURE_NAME','DELETE_ROW');
234: fnd_msg_pub.add;
235: when others then
236: rollback;
237: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PKG',
238: p_procedure_name => 'DELETE_ROW',
239: p_error_text => SUBSTRB(SQLERRM,1,240));
240: raise;
241: end DELETE_ROW;

Line 244: end PA_PROJECT_PARTIES_PKG;

240: raise;
241: end DELETE_ROW;
242:
243:
244: end PA_PROJECT_PARTIES_PKG;