APPS.IBE_SHOP_LIST_HEADER_PKG dependencies on FND_API

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

1: PACKAGE BODY IBE_Shop_List_Header_PKG AS
2: /* $Header: IBEVSLHB.pls 120.1 2005/08/28 21:51:23 appldev ship $ */
3:
4: l_true VARCHAR2(1) := FND_API.G_TRUE;
5:
6: PROCEDURE Insert_Row(
7: x_shp_list_id OUT NOCOPY NUMBER ,
8: p_request_id IN NUMBER ,

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

77: org_id
78: )
79: VALUES(
80: ibe_sh_shp_lists_s1.NEXTVAL,
81: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
82: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
83: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
84: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
85: 1,

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

78: )
79: VALUES(
80: ibe_sh_shp_lists_s1.NEXTVAL,
81: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
82: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
83: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
84: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
85: 1,
86: FND_GLOBAL.User_Id,

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

79: VALUES(
80: ibe_sh_shp_lists_s1.NEXTVAL,
81: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
82: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
83: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
84: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
85: 1,
86: FND_GLOBAL.User_Id,
87: SYSDATE,

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

80: ibe_sh_shp_lists_s1.NEXTVAL,
81: DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
82: DECODE(p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
83: DECODE(p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
84: DECODE(p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
85: 1,
86: FND_GLOBAL.User_Id,
87: SYSDATE,
88: FND_GLOBAL.User_Id,

Line 93: DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, NULL, p_shopping_list_name),

89: SYSDATE,
90: FND_GLOBAL.Login_Id,
91: p_party_id,
92: p_cust_account_id,
93: DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, NULL, p_shopping_list_name),
94: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
95: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
96: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
97: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

Line 94: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),

90: FND_GLOBAL.Login_Id,
91: p_party_id,
92: p_cust_account_id,
93: DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, NULL, p_shopping_list_name),
94: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
95: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
96: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
97: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
98: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

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

91: p_party_id,
92: p_cust_account_id,
93: DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, NULL, p_shopping_list_name),
94: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
95: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
96: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
97: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
98: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
99: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

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

92: p_cust_account_id,
93: DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, NULL, p_shopping_list_name),
94: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
95: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
96: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
97: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
98: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
99: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
100: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

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

93: DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, NULL, p_shopping_list_name),
94: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
95: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
96: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
97: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
98: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
99: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
100: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
101: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

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

94: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
95: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
96: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
97: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
98: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
99: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
100: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
101: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
102: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

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

95: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
96: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
97: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
98: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
99: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
100: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
101: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
102: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
103: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

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

96: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
97: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
98: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
99: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
100: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
101: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
102: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
103: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
104: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

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

97: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
98: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
99: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
100: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
101: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
102: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
103: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
104: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
105: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

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

98: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
99: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
100: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
101: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
102: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
103: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
104: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
105: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
106: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

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

99: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
100: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
101: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
102: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
103: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
104: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
105: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
106: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
107: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

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

100: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
101: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
102: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
103: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
104: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
105: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
106: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
107: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
108: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

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

101: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
102: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
103: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
104: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
105: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
106: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
107: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
108: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
109: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

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

102: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
103: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
104: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
105: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
106: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
107: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
108: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
109: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
110: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

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

103: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
104: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
105: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
106: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
107: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
108: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
109: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
110: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
111: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id)

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

104: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
105: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
106: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
107: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
108: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
109: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
110: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
111: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id)
112: )

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

105: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
106: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
107: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
108: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
109: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
110: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
111: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id)
112: )
113: RETURNING shp_list_id INTO x_shp_list_id;

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

106: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
107: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
108: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
109: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
110: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
111: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id)
112: )
113: RETURNING shp_list_id INTO x_shp_list_id;
114: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

107: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
108: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
109: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
110: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
111: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id)
112: )
113: RETURNING shp_list_id INTO x_shp_list_id;
114: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
115: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.Insert row');

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

156: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Update row');
157: END IF;
158:
159: UPDATE ibe_sh_shp_lists_all
160: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
161: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
162: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
163: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
164: object_version_number = object_version_number + 1,

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

157: END IF;
158:
159: UPDATE ibe_sh_shp_lists_all
160: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
161: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
162: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
163: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
164: object_version_number = object_version_number + 1,
165: created_by = created_by,

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

158:
159: UPDATE ibe_sh_shp_lists_all
160: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
161: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
162: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
163: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
164: object_version_number = object_version_number + 1,
165: created_by = created_by,
166: creation_date = creation_date,

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

159: UPDATE ibe_sh_shp_lists_all
160: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
161: program_application_id = DECODE(p_program_application_id, FND_API.G_MISS_NUM, program_application_id, p_program_application_id),
162: program_id = DECODE(p_program_id, FND_API.G_MISS_NUM, program_id, p_program_id),
163: program_update_date = DECODE(p_program_update_date, FND_API.G_MISS_DATE, program_update_date, p_program_update_date),
164: object_version_number = object_version_number + 1,
165: created_by = created_by,
166: creation_date = creation_date,
167: last_updated_by = FND_GLOBAL.User_Id,

Line 172: shopping_list_name = DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, shopping_list_name, p_shopping_list_name),

168: last_update_date = SYSDATE,
169: last_update_login = FND_GLOBAL.Login_Id,
170: party_id = party_id,
171: cust_account_id = cust_account_id,
172: shopping_list_name = DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, shopping_list_name, p_shopping_list_name),
173: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
174: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
175: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
176: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),

Line 173: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),

169: last_update_login = FND_GLOBAL.Login_Id,
170: party_id = party_id,
171: cust_account_id = cust_account_id,
172: shopping_list_name = DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, shopping_list_name, p_shopping_list_name),
173: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
174: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
175: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
176: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
177: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),

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

170: party_id = party_id,
171: cust_account_id = cust_account_id,
172: shopping_list_name = DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, shopping_list_name, p_shopping_list_name),
173: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
174: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
175: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
176: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
177: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
178: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),

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

171: cust_account_id = cust_account_id,
172: shopping_list_name = DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, shopping_list_name, p_shopping_list_name),
173: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
174: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
175: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
176: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
177: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
178: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
179: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),

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

172: shopping_list_name = DECODE(p_shopping_list_name, FND_API.G_MISS_CHAR, shopping_list_name, p_shopping_list_name),
173: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
174: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
175: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
176: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
177: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
178: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
179: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
180: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),

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

173: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
174: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
175: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
176: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
177: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
178: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
179: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
180: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
181: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),

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

174: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
175: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
176: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
177: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
178: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
179: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
180: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
181: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
182: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),

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

175: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
176: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
177: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
178: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
179: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
180: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
181: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
182: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
183: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),

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

176: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
177: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
178: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
179: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
180: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
181: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
182: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
183: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
184: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),

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

177: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
178: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
179: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
180: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
181: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
182: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
183: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
184: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
185: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),

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

178: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
179: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
180: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
181: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
182: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
183: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
184: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
185: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
186: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),

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

179: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
180: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
181: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
182: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
183: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
184: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
185: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
186: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
187: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),

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

180: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
181: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
182: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
183: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
184: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
185: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
186: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
187: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
188: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),

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

181: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
182: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
183: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
184: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
185: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
186: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
187: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
188: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
189: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),

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

182: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
183: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
184: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
185: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
186: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
187: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
188: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
189: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
190: org_id = DECODE(p_org_id, FND_API.G_MISS_NUM, org_id, p_org_id)

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

183: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
184: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
185: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
186: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
187: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
188: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
189: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
190: org_id = DECODE(p_org_id, FND_API.G_MISS_NUM, org_id, p_org_id)
191: WHERE shp_list_id = p_shp_list_id

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

184: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
185: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
186: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
187: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
188: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
189: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
190: org_id = DECODE(p_org_id, FND_API.G_MISS_NUM, org_id, p_org_id)
191: WHERE shp_list_id = p_shp_list_id
192: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);

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

185: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
186: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
187: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
188: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
189: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
190: org_id = DECODE(p_org_id, FND_API.G_MISS_NUM, org_id, p_org_id)
191: WHERE shp_list_id = p_shp_list_id
192: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
193:

Line 190: org_id = DECODE(p_org_id, FND_API.G_MISS_NUM, org_id, p_org_id)

186: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
187: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
188: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
189: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
190: org_id = DECODE(p_org_id, FND_API.G_MISS_NUM, org_id, p_org_id)
191: WHERE shp_list_id = p_shp_list_id
192: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
193:
194: IF (SQL%NOTFOUND) THEN

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

188: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
189: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
190: org_id = DECODE(p_org_id, FND_API.G_MISS_NUM, org_id, p_org_id)
191: WHERE shp_list_id = p_shp_list_id
192: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
193:
194: IF (SQL%NOTFOUND) THEN
195: RAISE NO_DATA_FOUND;
196: END IF;

Line 205: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

201:
202:
203: PROCEDURE Delete_Row(
204: p_shp_list_id IN NUMBER,
205: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
206: IS
207: BEGIN
208: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
209: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.delete row');

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

211:
212: DELETE
213: FROM ibe_sh_shp_lists_all
214: WHERE shp_list_id = p_shp_list_id
215: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
216:
217: IF (SQL%NOTFOUND) THEN
218: RAISE NO_DATA_FOUND;
219: END IF;