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_ENTITLEMENTS_WEB dependencies on OKS_ENTITLEMENTS_WEB

Line 1: PACKAGE BODY OKS_ENTITLEMENTS_WEB AS

1: PACKAGE BODY OKS_ENTITLEMENTS_WEB AS
2: /* $Header: OKSJENWB.pls 120.19.12000000.2 2007/07/30 11:54:45 cgopinee ship $ */
3: ---------------------------------------------------------------------
4:
5: /*

Line 43: x_contract_tbl OUT NOCOPY OKS_ENTITLEMENTS_WEB.output_tbl_contract

39: p_account_id IN VARCHAR2,
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2,
43: x_contract_tbl OUT NOCOPY OKS_ENTITLEMENTS_WEB.output_tbl_contract
44: )
45: IS
46: l_api_version NUMBER := 1;
47: l_init_msg_list VARCHAR2(10) := 'T';

Line 201: p_account_all_id IN OKS_ENTITLEMENTS_WEB.account_all_id_tbl_type,

197: p_entitlement_check_YN IN VARCHAR2,
198: p_account_check_all IN VARCHAR2,
199: p_account_id IN VARCHAR2,
200: p_covlvl_party_id IN VARCHAR2,
201: p_account_all_id IN OKS_ENTITLEMENTS_WEB.account_all_id_tbl_type,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: x_contract_tbl OUT NOCOPY OKS_ENTITLEMENTS_WEB.output_tbl_contract

Line 205: x_contract_tbl OUT NOCOPY OKS_ENTITLEMENTS_WEB.output_tbl_contract

201: p_account_all_id IN OKS_ENTITLEMENTS_WEB.account_all_id_tbl_type,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: x_contract_tbl OUT NOCOPY OKS_ENTITLEMENTS_WEB.output_tbl_contract
206: )
207: IS
208: CURSOR party_sites_cur(p_party_id VARCHAR2, p_site_name VARCHAR2)
209: IS

Line 528: x_party_sites_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_sites_tbl_type

524: PROCEDURE party_sites(
525: p_party_id_arg IN VARCHAR2,
526: p_site_name_arg IN VARCHAR2,
527: x_return_status OUT NOCOPY VARCHAR2,
528: x_party_sites_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_sites_tbl_type
529: )
530: IS
531: CURSOR party_sites_cur(p_party_id VARCHAR2, p_site_name VARCHAR2)
532: IS

Line 557: l_party_sites_tbl_type OKS_ENTITLEMENTS_WEB.party_sites_tbl_type;

553: and LCN.LOCATION_ID = PSE.LOCATION_ID
554: and LCN.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
555: and (PSE.PARTY_SITE_NAME like p_site_name or PSE.PARTY_SITE_NAME is NULL);
556:
557: l_party_sites_tbl_type OKS_ENTITLEMENTS_WEB.party_sites_tbl_type;
558: l_party_sites_tbl_indx NUMBER :=1;
559:
560: BEGIN
561: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 632: x_party_items_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_items_tbl_type

628: PROCEDURE party_items(
629: p_party_id_arg IN VARCHAR2,
630: p_item_name_arg IN VARCHAR2,
631: x_return_status OUT NOCOPY VARCHAR2,
632: x_party_items_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_items_tbl_type
633: )
634: IS
635: CURSOR party_items_cur(p_party_id VARCHAR2, p_item_name VARCHAR2)
636: IS

Line 662: l_party_items_tbl_type OKS_ENTITLEMENTS_WEB.party_items_tbl_type;

658: and B.ORGANIZATION_ID = T.ORGANIZATION_ID
659: and T.LANGUAGE = userenv('LANG')
660: and T.DESCRIPTION like p_item_name;
661:
662: l_party_items_tbl_type OKS_ENTITLEMENTS_WEB.party_items_tbl_type;
663: l_party_items_tbl_indx NUMBER :=1;
664:
665: BEGIN
666: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 736: p_account_id_all IN OKS_ENTITLEMENTS_WEB.account_all_id_tbl_type,

732: */
733:
734: PROCEDURE party_systems(
735: p_party_id_arg IN VARCHAR2,
736: p_account_id_all IN OKS_ENTITLEMENTS_WEB.account_all_id_tbl_type,
737: p_system_name_arg IN VARCHAR2,
738: x_return_status OUT NOCOPY VARCHAR2,
739: x_party_systems_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_systems_tbl_type
740: )

Line 739: x_party_systems_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_systems_tbl_type

735: p_party_id_arg IN VARCHAR2,
736: p_account_id_all IN OKS_ENTITLEMENTS_WEB.account_all_id_tbl_type,
737: p_system_name_arg IN VARCHAR2,
738: x_return_status OUT NOCOPY VARCHAR2,
739: x_party_systems_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_systems_tbl_type
740: )
741: IS
742: CURSOR party_systems_cur(p_party_id VARCHAR2, p_system_name VARCHAR2)
743: IS

Line 767: l_party_systems_tbl_type OKS_ENTITLEMENTS_WEB.party_systems_tbl_type;

763: and B.SYSTEM_ID = T.SYSTEM_ID
764: and T.LANGUAGE = userenv('LANG')
765: AND T.NAME like p_system_name;
766:
767: l_party_systems_tbl_type OKS_ENTITLEMENTS_WEB.party_systems_tbl_type;
768: l_party_systems_tbl_indx NUMBER :=1;
769: l_account_tbl_indx NUMBER :=1;
770:
771: BEGIN

Line 841: p_account_id_all IN OKS_ENTITLEMENTS_WEB.account_all_id_tbl_type,

837: */
838:
839: PROCEDURE party_products(
840: p_party_id_arg IN VARCHAR2,
841: p_account_id_all IN OKS_ENTITLEMENTS_WEB.account_all_id_tbl_type,
842: p_product_name_arg IN VARCHAR2,
843: x_return_status OUT NOCOPY VARCHAR2,
844: x_party_products_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_products_tbl_type
845: )

Line 844: x_party_products_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_products_tbl_type

840: p_party_id_arg IN VARCHAR2,
841: p_account_id_all IN OKS_ENTITLEMENTS_WEB.account_all_id_tbl_type,
842: p_product_name_arg IN VARCHAR2,
843: x_return_status OUT NOCOPY VARCHAR2,
844: x_party_products_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_products_tbl_type
845: )
846: IS
847: CURSOR party_products_cur(p_party_id VARCHAR2, p_product_name VARCHAR2)
848: IS

Line 871: l_party_products_tbl_type OKS_ENTITLEMENTS_WEB.party_products_tbl_type;

867: and BK.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID
868: and BK.ORGANIZATION_ID = CP.inv_master_organization_id
869: AND BK.DESCRIPTION like p_product_name;
870:
871: l_party_products_tbl_type OKS_ENTITLEMENTS_WEB.party_products_tbl_type;
872: l_party_products_tbl_indx NUMBER :=1;
873: l_account_tbl_indx NUMBER :=1;
874:
875: BEGIN

Line 946: x_contract_cat_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.contract_cat_tbl_type,

942: PROCEDURE adv_search_overview(
943: p_party_id_arg IN VARCHAR2,
944: x_return_status OUT NOCOPY VARCHAR2,
945: x_party_name OUT NOCOPY VARCHAR2,
946: x_contract_cat_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.contract_cat_tbl_type,
947: x_contract_status_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.contract_status_tbl_type
948: )
949: IS
950: CURSOR party_name_cur(p_party_id VARCHAR2)

Line 947: x_contract_status_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.contract_status_tbl_type

943: p_party_id_arg IN VARCHAR2,
944: x_return_status OUT NOCOPY VARCHAR2,
945: x_party_name OUT NOCOPY VARCHAR2,
946: x_contract_cat_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.contract_cat_tbl_type,
947: x_contract_status_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.contract_status_tbl_type
948: )
949: IS
950: CURSOR party_name_cur(p_party_id VARCHAR2)
951: IS

Line 960: l_contract_cat_tbl_type OKS_ENTITLEMENTS_WEB.contract_cat_tbl_type;

956: CURSOR contract_status_cur
957: IS
958: SELECT CODE, MEANING FROM OKC_STATUSES_V ORDER BY MEANING;
959:
960: l_contract_cat_tbl_type OKS_ENTITLEMENTS_WEB.contract_cat_tbl_type;
961: l_contract_status_tbl_type OKS_ENTITLEMENTS_WEB.contract_status_tbl_type;
962: l_party_name VARCHAR2(500);
963:
964: l_contract_cat_tbl_indx NUMBER :=1;

Line 961: l_contract_status_tbl_type OKS_ENTITLEMENTS_WEB.contract_status_tbl_type;

957: IS
958: SELECT CODE, MEANING FROM OKC_STATUSES_V ORDER BY MEANING;
959:
960: l_contract_cat_tbl_type OKS_ENTITLEMENTS_WEB.contract_cat_tbl_type;
961: l_contract_status_tbl_type OKS_ENTITLEMENTS_WEB.contract_status_tbl_type;
962: l_party_name VARCHAR2(500);
963:
964: l_contract_cat_tbl_indx NUMBER :=1;
965: l_contract_status_tbl_indx NUMBER :=1;

Line 1054: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,

1050: PROCEDURE contract_number_overview(
1051: p_contract_number_arg IN VARCHAR2,
1052: p_contract_modifier_arg IN VARCHAR2,
1053: x_return_status OUT NOCOPY VARCHAR2,
1054: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,
1055: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,
1056: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,
1057: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type
1058: )

Line 1055: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,

1051: p_contract_number_arg IN VARCHAR2,
1052: p_contract_modifier_arg IN VARCHAR2,
1053: x_return_status OUT NOCOPY VARCHAR2,
1054: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,
1055: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,
1056: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,
1057: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type
1058: )
1059: IS

Line 1056: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,

1052: p_contract_modifier_arg IN VARCHAR2,
1053: x_return_status OUT NOCOPY VARCHAR2,
1054: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,
1055: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,
1056: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,
1057: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type
1058: )
1059: IS
1060: CURSOR contract_number_id_cur(p_contract_number VARCHAR2)

Line 1057: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type

1053: x_return_status OUT NOCOPY VARCHAR2,
1054: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,
1055: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,
1056: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,
1057: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type
1058: )
1059: IS
1060: CURSOR contract_number_id_cur(p_contract_number VARCHAR2)
1061: IS

Line 1245: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,

1241:
1242: PROCEDURE contract_overview(
1243: p_contract_id_arg IN VARCHAR2,
1244: x_return_status OUT NOCOPY VARCHAR2,
1245: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,
1246: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,
1247: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,
1248: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type
1249: )

Line 1246: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,

1242: PROCEDURE contract_overview(
1243: p_contract_id_arg IN VARCHAR2,
1244: x_return_status OUT NOCOPY VARCHAR2,
1245: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,
1246: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,
1247: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,
1248: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type
1249: )
1250: IS

Line 1247: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,

1243: p_contract_id_arg IN VARCHAR2,
1244: x_return_status OUT NOCOPY VARCHAR2,
1245: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,
1246: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,
1247: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,
1248: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type
1249: )
1250: IS
1251: CURSOR contract_hdr_cur( p_contract_id_arg VARCHAR2)

Line 1248: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type

1244: x_return_status OUT NOCOPY VARCHAR2,
1245: x_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_rec_type,
1246: x_hdr_addr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type,
1247: x_party_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_tbl_type,
1248: x_line_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_tbl_type
1249: )
1250: IS
1251: CURSOR contract_hdr_cur( p_contract_id_arg VARCHAR2)
1252: IS

Line 1561: l_hdr_rec_type OKS_ENTITLEMENTS_WEB.hdr_rec_type;

1557: AND PS.LOCATION_ID = L.LOCATION_ID
1558: AND (CS.SITE_USE_ID = okcLn.BILL_TO_SITE_USE_ID
1559: OR CS.SITE_USE_ID = okcLn.SHIP_TO_SITE_USE_ID);
1560:
1561: l_hdr_rec_type OKS_ENTITLEMENTS_WEB.hdr_rec_type;
1562: l_hdr_addr_rec_type OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type;
1563: l_party_tbl_type OKS_ENTITLEMENTS_WEB.party_tbl_type;
1564: l_line_tbl_type OKS_ENTITLEMENTS_WEB.line_tbl_type;
1565:

Line 1562: l_hdr_addr_rec_type OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type;

1558: AND (CS.SITE_USE_ID = okcLn.BILL_TO_SITE_USE_ID
1559: OR CS.SITE_USE_ID = okcLn.SHIP_TO_SITE_USE_ID);
1560:
1561: l_hdr_rec_type OKS_ENTITLEMENTS_WEB.hdr_rec_type;
1562: l_hdr_addr_rec_type OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type;
1563: l_party_tbl_type OKS_ENTITLEMENTS_WEB.party_tbl_type;
1564: l_line_tbl_type OKS_ENTITLEMENTS_WEB.line_tbl_type;
1565:
1566: l_party_tbl_indx NUMBER :=1;

Line 1563: l_party_tbl_type OKS_ENTITLEMENTS_WEB.party_tbl_type;

1559: OR CS.SITE_USE_ID = okcLn.SHIP_TO_SITE_USE_ID);
1560:
1561: l_hdr_rec_type OKS_ENTITLEMENTS_WEB.hdr_rec_type;
1562: l_hdr_addr_rec_type OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type;
1563: l_party_tbl_type OKS_ENTITLEMENTS_WEB.party_tbl_type;
1564: l_line_tbl_type OKS_ENTITLEMENTS_WEB.line_tbl_type;
1565:
1566: l_party_tbl_indx NUMBER :=1;
1567: l_line_tbl_indx NUMBER :=1;

Line 1564: l_line_tbl_type OKS_ENTITLEMENTS_WEB.line_tbl_type;

1560:
1561: l_hdr_rec_type OKS_ENTITLEMENTS_WEB.hdr_rec_type;
1562: l_hdr_addr_rec_type OKS_ENTITLEMENTS_WEB.hdr_addr_rec_type;
1563: l_party_tbl_type OKS_ENTITLEMENTS_WEB.party_tbl_type;
1564: l_line_tbl_type OKS_ENTITLEMENTS_WEB.line_tbl_type;
1565:
1566: l_party_tbl_indx NUMBER :=1;
1567: l_line_tbl_indx NUMBER :=1;
1568: l_duration NUMBER;

Line 1980: x_party_contact_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_contact_tbl_type

1976: PROCEDURE party_overview(
1977: p_contract_id_arg IN VARCHAR2,
1978: p_party_rle_code_arg IN VARCHAR2,
1979: x_return_status OUT NOCOPY VARCHAR2,
1980: x_party_contact_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.party_contact_tbl_type
1981: )
1982: IS
1983: CURSOR party_contact_email_cur( p_owner_table_id VARCHAR)
1984: IS

Line 2033: l_party_contact_tbl_type OKS_ENTITLEMENTS_WEB.party_contact_tbl_type;

2029: SELECT email_address
2030: FROM JTF_RS_GROUPS_B
2031: WHERE group_id = p_contact_id;
2032:
2033: l_party_contact_tbl_type OKS_ENTITLEMENTS_WEB.party_contact_tbl_type;
2034:
2035: l_party_contact_tbl_indx NUMBER :=1;
2036: l_org_id NUMBER;
2037:

Line 2140: x_pty_cntct_dtls_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.pty_cntct_dtls_tbl_type

2136:
2137: PROCEDURE party_contacts_overview(
2138: p_contact_id_arg IN VARCHAR2,
2139: x_return_status OUT NOCOPY VARCHAR2,
2140: x_pty_cntct_dtls_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.pty_cntct_dtls_tbl_type
2141: )
2142: IS
2143: CURSOR party_contact_details_cur(p_contact_id_arg VARCHAR2)
2144: IS

Line 2167: l_pty_cntct_dtls_tbl_type OKS_ENTITLEMENTS_WEB.pty_cntct_dtls_tbl_type;

2163: From
2164: OKS_CONTACT_POINTS_V
2165: Where OWNER_TABLE_ID = to_number(p_contact_id_arg);
2166:
2167: l_pty_cntct_dtls_tbl_type OKS_ENTITLEMENTS_WEB.pty_cntct_dtls_tbl_type;
2168:
2169: l_party_contact_tbl_indx NUMBER :=1;
2170:
2171: BEGIN

Line 2408: x_line_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_hdr_rec_type,

2404:
2405: PROCEDURE line_overview(
2406: p_line_id_arg IN VARCHAR2,
2407: x_return_status OUT NOCOPY VARCHAR2,
2408: x_line_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_hdr_rec_type,
2409: x_covered_level_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.covered_level_tbl_type,
2410: x_cust_contacts_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.cust_contacts_tbl_type
2411: )
2412: IS

Line 2409: x_covered_level_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.covered_level_tbl_type,

2405: PROCEDURE line_overview(
2406: p_line_id_arg IN VARCHAR2,
2407: x_return_status OUT NOCOPY VARCHAR2,
2408: x_line_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_hdr_rec_type,
2409: x_covered_level_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.covered_level_tbl_type,
2410: x_cust_contacts_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.cust_contacts_tbl_type
2411: )
2412: IS
2413: CURSOR line_renewal_cur(p_line_id_arg VARCHAR2)

Line 2410: x_cust_contacts_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.cust_contacts_tbl_type

2406: p_line_id_arg IN VARCHAR2,
2407: x_return_status OUT NOCOPY VARCHAR2,
2408: x_line_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.line_hdr_rec_type,
2409: x_covered_level_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.covered_level_tbl_type,
2410: x_cust_contacts_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.cust_contacts_tbl_type
2411: )
2412: IS
2413: CURSOR line_renewal_cur(p_line_id_arg VARCHAR2)
2414: IS

Line 2721: l_line_hdr_rec_type OKS_ENTITLEMENTS_WEB.line_hdr_rec_type;

2717: AND HZR.RELATIONSHIP_CODE IN ('CONTACT_OF','EMPLOYEE_OF')
2718: AND HZR.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2719: AND HZR.SUBJECT_ID = HZP.PARTY_ID ;
2720:
2721: l_line_hdr_rec_type OKS_ENTITLEMENTS_WEB.line_hdr_rec_type;
2722: l_covered_level_tbl_type OKS_ENTITLEMENTS_WEB.covered_level_tbl_type;
2723: l_cust_contacts_tbl_type OKS_ENTITLEMENTS_WEB.cust_contacts_tbl_type;
2724:
2725: l_covered_level_tbl_indx NUMBER :=1;

Line 2722: l_covered_level_tbl_type OKS_ENTITLEMENTS_WEB.covered_level_tbl_type;

2718: AND HZR.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2719: AND HZR.SUBJECT_ID = HZP.PARTY_ID ;
2720:
2721: l_line_hdr_rec_type OKS_ENTITLEMENTS_WEB.line_hdr_rec_type;
2722: l_covered_level_tbl_type OKS_ENTITLEMENTS_WEB.covered_level_tbl_type;
2723: l_cust_contacts_tbl_type OKS_ENTITLEMENTS_WEB.cust_contacts_tbl_type;
2724:
2725: l_covered_level_tbl_indx NUMBER :=1;
2726: l_customer_contact_tbl_indx NUMBER :=1;

Line 2723: l_cust_contacts_tbl_type OKS_ENTITLEMENTS_WEB.cust_contacts_tbl_type;

2719: AND HZR.SUBJECT_ID = HZP.PARTY_ID ;
2720:
2721: l_line_hdr_rec_type OKS_ENTITLEMENTS_WEB.line_hdr_rec_type;
2722: l_covered_level_tbl_type OKS_ENTITLEMENTS_WEB.covered_level_tbl_type;
2723: l_cust_contacts_tbl_type OKS_ENTITLEMENTS_WEB.cust_contacts_tbl_type;
2724:
2725: l_covered_level_tbl_indx NUMBER :=1;
2726: l_customer_contact_tbl_indx NUMBER :=1;
2727: l_duration NUMBER;

Line 2925: x_coverage_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_rec_type,

2921: PROCEDURE coverage_overview(
2922: p_coverage_ID_arg IN VARCHAR2,
2923: p_contract_ID_arg IN VARCHAR2,
2924: x_return_status OUT NOCOPY VARCHAR2,
2925: x_coverage_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_rec_type,
2926: x_bus_proc_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_tbl_type
2927: )
2928: IS
2929: CURSOR coverage_warranty_cur(p_coverage_ID_arg VARCHAR2)

Line 2926: x_bus_proc_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_tbl_type

2922: p_coverage_ID_arg IN VARCHAR2,
2923: p_contract_ID_arg IN VARCHAR2,
2924: x_return_status OUT NOCOPY VARCHAR2,
2925: x_coverage_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_rec_type,
2926: x_bus_proc_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_tbl_type
2927: )
2928: IS
2929: CURSOR coverage_warranty_cur(p_coverage_ID_arg VARCHAR2)
2930: IS

Line 3007: l_coverage_rec_type OKS_ENTITLEMENTS_WEB.coverage_rec_type;

3003: Where
3004: oksLn.CLE_ID = business_proc_id
3005: and dis.ID1 = oksLn.DISCOUNT_LIST;
3006:
3007: l_coverage_rec_type OKS_ENTITLEMENTS_WEB.coverage_rec_type;
3008: l_bus_proc_tbl_type OKS_ENTITLEMENTS_WEB.bus_proc_tbl_type;
3009:
3010: l_bus_proc_tbl_indx NUMBER := 1;
3011:

Line 3008: l_bus_proc_tbl_type OKS_ENTITLEMENTS_WEB.bus_proc_tbl_type;

3004: oksLn.CLE_ID = business_proc_id
3005: and dis.ID1 = oksLn.DISCOUNT_LIST;
3006:
3007: l_coverage_rec_type OKS_ENTITLEMENTS_WEB.coverage_rec_type;
3008: l_bus_proc_tbl_type OKS_ENTITLEMENTS_WEB.bus_proc_tbl_type;
3009:
3010: l_bus_proc_tbl_indx NUMBER := 1;
3011:
3012: BEGIN

Line 3126: x_bus_proc_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type,

3122: PROCEDURE bus_proc_overview(
3123: p_bus_proc_ID_arg IN VARCHAR2,
3124: p_contract_ID_arg IN VARCHAR2,
3125: x_return_status OUT NOCOPY VARCHAR2,
3126: x_bus_proc_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type,
3127: x_coverage_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type,
3128: x_reaction_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type,
3129: x_resolution_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type,
3130: x_pref_resource_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type,

Line 3127: x_coverage_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type,

3123: p_bus_proc_ID_arg IN VARCHAR2,
3124: p_contract_ID_arg IN VARCHAR2,
3125: x_return_status OUT NOCOPY VARCHAR2,
3126: x_bus_proc_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type,
3127: x_coverage_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type,
3128: x_reaction_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type,
3129: x_resolution_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type,
3130: x_pref_resource_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type,
3131: x_bus_proc_bil_typ_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type

Line 3128: x_reaction_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type,

3124: p_contract_ID_arg IN VARCHAR2,
3125: x_return_status OUT NOCOPY VARCHAR2,
3126: x_bus_proc_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type,
3127: x_coverage_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type,
3128: x_reaction_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type,
3129: x_resolution_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type,
3130: x_pref_resource_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type,
3131: x_bus_proc_bil_typ_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type
3132: )

Line 3129: x_resolution_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type,

3125: x_return_status OUT NOCOPY VARCHAR2,
3126: x_bus_proc_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type,
3127: x_coverage_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type,
3128: x_reaction_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type,
3129: x_resolution_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type,
3130: x_pref_resource_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type,
3131: x_bus_proc_bil_typ_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type
3132: )
3133: IS

Line 3130: x_pref_resource_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type,

3126: x_bus_proc_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type,
3127: x_coverage_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type,
3128: x_reaction_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type,
3129: x_resolution_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type,
3130: x_pref_resource_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type,
3131: x_bus_proc_bil_typ_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type
3132: )
3133: IS
3134: CURSOR bus_proc_hdr_cur(p_bus_proc_ID_arg VARCHAR2)

Line 3131: x_bus_proc_bil_typ_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type

3127: x_coverage_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type,
3128: x_reaction_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type,
3129: x_resolution_times_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type,
3130: x_pref_resource_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type,
3131: x_bus_proc_bil_typ_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type
3132: )
3133: IS
3134: CURSOR bus_proc_hdr_cur(p_bus_proc_ID_arg VARCHAR2)
3135: IS

Line 3422: l_bus_proc_hdr_rec_type OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type;

3418: and fnd.lookup_type(+) = 'OKS_BILLING_RATE'
3419: and fnd.lookup_code(+) = bsh.bill_rate_code
3420: and bsh.holiday_yn = 'N';
3421:
3422: l_bus_proc_hdr_rec_type OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type;
3423: l_coverage_times_tbl_type OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type;
3424: l_reaction_times_tbl_type OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type;
3425: l_resolution_times_tbl_type OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type;
3426: l_pref_resource_tbl_type OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type;

Line 3423: l_coverage_times_tbl_type OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type;

3419: and fnd.lookup_code(+) = bsh.bill_rate_code
3420: and bsh.holiday_yn = 'N';
3421:
3422: l_bus_proc_hdr_rec_type OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type;
3423: l_coverage_times_tbl_type OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type;
3424: l_reaction_times_tbl_type OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type;
3425: l_resolution_times_tbl_type OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type;
3426: l_pref_resource_tbl_type OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type;
3427: l_bus_proc_bil_typ_tbl_type OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type;

Line 3424: l_reaction_times_tbl_type OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type;

3420: and bsh.holiday_yn = 'N';
3421:
3422: l_bus_proc_hdr_rec_type OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type;
3423: l_coverage_times_tbl_type OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type;
3424: l_reaction_times_tbl_type OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type;
3425: l_resolution_times_tbl_type OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type;
3426: l_pref_resource_tbl_type OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type;
3427: l_bus_proc_bil_typ_tbl_type OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type;
3428:

Line 3425: l_resolution_times_tbl_type OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type;

3421:
3422: l_bus_proc_hdr_rec_type OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type;
3423: l_coverage_times_tbl_type OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type;
3424: l_reaction_times_tbl_type OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type;
3425: l_resolution_times_tbl_type OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type;
3426: l_pref_resource_tbl_type OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type;
3427: l_bus_proc_bil_typ_tbl_type OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type;
3428:
3429: l_coverage_times_tbl_indx NUMBER := 1;

Line 3426: l_pref_resource_tbl_type OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type;

3422: l_bus_proc_hdr_rec_type OKS_ENTITLEMENTS_WEB.bus_proc_hdr_rec_type;
3423: l_coverage_times_tbl_type OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type;
3424: l_reaction_times_tbl_type OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type;
3425: l_resolution_times_tbl_type OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type;
3426: l_pref_resource_tbl_type OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type;
3427: l_bus_proc_bil_typ_tbl_type OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type;
3428:
3429: l_coverage_times_tbl_indx NUMBER := 1;
3430: l_reaction_times_tbl_indx NUMBER := 1;

Line 3427: l_bus_proc_bil_typ_tbl_type OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type;

3423: l_coverage_times_tbl_type OKS_ENTITLEMENTS_WEB.coverage_times_tbl_type;
3424: l_reaction_times_tbl_type OKS_ENTITLEMENTS_WEB.reaction_times_tbl_type;
3425: l_resolution_times_tbl_type OKS_ENTITLEMENTS_WEB.resolution_times_tbl_type;
3426: l_pref_resource_tbl_type OKS_ENTITLEMENTS_WEB.pref_resource_tbl_type;
3427: l_bus_proc_bil_typ_tbl_type OKS_ENTITLEMENTS_WEB.bus_proc_bil_typ_tbl_type;
3428:
3429: l_coverage_times_tbl_indx NUMBER := 1;
3430: l_reaction_times_tbl_indx NUMBER := 1;
3431: l_resolution_times_tbl_indx NUMBER := 1;

Line 3638: x_usage_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.usage_hdr_rec_type,

3634:
3635: PROCEDURE usage_overview(
3636: p_line_id_arg IN VARCHAR2,
3637: x_return_status OUT NOCOPY VARCHAR2,
3638: x_usage_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.usage_hdr_rec_type,
3639: x_covered_prods_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.covered_prods_tbl_type
3640: )
3641: IS
3642: CURSOR usage_invoice_cur(p_line_id_arg VARCHAR2)

Line 3639: x_covered_prods_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.covered_prods_tbl_type

3635: PROCEDURE usage_overview(
3636: p_line_id_arg IN VARCHAR2,
3637: x_return_status OUT NOCOPY VARCHAR2,
3638: x_usage_hdr_rec_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.usage_hdr_rec_type,
3639: x_covered_prods_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.covered_prods_tbl_type
3640: )
3641: IS
3642: CURSOR usage_invoice_cur(p_line_id_arg VARCHAR2)
3643: IS

Line 3844: l_usage_hdr_rec_type OKS_ENTITLEMENTS_WEB.usage_hdr_rec_type;

3840: and ln.ID = itm.CLE_ID
3841: and ln.DNZ_CHR_ID = hdr.ID
3842: AND ln.cle_ID IS NULL ;
3843:
3844: l_usage_hdr_rec_type OKS_ENTITLEMENTS_WEB.usage_hdr_rec_type;
3845: l_covered_prods_tbl_type OKS_ENTITLEMENTS_WEB.covered_prods_tbl_type;
3846:
3847: l_covered_prod_tbl_indx NUMBER := 1;
3848: l_org_id NUMBER;

Line 3845: l_covered_prods_tbl_type OKS_ENTITLEMENTS_WEB.covered_prods_tbl_type;

3841: and ln.DNZ_CHR_ID = hdr.ID
3842: AND ln.cle_ID IS NULL ;
3843:
3844: l_usage_hdr_rec_type OKS_ENTITLEMENTS_WEB.usage_hdr_rec_type;
3845: l_covered_prods_tbl_type OKS_ENTITLEMENTS_WEB.covered_prods_tbl_type;
3846:
3847: l_covered_prod_tbl_indx NUMBER := 1;
3848: l_org_id NUMBER;
3849: BEGIN

Line 3973: x_counter_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.counter_tbl_type

3969:
3970: PROCEDURE product_overview(
3971: p_covered_prod_ID_arg IN VARCHAR2,
3972: x_return_status OUT NOCOPY VARCHAR2,
3973: x_counter_tbl_type OUT NOCOPY OKS_ENTITLEMENTS_WEB.counter_tbl_type
3974: )
3975: IS
3976: CURSOR counter_cur(p_covered_prod_ID_arg VARCHAR2)
3977: IS

Line 4092: l_counter_tbl_type OKS_ENTITLEMENTS_WEB.counter_tbl_type;

4088: AND KL.ID = KI.CLE_ID
4089: AND KI.JTOT_OBJECT1_CODE IN('OKX_SERVICE','OKX_WARRANTY','OKX_USAGE')
4090: AND CCB.COUNTER_ID = to_number(p_covered_prod_ID_arg);
4091:
4092: l_counter_tbl_type OKS_ENTITLEMENTS_WEB.counter_tbl_type;
4093:
4094: l_covered_prod_tbl_indx NUMBER := 1;
4095:
4096: BEGIN

Line 4133: END OKS_ENTITLEMENTS_WEB;

4129: x_return_status := g_ret_sts_unexp_error;
4130:
4131: END product_overview;
4132: ----------------------------------------------------------------------------------
4133: END OKS_ENTITLEMENTS_WEB;