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.66.12020000.2 2013/02/05 17:15:47 ansraj ship $ */
3:
4: --+---------------------------------+---+---+---+---+---+----------------------+
5: --| OBJECT |SEL|INS|UPD|DEL|CRE|OTHER |

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

6110: END
6111: ) subline_sdate,
6112: kl.end_date subline_edate,
6113: (decode(row_number() over (partition by kl.dnz_chr_id order by kl.cle_id), 1,
6114: oks_mass_update_pvt.get_seq_no ('H', 'NEW',kh.end_date)
6115: , oks_mass_update_pvt.get_seq_no ('H', 'OLD', kh.end_date))
6116:
6117: ) newcontractid,
6118: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1

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

6111: ) subline_sdate,
6112: kl.end_date subline_edate,
6113: (decode(row_number() over (partition by kl.dnz_chr_id order by kl.cle_id), 1,
6114: oks_mass_update_pvt.get_seq_no ('H', 'NEW',kh.end_date)
6115: , oks_mass_update_pvt.get_seq_no ('H', 'OLD', kh.end_date))
6116:
6117: ) newcontractid,
6118: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1
6119: , oks_mass_update_pvt.get_seq_no ('L', 'NEW',kl.end_date)

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

6115: , oks_mass_update_pvt.get_seq_no ('H', 'OLD', kh.end_date))
6116:
6117: ) newcontractid,
6118: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1
6119: , oks_mass_update_pvt.get_seq_no ('L', 'NEW',kl.end_date)
6120: , oks_mass_update_pvt.get_seq_no ('L', 'OLD',kl.end_date))
6121: ) newlineid,
6122: oks_mass_update_pvt.get_seq_no ('SL', 'NEW',kl.end_date) newsublineid,
6123: st.ste_code subline_status,

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

6116:
6117: ) newcontractid,
6118: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1
6119: , oks_mass_update_pvt.get_seq_no ('L', 'NEW',kl.end_date)
6120: , oks_mass_update_pvt.get_seq_no ('L', 'OLD',kl.end_date))
6121: ) newlineid,
6122: oks_mass_update_pvt.get_seq_no ('SL', 'NEW',kl.end_date) newsublineid,
6123: st.ste_code subline_status,
6124: tmp.transfer_date transfer_date,

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

6118: (decode(row_number() over (partition by kl.dnz_chr_id, kl.cle_id order by kl.rowid), 1
6119: , oks_mass_update_pvt.get_seq_no ('L', 'NEW',kl.end_date)
6120: , oks_mass_update_pvt.get_seq_no ('L', 'OLD',kl.end_date))
6121: ) newlineid,
6122: oks_mass_update_pvt.get_seq_no ('SL', 'NEW',kl.end_date) newsublineid,
6123: st.ste_code subline_status,
6124: tmp.transfer_date transfer_date,
6125: tmp.old_customer_product_id custprod_id,
6126: kl.price_negotiated,

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

6423: kl.start_date AS prod_sdate,
6424: kl.end_date AS prod_edate,
6425: kl.sts_code AS prod_sts,
6426: tmp.installation_date AS idc_date,
6427: TRUNC (oks_mass_update_pvt.get_end_date (kl.start_date,
6428: kl.end_date,
6429: tmp.installation_date
6430: )
6431: ) AS new_edt,