PACKAGE: APPS.ECE_CDMO_UTIL

Source

1 package ece_cdmo_util AUTHID CURRENT_USER as
2 -- $Header: ECCDMOS.pls 120.3 2005/09/28 07:33:23 arsriniv noship $
3   PROCEDURE Update_AR ( Document_Type               IN  VARCHAR2,
4                         Transaction_ID              IN  NUMBER,
5                         Installment_Number          IN  NUMBER,
6                         Multiple_Installments_Flag  IN  VARCHAR2,
7                         Maximum_Installment_Number  IN  NUMBER,
8                         Update_Date                 IN  DATE );
9 
10 PROCEDURE GET_REMIT_ADDRESS (
11 	customer_trx_id 	IN 	NUMBER,
12 	remit_to_address1 	OUT NOCOPY 	VARCHAR2,
13 	remit_to_address2 	OUT NOCOPY 	VARCHAR2,
14 	remit_to_address3 	OUT NOCOPY 	VARCHAR2,
15 	remit_to_address4 	OUT NOCOPY 	VARCHAR2,
16 	remit_to_city		OUT NOCOPY	VARCHAR2,
17 	remit_to_county		OUT NOCOPY	VARCHAR2,
18 	remit_to_state		OUT NOCOPY	VARCHAR2,
19 	remit_to_province	OUT NOCOPY	VARCHAR2,
20 	remit_to_country	OUT NOCOPY	VARCHAR2,
21         remit_to_code_int       OUT NOCOPY VARCHAR2,
22 	remit_to_postal_code	OUT NOCOPY	VARCHAR2);
23 
24 PROCEDURE GET_PAYMENT (
25 	customer_trx_id 	    	IN 	NUMBER,
26 	installment_number		IN	NUMBER,
27 	multiple_installments_flag	OUT NOCOPY	VARCHAR2,
28 	maximum_installment_number	OUT NOCOPY	NUMBER,
29 	amount_tax_due	 		OUT NOCOPY 	NUMBER,
30 	amount_charges_due		OUT NOCOPY 	NUMBER,
31 	amount_freight_due 		OUT NOCOPY 	NUMBER,
32 	amount_line_items_due		OUT NOCOPY 	NUMBER,
33 	total_amount_due		OUT NOCOPY 	NUMBER,
34         total_amount_remaining          OUT NOCOPY     NUMBER);
35 
36 PROCEDURE GET_TERM_DISCOUNT (
37 	document_type		 IN	 VARCHAR2,
38 	term_id			 IN	 NUMBER,
39 	term_sequence_number     IN      NUMBER,
40 	discount_percent1        OUT NOCOPY	 NUMBER,
41 	discount_days1           OUT NOCOPY     NUMBER,
42 	discount_date1           OUT NOCOPY     DATE,
43 	discount_day_of_month1   OUT NOCOPY     NUMBER,
44 	discount_months_forward1 OUT NOCOPY     NUMBER,
45 	discount_percent2        OUT NOCOPY	 NUMBER,
46 	discount_days2           OUT NOCOPY     NUMBER,
47 	discount_date2           OUT NOCOPY     DATE,
48 	discount_day_of_month2   OUT NOCOPY     NUMBER,
49 	discount_months_forward2 OUT NOCOPY     NUMBER,
50 	discount_percent3        OUT NOCOPY	 NUMBER,
51 	discount_days3           OUT NOCOPY     NUMBER,
52 	discount_date3           OUT NOCOPY     DATE,
53 	discount_day_of_month3   OUT NOCOPY     NUMBER,
54 	discount_months_forward3 OUT NOCOPY     NUMBER);
55 
56 -- Bug 1940758
57 PROCEDURE UPDATE_HEADER_WITH_LINE (
58 	p_customer_trx_id 	    	IN 	NUMBER);
59 end ece_cdmo_util;