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.OKI_REFRESH_PVT dependencies on OKI_DISCO_UTIL_PUB

Line 2581: ,oki_disco_util_pub.get_duration(khr.start_date,khr.end_date)

2577: ,l_base_currency
2578: ,hoks.est_rev_date close_date -- 11510 Changes
2579: ,trunc(khr.start_date)
2580: ,trunc(khr.end_date)
2581: ,oki_disco_util_pub.get_duration(khr.start_date,khr.end_date)
2582: ,oki_disco_util_pub.get_period(khr.start_date,khr.end_date)
2583: ,trunc(khr.date_approved)
2584: ,trunc(khr.date_signed)
2585: ,trunc(khr.date_renewed)

Line 2582: ,oki_disco_util_pub.get_period(khr.start_date,khr.end_date)

2578: ,hoks.est_rev_date close_date -- 11510 Changes
2579: ,trunc(khr.start_date)
2580: ,trunc(khr.end_date)
2581: ,oki_disco_util_pub.get_duration(khr.start_date,khr.end_date)
2582: ,oki_disco_util_pub.get_period(khr.start_date,khr.end_date)
2583: ,trunc(khr.date_approved)
2584: ,trunc(khr.date_signed)
2585: ,trunc(khr.date_renewed)
2586: ,trunc(khr.datetime_cancelled)

Line 3040: , oki_disco_util_pub.get_duration(khr.start_date,khr.end_date)

3036: , l_base_currency
3037: , hoks.est_rev_date close_date -- 11510 Changes
3038: , TRUNC(khr.start_date)
3039: , TRUNC(khr.end_date)
3040: , oki_disco_util_pub.get_duration(khr.start_date,khr.end_date)
3041: , oki_disco_util_pub.get_period(khr.start_date,khr.end_date)
3042: , TRUNC(khr.date_approved)
3043: , TRUNC(khr.date_signed)
3044: , TRUNC(khr.date_renewed)

Line 3041: , oki_disco_util_pub.get_period(khr.start_date,khr.end_date)

3037: , hoks.est_rev_date close_date -- 11510 Changes
3038: , TRUNC(khr.start_date)
3039: , TRUNC(khr.end_date)
3040: , oki_disco_util_pub.get_duration(khr.start_date,khr.end_date)
3041: , oki_disco_util_pub.get_period(khr.start_date,khr.end_date)
3042: , TRUNC(khr.date_approved)
3043: , TRUNC(khr.date_signed)
3044: , TRUNC(khr.date_renewed)
3045: , TRUNC(khr.datetime_cancelled)

Line 3474: ,oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)

3470: ,shd.scs_code
3471: ,cle.line_number
3472: ,trunc(cle.start_date)
3473: ,trunc(cle.end_date)
3474: ,oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)
3475: ,oki_disco_util_pub.get_period(cle.start_date,cle.end_date)
3476: ,cle.sts_code
3477: ,sts.ste_code
3478: ,cle.trn_code

Line 3475: ,oki_disco_util_pub.get_period(cle.start_date,cle.end_date)

3471: ,cle.line_number
3472: ,trunc(cle.start_date)
3473: ,trunc(cle.end_date)
3474: ,oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)
3475: ,oki_disco_util_pub.get_period(cle.start_date,cle.end_date)
3476: ,cle.sts_code
3477: ,sts.ste_code
3478: ,cle.trn_code
3479: ,trunc(cle.date_terminated)

Line 3766: , oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)

3762: , shd.scs_code
3763: , cle.line_number
3764: , TRUNC(cle.start_date)
3765: , TRUNC(cle.end_date)
3766: , oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)
3767: , oki_disco_util_pub.get_period(cle.start_date,cle.end_date)
3768: , cle.sts_code
3769: , sts.ste_code
3770: , cle.trn_code

Line 3767: , oki_disco_util_pub.get_period(cle.start_date,cle.end_date)

3763: , cle.line_number
3764: , TRUNC(cle.start_date)
3765: , TRUNC(cle.end_date)
3766: , oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)
3767: , oki_disco_util_pub.get_period(cle.start_date,cle.end_date)
3768: , cle.sts_code
3769: , sts.ste_code
3770: , cle.trn_code
3771: , TRUNC(cle.date_terminated)

Line 4055: ,oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)

4051: ,sil.complete_contract_number
4052: ,sil.line_number ||'.'|| cle.line_number
4053: ,trunc(cle.start_date)
4054: ,trunc(cle.end_date)
4055: ,oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)
4056: ,oki_disco_util_pub.get_period(cle.start_date,cle.end_date)
4057: ,cle.sts_code
4058: ,sts.ste_code
4059: ,cle.trn_code

Line 4056: ,oki_disco_util_pub.get_period(cle.start_date,cle.end_date)

4052: ,sil.line_number ||'.'|| cle.line_number
4053: ,trunc(cle.start_date)
4054: ,trunc(cle.end_date)
4055: ,oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)
4056: ,oki_disco_util_pub.get_period(cle.start_date,cle.end_date)
4057: ,cle.sts_code
4058: ,sts.ste_code
4059: ,cle.trn_code
4060: ,trunc(cle.date_terminated)

Line 4442: ,oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)

4438: , sil.complete_contract_number
4439: , sil.line_number ||'.'|| cle.line_number
4440: , TRUNC(cle.start_date)
4441: , TRUNC(cle.end_date)
4442: ,oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)
4443: ,oki_disco_util_pub.get_period(cle.start_date,cle.end_date)
4444: , cle.sts_code
4445: , sts.ste_code
4446: , cle.trn_code

Line 4443: ,oki_disco_util_pub.get_period(cle.start_date,cle.end_date)

4439: , sil.line_number ||'.'|| cle.line_number
4440: , TRUNC(cle.start_date)
4441: , TRUNC(cle.end_date)
4442: ,oki_disco_util_pub.get_duration(cle.start_date,cle.end_date)
4443: ,oki_disco_util_pub.get_period(cle.start_date,cle.end_date)
4444: , cle.sts_code
4445: , sts.ste_code
4446: , cle.trn_code
4447: , TRUNC(cle.date_terminated)