APPS.BIC_CONSOLIDATE_CUST_DATA_PKG dependencies on BIC_PARTY_STATUS_SUMM

Line 726: update bic_party_status_summ

722: close c_measure_values;
723:
724: -- Begin statement is used for exception handling.
725: begin
726: update bic_party_status_summ
727: set acquisition = nvl(l_acquisition, acquisition),
728: activation = nvl(l_activation , activation ),
729: retention = nvl(l_retention , retention ),
730: life_cycle = nvl(l_life_cycle , life_cycle )

Line 735: insert into bic_party_status_summ (

731: where period_start_date = g_date
732: and party_id = g_party_id;
733:
734: if sql%notfound then
735: insert into bic_party_status_summ (
736: party_id ,
737: period_start_date,
738: ACQUISITION ,
739: ACTIVATION ,

Line 757: 'Error n bic_party_status_summ for party id:' ||

753: end if;
754: exception
755: when others then
756: fnd_file.put_line(fnd_file.log,
757: 'Error n bic_party_status_summ for party id:' ||
758: to_char(g_party_id) ||
759: ' date:' || to_char(g_date,'dd-mon-yyyy') || '-'||
760: substr(sqlerrm,1,200));
761: /*******

Line 777: -- and bic_party_status_summ tables.

773: end populate_status_data;
774: ----
775: ----
776: -- This procedure updates market segment for each party in bic_party_summ
777: -- and bic_party_status_summ tables.
778: procedure update_market_segment is
779: begin
780: update bic_party_summ summ
781: set market_segment_id = (select market_segment_id

Line 786: update bic_party_status_summ summ

782: from ams_party_market_segments mseg
783: where market_segment_flag = 'Y'
784: and mseg.party_id = summ.party_id
785: and rownum = 1);
786: update bic_party_status_summ summ
787: set market_segment_id = (select market_segment_id
788: from ams_party_market_segments mseg
789: where market_segment_flag = 'Y'
790: and mseg.party_id = summ.party_id