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.IEO_SVR_VALUES_PVT dependencies on FND_API

Line 36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

32: , server_id
33: , value
34: ) VALUES (
35: x_value_id
36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

Line 37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

33: , value
34: ) VALUES (
35: x_value_id
36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)

Line 38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

34: ) VALUES (
35: x_value_id
36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
42: , DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)

Line 39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

35: x_value_id
36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
42: , DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
43: , DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)

Line 40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
42: , DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
43: , DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
44: , DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)

Line 41: , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)

37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
42: , DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
43: , DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
44: , DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
45: );

Line 42: , DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)

38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
42: , DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
43: , DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
44: , DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
45: );
46:

Line 43: , DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)

39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
42: , DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
43: , DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
44: , DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
45: );
46:
47: OPEN l_insert;

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

40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
42: , DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
43: , DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
44: , DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
45: );
46:
47: OPEN l_insert;
48: FETCH l_insert INTO x_rowid;

Line 82: value_id=DECODE(x_value_id,FND_API.G_MISS_NUM,NULL,x_value_id)

78: ) IS
79: BEGIN
80: UPDATE ieo_svr_values
81: SET
82: value_id=DECODE(x_value_id,FND_API.G_MISS_NUM,NULL,x_value_id)
83: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

Line 83: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

79: BEGIN
80: UPDATE ieo_svr_values
81: SET
82: value_id=DECODE(x_value_id,FND_API.G_MISS_NUM,NULL,x_value_id)
83: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

Line 84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

80: UPDATE ieo_svr_values
81: SET
82: value_id=DECODE(x_value_id,FND_API.G_MISS_NUM,NULL,x_value_id)
83: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)

Line 85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

81: SET
82: value_id=DECODE(x_value_id,FND_API.G_MISS_NUM,NULL,x_value_id)
83: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
89: , param_id=DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)

Line 86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

82: value_id=DECODE(x_value_id,FND_API.G_MISS_NUM,NULL,x_value_id)
83: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
89: , param_id=DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
90: , server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)

Line 87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

83: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
89: , param_id=DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
90: , server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
91: , value=DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)

Line 88: , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)

84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
89: , param_id=DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
90: , server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
91: , value=DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
92: WHERE ROWID = x_rowid;

Line 89: , param_id=DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)

85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
89: , param_id=DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
90: , server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
91: , value=DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
92: WHERE ROWID = x_rowid;
93: IF (SQL%NOTFOUND) THEN

Line 90: , server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)

86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
89: , param_id=DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
90: , server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
91: , value=DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
92: WHERE ROWID = x_rowid;
93: IF (SQL%NOTFOUND) THEN
94: RAISE NO_DATA_FOUND;

Line 91: , value=DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)

87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , value_index=DECODE(x_value_index,FND_API.G_MISS_NUM,NULL,x_value_index)
89: , param_id=DECODE(x_param_id,FND_API.G_MISS_NUM,NULL,x_param_id)
90: , server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
91: , value=DECODE(x_value,FND_API.G_MISS_CHAR,NULL,x_value)
92: WHERE ROWID = x_rowid;
93: IF (SQL%NOTFOUND) THEN
94: RAISE NO_DATA_FOUND;
95: END IF;