[Home] [Help]
PACKAGE: APPS.JA_CN_CUSTOM_SOURCES
Source
1 package JA_CN_CUSTOM_SOURCES AUTHID CURRENT_USER AS
2 --$Header: JACNSCSS.pls 120.4.12020000.2 2013/02/21 06:58:20 chongwan ship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNSCSS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is used to create customer source. |
13 --| |
14 --| PROCEDURE LIST |
15 --| |
16 --| PROCEDURE Invoice_Category PUBLIC |
17 --| |
18 --| HISTORY |
19 --| 01/08/2007 yanbo liu Created |
20 --| 01/06/2009 Chaoqun Wu Fixing bug#8478003
21 --| |
22 --+======================================================================*/
23 l_module_prefix VARCHAR2(100) :='JA_CN_CUSTOM_SOURCES';
24 --==========================================================================
25 -- PROCEDURE NAME:
26 -- Invoice_Category Public
27 --
28 -- DESCRIPTION:
29 -- This procedure is used to return different source value according to
30 -- invoice source input.
31 --
32 -- PARAMETERS:
33 -- p_Invoice_Source invoice source
34 -- p_invoice_id invoice id
35 -- p_invoice_line_number invoice line number
36 -- p_distribution_line_number distribution line number
37 --
38 -- DESIGN REFERENCES:
39 -- None
40 --
41 -- CHANGE HISTORY:
42 --
43 --===========================================================================
44 FUNCTION Invoice_Category(p_Invoice_Source IN VARCHAR2,
45 p_invoice_id IN NUMBER,
46 p_invoice_distribution_id IN NUMBER)
47 RETURN VARCHAR2;
48 FUNCTION Invoice_GainLoss_Category(p_invoice_payment_id IN NUMBER)
49 RETURN VARCHAR2;
50
51 FUNCTION GET_PROJECT_NUM(p_project_id IN NUMBER) --Fixing bug#8478003
52 RETURN VARCHAR2;
53
54 end JA_CN_CUSTOM_SOURCES;