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.OKL_EXT_BILLING_CHARGES_PVT dependencies on OKL_EXT_BILLING_INTERFACE

Line 8: ,TRX_STATUS_CODE OKL_EXT_BILLING_INTERFACE.trx_status_code%TYPE

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_EXT_BILLING_CHARGES_PVT';
5:
6: TYPE ext_rec_type IS RECORD (
7: ext_rowid rowid
8: ,TRX_STATUS_CODE OKL_EXT_BILLING_INTERFACE.trx_status_code%TYPE
9: ,ERROR_MESSAGE OKL_EXT_BILLING_INTERFACE.ERROR_MESSAGE%TYPE
10: ,CONTRACT_NUMBER OKL_EXT_BILLING_INTERFACE.CONTRACT_NUMBER%TYPE
11: ,CONTRACT_ID OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE
12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE

Line 9: ,ERROR_MESSAGE OKL_EXT_BILLING_INTERFACE.ERROR_MESSAGE%TYPE

5:
6: TYPE ext_rec_type IS RECORD (
7: ext_rowid rowid
8: ,TRX_STATUS_CODE OKL_EXT_BILLING_INTERFACE.trx_status_code%TYPE
9: ,ERROR_MESSAGE OKL_EXT_BILLING_INTERFACE.ERROR_MESSAGE%TYPE
10: ,CONTRACT_NUMBER OKL_EXT_BILLING_INTERFACE.CONTRACT_NUMBER%TYPE
11: ,CONTRACT_ID OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE
12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE
13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE

Line 10: ,CONTRACT_NUMBER OKL_EXT_BILLING_INTERFACE.CONTRACT_NUMBER%TYPE

6: TYPE ext_rec_type IS RECORD (
7: ext_rowid rowid
8: ,TRX_STATUS_CODE OKL_EXT_BILLING_INTERFACE.trx_status_code%TYPE
9: ,ERROR_MESSAGE OKL_EXT_BILLING_INTERFACE.ERROR_MESSAGE%TYPE
10: ,CONTRACT_NUMBER OKL_EXT_BILLING_INTERFACE.CONTRACT_NUMBER%TYPE
11: ,CONTRACT_ID OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE
12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE
13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE
14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE

Line 11: ,CONTRACT_ID OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE

7: ext_rowid rowid
8: ,TRX_STATUS_CODE OKL_EXT_BILLING_INTERFACE.trx_status_code%TYPE
9: ,ERROR_MESSAGE OKL_EXT_BILLING_INTERFACE.ERROR_MESSAGE%TYPE
10: ,CONTRACT_NUMBER OKL_EXT_BILLING_INTERFACE.CONTRACT_NUMBER%TYPE
11: ,CONTRACT_ID OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE
12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE
13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE
14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE
15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE

Line 12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE

8: ,TRX_STATUS_CODE OKL_EXT_BILLING_INTERFACE.trx_status_code%TYPE
9: ,ERROR_MESSAGE OKL_EXT_BILLING_INTERFACE.ERROR_MESSAGE%TYPE
10: ,CONTRACT_NUMBER OKL_EXT_BILLING_INTERFACE.CONTRACT_NUMBER%TYPE
11: ,CONTRACT_ID OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE
12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE
13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE
14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE
15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE
16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE

Line 13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE

9: ,ERROR_MESSAGE OKL_EXT_BILLING_INTERFACE.ERROR_MESSAGE%TYPE
10: ,CONTRACT_NUMBER OKL_EXT_BILLING_INTERFACE.CONTRACT_NUMBER%TYPE
11: ,CONTRACT_ID OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE
12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE
13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE
14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE
15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE
16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE
17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE

Line 14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE

10: ,CONTRACT_NUMBER OKL_EXT_BILLING_INTERFACE.CONTRACT_NUMBER%TYPE
11: ,CONTRACT_ID OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE
12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE
13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE
14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE
15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE
16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE
17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE
18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE

Line 15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE

11: ,CONTRACT_ID OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE
12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE
13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE
14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE
15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE
16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE
17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE
18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE
19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE

Line 16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE

12: ,STY_ID OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE
13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE
14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE
15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE
16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE
17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE
18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE
19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE
20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE

Line 17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE

13: ,STY_NAME OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE
14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE
15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE
16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE
17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE
18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE
19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE
20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE
21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE

Line 18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE

14: ,ASSET_ID OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE
15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE
16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE
17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE
18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE
19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE
20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE
21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE
22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE

Line 19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE

15: ,ASSET_NUMBER OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE
16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE
17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE
18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE
19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE
20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE
21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE
22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE
23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE

Line 20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE

16: ,INVOICE_DATE OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE
17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE
18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE
19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE
20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE
21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE
22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE
23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE
24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE

Line 21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE

17: ,AMOUNT OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE
18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE
19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE
20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE
21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE
22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE
23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE
24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE
25: ,TAX_VENDOR_SITE_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE

Line 22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE

18: ,CURRENCY_CODE OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE
19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE
20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE
21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE
22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE
23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE
24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE
25: ,TAX_VENDOR_SITE_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE
26: ,TAX_VENDOR_SITE_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_NAME%TYPE

Line 23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE

19: ,ORG_ID OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE
20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE
21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE
22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE
23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE
24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE
25: ,TAX_VENDOR_SITE_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE
26: ,TAX_VENDOR_SITE_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_NAME%TYPE
27: ,STREAM_TYPE_PURPOSE OKL_EXT_BILLING_INTERFACE.STREAM_TYPE_PURPOSE%TYPE

Line 24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE

20: ,JURSDCTN_TYPE OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE
21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE
22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE
23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE
24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE
25: ,TAX_VENDOR_SITE_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE
26: ,TAX_VENDOR_SITE_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_NAME%TYPE
27: ,STREAM_TYPE_PURPOSE OKL_EXT_BILLING_INTERFACE.STREAM_TYPE_PURPOSE%TYPE
28: ,TAX_ASSESSMENT_DATE OKL_EXT_BILLING_INTERFACE.TAX_ASSESSMENT_DATE%TYPE --vpanwar FPbug#5891876

Line 25: ,TAX_VENDOR_SITE_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE

21: ,JURSDCTN_NAME OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE
22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE
23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE
24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE
25: ,TAX_VENDOR_SITE_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE
26: ,TAX_VENDOR_SITE_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_NAME%TYPE
27: ,STREAM_TYPE_PURPOSE OKL_EXT_BILLING_INTERFACE.STREAM_TYPE_PURPOSE%TYPE
28: ,TAX_ASSESSMENT_DATE OKL_EXT_BILLING_INTERFACE.TAX_ASSESSMENT_DATE%TYPE --vpanwar FPbug#5891876
29: );

Line 26: ,TAX_VENDOR_SITE_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_NAME%TYPE

22: ,MLRT_TAX OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE
23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE
24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE
25: ,TAX_VENDOR_SITE_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE
26: ,TAX_VENDOR_SITE_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_NAME%TYPE
27: ,STREAM_TYPE_PURPOSE OKL_EXT_BILLING_INTERFACE.STREAM_TYPE_PURPOSE%TYPE
28: ,TAX_ASSESSMENT_DATE OKL_EXT_BILLING_INTERFACE.TAX_ASSESSMENT_DATE%TYPE --vpanwar FPbug#5891876
29: );
30:

Line 27: ,STREAM_TYPE_PURPOSE OKL_EXT_BILLING_INTERFACE.STREAM_TYPE_PURPOSE%TYPE

23: ,TAX_VENDOR_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE
24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE
25: ,TAX_VENDOR_SITE_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE
26: ,TAX_VENDOR_SITE_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_NAME%TYPE
27: ,STREAM_TYPE_PURPOSE OKL_EXT_BILLING_INTERFACE.STREAM_TYPE_PURPOSE%TYPE
28: ,TAX_ASSESSMENT_DATE OKL_EXT_BILLING_INTERFACE.TAX_ASSESSMENT_DATE%TYPE --vpanwar FPbug#5891876
29: );
30:
31: type ext_tbl_type is table of ext_rec_type index by binary_integer;

Line 28: ,TAX_ASSESSMENT_DATE OKL_EXT_BILLING_INTERFACE.TAX_ASSESSMENT_DATE%TYPE --vpanwar FPbug#5891876

24: ,TAX_VENDOR_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE
25: ,TAX_VENDOR_SITE_ID OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE
26: ,TAX_VENDOR_SITE_NAME OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_NAME%TYPE
27: ,STREAM_TYPE_PURPOSE OKL_EXT_BILLING_INTERFACE.STREAM_TYPE_PURPOSE%TYPE
28: ,TAX_ASSESSMENT_DATE OKL_EXT_BILLING_INTERFACE.TAX_ASSESSMENT_DATE%TYPE --vpanwar FPbug#5891876
29: );
30:
31: type ext_tbl_type is table of ext_rec_type index by binary_integer;
32: