APPS.OZF_PRODUCT_ALLOCATIONS_PKG dependencies on FND_API

Line 67: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN

63:
64:
65: BEGIN
66:
67: IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
68: SELECT NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99)
69: INTO px_org_id
70: FROM DUAL;
71: END IF;

Line 112: DECODE( px_product_allocation_id, FND_API.G_MISS_NUM, NULL, px_product_allocation_id),

108: org_id
109: )
110: VALUES
111: (
112: DECODE( px_product_allocation_id, FND_API.G_MISS_NUM, NULL, px_product_allocation_id),
113: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
114: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
115: DECODE( p_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),
116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),

Line 113: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),

109: )
110: VALUES
111: (
112: DECODE( px_product_allocation_id, FND_API.G_MISS_NUM, NULL, px_product_allocation_id),
113: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
114: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
115: DECODE( p_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),
116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
117: DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),

Line 114: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),

110: VALUES
111: (
112: DECODE( px_product_allocation_id, FND_API.G_MISS_NUM, NULL, px_product_allocation_id),
113: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
114: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
115: DECODE( p_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),
116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
117: DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),
118: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),

Line 115: DECODE( p_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),

111: (
112: DECODE( px_product_allocation_id, FND_API.G_MISS_NUM, NULL, px_product_allocation_id),
113: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
114: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
115: DECODE( p_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),
116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
117: DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),
118: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
119: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),

Line 116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),

112: DECODE( px_product_allocation_id, FND_API.G_MISS_NUM, NULL, px_product_allocation_id),
113: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
114: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
115: DECODE( p_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),
116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
117: DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),
118: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
119: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
120: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),

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

113: DECODE( p_allocation_for, FND_API.g_miss_char, NULL, p_allocation_for),
114: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
115: DECODE( p_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),
116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
117: DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),
118: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
119: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
120: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
121: DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),

Line 118: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),

114: DECODE( p_allocation_for_id, FND_API.G_MISS_NUM, NULL, p_allocation_for_id),
115: DECODE( p_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),
116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
117: DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),
118: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
119: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
120: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
121: DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),
122: px_object_version_number,

Line 119: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),

115: DECODE( p_fund_id, FND_API.G_MISS_NUM, NULL, p_fund_id),
116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
117: DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),
118: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
119: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
120: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
121: DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),
122: px_object_version_number,
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 120: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),

116: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
117: DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),
118: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
119: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
120: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
121: DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),
122: px_object_version_number,
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 121: DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),

117: DECODE( p_item_id, FND_API.G_MISS_NUM, NULL, p_item_id),
118: DECODE( p_selected_flag, FND_API.g_miss_char, NULL, p_selected_flag),
119: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
120: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
121: DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),
122: px_object_version_number,
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

119: DECODE( p_target, FND_API.G_MISS_NUM, NULL, p_target),
120: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
121: DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),
122: px_object_version_number,
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

120: DECODE( p_lysp_sales, FND_API.G_MISS_NUM, NULL, p_lysp_sales),
121: DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),
122: px_object_version_number,
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

Line 125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

121: DECODE( p_parent_product_allocation_id, FND_API.G_MISS_NUM, NULL, p_parent_product_allocation_id),
122: px_object_version_number,
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

122: px_object_version_number,
123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

123: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

124: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

Line 129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

125: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

Line 130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

126: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

Line 131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

127: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

Line 132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

Line 133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

Line 134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

Line 135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

Line 136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

Line 137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

Line 138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

Line 139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

Line 140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
144: px_org_id

Line 141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
144: px_org_id
145: );

Line 142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
144: px_org_id
145: );
146:

Line 143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
144: px_org_id
145: );
146:
147: END Insert_Row;

Line 200: product_allocation_id = DECODE( p_product_allocation_id, null, product_allocation_id, FND_API.G_MISS_NUM, null, p_product_allocation_id),

196: IS
197: BEGIN
198: Update ozf_product_allocations
199: SET
200: product_allocation_id = DECODE( p_product_allocation_id, null, product_allocation_id, FND_API.G_MISS_NUM, null, p_product_allocation_id),
201: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
202: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
203: fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),
204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),

Line 201: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),

197: BEGIN
198: Update ozf_product_allocations
199: SET
200: product_allocation_id = DECODE( p_product_allocation_id, null, product_allocation_id, FND_API.G_MISS_NUM, null, p_product_allocation_id),
201: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
202: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
203: fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),
204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),
205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),

Line 202: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),

198: Update ozf_product_allocations
199: SET
200: product_allocation_id = DECODE( p_product_allocation_id, null, product_allocation_id, FND_API.G_MISS_NUM, null, p_product_allocation_id),
201: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
202: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
203: fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),
204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),
205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),
206: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),

Line 203: fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),

199: SET
200: product_allocation_id = DECODE( p_product_allocation_id, null, product_allocation_id, FND_API.G_MISS_NUM, null, p_product_allocation_id),
201: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
202: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
203: fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),
204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),
205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),
206: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
207: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),

Line 204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),

200: product_allocation_id = DECODE( p_product_allocation_id, null, product_allocation_id, FND_API.G_MISS_NUM, null, p_product_allocation_id),
201: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
202: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
203: fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),
204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),
205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),
206: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
207: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
208: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),

Line 205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),

201: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
202: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
203: fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),
204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),
205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),
206: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
207: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
208: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
209: parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),

Line 206: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),

202: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
203: fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),
204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),
205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),
206: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
207: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
208: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
209: parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),
210: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,

Line 207: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),

203: fund_id = DECODE( p_fund_id, null, fund_id, FND_API.G_MISS_NUM, null, p_fund_id),
204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),
205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),
206: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
207: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
208: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
209: parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),
210: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

Line 208: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),

204: item_type = DECODE( p_item_type, null, item_type, FND_API.g_miss_char, null, p_item_type),
205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),
206: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
207: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
208: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
209: parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),
210: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 209: parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),

205: item_id = DECODE( p_item_id, null, item_id, FND_API.G_MISS_NUM, null, p_item_id),
206: selected_flag = DECODE( p_selected_flag, null, selected_flag, FND_API.g_miss_char, null, p_selected_flag),
207: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
208: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
209: parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),
210: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

207: target = DECODE( p_target, null, target, FND_API.G_MISS_NUM, null, p_target),
208: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
209: parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),
210: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

Line 212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

208: lysp_sales = DECODE( p_lysp_sales, null, lysp_sales, FND_API.G_MISS_NUM, null, p_lysp_sales),
209: parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),
210: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

Line 213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

209: parent_product_allocation_id = DECODE(p_parent_product_allocation_id,null,parent_product_allocation_id, FND_API.G_MISS_NUM, null, p_parent_product_allocation_id),
210: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

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

210: object_version_number = nvl(p_object_version_number, object_version_number) + 1 ,
211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

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

211: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

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

212: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
213: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
214: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
215: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
216: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
217: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
218: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
219: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
220: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

223: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
230: WHERE product_allocation_id = p_product_allocation_id;
231: -- AND object_version_number = p_object_version_number;

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

224: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
230: WHERE product_allocation_id = p_product_allocation_id;
231: -- AND object_version_number = p_object_version_number;
232:

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

225: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
226: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
227: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
228: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
229: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
230: WHERE product_allocation_id = p_product_allocation_id;
231: -- AND object_version_number = p_object_version_number;
232:
233:

Line 235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

231: -- AND object_version_number = p_object_version_number;
232:
233:
234: IF (SQL%NOTFOUND) THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END IF;
237:
238:
239: END Update_Row;

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

261: DELETE FROM ozf_product_allocations
262: WHERE product_allocation_id = p_product_allocation_id
263: AND object_version_number = p_object_version_number;
264: If (SQL%NOTFOUND) then
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: End If;
267: END Delete_Row ;
268:
269:

Line 303: RAISE FND_API.g_exc_error;

299: FETCH c INTO Recinfo;
300: IF (c%NOTFOUND) THEN
301: CLOSE c;
302: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
303: RAISE FND_API.g_exc_error;
304: END IF;
305: CLOSE c;
306: END Lock_Row;
307: