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