21: ----------------------------------------------------------------------------
22: g_listheader_rec AMS_LISTHEADER_PVT.list_header_rec_type;
23:
24: ----------------------------------------------------------------------------
25: --This Variable stores a record from the AMS_LIST_SELECT_ACTIONS table. --
26: ----------------------------------------------------------------------------
27: g_listaction_rec AMS_LISTACTION_PVT.action_rec_type;
28:
29: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_List_Maint_PVT';
763: WHERE list_header_id = p_list_header_id;
764:
765:
766: ------------------------------------------------------------------------------------
767: --This Cursor retreves all list criteraias from the AMS_LIST_SELECT_ACTIONS table.--
768: ------------------------------------------------------------------------------------
769: Cursor C_ListAction_Dets(p_list_header_id NUMBER)
770: IS SELECT
771: list_select_action_id
790: ,no_of_rows_used
791: ,distribution_pct
792: ,result_text
793: ,description
794: FROM ams_list_select_actions
795: WHERE list_header_id = p_list_header_id
796: ORDER BY order_number;
797:
798: