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 1800: FROM pa_action_set_line_aud

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

Line 1811: FROM pa_action_set_line_aud

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

Line 1823: FROM pa_action_set_line_aud asa,

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

Line 1914: UPDATE pa_action_set_line_aud

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