PACKAGE: APPS.QP_DENORMALIZED_PRICING_ATTRS

Source

1 PACKAGE QP_Denormalized_Pricing_Attrs AUTHID CURRENT_USER AS
2 /* $Header: QPXDNPAS.pls 120.2.12020000.1 2012/06/27 20:57:39 appldev ship $ */
3 
4 /* Added for bug 7309559 */
5 TYPE Num_Type IS TABLE OF Number INDEX BY BINARY_INTEGER;
6 G_PERF CONSTANT VARCHAR2(30)  := 'QP_PERFORMANCE_CONTROL';
7 G_ON CONSTANT VARCHAR2(30)  := 'ON';
8 G_OFF CONSTANT VARCHAR2(30)  := 'OFF';
9 G_REQUEST CONSTANT VARCHAR2(30)  := 'INT';
10 G_UPDATE_FACTOR CONSTANT VARCHAR2(30)  := 'FACTOR';
11 
12 PROCEDURE Prepare_input_data(
13 	ERR_BUFF OUT  NOCOPY VARCHAR2,
14 	RETCODE OUT  NOCOPY NUMBER,
15 	P_LIST_HEADER_ID_LOW IN OUT NOCOPY NUMBER,
16 	P_LIST_HEADER_ID_HIGH IN OUT NOCOPY NUMBER,
17 	P_LIST_HEADER_ID_TBL IN OUT NOCOPY NUM_TYPE,
18 	P_UPDATE_TYPE IN VARCHAR2
19 );
20 
21 PROCEDURE Update_search_ind(
22 	ERR_BUFF OUT  NOCOPY VARCHAR2,
23 	RETCODE OUT  NOCOPY NUMBER,
24 	P_LIST_HEADER_ID_LOW IN NUMBER,
25 	P_LIST_HEADER_ID_HIGH IN NUMBER,
26 	P_LIST_HEADER_ID_TBL IN NUM_TYPE,
27 	P_UPDATE_TYPE IN VARCHAR2 DEFAULT 'BATCH'
28   );
29 
30 PROCEDURE Update_search_ind(
31 	ERR_BUFF OUT NOCOPY VARCHAR2,
32 	RETCODE OUT NOCOPY NUMBER,
33 	P_LIST_HEADER_ID_LOW IN NUMBER,
34 	P_LIST_HEADER_ID_HIGH IN NUMBER,
35 	P_UPDATE_TYPE IN VARCHAR2
36   );
37 /* End for bug 7309559 */
38   PROCEDURE Update_Pricing_Attributes(
39                              p_list_header_id_low  IN NUMBER default null,
40                              p_list_header_id_high IN NUMBER default null,
41                              p_update_type         IN VARCHAR2 default 'BATCH');
42 
43   PROCEDURE Populate_Factor_List_Attrs(
44                               p_list_header_id_low  IN NUMBER default null,
45                               p_list_header_id_high IN NUMBER default null);
46 
47 END QP_Denormalized_Pricing_Attrs;