DBA Data[Home] [Help]

APPS.QP_MODIFIERS_PVT dependencies on FND_GLOBAL

Line 309: l_MODIFIER_LIST_rec.last_updated_by := FND_GLOBAL.USER_ID;

305:
306: -- Get Who Information
307:
308: l_MODIFIER_LIST_rec.last_update_date := SYSDATE;
309: l_MODIFIER_LIST_rec.last_updated_by := FND_GLOBAL.USER_ID;
310: l_MODIFIER_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
311:
312: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
313:

Line 310: l_MODIFIER_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

306: -- Get Who Information
307:
308: l_MODIFIER_LIST_rec.last_update_date := SYSDATE;
309: l_MODIFIER_LIST_rec.last_updated_by := FND_GLOBAL.USER_ID;
310: l_MODIFIER_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
311:
312: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
313:
314: OE_Debug_Pub.add('query'||p_modifier_list_rec.version_no);

Line 320: l_MODIFIER_LIST_rec.created_by := FND_GLOBAL.USER_ID;

316:
317: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
318:
319: l_MODIFIER_LIST_rec.creation_date := SYSDATE;
320: l_MODIFIER_LIST_rec.created_by := FND_GLOBAL.USER_ID;
321:
322: QP_Modifier_List_Util.Insert_Row (l_MODIFIER_LIST_rec);
323:
324: END IF;

Line 723: l_MODIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;

719: --dbms_output.put_line('oper = ' || l_MODIFIERS_rec.operation);
720: -- Get Who Information
721:
722: l_MODIFIERS_rec.last_update_date := SYSDATE;
723: l_MODIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
724: l_MODIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
725:
726: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
727:

Line 724: l_MODIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

720: -- Get Who Information
721:
722: l_MODIFIERS_rec.last_update_date := SYSDATE;
723: l_MODIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
724: l_MODIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
725:
726: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
727:
728: QP_Modifiers_Util.Update_Row (l_MODIFIERS_rec);

Line 782: l_MODIFIERS_rec.created_by := FND_GLOBAL.USER_ID;

778:
779: ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
780:
781: l_MODIFIERS_rec.creation_date := SYSDATE;
782: l_MODIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
783:
784: --dbms_output.put_line('just before insert');
785: oe_debug_pub.add('list before = ' || to_char(l_MODIFIERS_rec.list_line_id));
786: oe_debug_pub.add('to before = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));

Line 1284: l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;

1280:
1281: -- Get Who Information
1282:
1283: l_QUALIFIERS_rec.last_update_date := SYSDATE;
1284: l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
1285: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1286:
1287: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1288:

Line 1285: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1281: -- Get Who Information
1282:
1283: l_QUALIFIERS_rec.last_update_date := SYSDATE;
1284: l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
1285: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1286:
1287: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1288:
1289: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);

Line 1294: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;

1290:
1291: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1292:
1293: l_QUALIFIERS_rec.creation_date := SYSDATE;
1294: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
1295:
1296: oe_debug_pub.add('util . Insert');
1297: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
1298:

Line 1794: l_PRICING_ATTR_rec.last_updated_by := FND_GLOBAL.USER_ID;

1790:
1791: -- Get Who Information
1792:
1793: l_PRICING_ATTR_rec.last_update_date := SYSDATE;
1794: l_PRICING_ATTR_rec.last_updated_by := FND_GLOBAL.USER_ID;
1795: l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1796:
1797: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1798:

Line 1795: l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1791: -- Get Who Information
1792:
1793: l_PRICING_ATTR_rec.last_update_date := SYSDATE;
1794: l_PRICING_ATTR_rec.last_updated_by := FND_GLOBAL.USER_ID;
1795: l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1796:
1797: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1798:
1799: QP_Pricing_Attr_Util.Update_Row (l_PRICING_ATTR_rec);

Line 1804: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;

1800:
1801: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1802:
1803: l_PRICING_ATTR_rec.creation_date := SYSDATE;
1804: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;
1805: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp');
1806: QP_Pricing_Attr_Util.Insert_Row (l_PRICING_ATTR_rec);
1807:
1808: END IF;