eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_ADJ_SECURITY dependencies on OE_GLOBALS

Line 95: not OE_GLOBALS.G_HEADER_CREATED THEN

91: -- Audit Trail Enabled
92: IF g_is_caller_defaulting = 'N' THEN
93: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' and
94: nvl(l_transaction_phase_code,'F') = 'F' and
95: not OE_GLOBALS.G_HEADER_CREATED THEN
96: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
97: OPEN IS_ORDER_BOOKED (p_record.header_id);
98: FETCH IS_ORDER_BOOKED INTO l_order_booked_flag;
99: CLOSE IS_ORDER_BOOKED;

Line 107: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

103: -- set OUT result to NOT CONSTRAINED
104: IF l_debug_level > 0 THEN
105: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
106: END IF;
107: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
108: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
109: ELSIF x_on_operation_action = 2 THEN
110: -- set OUT result to NOT CONSTRAINED
111: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

Line 108: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

104: IF l_debug_level > 0 THEN
105: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
106: END IF;
107: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
108: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
109: ELSIF x_on_operation_action = 2 THEN
110: -- set OUT result to NOT CONSTRAINED
111: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
112: IF l_debug_level > 0 THEN

Line 111: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

107: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
108: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
109: ELSIF x_on_operation_action = 2 THEN
110: -- set OUT result to NOT CONSTRAINED
111: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
114: END IF;
115: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 115: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

111: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
114: END IF;
115: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
116: END IF;
117: END IF;
118: END IF;
119: END IF;

Line 127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

123: -- set OUT result to NOT CONSTRAINED
124: IF l_debug_level > 0 THEN
125: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
126: END IF;
127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
129: ELSIF x_on_operation_action = 2 THEN
130: -- set OUT result to NOT CONSTRAINED
131: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

Line 128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

124: IF l_debug_level > 0 THEN
125: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
126: END IF;
127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
129: ELSIF x_on_operation_action = 2 THEN
130: -- set OUT result to NOT CONSTRAINED
131: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
132: IF l_debug_level > 0 THEN

Line 131: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
129: ELSIF x_on_operation_action = 2 THEN
130: -- set OUT result to NOT CONSTRAINED
131: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
134: END IF;
135: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 135: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

131: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
134: END IF;
135: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
136: END IF;
137: END IF;
138: END IF;
139: END IF;

Line 1263: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1259:
1260: -- Initializing return status to SUCCESS
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1264: l_operation := OE_PC_GLOBALS.CREATE_OP;
1265: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1266: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1267: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

Line 1265: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1264: l_operation := OE_PC_GLOBALS.CREATE_OP;
1265: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1266: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1267: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1268: l_operation := OE_PC_GLOBALS.DELETE_OP;
1269: ELSE

Line 1267: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

1263: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1264: l_operation := OE_PC_GLOBALS.CREATE_OP;
1265: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1266: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1267: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1268: l_operation := OE_PC_GLOBALS.DELETE_OP;
1269: ELSE
1270: IF l_debug_level > 0 THEN
1271: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 1335: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1331: -- Initializing out result to NOT CONSTRAINED
1332: x_result := OE_PC_GLOBALS.NO;
1333:
1334: -- Get the operation code to be passed to the security framework API
1335: IF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1336: l_operation := OE_PC_GLOBALS.CREATE_OP;
1337: -- Bug 1755817: if there are no attribute-specific insert
1338: -- constraints, then no need to go further. Entity level
1339: -- security check for CREATE will be called again from

Line 1349: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1345: )
1346: THEN
1347: RETURN;
1348: END IF;
1349: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1350: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1351: ELSE
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 1370: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.applied_flag,p_old_line_adj_rec.applied_flag) THEN

1366: oe_debug_pub.add( 'p_line_adj_rec.applied_flag: ' || p_line_adj_rec.applied_flag );
1367:
1368: IF p_line_adj_rec.applied_flag = FND_API.G_MISS_CHAR THEN
1369: NULL;
1370: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.applied_flag,p_old_line_adj_rec.applied_flag) THEN
1371: oe_debug_pub.add( 'l_rowtype_rec.automatic_flag: ' || l_rowtype_rec.automatic_flag );
1372: oe_debug_pub.add( 'l_rowtype_rec.applied_flag: ' || l_rowtype_rec.applied_flag );
1373:
1374: IF l_rowtype_rec.automatic_flag='Y' AND l_rowtype_rec.applied_flag='N' THEN

Line 1395: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.automatic_flag,p_old_line_adj_rec.automatic_flag) THEN

1391: -- check constraints for all the changed attributes.
1392:
1393:
1394: IF p_line_adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN NULL;
1395: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.automatic_flag,p_old_line_adj_rec.automatic_flag) THEN
1396:
1397: l_result := AUTOMATIC
1398: (p_operation => l_operation
1399: ,p_record => l_rowtype_rec

Line 1411: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_id,p_old_line_adj_rec.discount_id) THEN

1407:
1408: END IF;
1409:
1410: IF p_line_adj_rec.discount_id = FND_API.G_MISS_NUM THEN NULL;
1411: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_id,p_old_line_adj_rec.discount_id) THEN
1412:
1413: l_result := DISCOUNT
1414: (p_operation => l_operation
1415: ,p_record => l_rowtype_rec

Line 1427: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.operand,p_old_line_adj_rec.operand) THEN

1423:
1424: END IF;
1425:
1426: IF p_line_adj_rec.operand = FND_API.G_MISS_NUM THEN NULL;
1427: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.operand,p_old_line_adj_rec.operand) THEN
1428:
1429: l_result := OPERAND
1430: (p_operation => l_operation
1431: ,p_record => l_rowtype_rec

Line 1443: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_line_id,p_old_line_adj_rec.discount_line_id) THEN

1439:
1440: END IF;
1441:
1442: IF p_line_adj_rec.discount_line_id = FND_API.G_MISS_NUM THEN NULL;
1443: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_line_id,p_old_line_adj_rec.discount_line_id) THEN
1444:
1445: l_result := DISCOUNT_LINE
1446: (p_operation => l_operation
1447: ,p_record => l_rowtype_rec

Line 1459: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.percent,p_old_line_adj_rec.percent) THEN

1455:
1456: END IF;
1457:
1458: IF p_line_adj_rec.percent = FND_API.G_MISS_NUM THEN NULL;
1459: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.percent,p_old_line_adj_rec.percent) THEN
1460:
1461: l_result := PERCENT
1462: (p_operation => l_operation
1463: ,p_record => l_rowtype_rec

Line 1475: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.request_id,p_old_line_adj_rec.request_id) THEN

1471:
1472: END IF;
1473:
1474: IF p_line_adj_rec.request_id = FND_API.G_MISS_NUM THEN NULL;
1475: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.request_id,p_old_line_adj_rec.request_id) THEN
1476:
1477: l_result := REQUEST
1478: (p_operation => l_operation
1479: ,p_record => l_rowtype_rec

Line 1507: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.context,p_old_line_adj_rec.context) THEN

1503: g_check_all_cols_constraint := 'N';
1504: END IF;
1505:
1506: IF p_line_adj_rec.context = FND_API.G_MISS_CHAR THEN NULL;
1507: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.context,p_old_line_adj_rec.context) THEN
1508:
1509: l_result := CONTEXT
1510: (p_operation => l_operation
1511: ,p_record => l_rowtype_rec

Line 1523: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute1,p_old_line_adj_rec.attribute1) THEN

1519:
1520: END IF;
1521:
1522: IF p_line_adj_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
1523: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute1,p_old_line_adj_rec.attribute1) THEN
1524:
1525: l_result := ATTRIBUTE1
1526: (p_operation => l_operation
1527: ,p_record => l_rowtype_rec

Line 1539: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute10,p_old_line_adj_rec.attribute10) THEN

1535:
1536: END IF;
1537:
1538: IF p_line_adj_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
1539: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute10,p_old_line_adj_rec.attribute10) THEN
1540:
1541: l_result := ATTRIBUTE10
1542: (p_operation => l_operation
1543: ,p_record => l_rowtype_rec

Line 1555: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute11,p_old_line_adj_rec.attribute11) THEN

1551:
1552: END IF;
1553:
1554: IF p_line_adj_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
1555: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute11,p_old_line_adj_rec.attribute11) THEN
1556:
1557: l_result := ATTRIBUTE11
1558: (p_operation => l_operation
1559: ,p_record => l_rowtype_rec

Line 1571: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute12,p_old_line_adj_rec.attribute12) THEN

1567:
1568: END IF;
1569:
1570: IF p_line_adj_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
1571: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute12,p_old_line_adj_rec.attribute12) THEN
1572:
1573: l_result := ATTRIBUTE12
1574: (p_operation => l_operation
1575: ,p_record => l_rowtype_rec

Line 1587: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute13,p_old_line_adj_rec.attribute13) THEN

1583:
1584: END IF;
1585:
1586: IF p_line_adj_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1587: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute13,p_old_line_adj_rec.attribute13) THEN
1588:
1589: l_result := ATTRIBUTE13
1590: (p_operation => l_operation
1591: ,p_record => l_rowtype_rec

Line 1603: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute14,p_old_line_adj_rec.attribute14) THEN

1599:
1600: END IF;
1601:
1602: IF p_line_adj_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1603: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute14,p_old_line_adj_rec.attribute14) THEN
1604:
1605: l_result := ATTRIBUTE14
1606: (p_operation => l_operation
1607: ,p_record => l_rowtype_rec

Line 1619: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute15,p_old_line_adj_rec.attribute15) THEN

1615:
1616: END IF;
1617:
1618: IF p_line_adj_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1619: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute15,p_old_line_adj_rec.attribute15) THEN
1620:
1621: l_result := ATTRIBUTE15
1622: (p_operation => l_operation
1623: ,p_record => l_rowtype_rec

Line 1635: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute2,p_old_line_adj_rec.attribute2) THEN

1631:
1632: END IF;
1633:
1634: IF p_line_adj_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1635: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute2,p_old_line_adj_rec.attribute2) THEN
1636:
1637: l_result := ATTRIBUTE2
1638: (p_operation => l_operation
1639: ,p_record => l_rowtype_rec

Line 1651: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute3,p_old_line_adj_rec.attribute3) THEN

1647:
1648: END IF;
1649:
1650: IF p_line_adj_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1651: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute3,p_old_line_adj_rec.attribute3) THEN
1652:
1653: l_result := ATTRIBUTE3
1654: (p_operation => l_operation
1655: ,p_record => l_rowtype_rec

Line 1667: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute4,p_old_line_adj_rec.attribute4) THEN

1663:
1664: END IF;
1665:
1666: IF p_line_adj_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1667: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute4,p_old_line_adj_rec.attribute4) THEN
1668:
1669: l_result := ATTRIBUTE4
1670: (p_operation => l_operation
1671: ,p_record => l_rowtype_rec

Line 1683: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute5,p_old_line_adj_rec.attribute5) THEN

1679:
1680: END IF;
1681:
1682: IF p_line_adj_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1683: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute5,p_old_line_adj_rec.attribute5) THEN
1684:
1685: l_result := ATTRIBUTE5
1686: (p_operation => l_operation
1687: ,p_record => l_rowtype_rec

Line 1699: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute6,p_old_line_adj_rec.attribute6) THEN

1695:
1696: END IF;
1697:
1698: IF p_line_adj_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1699: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute6,p_old_line_adj_rec.attribute6) THEN
1700:
1701: l_result := ATTRIBUTE6
1702: (p_operation => l_operation
1703: ,p_record => l_rowtype_rec

Line 1715: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute7,p_old_line_adj_rec.attribute7) THEN

1711:
1712: END IF;
1713:
1714: IF p_line_adj_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1715: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute7,p_old_line_adj_rec.attribute7) THEN
1716:
1717: l_result := ATTRIBUTE7
1718: (p_operation => l_operation
1719: ,p_record => l_rowtype_rec

Line 1731: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute8,p_old_line_adj_rec.attribute8) THEN

1727:
1728: END IF;
1729:
1730: IF p_line_adj_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1731: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute8,p_old_line_adj_rec.attribute8) THEN
1732:
1733: l_result := ATTRIBUTE8
1734: (p_operation => l_operation
1735: ,p_record => l_rowtype_rec

Line 1747: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute9,p_old_line_adj_rec.attribute9) THEN

1743:
1744: END IF;
1745:
1746: IF p_line_adj_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1747: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute9,p_old_line_adj_rec.attribute9) THEN
1748:
1749: l_result := ATTRIBUTE9
1750: (p_operation => l_operation
1751: ,p_record => l_rowtype_rec