APPS.OZF_VOLUME_CALCULATION_PUB dependencies on FND_GLOBAL

Line 284: ,FND_GLOBAL.user_id

280: )
281: VALUES
282: ( ozf_order_group_prod_s.NEXTVAL
283: ,SYSDATE
284: ,FND_GLOBAL.user_id
285: ,SYSDATE
286: ,FND_GLOBAL.user_id
287: ,FND_GLOBAL.conc_login_id
288: ,p_volume_detail_rec.line_id

Line 286: ,FND_GLOBAL.user_id

282: ( ozf_order_group_prod_s.NEXTVAL
283: ,SYSDATE
284: ,FND_GLOBAL.user_id
285: ,SYSDATE
286: ,FND_GLOBAL.user_id
287: ,FND_GLOBAL.conc_login_id
288: ,p_volume_detail_rec.line_id
289: ,l_rma_ref_line_detail.offer_id
290: ,l_rma_ref_line_detail.qp_list_header_id

Line 287: ,FND_GLOBAL.conc_login_id

283: ,SYSDATE
284: ,FND_GLOBAL.user_id
285: ,SYSDATE
286: ,FND_GLOBAL.user_id
287: ,FND_GLOBAL.conc_login_id
288: ,p_volume_detail_rec.line_id
289: ,l_rma_ref_line_detail.offer_id
290: ,l_rma_ref_line_detail.qp_list_header_id
291: ,l_rma_ref_line_detail.group_no

Line 410: ,FND_GLOBAL.user_id

406: VALUES
407: (
408: ozf_volume_detail_s.NEXTVAL
409: ,SYSDATE
410: ,FND_GLOBAL.user_id
411: ,SYSDATE
412: ,FND_GLOBAL.user_id
413: ,FND_GLOBAL.conc_login_id
414: ,p_offer_id

Line 412: ,FND_GLOBAL.user_id

408: ozf_volume_detail_s.NEXTVAL
409: ,SYSDATE
410: ,FND_GLOBAL.user_id
411: ,SYSDATE
412: ,FND_GLOBAL.user_id
413: ,FND_GLOBAL.conc_login_id
414: ,p_offer_id
415: ,p_qp_list_header_id
416: ,p_volume_detail_rec.sold_from_cust_account_id

Line 413: ,FND_GLOBAL.conc_login_id

409: ,SYSDATE
410: ,FND_GLOBAL.user_id
411: ,SYSDATE
412: ,FND_GLOBAL.user_id
413: ,FND_GLOBAL.conc_login_id
414: ,p_offer_id
415: ,p_qp_list_header_id
416: ,p_volume_detail_rec.sold_from_cust_account_id
417: ,p_volume_detail_rec.sold_to_cust_account_id

Line 447: last_updated_by = FND_GLOBAL.user_id,

443: IF l_combine_schedule_yn = 'Y' THEN -- update all pbh lines
444: UPDATE ozf_volume_summary
445: SET group_volume = group_volume + l_current_volume,
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,
448: last_update_login = FND_GLOBAL.conc_login_id
449: WHERE offer_id = p_offer_id
450: AND group_no = l_group_no;
451: ELSE -- update one pbh line only

Line 448: last_update_login = FND_GLOBAL.conc_login_id

444: UPDATE ozf_volume_summary
445: SET group_volume = group_volume + l_current_volume,
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,
448: last_update_login = FND_GLOBAL.conc_login_id
449: WHERE offer_id = p_offer_id
450: AND group_no = l_group_no;
451: ELSE -- update one pbh line only
452: UPDATE ozf_volume_summary

Line 455: last_updated_by = FND_GLOBAL.user_id,

451: ELSE -- update one pbh line only
452: UPDATE ozf_volume_summary
453: SET group_volume = group_volume + l_current_volume,
454: last_update_date = SYSDATE,
455: last_updated_by = FND_GLOBAL.user_id,
456: last_update_login = FND_GLOBAL.conc_login_id
457: WHERE offer_id = p_offer_id
458: AND group_no = l_group_no
459: AND pbh_line_id = l_pbh_line_id;

Line 456: last_update_login = FND_GLOBAL.conc_login_id

452: UPDATE ozf_volume_summary
453: SET group_volume = group_volume + l_current_volume,
454: last_update_date = SYSDATE,
455: last_updated_by = FND_GLOBAL.user_id,
456: last_update_login = FND_GLOBAL.conc_login_id
457: WHERE offer_id = p_offer_id
458: AND group_no = l_group_no
459: AND pbh_line_id = l_pbh_line_id;
460: END IF;

Line 482: ,FND_GLOBAL.user_id

478: VALUES
479: (
480: ozf_volume_summary_s.NEXTVAL
481: ,SYSDATE
482: ,FND_GLOBAL.user_id
483: ,SYSDATE
484: ,FND_GLOBAL.user_id
485: ,FND_GLOBAL.conc_login_id
486: ,p_offer_id

Line 484: ,FND_GLOBAL.user_id

480: ozf_volume_summary_s.NEXTVAL
481: ,SYSDATE
482: ,FND_GLOBAL.user_id
483: ,SYSDATE
484: ,FND_GLOBAL.user_id
485: ,FND_GLOBAL.conc_login_id
486: ,p_offer_id
487: ,p_qp_list_header_id
488: ,l_group_no

Line 485: ,FND_GLOBAL.conc_login_id

481: ,SYSDATE
482: ,FND_GLOBAL.user_id
483: ,SYSDATE
484: ,FND_GLOBAL.user_id
485: ,FND_GLOBAL.conc_login_id
486: ,p_offer_id
487: ,p_qp_list_header_id
488: ,l_group_no
489: ,l_current_volume

Line 512: ,FND_GLOBAL.user_id

508: VALUES
509: (
510: ozf_volume_summary_s.NEXTVAL
511: ,SYSDATE
512: ,FND_GLOBAL.user_id
513: ,SYSDATE
514: ,FND_GLOBAL.user_id
515: ,FND_GLOBAL.conc_login_id
516: ,p_offer_id

Line 514: ,FND_GLOBAL.user_id

510: ozf_volume_summary_s.NEXTVAL
511: ,SYSDATE
512: ,FND_GLOBAL.user_id
513: ,SYSDATE
514: ,FND_GLOBAL.user_id
515: ,FND_GLOBAL.conc_login_id
516: ,p_offer_id
517: ,p_qp_list_header_id
518: ,l_group_no

Line 515: ,FND_GLOBAL.conc_login_id

511: ,SYSDATE
512: ,FND_GLOBAL.user_id
513: ,SYSDATE
514: ,FND_GLOBAL.user_id
515: ,FND_GLOBAL.conc_login_id
516: ,p_offer_id
517: ,p_qp_list_header_id
518: ,l_group_no
519: ,l_current_volume

Line 538: last_updated_by = FND_GLOBAL.user_id,

534: IF l_volume_exists = 'Y' THEN -- update distributor's volume
535: UPDATE ozf_volume_summary
536: SET individual_volume = individual_volume + l_current_volume,
537: last_update_date = SYSDATE,
538: last_updated_by = FND_GLOBAL.user_id,
539: last_update_login = FND_GLOBAL.conc_login_id
540: WHERE offer_id = p_offer_id
541: AND individual_type = 'DISTRIBUTOR'
542: AND individual_id = p_volume_detail_rec.sold_from_cust_account_id

Line 539: last_update_login = FND_GLOBAL.conc_login_id

535: UPDATE ozf_volume_summary
536: SET individual_volume = individual_volume + l_current_volume,
537: last_update_date = SYSDATE,
538: last_updated_by = FND_GLOBAL.user_id,
539: last_update_login = FND_GLOBAL.conc_login_id
540: WHERE offer_id = p_offer_id
541: AND individual_type = 'DISTRIBUTOR'
542: AND individual_id = p_volume_detail_rec.sold_from_cust_account_id
543: AND pbh_line_id = l_pbh_line_id;

Line 564: ,FND_GLOBAL.user_id

560: VALUES
561: (
562: ozf_volume_summary_s.NEXTVAL
563: ,SYSDATE
564: ,FND_GLOBAL.user_id
565: ,SYSDATE
566: ,FND_GLOBAL.user_id
567: ,FND_GLOBAL.conc_login_id
568: ,p_offer_id

Line 566: ,FND_GLOBAL.user_id

562: ozf_volume_summary_s.NEXTVAL
563: ,SYSDATE
564: ,FND_GLOBAL.user_id
565: ,SYSDATE
566: ,FND_GLOBAL.user_id
567: ,FND_GLOBAL.conc_login_id
568: ,p_offer_id
569: ,p_qp_list_header_id
570: ,'DISTRIBUTOR'

Line 567: ,FND_GLOBAL.conc_login_id

563: ,SYSDATE
564: ,FND_GLOBAL.user_id
565: ,SYSDATE
566: ,FND_GLOBAL.user_id
567: ,FND_GLOBAL.conc_login_id
568: ,p_offer_id
569: ,p_qp_list_header_id
570: ,'DISTRIBUTOR'
571: ,p_volume_detail_rec.sold_from_cust_account_id

Line 588: last_updated_by = FND_GLOBAL.user_id,

584: IF l_volume_exists = 'Y' THEN -- update customer's volume
585: UPDATE ozf_volume_summary
586: SET individual_volume = individual_volume + l_current_volume,
587: last_update_date = SYSDATE,
588: last_updated_by = FND_GLOBAL.user_id,
589: last_update_login = FND_GLOBAL.conc_login_id
590: WHERE offer_id = p_offer_id
591: AND individual_type = 'ACCOUNT'
592: AND individual_id = p_volume_detail_rec.sold_to_cust_account_id

Line 589: last_update_login = FND_GLOBAL.conc_login_id

585: UPDATE ozf_volume_summary
586: SET individual_volume = individual_volume + l_current_volume,
587: last_update_date = SYSDATE,
588: last_updated_by = FND_GLOBAL.user_id,
589: last_update_login = FND_GLOBAL.conc_login_id
590: WHERE offer_id = p_offer_id
591: AND individual_type = 'ACCOUNT'
592: AND individual_id = p_volume_detail_rec.sold_to_cust_account_id
593: AND pbh_line_id = l_pbh_line_id;

Line 614: ,FND_GLOBAL.user_id

610: VALUES
611: (
612: ozf_volume_summary_s.NEXTVAL
613: ,SYSDATE
614: ,FND_GLOBAL.user_id
615: ,SYSDATE
616: ,FND_GLOBAL.user_id
617: ,FND_GLOBAL.conc_login_id
618: ,p_offer_id

Line 616: ,FND_GLOBAL.user_id

612: ozf_volume_summary_s.NEXTVAL
613: ,SYSDATE
614: ,FND_GLOBAL.user_id
615: ,SYSDATE
616: ,FND_GLOBAL.user_id
617: ,FND_GLOBAL.conc_login_id
618: ,p_offer_id
619: ,p_qp_list_header_id
620: ,'ACCOUNT'

Line 617: ,FND_GLOBAL.conc_login_id

613: ,SYSDATE
614: ,FND_GLOBAL.user_id
615: ,SYSDATE
616: ,FND_GLOBAL.user_id
617: ,FND_GLOBAL.conc_login_id
618: ,p_offer_id
619: ,p_qp_list_header_id
620: ,'ACCOUNT'
621: ,p_volume_detail_rec.sold_to_cust_account_id

Line 637: last_updated_by = FND_GLOBAL.user_id,

633: IF l_volume_exists = 'Y' THEN -- update bill_to's volume
634: UPDATE ozf_volume_summary
635: SET individual_volume = individual_volume + l_current_volume,
636: last_update_date = SYSDATE,
637: last_updated_by = FND_GLOBAL.user_id,
638: last_update_login = FND_GLOBAL.conc_login_id
639: WHERE offer_id = p_offer_id
640: AND individual_type = 'BILL_TO'
641: AND individual_id = p_volume_detail_rec.bill_to_site_use_id

Line 638: last_update_login = FND_GLOBAL.conc_login_id

634: UPDATE ozf_volume_summary
635: SET individual_volume = individual_volume + l_current_volume,
636: last_update_date = SYSDATE,
637: last_updated_by = FND_GLOBAL.user_id,
638: last_update_login = FND_GLOBAL.conc_login_id
639: WHERE offer_id = p_offer_id
640: AND individual_type = 'BILL_TO'
641: AND individual_id = p_volume_detail_rec.bill_to_site_use_id
642: AND pbh_line_id = l_pbh_line_id;

Line 663: ,FND_GLOBAL.user_id

659: VALUES
660: (
661: ozf_volume_summary_s.NEXTVAL
662: ,SYSDATE
663: ,FND_GLOBAL.user_id
664: ,SYSDATE
665: ,FND_GLOBAL.user_id
666: ,FND_GLOBAL.conc_login_id
667: ,p_offer_id

Line 665: ,FND_GLOBAL.user_id

661: ozf_volume_summary_s.NEXTVAL
662: ,SYSDATE
663: ,FND_GLOBAL.user_id
664: ,SYSDATE
665: ,FND_GLOBAL.user_id
666: ,FND_GLOBAL.conc_login_id
667: ,p_offer_id
668: ,p_qp_list_header_id
669: ,'BILL_TO'

Line 666: ,FND_GLOBAL.conc_login_id

662: ,SYSDATE
663: ,FND_GLOBAL.user_id
664: ,SYSDATE
665: ,FND_GLOBAL.user_id
666: ,FND_GLOBAL.conc_login_id
667: ,p_offer_id
668: ,p_qp_list_header_id
669: ,'BILL_TO'
670: ,p_volume_detail_rec.bill_to_site_use_id

Line 686: last_updated_by = FND_GLOBAL.user_id,

682: IF l_volume_exists = 'Y' THEN -- update ship_to's volume
683: UPDATE ozf_volume_summary
684: SET individual_volume = individual_volume + l_current_volume,
685: last_update_date = SYSDATE,
686: last_updated_by = FND_GLOBAL.user_id,
687: last_update_login = FND_GLOBAL.conc_login_id
688: WHERE offer_id = p_offer_id
689: AND individual_type = 'SHIP_TO'
690: AND individual_id = p_volume_detail_rec.ship_to_site_use_id

Line 687: last_update_login = FND_GLOBAL.conc_login_id

683: UPDATE ozf_volume_summary
684: SET individual_volume = individual_volume + l_current_volume,
685: last_update_date = SYSDATE,
686: last_updated_by = FND_GLOBAL.user_id,
687: last_update_login = FND_GLOBAL.conc_login_id
688: WHERE offer_id = p_offer_id
689: AND individual_type = 'SHIP_TO'
690: AND individual_id = p_volume_detail_rec.ship_to_site_use_id
691: AND pbh_line_id = l_pbh_line_id;

Line 712: ,FND_GLOBAL.user_id

708: VALUES
709: (
710: ozf_volume_summary_s.NEXTVAL
711: ,SYSDATE
712: ,FND_GLOBAL.user_id
713: ,SYSDATE
714: ,FND_GLOBAL.user_id
715: ,FND_GLOBAL.conc_login_id
716: ,p_offer_id

Line 714: ,FND_GLOBAL.user_id

710: ozf_volume_summary_s.NEXTVAL
711: ,SYSDATE
712: ,FND_GLOBAL.user_id
713: ,SYSDATE
714: ,FND_GLOBAL.user_id
715: ,FND_GLOBAL.conc_login_id
716: ,p_offer_id
717: ,p_qp_list_header_id
718: ,'SHIP_TO'

Line 715: ,FND_GLOBAL.conc_login_id

711: ,SYSDATE
712: ,FND_GLOBAL.user_id
713: ,SYSDATE
714: ,FND_GLOBAL.user_id
715: ,FND_GLOBAL.conc_login_id
716: ,p_offer_id
717: ,p_qp_list_header_id
718: ,'SHIP_TO'
719: ,p_volume_detail_rec.ship_to_site_use_id

Line 1734: ,FND_GLOBAL.user_id

1730: )
1731: VALUES
1732: ( ozf_order_group_prod_s.NEXTVAL
1733: ,SYSDATE
1734: ,FND_GLOBAL.user_id
1735: ,SYSDATE
1736: ,FND_GLOBAL.user_id
1737: ,FND_GLOBAL.conc_login_id
1738: ,p_order_line_id

Line 1736: ,FND_GLOBAL.user_id

1732: ( ozf_order_group_prod_s.NEXTVAL
1733: ,SYSDATE
1734: ,FND_GLOBAL.user_id
1735: ,SYSDATE
1736: ,FND_GLOBAL.user_id
1737: ,FND_GLOBAL.conc_login_id
1738: ,p_order_line_id
1739: ,l_offer_id
1740: ,l_list_header_id

Line 1737: ,FND_GLOBAL.conc_login_id

1733: ,SYSDATE
1734: ,FND_GLOBAL.user_id
1735: ,SYSDATE
1736: ,FND_GLOBAL.user_id
1737: ,FND_GLOBAL.conc_login_id
1738: ,p_order_line_id
1739: ,l_offer_id
1740: ,l_list_header_id
1741: ,l_group_no

Line 1755: last_updated_by = FND_GLOBAL.user_id,

1751: );
1752: ELSE
1753: UPDATE ozf_order_group_prod
1754: SET last_update_date = SYSDATE,
1755: last_updated_by = FND_GLOBAL.user_id,
1756: last_update_login = FND_GLOBAL.conc_login_id,
1757: order_line_id = p_order_line_id,
1758: offer_id = l_offer_id,
1759: qp_list_header_id = l_list_header_id,

Line 1756: last_update_login = FND_GLOBAL.conc_login_id,

1752: ELSE
1753: UPDATE ozf_order_group_prod
1754: SET last_update_date = SYSDATE,
1755: last_updated_by = FND_GLOBAL.user_id,
1756: last_update_login = FND_GLOBAL.conc_login_id,
1757: order_line_id = p_order_line_id,
1758: offer_id = l_offer_id,
1759: qp_list_header_id = l_list_header_id,
1760: group_no = l_group_no,