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 1700: -- if other tables other than the standard tables are used in

1696: l_input_sql_select := lower_str( 'select ' || l_input_sql_select );
1697: convert_clob_to_string(l_input_sql_from_clob, l_input_sql_from);
1698: l_input_sql_from := lower( 'from ' || l_input_sql_from );
1699:
1700: -- if other tables other than the standard tables are used in
1701: -- the input expression we will retain the select statment in
1702: -- get input othewise we will replace it with a expression using
1703: -- global variable which are prepopulated in calculate_quota
1704: IF g_other_tabused_tbl(l_mul_input.calc_sql_exp_id) = 'Y' THEN

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

2054: construct_sql_from_where(l_output_sql_select, l_output_sql_from, l_output_sql_where);
2055: handle_output_sql_select(l_output_sql_select, l_output_sql_from, l_output_sql_where);
2056:
2057: -- Added for 11.5.10 Performance Enhancments
2058: -- if other tables other than the standard tables are used in
2059: -- the output expression we will retain the select statment in
2060: -- otherwise Replace the select with a expression which uses
2061: -- the prefetched column values held in record variables
2062:

Line 5099: -- Standard Start of API savepoint

5095: -- END Declaration for bug 12330815
5096:
5097:
5098: BEGIN
5099: -- Standard Start of API savepoint
5100: SAVEPOINT generate_formula;
5101:
5102: -- ADDED for bug 14230033
5103: IF ( ad_zd.get_edition('PATCH') IS NOT NULL ) THEN

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

5110: x_msg_data := 'AD_ZD_DISABLED_FEATURE';
5111: RETURN;
5112: END IF;
5113:
5114: -- Standard call to check for call compatibility.
5115: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5116: p_api_version ,
5117: l_api_name ,
5118: G_PKG_NAME )

Line 5274: -- Standard check of p_commit.

5270: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5271: 'End of generate_formula');
5272: end if;
5273:
5274: -- Standard check of p_commit.
5275: IF FND_API.To_Boolean( p_commit ) THEN
5276: COMMIT WORK;
5277: END IF;
5278:

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

5275: IF FND_API.To_Boolean( p_commit ) THEN
5276: COMMIT WORK;
5277: END IF;
5278:
5279: -- Standard call to get message count and if count is 1, get message info.
5280: FND_MSG_PUB.Count_And_Get
5281: ( p_count => x_msg_count ,
5282: p_data => x_msg_data ,
5283: p_encoded => FND_API.G_FALSE