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.OKS_MASS_UPDATE_PVT dependencies on OKS_MASS_UPDATE_PVT

Line 1: PACKAGE BODY OKS_MASS_UPDATE_PVT AS

1: PACKAGE BODY OKS_MASS_UPDATE_PVT AS
2: /* $Header: OKSRMUPB.pls 120.57.12000000.5 2007/10/18 15:02:50 cgopinee ship $ */
3:
4: --+---------------------------------+---+---+---+---+---+----------------------+
5: --| OBJECT |SEL|INS|UPD|DEL|CRE|OTHER |

Line 6097: oks_mass_update_pvt.get_seq_no ('H', 'NEW',kh.end_date)

6093: END
6094: ) subline_sdate,
6095: kl.end_date subline_edate,
6096: (decode(row_number() over (partition by kl.dnz_chr_id order by kl.cle_id), 1,
6097: oks_mass_update_pvt.get_seq_no ('H', 'NEW',kh.end_date)
6098: , oks_mass_update_pvt.get_seq_no ('H', 'OLD', kh.end_date))
6099:
6100: ) newcontractid,
6101: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1

Line 6098: , oks_mass_update_pvt.get_seq_no ('H', 'OLD', kh.end_date))

6094: ) subline_sdate,
6095: kl.end_date subline_edate,
6096: (decode(row_number() over (partition by kl.dnz_chr_id order by kl.cle_id), 1,
6097: oks_mass_update_pvt.get_seq_no ('H', 'NEW',kh.end_date)
6098: , oks_mass_update_pvt.get_seq_no ('H', 'OLD', kh.end_date))
6099:
6100: ) newcontractid,
6101: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1
6102: , oks_mass_update_pvt.get_seq_no ('L', 'NEW',kl.end_date)

Line 6102: , oks_mass_update_pvt.get_seq_no ('L', 'NEW',kl.end_date)

6098: , oks_mass_update_pvt.get_seq_no ('H', 'OLD', kh.end_date))
6099:
6100: ) newcontractid,
6101: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1
6102: , oks_mass_update_pvt.get_seq_no ('L', 'NEW',kl.end_date)
6103: , oks_mass_update_pvt.get_seq_no ('L', 'OLD',kl.end_date))
6104: ) newlineid,
6105: oks_mass_update_pvt.get_seq_no ('SL', 'NEW',kl.end_date) newsublineid,
6106: st.ste_code subline_status,

Line 6103: , oks_mass_update_pvt.get_seq_no ('L', 'OLD',kl.end_date))

6099:
6100: ) newcontractid,
6101: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1
6102: , oks_mass_update_pvt.get_seq_no ('L', 'NEW',kl.end_date)
6103: , oks_mass_update_pvt.get_seq_no ('L', 'OLD',kl.end_date))
6104: ) newlineid,
6105: oks_mass_update_pvt.get_seq_no ('SL', 'NEW',kl.end_date) newsublineid,
6106: st.ste_code subline_status,
6107: tmp.transfer_date transfer_date,

Line 6105: oks_mass_update_pvt.get_seq_no ('SL', 'NEW',kl.end_date) newsublineid,

6101: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1
6102: , oks_mass_update_pvt.get_seq_no ('L', 'NEW',kl.end_date)
6103: , oks_mass_update_pvt.get_seq_no ('L', 'OLD',kl.end_date))
6104: ) newlineid,
6105: oks_mass_update_pvt.get_seq_no ('SL', 'NEW',kl.end_date) newsublineid,
6106: st.ste_code subline_status,
6107: tmp.transfer_date transfer_date,
6108: tmp.old_customer_product_id custprod_id,
6109: kl.price_negotiated,

Line 6410: TRUNC (oks_mass_update_pvt.get_end_date (kl.start_date,

6406: kl.start_date AS prod_sdate,
6407: kl.end_date AS prod_edate,
6408: kl.sts_code AS prod_sts,
6409: tmp.installation_date AS idc_date,
6410: TRUNC (oks_mass_update_pvt.get_end_date (kl.start_date,
6411: kl.end_date,
6412: tmp.installation_date
6413: )
6414: ) AS new_edt,