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

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

49: , media_type_id
50: ) VALUES (
51: x_wbsc_id
52: , x_svcpln_svcpln_id
53: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
54: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
55: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
56: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
57: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

Line 54: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)

50: ) VALUES (
51: x_wbsc_id
52: , x_svcpln_svcpln_id
53: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
54: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
55: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
56: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
57: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)

Line 55: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)

51: x_wbsc_id
52: , x_svcpln_svcpln_id
53: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
54: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
55: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
56: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
57: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)

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

52: , x_svcpln_svcpln_id
53: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
54: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
55: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
56: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
57: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
60: , DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)

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

53: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
54: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
55: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
56: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
57: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
60: , DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)

Line 58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)

54: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
55: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
56: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
57: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
60: , DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)

Line 59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)

55: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
56: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
57: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
60: , DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)

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

56: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
57: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
60: , DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
64: , DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)

Line 61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)

57: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
60: , DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
64: , DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
65: , DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)

Line 62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)

58: , DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
60: , DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
64: , DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
65: , DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
66: , DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)

Line 63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)

59: , DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
60: , DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
64: , DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
65: , DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
66: , DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
67: , DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)

Line 64: , DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)

60: , DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
64: , DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
65: , DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
66: , DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
67: , DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)
68: , x_MEDIA_TYPE_ID

Line 65: , DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)

61: , DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
64: , DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
65: , DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
66: , DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
67: , DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)
68: , x_MEDIA_TYPE_ID
69: );

Line 66: , DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)

62: , DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
64: , DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
65: , DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
66: , DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
67: , DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)
68: , x_MEDIA_TYPE_ID
69: );
70:

Line 67: , DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)

63: , DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
64: , DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
65: , DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
66: , DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
67: , DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)
68: , x_MEDIA_TYPE_ID
69: );
70:
71: INSERT INTO ieb_svc_cat_temps_tl (

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

81: , language
82: , source_lang
83: ) select
84: x_wbsc_id
85: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
86: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
87: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
88: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
89: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

Line 86: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)

82: , source_lang
83: ) select
84: x_wbsc_id
85: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
86: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
87: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
88: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
89: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
90: , DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)

Line 87: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)

83: ) select
84: x_wbsc_id
85: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
86: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
87: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
88: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
89: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
90: , DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
91: , DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)

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

84: x_wbsc_id
85: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
86: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
87: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
88: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
89: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
90: , DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
91: , DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
92: , DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)

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

85: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
86: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
87: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
88: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
89: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
90: , DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
91: , DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
92: , DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)
93: , l.language_code

Line 90: , DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)

86: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
87: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
88: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
89: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
90: , DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
91: , DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
92: , DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)
93: , l.language_code
94: , USERENV('LANG')

Line 91: , DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)

87: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
88: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
89: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
90: , DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
91: , DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
92: , DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)
93: , l.language_code
94: , USERENV('LANG')
95: from fnd_languages l

Line 92: , DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)

88: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
89: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
90: , DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
91: , DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
92: , DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)
93: , l.language_code
94: , USERENV('LANG')
95: from fnd_languages l
96: WHERE l.installed_flag IN ('I', 'B')

Line 129: svcpln_svcpln_id=DECODE(x_svcpln_svcpln_id,FND_API.G_MISS_NUM,NULL,x_svcpln_svcpln_id)

125: ) IS
126: BEGIN
127: UPDATE ieb_svc_cat_temps_b
128: SET
129: svcpln_svcpln_id=DECODE(x_svcpln_svcpln_id,FND_API.G_MISS_NUM,NULL,x_svcpln_svcpln_id)
130: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
131: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
132: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)

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

126: BEGIN
127: UPDATE ieb_svc_cat_temps_b
128: SET
129: svcpln_svcpln_id=DECODE(x_svcpln_svcpln_id,FND_API.G_MISS_NUM,NULL,x_svcpln_svcpln_id)
130: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
131: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
132: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)

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

127: UPDATE ieb_svc_cat_temps_b
128: SET
129: svcpln_svcpln_id=DECODE(x_svcpln_svcpln_id,FND_API.G_MISS_NUM,NULL,x_svcpln_svcpln_id)
130: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
131: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
132: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)

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

128: SET
129: svcpln_svcpln_id=DECODE(x_svcpln_svcpln_id,FND_API.G_MISS_NUM,NULL,x_svcpln_svcpln_id)
130: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
131: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
132: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)

Line 133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)

129: svcpln_svcpln_id=DECODE(x_svcpln_svcpln_id,FND_API.G_MISS_NUM,NULL,x_svcpln_svcpln_id)
130: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
131: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
132: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)

Line 134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)

130: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
131: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
132: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)

Line 135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)

131: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
132: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
139: , src_tbl_key_column=DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)

Line 136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)

132: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
139: , src_tbl_key_column=DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
140: , src_tbl_value_column=DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)

Line 137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)

133: , media_type=DECODE(x_media_type,FND_API.G_MISS_CHAR,NULL,x_media_type)
134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
139: , src_tbl_key_column=DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
140: , src_tbl_value_column=DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
141: , src_tbl_value_translation_flag=DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)

Line 138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)

134: , depth=DECODE(x_depth,FND_API.G_MISS_NUM,NULL,x_depth)
135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
139: , src_tbl_key_column=DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
140: , src_tbl_value_column=DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
141: , src_tbl_value_translation_flag=DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
142: , src_tbl_where_clause=DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)

Line 139: , src_tbl_key_column=DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)

135: , parent_id=DECODE(x_parent_id,FND_API.G_MISS_NUM,NULL,x_parent_id)
136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
139: , src_tbl_key_column=DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
140: , src_tbl_value_column=DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
141: , src_tbl_value_translation_flag=DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
142: , src_tbl_where_clause=DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)
143: , media_type_id = x_media_type_id

Line 140: , src_tbl_value_column=DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)

136: , original_name=DECODE(x_original_name,FND_API.G_MISS_CHAR,NULL,x_original_name)
137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
139: , src_tbl_key_column=DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
140: , src_tbl_value_column=DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
141: , src_tbl_value_translation_flag=DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
142: , src_tbl_where_clause=DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)
143: , media_type_id = x_media_type_id
144: WHERE

Line 141: , src_tbl_value_translation_flag=DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)

137: , active_y_n=DECODE(x_active_y_n,FND_API.G_MISS_CHAR,NULL,x_active_y_n)
138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
139: , src_tbl_key_column=DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
140: , src_tbl_value_column=DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
141: , src_tbl_value_translation_flag=DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
142: , src_tbl_where_clause=DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)
143: , media_type_id = x_media_type_id
144: WHERE
145: wbsc_id=x_wbsc_id;

Line 142: , src_tbl_where_clause=DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)

138: , source_table_name=DECODE(x_source_table_name,FND_API.G_MISS_CHAR,NULL,x_source_table_name)
139: , src_tbl_key_column=DECODE(x_src_tbl_key_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_key_column)
140: , src_tbl_value_column=DECODE(x_src_tbl_value_column,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_column)
141: , src_tbl_value_translation_flag=DECODE(x_src_tbl_value_translation_fl,FND_API.G_MISS_CHAR,NULL,x_src_tbl_value_translation_fl)
142: , src_tbl_where_clause=DECODE(x_src_tbl_where_clause,FND_API.G_MISS_CHAR,NULL,x_src_tbl_where_clause)
143: , media_type_id = x_media_type_id
144: WHERE
145: wbsc_id=x_wbsc_id;
146:

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

149: END IF;
150:
151: UPDATE ieb_svc_cat_temps_tl
152: SET
153: last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
154: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
155: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
156: , SERVICE_CATEGORY_NAME = DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
157: , DESCRIPTION = DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)

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

150:
151: UPDATE ieb_svc_cat_temps_tl
152: SET
153: last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
154: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
155: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
156: , SERVICE_CATEGORY_NAME = DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
157: , DESCRIPTION = DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
158: , MEDIA_CATEGORY_LABEL = DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)

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

151: UPDATE ieb_svc_cat_temps_tl
152: SET
153: last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
154: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
155: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
156: , SERVICE_CATEGORY_NAME = DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
157: , DESCRIPTION = DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
158: , MEDIA_CATEGORY_LABEL = DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)
159: , source_lang = USERENV('LANG')

Line 156: , SERVICE_CATEGORY_NAME = DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)

152: SET
153: last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
154: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
155: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
156: , SERVICE_CATEGORY_NAME = DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
157: , DESCRIPTION = DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
158: , MEDIA_CATEGORY_LABEL = DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)
159: , source_lang = USERENV('LANG')
160: WHERE

Line 157: , DESCRIPTION = DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)

153: last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
154: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
155: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
156: , SERVICE_CATEGORY_NAME = DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
157: , DESCRIPTION = DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
158: , MEDIA_CATEGORY_LABEL = DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)
159: , source_lang = USERENV('LANG')
160: WHERE
161: wbsc_id=x_wbsc_id

Line 158: , MEDIA_CATEGORY_LABEL = DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)

154: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
155: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
156: , SERVICE_CATEGORY_NAME = DECODE(x_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,NULL,x_SERVICE_CATEGORY_NAME)
157: , DESCRIPTION = DECODE(x_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,x_DESCRIPTION)
158: , MEDIA_CATEGORY_LABEL = DECODE(x_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL,x_MEDIA_CATEGORY_LABEL)
159: , source_lang = USERENV('LANG')
160: WHERE
161: wbsc_id=x_wbsc_id
162: AND USERENV('LANG') IN (language, source_lang);

Line 281: , SERVICE_CATEGORY_NAME = DECODE(p_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,

277: SET
278: last_update_date=sysdate
279: , last_updated_by=user_id
280: , last_update_login=0
281: , SERVICE_CATEGORY_NAME = DECODE(p_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,
282: NULL,p_SERVICE_CATEGORY_NAME)
283: , DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION)
284: , MEDIA_CATEGORY_LABEL = DECODE(p_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL, p_MEDIA_CATEGORY_LABEL)
285: , source_lang = USERENV('LANG')

Line 283: , DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION)

279: , last_updated_by=user_id
280: , last_update_login=0
281: , SERVICE_CATEGORY_NAME = DECODE(p_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,
282: NULL,p_SERVICE_CATEGORY_NAME)
283: , DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION)
284: , MEDIA_CATEGORY_LABEL = DECODE(p_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL, p_MEDIA_CATEGORY_LABEL)
285: , source_lang = USERENV('LANG')
286: WHERE
287: wbsc_id=p_wbsc_id

Line 284: , MEDIA_CATEGORY_LABEL = DECODE(p_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL, p_MEDIA_CATEGORY_LABEL)

280: , last_update_login=0
281: , SERVICE_CATEGORY_NAME = DECODE(p_SERVICE_CATEGORY_NAME,FND_API.G_MISS_CHAR,
282: NULL,p_SERVICE_CATEGORY_NAME)
283: , DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION)
284: , MEDIA_CATEGORY_LABEL = DECODE(p_MEDIA_CATEGORY_LABEL,FND_API.G_MISS_CHAR,NULL, p_MEDIA_CATEGORY_LABEL)
285: , source_lang = USERENV('LANG')
286: WHERE
287: wbsc_id=p_wbsc_id
288: AND USERENV('LANG') IN (language, source_lang);