APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_ACTION_SET_LINE_AUD

Line 558: pa_action_set_line_aud asla

554: MINUS
555: -- SELECT ohd.child_organization_id, pa_expenditures_utils.GetOrgTlName(ohd.child_organization_id) -- Commented for Bug 4866284
556: SELECT ohd.child_organization_id, pa_resource_utils.get_organization_name(ohd.child_organization_id) -- Added for Bug 4866284
557: FROM pa_org_hierarchy_denorm ohd,
558: pa_action_set_line_aud asla
559: WHERE ohd.org_hierarchy_version_id = c_org_hierarchy_version_id
560: AND ohd.parent_organization_id = c_start_org_id
561: AND ohd.pa_org_use_type = 'EXPENDITURES'
562: AND ohd.child_organization_id = to_number(asla.audit_attribute)

Line 1801: FROM pa_action_set_line_aud

1797:
1798: -- cursor to get all the currently active audit lines
1799: CURSOR get_all_active_audit_lines IS
1800: SELECT action_set_line_id, action_code, audit_attribute, audit_display_attribute, 'REVERSED'
1801: FROM pa_action_set_line_aud
1802: WHERE object_id = p_object_id
1803: AND object_type = 'OPEN_ASSIGNMENT'
1804: AND action_set_type_code = 'ADVERTISEMENT'
1805: AND active_flag = 'Y'

Line 1812: FROM pa_action_set_line_aud

1808:
1809: -- cursor to get all the currently active audit lines with/without error
1810: CURSOR get_active_audit_lines_error IS
1811: SELECT action_set_line_id, 'REVERSED'
1812: FROM pa_action_set_line_aud
1813: WHERE object_id = p_object_id
1814: AND object_type = 'OPEN_ASSIGNMENT'
1815: AND action_set_type_code = 'ADVERTISEMENT'
1816: AND active_flag = 'Y'

Line 1824: FROM pa_action_set_line_aud asa,

1820: -- cursor to get all the action lines that were reversed due to the execution
1821: -- of this Remove Advertisement line and are not deleted
1822: CURSOR get_all_reversed_lines IS
1823: SELECT asl.action_set_line_id, asl.action_code, asa.audit_attribute, asa.audit_display_attribute, 'COMPLETE'
1824: FROM pa_action_set_line_aud asa,
1825: pa_action_set_lines asl,
1826: pa_action_set_line_cond aslc
1827: WHERE asa.object_id = p_object_id
1828: AND asa.object_type = 'OPEN_ASSIGNMENT'

Line 1915: UPDATE pa_action_set_line_aud

1911: END IF;
1912:
1913: -- Update the active flag to 'N' in the audit records
1914: FORALL i IN l_action_set_line_id_tbl2.FIRST ..l_action_set_line_id_tbl2.LAST
1915: UPDATE pa_action_set_line_aud
1916: SET active_flag = 'N'
1917: WHERE action_set_line_id = l_action_set_line_id_tbl2(i);
1918:
1919: -- set the action status code to REVERSE_PENDING