1 package INVPULI2 as
2 /* $Header: INVPUL2S.pls 120.1.12010000.2 2008/07/29 13:43:51 ptkumar ship $ */
3
4 TYPE Import_Template_Tbl_Type IS TABLE OF NUMBER
5 INDEX BY BINARY_INTEGER;
6
7 function copy_template_attributes(
8 org_id IN NUMBER
9 ,all_org IN NUMBER := 2
10 ,prog_appid IN NUMBER := -1
11 ,prog_id IN NUMBER := -1
12 ,request_id IN NUMBER := -1
13 ,user_id IN NUMBER := -1
14 ,login_id IN NUMBER := -1
15 ,xset_id IN NUMBER := -999
16 ,err_text IN OUT NOCOPY VARCHAR2
17 ) RETURN INTEGER;
18
19 /*------------------------------------------------------------------------------------
20
21 Procedure for Applying the specfied template to the specified interface row.
22
23 ------------------------------------------------------------------------------------*/
24
25 FUNCTION apply_multiple_template( p_template_tbl IN Import_Template_Tbl_Type
26 ,p_org_id IN NUMBER
27 ,p_all_org IN NUMBER := 2
28 ,p_prog_appid IN NUMBER := -1
29 ,p_prog_id IN NUMBER := -1
30 ,p_request_id IN NUMBER := -1
31 ,p_user_id IN NUMBER := -1
32 ,p_login_id IN NUMBER := -1
33 ,p_xset_id IN NUMBER := -999
34 ,x_err_text IN OUT NOCOPY VARCHAR2)
35 RETURN INTEGER;
36
37 end INVPULI2;