APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_VOLUME_SUMMARY_INT

Line 480: --INSERT IN TO OZF_VOLUME_SUMMARY_INT table all the pbh lines for the offer

476: -- process volume summary
477: -- 1. group's volume
478: IF l_volume_track_type = 'GROUP' THEN
479: IF l_combine_schedule_yn = 'Y' THEN
480: --INSERT IN TO OZF_VOLUME_SUMMARY_INT table all the pbh lines for the offer
481: FOR l_pbh_line IN c_pbh_lines(p_offer_id) LOOP
482: INSERT INTO ozf_volume_summary_int
483: (
484: resale_batch_id

Line 482: INSERT INTO ozf_volume_summary_int

478: IF l_volume_track_type = 'GROUP' THEN
479: IF l_combine_schedule_yn = 'Y' THEN
480: --INSERT IN TO OZF_VOLUME_SUMMARY_INT table all the pbh lines for the offer
481: FOR l_pbh_line IN c_pbh_lines(p_offer_id) LOOP
482: INSERT INTO ozf_volume_summary_int
483: (
484: resale_batch_id
485: ,offer_id
486: ,group_no

Line 515: ELSE -- insert one pbh line only in to ozf_volume_summary_int table

511: ,FND_GLOBAL.conc_request_id
512: );
513: END LOOP;
514:
515: ELSE -- insert one pbh line only in to ozf_volume_summary_int table
516: INSERT INTO ozf_volume_summary_int
517: (
518: resale_batch_id
519: ,offer_id

Line 516: INSERT INTO ozf_volume_summary_int

512: );
513: END LOOP;
514:
515: ELSE -- insert one pbh line only in to ozf_volume_summary_int table
516: INSERT INTO ozf_volume_summary_int
517: (
518: resale_batch_id
519: ,offer_id
520: ,group_no

Line 556: INSERT INTO ozf_volume_summary_int

552: --IF p_volume_detail_rec.sold_from_cust_account_id IS NOT NULL AND p_volume_detail_rec.sold_from_cust_account_id <> fnd_api.g_miss_num THEN
553: IF p_indirect_flag = 'R' THEN -- indirect sales
554: ozf_utility_pvt.write_conc_log('distributor ' || l_volume_exists);
555: --insert distributor's volume in to volume summary int table
556: INSERT INTO ozf_volume_summary_int
557: (
558: resale_batch_id
559: ,offer_id
560: ,individual_type

Line 593: -- insert customer's volume into ozf_volume_summary_int table

589:
590: END IF; -- end distributor's volume
591:
592: -- 3. customer's volume
593: -- insert customer's volume into ozf_volume_summary_int table
594: INSERT INTO ozf_volume_summary_int
595: (
596: resale_batch_id
597: ,offer_id

Line 594: INSERT INTO ozf_volume_summary_int

590: END IF; -- end distributor's volume
591:
592: -- 3. customer's volume
593: -- insert customer's volume into ozf_volume_summary_int table
594: INSERT INTO ozf_volume_summary_int
595: (
596: resale_batch_id
597: ,offer_id
598: ,individual_type

Line 631: -- insert bill_to's volume into ozf_volume_summary_int table

627:
628:
629:
630: -- 4. bill_to's volume
631: -- insert bill_to's volume into ozf_volume_summary_int table
632: INSERT INTO ozf_volume_summary_int
633: (
634: resale_batch_id
635: ,offer_id

Line 632: INSERT INTO ozf_volume_summary_int

628:
629:
630: -- 4. bill_to's volume
631: -- insert bill_to's volume into ozf_volume_summary_int table
632: INSERT INTO ozf_volume_summary_int
633: (
634: resale_batch_id
635: ,offer_id
636: ,individual_type

Line 668: -- insert ship_to's volume into ozf_volume_summary_int table

664: );
665:
666:
667: -- 5. ship_to's volume
668: -- insert ship_to's volume into ozf_volume_summary_int table
669: INSERT INTO ozf_volume_summary_int
670: (
671: resale_batch_id
672: ,offer_id

Line 669: INSERT INTO ozf_volume_summary_int

665:
666:
667: -- 5. ship_to's volume
668: -- insert ship_to's volume into ozf_volume_summary_int table
669: INSERT INTO ozf_volume_summary_int
670: (
671: resale_batch_id
672: ,offer_id
673: ,individual_type