PACKAGE: APPS.QP_INT_LOADER_PUB

Source

1 PACKAGE QP_INT_LOADER_PUB AUTHID CURRENT_USER AS
2 /* $Header: QPXILDRS.pls 120.1 2005/06/14 05:36:16 appldev  $ */
3 
4 G_PROCESS_LST_REQ_TYPE                  VARCHAR2(3);
5 
6 PROCEDURE Load_Int_List
7 (	p_process_id		IN	NUMBER,
8 	x_status		OUT NOCOPY /* file.sql.39 change */	VARCHAR2,
9 	x_errors		OUT NOCOPY /* file.sql.39 change */	VARCHAR2
10 );
11 
12 
13 PROCEDURE Load_Int_List
14 (	p_process_id		IN	NUMBER,
15 	p_action_code		IN	VARCHAR2
16 );
17 
18 /*
19 
20 PROCEDURE Insert_Err_Msg
21 (
22 		p_job_id		IN	NUMBER,
23 		p_line_num		IN	NUMBER,
24 		p_field_name		IN 	VARCHAR2,
25 		p_creation_date		IN 	DATE,
26 		p_err_msg		IN 	VARCHAR2,
27 		p_last_update_date	IN 	DATE
28 );
29 
30 PROCEDURE Insert_Job_Status
31 (
32 		p_job_id		IN	NUMBER,
33 		p_lines_processed	IN	NUMBER,
34 		p_lines_failed		IN 	NUMBER,
35 		p_lines_submitted	IN 	NUMBER,
36 		p_total_error_number	IN 	NUMBER,
37 		p_supplier_id		IN 	NUMBER,
38 		p_job_status		IN	VARCHAR2,
39 		p_job_type		IN	VARCHAR2,
40 		p_file_name		IN	VARCHAR2,
41 		p_start_date		IN 	DATE,
42 		p_completion_date	IN	DATE
43 );
44 
45 PROCEDURE GetRegionId (
46 	p_region_str IN VARCHAR2,
47 	x_region_id OUT NOCOPY NUMBER,
48 	x_rid_err_msg OUT NOCOPY VARCHAR2
49 );
50 */
51 
52 PROCEDURE Get_Party_Id (
53 	p_process_id IN NUMBER,
54 	x_party_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
55 	x_pid_err_msg OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 );
57 
58 PROCEDURE Is_Qualifier_Prclst_Exist (
59 		p_prclst_name IN VARCHAR2,
60 		x_prclst_exists OUT NOCOPY /* file.sql.39 change */ BOOLEAN,
61 		x_prclst_exists_err_msg OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 );
63 
64 g_temp_status varchar2(30);
65 g_temp_errors varchar2(5000);
66 g_temp_region_id NUMBER;
67 
68 END QP_INT_LOADER_PUB;