[Home] [Help]
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
40: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
41: l_res_type_code pa_resource_types.resource_type_code%TYPE;
42:
43: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS
44: SELECT prta.person_id,
45: prta.job_id,
58: prt.resource_type_id,
59: prt.resource_type_code
60: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
61: PA_RESOURCES PR,
62: PA_RESOURCE_TYPES PRT
63: WHERE prta.resource_id = pr.resource_id
64: AND pr.resource_id =P_RESOURCE_ID
65: AND pr.resource_type_id= prt.resource_type_id;
66:
101: CURSOR c_resource_types_csr IS
102: SELECT
103: resource_type_code
104: FROM
105: pa_resource_types_active_v
106: WHERE resource_type_id = l_resource_type_id;
107:
108: CURSOR c_revenue_categ_csr IS -- changed for perf bug 4887375
109: /*SELECT
183: IF (p_sort_order IS NULL OR p_sort_order = 0) THEN
184: l_get_new_sort_order := 'TRUE';
185: END IF;
186:
187: p_err_stage := ' Select resource_type_code from pa_resource_types';
188: OPEN c_resource_types_csr;
189: FETCH c_resource_types_csr INTO
190: l_resource_type_code;
191: IF c_resource_types_csr%NOTFOUND THEN
560: l_Uom VARCHAR2(30);
561: l_track_as_labor_flag VARCHAR2(1);
562: l_rollup_qty_flag VARCHAR2(1);
563: l_resource_id NUMBER := NULL;
564: l_resource_type_code pa_resource_types.resource_type_code%TYPE;
565: l_job_group_id NUMBER := NULL; --Added for Bug 2486405.
566: l_msg_count NUMBER;
567: l_record_version_number NUMBER := NULL;
568: l_return_status VARCHAR2(1);
622: -- Start of change
623:
624: CURSOR Cur_Unclassified_Resource_List IS
625: SELECT prt.resource_type_id,prt.resource_type_code
626: FROM pa_resources pr, pa_resource_types prt
627: WHERE prt.resource_type_code='UNCLASSIFIED'
628: AND pr.resource_type_id = prt.resource_type_id;
629:
630:
1454: CURSOR c_res_types_csr IS
1455: SELECT
1456: resource_class_code
1457: FROM
1458: pa_resource_types_active_v
1459: WHERE
1460: resource_type_code = p_resource_type_code;
1461:
1462: CURSOR c_res_format_csr IS
1488: p_err_stack :=
1489: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_txn_Attribute';
1490:
1491:
1492: p_err_stage := 'Select resource_class_code from pa_resource_types_active_v';
1493:
1494: OPEN c_res_types_csr;
1495: FETCH c_res_types_csr INTO l_resource_class_code;
1496: IF c_res_types_csr%NOTFOUND THEN
1703: CURSOR c_resource_types_csr IS
1704: SELECT
1705: resource_type_code
1706: FROM
1707: pa_resource_types_active_v
1708: WHERE resource_type_id = l_grouped_resource_type_id;
1709:
1710: CURSOR c_rev_category_csr IS -- changed for perf bug 4887375
1711: /*SELECT
1837: END IF;
1838: IF l_grouped_resource_type_id <> 0 THEN
1839: -- the resource list has been grouped
1840: -- get the resource_type_code into grouped_by_resource_type_code
1841: -- from pa_resource_types using group_resource_type_id
1842:
1843: p_err_stage := 'Select resource_type_code from pa_resource_types ';
1844: OPEN c_resource_types_csr;
1845: FETCH c_resource_types_csr INTO
1839: -- the resource list has been grouped
1840: -- get the resource_type_code into grouped_by_resource_type_code
1841: -- from pa_resource_types using group_resource_type_id
1842:
1843: p_err_stage := 'Select resource_type_code from pa_resource_types ';
1844: OPEN c_resource_types_csr;
1845: FETCH c_resource_types_csr INTO
1846: l_grouped_resource_type_code;
1847: IF c_resource_types_csr%NOTFOUND THEN
2276: CURSOR c_resource_types_csr IS
2277: SELECT
2278: resource_type_id
2279: FROM
2280: pa_resource_types_active_v
2281: WHERE resource_type_code = p_resource_type_code;
2282:
2283: CURSOR c_resource_seq_csr IS
2284: SELECT
2303: p_err_stage := 'PA_RL_RES_TYPE_CODE_REQD';
2304: RETURN;
2305: END IF;
2306:
2307: p_err_stage := 'Select resource_type_id from pa_resource_types_active_v ';
2308:
2309: OPEN c_resource_types_csr;
2310: FETCH c_resource_types_csr INTO
2311: l_resource_type_id;
2498: l_resource_name VARCHAR2(80);
2499: l_alias VARCHAR2(30);
2500: l_new_track_as_labor_flag VARCHAR2(1);
2501: l_org_id NUMBER := NULL;
2502: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2503: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2504: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2505: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2514: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2515: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2516: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2517: l_res_type_code pa_resource_types.resource_type_code%TYPE;
2518:
2519:
2520: CURSOR c_res_list_csr IS
2521: SELECT
2527: CURSOR c_resource_types_csr IS
2528: SELECT
2529: resource_type_code
2530: FROM
2531: pa_resource_types
2532: WHERE resource_type_id = l_grouped_resource_type_id;
2533:
2534: CURSOR c_exp_categ_csr IS
2535: SELECT
2661: prt.resource_type_id,
2662: prt.resource_type_code
2663: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
2664: PA_RESOURCES PR,
2665: PA_RESOURCE_TYPES PRT
2666: WHERE prta.resource_id = pr.resource_id
2667: AND pr.resource_id =P_RESOURCE_ID
2668: AND pr.resource_type_id= prt.resource_type_id;
2669:
2675: -- Start of change
2676:
2677: CURSOR Cur_Unclassified_Resource_List IS
2678: SELECT prt.resource_type_id,prt.resource_type_code
2679: FROM pa_resources pr, pa_resource_types prt
2680: WHERE prt.resource_type_code='UNCLASSIFIED'
2681: AND pr.resource_type_id = prt.resource_type_id;
2682:
2683: BEGIN
2717: RETURN;
2718: END IF;
2719:
2720: IF l_grouped_resource_type_id <> 0 THEN
2721: p_err_stage := ' Select resource_type_code from pa_resource_types';
2722: OPEN c_resource_types_csr;
2723: FETCH c_resource_types_csr INTO
2724: l_grouped_res_type_code;
2725: IF c_resource_types_csr%NOTFOUND THEN