[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| insert_p |
| |
| DESCRIPTION |
| Inserts a record into AR_DISTRIBUTIONS_ALL table, inserts org_id |
| column for Multi Org. |
| |
| SCOPE - PUBLIC |
| |
| EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
| |
| ARGUMENTS |
| IN: |
| p_dist_rec - Distribution record to be inserted |
| |
| OUT: |
| p_line_id - Line Id of the distribution created |
| |
| RETURNS |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| |
| 07-DEC-98 VAHLUWAL Created for Release 11.5 upgrade |
| |
+===========================================================================*/
PROCEDURE insert_p( p_dist_rec IN ar_distributions_all%ROWTYPE,
p_line_id OUT NOCOPY ar_distributions_all.line_id%TYPE ) IS
l_line_id ar_distributions_all.line_id%TYPE;
SELECT ar_distributions_s.nextval
INTO l_line_id
FROM dual;
INSERT INTO ar_distributions_all (
line_id,
source_id,
source_table,
source_type,
code_combination_id,
amount_dr,
amount_cr,
acctd_amount_dr,
acctd_amount_cr,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
source_id_secondary,
source_table_secondary,
currency_code ,
currency_conversion_rate,
currency_conversion_type,
currency_conversion_date,
third_party_id,
third_party_sub_id,
tax_code_id,
location_segment_id,
reversed_source_id,
taxable_entered_dr,
taxable_entered_cr,
taxable_accounted_dr,
taxable_accounted_cr,
tax_link_id,
org_id
)
VALUES ( l_line_id,
p_dist_rec.source_id,
p_dist_rec.source_table,
p_dist_rec.source_type,
p_dist_rec.code_combination_id,
p_dist_rec.amount_dr,
p_dist_rec.amount_cr,
p_dist_rec.acctd_amount_dr,
p_dist_rec.acctd_amount_cr,
-2001, --identifies that AR Upgrade created the data
SYSDATE,
-2001,
SYSDATE,
-2001,
p_dist_rec.source_id_secondary,
p_dist_rec.source_table_secondary,
p_dist_rec.currency_code ,
p_dist_rec.currency_conversion_rate,
p_dist_rec.currency_conversion_type,
p_dist_rec.currency_conversion_date,
p_dist_rec.third_party_id,
p_dist_rec.third_party_sub_id,
p_dist_rec.tax_code_id,
p_dist_rec.location_segment_id,
p_dist_rec.reversed_source_id,
p_dist_rec.taxable_entered_dr,
p_dist_rec.taxable_entered_cr,
p_dist_rec.taxable_accounted_dr,
p_dist_rec.taxable_accounted_cr,
p_dist_rec.tax_link_id,
p_dist_rec.org_id
);
debug( 'EXCEPTION: ARP_UPGRADE_COMMON_UTIL.insert_p' );
END insert_p;