APPS.PFT_PROFITAGG_PUB dependencies on FEM_COL_TMPLT_DEFN_API_PUB

Line 1994: l_table_alias := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias;

1990: ,p_condition_obj_id => p_param_rec.cond_obj_id
1991: ,p_col_obj_def_id => l_col_obj_def_id
1992: ,p_aggregate_customer => p_param_rec.aggregate_customer);
1993:
1994: l_table_alias := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias;
1995:
1996: fem_engines_pkg.tech_message(
1997: p_severity => g_log_level_3
1998: ,p_module => G_BLOCK||'.'||l_api_name

Line 2305: Fem_Col_Tmplt_Defn_Api_Pub.generate_predicates (

2301: END IF;
2302:
2303: -- Calls Column population Template API to create SQL statement based on
2304: -- the given col population template.
2305: Fem_Col_Tmplt_Defn_Api_Pub.generate_predicates (
2306: p_api_version => g_api_version
2307: ,p_init_msg_list => g_false
2308: ,p_commit => g_false
2309: ,p_encoded => g_true

Line 2339: l_table_alias := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias;

2335: RAISE e_col_population_api_err ;
2336:
2337: END IF;
2338:
2339: l_table_alias := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias;
2340:
2341: IF (p_aggregate_customer = 'Y') THEN
2342: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
2343: ,p_module => G_BLOCK||'.'||l_api_name

Line 2786: l_where := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias ||

2782: ' WHERE hierarchy_obj_def_id = :5';
2783:
2784: p_from_clause := p_from_clause || ' AND child_depth_num = :6 ) )cust_hier_dump';
2785:
2786: l_where := Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias ||
2787: '.Customer_Id = ' || 'cust_hier_dump.child_id';
2788:
2789: p_where_clause := p_where_clause || ' AND ' || l_where;
2790: p_order_by_clause := 'GROUP BY cust_hier_dump.Customer_Id';

Line 2793: Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias ||

2789: p_where_clause := p_where_clause || ' AND ' || l_where;
2790: p_order_by_clause := 'GROUP BY cust_hier_dump.Customer_Id';
2791:
2792: p_where_clause := p_where_clause || ' AND ' ||
2793: Fem_Col_Tmplt_Defn_Api_Pub.g_src_alias ||
2794: '.data_aggregation_type_code = ' ||
2795: '''CUSTOMER_AGGREGATION''';
2796:
2797: fem_engines_pkg.tech_message ( p_severity => g_log_level_2