PACKAGE: APPS.OKS_ARFEEDER_PUB

Source

1 Package OKS_ARFEEDER_PUB AS
2 /* $Header: OKSPARFS.pls 120.0.12000000.1 2007/01/16 22:04:59 appldev ship $ */
3 
4 G_EXCEPTION_BILLING EXCEPTION;
5 
6 G_SUM   CONSTANT NUMBER := 1;
7 G_DET   CONSTANT NUMBER := 2;
8 G_SOURCE_NAME CONSTANT VARCHAR2(20) := 'OKS CONTRACTS';
9 G_LINE_TYPE   CONSTANT VARCHAR2(20) := 'LINE';
10 G_QTY   CONSTANT NUMBER := 1;
11 G_ADVANCE   CONSTANT Varchar2(10) := '-2' ;
12 
13 G_LSE_ID_FOR_USAGE  CONSTANT NUMBER := 12;
14 G_LSE_ID_FOR_SUBSCR CONSTANT NUMBER := 46;
15 
16 G_INIT_RAIL_REC RA_INTERFACE_LINES%ROWTYPE;
17 G_RAIL_REC RA_INTERFACE_LINES_ALL%ROWTYPE;
18 G_INIT_RAISC_REC RA_INTERFACE_SALESCREDITS%ROWTYPE;
19 G_RAISC_REC   AR_InterfaceSalesCredits_GRP.salescredit_rec_type;
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21 
22 --Start Fix for bug#4198616
23 G_LOG_YES_NO Varchar2(10);
24 --End Fix for bug#4198616
25 
26   PROCEDURE Get_REC_FEEDER
27   (
28     X_RETURN_STATUS           OUT    NOCOPY    VARCHAR2,
29     X_MSG_COUNT               OUT    NOCOPY    NUMBER,
30     X_MSG_DATA                OUT    NOCOPY    VARCHAR2,
31     P_FLAG                    IN               NUMBER, -- 1 sales_group_id col present else not
32     P_CALLED_FROM             IN               NUMBER,
33     P_DATE		      IN               DATE,
34     P_CLE_ID                  IN               NUMBER,
35     P_PRV                     IN               NUMBER,
36     P_BILLREP_TBL             IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
37     P_BILLREP_TBL_IDX         IN               NUMBER,
38     P_BILLREP_ERR_TBL         IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
39     P_BILLREP_ERR_TBL_IDX     IN OUT NOCOPY    NUMBER
40   );
41 
42 
43 
44 END OKS_ARFEEDER_PUB;