[Home] [Help]
PACKAGE: APPS.GMF_AR_GET_INVOICE_HEADER
Source
1 PACKAGE GMF_AR_GET_INVOICE_HEADER AUTHID CURRENT_USER AS
2 /* $Header: gmfinrhs.pls 115.2 2002/11/11 00:38:45 rseshadr ship $ */
3 PROCEDURE get_invoice_header
4 (invoice_id IN OUT NOCOPY NUMBER, /* Invoice Id*/
5 t_start_date IN OUT NOCOPY DATE,
6 t_end_date IN OUT NOCOPY DATE,
7 t_created_by OUT NOCOPY NUMBER,
8 t_creation_date OUT NOCOPY DATE,
9 t_last_updated_by OUT NOCOPY NUMBER,
10 t_last_update_date OUT NOCOPY DATE,
11 t_trx_number OUT NOCOPY VARCHAR2, /* Inv Number*/
12 t_invoice_amount OUT NOCOPY NUMBER, /* Inv amount */
13 t_balance_amount OUT NOCOPY NUMBER, /* Bal amount*/
14 t_trx_date OUT NOCOPY DATE, /* Inv date*/
15 t_cust_trx_type_id OUT NOCOPY NUMBER, /* Tran type*/
16 t_invoice_currency_code OUT NOCOPY VARCHAR2, /* Curncy code*/
17 t_term_id OUT NOCOPY NUMBER, /* Terms Id*/
18 t_customer_trx_id OUT NOCOPY NUMBER,
19 t_last_update_login OUT NOCOPY NUMBER,
20 t_set_of_books_id OUT NOCOPY NUMBER,
21 t_bill_to_contact_id OUT NOCOPY NUMBER,
22 t_batch_id OUT NOCOPY NUMBER,
23 t_batch_source_id OUT NOCOPY NUMBER,
24 t_reason_code OUT NOCOPY VARCHAR2,
25 t_sold_to_customer_id OUT NOCOPY NUMBER,
26 t_sold_to_contact_id OUT NOCOPY NUMBER,
27 t_sold_to_site_use_id OUT NOCOPY NUMBER,
28 t_bill_to_customer_id OUT NOCOPY NUMBER,
29 t_bill_to_site_use_id OUT NOCOPY NUMBER,
30 t_ship_to_customer_id OUT NOCOPY NUMBER,
31 t_ship_to_contact_id OUT NOCOPY NUMBER,
32 t_ship_to_site_use_id OUT NOCOPY NUMBER,
33 t_remit_to_address_id OUT NOCOPY NUMBER,
34 t_term_due_date OUT NOCOPY DATE,
35 t_previous_customer_trx_id OUT NOCOPY NUMBER,
36 t_primary_salesrep_id OUT NOCOPY NUMBER,
37 t_printing_original_date OUT NOCOPY DATE,
38 t_printing_last_printed OUT NOCOPY DATE,
39 t_printing_option OUT NOCOPY VARCHAR2,
40 t_printing_count OUT NOCOPY NUMBER,
41 t_printing_pending OUT NOCOPY VARCHAR2,
42 t_purchase_order OUT NOCOPY VARCHAR2,
43 t_purchase_order_revision OUT NOCOPY VARCHAR2,
44 t_purchase_order_date OUT NOCOPY DATE,
45 t_customer_reference OUT NOCOPY VARCHAR2,
46 t_internal_notes OUT NOCOPY VARCHAR2,
47 t_exchange_rate_type OUT NOCOPY VARCHAR2,
48 t_exchange_date OUT NOCOPY DATE,
49 t_exchange_rate OUT NOCOPY NUMBER,
50 t_territory_id OUT NOCOPY NUMBER,
51 t_initial_customer_trx_id OUT NOCOPY NUMBER,
52 t_agreement_id OUT NOCOPY NUMBER,
53 t_end_date_commitment OUT NOCOPY DATE,
54 t_start_date_commitment OUT NOCOPY DATE,
55 t_last_printed_sequence_num OUT NOCOPY NUMBER,
56 t_orig_system_batch_name OUT NOCOPY VARCHAR2,
57 t_post_request_id OUT NOCOPY NUMBER,
58 t_request_id OUT NOCOPY NUMBER,
59 t_program_application_id OUT NOCOPY NUMBER,
60 t_program_id OUT NOCOPY NUMBER,
61 t_program_update_date OUT NOCOPY DATE,
62 t_finance_charges OUT NOCOPY VARCHAR2,
63 t_complete_flag OUT NOCOPY VARCHAR2,
64 t_posting_control_id OUT NOCOPY NUMBER,
65 t_bill_to_address_id OUT NOCOPY NUMBER,
66 t_ra_post_loop_number OUT NOCOPY NUMBER,
67 t_ship_to_address_id OUT NOCOPY NUMBER,
68 t_credit_method_for_rules OUT NOCOPY VARCHAR2,
69 t_cr_method_for_installments OUT NOCOPY VARCHAR2,
70 t_receipt_method_id OUT NOCOPY NUMBER,
71 t_related_customer_trx_id OUT NOCOPY NUMBER,
72 t_invoicing_rule_id OUT NOCOPY NUMBER,
73 t_ship_via OUT NOCOPY VARCHAR2,
74 t_ship_date_actual OUT NOCOPY DATE,
75 t_waybill_number OUT NOCOPY VARCHAR2,
76 t_fob_point OUT NOCOPY VARCHAR2,
77 t_customer_bank_account_id OUT NOCOPY NUMBER,
78 t_status_trx OUT NOCOPY VARCHAR2,
79 t_doc_sequence_id OUT NOCOPY NUMBER,
80 t_doc_sequence_value OUT NOCOPY NUMBER,
81 t_paying_customer_id OUT NOCOPY NUMBER,
82 t_paying_site_use_id OUT NOCOPY NUMBER,
83 t_related_batch_source_id OUT NOCOPY NUMBER,
84 t_default_tax_exempt_flag OUT NOCOPY VARCHAR2,
85 t_created_from OUT NOCOPY VARCHAR2,
86 row_to_fetch IN OUT NOCOPY NUMBER,
87 error_status OUT NOCOPY NUMBER,
88 t_term_name OUT NOCOPY VARCHAR2,
89 t_trx_name OUT NOCOPY VARCHAR2,
90 t_type OUT NOCOPY VARCHAR2);
91 END GMF_AR_GET_INVOICE_HEADER;