[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE delete_trx_data(
p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
p_process_status OUT NOCOPY VARCHAR2,
p_process_message OUT NOCOPY VARCHAR2)
IS
BEGIN
null ;
PROCEDURE insert_trx_lines(
p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE DEFAULT NULL,
p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE DEFAULT NULL,
p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE DEFAULT NULL,
p_process_status OUT NOCOPY VARCHAR2,
p_process_message OUT NOCOPY VARCHAR2)
IS
BEGIN
null ;
PROCEDURE insert_trx_line_gl_dist(
p_account_class IN ra_cust_trx_line_gl_dist_all.account_class%TYPE,
p_account_set_flag IN ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE,
p_acctd_amount IN ra_cust_trx_line_gl_dist_all.acctd_amount%TYPE,
p_amount IN ra_cust_trx_line_gl_dist_all.amount%TYPE,
p_code_combination_id IN ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE,
p_cust_trx_line_gl_dist_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE,
p_cust_trx_line_salesrep_id IN ra_cust_trx_line_gl_dist_all.cust_trx_line_salesrep_id%TYPE,
p_customer_trx_id IN ra_cust_trx_line_gl_dist_all.customer_trx_id%TYPE,
p_customer_trx_line_id IN ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE,
p_gl_date IN ra_cust_trx_line_gl_dist_all.gl_date%TYPE,
p_last_update_date IN ra_cust_trx_line_gl_dist_all.last_update_date%TYPE,
p_last_updated_by IN ra_cust_trx_line_gl_dist_all.last_updated_by%TYPE,
p_creation_date IN ra_cust_trx_line_gl_dist_all.creation_date%TYPE,
p_created_by IN ra_cust_trx_line_gl_dist_all.created_by%TYPE,
p_last_update_login IN ra_cust_trx_line_gl_dist_all.last_update_login%TYPE,
p_org_id IN ra_cust_trx_line_gl_dist_all.org_id%TYPE,
p_percent IN ra_cust_trx_line_gl_dist_all.percent%TYPE,
p_posting_control_id IN ra_cust_trx_line_gl_dist_all.posting_control_id%TYPE,
p_set_of_books_id IN ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE,
p_process_status OUT NOCOPY VARCHAR2,
p_process_message OUT NOCOPY VARCHAR2)
IS
BEGIN
null ;