APPS.ASO_BI_LINE_FACT_PVT dependencies on ASO_BI_QUOTE_LINES_ALL

Line 15: 'ASO_BI_QUOTE_LINES_ALL table');

11: BEGIN
12:
13: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
14: BIS_COLLECTION_UTILITIES.Debug('Start deleting the updated rows from ' ||
15: 'ASO_BI_QUOTE_LINES_ALL table');
16: END IF;
17:
18: DELETE FROM ASO_BI_QUOTE_LINES_ALL qlin
19: WHERE qlin.quote_number IN (

Line 18: DELETE FROM ASO_BI_QUOTE_LINES_ALL qlin

14: BIS_COLLECTION_UTILITIES.Debug('Start deleting the updated rows from ' ||
15: 'ASO_BI_QUOTE_LINES_ALL table');
16: END IF;
17:
18: DELETE FROM ASO_BI_QUOTE_LINES_ALL qlin
19: WHERE qlin.quote_number IN (
20: SELECT quote_number
21: FROM ASO_BI_QUOTE_IDS
22: );

Line 26: 'ASO_BI_QUOTE_LINES_ALL table');

22: );
23:
24: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
25: BIS_COLLECTION_UTILITIES.Debug('Deleted the updated rows from '||
26: 'ASO_BI_QUOTE_LINES_ALL table');
27: END IF;
28:
29: COMMIT;
30: END Cleanup_Line_Data;

Line 405: -- Initial Load of ASO_BI_QUOTE_LINES_ALL

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
406: -- Called as a part of initial load of quote lines
407: Procedure InitiLoad_QotLine
408: As
409: l_user_id number;

Line 424: INTO ASO_BI_QUOTE_LINES_ALL QOT_LINES_ALL

420: END IF;
421:
422: EXECUTE IMMEDIATE
423: 'INSERT/*+ APPEND PARALLEL(QOT_LINES_ALL)*/
424: INTO ASO_BI_QUOTE_LINES_ALL QOT_LINES_ALL
425: ( quote_header_id,
426: quote_number,
427: quote_version,
428: quote_creation_date,

Line 541: INTO ASO_BI_QUOTE_LINES_ALL QOT_LINES_ALL

537: COMMIT;
538:
539: EXECUTE IMMEDIATE
540: 'INSERT/*+ APPEND PARALLEL(QOT_LINES_ALL)*/
541: INTO ASO_BI_QUOTE_LINES_ALL QOT_LINES_ALL
542: ( quote_header_id,
543: quote_number,
544: quote_version,
545: quote_creation_date,

Line 656: -- Inserts Records into ASO_BI_QUOTE_LINES_ALL reading from

652:
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;

Line 673: 'INSERT/*+ append */ INTO ASO_BI_QUOTE_LINES_ALL

669: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote Line fact');
670: END IF;
671:
672: EXECUTE IMMEDIATE
673: 'INSERT/*+ append */ INTO ASO_BI_QUOTE_LINES_ALL
674: ( quote_header_id,
675: quote_number,
676: quote_version,
677: quote_creation_date,

Line 790: 'INSERT/*+ append */ INTO ASO_BI_QUOTE_LINES_ALL

786:
787: COMMIT;
788:
789: EXECUTE IMMEDIATE
790: 'INSERT/*+ append */ INTO ASO_BI_QUOTE_LINES_ALL
791: ( quote_header_id,
792: quote_number,
793: quote_version,
794: quote_creation_date,