23: CURSOR c_resource_types_csr IS
24: SELECT
25: resource_type_code
26: FROM
27: pa_resource_types
28: WHERE resource_type_id = l_resource_type_id;
29:
30: CURSOR c_resource_list_member_csr IS
31: SELECT
89: p_track_as_labor_flag := NULL;
90: RETURN;
91: END IF;
92:
93: p_err_stage := 'Select resource_type_code from pa_resource_types ';
94:
95: --- Get the resource_type_code of the resource_type from
96: --- pa_resource_types using the resource_type_id.
97:
92:
93: p_err_stage := 'Select resource_type_code from pa_resource_types ';
94:
95: --- Get the resource_type_code of the resource_type from
96: --- pa_resource_types using the resource_type_id.
97:
98: OPEN c_resource_types_csr;
99: FETCH c_resource_types_csr INTO l_resource_type_code;
100: IF c_resource_types_csr%NOTFOUND THEN
428: CURSOR c_resource_types_csr IS
429: SELECT
430: resource_type_id
431: FROM
432: pa_resource_types
433: WHERE resource_type_code = p_resource_type_code;
434:
435: --
436: -- 22-APR-98 ------------------------------------------------
575: p_err_code := 10;
576: p_err_stage := 'PA_NO_PROJECT_ROLE_ID';
577: RETURN;
578: END IF;
579: p_err_stage := 'Select resource_type_id from pa_resource_types ';
580:
581: --- Get the resource_type_id of the resource_type from
582: --- pa_resource_types using the resource_type_code.
583:
578: END IF;
579: p_err_stage := 'Select resource_type_id from pa_resource_types ';
580:
581: --- Get the resource_type_id of the resource_type from
582: --- pa_resource_types using the resource_type_code.
583:
584: OPEN c_resource_types_csr;
585: FETCH c_resource_types_csr INTO l_resource_type_id;
586: IF c_resource_types_csr%NOTFOUND THEN
1023: par.track_as_labor_flag,
1024: par.unit_of_measure,
1025: par.rollup_quantity_flag
1026: FROM pa_resources par,
1027: pa_resource_types part
1028: WHERE part.resource_type_code = 'UNCLASSIFIED'
1029: AND part.resource_type_id = par.resource_type_id;
1030:
1031: l_old_stack varchar2(2000);
1132: WHERE exists
1133: (select 'x'
1134: from pa_resource_list_members rlm
1135: , pa_resources r
1136: , pa_resource_types rt
1137: where
1138: rlm.resource_list_id = l_resource_list_id
1139: and rlm.resource_id = r.resource_id
1140: and r.resource_type_id = rt.resource_type_id