[Home] [Help]
PACKAGE: APPS.AR_INVOICE_DEFAULT_PVT
Source
1 PACKAGE AR_INVOICE_DEFAULT_PVT AS
2 /* $Header: ARXVINDS.pls 120.3.12010000.2 2008/10/14 12:12:25 spdixit ship $ */
3
4 TYPE trx_system_parameters_rec_type IS RECORD (
5 set_of_books_id ar_system_parameters.set_of_books_id%type,
6 accounting_method ar_system_parameters.accounting_method%type,
7 accrue_interest ar_system_parameters.accrue_interest%type,
8 unearned_discount ar_system_parameters.unearned_discount%type,
9 partial_discount_flag ar_system_parameters.partial_discount_flag%type,
10 print_remit_to ar_system_parameters.print_remit_to%type,
11 default_cb_due_date ar_system_parameters.default_cb_due_date%type,
12 auto_site_numbering ar_system_parameters.auto_site_numbering%type,
13 cash_basis_set_of_books_id ar_system_parameters.cash_basis_set_of_books_id%type,
14 code_combination_id_gain ar_system_parameters.code_combination_id_gain%type,
15 autocash_hierarchy_id ar_system_parameters.autocash_hierarchy_id%type,
16 run_gl_journal_import_flag ar_system_parameters.run_gl_journal_import_flag%type,
17 cer_split_amount ar_system_parameters.cer_split_amount%type,
18 cer_dso_days ar_system_parameters.cer_dso_days%type,
19 posting_days_per_cycle ar_system_parameters.posting_days_per_cycle%type,
20 address_validation ar_system_parameters.address_validation%type,
21 calc_discount_on_lines_flag ar_system_parameters.calc_discount_on_lines_flag%type,
22 change_printed_invoice_flag ar_system_parameters.change_printed_invoice_flag%type,
23 code_combination_id_loss ar_system_parameters.code_combination_id_loss%type,
24 create_reciprocal_flag ar_system_parameters.create_reciprocal_flag%type,
25 default_country ar_system_parameters.default_country%type,
26 default_territory ar_system_parameters.default_territory%type,
27 generate_customer_number ar_system_parameters.generate_customer_number%type,
28 invoice_deletion_flag ar_system_parameters.invoice_deletion_flag%type,
29 location_structure_id ar_system_parameters.location_structure_id%type,
30 site_required_flag ar_system_parameters.site_required_flag%type,
31 tax_allow_compound_flag ar_system_parameters.tax_allow_compound_flag%type,
32 tax_header_level_flag ar_system_parameters.tax_header_level_flag%type,
33 tax_rounding_allow_override ar_system_parameters.tax_rounding_allow_override%type,
34 tax_invoice_print ar_system_parameters.tax_invoice_print%type,
35 tax_method ar_system_parameters.tax_method%type,
36 tax_use_customer_exempt_flag ar_system_parameters.tax_use_customer_exempt_flag%type,
37 tax_use_cust_exc_rate_flag ar_system_parameters.tax_use_cust_exc_rate_flag%type,
38 tax_use_loc_exc_rate_flag ar_system_parameters.tax_use_loc_exc_rate_flag%type,
39 tax_use_product_exempt_flag ar_system_parameters.tax_use_product_exempt_flag%type,
40 tax_use_prod_exc_rate_flag ar_system_parameters.tax_use_prod_exc_rate_flag%type,
41 tax_use_site_exc_rate_flag ar_system_parameters.tax_use_site_exc_rate_flag%type,
42 ai_log_file_message_level ar_system_parameters.ai_log_file_message_level%type,
43 ai_max_memory_in_bytes ar_system_parameters.ai_max_memory_in_bytes%type,
44 ai_acct_flex_key_left_prompt ar_system_parameters.ai_acct_flex_key_left_prompt%type,
45 ai_mtl_items_key_left_prompt ar_system_parameters.ai_mtl_items_key_left_prompt%type,
46 ai_territory_key_left_prompt ar_system_parameters.ai_territory_key_left_prompt%type,
47 ai_purge_int_tables_flag ar_system_parameters.ai_purge_interface_tables_flag%type,
48 ai_activate_sql_trace_flag ar_system_parameters.ai_activate_sql_trace_flag%type,
49 default_grouping_rule_id ar_system_parameters.default_grouping_rule_id%type,
50 salesrep_required_flag ar_system_parameters.salesrep_required_flag%type,
51 auto_rec_invoices_per_commit ar_system_parameters.auto_rec_invoices_per_commit%type,
52 auto_rec_receipts_per_commit ar_system_parameters.auto_rec_receipts_per_commit%type,
53 pay_unrelated_invoices_flag ar_system_parameters.pay_unrelated_invoices_flag%type,
54 print_home_country_flag ar_system_parameters.print_home_country_flag%type,
55 location_tax_account ar_system_parameters.location_tax_account%type,
56 from_postal_code ar_system_parameters.from_postal_code%type,
57 to_postal_code ar_system_parameters.to_postal_code%type,
58 tax_registration_number ar_system_parameters.tax_registration_number%type,
59 populate_gl_segments_flag ar_system_parameters.populate_gl_segments_flag%type,
60 unallocated_revenue_ccid ar_system_parameters.unallocated_revenue_ccid%type,
61 base_currency_code gl_sets_of_books.currency_code%type,
62 chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type,
63 period_set_name gl_sets_of_books.period_set_name%type,
64 set_of_books gl_sets_of_books.short_name%type,
65 base_precision fnd_currencies.precision%type,
66 base_EXTENDED_PRECISION fnd_currencies.EXTENDED_PRECISION%type,
67 base_MIN_ACCOUNTABLE_UNIT fnd_currencies.MINIMUM_ACCOUNTABLE_UNIT%type,
68 salescredit_name ra_salesreps.name%type,
69 yes_meaning ar_lookups.meaning%type,
70 no_meaning ar_lookups.meaning%type,
71 org_id ar_system_parameters.org_id%type,
72 inclusive_tax_used ar_system_parameters.inclusive_tax_used%type,
73 tax_enforce_account_flag ar_system_parameters.tax_enforce_account_flag%type,
74 ta_installed_flag varchar2(1),
75 br_enabled_flag ar_system_parameters.bills_receivable_enabled_flag%type,
76 default_reference ra_batch_sources.default_reference%type,
77 ar_ra_batch_source_name ra_batch_sources.name%type,
78 ar_ra_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type,
79 ar_multi_currency_flag varchar2(1),
80 ar_receipt_multi_currency_flag varchar2(1),
81 short_name gl_sets_of_books.short_name%type,
82 precision fnd_currencies.precision%type,
83 EXTENDED_PRECISION fnd_currencies.extended_precision%type,
84 MINIMUM_ACCOUNTABLE_UNIT fnd_currencies.MINIMUM_ACCOUNTABLE_UNIT%type,
85 DOCUMENT_SEQ_GEN_LEVEL ar_system_parameters.DOCUMENT_SEQ_GEN_LEVEL%type,
86 trx_header_level_rounding ar_system_parameters.trx_header_level_rounding%type);
87
88 trx_system_parameters_rec trx_system_parameters_rec_type;
89
90 TYPE trx_profile_rec_type IS RECORD (
91 ar_br_batch_source VARCHAR2(255),
92 AR_BR_WO_RECOURSE VARCHAR2(255),
93 AR_MASK_BANK_ACCOUNT_NUMBERS VARCHAR2(255),
94 ar_unique_seq_numbers VARCHAR2(255),
95 ar_adj_credit_unconfirmed_inv VARCHAR2(255),
96 ar_allow_manual_tax_lines VARCHAR2(255),
97 ar_allow_tax_update VARCHAR2(255),
98 ar_allow_tax_code_override VARCHAR2(255),
99 ar_allow_trx_line_exemptions VARCHAR2(255),
100 ar_batch_source VARCHAR2(255),
101 ar_change_cust_name VARCHAR2(255),
102 ar_change_cust_on_trx VARCHAR2(255),
103 ar_override_adj_activity_acct VARCHAR2(255),
104 ar_powercash_allow_actions VARCHAR2(255),
105 ar_ra_batch_source VARCHAR2(255),
106 ar_update_due_date VARCHAR2(255),
107 ar_use_inv_acct_for_cm_flag VARCHAR2(255),
108 ussgl_option VARCHAR2(255),
109 display_inverse_rate VARCHAR2(255),
110 ar_allow_salescredit_update VARCHAR2(255),
111 so_organization_id VARCHAR2(255),
112 so_source_code VARCHAR2(255),
113 so_id_flex_code VARCHAR2(255),
114 ar_jg_create_bank_charges VARCHAR2(255),
115 ar_incl_receipts_at_risk VARCHAR2(255),
116 default_exchange_rate_type VARCHAR2(255),
117 default_exchange_rate_type_dsp VARCHAR2(255),
118 def_exchange_rate_type_profile VARCHAR2(255),
119 so_installed_flag VARCHAR2(255),
120 rev_based_on_srep_flag VARCHAR2(1),
121 autoacc_based_on_srep_flag VARCHAR2(1),
122 autoacc_based_on_primary_srep VARCHAR2(1),
123 autoacc_based_on_agree_cat VARCHAR2(1),
124 autoacc_based_on_type_flag VARCHAR2(1),
125 autoacc_based_on_item_flag VARCHAR2(1),
126 autoacc_based_on_tax_code VARCHAR2(1),
127 autoacc_based_on_site_flag VARCHAR2(1));
128
129 trx_profile_rec trx_profile_rec_type;
130
131
132
133
134 PROCEDURE Get_system_parameters(
135 p_trx_system_parameters_rec OUT NOCOPY trx_system_parameters_rec_type,
136 x_errmsg OUT NOCOPY VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2);
138
139 PROCEDURE Get_profile_values(
140 p_trx_profile_rec OUT NOCOPY trx_profile_rec_type,
141 x_errmsg OUT NOCOPY VARCHAR2,
142 x_return_status OUT NOCOPY VARCHAR2);
143
144 PROCEDURE Default_gl_date;
145
146
147 END;