[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT CS_CP_SERVICES_S.nextval FROM SYS.DUAL;
ELSIF p_service_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
p_service_rec.last_update_date IS NULL
THEN
TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
ELSIF p_service_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
p_service_rec.last_updated_by IS NULL
THEN
TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
SELECT *
FROM Cs_Contract_Statuses
WHERE cs_contract_statuses.contract_status_id = p_contract_status_id;
SELECT *
FROM Cs_Contract_Line_Tplts
WHERE cs_contract_line_tplts.contract_line_template_id = p_contract_line_template_id;
SELECT *
FROM Cs_Customer_Products
WHERE cs_customer_products.customer_product_id = p_customer_product_id;
SELECT *
FROM Cs_Contracts_All
WHERE cs_contracts_all.contract_id = p_contract_id;
p_to.last_update_date := p_from.last_update_date;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_login := p_from.last_update_login;
p_to.last_update_date := p_from.last_update_date;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_login := p_from.last_update_login;
PROCEDURE insert_row
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
p_validation_level IN NUMBER,
p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
x_return_status OUT VARCHAR2,
x_msg_count OUT NUMBER,
x_msg_data OUT VARCHAR2,
p_service_rec IN Service_Rec_Type := G_MISS_SERVICE_REC,
x_cp_service_id OUT NUMBER) IS
l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
INSERT INTO CS_CP_SERVICES(
cp_service_id,
customer_product_id,
contract_line_status_id,
contract_line_template_id,
contract_id,
service_inventory_item_id,
service_manufacturing_org_id,
status_code,
last_cp_service_transaction_id,
invoice_flag,
coverage_schedule_id,
prorate_flag,
duration_quantity,
unit_of_measure_code,
starting_delay,
bill_to_site_use_id,
bill_to_contact_id,
service_txn_availability_code,
next_pm_visit_date,
pm_visits_completed,
last_pm_visit_date,
pm_schedule_id,
pm_schedule_flag,
current_max_schedule_date,
price_list_id,
service_order_type,
invoice_count,
currency_code,
conversion_type,
conversion_rate,
conversion_date,
original_service_line_id,
warranty_flag,
original_start_date,
original_end_date,
service_date_change,
workflow,
ship_to_site_use_id,
original_system_line_reference,
extended_price,
discount_id,
tax_code,
billing_frequency_period,
first_bill_date,
next_bill_date,
creation_date,
bill_on,
created_by,
last_update_date,
last_updated_by,
last_update_login,
start_date_active,
end_date_active,
pricing_attribute1,
pricing_attribute2,
pricing_attribute3,
pricing_attribute4,
pricing_attribute5,
pricing_attribute6,
pricing_attribute7,
pricing_attribute8,
pricing_attribute9,
pricing_attribute10,
pricing_attribute11,
pricing_attribute12,
pricing_attribute13,
pricing_attribute14,
pricing_attribute15,
pricing_context,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
context,
list_price,
org_id,
price_percent)
VALUES (
l_def_service_rec.cp_service_id,
l_def_service_rec.customer_product_id,
l_def_service_rec.contract_line_status_id,
l_def_service_rec.contract_line_template_id,
l_def_service_rec.contract_id,
l_def_service_rec.service_inventory_item_id,
l_def_service_rec.service_manufacturing_org_id,
l_def_service_rec.status_code,
l_def_service_rec.last_cp_service_transaction_id,
l_def_service_rec.invoice_flag,
l_def_service_rec.coverage_schedule_id,
l_def_service_rec.prorate_flag,
l_def_service_rec.duration_quantity,
l_def_service_rec.unit_of_measure_code,
l_def_service_rec.starting_delay,
l_def_service_rec.bill_to_site_use_id,
l_def_service_rec.bill_to_contact_id,
l_def_service_rec.service_txn_availability_code,
l_def_service_rec.next_pm_visit_date,
l_def_service_rec.pm_visits_completed,
l_def_service_rec.last_pm_visit_date,
l_def_service_rec.pm_schedule_id,
l_def_service_rec.pm_schedule_flag,
l_def_service_rec.current_max_schedule_date,
l_def_service_rec.price_list_id,
l_def_service_rec.service_order_type,
l_def_service_rec.invoice_count,
l_def_service_rec.currency_code,
l_def_service_rec.conversion_type,
l_def_service_rec.conversion_rate,
l_def_service_rec.conversion_date,
l_def_service_rec.original_service_line_id,
l_def_service_rec.warranty_flag,
l_def_service_rec.original_start_date,
l_def_service_rec.original_end_date,
l_def_service_rec.service_date_change,
l_def_service_rec.workflow,
l_def_service_rec.ship_to_site_use_id,
l_def_service_rec.original_system_line_reference,
l_def_service_rec.extended_price,
l_def_service_rec.discount_id,
l_def_service_rec.tax_code,
l_def_service_rec.billing_frequency_period,
l_def_service_rec.first_bill_date,
l_def_service_rec.next_bill_date,
l_def_service_rec.creation_date,
l_def_service_rec.bill_on,
l_def_service_rec.created_by,
l_def_service_rec.last_update_date,
l_def_service_rec.last_updated_by,
l_def_service_rec.last_update_login,
l_def_service_rec.start_date_active,
l_def_service_rec.end_date_active,
l_def_service_rec.pricing_attribute1,
l_def_service_rec.pricing_attribute2,
l_def_service_rec.pricing_attribute3,
l_def_service_rec.pricing_attribute4,
l_def_service_rec.pricing_attribute5,
l_def_service_rec.pricing_attribute6,
l_def_service_rec.pricing_attribute7,
l_def_service_rec.pricing_attribute8,
l_def_service_rec.pricing_attribute9,
l_def_service_rec.pricing_attribute10,
l_def_service_rec.pricing_attribute11,
l_def_service_rec.pricing_attribute12,
l_def_service_rec.pricing_attribute13,
l_def_service_rec.pricing_attribute14,
l_def_service_rec.pricing_attribute15,
l_def_service_rec.pricing_context,
l_def_service_rec.attribute1,
l_def_service_rec.attribute2,
l_def_service_rec.attribute3,
l_def_service_rec.attribute4,
l_def_service_rec.attribute5,
l_def_service_rec.attribute6,
l_def_service_rec.attribute7,
l_def_service_rec.attribute8,
l_def_service_rec.attribute9,
l_def_service_rec.attribute10,
l_def_service_rec.attribute11,
l_def_service_rec.attribute12,
l_def_service_rec.attribute13,
l_def_service_rec.attribute14,
l_def_service_rec.attribute15,
l_def_service_rec.context,
l_def_service_rec.list_price,
l_def_service_rec.org_id,
l_def_service_rec.price_percent);
END insert_row;
PROCEDURE insert_row
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
p_validation_level IN NUMBER,
p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
x_return_status OUT VARCHAR2,
x_msg_count OUT NUMBER,
x_msg_data OUT VARCHAR2,
p_customer_product_id IN NUMBER := NULL,
p_contract_line_status_id IN NUMBER := NULL,
p_contract_line_template_id IN NUMBER := NULL,
p_contract_id IN NUMBER := NULL,
p_service_inventory_item_id IN NUMBER := NULL,
p_service_manufacturing_org_id IN NUMBER := NULL,
p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := NULL,
p_lst_cp_srvic_trnsctin_id IN NUMBER := NULL,
p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := NULL,
p_coverage_schedule_id IN NUMBER := NULL,
p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := NULL,
p_duration_quantity IN NUMBER := NULL,
p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
p_starting_delay IN NUMBER := NULL,
p_bill_to_site_use_id IN NUMBER := NULL,
p_bill_to_contact_id IN NUMBER := NULL,
p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := NULL,
p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := NULL,
p_pm_visits_completed IN NUMBER := NULL,
p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := NULL,
p_pm_schedule_id IN NUMBER := NULL,
p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := NULL,
p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := NULL,
p_price_list_id IN NUMBER := NULL,
p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := NULL,
p_invoice_count IN NUMBER := NULL,
p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := NULL,
p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := NULL,
p_conversion_rate IN NUMBER := NULL,
p_conversion_date IN CS_CP_SERVICES.CONVERSION_DATE%TYPE := NULL,
p_original_service_line_id IN NUMBER := NULL,
p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := NULL,
p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := NULL,
p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := NULL,
p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := NULL,
p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := NULL,
p_ship_to_site_use_id IN NUMBER := NULL,
p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := NULL,
p_extended_price IN NUMBER := NULL,
p_discount_id IN NUMBER := NULL,
p_tax_code IN CS_CP_SERVICES.TAX_CODE%TYPE := NULL,
p_billing_frequency_period IN CS_CP_SERVICES.BILLING_FREQUENCY_PERIOD%TYPE := NULL,
p_first_bill_date IN CS_CP_SERVICES.FIRST_BILL_DATE%TYPE := NULL,
p_next_bill_date IN CS_CP_SERVICES.NEXT_BILL_DATE%TYPE := NULL,
p_creation_date IN CS_CP_SERVICES.CREATION_DATE%TYPE := NULL,
p_bill_on IN NUMBER := NULL,
p_created_by IN NUMBER := NULL,
p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := NULL,
p_last_updated_by IN NUMBER := NULL,
p_last_update_login IN NUMBER := NULL,
p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := NULL,
p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := NULL,
p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := NULL,
p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := NULL,
p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := NULL,
p_pricing_attribute4 IN CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := NULL,
p_pricing_attribute5 IN CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := NULL,
p_pricing_attribute6 IN CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := NULL,
p_pricing_attribute7 IN CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := NULL,
p_pricing_attribute8 IN CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := NULL,
p_pricing_attribute9 IN CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := NULL,
p_pricing_attribute10 IN CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := NULL,
p_pricing_attribute11 IN CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := NULL,
p_pricing_attribute12 IN CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := NULL,
p_pricing_attribute13 IN CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := NULL,
p_pricing_attribute14 IN CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := NULL,
p_pricing_attribute15 IN CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := NULL,
p_pricing_context IN CS_CP_SERVICES.PRICING_CONTEXT%TYPE := NULL,
p_attribute1 IN CS_CP_SERVICES.ATTRIBUTE1%TYPE := NULL,
p_attribute2 IN CS_CP_SERVICES.ATTRIBUTE2%TYPE := NULL,
p_attribute3 IN CS_CP_SERVICES.ATTRIBUTE3%TYPE := NULL,
p_attribute4 IN CS_CP_SERVICES.ATTRIBUTE4%TYPE := NULL,
p_attribute5 IN CS_CP_SERVICES.ATTRIBUTE5%TYPE := NULL,
p_attribute6 IN CS_CP_SERVICES.ATTRIBUTE6%TYPE := NULL,
p_attribute7 IN CS_CP_SERVICES.ATTRIBUTE7%TYPE := NULL,
p_attribute8 IN CS_CP_SERVICES.ATTRIBUTE8%TYPE := NULL,
p_attribute9 IN CS_CP_SERVICES.ATTRIBUTE9%TYPE := NULL,
p_attribute10 IN CS_CP_SERVICES.ATTRIBUTE10%TYPE := NULL,
p_attribute11 IN CS_CP_SERVICES.ATTRIBUTE11%TYPE := NULL,
p_attribute12 IN CS_CP_SERVICES.ATTRIBUTE12%TYPE := NULL,
p_attribute13 IN CS_CP_SERVICES.ATTRIBUTE13%TYPE := NULL,
p_attribute14 IN CS_CP_SERVICES.ATTRIBUTE14%TYPE := NULL,
p_attribute15 IN CS_CP_SERVICES.ATTRIBUTE15%TYPE := NULL,
p_context IN CS_CP_SERVICES.CONTEXT%TYPE := NULL,
p_list_price IN NUMBER := NULL,
p_org_id IN NUMBER := NULL,
p_price_percent IN NUMBER := NULL,
x_cp_service_id OUT NUMBER) IS
l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
l_service_rec.LAST_UPDATE_DATE := p_last_update_date;
l_service_rec.LAST_UPDATED_BY := p_last_updated_by;
l_service_rec.LAST_UPDATE_LOGIN := p_last_update_login;
insert_row(
p_api_version,
p_init_msg_list,
p_validation_level,
p_commit,
x_return_status,
x_msg_count,
x_msg_data,
l_service_rec,
x_cp_service_id
);
END insert_row;
p_last_update_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER,
p_start_date_active IN DATE,
p_end_date_active IN DATE,
p_pricing_attribute1 IN VARCHAR2,
p_pricing_attribute2 IN VARCHAR2,
p_pricing_attribute3 IN VARCHAR2,
p_pricing_attribute4 IN VARCHAR2,
p_pricing_attribute5 IN VARCHAR2,
p_pricing_attribute6 IN VARCHAR2,
p_pricing_attribute7 IN VARCHAR2,
p_pricing_attribute8 IN VARCHAR2,
p_pricing_attribute9 IN VARCHAR2,
p_pricing_attribute10 IN VARCHAR2,
p_pricing_attribute11 IN VARCHAR2,
p_pricing_attribute12 IN VARCHAR2,
p_pricing_attribute13 IN VARCHAR2,
p_pricing_attribute14 IN VARCHAR2,
p_pricing_attribute15 IN VARCHAR2,
p_pricing_context IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_context IN VARCHAR2,
p_list_price IN NUMBER,
p_org_id IN NUMBER,
p_price_percent IN NUMBER) IS
E_Resource_Busy EXCEPTION;
SELECT *
FROM CS_CP_SERVICES
WHERE
CP_SERVICE_ID = p_cp_service_id
FOR UPDATE NOWAIT;
TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
IF (l_object_version_number.LAST_UPDATE_DATE <> p_last_update_date) THEN
TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
IF (l_object_version_number.LAST_UPDATED_BY <> p_last_updated_by) THEN
TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
IF (l_object_version_number.LAST_UPDATE_LOGIN <> p_last_update_login) THEN
TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
Procedure update_row
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
p_validation_level IN NUMBER,
p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
x_return_status OUT VARCHAR2,
x_msg_count OUT NUMBER,
x_msg_data OUT VARCHAR2,
p_service_val_rec IN Service_Val_Rec_Type := G_MISS_SERVICE_VAL_REC) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_row';
SELECT *
FROM Cs_Cp_Services
WHERE cs_cp_services.cp_service_id = p_cp_service_id;
IF (x_service_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
THEN
x_service_rec.last_update_date := l_cs_cp_services_pk.last_update_date;
IF (x_service_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
THEN
x_service_rec.last_updated_by := l_cs_cp_services_pk.last_updated_by;
IF (x_service_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
THEN
x_service_rec.last_update_login := l_cs_cp_services_pk.last_update_login;
UPDATE CS_CP_SERVICES
SET
CP_SERVICE_ID = l_def_service_rec.cp_service_id ,
CUSTOMER_PRODUCT_ID = l_def_service_rec.customer_product_id ,
CONTRACT_LINE_STATUS_ID = l_def_service_rec.contract_line_status_id ,
CONTRACT_LINE_TEMPLATE_ID = l_def_service_rec.contract_line_template_id ,
CONTRACT_ID = l_def_service_rec.contract_id ,
SERVICE_INVENTORY_ITEM_ID = l_def_service_rec.service_inventory_item_id ,
SERVICE_MANUFACTURING_ORG_ID = l_def_service_rec.service_manufacturing_org_id ,
STATUS_CODE = l_def_service_rec.status_code ,
LAST_CP_SERVICE_TRANSACTION_ID = l_def_service_rec.last_cp_service_transaction_id ,
INVOICE_FLAG = l_def_service_rec.invoice_flag ,
COVERAGE_SCHEDULE_ID = l_def_service_rec.coverage_schedule_id ,
PRORATE_FLAG = l_def_service_rec.prorate_flag ,
DURATION_QUANTITY = l_def_service_rec.duration_quantity ,
UNIT_OF_MEASURE_CODE = l_def_service_rec.unit_of_measure_code ,
STARTING_DELAY = l_def_service_rec.starting_delay ,
BILL_TO_SITE_USE_ID = l_def_service_rec.bill_to_site_use_id ,
BILL_TO_CONTACT_ID = l_def_service_rec.bill_to_contact_id ,
SERVICE_TXN_AVAILABILITY_CODE = l_def_service_rec.service_txn_availability_code ,
NEXT_PM_VISIT_DATE = l_def_service_rec.next_pm_visit_date ,
PM_VISITS_COMPLETED = l_def_service_rec.pm_visits_completed ,
LAST_PM_VISIT_DATE = l_def_service_rec.last_pm_visit_date ,
PM_SCHEDULE_ID = l_def_service_rec.pm_schedule_id ,
PM_SCHEDULE_FLAG = l_def_service_rec.pm_schedule_flag ,
CURRENT_MAX_SCHEDULE_DATE = l_def_service_rec.current_max_schedule_date ,
PRICE_LIST_ID = l_def_service_rec.price_list_id ,
SERVICE_ORDER_TYPE = l_def_service_rec.service_order_type ,
INVOICE_COUNT = l_def_service_rec.invoice_count ,
CURRENCY_CODE = l_def_service_rec.currency_code ,
CONVERSION_TYPE = l_def_service_rec.conversion_type ,
CONVERSION_RATE = l_def_service_rec.conversion_rate ,
CONVERSION_DATE = l_def_service_rec.conversion_date ,
ORIGINAL_SERVICE_LINE_ID = l_def_service_rec.original_service_line_id ,
WARRANTY_FLAG = l_def_service_rec.warranty_flag ,
ORIGINAL_START_DATE = l_def_service_rec.original_start_date ,
ORIGINAL_END_DATE = l_def_service_rec.original_end_date ,
SERVICE_DATE_CHANGE = l_def_service_rec.service_date_change ,
WORKFLOW = l_def_service_rec.workflow ,
SHIP_TO_SITE_USE_ID = l_def_service_rec.ship_to_site_use_id ,
ORIGINAL_SYSTEM_LINE_REFERENCE = l_def_service_rec.original_system_line_reference ,
EXTENDED_PRICE = l_def_service_rec.extended_price ,
DISCOUNT_ID = l_def_service_rec.discount_id ,
TAX_CODE = l_def_service_rec.tax_code ,
BILLING_FREQUENCY_PERIOD = l_def_service_rec.billing_frequency_period ,
FIRST_BILL_DATE = l_def_service_rec.first_bill_date ,
NEXT_BILL_DATE = l_def_service_rec.next_bill_date ,
CREATION_DATE = l_def_service_rec.creation_date ,
BILL_ON = l_def_service_rec.bill_on ,
CREATED_BY = l_def_service_rec.created_by ,
LAST_UPDATE_DATE = l_def_service_rec.last_update_date ,
LAST_UPDATED_BY = l_def_service_rec.last_updated_by ,
LAST_UPDATE_LOGIN = l_def_service_rec.last_update_login ,
START_DATE_ACTIVE = l_def_service_rec.start_date_active ,
END_DATE_ACTIVE = l_def_service_rec.end_date_active ,
PRICING_ATTRIBUTE1 = l_def_service_rec.pricing_attribute1 ,
PRICING_ATTRIBUTE2 = l_def_service_rec.pricing_attribute2 ,
PRICING_ATTRIBUTE3 = l_def_service_rec.pricing_attribute3 ,
PRICING_ATTRIBUTE4 = l_def_service_rec.pricing_attribute4 ,
PRICING_ATTRIBUTE5 = l_def_service_rec.pricing_attribute5 ,
PRICING_ATTRIBUTE6 = l_def_service_rec.pricing_attribute6 ,
PRICING_ATTRIBUTE7 = l_def_service_rec.pricing_attribute7 ,
PRICING_ATTRIBUTE8 = l_def_service_rec.pricing_attribute8 ,
PRICING_ATTRIBUTE9 = l_def_service_rec.pricing_attribute9 ,
PRICING_ATTRIBUTE10 = l_def_service_rec.pricing_attribute10 ,
PRICING_ATTRIBUTE11 = l_def_service_rec.pricing_attribute11 ,
PRICING_ATTRIBUTE12 = l_def_service_rec.pricing_attribute12 ,
PRICING_ATTRIBUTE13 = l_def_service_rec.pricing_attribute13 ,
PRICING_ATTRIBUTE14 = l_def_service_rec.pricing_attribute14 ,
PRICING_ATTRIBUTE15 = l_def_service_rec.pricing_attribute15 ,
PRICING_CONTEXT = l_def_service_rec.pricing_context ,
ATTRIBUTE1 = l_def_service_rec.attribute1 ,
ATTRIBUTE2 = l_def_service_rec.attribute2 ,
ATTRIBUTE3 = l_def_service_rec.attribute3 ,
ATTRIBUTE4 = l_def_service_rec.attribute4 ,
ATTRIBUTE5 = l_def_service_rec.attribute5 ,
ATTRIBUTE6 = l_def_service_rec.attribute6 ,
ATTRIBUTE7 = l_def_service_rec.attribute7 ,
ATTRIBUTE8 = l_def_service_rec.attribute8 ,
ATTRIBUTE9 = l_def_service_rec.attribute9 ,
ATTRIBUTE10 = l_def_service_rec.attribute10 ,
ATTRIBUTE11 = l_def_service_rec.attribute11 ,
ATTRIBUTE12 = l_def_service_rec.attribute12 ,
ATTRIBUTE13 = l_def_service_rec.attribute13 ,
ATTRIBUTE14 = l_def_service_rec.attribute14 ,
ATTRIBUTE15 = l_def_service_rec.attribute15 ,
CONTEXT = l_def_service_rec.context ,
LIST_PRICE = l_def_service_rec.list_price ,
ORG_ID = l_def_service_rec.org_id ,
PRICE_PERCENT = l_def_service_rec.price_percent
WHERE
CP_SERVICE_ID = l_def_service_rec.cp_service_id
;
END update_row;
Procedure update_row
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
p_validation_level IN NUMBER,
p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
x_return_status OUT VARCHAR2,
x_msg_count OUT NUMBER,
x_msg_data OUT VARCHAR2,
p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_contract_line_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_status_code IN CS_CP_SERVICES.STATUS_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_lst_cp_srvic_trnsctin_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_invoice_flag IN CS_CP_SERVICES.INVOICE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_coverage_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_prorate_flag IN CS_CP_SERVICES.PRORATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_duration_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_unit_of_measure_code IN CS_CP_SERVICES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_starting_delay IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_bill_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_bill_to_contact_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_srvic_txn_vilbility_cd IN CS_CP_SERVICES.SERVICE_TXN_AVAILABILITY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_next_pm_visit_date IN CS_CP_SERVICES.NEXT_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_pm_visits_completed IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_last_pm_visit_date IN CS_CP_SERVICES.LAST_PM_VISIT_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_pm_schedule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_pm_schedule_flag IN CS_CP_SERVICES.PM_SCHEDULE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_current_max_schedule_date IN CS_CP_SERVICES.CURRENT_MAX_SCHEDULE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_service_order_type IN CS_CP_SERVICES.SERVICE_ORDER_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_invoice_count IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_currency_code IN CS_CP_SERVICES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_conversion_type IN CS_CP_SERVICES.CONVERSION_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_conversion_date IN CS_CP_SERVICES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_original_service_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_warranty_flag IN CS_CP_SERVICES.WARRANTY_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_original_start_date IN CS_CP_SERVICES.ORIGINAL_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_original_end_date IN CS_CP_SERVICES.ORIGINAL_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_service_date_change IN CS_CP_SERVICES.SERVICE_DATE_CHANGE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_workflow IN CS_CP_SERVICES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_ship_to_site_use_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_riginl_systm_lin_rfrnc IN CS_CP_SERVICES.ORIGINAL_SYSTEM_LINE_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_extended_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_tax_code IN CS_CP_SERVICES.TAX_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_billing_frequency_period IN CS_CP_SERVICES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_first_bill_date IN CS_CP_SERVICES.FIRST_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_next_bill_date IN CS_CP_SERVICES.NEXT_BILL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_creation_date IN CS_CP_SERVICES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_bill_on IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute4 IN CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute5 IN CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute6 IN CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute7 IN CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute8 IN CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute9 IN CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute10 IN CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute11 IN CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute12 IN CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute13 IN CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute14 IN CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute15 IN CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_context IN CS_CP_SERVICES.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute1 IN CS_CP_SERVICES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute2 IN CS_CP_SERVICES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute3 IN CS_CP_SERVICES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute4 IN CS_CP_SERVICES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute5 IN CS_CP_SERVICES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute6 IN CS_CP_SERVICES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute7 IN CS_CP_SERVICES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute8 IN CS_CP_SERVICES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute9 IN CS_CP_SERVICES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute10 IN CS_CP_SERVICES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute11 IN CS_CP_SERVICES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute12 IN CS_CP_SERVICES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute13 IN CS_CP_SERVICES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute14 IN CS_CP_SERVICES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute15 IN CS_CP_SERVICES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_context IN CS_CP_SERVICES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_price_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_row';
l_service_rec.LAST_UPDATE_DATE := p_last_update_date;
l_service_rec.LAST_UPDATED_BY := p_last_updated_by;
l_service_rec.LAST_UPDATE_LOGIN := p_last_update_login;
update_row(
p_api_version,
p_init_msg_list,
p_validation_level,
p_commit,
x_return_status,
x_msg_count,
x_msg_data,
l_service_rec
);
END update_row;
Procedure delete_row
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
p_validation_level IN NUMBER,
p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
x_return_status OUT VARCHAR2,
x_msg_count OUT NUMBER,
x_msg_data OUT VARCHAR2,
p_cp_service_id IN NUMBER) IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
DELETE FROM CS_CP_SERVICES
WHERE
CP_SERVICE_ID = p_cp_service_id
;
END delete_row;
p_last_update_date IN CS_CP_SERVICES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_start_date_active IN CS_CP_SERVICES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_end_date_active IN CS_CP_SERVICES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
p_pricing_attribute1 IN CS_CP_SERVICES.PRICING_ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute2 IN CS_CP_SERVICES.PRICING_ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute3 IN CS_CP_SERVICES.PRICING_ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute4 IN CS_CP_SERVICES.PRICING_ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute5 IN CS_CP_SERVICES.PRICING_ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute6 IN CS_CP_SERVICES.PRICING_ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute7 IN CS_CP_SERVICES.PRICING_ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute8 IN CS_CP_SERVICES.PRICING_ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute9 IN CS_CP_SERVICES.PRICING_ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute10 IN CS_CP_SERVICES.PRICING_ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute11 IN CS_CP_SERVICES.PRICING_ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute12 IN CS_CP_SERVICES.PRICING_ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute13 IN CS_CP_SERVICES.PRICING_ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute14 IN CS_CP_SERVICES.PRICING_ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_attribute15 IN CS_CP_SERVICES.PRICING_ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_pricing_context IN CS_CP_SERVICES.PRICING_CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute1 IN CS_CP_SERVICES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute2 IN CS_CP_SERVICES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute3 IN CS_CP_SERVICES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute4 IN CS_CP_SERVICES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute5 IN CS_CP_SERVICES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute6 IN CS_CP_SERVICES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute7 IN CS_CP_SERVICES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute8 IN CS_CP_SERVICES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute9 IN CS_CP_SERVICES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute10 IN CS_CP_SERVICES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute11 IN CS_CP_SERVICES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute12 IN CS_CP_SERVICES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute13 IN CS_CP_SERVICES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute14 IN CS_CP_SERVICES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_attribute15 IN CS_CP_SERVICES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_context IN CS_CP_SERVICES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
p_price_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
l_service_rec.LAST_UPDATE_DATE := p_last_update_date;
l_service_rec.LAST_UPDATED_BY := p_last_updated_by;
l_service_rec.LAST_UPDATE_LOGIN := p_last_update_login;