APPS.CN_FORMULA_GEN_PKG dependencies on STANDARD

Line 93: -- other than the standard table

89: -- stores a list of unique table names referred to by this formula
90: g_uniq_tbl_names_tbl exp_tbl_names_tbl_type;
91:
92: --table to indicate whether a expression used anyother table
93: -- other than the standard table
94: g_other_tabused_tbl exp_other_tabused_tbl_type;
95:
96: --table to indicate whether a expression uses any non pl/sql function like decode
97: g_non_plsql_func_used_tbl exp_other_tabused_tbl_type;

Line 406: --then some non standard table is used set the flag g_other_tabused_tbl to indicate this

402:
403: END LOOP;
404:
405: --if no of tables parsed and added to the list is less then no of tables parsed
406: --then some non standard table is used set the flag g_other_tabused_tbl to indicate this
407: IF l_parsed_elmnts_tbl.COUNT > counter_1 THEN
408: g_other_tabused_tbl(expression_rec.CALC_SQL_EXP_ID) := 'Y';
409: ELSE
410: IF NOT g_other_tabused_tbl.EXISTS(expression_rec.CALC_SQL_EXP_ID) THEN

Line 1693: -- if other tables other than the standard tables are used in

1689: l_input_sql_select := lower_str( 'select ' || l_input_sql_select );
1690: convert_clob_to_string(l_input_sql_from_clob, l_input_sql_from);
1691: l_input_sql_from := lower( 'from ' || l_input_sql_from );
1692:
1693: -- if other tables other than the standard tables are used in
1694: -- the input expression we will retain the select statment in
1695: -- get input othewise we will replace it with a expression using
1696: -- global variable which are prepopulated in calculate_quota
1697: IF g_other_tabused_tbl(l_mul_input.calc_sql_exp_id) = 'Y' THEN

Line 2045: -- if other tables other than the standard tables are used in

2041: construct_sql_from_where(l_output_sql_select, l_output_sql_from, l_output_sql_where);
2042: handle_output_sql_select(l_output_sql_select, l_output_sql_from, l_output_sql_where);
2043:
2044: -- Added for 11.5.10 Performance Enhancments
2045: -- if other tables other than the standard tables are used in
2046: -- the output expression we will retain the select statment in
2047: -- otherwise Replace the select with a expression which uses
2048: -- the prefetched column values held in record variables
2049:

Line 5032: -- Standard Start of API savepoint

5028: l_error_count NUMBER;
5029:
5030: l_formula_name VARCHAR2(100);
5031: BEGIN
5032: -- Standard Start of API savepoint
5033: SAVEPOINT generate_formula;
5034:
5035: -- Standard call to check for call compatibility.
5036: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 5035: -- Standard call to check for call compatibility.

5031: BEGIN
5032: -- Standard Start of API savepoint
5033: SAVEPOINT generate_formula;
5034:
5035: -- Standard call to check for call compatibility.
5036: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5037: p_api_version ,
5038: l_api_name ,
5039: G_PKG_NAME )

Line 5191: -- Standard check of p_commit.

5187: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5188: 'End of generate_formula');
5189: end if;
5190:
5191: -- Standard check of p_commit.
5192: IF FND_API.To_Boolean( p_commit ) THEN
5193: COMMIT WORK;
5194: END IF;
5195:

Line 5196: -- Standard call to get message count and if count is 1, get message info.

5192: IF FND_API.To_Boolean( p_commit ) THEN
5193: COMMIT WORK;
5194: END IF;
5195:
5196: -- Standard call to get message count and if count is 1, get message info.
5197: FND_MSG_PUB.Count_And_Get
5198: ( p_count => x_msg_count ,
5199: p_data => x_msg_data ,
5200: p_encoded => FND_API.G_FALSE