[Home] [Help]
PACKAGE: APPS.QP_MAINTAIN_DENORMALIZED_DATA
Source
1 PACKAGE QP_Maintain_Denormalized_Data AUTHID CURRENT_USER AS
2 /* $Header: QPXDENOS.pls 120.0.12010000.2 2009/04/28 15:30:44 dnema ship $ */
3 -- Spec variables
4 -- row who columns
5
6 P_created_by NUMBER DEFAULT FND_GLOBAL.USER_ID;
7 P_creation_date DATE DEFAULT SYSDATE;
8 P_login_id NUMBER DEFAULT FND_GLOBAL.LOGIN_ID;
9 P_program_appl_id NUMBER DEFAULT FND_GLOBAL.PROG_APPL_ID;
10 P_conc_program_id NUMBER DEFAULT FND_GLOBAL.CONC_PROGRAM_ID;
11 P_request_id NUMBER DEFAULT FND_GLOBAL.CONC_REQUEST_ID;
12 P_sob_id NUMBER ;
13 P_user_id NUMBER DEFAULT FND_GLOBAL.USER_ID;
14 err_buff VARCHAR2(2000);
15 retcode NUMBER;
16
17 Procedure Set_HVOP_Pricing (x_return_status OUT NOCOPY VARCHAR2,
18 x_return_status_text OUT NOCOPY VARCHAR2);
19
20 PROCEDURE Update_Qualifiers
21 (err_buff out NOCOPY VARCHAR2,
22 retcode out NOCOPY NUMBER,
23 p_List_Header_Id NUMBER deFAult null,
24 p_List_Header_Id_high NUMBER deFAult null,
25 p_update_type VARCHAR2 DEFAULT 'BATCH' ,
26 p_dummy VARCHAR2 DEFAULT null,
27 p_request_id NUMBER := NULL --bug 8359554
28 );
29
30 procedure update_pricing_phases(p_update_type IN VARCHAR2 DEFAULT 'DELAYED'
31 , p_pricing_phase_id IN NUMBER DEFAULT NULL
32 , p_automatic_flag IN VARCHAR2 DEFAULT NULL ----fix for bug 3756625
33 ,p_count IN NUMBER DEFAULT NULL
34 ,p_call_from IN NUMBER DEFAULT NULL
35 , x_return_status OUT NOCOPY VARCHAR2
36 , x_return_status_text OUT NOCOPY VARCHAR2);
37
38 procedure update_row_count(p_List_Header_Id_low NUMBER DEFAULT NULL
39 ,p_List_Header_Id_High NUMBER DEFAULT NULL
40 ,p_update_type VARCHAR DEFAULT 'BATCH'
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_return_status_text OUT NOCOPY VARCHAR2);
43
44 END QP_Maintain_Denormalized_Data;