eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_VOLUME_CALCULATION_PUB dependencies on FND_GLOBAL

Line 315: ,FND_GLOBAL.user_id

311: )
312: VALUES
313: ( ozf_order_group_prod_s.NEXTVAL
314: ,SYSDATE
315: ,FND_GLOBAL.user_id
316: ,SYSDATE
317: ,FND_GLOBAL.user_id
318: ,FND_GLOBAL.conc_login_id
319: ,p_volume_detail_rec.line_id

Line 317: ,FND_GLOBAL.user_id

313: ( ozf_order_group_prod_s.NEXTVAL
314: ,SYSDATE
315: ,FND_GLOBAL.user_id
316: ,SYSDATE
317: ,FND_GLOBAL.user_id
318: ,FND_GLOBAL.conc_login_id
319: ,p_volume_detail_rec.line_id
320: ,l_rma_ref_line_detail.offer_id
321: ,l_rma_ref_line_detail.qp_list_header_id

Line 318: ,FND_GLOBAL.conc_login_id

314: ,SYSDATE
315: ,FND_GLOBAL.user_id
316: ,SYSDATE
317: ,FND_GLOBAL.user_id
318: ,FND_GLOBAL.conc_login_id
319: ,p_volume_detail_rec.line_id
320: ,l_rma_ref_line_detail.offer_id
321: ,l_rma_ref_line_detail.qp_list_header_id
322: ,l_rma_ref_line_detail.group_no

Line 448: ,FND_GLOBAL.user_id

444: VALUES
445: (
446: ozf_volume_detail_s.NEXTVAL
447: ,SYSDATE
448: ,FND_GLOBAL.user_id
449: ,SYSDATE
450: ,FND_GLOBAL.user_id
451: ,FND_GLOBAL.conc_login_id
452: ,p_offer_id

Line 450: ,FND_GLOBAL.user_id

446: ozf_volume_detail_s.NEXTVAL
447: ,SYSDATE
448: ,FND_GLOBAL.user_id
449: ,SYSDATE
450: ,FND_GLOBAL.user_id
451: ,FND_GLOBAL.conc_login_id
452: ,p_offer_id
453: ,p_qp_list_header_id
454: ,p_volume_detail_rec.sold_from_cust_account_id

Line 451: ,FND_GLOBAL.conc_login_id

447: ,SYSDATE
448: ,FND_GLOBAL.user_id
449: ,SYSDATE
450: ,FND_GLOBAL.user_id
451: ,FND_GLOBAL.conc_login_id
452: ,p_offer_id
453: ,p_qp_list_header_id
454: ,p_volume_detail_rec.sold_from_cust_account_id
455: ,p_volume_detail_rec.sold_to_cust_account_id

Line 506: ,FND_GLOBAL.user_id

502: ,l_group_no
503: ,l_current_volume
504: ,l_pbh_line.offer_discount_line_id
505: ,SYSDATE
506: ,FND_GLOBAL.user_id
507: ,SYSDATE
508: ,FND_GLOBAL.user_id
509: ,FND_GLOBAL.conc_login_id
510: ,'TP_ACCRUAL'

Line 508: ,FND_GLOBAL.user_id

504: ,l_pbh_line.offer_discount_line_id
505: ,SYSDATE
506: ,FND_GLOBAL.user_id
507: ,SYSDATE
508: ,FND_GLOBAL.user_id
509: ,FND_GLOBAL.conc_login_id
510: ,'TP_ACCRUAL'
511: ,FND_GLOBAL.conc_request_id
512: );

Line 509: ,FND_GLOBAL.conc_login_id

505: ,SYSDATE
506: ,FND_GLOBAL.user_id
507: ,SYSDATE
508: ,FND_GLOBAL.user_id
509: ,FND_GLOBAL.conc_login_id
510: ,'TP_ACCRUAL'
511: ,FND_GLOBAL.conc_request_id
512: );
513: END LOOP;

Line 511: ,FND_GLOBAL.conc_request_id

507: ,SYSDATE
508: ,FND_GLOBAL.user_id
509: ,FND_GLOBAL.conc_login_id
510: ,'TP_ACCRUAL'
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

Line 540: ,FND_GLOBAL.user_id

536: ,l_group_no
537: ,l_current_volume
538: ,l_pbh_line_id
539: ,SYSDATE
540: ,FND_GLOBAL.user_id
541: ,SYSDATE
542: ,FND_GLOBAL.user_id
543: ,FND_GLOBAL.conc_login_id
544: ,'TP_ACCRUAL'

Line 542: ,FND_GLOBAL.user_id

538: ,l_pbh_line_id
539: ,SYSDATE
540: ,FND_GLOBAL.user_id
541: ,SYSDATE
542: ,FND_GLOBAL.user_id
543: ,FND_GLOBAL.conc_login_id
544: ,'TP_ACCRUAL'
545: ,FND_GLOBAL.conc_request_id
546: );

Line 543: ,FND_GLOBAL.conc_login_id

539: ,SYSDATE
540: ,FND_GLOBAL.user_id
541: ,SYSDATE
542: ,FND_GLOBAL.user_id
543: ,FND_GLOBAL.conc_login_id
544: ,'TP_ACCRUAL'
545: ,FND_GLOBAL.conc_request_id
546: );
547: END IF;-- end combine schedule

Line 545: ,FND_GLOBAL.conc_request_id

541: ,SYSDATE
542: ,FND_GLOBAL.user_id
543: ,FND_GLOBAL.conc_login_id
544: ,'TP_ACCRUAL'
545: ,FND_GLOBAL.conc_request_id
546: );
547: END IF;-- end combine schedule
548: END IF; --end l_volume_track_type = 'GROUP'
549:

Line 582: ,FND_GLOBAL.user_id

578: ,p_volume_detail_rec.sold_from_cust_account_id
579: ,l_current_volume
580: ,l_pbh_line_id
581: ,SYSDATE
582: ,FND_GLOBAL.user_id
583: ,SYSDATE
584: ,FND_GLOBAL.user_id
585: ,FND_GLOBAL.conc_login_id
586: ,'TP_ACCRUAL'

Line 584: ,FND_GLOBAL.user_id

580: ,l_pbh_line_id
581: ,SYSDATE
582: ,FND_GLOBAL.user_id
583: ,SYSDATE
584: ,FND_GLOBAL.user_id
585: ,FND_GLOBAL.conc_login_id
586: ,'TP_ACCRUAL'
587: ,FND_GLOBAL.conc_request_id
588: );

Line 585: ,FND_GLOBAL.conc_login_id

581: ,SYSDATE
582: ,FND_GLOBAL.user_id
583: ,SYSDATE
584: ,FND_GLOBAL.user_id
585: ,FND_GLOBAL.conc_login_id
586: ,'TP_ACCRUAL'
587: ,FND_GLOBAL.conc_request_id
588: );
589:

Line 587: ,FND_GLOBAL.conc_request_id

583: ,SYSDATE
584: ,FND_GLOBAL.user_id
585: ,FND_GLOBAL.conc_login_id
586: ,'TP_ACCRUAL'
587: ,FND_GLOBAL.conc_request_id
588: );
589:
590: END IF; -- end distributor's volume
591:

Line 620: ,FND_GLOBAL.user_id

616: ,p_volume_detail_rec.sold_to_cust_account_id
617: ,l_current_volume
618: ,l_pbh_line_id
619: ,SYSDATE
620: ,FND_GLOBAL.user_id
621: ,SYSDATE
622: ,FND_GLOBAL.user_id
623: ,FND_GLOBAL.conc_login_id
624: ,'TP_ACCRUAL'

Line 622: ,FND_GLOBAL.user_id

618: ,l_pbh_line_id
619: ,SYSDATE
620: ,FND_GLOBAL.user_id
621: ,SYSDATE
622: ,FND_GLOBAL.user_id
623: ,FND_GLOBAL.conc_login_id
624: ,'TP_ACCRUAL'
625: ,FND_GLOBAL.conc_request_id
626: );

Line 623: ,FND_GLOBAL.conc_login_id

619: ,SYSDATE
620: ,FND_GLOBAL.user_id
621: ,SYSDATE
622: ,FND_GLOBAL.user_id
623: ,FND_GLOBAL.conc_login_id
624: ,'TP_ACCRUAL'
625: ,FND_GLOBAL.conc_request_id
626: );
627:

Line 625: ,FND_GLOBAL.conc_request_id

621: ,SYSDATE
622: ,FND_GLOBAL.user_id
623: ,FND_GLOBAL.conc_login_id
624: ,'TP_ACCRUAL'
625: ,FND_GLOBAL.conc_request_id
626: );
627:
628:
629:

Line 658: ,FND_GLOBAL.user_id

654: , p_volume_detail_rec.bill_to_site_use_id
655: ,l_current_volume
656: ,l_pbh_line_id
657: ,SYSDATE
658: ,FND_GLOBAL.user_id
659: ,SYSDATE
660: ,FND_GLOBAL.user_id
661: ,FND_GLOBAL.conc_login_id
662: ,'TP_ACCRUAL'

Line 660: ,FND_GLOBAL.user_id

656: ,l_pbh_line_id
657: ,SYSDATE
658: ,FND_GLOBAL.user_id
659: ,SYSDATE
660: ,FND_GLOBAL.user_id
661: ,FND_GLOBAL.conc_login_id
662: ,'TP_ACCRUAL'
663: ,FND_GLOBAL.conc_request_id
664: );

Line 661: ,FND_GLOBAL.conc_login_id

657: ,SYSDATE
658: ,FND_GLOBAL.user_id
659: ,SYSDATE
660: ,FND_GLOBAL.user_id
661: ,FND_GLOBAL.conc_login_id
662: ,'TP_ACCRUAL'
663: ,FND_GLOBAL.conc_request_id
664: );
665:

Line 663: ,FND_GLOBAL.conc_request_id

659: ,SYSDATE
660: ,FND_GLOBAL.user_id
661: ,FND_GLOBAL.conc_login_id
662: ,'TP_ACCRUAL'
663: ,FND_GLOBAL.conc_request_id
664: );
665:
666:
667: -- 5. ship_to's volume

Line 695: ,FND_GLOBAL.user_id

691: , p_volume_detail_rec.ship_to_site_use_id
692: ,l_current_volume
693: ,l_pbh_line_id
694: ,SYSDATE
695: ,FND_GLOBAL.user_id
696: ,SYSDATE
697: ,FND_GLOBAL.user_id
698: ,FND_GLOBAL.conc_login_id
699: ,'TP_ACCRUAL'

Line 697: ,FND_GLOBAL.user_id

693: ,l_pbh_line_id
694: ,SYSDATE
695: ,FND_GLOBAL.user_id
696: ,SYSDATE
697: ,FND_GLOBAL.user_id
698: ,FND_GLOBAL.conc_login_id
699: ,'TP_ACCRUAL'
700: ,FND_GLOBAL.conc_request_id
701: );

Line 698: ,FND_GLOBAL.conc_login_id

694: ,SYSDATE
695: ,FND_GLOBAL.user_id
696: ,SYSDATE
697: ,FND_GLOBAL.user_id
698: ,FND_GLOBAL.conc_login_id
699: ,'TP_ACCRUAL'
700: ,FND_GLOBAL.conc_request_id
701: );
702:

Line 700: ,FND_GLOBAL.conc_request_id

696: ,SYSDATE
697: ,FND_GLOBAL.user_id
698: ,FND_GLOBAL.conc_login_id
699: ,'TP_ACCRUAL'
700: ,FND_GLOBAL.conc_request_id
701: );
702:
703: ELSE
704:

Line 716: last_updated_by = FND_GLOBAL.user_id,

712: IF l_combine_schedule_yn = 'Y' THEN -- update all pbh lines
713: UPDATE ozf_volume_summary
714: SET group_volume = group_volume + l_current_volume,
715: last_update_date = SYSDATE,
716: last_updated_by = FND_GLOBAL.user_id,
717: last_update_login = FND_GLOBAL.conc_login_id
718: WHERE offer_id = p_offer_id
719: AND group_no = l_group_no;
720: ELSE -- update one pbh line only

Line 717: last_update_login = FND_GLOBAL.conc_login_id

713: UPDATE ozf_volume_summary
714: SET group_volume = group_volume + l_current_volume,
715: last_update_date = SYSDATE,
716: last_updated_by = FND_GLOBAL.user_id,
717: last_update_login = FND_GLOBAL.conc_login_id
718: WHERE offer_id = p_offer_id
719: AND group_no = l_group_no;
720: ELSE -- update one pbh line only
721: UPDATE ozf_volume_summary

Line 724: last_updated_by = FND_GLOBAL.user_id,

720: ELSE -- update one pbh line only
721: UPDATE ozf_volume_summary
722: SET group_volume = group_volume + l_current_volume,
723: last_update_date = SYSDATE,
724: last_updated_by = FND_GLOBAL.user_id,
725: last_update_login = FND_GLOBAL.conc_login_id
726: WHERE offer_id = p_offer_id
727: AND group_no = l_group_no
728: AND pbh_line_id = l_pbh_line_id;

Line 725: last_update_login = FND_GLOBAL.conc_login_id

721: UPDATE ozf_volume_summary
722: SET group_volume = group_volume + l_current_volume,
723: last_update_date = SYSDATE,
724: last_updated_by = FND_GLOBAL.user_id,
725: last_update_login = FND_GLOBAL.conc_login_id
726: WHERE offer_id = p_offer_id
727: AND group_no = l_group_no
728: AND pbh_line_id = l_pbh_line_id;
729: END IF;

Line 751: ,FND_GLOBAL.user_id

747: VALUES
748: (
749: ozf_volume_summary_s.NEXTVAL
750: ,SYSDATE
751: ,FND_GLOBAL.user_id
752: ,SYSDATE
753: ,FND_GLOBAL.user_id
754: ,FND_GLOBAL.conc_login_id
755: ,p_offer_id

Line 753: ,FND_GLOBAL.user_id

749: ozf_volume_summary_s.NEXTVAL
750: ,SYSDATE
751: ,FND_GLOBAL.user_id
752: ,SYSDATE
753: ,FND_GLOBAL.user_id
754: ,FND_GLOBAL.conc_login_id
755: ,p_offer_id
756: ,p_qp_list_header_id
757: ,l_group_no

Line 754: ,FND_GLOBAL.conc_login_id

750: ,SYSDATE
751: ,FND_GLOBAL.user_id
752: ,SYSDATE
753: ,FND_GLOBAL.user_id
754: ,FND_GLOBAL.conc_login_id
755: ,p_offer_id
756: ,p_qp_list_header_id
757: ,l_group_no
758: ,l_current_volume

Line 781: ,FND_GLOBAL.user_id

777: VALUES
778: (
779: ozf_volume_summary_s.NEXTVAL
780: ,SYSDATE
781: ,FND_GLOBAL.user_id
782: ,SYSDATE
783: ,FND_GLOBAL.user_id
784: ,FND_GLOBAL.conc_login_id
785: ,p_offer_id

Line 783: ,FND_GLOBAL.user_id

779: ozf_volume_summary_s.NEXTVAL
780: ,SYSDATE
781: ,FND_GLOBAL.user_id
782: ,SYSDATE
783: ,FND_GLOBAL.user_id
784: ,FND_GLOBAL.conc_login_id
785: ,p_offer_id
786: ,p_qp_list_header_id
787: ,l_group_no

Line 784: ,FND_GLOBAL.conc_login_id

780: ,SYSDATE
781: ,FND_GLOBAL.user_id
782: ,SYSDATE
783: ,FND_GLOBAL.user_id
784: ,FND_GLOBAL.conc_login_id
785: ,p_offer_id
786: ,p_qp_list_header_id
787: ,l_group_no
788: ,l_current_volume

Line 813: last_updated_by = FND_GLOBAL.user_id,

809: IF l_volume_exists = 'Y' THEN -- update distributor's volume
810: UPDATE ozf_volume_summary
811: SET individual_volume = individual_volume + l_current_volume,
812: last_update_date = SYSDATE,
813: last_updated_by = FND_GLOBAL.user_id,
814: last_update_login = FND_GLOBAL.conc_login_id
815: WHERE offer_id = p_offer_id
816: AND individual_type = 'DISTRIBUTOR'
817: AND individual_id = p_volume_detail_rec.sold_from_cust_account_id

Line 814: last_update_login = FND_GLOBAL.conc_login_id

810: UPDATE ozf_volume_summary
811: SET individual_volume = individual_volume + l_current_volume,
812: last_update_date = SYSDATE,
813: last_updated_by = FND_GLOBAL.user_id,
814: last_update_login = FND_GLOBAL.conc_login_id
815: WHERE offer_id = p_offer_id
816: AND individual_type = 'DISTRIBUTOR'
817: AND individual_id = p_volume_detail_rec.sold_from_cust_account_id
818: AND pbh_line_id = l_pbh_line_id;

Line 839: ,FND_GLOBAL.user_id

835: VALUES
836: (
837: ozf_volume_summary_s.NEXTVAL
838: ,SYSDATE
839: ,FND_GLOBAL.user_id
840: ,SYSDATE
841: ,FND_GLOBAL.user_id
842: ,FND_GLOBAL.conc_login_id
843: ,p_offer_id

Line 841: ,FND_GLOBAL.user_id

837: ozf_volume_summary_s.NEXTVAL
838: ,SYSDATE
839: ,FND_GLOBAL.user_id
840: ,SYSDATE
841: ,FND_GLOBAL.user_id
842: ,FND_GLOBAL.conc_login_id
843: ,p_offer_id
844: ,p_qp_list_header_id
845: ,'DISTRIBUTOR'

Line 842: ,FND_GLOBAL.conc_login_id

838: ,SYSDATE
839: ,FND_GLOBAL.user_id
840: ,SYSDATE
841: ,FND_GLOBAL.user_id
842: ,FND_GLOBAL.conc_login_id
843: ,p_offer_id
844: ,p_qp_list_header_id
845: ,'DISTRIBUTOR'
846: ,p_volume_detail_rec.sold_from_cust_account_id

Line 870: last_updated_by = FND_GLOBAL.user_id,

866: IF l_volume_exists = 'Y' THEN -- update customer's volume
867: UPDATE ozf_volume_summary
868: SET individual_volume = individual_volume + l_current_volume,
869: last_update_date = SYSDATE,
870: last_updated_by = FND_GLOBAL.user_id,
871: last_update_login = FND_GLOBAL.conc_login_id
872: WHERE offer_id = p_offer_id
873: AND individual_type = 'ACCOUNT'
874: AND individual_id = p_volume_detail_rec.sold_to_cust_account_id

Line 871: last_update_login = FND_GLOBAL.conc_login_id

867: UPDATE ozf_volume_summary
868: SET individual_volume = individual_volume + l_current_volume,
869: last_update_date = SYSDATE,
870: last_updated_by = FND_GLOBAL.user_id,
871: last_update_login = FND_GLOBAL.conc_login_id
872: WHERE offer_id = p_offer_id
873: AND individual_type = 'ACCOUNT'
874: AND individual_id = p_volume_detail_rec.sold_to_cust_account_id
875: AND pbh_line_id = l_pbh_line_id;

Line 896: ,FND_GLOBAL.user_id

892: VALUES
893: (
894: ozf_volume_summary_s.NEXTVAL
895: ,SYSDATE
896: ,FND_GLOBAL.user_id
897: ,SYSDATE
898: ,FND_GLOBAL.user_id
899: ,FND_GLOBAL.conc_login_id
900: ,p_offer_id

Line 898: ,FND_GLOBAL.user_id

894: ozf_volume_summary_s.NEXTVAL
895: ,SYSDATE
896: ,FND_GLOBAL.user_id
897: ,SYSDATE
898: ,FND_GLOBAL.user_id
899: ,FND_GLOBAL.conc_login_id
900: ,p_offer_id
901: ,p_qp_list_header_id
902: ,'ACCOUNT'

Line 899: ,FND_GLOBAL.conc_login_id

895: ,SYSDATE
896: ,FND_GLOBAL.user_id
897: ,SYSDATE
898: ,FND_GLOBAL.user_id
899: ,FND_GLOBAL.conc_login_id
900: ,p_offer_id
901: ,p_qp_list_header_id
902: ,'ACCOUNT'
903: ,p_volume_detail_rec.sold_to_cust_account_id

Line 925: last_updated_by = FND_GLOBAL.user_id,

921: IF l_volume_exists = 'Y' THEN -- update bill_to's volume
922: UPDATE ozf_volume_summary
923: SET individual_volume = individual_volume + l_current_volume,
924: last_update_date = SYSDATE,
925: last_updated_by = FND_GLOBAL.user_id,
926: last_update_login = FND_GLOBAL.conc_login_id
927: WHERE offer_id = p_offer_id
928: AND individual_type = 'BILL_TO'
929: AND individual_id = p_volume_detail_rec.bill_to_site_use_id

Line 926: last_update_login = FND_GLOBAL.conc_login_id

922: UPDATE ozf_volume_summary
923: SET individual_volume = individual_volume + l_current_volume,
924: last_update_date = SYSDATE,
925: last_updated_by = FND_GLOBAL.user_id,
926: last_update_login = FND_GLOBAL.conc_login_id
927: WHERE offer_id = p_offer_id
928: AND individual_type = 'BILL_TO'
929: AND individual_id = p_volume_detail_rec.bill_to_site_use_id
930: AND pbh_line_id = l_pbh_line_id;

Line 951: ,FND_GLOBAL.user_id

947: VALUES
948: (
949: ozf_volume_summary_s.NEXTVAL
950: ,SYSDATE
951: ,FND_GLOBAL.user_id
952: ,SYSDATE
953: ,FND_GLOBAL.user_id
954: ,FND_GLOBAL.conc_login_id
955: ,p_offer_id

Line 953: ,FND_GLOBAL.user_id

949: ozf_volume_summary_s.NEXTVAL
950: ,SYSDATE
951: ,FND_GLOBAL.user_id
952: ,SYSDATE
953: ,FND_GLOBAL.user_id
954: ,FND_GLOBAL.conc_login_id
955: ,p_offer_id
956: ,p_qp_list_header_id
957: ,'BILL_TO'

Line 954: ,FND_GLOBAL.conc_login_id

950: ,SYSDATE
951: ,FND_GLOBAL.user_id
952: ,SYSDATE
953: ,FND_GLOBAL.user_id
954: ,FND_GLOBAL.conc_login_id
955: ,p_offer_id
956: ,p_qp_list_header_id
957: ,'BILL_TO'
958: ,p_volume_detail_rec.bill_to_site_use_id

Line 980: last_updated_by = FND_GLOBAL.user_id,

976: IF l_volume_exists = 'Y' THEN -- update ship_to's volume
977: UPDATE ozf_volume_summary
978: SET individual_volume = individual_volume + l_current_volume,
979: last_update_date = SYSDATE,
980: last_updated_by = FND_GLOBAL.user_id,
981: last_update_login = FND_GLOBAL.conc_login_id
982: WHERE offer_id = p_offer_id
983: AND individual_type = 'SHIP_TO'
984: AND individual_id = p_volume_detail_rec.ship_to_site_use_id

Line 981: last_update_login = FND_GLOBAL.conc_login_id

977: UPDATE ozf_volume_summary
978: SET individual_volume = individual_volume + l_current_volume,
979: last_update_date = SYSDATE,
980: last_updated_by = FND_GLOBAL.user_id,
981: last_update_login = FND_GLOBAL.conc_login_id
982: WHERE offer_id = p_offer_id
983: AND individual_type = 'SHIP_TO'
984: AND individual_id = p_volume_detail_rec.ship_to_site_use_id
985: AND pbh_line_id = l_pbh_line_id;

Line 1006: ,FND_GLOBAL.user_id

1002: VALUES
1003: (
1004: ozf_volume_summary_s.NEXTVAL
1005: ,SYSDATE
1006: ,FND_GLOBAL.user_id
1007: ,SYSDATE
1008: ,FND_GLOBAL.user_id
1009: ,FND_GLOBAL.conc_login_id
1010: ,p_offer_id

Line 1008: ,FND_GLOBAL.user_id

1004: ozf_volume_summary_s.NEXTVAL
1005: ,SYSDATE
1006: ,FND_GLOBAL.user_id
1007: ,SYSDATE
1008: ,FND_GLOBAL.user_id
1009: ,FND_GLOBAL.conc_login_id
1010: ,p_offer_id
1011: ,p_qp_list_header_id
1012: ,'SHIP_TO'

Line 1009: ,FND_GLOBAL.conc_login_id

1005: ,SYSDATE
1006: ,FND_GLOBAL.user_id
1007: ,SYSDATE
1008: ,FND_GLOBAL.user_id
1009: ,FND_GLOBAL.conc_login_id
1010: ,p_offer_id
1011: ,p_qp_list_header_id
1012: ,'SHIP_TO'
1013: ,p_volume_detail_rec.ship_to_site_use_id

Line 2176: ,FND_GLOBAL.user_id

2172: )
2173: VALUES
2174: ( ozf_order_group_prod_s.NEXTVAL
2175: ,SYSDATE
2176: ,FND_GLOBAL.user_id
2177: ,SYSDATE
2178: ,FND_GLOBAL.user_id
2179: ,FND_GLOBAL.conc_login_id
2180: ,p_order_line_id

Line 2178: ,FND_GLOBAL.user_id

2174: ( ozf_order_group_prod_s.NEXTVAL
2175: ,SYSDATE
2176: ,FND_GLOBAL.user_id
2177: ,SYSDATE
2178: ,FND_GLOBAL.user_id
2179: ,FND_GLOBAL.conc_login_id
2180: ,p_order_line_id
2181: ,l_offer_id
2182: ,l_list_header_id

Line 2179: ,FND_GLOBAL.conc_login_id

2175: ,SYSDATE
2176: ,FND_GLOBAL.user_id
2177: ,SYSDATE
2178: ,FND_GLOBAL.user_id
2179: ,FND_GLOBAL.conc_login_id
2180: ,p_order_line_id
2181: ,l_offer_id
2182: ,l_list_header_id
2183: ,l_group_no

Line 2197: last_updated_by = FND_GLOBAL.user_id,

2193: );
2194: ELSE
2195: UPDATE ozf_order_group_prod
2196: SET last_update_date = SYSDATE,
2197: last_updated_by = FND_GLOBAL.user_id,
2198: last_update_login = FND_GLOBAL.conc_login_id,
2199: order_line_id = p_order_line_id,
2200: offer_id = l_offer_id,
2201: qp_list_header_id = l_list_header_id,

Line 2198: last_update_login = FND_GLOBAL.conc_login_id,

2194: ELSE
2195: UPDATE ozf_order_group_prod
2196: SET last_update_date = SYSDATE,
2197: last_updated_by = FND_GLOBAL.user_id,
2198: last_update_login = FND_GLOBAL.conc_login_id,
2199: order_line_id = p_order_line_id,
2200: offer_id = l_offer_id,
2201: qp_list_header_id = l_list_header_id,
2202: group_no = l_group_no,