eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.QP_BULK_VALIDATE

Source


1 PACKAGE QP_BULK_VALIDATE AS
2 /* $Header: QPXBLVAS.pls 120.3.12010000.1 2008/07/28 11:50:38 appldev ship $ */
3 
4    TYPE num_type      IS TABLE OF Number         INDEX BY BINARY_INTEGER;
5    TYPE char_type     IS TABLE OF Varchar2(1)    INDEX BY BINARY_INTEGER;
6    TYPE char30_type   IS TABLE OF Varchar2(30)   INDEX BY BINARY_INTEGER;
7    TYPE char2_type    IS TABLE OF Varchar2(2)    INDEX BY BINARY_INTEGER;
8    TYPE char240_type  IS TABLE OF Varchar2(240)  INDEX BY BINARY_INTEGER;
9    TYPE char4_type    IS TABLE OF Varchar2(4)    INDEX BY BINARY_INTEGER;
10    TYPE char3_type    IS TABLE OF Varchar2(3)    INDEX BY BINARY_INTEGER;
11    TYPE char50_type   IS TABLE OF Varchar2(50)   INDEX BY BINARY_INTEGER;
12    TYPE char2000_type IS TABLE OF Varchar2(2000) INDEX BY BINARY_INTEGER;
13    TYPE char10_type   IS TABLE OF Varchar2(10)   INDEX BY BINARY_INTEGER;
14    TYPE real_type     IS TABLE OF Number(32,10)  INDEX BY BINARY_INTEGER;
15    TYPE date_type     IS TABLE OF Date           INDEX BY BINARY_INTEGER;
16 
17 TYPE DUPL_LINE_TYPE IS RECORD
18 (a_orig_sys_line_ref char50_type,
19     b_orig_sys_line_ref char50_type,
20     orig_sys_header_ref char50_type,
21     a_product_uom_code char3_type,
22     b_product_uom_code char3_type,
23     a_pricing_attribute_context char30_type,
24     b_pricing_attribute_context char30_type,
25     a_pricing_attribute char30_type,
26     b_pricing_attribute char30_type,
27     a_pricing_attr_value_from char240_type,
28     a_pricing_attr_value_to char240_type,
29     b_pricing_attr_value_from char240_type,
30     b_pricing_attr_value_to char240_type,
31     a_comparison_operator_code char30_type,
32     b_comparison_operator_code char30_type
33     -- Bug 5092813 RAVI
34     ,b_list_line_id num_type
35     -- Bug 5234939 RAVI START
36     ,a_orig_sys_pricing_attr_ref char50_type
37     ,b_orig_sys_pricing_attr_ref char50_type);
38 
39 TYPE PA_LINE_TYPE IS RECORD
40 (   orig_sys_pricing_attr_ref char50_type,
41     orig_sys_line_ref         char50_type,
42     pricing_attribute_context char30_type,
43     pricing_attribute         char30_type,
44     pricing_attr_value_from   char240_type,
45     pricing_attr_value_to     char240_type,
46     comparison_operator_code  char30_type
47 );
48 -- Bug 5234939 RAVI END
49 
50 g_context     VARCHAR2(240);
51 g_attribute1  VARCHAR2(240);
52 g_attribute2  VARCHAR2(240);
53 g_attribute3  VARCHAR2(240);
54 g_attribute4  VARCHAR2(240);
55 g_attribute5  VARCHAR2(240);
56 g_attribute6  VARCHAR2(240);
57 g_attribute7  VARCHAR2(240);
58 g_attribute8  VARCHAR2(240);
59 g_attribute9  VARCHAR2(240);
60 g_attribute10 VARCHAR2(240);
61 g_attribute11 VARCHAR2(240);
62 g_attribute12 VARCHAR2(240);
63 g_attribute13 VARCHAR2(240);
64 g_attribute14 VARCHAR2(240);
65 g_attribute15 VARCHAR2(240);
66 
67 g_context_name     VARCHAR2(240);
68 g_attribute1_name  VARCHAR2(240);
69 g_attribute2_name  VARCHAR2(240);
70 g_attribute3_name  VARCHAR2(240);
71 g_attribute4_name  VARCHAR2(240);
72 g_attribute5_name  VARCHAR2(240);
73 g_attribute6_name  VARCHAR2(240);
74 g_attribute7_name  VARCHAR2(240);
75 g_attribute8_name  VARCHAR2(240);
76 g_attribute9_name  VARCHAR2(240);
77 g_attribute10_name VARCHAR2(240);
78 g_attribute11_name VARCHAR2(240);
79 g_attribute12_name VARCHAR2(240);
80 g_attribute13_name VARCHAR2(240);
81 g_attribute14_name VARCHAR2(240);
82 g_attribute15_name VARCHAR2(240);
83 
84 g_orig_sys_header_ref VARCHAR2(50);
85 g_orig_sys_line_ref VARCHAR2(50);
86 
87 PROCEDURE DUP_LINE_CHECK
88           (p_request_id NUMBER);
89 
90 PROCEDURE ENTITY_HEADER(p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE);
91 
92 PROCEDURE ENTITY_LINE(P_LINE_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE);
93 
94 PROCEDURE ENTITY_QUALIFIER(p_qualifier_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.qualifier_rec_type);
95 
96 PROCEDURE ENTITY_PRICING_ATTR(p_pricing_attr_rec IN OUT  NOCOPY QP_BULK_LOADER_PUB.pricing_attr_rec_type);
97 
98 PROCEDURE ATTRIBUTE_HEADER(p_request_id NUMBER);
99 
100 PROCEDURE ATTRIBUTE_QUALIFIER(p_request_id NUMBER);
101 
102 PROCEDURE ATTRIBUTE_LINE(p_request_id NUMBER);
103 
104 PROCEDURE MARK_ERRORED_INTERFACE_RECORD
105 (p_table_type  VARCHAR2
106  ,p_request_id  NUMBER);
107 
108 -- Bug# 5412045
109 -- Shell for qp_validate.product_uom to return Varchar2 ('TRUE', 'FALSE')
110 -- qp_validate.product_uom returns a boolean.
111 FUNCTION Product_Uom ( p_product_uom_code IN VARCHAR2,
112                        p_category_id IN NUMBER,
113                        p_list_header_id IN NUMBER ) RETURN VARCHAR2;
114 
115 END QP_BULK_VALIDATE;