DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PKG dependencies on PA_PROJECT_PARTIES_S

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 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: PROJECT_ROLE_ID = X_PROJECT_ROLE_ID, --Bug 13446954
177: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
178: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
179: SCHEDULED_FLAG = X_SCHEDULED_FLAG,