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.CS_SERVICE_PVT dependencies on CS_CP_SERVICES_S

Line 5: SELECT CS_CP_SERVICES_S.nextval FROM SYS.DUAL;

1: PACKAGE BODY CS_SERVICE_PVT AS
2: /* $Header: csctserb.pls 115.2 99/07/16 08:54:18 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CP_SERVICES_S.nextval FROM SYS.DUAL;
6: l_seq_id NUMBER := 0;
7: BEGIN
8: OPEN get_seq_id_csr;
9: FETCH get_seq_id_csr INTO l_seq_id;

Line 652: p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := NULL,

648: p_contract_line_template_id IN NUMBER := NULL,
649: p_contract_id IN NUMBER := NULL,
650: p_service_inventory_item_id IN NUMBER := NULL,
651: p_service_manufacturing_org_id IN NUMBER := NULL,
652: p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := NULL,
653: p_lst_cp_srvic_trnsctin_id IN NUMBER := NULL,
654: p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := NULL,
655: p_coverage_schedule_id IN NUMBER := NULL,
656: p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := NULL,

Line 662: p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := NULL,

658: p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
659: p_starting_delay IN NUMBER := NULL,
660: p_bill_to_site_use_id IN NUMBER := NULL,
661: p_bill_to_contact_id IN NUMBER := NULL,
662: p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := NULL,
663: p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := NULL,
664: p_pm_visits_completed IN NUMBER := NULL,
665: p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := NULL,
666: p_pm_schedule_id IN NUMBER := NULL,

Line 670: p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := NULL,

666: p_pm_schedule_id IN NUMBER := NULL,
667: p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := NULL,
668: p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := NULL,
669: p_price_list_id IN NUMBER := NULL,
670: p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := NULL,
671: p_invoice_count IN NUMBER := NULL,
672: p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := NULL,
673: p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := NULL,
674: p_conversion_rate IN NUMBER := NULL,

Line 680: p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := NULL,

676: p_original_service_line_id IN NUMBER := NULL,
677: p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := NULL,
678: p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := NULL,
679: p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := NULL,
680: p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := NULL,
681: p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := NULL,
682: p_ship_to_site_use_id IN NUMBER := NULL,
683: p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := NULL,
684: p_extended_price IN NUMBER := NULL,

Line 696: p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := NULL,

692: p_created_by IN NUMBER := NULL,
693: p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := NULL,
694: p_last_updated_by IN NUMBER := NULL,
695: p_last_update_login IN NUMBER := NULL,
696: p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := NULL,
697: p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := NULL,
698: p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := NULL,
699: p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := NULL,
700: p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := NULL,

Line 2005: p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

2001: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2002: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2003: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2004: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2005: p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2006: p_lst_cp_srvic_trnsctin_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2007: p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2008: p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2009: p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 2015: p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

2011: p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2012: p_starting_delay IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2013: p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2014: p_bill_to_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2015: p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2016: p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2017: p_pm_visits_completed IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2018: p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2019: p_pm_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 2023: p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

2019: p_pm_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2020: p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2021: p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2022: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2023: p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2024: p_invoice_count IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2025: p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2026: p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2027: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 2033: p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

2029: p_original_service_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2030: p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2031: p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2032: p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2033: p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2034: p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2035: p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2036: p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2037: p_extended_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 2049: p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

2045: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2046: p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2047: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2048: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2049: p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2050: p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2051: p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2052: p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2053: p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 2405: p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

2401: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2402: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2403: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2404: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2405: p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2406: p_lst_cp_srvic_trnsctin_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2407: p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2408: p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2409: p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 2415: p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

2411: p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2412: p_starting_delay IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2413: p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2414: p_bill_to_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2415: p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2416: p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2417: p_pm_visits_completed IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2418: p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2419: p_pm_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 2423: p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

2419: p_pm_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2420: p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2421: p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2422: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2423: p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2424: p_invoice_count IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2425: p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2426: p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2427: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 2433: p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

2429: p_original_service_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2430: p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2431: p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2432: p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2433: p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2434: p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2435: p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2436: p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2437: p_extended_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 2449: p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

2445: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2446: p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2447: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2448: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2449: p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2450: p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
2451: p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2452: p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
2453: p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,