DBA Data[Home] [Help]

APPS.AMS_LIST_MAINT_PVT dependencies on AMS_LIST_SELECT_ACTIONS

Line 25: --This Variable stores a record from the AMS_LIST_SELECT_ACTIONS table. --

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';

Line 767: --This Cursor retreves all list criteraias from the AMS_LIST_SELECT_ACTIONS table.--

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

Line 794: FROM ams_list_select_actions

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: