APPS.IBE_BI_STR_MIG_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 9: minisite_id aso_quote_headers_all.minisite_id%TYPE,

5: g_start_dt DATE := SYSDATE;
6:
7:
8: type g_org_mapping is RECORD(
9: minisite_id aso_quote_headers_all.minisite_id%TYPE,
10: org_id aso_quote_headers_all.org_id%TYPE,
11: minisite_name ibe_msites_vl.msite_name%TYPE,
12: org_name hr_operating_units.name%TYPE ,
13: is_valid_org varchar2(1),

Line 10: org_id aso_quote_headers_all.org_id%TYPE,

6:
7:
8: type g_org_mapping is RECORD(
9: minisite_id aso_quote_headers_all.minisite_id%TYPE,
10: org_id aso_quote_headers_all.org_id%TYPE,
11: minisite_name ibe_msites_vl.msite_name%TYPE,
12: org_name hr_operating_units.name%TYPE ,
13: is_valid_org varchar2(1),
14: is_valid_str varchar2(1),

Line 454: FROM aso_quote_headers_all QHDR,

450: qlin.minisite_id msite2,
451: decode(NVL(qlin.minisite_id,-999) , -999, NULL, 'LINE') qtype,
452: qhdr.currency_code,
453: RANK() OVER (PARTITION BY qhdr.quote_header_id ORDER BY qlin.quote_line_id ASC NULLS LAST) RANK
454: FROM aso_quote_headers_all QHDR,
455: aso_quote_lines_all QLIN,
456: hz_parties hp
457: WHERE qhdr.quote_header_id = qlin.quote_header_id(+)
458: AND (qhdr.quote_source_code like 'IStore%' or qhdr.publish_flag = 'Y')

Line 522: FROM aso_quote_headers_all QHDR,

518: qlin.minisite_id msite2,
519: decode(NVL(qlin.minisite_id,-999) , -999, NULL, 'LINE') qtype,
520: qhdr.currency_code,
521: RANK() OVER (PARTITION BY qhdr.quote_header_id ORDER BY qlin.quote_line_id ASC NULLS LAST) RANK
522: FROM aso_quote_headers_all QHDR,
523: aso_quote_lines_all QLIN,
524: hz_parties hp
525: WHERE qhdr.quote_header_id = qlin.quote_header_id(+)
526: AND (qhdr.quote_source_code like 'IStore%' or qhdr.publish_flag = 'Y')

Line 583: from aso_quote_headers_all qhdr,

579: fnd_global.conc_request_id ,
580: fnd_global.prog_appl_id,
581: fnd_global.conc_program_id ,
582: SYSDATE
583: from aso_quote_headers_all qhdr,
584: hz_parties hp
585: where (qhdr.quote_source_code like 'IStore%' OR qhdr.publish_flag = 'Y')
586: AND qhdr.party_id = hp.party_id ;
587: ELSE

Line 634: from aso_quote_headers_all qhdr,

630: fnd_global.conc_request_id ,
631: fnd_global.prog_appl_id,
632: fnd_global.conc_program_id ,
633: SYSDATE
634: from aso_quote_headers_all qhdr,
635: hz_parties hp
636: where (qhdr.quote_source_code like 'IStore%' OR qhdr.publish_flag = 'Y')
637: AND qhdr.party_id = hp.party_id
638: AND qhdr.minisite_id IS NULL;

Line 854: -- Procedure update_quote api to update aso_quote_headers_all

850:
851:
852:
853: --====================================================================
854: -- Procedure update_quote api to update aso_quote_headers_all
855: --====================================================================
856:
857: PROCEDURE update_quote (p_batch_size IN NUMBER) IS
858: CURSOR LogCursor IS

Line 866: TYPE MsiteTab IS TABLE OF ASO_QUOTE_HEADERS_ALL.MINISITE_ID%TYPE;

862: WHERE migration_code = 'IBE_MINISITE_MIGRATION'
863: AND migration_mode = 'EVALUATE'
864: AND run_sequence = 0;
865:
866: TYPE MsiteTab IS TABLE OF ASO_QUOTE_HEADERS_ALL.MINISITE_ID%TYPE;
867: TYPE QuoteHeaderTab IS TABLE OF ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID%TYPE;
868:
869: MsiteTable MsiteTab;
870: QuoteHeaderTable QuoteHeaderTab;

Line 867: TYPE QuoteHeaderTab IS TABLE OF ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID%TYPE;

863: AND migration_mode = 'EVALUATE'
864: AND run_sequence = 0;
865:
866: TYPE MsiteTab IS TABLE OF ASO_QUOTE_HEADERS_ALL.MINISITE_ID%TYPE;
867: TYPE QuoteHeaderTab IS TABLE OF ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID%TYPE;
868:
869: MsiteTable MsiteTab;
870: QuoteHeaderTable QuoteHeaderTab;
871: k Number :=0;

Line 888: UPDATE aso_quote_headers_all

884: EXIT;
885: END IF;
886:
887: FORALL i in QuoteHeaderTable.First..QuoteHeaderTable.Last
888: UPDATE aso_quote_headers_all
889: SET minisite_id = MsiteTable(i)
890: WHERE quote_header_id = QuoteHeaderTable(i);
891:
892: EXIT WHEN LogCursor%NOTFOUND;

Line 1225: WHERE exists (SELECT qhdr.org_id FROM aso_quote_headers_all qhdr

1221:
1222:
1223: CURSOR c_valid_orgs is
1224: SELECT organization_id, name FROM hr_operating_units OU
1225: WHERE exists (SELECT qhdr.org_id FROM aso_quote_headers_all qhdr
1226: WHERE ou.organization_id = qhdr.org_id);
1227:
1228: CURSOR c_valid_str is
1229: SELECT distinct MSITE_ID,