DBA Data[Home] [Help]

APPS.QRM_PA_AGGREGATION_P dependencies on QRM_DATE_TABLE

Line 1405: v_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

1401: --'OA' if called from OA
1402: --'CONC' if called from Concurrent Program
1403: RETURN VARCHAR2 IS --'T' if success or 'F' for unsuccessful
1404:
1405: v_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
1406: v_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
1407: v_col SYSTEM.QRM_VARCHAR_table;
1408: v_col_seq_no xtr_md_num_table := xtr_md_num_table();
1409: v_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

Line 1406: v_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

1402: --'CONC' if called from Concurrent Program
1403: RETURN VARCHAR2 IS --'T' if success or 'F' for unsuccessful
1404:
1405: v_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
1406: v_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
1407: v_col SYSTEM.QRM_VARCHAR_table;
1408: v_col_seq_no xtr_md_num_table := xtr_md_num_table();
1409: v_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();
1410: v_percent_col_name_map SYSTEM.QRM_VARCHAR_table := SYSTEM.QRM_VARCHAR_table();

Line 2905: p_start_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,

2901: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2902: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2903: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
2904: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2905: p_start_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
2906: p_end_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
2907: p_tb_label_arr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE) IS
2908:
2909: CURSOR v_tb_cursor IS

Line 2906: p_end_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,

2902: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2903: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
2904: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
2905: p_start_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
2906: p_end_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
2907: p_tb_label_arr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE) IS
2908:
2909: CURSOR v_tb_cursor IS
2910: SELECT interval_length, interval_type, label

Line 3068: v_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

3064: v_percent_col_name_map SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3065: v_a1 SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3066: v_col_type XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
3067: v_col_hidden SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3068: v_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
3069: v_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
3070: v_tb_label_arr SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3071: v_row_agg_no NUMBER := 0;
3072: v_max_col_no NUMBER;

Line 3069: v_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();

3065: v_a1 SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3066: v_col_type XTR_MD_NUM_TABLE := XTR_MD_NUM_TABLE();
3067: v_col_hidden SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3068: v_start_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
3069: v_end_date SYSTEM.QRM_DATE_TABLE := SYSTEM.QRM_DATE_TABLE();
3070: v_tb_label_arr SYSTEM.QRM_VARCHAR_TABLE := SYSTEM.QRM_VARCHAR_TABLE();
3071: v_row_agg_no NUMBER := 0;
3072: v_max_col_no NUMBER;
3073: