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_PARTY_SITE_USES_PKG dependencies on FND_API

Line 43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),

39: CREATED_BY_MODULE,
40: APPLICATION_ID
41: )
42: VALUES (
43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),
44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),

40: APPLICATION_ID
41: )
42: VALUES (
43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),
44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

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

41: )
42: VALUES (
43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),
44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),

51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
58: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
59: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),

52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
58: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
59: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
60: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

Line 57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
58: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
59: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
60: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
61: ) RETURNING

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

54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
58: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
59: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
60: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
61: ) RETURNING
62: PARTY_SITE_USE_ID

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

55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
58: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
59: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
60: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
61: ) RETURNING
62: PARTY_SITE_USE_ID
63: INTO

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

56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
58: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
59: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
60: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
61: ) RETURNING
62: PARTY_SITE_USE_ID
63: INTO
64: X_PARTY_SITE_USE_ID;

Line 117: PARTY_SITE_USE_ID = DECODE( X_PARTY_SITE_USE_ID, NULL, PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_USE_ID ),

113:
114: BEGIN
115:
116: UPDATE HZ_PARTY_SITE_USES SET
117: PARTY_SITE_USE_ID = DECODE( X_PARTY_SITE_USE_ID, NULL, PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_USE_ID ),
118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),

114: BEGIN
115:
116: UPDATE HZ_PARTY_SITE_USES SET
117: PARTY_SITE_USE_ID = DECODE( X_PARTY_SITE_USE_ID, NULL, PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_USE_ID ),
118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),

115:
116: UPDATE HZ_PARTY_SITE_USES SET
117: PARTY_SITE_USE_ID = DECODE( X_PARTY_SITE_USE_ID, NULL, PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_USE_ID ),
118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),

125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
132: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
133: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),

126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
132: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
133: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
134: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

Line 131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
132: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
133: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
134: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
135: WHERE ROWID = X_RowId;

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

128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
132: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
133: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
134: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
135: WHERE ROWID = X_RowId;
136:

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

129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
132: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
133: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
134: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
135: WHERE ROWID = X_RowId;
136:
137: IF ( SQL%NOTFOUND ) THEN

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

130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
132: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
133: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
134: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
135: WHERE ROWID = X_RowId;
136:
137: IF ( SQL%NOTFOUND ) THEN
138: RAISE NO_DATA_FOUND;

Line 260: NVL( PARTY_SITE_USE_ID, FND_API.G_MISS_NUM ),

256:
257: BEGIN
258:
259: SELECT
260: NVL( PARTY_SITE_USE_ID, FND_API.G_MISS_NUM ),
261: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
262: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
263: NVL( SITE_USE_TYPE, FND_API.G_MISS_CHAR ),
264: NVL( PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR ),

Line 261: NVL( COMMENTS, FND_API.G_MISS_CHAR ),

257: BEGIN
258:
259: SELECT
260: NVL( PARTY_SITE_USE_ID, FND_API.G_MISS_NUM ),
261: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
262: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
263: NVL( SITE_USE_TYPE, FND_API.G_MISS_CHAR ),
264: NVL( PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR ),
265: NVL( STATUS, FND_API.G_MISS_CHAR ),

Line 262: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),

258:
259: SELECT
260: NVL( PARTY_SITE_USE_ID, FND_API.G_MISS_NUM ),
261: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
262: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
263: NVL( SITE_USE_TYPE, FND_API.G_MISS_CHAR ),
264: NVL( PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR ),
265: NVL( STATUS, FND_API.G_MISS_CHAR ),
266: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 263: NVL( SITE_USE_TYPE, FND_API.G_MISS_CHAR ),

259: SELECT
260: NVL( PARTY_SITE_USE_ID, FND_API.G_MISS_NUM ),
261: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
262: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
263: NVL( SITE_USE_TYPE, FND_API.G_MISS_CHAR ),
264: NVL( PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR ),
265: NVL( STATUS, FND_API.G_MISS_CHAR ),
266: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
267: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 264: NVL( PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR ),

260: NVL( PARTY_SITE_USE_ID, FND_API.G_MISS_NUM ),
261: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
262: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
263: NVL( SITE_USE_TYPE, FND_API.G_MISS_CHAR ),
264: NVL( PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR ),
265: NVL( STATUS, FND_API.G_MISS_CHAR ),
266: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
267: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
268: INTO

Line 265: NVL( STATUS, FND_API.G_MISS_CHAR ),

261: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
262: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
263: NVL( SITE_USE_TYPE, FND_API.G_MISS_CHAR ),
264: NVL( PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR ),
265: NVL( STATUS, FND_API.G_MISS_CHAR ),
266: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
267: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
268: INTO
269: X_PARTY_SITE_USE_ID,

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

262: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
263: NVL( SITE_USE_TYPE, FND_API.G_MISS_CHAR ),
264: NVL( PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR ),
265: NVL( STATUS, FND_API.G_MISS_CHAR ),
266: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
267: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
268: INTO
269: X_PARTY_SITE_USE_ID,
270: X_COMMENTS,

Line 267: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

263: NVL( SITE_USE_TYPE, FND_API.G_MISS_CHAR ),
264: NVL( PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR ),
265: NVL( STATUS, FND_API.G_MISS_CHAR ),
266: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
267: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
268: INTO
269: X_PARTY_SITE_USE_ID,
270: X_COMMENTS,
271: X_PARTY_SITE_ID,

Line 286: RAISE FND_API.G_EXC_ERROR;

282: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
283: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party_site_use_rec');
284: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PARTY_SITE_USE_ID ) );
285: FND_MSG_PUB.ADD;
286: RAISE FND_API.G_EXC_ERROR;
287:
288: END Select_Row;
289:
290: PROCEDURE Delete_Row (