eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_LOC_ASSIGNMENTS_PKG dependencies on FND_API

Line 33: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),

29: CREATED_BY_MODULE,
30: APPLICATION_ID
31: )
32: VALUES (
33: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
34: DECODE( X_LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
35: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 34: DECODE( X_LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),

30: APPLICATION_ID
31: )
32: VALUES (
33: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
34: DECODE( X_LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
35: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 35: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),

31: )
32: VALUES (
33: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
34: DECODE( X_LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
35: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 45: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

41: HZ_UTILITY_V2PUB.REQUEST_ID,
42: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
43: HZ_UTILITY_V2PUB.PROGRAM_ID,
44: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
45: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
46: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
47: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
48: ) ;
49:

Line 46: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

42: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
43: HZ_UTILITY_V2PUB.PROGRAM_ID,
44: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
45: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
46: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
47: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
48: ) ;
49:
50: END Insert_Row;

Line 47: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

43: HZ_UTILITY_V2PUB.PROGRAM_ID,
44: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
45: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
46: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
47: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
48: ) ;
49:
50: END Insert_Row;
51:

Line 66: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),

62:
63: BEGIN
64:
65: UPDATE HZ_LOC_ASSIGNMENTS SET
66: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
67: LOC_ID = DECODE( X_LOC_ID, NULL, LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
68: ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
69: CREATED_BY = CREATED_BY,
70: CREATION_DATE = CREATION_DATE,

Line 67: LOC_ID = DECODE( X_LOC_ID, NULL, LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),

63: BEGIN
64:
65: UPDATE HZ_LOC_ASSIGNMENTS SET
66: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
67: LOC_ID = DECODE( X_LOC_ID, NULL, LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
68: ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
69: CREATED_BY = CREATED_BY,
70: CREATION_DATE = CREATION_DATE,
71: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 68: ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),

64:
65: UPDATE HZ_LOC_ASSIGNMENTS SET
66: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
67: LOC_ID = DECODE( X_LOC_ID, NULL, LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
68: ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
69: CREATED_BY = CREATED_BY,
70: CREATION_DATE = CREATION_DATE,
71: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
72: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 78: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

74: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
75: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
76: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
77: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
78: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
79: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
80: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
81: WHERE ROWID = X_RowId;
82:

Line 79: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

75: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
76: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
77: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
78: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
79: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
80: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
81: WHERE ROWID = X_RowId;
82:
83: IF ( SQL%NOTFOUND ) THEN

Line 80: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

76: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
77: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
78: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
79: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
80: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
81: WHERE ROWID = X_RowId;
82:
83: IF ( SQL%NOTFOUND ) THEN
84: RAISE NO_DATA_FOUND;

Line 193: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),

189:
190: BEGIN
191:
192: SELECT
193: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
194: NVL( LOC_ID, FND_API.G_MISS_NUM ),
195: NVL( ORG_ID, FND_API.G_MISS_NUM ),
196: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
197: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 194: NVL( LOC_ID, FND_API.G_MISS_NUM ),

190: BEGIN
191:
192: SELECT
193: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
194: NVL( LOC_ID, FND_API.G_MISS_NUM ),
195: NVL( ORG_ID, FND_API.G_MISS_NUM ),
196: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
197: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
198: INTO

Line 195: NVL( ORG_ID, FND_API.G_MISS_NUM ),

191:
192: SELECT
193: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
194: NVL( LOC_ID, FND_API.G_MISS_NUM ),
195: NVL( ORG_ID, FND_API.G_MISS_NUM ),
196: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
197: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
198: INTO
199: X_LOCATION_ID,

Line 196: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

192: SELECT
193: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
194: NVL( LOC_ID, FND_API.G_MISS_NUM ),
195: NVL( ORG_ID, FND_API.G_MISS_NUM ),
196: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
197: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
198: INTO
199: X_LOCATION_ID,
200: X_LOC_ID,

Line 197: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

193: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
194: NVL( LOC_ID, FND_API.G_MISS_NUM ),
195: NVL( ORG_ID, FND_API.G_MISS_NUM ),
196: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
197: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
198: INTO
199: X_LOCATION_ID,
200: X_LOC_ID,
201: X_ORG_ID,

Line 214: RAISE FND_API.G_EXC_ERROR;

210: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
211: FND_MESSAGE.SET_TOKEN( 'RECORD', 'loc_assignment_rec');
212: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_LOCATION_ID ) );
213: FND_MSG_PUB.ADD;
214: RAISE FND_API.G_EXC_ERROR;
215:
216: END Select_Row;
217:
218: PROCEDURE Delete_Row (