[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
p_request_header_id NUMBER,
p_object_version_NUMBER NUMBER,
p_last_update_date DATE,
p_last_updated_by NUMBER,
p_creation_date DATE,
p_created_by NUMBER,
p_last_update_login NUMBER,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_update_date DATE,
p_program_id NUMBER,
p_created_from VARCHAR2,
p_request_number VARCHAR2,
p_request_class VARCHAR2,
p_offer_type VARCHAR2,
p_offer_id NUMBER,
p_root_request_header_id NUMBER,
p_linked_request_header_id NUMBER,
p_request_start_date DATE,
p_request_end_date DATE,
p_user_status_id VARCHAR2,
p_request_outcome VARCHAR2,
p_decline_reason_code VARCHAR2,
p_return_reason_code VARCHAR2,
p_request_currency_code VARCHAR2,
p_authorization_number VARCHAR2,
p_sd_requested_budget_amount NUMBER,
p_sd_approved_budget_amount NUMBER,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2,
p_supplier_id NUMBER,
p_supplier_site_id NUMBER,
p_supplier_contact_id NUMBER,
p_internal_submission_date DATE,
p_assignee_response_by_date DATE,
p_assignee_response_date DATE,
p_submtd_by_for_supp_appr VARCHAR2,
p_supplier_response_by_date DATE,
p_supplier_response_date DATE,
p_supplier_submission_date DATE,
p_requestor_id NUMBER,
p_supplier_quote_number VARCHAR2,
p_internal_order_number NUMBER,
p_sales_order_currency VARCHAR2,
p_request_source VARCHAR2,
p_assignee_resource_id NUMBER,
p_org_id NUMBER,
p_security_group_id NUMBER,
p_accrual_type VARCHAR2,
p_cust_account_id VARCHAR2,
p_supplier_email VARCHAR2,
p_supplier_phone VARCHAR2,
p_request_type_setup_id NUMBER,
p_request_basis VARCHAR2,
p_supplier_contact_name VARCHAR2) --//Bugfix 7822442
IS
BEGIN
INSERT INTO ozf_sd_request_headers_all_b(
request_header_id,
object_version_number,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
request_id,
program_application_id,
program_update_date,
program_id,
created_from,
request_number,
request_class,
offer_type,
offer_id,
root_request_header_id,
linked_request_header_id,
request_start_date,
request_end_date,
user_status_id,
request_outcome,
decline_reason_code,
return_reason_code,
request_currency_code,
authorization_number,
requested_budget_amount,
approved_budget_amount,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
supplier_id,
supplier_site_id,
supplier_contact_id,
internal_submission_date,
asignee_response_by_date,
asignee_response_date,
submtd_by_for_supp_approval,
supplier_response_by_date,
supplier_response_date,
supplier_submission_date,
requestor_id,
supplier_quote_number,
internal_order_number,
sales_order_currency,
request_source,
asignee_resource_id,
org_id,
security_group_id,
accrual_type,
cust_account_id,
supplier_contact_email_address,
supplier_contact_phone_number,
request_type_setup_id,
request_basis,
supplier_contact_name)
VALUES(
p_request_header_id,
p_object_version_number,
p_last_update_date,
p_last_updated_by,
p_creation_date,
p_created_by,
p_last_update_login,
p_request_id,
p_program_application_id,
p_program_update_date,
p_program_id,
p_created_from,
p_request_number,
p_request_class,
p_offer_type,
p_offer_id,
p_root_request_header_id,
p_linked_request_header_id,
p_request_start_date,
p_request_end_date,
p_user_status_id,
p_request_outcome,
p_decline_reason_code,
p_return_reason_code,
p_request_currency_code,
p_authorization_number,
p_sd_requested_budget_amount,
p_sd_approved_budget_amount,
p_attribute_category,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_supplier_id,
p_supplier_site_id,
p_supplier_contact_id,
p_internal_submission_date,
p_assignee_response_by_date,
p_assignee_response_date,
p_submtd_by_for_supp_appr,
p_supplier_response_by_date,
p_supplier_response_date,
p_supplier_submission_date,
p_requestor_id,
p_supplier_quote_number,
p_internal_order_number,
p_sales_order_currency,
p_request_source,
p_assignee_resource_id,
p_org_id,
p_security_group_id,
p_accrual_type,
p_cust_account_id,
p_supplier_email,
p_supplier_phone,
p_request_type_setup_id,
p_request_basis,
p_supplier_contact_name);
END Insert_Row;
PROCEDURE Update_Row(
p_request_header_id NUMBER,
p_object_version_number NUMBER,
p_last_update_date DATE,
p_last_updated_by NUMBER,
p_last_update_login NUMBER,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_update_date DATE,
p_program_id NUMBER,
p_created_from VARCHAR2,
p_request_number VARCHAR2,
p_request_class VARCHAR2,
p_offer_type VARCHAR2,
p_offer_id NUMBER,
p_root_request_header_id NUMBER,
p_linked_request_header_id NUMBER,
p_request_start_date DATE,
p_request_end_date DATE,
p_user_status_id VARCHAR2,
p_request_outcome VARCHAR2,
p_decline_reason_code VARCHAR2,
p_return_reason_code VARCHAR2,
p_request_currency_code VARCHAR2,
p_authorization_number VARCHAR2,
p_sd_requested_budget_amount NUMBER,
p_sd_approved_budget_amount NUMBER,
p_attribute_category VARCHAR2,
p_attribute1 VARCHAR2,
p_attribute2 VARCHAR2,
p_attribute3 VARCHAR2,
p_attribute4 VARCHAR2,
p_attribute5 VARCHAR2,
p_attribute6 VARCHAR2,
p_attribute7 VARCHAR2,
p_attribute8 VARCHAR2,
p_attribute9 VARCHAR2,
p_attribute10 VARCHAR2,
p_attribute11 VARCHAR2,
p_attribute12 VARCHAR2,
p_attribute13 VARCHAR2,
p_attribute14 VARCHAR2,
p_attribute15 VARCHAR2,
p_supplier_id NUMBER,
p_supplier_site_id NUMBER,
p_supplier_contact_id NUMBER,
p_internal_submission_date DATE,
p_assignee_response_by_date DATE,
p_assignee_response_date DATE,
p_submtd_by_for_supp_appr VARCHAR2,
p_supplier_response_by_date DATE,
p_supplier_response_date DATE,
p_supplier_submission_date DATE,
p_requestor_id NUMBER,
p_supplier_quote_number VARCHAR2,
p_internal_order_number NUMBER,
p_sales_order_currency VARCHAR2,
p_request_source VARCHAR2,
p_assignee_resource_id NUMBER,
p_org_id NUMBER,
p_security_group_id NUMBER,
p_accrual_type VARCHAR2,
p_cust_account_id VARCHAR2,
p_supplier_email VARCHAR2,
p_supplier_phone VARCHAR2,
p_request_type_setup_id NUMBER,
p_request_basis VARCHAR2,
p_supplier_contact_name VARCHAR2) --//Bugfix 7822442
IS
BEGIN
UPDATE OZF_SD_REQUEST_HEADERS_ALL_B
SET
object_version_number = p_object_version_number,
last_update_date = p_last_update_date,
last_updated_by = p_last_updated_by,
last_update_login = p_last_update_login,
request_id = p_request_id,
program_application_id = p_program_application_id,
program_update_date = p_program_update_date,
program_id = p_program_id,
created_from = p_created_from,
request_number = p_request_number,
request_class = p_request_class,
offer_type = p_offer_type,
offer_id = p_offer_id,
root_request_header_id = p_root_request_header_id,
linked_request_header_id = p_linked_request_header_id,
request_start_date = p_request_start_date,
request_end_date = p_request_end_date,
user_status_id = p_user_status_id,
request_outcome = p_request_outcome,
decline_reason_code = p_decline_reason_code,
return_reason_code = p_return_reason_code,
request_currency_code = p_request_currency_code,
authorization_number = p_authorization_number,
requested_budget_amount = p_sd_requested_budget_amount,
approved_budget_amount = p_sd_approved_budget_amount,
attribute_category = p_attribute_category,
attribute1 = p_attribute1,
attribute2 = p_attribute2,
attribute3 = p_attribute3,
attribute4 = p_attribute4,
attribute5 = p_attribute5,
attribute6 = p_attribute6,
attribute7 = p_attribute7,
attribute8 = p_attribute8,
attribute9 = p_attribute9,
attribute10 = p_attribute10,
attribute11 = p_attribute11,
attribute12 = p_attribute12,
attribute13 = p_attribute13,
attribute14 = p_attribute14,
attribute15 = p_attribute15,
supplier_id = p_supplier_id,
supplier_site_id = p_supplier_site_id,
supplier_contact_id = p_supplier_contact_id,
internal_submission_date = p_internal_submission_date,
asignee_response_by_date = p_assignee_response_by_date,
asignee_response_date = p_assignee_response_date,
submtd_by_for_supp_approval = p_submtd_by_for_supp_appr,
supplier_response_by_date = p_supplier_response_by_date,
supplier_response_date = p_supplier_response_date,
supplier_submission_date = p_supplier_submission_date,
requestor_id = p_requestor_id,
supplier_quote_number = p_supplier_quote_number,
internal_order_number = p_internal_order_number,
sales_order_currency = p_sales_order_currency,
request_source = p_request_source,
asignee_resource_id = p_assignee_resource_id,
org_id = p_org_id,
security_group_id = p_security_group_id,
accrual_type = p_accrual_type,
cust_account_id = p_cust_account_id,
supplier_contact_email_address = p_supplier_email,
supplier_contact_phone_number = p_supplier_phone,
request_type_setup_id = p_request_type_setup_id,
request_basis = p_request_basis,
supplier_contact_name = p_supplier_contact_name --//Bugfix 7822442
WHERE
request_header_id=p_request_header_id;
END Update_Row;