308:
309: -- Get Who Information
310:
311: l_MODIFIER_LIST_rec.last_update_date := SYSDATE;
312: l_MODIFIER_LIST_rec.last_updated_by := FND_GLOBAL.USER_ID;
313: l_MODIFIER_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
314:
315: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
316:
309: -- Get Who Information
310:
311: l_MODIFIER_LIST_rec.last_update_date := SYSDATE;
312: l_MODIFIER_LIST_rec.last_updated_by := FND_GLOBAL.USER_ID;
313: l_MODIFIER_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
314:
315: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
316:
317: OE_Debug_Pub.add('query'||p_modifier_list_rec.version_no);
319:
320: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
321:
322: l_MODIFIER_LIST_rec.creation_date := SYSDATE;
323: l_MODIFIER_LIST_rec.created_by := FND_GLOBAL.USER_ID;
324:
325: QP_Modifier_List_Util.Insert_Row (l_MODIFIER_LIST_rec);
326:
327: END IF;
722: --dbms_output.put_line('oper = ' || l_MODIFIERS_rec.operation);
723: -- Get Who Information
724:
725: l_MODIFIERS_rec.last_update_date := SYSDATE;
726: l_MODIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
727: l_MODIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
728:
729: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
730:
723: -- Get Who Information
724:
725: l_MODIFIERS_rec.last_update_date := SYSDATE;
726: l_MODIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
727: l_MODIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
728:
729: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
730:
731: QP_Modifiers_Util.Update_Row (l_MODIFIERS_rec);
781:
782: ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
783:
784: l_MODIFIERS_rec.creation_date := SYSDATE;
785: l_MODIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
786:
787: --dbms_output.put_line('just before insert');
788: oe_debug_pub.add('list before = ' || to_char(l_MODIFIERS_rec.list_line_id));
789: oe_debug_pub.add('to before = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
1283:
1284: -- Get Who Information
1285:
1286: l_QUALIFIERS_rec.last_update_date := SYSDATE;
1287: l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
1288: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1289:
1290: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1291:
1284: -- Get Who Information
1285:
1286: l_QUALIFIERS_rec.last_update_date := SYSDATE;
1287: l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
1288: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1289:
1290: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1291:
1292: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
1293:
1294: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1295:
1296: l_QUALIFIERS_rec.creation_date := SYSDATE;
1297: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
1298:
1299: oe_debug_pub.add('util . Insert');
1300: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
1301:
1793:
1794: -- Get Who Information
1795:
1796: l_PRICING_ATTR_rec.last_update_date := SYSDATE;
1797: l_PRICING_ATTR_rec.last_updated_by := FND_GLOBAL.USER_ID;
1798: l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1799:
1800: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1801:
1794: -- Get Who Information
1795:
1796: l_PRICING_ATTR_rec.last_update_date := SYSDATE;
1797: l_PRICING_ATTR_rec.last_updated_by := FND_GLOBAL.USER_ID;
1798: l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1799:
1800: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1801:
1802: QP_Pricing_Attr_Util.Update_Row (l_PRICING_ATTR_rec);
1803:
1804: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1805:
1806: l_PRICING_ATTR_rec.creation_date := SYSDATE;
1807: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;
1808: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp');
1809: QP_Pricing_Attr_Util.Insert_Row (l_PRICING_ATTR_rec);
1810:
1811: END IF;