APPS.AMS_DMSELECTION_PVT dependencies on STANDARD

Line 20: -- 18-Apr-2001 choang Added semicolon after exit for standards.

16: -- passing nth row instead of pct random. 4)
17: -- used bind vars in populate_using_sql.
18: -- 06-Mar-2001 choang Added workbook_owner_name so query uses
19: -- index against ams_discoverer_sql.
20: -- 18-Apr-2001 choang Added semicolon after exit for standards.
21: -- 22-Jul-2001 choang Replaced select party_id from list_entries with
22: -- select list_entry_source_system_id.
23: -- 31-Aug-2001 choang Changed logic for getting responses.
24: -- 10-Oct-2001 choang Changed logic for CSCH to use ams_act_lists

Line 2615: L_SELECTION_TYPE_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

2611: p_object_for_id IN NUMBER,
2612: x_return_status OUT NOCOPY VARCHAR2
2613: )
2614: IS
2615: L_SELECTION_TYPE_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';
2616: L_SELECTION_TYPE_NTH_ROW CONSTANT VARCHAR2(30) := 'NTH_RECORD';
2617: L_SELECTION_TYPE_PCT CONSTANT VARCHAR2(30) := 'RANDOM';
2618:
2619: l_total_records NUMBER;

Line 2678: IF l_row_selection_type = L_SELECTION_TYPE_STANDARD THEN

2674: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_records);
2675: RAISE FND_API.G_EXC_ERROR;
2676: END IF;
2677:
2678: IF l_row_selection_type = L_SELECTION_TYPE_STANDARD THEN
2679: -- UPDATE ams_dm_inter_source_stg
2680: UPDATE ams_dm_int_src_stg_gt
2681: SET enabled_flag = 'Y'
2682: WHERE arc_object_used_by = p_arc_object_for