eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASSIGNMENT_UTILS dependencies on PA_PROJECT_STATUSES

Line 16: ( p_status_code IN pa_project_statuses.project_status_code%TYPE

12: --
13: li_message_level NUMBER := 1;
14:
15: PROCEDURE check_status_is_in_use
16: ( p_status_code IN pa_project_statuses.project_status_code%TYPE
17: ,x_in_use_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
18: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
19: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
20: BEGIN

Line 182: (x_starting_oa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895

178: -- This procedure returns the default assignment statuses
179: -- 17-JUL-2000 R. Krishnamurthy Created
180:
181: PROCEDURE Get_Def_Asgmt_Statuses
182: (x_starting_oa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
183: x_starting_sa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
184: x_starting_fa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
185: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
186: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 183: x_starting_sa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895

179: -- 17-JUL-2000 R. Krishnamurthy Created
180:
181: PROCEDURE Get_Def_Asgmt_Statuses
182: (x_starting_oa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
183: x_starting_sa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
184: x_starting_fa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
185: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
186: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
187:

Line 184: x_starting_fa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895

180:
181: PROCEDURE Get_Def_Asgmt_Statuses
182: (x_starting_oa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
183: x_starting_sa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
184: x_starting_fa_status OUT NOCOPY pa_project_statuses.project_status_code%TYPE, --File.Sql.39 bug 4440895
185: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
186: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
187:
188: BEGIN

Line 251: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

247: -- This function returns whether a given assignment status is
248: -- a confirmed status or not
249: -- 18-JUL-2000 R. Krishnamurthy Created
250: FUNCTION Is_Confirmed_Status
251: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
252: p_status_type IN pa_project_statuses.status_type%TYPE )
253: return VARCHAR2 IS
254: BEGIN
255: RETURN check_input_system_status (

Line 252: p_status_type IN pa_project_statuses.status_type%TYPE )

248: -- a confirmed status or not
249: -- 18-JUL-2000 R. Krishnamurthy Created
250: FUNCTION Is_Confirmed_Status
251: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
252: p_status_type IN pa_project_statuses.status_type%TYPE )
253: return VARCHAR2 IS
254: BEGIN
255: RETURN check_input_system_status (
256: p_status_code,

Line 268: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

264: -- This function returns whether a given assignment status is
265: -- a Provisional status or not
266: -- 18-JUL-2000 R. Krishnamurthy Created
267: FUNCTION Is_Provisional_Status
268: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
269: p_status_type IN pa_project_statuses.status_type%TYPE )
270: return VARCHAR2 IS
271: BEGIN
272: RETURN check_input_system_status (

Line 269: p_status_type IN pa_project_statuses.status_type%TYPE )

265: -- a Provisional status or not
266: -- 18-JUL-2000 R. Krishnamurthy Created
267: FUNCTION Is_Provisional_Status
268: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
269: p_status_type IN pa_project_statuses.status_type%TYPE )
270: return VARCHAR2 IS
271: BEGIN
272: RETURN check_input_system_status (
273: p_status_code,

Line 285: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

281: -- This function returns whether a given assignment status is
282: -- a Filled status or not
283: -- 18-JUL-2000 R. Krishnamurthy Created
284: FUNCTION Is_Asgmt_Filled
285: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
286: p_status_type IN pa_project_statuses.status_type%TYPE )
287: return VARCHAR2 IS
288: BEGIN
289: RETURN check_input_system_status (

Line 286: p_status_type IN pa_project_statuses.status_type%TYPE )

282: -- a Filled status or not
283: -- 18-JUL-2000 R. Krishnamurthy Created
284: FUNCTION Is_Asgmt_Filled
285: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
286: p_status_type IN pa_project_statuses.status_type%TYPE )
287: return VARCHAR2 IS
288: BEGIN
289: RETURN check_input_system_status (
290: p_status_code,

Line 302: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

298: -- This function returns whether a given assignment status is
299: -- an Open status or not
300: -- 18-JUL-2000 R. Krishnamurthy Created
301: FUNCTION Is_Asgmt_In_Open_Status
302: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
303: p_status_type IN pa_project_statuses.status_type%TYPE )
304: return VARCHAR2 IS
305: BEGIN
306: RETURN check_input_system_status (

Line 303: p_status_type IN pa_project_statuses.status_type%TYPE )

299: -- an Open status or not
300: -- 18-JUL-2000 R. Krishnamurthy Created
301: FUNCTION Is_Asgmt_In_Open_Status
302: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
303: p_status_type IN pa_project_statuses.status_type%TYPE )
304: return VARCHAR2 IS
305: BEGIN
306: RETURN check_input_system_status (
307: p_status_code,

Line 319: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

315: -- This function returns whether a given open assignment status is
316: -- a cancelled status or not
317: -- 18-JUL-2000 R. Krishnamurthy Created
318: FUNCTION Is_Open_Asgmt_Cancelled
319: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
320: p_status_type IN pa_project_statuses.status_type%TYPE )
321: return VARCHAR2 IS
322: BEGIN
323: RETURN check_input_system_status (

Line 320: p_status_type IN pa_project_statuses.status_type%TYPE )

316: -- a cancelled status or not
317: -- 18-JUL-2000 R. Krishnamurthy Created
318: FUNCTION Is_Open_Asgmt_Cancelled
319: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
320: p_status_type IN pa_project_statuses.status_type%TYPE )
321: return VARCHAR2 IS
322: BEGIN
323: RETURN check_input_system_status (
324: p_status_code,

Line 336: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

332: -- This function returns whether a given staffed assignment status is
333: -- a cancelled status or not
334: -- 18-JUL-2000 R. Krishnamurthy Created
335: FUNCTION Is_Staffed_Asgmt_Cancelled
336: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
337: p_status_type IN pa_project_statuses.status_type%TYPE )
338: return VARCHAR2 IS
339: BEGIN
340: RETURN check_input_system_status (

Line 337: p_status_type IN pa_project_statuses.status_type%TYPE )

333: -- a cancelled status or not
334: -- 18-JUL-2000 R. Krishnamurthy Created
335: FUNCTION Is_Staffed_Asgmt_Cancelled
336: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
337: p_status_type IN pa_project_statuses.status_type%TYPE )
338: return VARCHAR2 IS
339: BEGIN
340: RETURN check_input_system_status (
341: p_status_code,

Line 353: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,

349: -- This function returns whether a given status is
350: -- has the specified system status
351: -- 18-JUL-2000 R. Krishnamurthy Created
352: FUNCTION Check_input_system_status
353: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
354: p_status_type IN pa_project_statuses.status_type%TYPE ,
355: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)
356: RETURN VARCHAR2 IS
357: l_ret_val VARCHAR2(1);

Line 354: p_status_type IN pa_project_statuses.status_type%TYPE ,

350: -- has the specified system status
351: -- 18-JUL-2000 R. Krishnamurthy Created
352: FUNCTION Check_input_system_status
353: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
354: p_status_type IN pa_project_statuses.status_type%TYPE ,
355: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)
356: RETURN VARCHAR2 IS
357: l_ret_val VARCHAR2(1);
358: BEGIN

Line 355: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)

351: -- 18-JUL-2000 R. Krishnamurthy Created
352: FUNCTION Check_input_system_status
353: (p_status_code IN pa_project_statuses.project_status_code%TYPE ,
354: p_status_type IN pa_project_statuses.status_type%TYPE ,
355: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)
356: RETURN VARCHAR2 IS
357: l_ret_val VARCHAR2(1);
358: BEGIN
359: SELECT DECODE (project_system_status_code,

Line 362: FROM pa_project_statuses

358: BEGIN
359: SELECT DECODE (project_system_status_code,
360: p_in_system_status_code,'Y','N')
361: INTO l_ret_val
362: FROM pa_project_statuses
363: WHERE project_status_code = p_status_code
364: AND status_type = p_status_type;
365: RETURN l_ret_val;
366: EXCEPTION

Line 749: FUNCTION is_asgmt_allow_stus_ctl_check(p_asgmt_status_code IN pa_project_statuses.project_status_code%TYPE,

745:
746: END Add_Message;
747:
748:
749: FUNCTION is_asgmt_allow_stus_ctl_check(p_asgmt_status_code IN pa_project_statuses.project_status_code%TYPE,
750: p_project_id IN pa_projects_all.project_id%TYPE,
751: p_add_message IN VARCHAR2)
752: RETURN VARCHAR2 IS
753:

Line 757: pa_project_statuses ps,

753:
754: CURSOR get_status_info IS
755: SELECT proj.project_status_code, ps.project_status_name, ps2.project_system_status_code, ps2.project_status_name
756: FROM pa_projects_all proj,
757: pa_project_statuses ps,
758: pa_project_statuses ps2
759: WHERE project_id = p_project_id
760: AND proj.project_status_code = ps.project_status_code
761: AND ps2.project_status_code = p_asgmt_status_code;

Line 758: pa_project_statuses ps2

754: CURSOR get_status_info IS
755: SELECT proj.project_status_code, ps.project_status_name, ps2.project_system_status_code, ps2.project_status_name
756: FROM pa_projects_all proj,
757: pa_project_statuses ps,
758: pa_project_statuses ps2
759: WHERE project_id = p_project_id
760: AND proj.project_status_code = ps.project_status_code
761: AND ps2.project_status_code = p_asgmt_status_code;
762:

Line 763: l_project_status_code pa_project_statuses.project_status_code%TYPE;

759: WHERE project_id = p_project_id
760: AND proj.project_status_code = ps.project_status_code
761: AND ps2.project_status_code = p_asgmt_status_code;
762:
763: l_project_status_code pa_project_statuses.project_status_code%TYPE;
764: l_project_status_name pa_project_statuses.project_status_name%TYPE;
765: l_asgmt_system_status_code pa_project_statuses.project_system_status_code%TYPE;
766: l_asgmt_status_name pa_project_statuses.project_status_name%TYPE;
767: l_allow_asgmt VARCHAR2(1);

Line 764: l_project_status_name pa_project_statuses.project_status_name%TYPE;

760: AND proj.project_status_code = ps.project_status_code
761: AND ps2.project_status_code = p_asgmt_status_code;
762:
763: l_project_status_code pa_project_statuses.project_status_code%TYPE;
764: l_project_status_name pa_project_statuses.project_status_name%TYPE;
765: l_asgmt_system_status_code pa_project_statuses.project_system_status_code%TYPE;
766: l_asgmt_status_name pa_project_statuses.project_status_name%TYPE;
767: l_allow_asgmt VARCHAR2(1);
768: l_status_control_code pa_project_status_controls.action_code%TYPE;

Line 765: l_asgmt_system_status_code pa_project_statuses.project_system_status_code%TYPE;

761: AND ps2.project_status_code = p_asgmt_status_code;
762:
763: l_project_status_code pa_project_statuses.project_status_code%TYPE;
764: l_project_status_name pa_project_statuses.project_status_name%TYPE;
765: l_asgmt_system_status_code pa_project_statuses.project_system_status_code%TYPE;
766: l_asgmt_status_name pa_project_statuses.project_status_name%TYPE;
767: l_allow_asgmt VARCHAR2(1);
768: l_status_control_code pa_project_status_controls.action_code%TYPE;
769:

Line 766: l_asgmt_status_name pa_project_statuses.project_status_name%TYPE;

762:
763: l_project_status_code pa_project_statuses.project_status_code%TYPE;
764: l_project_status_name pa_project_statuses.project_status_name%TYPE;
765: l_asgmt_system_status_code pa_project_statuses.project_system_status_code%TYPE;
766: l_asgmt_status_name pa_project_statuses.project_status_name%TYPE;
767: l_allow_asgmt VARCHAR2(1);
768: l_status_control_code pa_project_status_controls.action_code%TYPE;
769:
770: BEGIN

Line 1267: pa_project_statuses ps

1263: asgn.expenditure_type,
1264: asgn.project_role_id,
1265: asgn.assignment_name
1266: from pa_project_assignments asgn,
1267: pa_project_statuses ps
1268: where asgn.project_id = p_project_id
1269: and asgn.assignment_type = 'OPEN_ASSIGNMENT'
1270: and asgn.status_code = ps.project_status_code(+)
1271: and (ps.project_system_status_code = 'OPEN_ASGMT'

Line 1288: pa_project_statuses ps,

1284: asgn.project_role_id,
1285: decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK'), --ppt.system_person_type,
1286: asgn.assignment_name
1287: from pa_project_assignments asgn,
1288: pa_project_statuses ps,
1289: per_person_type_usages_f ptuf,
1290: per_person_types ppt,
1291: per_all_assignments_f aaf,
1292: pa_resource_txn_attributes rta,

Line 1321: pa_project_statuses ps,

1317: asgn.project_role_id,
1318: ppt.system_person_type,
1319: asgn.assignment_name
1320: from pa_project_assignments asgn,
1321: pa_project_statuses ps,
1322: per_person_type_usages_f ptuf,
1323: per_person_types ppt,
1324: per_all_assignments_f aaf,
1325: pa_resource_txn_attributes rta

Line 1579: from pa_project_assignments pap, pa_project_statuses stat

1575: p_project_id IN NUMBER) RETURN NUMBER IS
1576:
1577: Cursor C_ASMT_ID IS
1578: select distinct pap.assignment_id
1579: from pa_project_assignments pap, pa_project_statuses stat
1580: where pap.resource_list_member_id = p_resource_list_member_id
1581: and pap.project_id = p_project_id
1582: and pap.STATUS_CODE = stat.PROJECT_STATUS_CODE (+)
1583: and nvl(stat.PROJECT_SYSTEM_STATUS_CODE, '-1') not in ('OPEN_ASGMT_CANCEL','STAFFED_ASGMT_CANCEL', 'OPEN_ASGMT_FILLED');

Line 1608: from pa_project_assignments pap, pa_project_statuses stat

1604: p_project_id IN NUMBER) RETURN VARCHAR2 IS
1605:
1606: Cursor C_ASMT_TYPE IS
1607: select distinct pap.assignment_type
1608: from pa_project_assignments pap, pa_project_statuses stat
1609: where pap.resource_list_member_id = p_resource_list_member_id
1610: and pap.project_id = p_project_id
1611: and pap.STATUS_CODE = stat.PROJECT_STATUS_CODE (+)
1612: and nvl(stat.PROJECT_SYSTEM_STATUS_CODE, '-1') not in ('OPEN_ASGMT_CANCEL','STAFFED_ASGMT_CANCEL', 'OPEN_ASGMT_FILLED');

Line 1799: from pa_project_assignments pap, pa_project_statuses stat

1795: RETURN DATE IS
1796: Cursor C_Team_Role_Start IS
1797:
1798: select min(pap.start_date) team_role_start
1799: from pa_project_assignments pap, pa_project_statuses stat
1800: where
1801: pap.resource_list_member_id = p_resource_list_member_id
1802: and pap.project_id = p_project_id
1803: and

Line 1826: from pa_project_assignments pap, pa_project_statuses stat

1822: FUNCTION Get_Team_Role_End(p_project_id IN NUMBER, p_resource_list_member_id IN NUMBER)
1823: RETURN DATE IS
1824: Cursor C_Team_Role_End IS
1825: select max(pap.End_date) team_role_End
1826: from pa_project_assignments pap, pa_project_statuses stat
1827: where
1828: pap.resource_list_member_id = p_resource_list_member_id
1829: and pap.project_id = p_project_id
1830: and