PACKAGE: APPS.CN_SRP_PAYEE_ASSIGNS_PKG

Source

1 PACKAGE CN_SRP_PAYEE_ASSIGNS_PKG as
2 -- $Header: cntspas.pls 120.1 2005/06/10 14:00:50 appldev  $
3 --
4 -- Package Name
5 -- CN_Srp_payee_assigns_PKG
6 -- Purpose
7 --  Table Handler for cn_srp_payee_assigns
8 --  FORM
9 --  BLOCK
10 --
11 -- History
12 -- 10-JUN-99 Kumar Sivasankaran  	Created
13 
14  PROCEDURE Insert_Record
15      ( x_srp_payee_assign_id     IN OUT NOCOPY NUMBER
16       ,p_srp_quota_assign_id            NUMBER
17       ,p_org_id                         NUMBER
18       ,p_payee_id		        NUMBER
19       ,p_quota_id                       NUMBER
20       ,p_salesrep_id	                NUMBER
21       ,p_start_date			DATE
22       ,p_end_date	                DATE
23       ,p_Last_Update_Date               DATE
24       ,p_Last_Updated_By                NUMBER
25       ,p_Creation_Date                  DATE
26       ,p_Created_By                     NUMBER
27       ,p_Last_Update_Login              NUMBER);
28 
29 PROCEDURE Update_Record(
30                         p_srp_payee_assign_id            NUMBER
31 		       ,p_payee_id		         NUMBER
32                        ,p_start_date			 DATE
33 		       ,p_end_date	                 DATE
34                        ,p_Last_Update_Date               DATE
35                        ,p_Last_Updated_By                NUMBER
36                        ,p_Last_Update_Login              NUMBER);
37 
38 PROCEDURE Delete_Record( p_srp_payee_assign_id           NUMBER );
39 
40 PROCEDURE Delete_Record(
41 			 p_srp_quota_assign_id  	 NUMBER
42 			 ,p_quota_id	       		 NUMBER);
43 
44 END CN_srp_payee_assigns_PKG;