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.

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 1682: IF g_trx_group_code = 'INDIVIDUAL' THEN

1678: cn_utils.appindcr(body_code, ' l_itd_target NUMBER;');
1679: cn_utils.appendcr(body_code);
1680: cn_utils.appendcr(body_code, 'BEGIN');
1681:
1682: IF g_trx_group_code = 'INDIVIDUAL' THEN
1683: l_counter := 1;
1684: FOR l_mul_input IN l_mul_inputs_csr LOOP
1685: OPEN dim_type(l_mul_input.rate_dim_sequence);
1686: FETCH dim_type INTO l_dim_unit_code;

Line 1770: -- so select expression from dual;

1766: END IF;
1767: END IF;
1768: END LOOP;
1769: -- if non plsq function like DECODE is used we cannot use just an expression
1770: -- so select expression from dual;
1771: IF g_non_plsql_func_used_tbl(l_mul_input.calc_sql_exp_id) = 'N' THEN
1772: -- fix for bug 3187576
1773: --cn_utils.appindcr(body_code,REPLACE(l_input_sql_select,'select',NULL)||';');
1774: split_long_sql( body_code, REPLACE(l_input_sql_select,'select',NULL)||';', 'SELECT');

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

1782: cn_utils.appindcr(body_code, ' into l_input_string ');
1783: ELSE
1784: cn_utils.appindcr(body_code, ' into l_input ');
1785: END IF;
1786: cn_utils.appindcr(body_code, ' FROM DUAL; ');
1787: END IF;
1788: END IF;
1789:
1790: cn_utils.appendcr(body_code);

Line 1871: g_trx_group_code := 'INDIVIDUAL';

1867: ELSE -- g_trx_group_code = 'GROUP'
1868: cn_utils.appindcr(body_code, ' IF p_commission_line_id IS NOT NULL THEN ');
1869: cn_utils.appendcr(body_code);
1870:
1871: g_trx_group_code := 'INDIVIDUAL';
1872: l_counter :=1;
1873: FOR l_mul_input IN l_mul_inputs_csr LOOP
1874: l_input_sql_where := 'WHERE 1=1 ';
1875:

Line 2036: IF g_trx_group_code = 'INDIVIDUAL' THEN

2032: cn_utils.appindcr(body_code, ' l_output NUMBER;');
2033: cn_utils.appendcr(body_code);
2034: cn_utils.appendcr(body_code, 'BEGIN');
2035:
2036: IF g_trx_group_code = 'INDIVIDUAL' THEN
2037: OPEN l_sql_select_from_csr;
2038: FETCH l_sql_select_from_csr INTO l_out_calc_sql_exp_id,l_output_sql_select_clob, l_output_sql_from_clob;
2039: CLOSE l_sql_select_from_csr;
2040:

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

2107: -- fix for bug 3187576
2108: --cn_utils.appindcr(body_code,REPLACE(l_output_sql_select,'select',NULL));
2109: split_long_sql( body_code, REPLACE(l_output_sql_select,'select',NULL), 'SELECT');
2110: cn_utils.appindcr(body_code, ' into l_commission ');
2111: cn_utils.appindcr(body_code, ' FROM DUAL; ');
2112: END IF;
2113: END IF;
2114:
2115: cn_utils.appendcr(body_code);

Line 2143: g_trx_group_code := 'INDIVIDUAL';

2139: ELSE -- group by case
2140: cn_utils.appindcr(body_code, ' IF p_commission_line_id IS NOT NULL THEN ');
2141: cn_utils.appendcr(body_code);
2142: -- construct the code for testing trx by trx
2143: g_trx_group_code := 'INDIVIDUAL';
2144: l_output_sql_where := 'WHERE 1=1 ';
2145:
2146: OPEN l_sql_select_from_csr;
2147: FETCH l_sql_select_from_csr INTO l_out_calc_sql_exp_id,l_output_sql_select_clob, l_output_sql_from_clob;

Line 2289: IF g_trx_group_code = 'INDIVIDUAL' THEN

2285: cn_utils.appindcr(body_code, ' l_perf NUMBER;');
2286: cn_utils.appendcr(body_code);
2287: cn_utils.appendcr(body_code, 'BEGIN');
2288:
2289: IF g_trx_group_code = 'INDIVIDUAL' THEN
2290: IF g_perf_measure_id IS NOT NULL THEN
2291: OPEN l_perf_select_from_csr;
2292: FETCH l_perf_select_from_csr
2293: INTO l_perf_sql_select_clob, l_perf_sql_from_clob;

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

2364: -- fix for bug 3187576
2365: --cn_utils.appindcr(body_code,REPLACE(l_perf_sql_select,'select',NULL));
2366: split_long_sql( body_code, REPLACE(l_perf_sql_select,'select',NULL), 'SELECT');
2367: cn_utils.appindcr(body_code, ' into l_perf ');
2368: cn_utils.appindcr(body_code, ' FROM DUAL; ');
2369: END IF;
2370: END IF;
2371: cn_utils.appindcr(body_code, ' l_perf := nvl(l_perf, 0); ');
2372: ELSE -- group by case

Line 2376: g_trx_group_code := 'INDIVIDUAL';

2372: ELSE -- group by case
2373: cn_utils.appindcr(body_code, ' IF p_commission_line_id IS NOT NULL THEN ');
2374: cn_utils.appendcr(body_code);
2375: -- construct the code for testing trx by trx
2376: g_trx_group_code := 'INDIVIDUAL';
2377: l_perf_sql_where := 'WHERE 1=1 ';
2378:
2379: IF g_perf_measure_id IS NOT NULL THEN
2380: OPEN l_perf_select_from_csr;

Line 2603: -- construct the cursor for individual case

2599: cn_utils.appindcr(body_code, ' l_rollover );');
2600: cn_utils.appendcr(body_code);
2601: END calc_roll;
2602:
2603: -- construct the cursor for individual case
2604: PROCEDURE individual_cursor (spec_code IN OUT NOCOPY cn_utils.code_type,
2605: body_code IN OUT NOCOPY cn_utils.code_type ) IS
2606: BEGIN
2607: cn_utils.appendcr(body_code);

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

2600: cn_utils.appendcr(body_code);
2601: END calc_roll;
2602:
2603: -- construct the cursor for individual case
2604: PROCEDURE individual_cursor (spec_code IN OUT NOCOPY cn_utils.code_type,
2605: body_code IN OUT NOCOPY cn_utils.code_type ) IS
2606: BEGIN
2607: cn_utils.appendcr(body_code);
2608: cn_utils.appindcr(body_code, ' CURSOR l_lines_csr IS ');

Line 2654: END individual_cursor;

2650: cn_utils.appindcr(body_code, ' ORDER by cl.processed_date asc ');
2651: cn_utils.appindcr(body_code, ' ,cl.commission_line_id asc ');
2652: cn_utils.appindcr(body_code, ' ; ');
2653: cn_utils.appendcr(body_code);
2654: END individual_cursor;
2655:
2656: -- construct the code to update global variables
2657: PROCEDURE update_variables(spec_code IN OUT NOCOPY cn_utils.code_type,
2658: body_code IN OUT NOCOPY cn_utils.code_type )

Line 2753: individual_cursor(spec_code, body_code);

2749: cn_utils.appendcr(body_code);
2750:
2751: -- constrcut the cursor to loop through trxs
2752: IF (NOT(g_no_trx_flag)) THEN
2753: individual_cursor(spec_code, body_code);
2754: END IF;
2755:
2756:
2757: -- Added for 11.5.10 Performance Enhancments

Line 2760: IF g_trx_group_code = 'INDIVIDUAL' THEN

2756:
2757: -- Added for 11.5.10 Performance Enhancments
2758: -- Declare cursors which will fetch all columns of tables
2759: -- used in input/output/perf expressions.
2760: IF g_trx_group_code = 'INDIVIDUAL' THEN
2761: l_table_object_id := g_uniq_tbl_names_tbl.FIRST;
2762: FOR l_counter IN 1..g_uniq_tbl_names_tbl.COUNT LOOP
2763: IF INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_LINES') = 0 AND
2764: INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_HEADERS') = 0 THEN

Line 2803: IF g_trx_group_code = 'INDIVIDUAL' THEN

2799:
2800: -- Added for 11.5.10 Performance Enhancments
2801: -- Declare open fetch statment which will fetch all columns of tables
2802: -- used in input/output/perf expressions.into global variables
2803: IF g_trx_group_code = 'INDIVIDUAL' THEN
2804: l_table_object_id := g_uniq_tbl_names_tbl.FIRST;
2805: FOR l_counter IN 1..g_uniq_tbl_names_tbl.COUNT LOOP
2806: IF INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_LINES') = 0 AND
2807: INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_HEADERS') = 0 THEN

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

2822: END LOOP;
2823: END IF;
2824:
2825:
2826: IF (g_trx_group_code = 'INDIVIDUAL' AND NOT(g_no_trx_flag)) THEN
2827: -- for individual case we don't need to accumulate output_achieved
2828: cn_utils.appindcr(body_code, ' Open l_lines_csr; ');
2829: cn_utils.appindcr(body_code, ' LOOP ');
2830: cn_utils.appindcr(body_code, ' l_trx_rec_new := l_trx_rec_null; ');

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

2823: END IF;
2824:
2825:
2826: IF (g_trx_group_code = 'INDIVIDUAL' AND NOT(g_no_trx_flag)) THEN
2827: -- for individual case we don't need to accumulate output_achieved
2828: cn_utils.appindcr(body_code, ' Open l_lines_csr; ');
2829: cn_utils.appindcr(body_code, ' LOOP ');
2830: cn_utils.appindcr(body_code, ' l_trx_rec_new := l_trx_rec_null; ');
2831: cn_utils.appindcr(body_code, ' FETCH l_lines_csr into g_commission_rec; ');

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

2923: END IF;
2924: IF g_itd_flag = 'Y' THEN
2925: cn_utils.appindcr(body_code, ' l_trx_rec_new.output_achieved := g_output_achieved ; ');
2926: ELSE
2927: -- output_achieved = 0 since no need to accumulate output for individual non itd case
2928: cn_utils.appindcr(body_code, ' l_trx_rec_new.output_achieved := 0 ; ');
2929: END IF;
2930: cn_utils.appindcr(body_code, ' l_trx_rec_new.perf_achieved := l_perf ; ');
2931: cn_utils.appendcr(body_code);

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

3443: END IF;
3444: IF g_itd_flag = 'Y' THEN
3445: cn_utils.appindcr(body_code, ' l_trx_rec_new.output_achieved := g_output_achieved ; ');
3446: ELSE
3447: -- output_achieved = 0 since no need to accumulate output for individual non itd case
3448: cn_utils.appindcr(body_code, ' l_trx_rec_new.output_achieved := 0 ; ');
3449: END IF;
3450: cn_utils.appindcr(body_code, ' l_trx_rec_new.perf_achieved := l_perf ; ');
3451: cn_utils.appendcr(body_code);

Line 3584: IF g_trx_group_code = 'INDIVIDUAL' THEN

3580:
3581: -- Added for 11.5.10 Performance Enhancments
3582: -- Declare cursors which will fetch all columns of tables
3583: -- used in input/output/perf expressions.
3584: IF g_trx_group_code = 'INDIVIDUAL' THEN
3585: l_table_object_id := g_uniq_tbl_names_tbl.FIRST;
3586: FOR l_counter IN 1..g_uniq_tbl_names_tbl.COUNT LOOP
3587: IF INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_LINES') = 0 AND
3588: INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_HEADERS') = 0 THEN

Line 3632: IF g_trx_group_code = 'INDIVIDUAL' THEN

3628:
3629: -- Added for 11.5.10 Performance Enhancments
3630: -- Declare fetch statment which will fetch all columns of tables
3631: -- used in input/output/perf expressions.
3632: IF g_trx_group_code = 'INDIVIDUAL' THEN
3633: l_table_object_id := g_uniq_tbl_names_tbl.FIRST;
3634: FOR l_counter IN 1..g_uniq_tbl_names_tbl.COUNT LOOP
3635: IF INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_LINES') = 0 AND
3636: INSTR(g_uniq_tbl_names_tbl(l_table_object_id).table_name,'CN_COMMISSION_HEADERS') = 0 THEN

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

3648: l_table_object_id := g_uniq_tbl_names_tbl.NEXT(l_table_object_id);
3649: END LOOP;
3650: END IF;
3651:
3652: IF g_trx_group_code = 'INDIVIDUAL' AND g_itd_flag = 'N' AND g_cumulative_flag = 'N' THEN
3653: cn_utils.appindcr(body_code, ' get_input(p_commission_line_id, p_salesrep_id, ');
3654: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id, ');
3655: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, p_processed_date, ');
3656: cn_utils.appindcr(body_code, ' l_mul_input_tbl );');

Line 4659: FROM dual;

4655: 'CSQA.PAYMENT_AMOUNT', 'payment_amount',
4656: l_segment_orig
4657: )
4658: INTO l_segment
4659: FROM dual;
4660:
4661: IF l_segment_orig = l_segment THEN
4662: l_segment := '1';
4663: END IF;

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

4933: 'After generating calculate_bonus_quota in create_formula');
4934: end if;
4935: END IF;
4936:
4937: IF (g_trx_group_code = 'INDIVIDUAL' AND g_itd_flag = 'N' AND g_cumulative_flag = 'N' AND g_formula_type = 'C') THEN
4938: get_result(spec_code, body_code);
4939: cn_message_pkg.debug( 'after get_result ');
4940: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4941: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 5157: FROM dual;

5153: -- start usage of ad_ddl from bug 12330815 ( repalce dbms_sql with ad_ddl)
5154:
5155: SELECT user
5156: INTO l_applsys_schema
5157: FROM dual;
5158:
5159: FOR c_pkg_spec IN pkg_object_id(l_formula_name, 'PKS', g_org_id) LOOP
5160:
5161: OPEN pkg_start(c_pkg_spec.object_id, g_org_id);