[Home] [Help]
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,
151: quote_number,
152: quote_version,
153: quote_creation_date,
262: END IF;
263:
264: COMMIT;
265:
266: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_QUOTE_LINES_STG');
267:
268: End InitiLoad_QotLineStg ;
269:
270:
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,
291: quote_version,
292: quote_creation_date,
397: END IF;
398:
399: COMMIT;
400:
401: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_QUOTE_LINES_STG');
402:
403: END Populate_Qot_Line_Fact_Stg;
404:
405: -- Initial Load of ASO_BI_QUOTE_LINES_ALL
525: ORDER BY config_item_id ASC
526: ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
527: Top_Organization_Id,
528: qlinstg.Charge_periodicity_code
529: FROM ASO_BI_QUOTE_LINES_STG qlinstg
530: WHERE Config_Header_Id IS NOT NULL'
531: USING l_sysdate,
532: l_user_id,
533: l_sysdate,
634: qlinstg.order_creation_date,
635: Inventory_item_id Top_Inventory_Item_Id,
636: Organization_id Top_Organization_Id,
637: qlinstg.Charge_periodicity_code
638: FROM ASO_BI_QUOTE_LINES_STG qlinstg
639: WHERE Config_Header_Id IS NULL'
640: USING l_sysdate,
641: l_user_id,
642: l_sysdate,
653: End InitiLoad_QotLine ;
654:
655:
656: -- Inserts Records into ASO_BI_QUOTE_LINES_ALL reading from
657: -- ASO_BI_QUOTE_LINES_STG table.
658: PROCEDURE Populate_Line_data AS
659: l_user_id number;
660: l_login_id number;
661: l_sysdate date;
775: ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
776: Top_Organization_Id,
777: qlinstg.Charge_periodicity_code
778: FROM
779: ASO_BI_QUOTE_LINES_STG qlinstg
780: WHERE Config_Header_Id IS NOT NULL'
781: USING l_sysdate,
782: l_user_id,
783: l_sysdate,
884: Inventory_item_id Top_Inventory_Item_Id,
885: Organization_id Top_Organization_Id,
886: qlinstg.Charge_periodicity_code
887: FROM
888: ASO_BI_QUOTE_LINES_STG qlinstg
889: WHERE Config_Header_Id IS NULL'
890: USING l_sysdate,
891: l_user_id,
892: l_sysdate,
904:
905:
906:
907: -- This procedure is called as a part of incremental load of quote lines.
908: -- Populates ASO_BI_QUOTE_LINES_STG table
909: PROCEDURE Line_Worker(
910: Errbuf IN OUT NOCOPY VARCHAR2,
911: Retcode IN OUT NOCOPY NUMBER,
912: p_worker_no IN NUMBER)