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

Line 72: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

68: content_type,
69: strategy_ref_code,
70: selector_class
71: ) VALUES (
72: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
73: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
74: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
75: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 73: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

69: strategy_ref_code,
70: selector_class
71: ) VALUES (
72: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
73: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
74: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
75: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 74: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

70: selector_class
71: ) VALUES (
72: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
73: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
74: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
75: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),

Line 75: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

71: ) VALUES (
72: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
73: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
74: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
75: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),

Line 76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

72: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
73: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
74: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
75: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),
80: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),

Line 77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

73: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
74: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
75: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),
80: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),

Line 78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),

74: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
75: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),
80: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_strategy_ref_code, FND_API.g_miss_char, NULL, p_strategy_ref_code),

Line 79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),

75: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),
80: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_strategy_ref_code, FND_API.g_miss_char, NULL, p_strategy_ref_code),
83: DECODE( p_selector_class, FND_API.g_miss_char, NULL, p_selector_class));

Line 80: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),

76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),
80: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_strategy_ref_code, FND_API.g_miss_char, NULL, p_strategy_ref_code),
83: DECODE( p_selector_class, FND_API.g_miss_char, NULL, p_selector_class));
84:

Line 81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),

77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),
80: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_strategy_ref_code, FND_API.g_miss_char, NULL, p_strategy_ref_code),
83: DECODE( p_selector_class, FND_API.g_miss_char, NULL, p_selector_class));
84:
85: INSERT INTO AMS_IBA_PS_STRATS_TL (

Line 82: DECODE( p_strategy_ref_code, FND_API.g_miss_char, NULL, p_strategy_ref_code),

78: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),
80: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_strategy_ref_code, FND_API.g_miss_char, NULL, p_strategy_ref_code),
83: DECODE( p_selector_class, FND_API.g_miss_char, NULL, p_selector_class));
84:
85: INSERT INTO AMS_IBA_PS_STRATS_TL (
86: created_by,

Line 83: DECODE( p_selector_class, FND_API.g_miss_char, NULL, p_selector_class));

79: DECODE( p_max_returned, FND_API.g_miss_num, NULL, p_max_returned),
80: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_strategy_ref_code, FND_API.g_miss_char, NULL, p_strategy_ref_code),
83: DECODE( p_selector_class, FND_API.g_miss_char, NULL, p_selector_class));
84:
85: INSERT INTO AMS_IBA_PS_STRATS_TL (
86: created_by,
87: creation_date,

Line 98: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

94: strategy_description,
95: language,
96: source_lang
97: ) SELECT
98: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
99: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
100: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
101: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 99: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

95: language,
96: source_lang
97: ) SELECT
98: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
99: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
100: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
101: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 100: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

96: source_lang
97: ) SELECT
98: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
99: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
100: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
101: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
104: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),

Line 101: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

97: ) SELECT
98: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
99: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
100: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
101: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
104: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
105: DECODE( p_strategy_name, FND_API.G_MISS_CHAR, NULL, p_strategy_name),

Line 102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

98: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
99: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
100: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
101: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
104: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
105: DECODE( p_strategy_name, FND_API.G_MISS_CHAR, NULL, p_strategy_name),
106: DECODE( p_strategy_description, FND_API.G_MISS_CHAR, NULL, p_strategy_description),

Line 103: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

99: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
100: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
101: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
104: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
105: DECODE( p_strategy_name, FND_API.G_MISS_CHAR, NULL, p_strategy_name),
106: DECODE( p_strategy_description, FND_API.G_MISS_CHAR, NULL, p_strategy_description),
107: l.language_code,

Line 104: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),

100: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
101: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
104: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
105: DECODE( p_strategy_name, FND_API.G_MISS_CHAR, NULL, p_strategy_name),
106: DECODE( p_strategy_description, FND_API.G_MISS_CHAR, NULL, p_strategy_description),
107: l.language_code,
108: USERENV('LANG')

Line 105: DECODE( p_strategy_name, FND_API.G_MISS_CHAR, NULL, p_strategy_name),

101: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
104: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
105: DECODE( p_strategy_name, FND_API.G_MISS_CHAR, NULL, p_strategy_name),
106: DECODE( p_strategy_description, FND_API.G_MISS_CHAR, NULL, p_strategy_description),
107: l.language_code,
108: USERENV('LANG')
109: FROM fnd_languages l

Line 106: DECODE( p_strategy_description, FND_API.G_MISS_CHAR, NULL, p_strategy_description),

102: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
104: DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id),
105: DECODE( p_strategy_name, FND_API.G_MISS_CHAR, NULL, p_strategy_name),
106: DECODE( p_strategy_description, FND_API.G_MISS_CHAR, NULL, p_strategy_description),
107: l.language_code,
108: USERENV('LANG')
109: FROM fnd_languages l
110: WHERE l.installed_flag IN ('I', 'B')

Line 114: WHERE t.strategy_id = DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id)

110: WHERE l.installed_flag IN ('I', 'B')
111: AND NOT EXISTS
112: (SELECT null
113: FROM ams_iba_ps_strats_tl t
114: WHERE t.strategy_id = DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id)
115: AND t.language = l.language_code);
116:
117: END Insert_Row;
118:

Line 155: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

151: IS
152: BEGIN
153: Update AMS_IBA_PS_STRATS_B
154: SET
155: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
156: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 156: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

152: BEGIN
153: Update AMS_IBA_PS_STRATS_B
154: SET
155: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
156: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

153: Update AMS_IBA_PS_STRATS_B
154: SET
155: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
156: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),

Line 158: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

154: SET
155: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
156: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),
162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),

Line 159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

155: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
156: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),
162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),
163: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, strategy_type, p_strategy_type),

Line 160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

156: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),
162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),
163: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, strategy_type, p_strategy_type),
164: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),

Line 161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),

157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),
162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),
163: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, strategy_type, p_strategy_type),
164: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
165: strategy_ref_code = DECODE( p_strategy_ref_code, FND_API.g_miss_char, strategy_ref_code, p_strategy_ref_code),

Line 162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),

158: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),
162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),
163: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, strategy_type, p_strategy_type),
164: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
165: strategy_ref_code = DECODE( p_strategy_ref_code, FND_API.g_miss_char, strategy_ref_code, p_strategy_ref_code),
166: selector_class = DECODE( p_selector_class, FND_API.g_miss_char, selector_class, p_selector_class)

Line 163: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, strategy_type, p_strategy_type),

159: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),
162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),
163: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, strategy_type, p_strategy_type),
164: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
165: strategy_ref_code = DECODE( p_strategy_ref_code, FND_API.g_miss_char, strategy_ref_code, p_strategy_ref_code),
166: selector_class = DECODE( p_selector_class, FND_API.g_miss_char, selector_class, p_selector_class)
167: WHERE STRATEGY_ID = p_STRATEGY_ID;

Line 164: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),

160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),
162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),
163: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, strategy_type, p_strategy_type),
164: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
165: strategy_ref_code = DECODE( p_strategy_ref_code, FND_API.g_miss_char, strategy_ref_code, p_strategy_ref_code),
166: selector_class = DECODE( p_selector_class, FND_API.g_miss_char, selector_class, p_selector_class)
167: WHERE STRATEGY_ID = p_STRATEGY_ID;
168: -- AND object_version_number = p_object_version_number;

Line 165: strategy_ref_code = DECODE( p_strategy_ref_code, FND_API.g_miss_char, strategy_ref_code, p_strategy_ref_code),

161: -- strategy_id = DECODE( p_strategy_id, FND_API.g_miss_num, strategy_id, p_strategy_id),
162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),
163: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, strategy_type, p_strategy_type),
164: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
165: strategy_ref_code = DECODE( p_strategy_ref_code, FND_API.g_miss_char, strategy_ref_code, p_strategy_ref_code),
166: selector_class = DECODE( p_selector_class, FND_API.g_miss_char, selector_class, p_selector_class)
167: WHERE STRATEGY_ID = p_STRATEGY_ID;
168: -- AND object_version_number = p_object_version_number;
169:

Line 166: selector_class = DECODE( p_selector_class, FND_API.g_miss_char, selector_class, p_selector_class)

162: max_returned = DECODE( p_max_returned, FND_API.g_miss_num, max_returned, p_max_returned),
163: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, strategy_type, p_strategy_type),
164: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
165: strategy_ref_code = DECODE( p_strategy_ref_code, FND_API.g_miss_char, strategy_ref_code, p_strategy_ref_code),
166: selector_class = DECODE( p_selector_class, FND_API.g_miss_char, selector_class, p_selector_class)
167: WHERE STRATEGY_ID = p_STRATEGY_ID;
168: -- AND object_version_number = p_object_version_number;
169:
170: IF (SQL%NOTFOUND) THEN

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: WHERE STRATEGY_ID = p_STRATEGY_ID;
168: -- AND object_version_number = p_object_version_number;
169:
170: IF (SQL%NOTFOUND) THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: UPDATE ams_iba_ps_strats_tl SET
175: strategy_name = decode( p_strategy_NAME, FND_API.G_MISS_CHAR, strategy_NAME, p_strategy_NAME),

Line 175: strategy_name = decode( p_strategy_NAME, FND_API.G_MISS_CHAR, strategy_NAME, p_strategy_NAME),

171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: UPDATE ams_iba_ps_strats_tl SET
175: strategy_name = decode( p_strategy_NAME, FND_API.G_MISS_CHAR, strategy_NAME, p_strategy_NAME),
176: strategy_description = decode( p_strategy_DESCRIPTION, FND_API.G_MISS_CHAR, STRATEGY_DESCRIPTION, p_strategy_DESCRIPTION),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
179: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 176: strategy_description = decode( p_strategy_DESCRIPTION, FND_API.G_MISS_CHAR, STRATEGY_DESCRIPTION, p_strategy_DESCRIPTION),

172: END IF;
173:
174: UPDATE ams_iba_ps_strats_tl SET
175: strategy_name = decode( p_strategy_NAME, FND_API.G_MISS_CHAR, strategy_NAME, p_strategy_NAME),
176: strategy_description = decode( p_strategy_DESCRIPTION, FND_API.G_MISS_CHAR, STRATEGY_DESCRIPTION, p_strategy_DESCRIPTION),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
179: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
180: source_lang = USERENV('LANG')

Line 177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

173:
174: UPDATE ams_iba_ps_strats_tl SET
175: strategy_name = decode( p_strategy_NAME, FND_API.G_MISS_CHAR, strategy_NAME, p_strategy_NAME),
176: strategy_description = decode( p_strategy_DESCRIPTION, FND_API.G_MISS_CHAR, STRATEGY_DESCRIPTION, p_strategy_DESCRIPTION),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
179: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
180: source_lang = USERENV('LANG')
181: WHERE strategy_id = p_strategy_id

Line 178: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

174: UPDATE ams_iba_ps_strats_tl SET
175: strategy_name = decode( p_strategy_NAME, FND_API.G_MISS_CHAR, strategy_NAME, p_strategy_NAME),
176: strategy_description = decode( p_strategy_DESCRIPTION, FND_API.G_MISS_CHAR, STRATEGY_DESCRIPTION, p_strategy_DESCRIPTION),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
179: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
180: source_lang = USERENV('LANG')
181: WHERE strategy_id = p_strategy_id
182: AND USERENV('LANG') IN (language, source_lang);

Line 179: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

175: strategy_name = decode( p_strategy_NAME, FND_API.G_MISS_CHAR, strategy_NAME, p_strategy_NAME),
176: strategy_description = decode( p_strategy_DESCRIPTION, FND_API.G_MISS_CHAR, STRATEGY_DESCRIPTION, p_strategy_DESCRIPTION),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
179: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
180: source_lang = USERENV('LANG')
181: WHERE strategy_id = p_strategy_id
182: AND USERENV('LANG') IN (language, source_lang);
183:

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209: BEGIN
210: DELETE FROM AMS_IBA_PS_STRATS_B
211: WHERE STRATEGY_ID = p_STRATEGY_ID;
212: If (SQL%NOTFOUND) then
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: End If;
215:
216: DELETE FROM AMS_IBA_PS_STRATS_TL
217: WHERE STRATEGY_ID = p_STRATEGY_ID;

Line 219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

215:
216: DELETE FROM AMS_IBA_PS_STRATS_TL
217: WHERE STRATEGY_ID = p_STRATEGY_ID;
218: If (SQL%NOTFOUND) then
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: End If;
221:
222: END Delete_Row ;
223: