DBA Data[Home] [Help]

APPS.PA_ACTION_SETS_PVT dependencies on PA_ACTION_SET_LINE_AUD

Line 854: FROM PA_ACTION_SET_LINE_AUD

850: -- Bug Ref : 6797508
851: IF ( l_action_set_type_code = 'ADVERTISEMENT' ) THEN
852: IF ( l_do_audit_lines_exist = 'Y' )THEN
853: DELETE
854: FROM PA_ACTION_SET_LINE_AUD
855: WHERE ACTION_SET_LINE_ID = P_ACTION_SET_LINE_ID;
856: END IF;
857: -- 2411522 : Need to set MOD_SOURCE_ACTION_SET_FLAG = 'Y' when deleting a line.
858: l_do_audit_lines_exist :=

Line 1017: UPDATE pa_action_set_line_aud

1013: BEGIN
1014:
1015: IF p_status_code = 'REVERSED' THEN
1016:
1017: UPDATE pa_action_set_line_aud
1018: SET active_flag = 'N'
1019: WHERE action_set_line_id = p_action_set_line_id;
1020:
1021: END IF;

Line 1037: INSERT INTO pa_action_set_line_aud

1033:
1034: END LOOP;
1035:
1036: FORALL i IN p_audit_lines_tbl.FIRST .. p_audit_lines_tbl.LAST
1037: INSERT INTO pa_action_set_line_aud
1038: (action_set_line_id,
1039: object_type,
1040: object_id,
1041: action_set_type_code,