APPS.PA_HR_RESOURCE dependencies on PA_RESOURCES

Line 48: and raise error if records in the cursor. If not delete records from pa_resources_denorm,

44: CLOSE rbs_person_ref;
45:
46:
47: /* Bug#2738741 - Modified the code here to check in cursor pa_resource_list_members
48: and raise error if records in the cursor. If not delete records from pa_resources_denorm,
49: pa_resource_txn_attributes, pa_resources */
50:
51: Error_Message := 'PA_HR_PER_RES_TXN_ATTR';
52: OPEN resource_txn(p_person_id);

Line 49: pa_resource_txn_attributes, pa_resources */

45:
46:
47: /* Bug#2738741 - Modified the code here to check in cursor pa_resource_list_members
48: and raise error if records in the cursor. If not delete records from pa_resources_denorm,
49: pa_resource_txn_attributes, pa_resources */
50:
51: Error_Message := 'PA_HR_PER_RES_TXN_ATTR';
52: OPEN resource_txn(p_person_id);
53: FETCH resource_txn INTO r_id; /* Bug#2738741 - Commenting dummy1 */

Line 66: /* Bug#2738741 - Added code to check if prm is installed, if so delete from pa_resources_denorm

62: CLOSE resource_list_ref;
63:
64: /* Bug#2738741 - Delete from resource tables and denorm table as no reference */
65:
66: /* Bug#2738741 - Added code to check if prm is installed, if so delete from pa_resources_denorm
67: and called delete API for forecast items */
68:
69: -- Bug 4092769 - Remove PJR license check.
70: -- IF (pa_install.is_prm_licensed = 'Y') THEN

Line 80: DELETE FROM pa_resources_denorm WHERE resource_id = r_id;

76: IF (l_ret_stat <> FND_API.G_RET_STS_SUCCESS) THEN
77: Raise Forecastitem_err;
78: END IF;
79:
80: DELETE FROM pa_resources_denorm WHERE resource_id = r_id;
81: -- END IF;
82:
83: DELETE FROM pa_resource_txn_attributes where resource_id = r_id;
84:

Line 85: DELETE FROM pa_resources WHERE resource_id = r_id;

81: -- END IF;
82:
83: DELETE FROM pa_resource_txn_attributes where resource_id = r_id;
84:
85: DELETE FROM pa_resources WHERE resource_id = r_id;
86:
87: END IF;
88:
89: CLOSE resource_txn;