DBA Data[Home] [Help]

PACKAGE: APPS.ARP_PROGRAM_GENERATE_BR

Source


1 PACKAGE ARP_PROGRAM_GENERATE_BR AUTHID CURRENT_USER AS
2 /* $Header: ARBRTESS.pls 120.2 2003/10/23 07:44:46 orashid ship $ */
3 
4 
5 PROCEDURE auto_create_br_program(
6 		errbuf			      OUT NOCOPY VARCHAR2,
7                 retcode			      OUT NOCOPY VARCHAR2,
8                 p_call                        IN  NUMBER,
9                 p_draft_mode                  IN  VARCHAR2,
10                 p_print_flag                  IN  VARCHAR2,
11                 p_batch_id                    IN  RA_BATCHES.batch_id%TYPE			DEFAULT NULL,
12                 p_batch_source_id             IN  RA_BATCH_SOURCES.batch_source_id%TYPE,
13                 p_batch_date                  IN  VARCHAR2,
14                 p_gl_date                     IN  VARCHAR2					DEFAULT NULL,
15                 p_issue_date                  IN  VARCHAR2					DEFAULT NULL,
16                 p_maturity_date               IN  VARCHAR2					DEFAULT NULL,
17                 p_currency_code               IN  RA_BATCHES.currency_code%TYPE			DEFAULT NULL,
18                 p_comments                    IN  RA_BATCHES.comments%TYPE			DEFAULT NULL,
19                 p_special_instructions        IN  RA_BATCHES.special_instructions%TYPE		DEFAULT NULL,
20                 p_attribute_category          IN  RA_BATCHES.attribute_category%TYPE		DEFAULT NULL,
21                 p_attribute1                  IN  VARCHAR2					DEFAULT NULL,
22                 p_attribute2                  IN  VARCHAR2					DEFAULT NULL,
23                 p_attribute3                  IN  VARCHAR2					DEFAULT NULL,
24                 p_attribute4                  IN  VARCHAR2					DEFAULT NULL,
25                 p_attribute5                  IN  VARCHAR2					DEFAULT NULL,
26                 p_attribute6                  IN  VARCHAR2					DEFAULT NULL,
27                 p_attribute7                  IN  VARCHAR2					DEFAULT NULL,
28                 p_attribute8                  IN  VARCHAR2					DEFAULT NULL,
29                 p_attribute9                  IN  VARCHAR2					DEFAULT NULL,
30                 p_attribute10                 IN  VARCHAR2					DEFAULT NULL,
31                 p_attribute11                 IN  VARCHAR2					DEFAULT NULL,
32                 p_attribute12                 IN  VARCHAR2					DEFAULT NULL,
33                 p_attribute13                 IN  VARCHAR2					DEFAULT NULL,
34                 p_attribute14                 IN  VARCHAR2					DEFAULT NULL,
35                 p_attribute15                 IN  VARCHAR2					DEFAULT NULL,
36                 p_due_date_low                IN  VARCHAR2					DEFAULT NULL,
37                 p_due_date_high               IN  VARCHAR2					DEFAULT NULL,
38                 p_trx_date_low                IN  VARCHAR2					DEFAULT NULL,
39                 p_trx_date_high               IN  VARCHAR2					DEFAULT NULL,
40                 P_trx_type_id                 IN  RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE	DEFAULT NULL,
41                 p_rcpt_meth_id                IN  AR_RECEIPT_METHODS.receipt_method_id%TYPE	DEFAULT NULL,
42                 p_cust_bank_branch_id         IN  ce_bank_branches_v.branch_party_id%TYPE		DEFAULT NULL,
43                 p_trx_number_low              IN  RA_CUSTOMER_TRX.trx_number%TYPE		DEFAULT NULL,
44                 p_trx_number_high             IN  RA_CUSTOMER_TRX.trx_number%TYPE		DEFAULT NULL,
45                 p_cust_class                  IN  AR_LOOKUPS.lookup_code%TYPE			DEFAULT NULL,
46                 p_cust_category               IN  AR_LOOKUPS.lookup_code%TYPE			DEFAULT NULL,
47                 p_customer_id                 IN  HZ_CUST_ACCOUNTS.cust_account_id%TYPE			DEFAULT NULL,
48                 p_site_use_id                 IN  HZ_CUST_SITE_USES.site_use_id%TYPE			DEFAULT NULL);
49 
50 
51 PROCEDURE auto_create_br_API(
52 		p_api_version      		IN  NUMBER,
53        		p_init_msg_list    		IN  VARCHAR2 := FND_API.G_FALSE	,
54         	p_commit           		IN  VARCHAR2 := FND_API.G_TRUE,
55         	p_validation_level 		IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
56         	x_return_status    		OUT NOCOPY VARCHAR2,
57         	x_msg_count        		OUT NOCOPY NUMBER,
58         	x_msg_data         		OUT NOCOPY VARCHAR2,
59                 p_customer_trx_id	    	IN  RA_CUSTOMER_TRX.customer_trx_id%TYPE,
60                 p_bill_id	             	OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
61                 p_request_id                 	OUT NOCOPY NUMBER,
62                 p_nb_bill	             	OUT NOCOPY NUMBER);
63 
64 
65 FUNCTION revision RETURN VARCHAR2;
66 
67 END ARP_PROGRAM_GENERATE_BR;