1 package FND_LOAD_UTIL AUTHID CURRENT_USER as
2 /* $Header: AFLDUTLS.pls 120.2.12010000.1 2008/07/25 14:15:57 appldev ship $ */
3
4 -- NULL_VALUE CONSTANT VARCHAR2(6) := '*NULL*';
5 --
6 -- OWNER_NAME
7 -- Return owner tag to be used in FNDLOAD data file
8 -- IN
9 -- p_id - user_id of last_updated_by column
10 -- RETURNS
11 -- OWNER attribute value for FNDLOAD data file
12 --
13 function OWNER_NAME(
14 p_id in number)
15 return varchar2;
16
17 --
18 -- OWNER_ID
19 -- Return the user_id of the OWNER attribute
20 -- IN
21 -- p_name - OWNER attribute value from FNDLOAD data file
22 -- RETURNS
23 -- user_id of owner to use in who columns
24 --
25 function OWNER_ID(
26 p_name in varchar2)
27 return number;
28
29 --
30 -- UPLOAD_TEST
31 -- Test whether or not to over-write database row when uploading
32 -- data from FNDLOAD data file, based on owner attributes of both
33 -- database row and row in file being uploaded.
34 -- IN
35 -- p_file_id - FND_LOAD_UTIL.OWNER_ID(<OWNER attribute from data file>)
36 -- p_file_lud - LAST_UPDATE_DATE attribute from data file
37 -- p_db_id - LAST_UPDATED_BY of db row
38 -- p_db_lud - LAST_UPDATE_DATE of db row
39 -- p_custom_mode - CUSTOM_MODE FNDLOAD parameter value
40 -- RETURNS
41 -- TRUE if safe to over-write.
42 --
43 function UPLOAD_TEST(
44 p_file_id in number,
45 p_file_lud in date,
46 p_db_id in number,
47 p_db_lud in date,
48 p_custom_mode in varchar2)
49 return boolean;
50
51 -- Bug 2438503 - Routine to return NULL value.
52 function NULL_VALUE return varchar2;
53 PRAGMA restrict_references(NULL_VALUE, WNDS, RNDS, WNPS, RNPS);
54
55 NLS_MODE BOOLEAN :=FALSE;
56
57 procedure SET_NLS_MODE;
58 end FND_LOAD_UTIL;