eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CN_FORMULA_GEN_PKG dependencies on DUAL

Line 610: SELECT user INTO X_userid FROM sys.dual;

606: description cn_obj_procedures_v.description%TYPE)
607: IS
608: X_userid VARCHAR2(20);
609: BEGIN
610: SELECT user INTO X_userid FROM sys.dual;
611:
612: cn_utils.appendcr(code, '--');
613: cn_utils.appendcr(code, '-- Procedure Name');
614: cn_utils.appendcr(code, '-- ' || procedure_name);

Line 981: -- for individual transaction

977: BEGIN
978: -- Check if cn_commission_lines in FROM clause
979: l_line_alias := get_table_alias (x_sql_from, 'cn_commission_lines');
980: IF l_line_alias IS NOT NULL THEN
981: -- for individual transaction
982: IF g_trx_group_code = 'INDIVIDUAL' THEN
983: l_sql_stmt := ' and ' || l_line_alias || '.commission_line_id = p_commission_line_id';
984:
985: IF NOT check_sql_stmt_existence(x_sql_where, l_sql_stmt) THEN

Line 982: IF g_trx_group_code = 'INDIVIDUAL' THEN

978: -- Check if cn_commission_lines in FROM clause
979: l_line_alias := get_table_alias (x_sql_from, 'cn_commission_lines');
980: IF l_line_alias IS NOT NULL THEN
981: -- for individual transaction
982: IF g_trx_group_code = 'INDIVIDUAL' THEN
983: l_sql_stmt := ' and ' || l_line_alias || '.commission_line_id = p_commission_line_id';
984:
985: IF NOT check_sql_stmt_existence(x_sql_where, l_sql_stmt) THEN
986: x_sql_where := x_sql_where || l_sql_stmt;

Line 1035: -- for individual transaction

1031: l_line_alias := get_table_alias_from_cn('cn_commission_lines');
1032: x_sql_from := x_sql_from || ', cn_commission_lines ' || l_line_alias;
1033: END IF ;
1034:
1035: -- for individual transaction
1036: IF g_trx_group_code = 'INDIVIDUAL' THEN
1037: l_sql_stmt := ' and ' || l_line_alias || '.commission_line_id = p_commission_line_id';
1038:
1039: IF NOT check_sql_stmt_existence(x_sql_where, l_sql_stmt) THEN

Line 1036: IF g_trx_group_code = 'INDIVIDUAL' THEN

1032: x_sql_from := x_sql_from || ', cn_commission_lines ' || l_line_alias;
1033: END IF ;
1034:
1035: -- for individual transaction
1036: IF g_trx_group_code = 'INDIVIDUAL' THEN
1037: l_sql_stmt := ' and ' || l_line_alias || '.commission_line_id = p_commission_line_id';
1038:
1039: IF NOT check_sql_stmt_existence(x_sql_where, l_sql_stmt) THEN
1040: x_sql_where := x_sql_where || l_sql_stmt;

Line 1675: IF g_trx_group_code = 'INDIVIDUAL' THEN

1671: cn_utils.appindcr(body_code, ' l_itd_target NUMBER;');
1672: cn_utils.appendcr(body_code);
1673: cn_utils.appendcr(body_code, 'BEGIN');
1674:
1675: IF g_trx_group_code = 'INDIVIDUAL' THEN
1676: l_counter := 1;
1677: FOR l_mul_input IN l_mul_inputs_csr LOOP
1678: OPEN dim_type(l_mul_input.rate_dim_sequence);
1679: FETCH dim_type INTO l_dim_unit_code;

Line 1763: -- so select expression from dual;

1759: END IF;
1760: END IF;
1761: END LOOP;
1762: -- if non plsq function like DECODE is used we cannot use just an expression
1763: -- so select expression from dual;
1764: IF g_non_plsql_func_used_tbl(l_mul_input.calc_sql_exp_id) = 'N' THEN
1765: -- fix for bug 3187576
1766: --cn_utils.appindcr(body_code,REPLACE(l_input_sql_select,'select',NULL)||';');
1767: split_long_sql( body_code, REPLACE(l_input_sql_select,'select',NULL)||';', 'SELECT');

Line 1779: cn_utils.appindcr(body_code, ' FROM DUAL; ');

1775: cn_utils.appindcr(body_code, ' into l_input_string ');
1776: ELSE
1777: cn_utils.appindcr(body_code, ' into l_input ');
1778: END IF;
1779: cn_utils.appindcr(body_code, ' FROM DUAL; ');
1780: END IF;
1781: END IF;
1782:
1783: cn_utils.appendcr(body_code);

Line 1858: g_trx_group_code := 'INDIVIDUAL';

1854: ELSE -- g_trx_group_code = 'GROUP'
1855: cn_utils.appindcr(body_code, ' IF p_commission_line_id IS NOT NULL THEN ');
1856: cn_utils.appendcr(body_code);
1857:
1858: g_trx_group_code := 'INDIVIDUAL';
1859: l_counter :=1;
1860: FOR l_mul_input IN l_mul_inputs_csr LOOP
1861: l_input_sql_where := 'WHERE 1=1 ';
1862:

Line 2023: IF g_trx_group_code = 'INDIVIDUAL' THEN

2019: cn_utils.appindcr(body_code, ' l_output NUMBER;');
2020: cn_utils.appendcr(body_code);
2021: cn_utils.appendcr(body_code, 'BEGIN');
2022:
2023: IF g_trx_group_code = 'INDIVIDUAL' THEN
2024: OPEN l_sql_select_from_csr;
2025: FETCH l_sql_select_from_csr INTO l_out_calc_sql_exp_id,l_output_sql_select_clob, l_output_sql_from_clob;
2026: CLOSE l_sql_select_from_csr;
2027:

Line 2098: cn_utils.appindcr(body_code, ' FROM DUAL; ');

2094: -- fix for bug 3187576
2095: --cn_utils.appindcr(body_code,REPLACE(l_output_sql_select,'select',NULL));
2096: split_long_sql( body_code, REPLACE(l_output_sql_select,'select',NULL), 'SELECT');
2097: cn_utils.appindcr(body_code, ' into l_commission ');
2098: cn_utils.appindcr(body_code, ' FROM DUAL; ');
2099: END IF;
2100: END IF;
2101:
2102: cn_utils.appendcr(body_code);

Line 2130: g_trx_group_code := 'INDIVIDUAL';

2126: ELSE -- group by case
2127: cn_utils.appindcr(body_code, ' IF p_commission_line_id IS NOT NULL THEN ');
2128: cn_utils.appendcr(body_code);
2129: -- construct the code for testing trx by trx
2130: g_trx_group_code := 'INDIVIDUAL';
2131: l_output_sql_where := 'WHERE 1=1 ';
2132:
2133: OPEN l_sql_select_from_csr;
2134: FETCH l_sql_select_from_csr INTO l_out_calc_sql_exp_id,l_output_sql_select_clob, l_output_sql_from_clob;

Line 2276: IF g_trx_group_code = 'INDIVIDUAL' THEN

2272: cn_utils.appindcr(body_code, ' l_perf NUMBER;');
2273: cn_utils.appendcr(body_code);
2274: cn_utils.appendcr(body_code, 'BEGIN');
2275:
2276: IF g_trx_group_code = 'INDIVIDUAL' THEN
2277: IF g_perf_measure_id IS NOT NULL THEN
2278: OPEN l_perf_select_from_csr;
2279: FETCH l_perf_select_from_csr
2280: INTO l_perf_sql_select_clob, l_perf_sql_from_clob;

Line 2355: cn_utils.appindcr(body_code, ' FROM DUAL; ');

2351: -- fix for bug 3187576
2352: --cn_utils.appindcr(body_code,REPLACE(l_perf_sql_select,'select',NULL));
2353: split_long_sql( body_code, REPLACE(l_perf_sql_select,'select',NULL), 'SELECT');
2354: cn_utils.appindcr(body_code, ' into l_perf ');
2355: cn_utils.appindcr(body_code, ' FROM DUAL; ');
2356: END IF;
2357: END IF;
2358: cn_utils.appindcr(body_code, ' l_perf := nvl(l_perf, 0); ');
2359: ELSE -- group by case

Line 2363: g_trx_group_code := 'INDIVIDUAL';

2359: ELSE -- group by case
2360: cn_utils.appindcr(body_code, ' IF p_commission_line_id IS NOT NULL THEN ');
2361: cn_utils.appendcr(body_code);
2362: -- construct the code for testing trx by trx
2363: g_trx_group_code := 'INDIVIDUAL';
2364: l_perf_sql_where := 'WHERE 1=1 ';
2365:
2366: IF g_perf_measure_id IS NOT NULL THEN
2367: OPEN l_perf_select_from_csr;

Line 2590: -- construct the cursor for individual case

2586: cn_utils.appindcr(body_code, ' l_rollover );');
2587: cn_utils.appendcr(body_code);
2588: END calc_roll;
2589:
2590: -- construct the cursor for individual case
2591: PROCEDURE individual_cursor (spec_code IN OUT NOCOPY cn_utils.code_type,
2592: body_code IN OUT NOCOPY cn_utils.code_type ) IS
2593: BEGIN
2594: cn_utils.appendcr(body_code);

Line 2591: PROCEDURE individual_cursor (spec_code IN OUT NOCOPY cn_utils.code_type,

2587: cn_utils.appendcr(body_code);
2588: END calc_roll;
2589:
2590: -- construct the cursor for individual case
2591: PROCEDURE individual_cursor (spec_code IN OUT NOCOPY cn_utils.code_type,
2592: body_code IN OUT NOCOPY cn_utils.code_type ) IS
2593: BEGIN
2594: cn_utils.appendcr(body_code);
2595: cn_utils.appindcr(body_code, ' CURSOR l_lines_csr IS ');

Line 2641: END individual_cursor;

2637: cn_utils.appindcr(body_code, ' ORDER by cl.processed_date asc ');
2638: cn_utils.appindcr(body_code, ' ,cl.commission_line_id asc ');
2639: cn_utils.appindcr(body_code, ' ; ');
2640: cn_utils.appendcr(body_code);
2641: END individual_cursor;
2642:
2643: -- construct the code to update global variables
2644: PROCEDURE update_variables(spec_code IN OUT NOCOPY cn_utils.code_type,
2645: body_code IN OUT NOCOPY cn_utils.code_type )

Line 2740: individual_cursor(spec_code, body_code);

2736: cn_utils.appendcr(body_code);
2737:
2738: -- constrcut the cursor to loop through trxs
2739: IF (NOT(g_no_trx_flag)) THEN
2740: individual_cursor(spec_code, body_code);
2741: END IF;
2742:
2743:
2744: -- Added for 11.5.10 Performance Enhancments

Line 2747: IF g_trx_group_code = 'INDIVIDUAL' THEN

2743:
2744: -- Added for 11.5.10 Performance Enhancments
2745: -- Declare cursors which will fetch all columns of tables
2746: -- used in input/output/perf expressions.
2747: IF g_trx_group_code = 'INDIVIDUAL' THEN
2748: l_table_object_id := g_uniq_tbl_names_tbl.FIRST;
2749: FOR l_counter IN 1..g_uniq_tbl_names_tbl.COUNT LOOP
2750: IF INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_LINES') = 0 AND
2751: INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_HEADERS') = 0 THEN

Line 2790: IF g_trx_group_code = 'INDIVIDUAL' THEN

2786:
2787: -- Added for 11.5.10 Performance Enhancments
2788: -- Declare open fetch statment which will fetch all columns of tables
2789: -- used in input/output/perf expressions.into global variables
2790: IF g_trx_group_code = 'INDIVIDUAL' THEN
2791: l_table_object_id := g_uniq_tbl_names_tbl.FIRST;
2792: FOR l_counter IN 1..g_uniq_tbl_names_tbl.COUNT LOOP
2793: IF INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_LINES') = 0 AND
2794: INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_HEADERS') = 0 THEN

Line 2813: IF (g_trx_group_code = 'INDIVIDUAL' AND NOT(g_no_trx_flag)) THEN

2809: END LOOP;
2810: END IF;
2811:
2812:
2813: IF (g_trx_group_code = 'INDIVIDUAL' AND NOT(g_no_trx_flag)) THEN
2814: -- for individual case we don't need to accumulate output_achieved
2815: cn_utils.appindcr(body_code, ' Open l_lines_csr; ');
2816: cn_utils.appindcr(body_code, ' LOOP ');
2817: cn_utils.appindcr(body_code, ' l_trx_rec_new := l_trx_rec_null; ');

Line 2814: -- for individual case we don't need to accumulate output_achieved

2810: END IF;
2811:
2812:
2813: IF (g_trx_group_code = 'INDIVIDUAL' AND NOT(g_no_trx_flag)) THEN
2814: -- for individual case we don't need to accumulate output_achieved
2815: cn_utils.appindcr(body_code, ' Open l_lines_csr; ');
2816: cn_utils.appindcr(body_code, ' LOOP ');
2817: cn_utils.appindcr(body_code, ' l_trx_rec_new := l_trx_rec_null; ');
2818: cn_utils.appindcr(body_code, ' FETCH l_lines_csr into g_commission_rec; ');

Line 2914: -- output_achieved = 0 since no need to accumulate output for individual non itd case

2910: END IF;
2911: IF g_itd_flag = 'Y' THEN
2912: cn_utils.appindcr(body_code, ' l_trx_rec_new.output_achieved := g_output_achieved ; ');
2913: ELSE
2914: -- output_achieved = 0 since no need to accumulate output for individual non itd case
2915: cn_utils.appindcr(body_code, ' l_trx_rec_new.output_achieved := 0 ; ');
2916: END IF;
2917: cn_utils.appindcr(body_code, ' l_trx_rec_new.perf_achieved := l_perf ; ');
2918: cn_utils.appendcr(body_code);

Line 3434: -- output_achieved = 0 since no need to accumulate output for individual non itd case

3430: END IF;
3431: IF g_itd_flag = 'Y' THEN
3432: cn_utils.appindcr(body_code, ' l_trx_rec_new.output_achieved := g_output_achieved ; ');
3433: ELSE
3434: -- output_achieved = 0 since no need to accumulate output for individual non itd case
3435: cn_utils.appindcr(body_code, ' l_trx_rec_new.output_achieved := 0 ; ');
3436: END IF;
3437: cn_utils.appindcr(body_code, ' l_trx_rec_new.perf_achieved := l_perf ; ');
3438: cn_utils.appendcr(body_code);

Line 3571: IF g_trx_group_code = 'INDIVIDUAL' THEN

3567:
3568: -- Added for 11.5.10 Performance Enhancments
3569: -- Declare cursors which will fetch all columns of tables
3570: -- used in input/output/perf expressions.
3571: IF g_trx_group_code = 'INDIVIDUAL' THEN
3572: l_table_object_id := g_uniq_tbl_names_tbl.FIRST;
3573: FOR l_counter IN 1..g_uniq_tbl_names_tbl.COUNT LOOP
3574: IF INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_LINES') = 0 AND
3575: INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_HEADERS') = 0 THEN

Line 3619: IF g_trx_group_code = 'INDIVIDUAL' THEN

3615:
3616: -- Added for 11.5.10 Performance Enhancments
3617: -- Declare fetch statment which will fetch all columns of tables
3618: -- used in input/output/perf expressions.
3619: IF g_trx_group_code = 'INDIVIDUAL' THEN
3620: l_table_object_id := g_uniq_tbl_names_tbl.FIRST;
3621: FOR l_counter IN 1..g_uniq_tbl_names_tbl.COUNT LOOP
3622: IF INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_LINES') = 0 AND
3623: INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_HEADERS') = 0 THEN

Line 3639: IF g_trx_group_code = 'INDIVIDUAL' AND g_itd_flag = 'N' AND g_cumulative_flag = 'N' THEN

3635: l_table_object_id := g_uniq_tbl_names_tbl.NEXT(l_table_object_id);
3636: END LOOP;
3637: END IF;
3638:
3639: IF g_trx_group_code = 'INDIVIDUAL' AND g_itd_flag = 'N' AND g_cumulative_flag = 'N' THEN
3640: cn_utils.appindcr(body_code, ' get_input(p_commission_line_id, p_salesrep_id, ');
3641: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id, ');
3642: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, p_processed_date, ');
3643: cn_utils.appindcr(body_code, ' l_mul_input_tbl );');

Line 4646: FROM dual;

4642: 'CSQA.PAYMENT_AMOUNT', 'payment_amount',
4643: l_segment_orig
4644: )
4645: INTO l_segment
4646: FROM dual;
4647:
4648: IF l_segment_orig = l_segment THEN
4649: l_segment := '1';
4650: END IF;

Line 4913: IF (g_trx_group_code = 'INDIVIDUAL' AND g_itd_flag = 'N' AND g_cumulative_flag = 'N' AND g_formula_type = 'C') THEN

4909: 'After generating calculate_bonus_quota in create_formula');
4910: end if;
4911: END IF;
4912:
4913: IF (g_trx_group_code = 'INDIVIDUAL' AND g_itd_flag = 'N' AND g_cumulative_flag = 'N' AND g_formula_type = 'C') THEN
4914: get_result(spec_code, body_code);
4915: cn_message_pkg.debug( 'after get_result ');
4916: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4917: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,