APPS.QRM_PA_AGGREGATION_P dependencies on QRM_VARCHAR_TABLE

Line 54: p_col_seq_no_key IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

50: p_date_type VARCHAR2,
51: p_calendar_id NUMBER,
52: p_business_week VARCHAR2,
53: p_col_seq_no IN OUT NOCOPY XTR_MD_NUM_TABLE,
54: p_col_seq_no_key IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
55: p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
56: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
57: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
58: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,

Line 55: p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

51: p_calendar_id NUMBER,
52: p_business_week VARCHAR2,
53: p_col_seq_no IN OUT NOCOPY XTR_MD_NUM_TABLE,
54: p_col_seq_no_key IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
55: p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
56: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
57: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
58: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
59: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

Line 56: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

52: p_business_week VARCHAR2,
53: p_col_seq_no IN OUT NOCOPY XTR_MD_NUM_TABLE,
54: p_col_seq_no_key IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
55: p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
56: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
57: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
58: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
59: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
60: p_start_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,

Line 57: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

53: p_col_seq_no IN OUT NOCOPY XTR_MD_NUM_TABLE,
54: p_col_seq_no_key IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
55: p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
56: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
57: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
58: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
59: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
60: p_start_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
61: p_end_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,

Line 59: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

55: p_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
56: p_percent_col_name_map IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
57: p_a1 IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
58: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
59: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
60: p_start_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
61: p_end_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
62: p_tb_label_arr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE);
63:

Line 62: p_tb_label_arr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE);

58: p_col_type IN OUT NOCOPY XTR_MD_NUM_TABLE,
59: p_col_hidden IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
60: p_start_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
61: p_end_date IN OUT NOCOPY SYSTEM.QRM_DATE_TABLE,
62: p_tb_label_arr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE);
63:
64:
65: FUNCTION update_total (p_name VARCHAR2,
66: p_ref_date DATE)

Line 87: p_att_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

83:
84: FUNCTION update_label(p_name VARCHAR2,
85: p_agg IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
86: p_col_order IN OUT NOCOPY XTR_MD_NUM_TABLE,
87: p_att_type IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
88: p_ref_date DATE)
89: RETURN BOOLEAN;
90:
91:

Line 100: p_tot_avg SYSTEM.QRM_VARCHAR_TABLE,

96: p_last_run_date DATE,
97: p_md_set_code VARCHAR2,
98: p_dirty VARCHAR2,
99: p_end_date_fix DATE,
100: p_tot_avg SYSTEM.QRM_VARCHAR_TABLE,
101: p_ccy_multiplier OUT NOCOPY NUMBER,
102: p_att_name IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
103: p_total OUT NOCOPY XTR_MD_NUM_TABLE,
104: p_table_col_curr OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

Line 104: p_table_col_curr OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,

100: p_tot_avg SYSTEM.QRM_VARCHAR_TABLE,
101: p_ccy_multiplier OUT NOCOPY NUMBER,
102: p_att_name IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
103: p_total OUT NOCOPY XTR_MD_NUM_TABLE,
104: p_table_col_curr OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
105: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE,
106: p_analysis_type VARCHAR2,
107: p_business_week VARCHAR2,
108: p_amount SYSTEM.QRM_VARCHAR_TABLE);--17

Line 105: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE,

101: p_ccy_multiplier OUT NOCOPY NUMBER,
102: p_att_name IN OUT NOCOPY SYSTEM.QRM_VARCHAR240_TABLE,
103: p_total OUT NOCOPY XTR_MD_NUM_TABLE,
104: p_table_col_curr OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
105: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE,
106: p_analysis_type VARCHAR2,
107: p_business_week VARCHAR2,
108: p_amount SYSTEM.QRM_VARCHAR_TABLE);--17
109:

Line 108: p_amount SYSTEM.QRM_VARCHAR_TABLE);--17

104: p_table_col_curr OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
105: p_sensitivity SYSTEM.QRM_VARCHAR_TABLE,
106: p_analysis_type VARCHAR2,
107: p_business_week VARCHAR2,
108: p_amount SYSTEM.QRM_VARCHAR_TABLE);--17
109:
110:
111: FUNCTION update_aggregate_curr(p_name VARCHAR2,
112: p_ref_date DATE,

Line 121: p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE)

117: p_max_col_no NUMBER,
118: p_underlying_ccy VARCHAR2,
119: p_currency_source VARCHAR2,
120: p_curr_reporting VARCHAR2,
121: p_agg_col_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE)
122: RETURN BOOLEAN;
123:
124: FUNCTION update_timebuckets_label(p_name VARCHAR2)
125: RETURN BOOLEAN;