DBA Data[Home] [Help]

APPS.ORACLEAPPS dependencies on FND_DM_NODES

Line 3170: TYPE t_node_id IS TABLE OF fnd_dm_nodes.node_id%TYPE;

3166: l_profile_defined boolean;
3167: l_auth_mode VARCHAR2(50);
3168: l_tz_enabled VARCHAR2(10);
3169: l_counter NUMBER;
3170: TYPE t_node_id IS TABLE OF fnd_dm_nodes.node_id%TYPE;
3171: TYPE t_node_name IS TABLE OF fnd_dm_nodes.node_name%TYPE;
3172: v_node_id t_node_id;
3173: v_node_name t_node_name;
3174:

Line 3171: TYPE t_node_name IS TABLE OF fnd_dm_nodes.node_name%TYPE;

3167: l_auth_mode VARCHAR2(50);
3168: l_tz_enabled VARCHAR2(10);
3169: l_counter NUMBER;
3170: TYPE t_node_id IS TABLE OF fnd_dm_nodes.node_id%TYPE;
3171: TYPE t_node_name IS TABLE OF fnd_dm_nodes.node_name%TYPE;
3172: v_node_id t_node_id;
3173: v_node_name t_node_name;
3174:
3175:

Line 3196: FROM fnd_dm_nodes

3192: ORDER BY NAME;
3193:
3194: CURSOR get_dm is
3195: SELECT node_id, node_name
3196: FROM fnd_dm_nodes
3197: ORDER BY node_name;
3198:
3199: cursor get_territory is
3200: select t.territory_short_name territory_name,