APPS.PFT_PPROFCAL_MASTER_PUB dependencies on FEM_CUSTOMER_PROFIT

Line 17: g_fem_customer_profit CONSTANT VARCHAR2(30) := 'FEM_CUSTOMER_PROFIT';

13: g_exec_status_success CONSTANT VARCHAR2(30) := 'SUCCESS';
14:
15: --Constants for output table names being registered with fem_pl_pkg
16: -- API register_table method.
17: g_fem_customer_profit CONSTANT VARCHAR2(30) := 'FEM_CUSTOMER_PROFIT';
18: g_fem_region_info CONSTANT VARCHAR2(30) := 'FEM_REGION_INFO';
19: g_fem_customers_attr CONSTANT VARCHAR2(30) := 'FEM_CUSTOMERS_ATTR';
20:
21: --constant for sql_stmt_type

Line 1222: fem_customer_profit.profit_percentile%TYPE;

1218: l_region_percent NUMBER;
1219: l_profit_percentile NUMBER;
1220:
1221: TYPE v_percentile_type IS TABLE OF
1222: fem_customer_profit.profit_percentile%TYPE;
1223: v_percentile v_percentile_type;
1224:
1225: e_process_single_rule_error EXCEPTION;
1226: e_register_rule_error EXCEPTION;

Line 1488: FROM fem_customer_profit

1484: -- Profit Percentile should be performed only once for a period
1485: BEGIN
1486: SELECT COUNT (profit_percentile)
1487: INTO l_profit_percentile
1488: FROM fem_customer_profit
1489: WHERE cal_period_id = p_param_rec.output_cal_period_id
1490: AND ledger_id = p_param_rec.ledger_id
1491: AND dataset_code = p_param_rec.output_dataset_code
1492: AND source_system_code = p_param_rec.source_system_code

Line 1517: FROM fem_customer_profit

1513: v_percentile := v_percentile_type();
1514: BEGIN
1515: SELECT profit_percentile
1516: BULK COLLECT INTO v_percentile
1517: FROM fem_customer_profit
1518: WHERE cal_period_id = p_param_rec.output_cal_period_id
1519: AND ledger_id = p_param_rec.ledger_id
1520: AND dataset_code = p_param_rec.output_dataset_code
1521: AND source_system_code = p_param_rec.source_system_code

Line 1543: ,p_tbl_name => g_fem_customer_profit

1539: ,p_module => G_BLOCK||'.'||l_api_name
1540: ,p_msg_text => 'Register table:CUST_PPTILE');
1541:
1542: Register_Table( p_param_rec => p_param_rec
1543: ,p_tbl_name => g_fem_customer_profit
1544: ,p_num_output_rows => 0
1545: ,p_stmt_type => g_update);
1546:
1547: FEM_ENGINES_PKG.Tech_Message(

Line 1553: ,p_table_name => g_fem_customer_profit

1549: ,p_module => G_BLOCK||'.'||l_api_name
1550: ,p_msg_text => 'Register updt colmn:CUST_PPTILE');
1551:
1552: Register_Updated_Column( p_param_rec => p_param_rec
1553: ,p_table_name => g_fem_customer_profit
1554: ,p_statement_type => g_update
1555: ,p_column_name => 'PROFIT_PERCENTILE');
1556:
1557: Register_Updated_Column( p_param_rec => p_param_rec

Line 1558: ,p_table_name => g_fem_customer_profit

1554: ,p_statement_type => g_update
1555: ,p_column_name => 'PROFIT_PERCENTILE');
1556:
1557: Register_Updated_Column( p_param_rec => p_param_rec
1558: ,p_table_name => g_fem_customer_profit
1559: ,p_statement_type => g_update
1560: ,p_column_name => 'PROFIT_DECILE');
1561:
1562: -----------------------------------------------------------------------

Line 1632: ,p_tbl_name => g_fem_customer_profit

1628: ,p_module => G_BLOCK||'.'||l_api_name
1629: ,p_msg_text => 'Register table:Value Index');
1630:
1631: Register_Table( p_param_rec => p_param_rec
1632: ,p_tbl_name => g_fem_customer_profit
1633: ,p_num_output_rows => 0
1634: ,p_stmt_type => g_update);
1635:
1636: -----------------------------------------------------------------------