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

Line 12: l_true VARCHAR2(1) := FND_API.G_TRUE;

8: -- Version : Current version 1.0
9: -- Notes :
10: --
11: -- End of comments
12: l_true VARCHAR2(1) := FND_API.G_TRUE;
13:
14: PROCEDURE Insert_Row(
15: x_shp_list_item_id OUT NOCOPY NUMBER ,
16: p_object_version_number IN NUMBER ,

Line 102: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),

98: org_id
99: )
100: VALUES(
101: ibe_sh_shp_list_items_s1.NEXTVAL,
102: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
103: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
104: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
105: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
106: 1,

Line 103: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),

99: )
100: VALUES(
101: ibe_sh_shp_list_items_s1.NEXTVAL,
102: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
103: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
104: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
105: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
106: 1,
107: FND_Global.User_ID,

Line 104: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),

100: VALUES(
101: ibe_sh_shp_list_items_s1.NEXTVAL,
102: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
103: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
104: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
105: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
106: 1,
107: FND_Global.User_ID,
108: SYSDATE,

Line 105: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),

101: ibe_sh_shp_list_items_s1.NEXTVAL,
102: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
103: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
104: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
105: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
106: 1,
107: FND_Global.User_ID,
108: SYSDATE,
109: FND_Global.User_ID,

Line 117: DECODE(p_config_header_id, FND_API.G_MISS_NUM, NULL, p_config_header_id),

113: p_inventory_item_id,
114: p_organization_id,
115: p_uom_code,
116: p_quantity,
117: DECODE(p_config_header_id, FND_API.G_MISS_NUM, NULL, p_config_header_id),
118: DECODE(p_config_revision_num, FND_API.G_MISS_NUM, NULL, p_config_revision_num),
119: DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_complete_configuration_flag),
120: DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_valid_configuration_flag),
121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),

Line 118: DECODE(p_config_revision_num, FND_API.G_MISS_NUM, NULL, p_config_revision_num),

114: p_organization_id,
115: p_uom_code,
116: p_quantity,
117: DECODE(p_config_header_id, FND_API.G_MISS_NUM, NULL, p_config_header_id),
118: DECODE(p_config_revision_num, FND_API.G_MISS_NUM, NULL, p_config_revision_num),
119: DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_complete_configuration_flag),
120: DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_valid_configuration_flag),
121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),
122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),

Line 119: DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_complete_configuration_flag),

115: p_uom_code,
116: p_quantity,
117: DECODE(p_config_header_id, FND_API.G_MISS_NUM, NULL, p_config_header_id),
118: DECODE(p_config_revision_num, FND_API.G_MISS_NUM, NULL, p_config_revision_num),
119: DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_complete_configuration_flag),
120: DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_valid_configuration_flag),
121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),
122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

Line 120: DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_valid_configuration_flag),

116: p_quantity,
117: DECODE(p_config_header_id, FND_API.G_MISS_NUM, NULL, p_config_header_id),
118: DECODE(p_config_revision_num, FND_API.G_MISS_NUM, NULL, p_config_revision_num),
119: DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_complete_configuration_flag),
120: DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_valid_configuration_flag),
121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),
122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

Line 121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),

117: DECODE(p_config_header_id, FND_API.G_MISS_NUM, NULL, p_config_header_id),
118: DECODE(p_config_revision_num, FND_API.G_MISS_NUM, NULL, p_config_revision_num),
119: DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_complete_configuration_flag),
120: DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_valid_configuration_flag),
121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),
122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

Line 122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),

118: DECODE(p_config_revision_num, FND_API.G_MISS_NUM, NULL, p_config_revision_num),
119: DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_complete_configuration_flag),
120: DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_valid_configuration_flag),
121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),
122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

Line 123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

119: DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_complete_configuration_flag),
120: DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_valid_configuration_flag),
121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),
122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

Line 124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

120: DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, NULL, p_valid_configuration_flag),
121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),
122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

Line 125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

121: DECODE(p_item_type_code, FND_API.G_MISS_CHAR, NULL, p_item_type_code),
122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

Line 126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

122: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

Line 127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

123: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

Line 128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

124: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

Line 129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

125: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

Line 130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

126: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

Line 131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

127: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
135: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

Line 132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

128: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
135: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
136: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

Line 133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

129: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
135: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
136: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
137: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

Line 134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

130: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
135: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
136: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
137: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
138: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id))

Line 135: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

131: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
135: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
136: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
137: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
138: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id))
139: RETURNING shp_list_item_id INTO x_shp_list_item_id;

Line 136: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

132: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
135: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
136: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
137: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
138: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id))
139: RETURNING shp_list_item_id INTO x_shp_list_item_id;
140:

Line 137: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

133: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
135: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
136: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
137: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
138: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id))
139: RETURNING shp_list_item_id INTO x_shp_list_item_id;
140:
141: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 138: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id))

134: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
135: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
136: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
137: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
138: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id))
139: RETURNING shp_list_item_id INTO x_shp_list_item_id;
140:
141: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
142: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.Insert row');

Line 194: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),

190: IBE_Util.Debug('Start IBE_Shop_List_line_PKG.update_row');
191: END IF;
192:
193: UPDATE ibe_shp_list_items_all
194: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
195: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
196: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
197: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
198: object_version_number = object_version_number + 1,

Line 195: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),

191: END IF;
192:
193: UPDATE ibe_shp_list_items_all
194: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
195: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
196: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
197: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
198: object_version_number = object_version_number + 1,
199: created_by = created_by,

Line 196: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),

192:
193: UPDATE ibe_shp_list_items_all
194: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
195: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
196: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
197: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
198: object_version_number = object_version_number + 1,
199: created_by = created_by,
200: creation_date = creation_date,

Line 197: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),

193: UPDATE ibe_shp_list_items_all
194: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
195: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
196: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
197: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
198: object_version_number = object_version_number + 1,
199: created_by = created_by,
200: creation_date = creation_date,
201: last_updated_by = FND_Global.User_ID,

Line 207: uom_code = DECODE(p_uom_code, FND_API.G_MISS_CHAR, uom_code, p_uom_code),

203: last_update_login = FND_Global.Login_ID,
204: shp_list_id = shp_list_id,
205: inventory_item_id = inventory_item_id,
206: organization_id = organization_id,
207: uom_code = DECODE(p_uom_code, FND_API.G_MISS_CHAR, uom_code, p_uom_code),
208: quantity = DECODE(p_quantity, FND_API.G_MISS_NUM, quantity, p_quantity),
209: config_header_id = DECODE(p_config_header_id, FND_API.G_MISS_NUM, config_header_id, p_config_header_id),
210: config_revision_num = DECODE(p_config_revision_num, FND_API.G_MISS_NUM, config_revision_num, p_config_revision_num),
211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),

Line 208: quantity = DECODE(p_quantity, FND_API.G_MISS_NUM, quantity, p_quantity),

204: shp_list_id = shp_list_id,
205: inventory_item_id = inventory_item_id,
206: organization_id = organization_id,
207: uom_code = DECODE(p_uom_code, FND_API.G_MISS_CHAR, uom_code, p_uom_code),
208: quantity = DECODE(p_quantity, FND_API.G_MISS_NUM, quantity, p_quantity),
209: config_header_id = DECODE(p_config_header_id, FND_API.G_MISS_NUM, config_header_id, p_config_header_id),
210: config_revision_num = DECODE(p_config_revision_num, FND_API.G_MISS_NUM, config_revision_num, p_config_revision_num),
211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),
212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),

Line 209: config_header_id = DECODE(p_config_header_id, FND_API.G_MISS_NUM, config_header_id, p_config_header_id),

205: inventory_item_id = inventory_item_id,
206: organization_id = organization_id,
207: uom_code = DECODE(p_uom_code, FND_API.G_MISS_CHAR, uom_code, p_uom_code),
208: quantity = DECODE(p_quantity, FND_API.G_MISS_NUM, quantity, p_quantity),
209: config_header_id = DECODE(p_config_header_id, FND_API.G_MISS_NUM, config_header_id, p_config_header_id),
210: config_revision_num = DECODE(p_config_revision_num, FND_API.G_MISS_NUM, config_revision_num, p_config_revision_num),
211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),
212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),
213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),

Line 210: config_revision_num = DECODE(p_config_revision_num, FND_API.G_MISS_NUM, config_revision_num, p_config_revision_num),

206: organization_id = organization_id,
207: uom_code = DECODE(p_uom_code, FND_API.G_MISS_CHAR, uom_code, p_uom_code),
208: quantity = DECODE(p_quantity, FND_API.G_MISS_NUM, quantity, p_quantity),
209: config_header_id = DECODE(p_config_header_id, FND_API.G_MISS_NUM, config_header_id, p_config_header_id),
210: config_revision_num = DECODE(p_config_revision_num, FND_API.G_MISS_NUM, config_revision_num, p_config_revision_num),
211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),
212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),
213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),
214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),

Line 211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),

207: uom_code = DECODE(p_uom_code, FND_API.G_MISS_CHAR, uom_code, p_uom_code),
208: quantity = DECODE(p_quantity, FND_API.G_MISS_NUM, quantity, p_quantity),
209: config_header_id = DECODE(p_config_header_id, FND_API.G_MISS_NUM, config_header_id, p_config_header_id),
210: config_revision_num = DECODE(p_config_revision_num, FND_API.G_MISS_NUM, config_revision_num, p_config_revision_num),
211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),
212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),
213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),
214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),

Line 212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),

208: quantity = DECODE(p_quantity, FND_API.G_MISS_NUM, quantity, p_quantity),
209: config_header_id = DECODE(p_config_header_id, FND_API.G_MISS_NUM, config_header_id, p_config_header_id),
210: config_revision_num = DECODE(p_config_revision_num, FND_API.G_MISS_NUM, config_revision_num, p_config_revision_num),
211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),
212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),
213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),
214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),

Line 213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),

209: config_header_id = DECODE(p_config_header_id, FND_API.G_MISS_NUM, config_header_id, p_config_header_id),
210: config_revision_num = DECODE(p_config_revision_num, FND_API.G_MISS_NUM, config_revision_num, p_config_revision_num),
211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),
212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),
213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),
214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),

Line 214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),

210: config_revision_num = DECODE(p_config_revision_num, FND_API.G_MISS_NUM, config_revision_num, p_config_revision_num),
211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),
212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),
213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),
214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),

Line 215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),

211: complete_configuration_flag = DECODE(p_complete_configuration_flag, FND_API.G_MISS_CHAR, complete_configuration_flag, p_complete_configuration_flag),
212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),
213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),
214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),

Line 216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),

212: valid_configuration_flag = DECODE(p_valid_configuration_flag, FND_API.G_MISS_CHAR, valid_configuration_flag, p_valid_configuration_flag),
213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),
214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),

Line 217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),

213: item_type_code = DECODE(p_item_type_code, FND_API.G_MISS_CHAR, item_type_code, p_item_type_code),
214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),

Line 218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),

214: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),

Line 219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),

215: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),

Line 220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),

216: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),

Line 221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),

217: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),

Line 222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),

218: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
226: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),

Line 223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),

219: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
226: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
227: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),

Line 224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),

220: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
226: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
227: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
228: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),

Line 225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),

221: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
226: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
227: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
228: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
229: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),

Line 226: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),

222: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
226: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
227: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
228: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
229: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
230: org_id = org_id

Line 227: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),

223: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
226: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
227: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
228: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
229: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
230: org_id = org_id
231: WHERE shp_list_item_id = p_shp_list_item_id

Line 228: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),

224: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
226: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
227: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
228: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
229: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
230: org_id = org_id
231: WHERE shp_list_item_id = p_shp_list_item_id
232: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);

Line 229: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),

225: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
226: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
227: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
228: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
229: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
230: org_id = org_id
231: WHERE shp_list_item_id = p_shp_list_item_id
232: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
233: IF (SQL%NOTFOUND) THEN

Line 232: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);

228: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
229: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
230: org_id = org_id
231: WHERE shp_list_item_id = p_shp_list_item_id
232: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
233: IF (SQL%NOTFOUND) THEN
234: RAISE NO_DATA_FOUND;
235: END IF;
236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 244: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM

240:
241:
242: PROCEDURE Delete_Row(
243: p_shp_list_item_id IN NUMBER,
244: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
245: )
246: IS
247: BEGIN
248: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 254: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);

250: END IF;
251: DELETE
252: FROM ibe_shp_list_items_all
253: WHERE shp_list_item_id = p_shp_list_item_id
254: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
255:
256: IF (SQL%NOTFOUND) THEN
257: RAISE NO_DATA_FOUND;
258: END IF;