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 638: FROM pa_resources pr, pa_resource_types prt

634: -- Start of change
635:
636: CURSOR Cur_Unclassified_Resource_List IS
637: SELECT prt.resource_type_id,prt.resource_type_code
638: FROM pa_resources pr, pa_resource_types prt
639: WHERE prt.resource_type_code='UNCLASSIFIED'
640: AND pr.resource_type_id = prt.resource_type_id;
641:
642:

Line 2633: pa_resources_s.NEXTVAL

2629: WHERE resource_type_code = p_resource_type_code;
2630:
2631: CURSOR c_resource_seq_csr IS
2632: SELECT
2633: pa_resources_s.NEXTVAL
2634: FROM
2635: SYS.DUAL;
2636:
2637:

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

2716: FETCH c_resource_seq_csr INTO
2717: l_resource_id;
2718: CLOSE c_resource_seq_csr;
2719:
2720: p_err_stage := 'Insert into pa_resources ';
2721:
2722: INSERT INTO pa_resources
2723: (resource_id,
2724: name,

Line 2722: INSERT INTO pa_resources

2718: CLOSE c_resource_seq_csr;
2719:
2720: p_err_stage := 'Insert into pa_resources ';
2721:
2722: INSERT INTO pa_resources
2723: (resource_id,
2724: name,
2725: description,
2726: resource_type_id,

Line 2887: pa_resources re,

2883: SELECT
2884: rta.expenditure_category
2885: FROM
2886: pa_resource_list_members rlm,
2887: pa_resources re,
2888: pa_resource_txn_attributes rta
2889: WHERE rlm.resource_list_member_id = p_parent_member_id
2890: AND rlm.resource_id = re.resource_id
2891: AND re.resource_id = rta.resource_id;

Line 2898: pa_resources re,

2894: SELECT
2895: rta.revenue_category
2896: FROM
2897: pa_resource_list_members rlm,
2898: pa_resources re,
2899: pa_resource_txn_attributes rta
2900: WHERE rlm.resource_list_member_id = p_parent_member_id
2901: AND rlm.resource_id = re.resource_id
2902: AND re.resource_id = rta.resource_id;

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

2990: FROM SYS.DUAL;
2991:
2992: --Cursor added for resolution of bug 1889671
2993:
2994: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS
2995: SELECT prta.person_id,
2996: prta.job_id,
2997: prta.organization_id,
2998: prta.vendor_id,

Line 3012: PA_RESOURCES PR,

3008: prta.resource_format_id,
3009: prt.resource_type_id,
3010: prt.resource_type_code
3011: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
3012: PA_RESOURCES PR,
3013: PA_RESOURCE_TYPES PRT
3014: WHERE prta.resource_id = pr.resource_id
3015: AND pr.resource_id =P_RESOURCE_ID
3016: AND pr.resource_type_id= prt.resource_type_id;

Line 3027: FROM pa_resources pr, pa_resource_types prt

3023: -- Start of change
3024:
3025: CURSOR Cur_Unclassified_Resource_List IS
3026: SELECT prt.resource_type_id,prt.resource_type_code
3027: FROM pa_resources pr, pa_resource_types prt
3028: WHERE prt.resource_type_code='UNCLASSIFIED'
3029: AND pr.resource_type_id = prt.resource_type_id;
3030:
3031: BEGIN

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

3268: END IF;
3269: END IF;
3270:
3271: --- Check whether the child resource has already been created as
3272: --- a resource in PA_RESOURCES table and get the resource_id.
3273:
3274: PA_GET_RESOURCE.Get_Resource
3275: (p_resource_name => p_resource_name,
3276: p_resource_type_Code => p_resource_type_code,