APPS.AMS_WEB_CITEM_ASSOC_PKG dependencies on FND_API

Line 71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),

67: last_update_date,
68: last_update_login,
69: object_version_number
70: ) VALUES (
71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

68: last_update_login,
69: object_version_number
70: ) VALUES (
71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),

69: object_version_number
70: ) VALUES (
71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

70: ) VALUES (
71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

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

73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
81:

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

74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
81:
82:

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

75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
81:
82:
83: END Insert_Row;

Line 80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
81:
82:
83: END Insert_Row;
84:

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

116:
117:
118: UPDATE ams_web_plce_citem_assoc
119: SET
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),

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

117:
118: UPDATE ams_web_plce_citem_assoc
119: SET
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)

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

118: UPDATE ams_web_plce_citem_assoc
119: SET
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
126: WHERE placement_citem_id = p_placement_citem_id;

Line 123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),

119: SET
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
126: WHERE placement_citem_id = p_placement_citem_id;
127:

Line 124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),

120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
126: WHERE placement_citem_id = p_placement_citem_id;
127:
128: IF (SQL%NOTFOUND) THEN

Line 125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)

121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
126: WHERE placement_citem_id = p_placement_citem_id;
127:
128: IF (SQL%NOTFOUND) THEN
129: RAISE no_data_found;