DBA Data[Home] [Help]

APPS.ASO_BI_LINE_FACT_PVT dependencies on BIS_COMMON_PARAMETERS

Line 78: l_batch_size:= bis_common_parameters.get_batch_size(

74: l_batch_size Number := 1000;
75: BEGIN
76:
77: /* For Transactions with Average Complexity */
78: l_batch_size:= bis_common_parameters.get_batch_size(
79: BIS_COMMON_PARAMETERS.MEDIUM);
80:
81: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
82: BIS_COLLECTION_UTILITIES.Debug('Started populating ASO_BI_LINE_IDS table');

Line 79: BIS_COMMON_PARAMETERS.MEDIUM);

75: BEGIN
76:
77: /* For Transactions with Average Complexity */
78: l_batch_size:= bis_common_parameters.get_batch_size(
79: BIS_COMMON_PARAMETERS.MEDIUM);
80:
81: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
82: BIS_COLLECTION_UTILITIES.Debug('Started populating ASO_BI_LINE_IDS table');
83: END IF;

Line 144: l_rate_type := bis_common_parameters.get_rate_type;

140: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
141: BIS_COLLECTION_UTILITIES.Debug('populating the Quote Lines Staging');
142: END IF;
143:
144: l_rate_type := bis_common_parameters.get_rate_type;
145: l_rpt_curr := bis_common_parameters.get_currency_code;
146: l_sec_currency := bis_common_parameters.get_secondary_currency_code;
147:
148:

Line 145: l_rpt_curr := bis_common_parameters.get_currency_code;

141: BIS_COLLECTION_UTILITIES.Debug('populating the Quote Lines Staging');
142: END IF;
143:
144: l_rate_type := bis_common_parameters.get_rate_type;
145: l_rpt_curr := bis_common_parameters.get_currency_code;
146: l_sec_currency := bis_common_parameters.get_secondary_currency_code;
147:
148:
149: INSERT/*+ APPEND PARALLEL(STG) */ INTO ASO_BI_QUOTE_LINES_STG STG

Line 146: l_sec_currency := bis_common_parameters.get_secondary_currency_code;

142: END IF;
143:
144: l_rate_type := bis_common_parameters.get_rate_type;
145: l_rpt_curr := bis_common_parameters.get_currency_code;
146: l_sec_currency := bis_common_parameters.get_secondary_currency_code;
147:
148:
149: INSERT/*+ APPEND PARALLEL(STG) */ INTO ASO_BI_QUOTE_LINES_STG STG
150: ( quote_header_id,

Line 284: l_rate_type := bis_common_parameters.get_rate_type;

280: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
281: BIS_COLLECTION_UTILITIES.Debug('Stared populating the Quote line fact Staging');
282: END IF;
283:
284: l_rate_type := bis_common_parameters.get_rate_type;
285: l_rpt_curr := bis_common_parameters.get_currency_code;
286: l_sec_currency := bis_common_parameters.get_secondary_currency_code;
287: -- Check for reporting currency null
288: INSERT/*+ append */ INTO ASO_BI_QUOTE_LINES_STG

Line 285: l_rpt_curr := bis_common_parameters.get_currency_code;

281: BIS_COLLECTION_UTILITIES.Debug('Stared populating the Quote line fact Staging');
282: END IF;
283:
284: l_rate_type := bis_common_parameters.get_rate_type;
285: l_rpt_curr := bis_common_parameters.get_currency_code;
286: l_sec_currency := bis_common_parameters.get_secondary_currency_code;
287: -- Check for reporting currency null
288: INSERT/*+ append */ INTO ASO_BI_QUOTE_LINES_STG
289: ( quote_header_id,

Line 286: l_sec_currency := bis_common_parameters.get_secondary_currency_code;

282: END IF;
283:
284: l_rate_type := bis_common_parameters.get_rate_type;
285: l_rpt_curr := bis_common_parameters.get_currency_code;
286: l_sec_currency := bis_common_parameters.get_secondary_currency_code;
287: -- Check for reporting currency null
288: INSERT/*+ append */ INTO ASO_BI_QUOTE_LINES_STG
289: ( quote_header_id,
290: quote_number,