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

Line 32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)

28: , milcs_code
29: , short_description
30: ) VALUES (
31: x_milcs_type_id
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

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

29: , short_description
30: ) VALUES (
31: x_milcs_type_id
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

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

30: ) VALUES (
31: x_milcs_type_id
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: , DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)

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

31: x_milcs_type_id
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: , DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
39: , DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)

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

32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: , DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
39: , DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
40: );

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

33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: , DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
39: , DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
40: );
41:

Line 38: , DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)

34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: , DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
39: , DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
40: );
41:
42: OPEN l_insert;

Line 39: , DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)

35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: , DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
39: , DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
40: );
41:
42: OPEN l_insert;
43: FETCH l_insert INTO x_rowid;

Line 73: milcs_type_id=DECODE(x_milcs_type_id,FND_API.G_MISS_NUM,NULL,x_milcs_type_id)

69: ) IS
70: BEGIN
71: UPDATE jtf_ih_media_itm_lc_seg_tys
72: SET
73: milcs_type_id=DECODE(x_milcs_type_id,FND_API.G_MISS_NUM,NULL,x_milcs_type_id)
74: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
75: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
76: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
77: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

Line 74: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)

70: BEGIN
71: UPDATE jtf_ih_media_itm_lc_seg_tys
72: SET
73: milcs_type_id=DECODE(x_milcs_type_id,FND_API.G_MISS_NUM,NULL,x_milcs_type_id)
74: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
75: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
76: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
77: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
78: , milcs_code=DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)

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

71: UPDATE jtf_ih_media_itm_lc_seg_tys
72: SET
73: milcs_type_id=DECODE(x_milcs_type_id,FND_API.G_MISS_NUM,NULL,x_milcs_type_id)
74: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
75: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
76: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
77: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
78: , milcs_code=DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
79: , short_description=DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)

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

72: SET
73: milcs_type_id=DECODE(x_milcs_type_id,FND_API.G_MISS_NUM,NULL,x_milcs_type_id)
74: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
75: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
76: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
77: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
78: , milcs_code=DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
79: , short_description=DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
80: WHERE milcs_type_id = x_milcs_type_id;

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

73: milcs_type_id=DECODE(x_milcs_type_id,FND_API.G_MISS_NUM,NULL,x_milcs_type_id)
74: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
75: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
76: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
77: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
78: , milcs_code=DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
79: , short_description=DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
80: WHERE milcs_type_id = x_milcs_type_id;
81: IF (SQL%NOTFOUND) THEN

Line 78: , milcs_code=DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)

74: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
75: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
76: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
77: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
78: , milcs_code=DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
79: , short_description=DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
80: WHERE milcs_type_id = x_milcs_type_id;
81: IF (SQL%NOTFOUND) THEN
82: RAISE NO_DATA_FOUND;

Line 79: , short_description=DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)

75: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
76: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
77: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
78: , milcs_code=DECODE(x_milcs_code,FND_API.G_MISS_CHAR,NULL,x_milcs_code)
79: , short_description=DECODE(x_short_description,FND_API.G_MISS_CHAR,NULL,x_short_description)
80: WHERE milcs_type_id = x_milcs_type_id;
81: IF (SQL%NOTFOUND) THEN
82: RAISE NO_DATA_FOUND;
83: END IF;