DBA Data[Home] [Help]

APPS.IEO_SVR_GROUPS_PVT dependencies on FND_API

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

32: , location
33: , description
34: ) VALUES (
35: x_server_group_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: , description
34: ) VALUES (
35: x_server_group_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_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)

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

34: ) VALUES (
35: x_server_group_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_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)

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

35: x_server_group_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_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)

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_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

Line 41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)

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_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: );

Line 42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_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_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: );
46:

Line 43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)

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_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: );
46:
47: OPEN l_insert;

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

40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: );
46:
47: OPEN l_insert;
48: FETCH l_insert INTO x_rowid;

Line 82: server_group_id=DECODE(x_server_group_id,FND_API.G_MISS_NUM,NULL,x_server_group_id)

78: ) IS
79: BEGIN
80: UPDATE ieo_svr_groups
81: SET
82: server_group_id=DECODE(x_server_group_id,FND_API.G_MISS_NUM,NULL,x_server_group_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_groups
81: SET
82: server_group_id=DECODE(x_server_group_id,FND_API.G_MISS_NUM,NULL,x_server_group_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_groups
81: SET
82: server_group_id=DECODE(x_server_group_id,FND_API.G_MISS_NUM,NULL,x_server_group_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: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)

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

81: SET
82: server_group_id=DECODE(x_server_group_id,FND_API.G_MISS_NUM,NULL,x_server_group_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: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)

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

82: server_group_id=DECODE(x_server_group_id,FND_API.G_MISS_NUM,NULL,x_server_group_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: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)

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: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

Line 88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)

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: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: WHERE ROWID = x_rowid;

Line 89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_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: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: WHERE ROWID = x_rowid;
93: IF (SQL%NOTFOUND) THEN

Line 90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)

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: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: WHERE ROWID = x_rowid;
93: IF (SQL%NOTFOUND) THEN
94: RAISE NO_DATA_FOUND;

Line 91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: WHERE ROWID = x_rowid;
93: IF (SQL%NOTFOUND) THEN
94: RAISE NO_DATA_FOUND;
95: END IF;