PACKAGE: APPS.CS_AR_FEEDER_PROGRAM

Source

1 PACKAGE CS_AR_FEEDER_PROGRAM AUTHID CURRENT_USER AS
2 /* $Header: csctfdrs.pls 115.1 99/07/16 08:52:41 porting ship $ */
3 
4 
5 FUNCTION Main_Procedure RETURN NUMBER;
6 
7 
8 FUNCTION 	Get_Interface_Lines RETURN number;
9 
10 
11 FUNCTION  Update_CS_Cont_Bill_Iface RETURN number;
12 
13 FUNCTION Process_Invoice(
14 						 p_created_by 				IN NUMBER,
15 						 p_contracts_interface_id	IN NUMBER,
16 						 p_contract_id 			IN NUMBER,
17 						 p_cp_service_transaction_id 	IN NUMBER,
18 						 p_cp_service_id 			IN NUMBER,
19 						 p_contract_billing_id 		IN NUMBER,
20 						 p_trx_start_date 			IN DATE,
21 						 p_trx_end_date 			IN DATE,
22 						 p_trx_date 				IN DATE,
23 						 p_trx_amount 				IN NUMBER,
24 						 p_reason_code 			IN VARCHAR2,
25 						 p_reason_comments 			IN VARCHAR2,
26 						 p_cp_quantity 			IN NUMBER,
27 						 p_ar_trx_type				IN VARCHAR2
28 				)RETURN NUMBER ;
29 
30 
31 FUNCTION Process_Credit_Memo(
32 						 p_created_by 				IN NUMBER,
33 						 p_contracts_interface_id	IN NUMBER,
34 						 p_contract_id 			IN NUMBER,
35 						 p_cp_service_transaction_id 	IN NUMBER,
36 						 p_cp_service_id 			IN NUMBER,
37 						 p_contract_billing_id 		IN NUMBER,
38 						 p_trx_start_date 			IN DATE,
39 						 p_trx_end_date 			IN DATE,
40 						 p_trx_date 				IN DATE,
41 						 p_trx_amount 				IN NUMBER,
42 						 p_reason_code 			IN VARCHAR2,
43 						 p_reason_comments 			IN VARCHAR2,
44 						 p_cp_quantity 			IN NUMBER,
45 						 p_ar_trx_type				IN VARCHAR2
46 				)RETURN NUMBER ;
47 
48 
49 
50 
51 FUNCTION multi_line_cm(
52 					 p_cp_service_transaction_id       IN NUMBER,
53 					 p_cp_service_id   				IN NUMBER,
54 					 p_contract_id 				IN NUMBER,
55 					 p_reason_code 				IN VARCHAR2,
56 					 p_reason_comments 				IN VARCHAR2,
57 					 p_trx_start_date 				IN DATE,
58 					 p_trx_end_date 				IN DATE,
59 					 p_created_by 					IN NUMBER
60 					)RETURN NUMBER ;
61 
62 
63 
64 PROCEDURE  reset_cs_cont_bill_iface
65 					(p_contracts_interface_id IN NUMBER);
66 
67 FUNCTION  Delete_cs_cont_bill_iface
68 					(p_contracts_interface_id IN NUMBER)
69 		RETURN number;
70 
71 FUNCTION 	Check_duplicate_txn_Lines(
72 				p_duplicate 				OUT VARCHAR2,
73 				p_trx_start_date 			IN  DATE,
74 				p_cp_service_transaction_id 	IN  NUMBER
75 				)RETURN NUMBER ;
76 
77 
78 FUNCTION	 update_cs_cp_services
79 		    		(p_cp_service_id NUMBER)RETURN NUMBER ;
80 
81 
82 
83 
84 FUNCTION update_cs_cp_service_trans
85 		    (
86 				p_cp_service_id 			IN  NUMBER,
87 				p_trx_start_date 			IN  DATE,
88 				p_created_by 				IN  NUMBER,
89 				p_cp_service_transaction_id 	IN  NUMBER
90 			)return NUMBER;
91 
92 
93 FUNCTION  insert_cs_cp_service_trans
94 		(
95 		   p_cp_service_transaction_id 	IN NUMBER,
96 		   p_cp_service_id 				IN NUMBER,
97 		   p_contract_id 				IN NUMBER,
98 		   p_reason_code 				IN VARCHAR2,
99 		   p_reason_comments 			IN VARCHAR2,
100 		   p_trx_start_date				IN DATE,
101 		   p_trx_end_date 				IN DATE
102 				) return NUMBER ;
103 
104 
105 
106 FUNCTION  insert_cs_contracts_billing
107 					(
108 						p_contract_id     IN  NUMBER,
109 						p_cp_service_id   IN  NUMBER,
110 						p_trx_end_date    IN  DATE,
111 						p_trx_type        IN  VARCHAR2
112 					)return NUMBER ;
113 
114 
115 FUNCTION insert_ra_interface_lines
116 				(
117 				 p_cp_service_transaction_id 	IN NUMBER,
118 				 p_contract_id 		 	IN NUMBER,
119 				 p_cp_service_id 		 	IN NUMBER,
120 				 p_contract_billing_id   	IN NUMBER,
121 				 p_current_billing_id	   	IN NUMBER,
122 				 p_trx_start_date 			IN DATE,
123 				 p_trx_end_date 			IN DATE,
124 				 p_trx_date				IN DATE,
125 				 p_trx_amount	 			IN NUMBER,
126 				 p_cp_quantity	 			IN NUMBER,
127 				 p_ar_trx_type	 			IN VARCHAR2
128 				 )
129 				 return NUMBER ;
130 
131 PROCEDURE print_Error;
132 
133 END CS_AR_FEEDER_PROGRAM;
134