APPS.PA_HR_RESOURCE dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 11: r_id pa_resource_txn_attributes.resource_id%type; /* Added for Bug#2738741 */

7: Reference_Exist OUT NOCOPY varchar2) --File.Sql.39 bug 4440895
8: IS
9: reference_exists exception;
10: dummy1 varchar2(1);
11: r_id pa_resource_txn_attributes.resource_id%type; /* Added for Bug#2738741 */
12: l_ret_stat varchar2(1); /* these variables are added for bug#2738741 */
13: msg_cnt number;
14: msg_data varchar2(2000);
15: forecastitem_err exception;

Line 19: from PA_RESOURCE_TXN_ATTRIBUTES pa

15: forecastitem_err exception;
16:
17: cursor resource_txn( p_person_id number ) is
18: select resource_id /* Bug 2738741 - Changed from null to resource_id */
19: from PA_RESOURCE_TXN_ATTRIBUTES pa
20: where pa.person_id = P_PERSON_ID;
21:
22: /* Bug#2738741 - Added this new cursor resource_list_ref for checking in pa_resource_list_members
23: which stores the members of a resource list */

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 83: DELETE FROM pa_resource_txn_attributes where resource_id = r_id;

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:
85: DELETE FROM pa_resources WHERE resource_id = r_id;
86:
87: END IF;

Line 111: from PA_RESOURCE_TXN_ATTRIBUTES pa

107: dummy1 varchar2(1);
108:
109: cursor resource_txn( p_job_id number ) is
110: select null
111: from PA_RESOURCE_TXN_ATTRIBUTES pa
112: where pa.job_id = P_JOB_ID;
113:
114: cursor resource_map( p_job_id number ) is
115: select null