APPS.AMS_PARTY_SEG_LOADER_PVT dependencies on AMS_CELL_PVT

Line 64: AMS_CELL_PVT.get_comp_sql(

60: IF (AMS_DEBUG_HIGH_ON) THEN
61: AMS_Utility_PVT.Debug_Message(l_api_name||' get comp sql for cell ');
62: END IF;
63:
64: AMS_CELL_PVT.get_comp_sql(
65: p_api_version => 1,
66: p_init_msg_list => NULL,
67: p_validation_level => NULL,
68: x_return_status => x_return_status,

Line 515: -- 1. The process will execute the ams_cell_pvt.get_comp_sql for a given

511: -- Purpose
512: -- load ams_party_market_segments for one segment
513: --
514: -- Note
515: -- 1. The process will execute the ams_cell_pvt.get_comp_sql for a given
516: -- cell_id to get its sql and its ancestors, then use DBMS SQL to excute
517: -- the returned SQL table to get parties that belong to that sql.
518: -- 2. If cell_id is passed into, then only that cell will be refreshed or
519: -- else all the cells will be refreshed.