APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_TTY_PTERR_METRICS

Line 726: delete from jtf_tty_pterr_metrics

722: l_align_pterrs_tbl := p_pterr_tbl;
723: END IF;
724:
725: FORALL y IN l_align_pterrs_tbl.FIRST .. l_align_pterrs_tbl.LAST
726: delete from jtf_tty_pterr_metrics
727: where align_proposed_terr_id = l_align_pterrs_tbl(y);
728:
729: --processing to insert into the JTF_TTY_PTERR_METRICS table: summ up metric values for the accounts owned by this rep
730: FORALL j IN l_align_pterrs_tbl.FIRST .. l_align_pterrs_tbl.LAST

Line 729: --processing to insert into the JTF_TTY_PTERR_METRICS table: summ up metric values for the accounts owned by this rep

725: FORALL y IN l_align_pterrs_tbl.FIRST .. l_align_pterrs_tbl.LAST
726: delete from jtf_tty_pterr_metrics
727: where align_proposed_terr_id = l_align_pterrs_tbl(y);
728:
729: --processing to insert into the JTF_TTY_PTERR_METRICS table: summ up metric values for the accounts owned by this rep
730: FORALL j IN l_align_pterrs_tbl.FIRST .. l_align_pterrs_tbl.LAST
731: insert into jtf_tty_pterr_metrics
732: ( align_pterr_metric_id
733: ,object_version_number

Line 731: insert into jtf_tty_pterr_metrics

727: where align_proposed_terr_id = l_align_pterrs_tbl(y);
728:
729: --processing to insert into the JTF_TTY_PTERR_METRICS table: summ up metric values for the accounts owned by this rep
730: FORALL j IN l_align_pterrs_tbl.FIRST .. l_align_pterrs_tbl.LAST
731: insert into jtf_tty_pterr_metrics
732: ( align_pterr_metric_id
733: ,object_version_number
734: ,align_proposed_terr_id
735: ,metric_lookup_type

Line 746: jtf_tty_pterr_metrics_s.nextval

742: ,last_update_date
743: ,last_update_login
744: )
745: select
746: jtf_tty_pterr_metrics_s.nextval
747: , 1
748: , l_align_pterrs_tbl(j)
749: , 'JTF_TTY_ALIGN_METRICS'
750: , 'DNB_ANNUAL_REVENUE'

Line 790: insert into jtf_tty_pterr_metrics

786: group by alm.align_metric_val, pa.align_proposed_terr_id
787: ) pterr_list;
788:
789: FORALL j IN l_align_pterrs_tbl.FIRST .. l_align_pterrs_tbl.LAST
790: insert into jtf_tty_pterr_metrics
791: ( align_pterr_metric_id
792: ,object_version_number
793: ,align_proposed_terr_id
794: ,metric_lookup_type

Line 805: jtf_tty_pterr_metrics_s.nextval

801: ,last_update_date
802: ,last_update_login
803: )
804: select
805: jtf_tty_pterr_metrics_s.nextval
806: , 1
807: , l_align_pterrs_tbl(j)
808: , 'JTF_TTY_ALIGN_METRICS'
809: , 'DNB_NUM_EMPLOYEES'

Line 849: insert into jtf_tty_pterr_metrics

845: group by alm.align_metric_val, pa.align_proposed_terr_id
846: ) pterr_list;
847:
848: FORALL j IN l_align_pterrs_tbl.FIRST .. l_align_pterrs_tbl.LAST
849: insert into jtf_tty_pterr_metrics
850: ( align_pterr_metric_id
851: ,object_version_number
852: ,align_proposed_terr_id
853: ,metric_lookup_type

Line 864: jtf_tty_pterr_metrics_s.nextval

860: ,last_update_date
861: ,last_update_login
862: )
863: select
864: jtf_tty_pterr_metrics_s.nextval
865: , 1
866: , l_align_pterrs_tbl(j)
867: , 'JTF_TTY_ALIGN_METRICS'
868: , 'NUM_ACCOUNTS'

Line 895: insert into jtf_tty_pterr_metrics

891: group by alm.tot_align_metric_val, pa.align_proposed_terr_id
892: ) pterr_list;
893:
894: FORALL j IN l_align_pterrs_tbl.FIRST .. l_align_pterrs_tbl.LAST
895: insert into jtf_tty_pterr_metrics
896: ( align_pterr_metric_id
897: ,object_version_number
898: ,align_proposed_terr_id
899: ,metric_lookup_type

Line 910: jtf_tty_pterr_metrics_s.nextval

906: ,last_update_date
907: ,last_update_login
908: )
909: select
910: jtf_tty_pterr_metrics_s.nextval
911: , 1
912: , l_align_pterrs_tbl(j)
913: , 'JTF_TTY_ALIGN_METRICS'
914: , 'PRIOR_SALES'