PACKAGE: APPS.INV_INVKBCPR_XMLP_PKG

Source

1 PACKAGE INV_INVKBCPR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVKBCPRS.pls 120.2 2011/02/07 13:42:19 sisankar ship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_ORG_ID NUMBER;
6 
7   P_SORT_BY NUMBER;
8 
9   P_QTY_PRECISION NUMBER;
10 
11   P_LOCATOR_STRUC_NUM NUMBER;
12 
13   P_KANBAN_CARD_NUMBER_HIGH VARCHAR2(30);
14 
15   P_KANBAN_CARD_NUMBER_LOW VARCHAR2(30);
16 
17   P_ITEM_HIGH VARCHAR2(30);
18 
19   P_ITEM_LOW VARCHAR2(30);
20 
21   P_SUBINV VARCHAR2(30);
22 
23   P_KANBAN_CARD_TYPE NUMBER;
24 
25   P_SOURCE_SUBINV VARCHAR2(50);
26 
27   P_LOCATOR_HI VARCHAR2(50);
28 
29   P_LOCATOR_LOW VARCHAR2(50);
30 
31   P_SOURCE_LOC_ID NUMBER;
32 
33   P_ITEM_WHERE VARCHAR2(240);
34 
35   P_SOURCE_LOC_FLEXDATA VARCHAR2(1200);
36 
37   P_LOC_WHERE VARCHAR2(320);
38 
39   P_ITEM_FLEXDATA VARCHAR2(300);
40 
41   P_LOC_FLEXDATA VARCHAR2(400);
42 
43   P_STRUCT_NUM VARCHAR2(15);
44 
45   P_OPTIMIZER_CODE NUMBER;
46 
47   P_TRACE_FLAG NUMBER;
48 
49   P_REPORT_ID NUMBER;
50 
51   P_CALL_FROM NUMBER;
52 
53   P_ORDER_BY VARCHAR2(2300) := 'MKC.KANBAN_CARD_NUMBER';
54 
55   P_CARD_WHERE VARCHAR2(200);
56 
57   P_KANBAN_CARD_ID NUMBER;
58   --Added by javakat  for ekanban P_PULL_SEQUENCE_ID
59   P_PULL_SEQUENCE_ID NUMBER;
60 
61   P_DATE_CREATED_LOW DATE;
62 
63   P_DATE_CREATED_HIGH DATE;
64 
65   P_SOURCE_TYPE NUMBER;
66 
67   P_SOURCE_ORG_ID NUMBER;
68 
69   P_SUPPLIER_ID NUMBER;
70 
71   P_CALL_WHERE VARCHAR2(2000) := '1=1';
72 
73   P_SUPPLIER_SITE_ID NUMBER;
74 
75   P_SOURCE_LOC_WHERE VARCHAR2(640);
76 
77   P_REPRINT_FLAG NUMBER;
78 
79   FUNCTION BEFOREREPORT RETURN BOOLEAN;
80 
81   FUNCTION AFTERREPORT RETURN BOOLEAN;
82 
83   FUNCTION AFTERPFORM RETURN BOOLEAN;
84 --Added this funtion for ekanban by javakat
85 --to print report for multiple kanaban records
86 
87 PROCEDURE call_kanban_report (  errbuf                OUT NOCOPY      VARCHAR2,
88                                 retcode               OUT NOCOPY      NUMBER,
89                                 x_request_id          OUT NOCOPY      NUMBER,
90 								P_PULL_SEQUENCE_ID   IN  NUMBER,
91 								P_MUL_KBN_CARD_IDS   IN  VARCHAR2);
92 END INV_INVKBCPR_XMLP_PKG;
93