APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCES

Line 43: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS

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,
46: prta.organization_id,
47: prta.vendor_id,

Line 61: PA_RESOURCES PR,

57: prta.resource_format_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;

Line 626: FROM pa_resources pr, pa_resource_types prt

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:

Line 2285: pa_resources_s.NEXTVAL

2281: WHERE resource_type_code = p_resource_type_code;
2282:
2283: CURSOR c_resource_seq_csr IS
2284: SELECT
2285: pa_resources_s.NEXTVAL
2286: FROM
2287: SYS.DUAL;
2288:
2289:

Line 2372: p_err_stage := 'Insert into pa_resources ';

2368: FETCH c_resource_seq_csr INTO
2369: l_resource_id;
2370: CLOSE c_resource_seq_csr;
2371:
2372: p_err_stage := 'Insert into pa_resources ';
2373:
2374: INSERT INTO pa_resources
2375: (resource_id,
2376: name,

Line 2374: INSERT INTO pa_resources

2370: CLOSE c_resource_seq_csr;
2371:
2372: p_err_stage := 'Insert into pa_resources ';
2373:
2374: INSERT INTO pa_resources
2375: (resource_id,
2376: name,
2377: description,
2378: resource_type_id,

Line 2539: pa_resources re,

2535: SELECT
2536: rta.expenditure_category
2537: FROM
2538: pa_resource_list_members rlm,
2539: pa_resources re,
2540: pa_resource_txn_attributes rta
2541: WHERE rlm.resource_list_member_id = p_parent_member_id
2542: AND rlm.resource_id = re.resource_id
2543: AND re.resource_id = rta.resource_id;

Line 2550: pa_resources re,

2546: SELECT
2547: rta.revenue_category
2548: FROM
2549: pa_resource_list_members rlm,
2550: pa_resources re,
2551: pa_resource_txn_attributes rta
2552: WHERE rlm.resource_list_member_id = p_parent_member_id
2553: AND rlm.resource_id = re.resource_id
2554: AND re.resource_id = rta.resource_id;

Line 2646: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS

2642: FROM SYS.DUAL;
2643:
2644: --Cursor added for resolution of bug 1889671
2645:
2646: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS
2647: SELECT prta.person_id,
2648: prta.job_id,
2649: prta.organization_id,
2650: prta.vendor_id,

Line 2664: PA_RESOURCES PR,

2660: prta.resource_format_id,
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;

Line 2679: FROM pa_resources pr, pa_resource_types prt

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

Line 2923: --- a resource in PA_RESOURCES table and get the resource_id.

2919: END IF;
2920: END IF;
2921:
2922: --- Check whether the child resource has already been created as
2923: --- a resource in PA_RESOURCES table and get the resource_id.
2924:
2925: PA_GET_RESOURCE.Get_Resource
2926: (p_resource_name => p_resource_name,
2927: p_resource_type_Code => p_resource_type_code,