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_HEADER_ADJ_SECURITY dependencies on OE_GLOBALS

Line 106: not OE_GLOBALS.G_HEADER_CREATED THEN

102: -- Audit Trail Enabled
103: IF g_is_caller_defaulting = 'N' THEN
104: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' and
105: nvl(l_transaction_phase_code,'F') = 'F' and
106: not OE_GLOBALS.G_HEADER_CREATED THEN
107: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
108: OPEN IS_ORDER_BOOKED (p_record.header_id);
109: FETCH IS_ORDER_BOOKED INTO l_order_booked_flag;
110: CLOSE IS_ORDER_BOOKED;

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

114: -- set OUT result to NOT CONSTRAINED
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
117: END IF;
118: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
119: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
120: ELSIF x_on_operation_action = 2 THEN
121: -- set OUT result to NOT CONSTRAINED
122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

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

115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
117: END IF;
118: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
119: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
120: ELSIF x_on_operation_action = 2 THEN
121: -- set OUT result to NOT CONSTRAINED
122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
123: IF l_debug_level > 0 THEN

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

118: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
119: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
120: ELSIF x_on_operation_action = 2 THEN
121: -- set OUT result to NOT CONSTRAINED
122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
125: END IF;
126: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

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

122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
125: END IF;
126: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
127: END IF;
128: END IF;
129: END IF;
130: END IF;

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

134: -- set OUT result to NOT CONSTRAINED
135: IF l_debug_level > 0 THEN
136: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
137: END IF;
138: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
139: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
140: ELSIF x_on_operation_action = 2 THEN
141: -- set OUT result to NOT CONSTRAINED
142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

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

135: IF l_debug_level > 0 THEN
136: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
137: END IF;
138: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
139: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
140: ELSIF x_on_operation_action = 2 THEN
141: -- set OUT result to NOT CONSTRAINED
142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
143: IF l_debug_level > 0 THEN

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

138: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
139: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
140: ELSIF x_on_operation_action = 2 THEN
141: -- set OUT result to NOT CONSTRAINED
142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
145: END IF;
146: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

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

142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
145: END IF;
146: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
147: END IF;
148: END IF;
149: END IF;
150: END IF;

Line 1275: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1271:
1272: -- Initializing return status to SUCCESS
1273: x_return_status := FND_API.G_RET_STS_SUCCESS;
1274:
1275: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1276: l_operation := OE_PC_GLOBALS.CREATE_OP;
1277: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1278: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1279: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

Line 1277: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1273: x_return_status := FND_API.G_RET_STS_SUCCESS;
1274:
1275: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1276: l_operation := OE_PC_GLOBALS.CREATE_OP;
1277: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1278: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1279: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1280: l_operation := OE_PC_GLOBALS.DELETE_OP;
1281: ELSE

Line 1279: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

1275: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1276: l_operation := OE_PC_GLOBALS.CREATE_OP;
1277: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1278: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1279: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1280: l_operation := OE_PC_GLOBALS.DELETE_OP;
1281: ELSE
1282: IF l_debug_level > 0 THEN
1283: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 1346: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

1342: -- Initializing out result to NOT CONSTRAINED
1343: x_result := OE_PC_GLOBALS.NO;
1344:
1345: -- Get the operation code to be passed to the security framework API
1346: IF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1347: l_operation := OE_PC_GLOBALS.CREATE_OP;
1348: -- Bug 1755817: if there are no attribute-specific insert
1349: -- constraints, then no need to go further. Entity level
1350: -- security check for CREATE will be called again from

Line 1360: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1356: )
1357: THEN
1358: RETURN;
1359: END IF;
1360: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1361: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1362: ELSE
1363: IF l_debug_level > 0 THEN
1364: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 1380: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.applied_flag,p_old_header_adj_rec.applied_flag) THEN

1376: oe_debug_pub.add( 'p_header_adj_rec.applied_flag: ' || p_header_adj_rec.applied_flag );
1377:
1378: IF p_header_adj_rec.applied_flag = FND_API.G_MISS_CHAR THEN
1379: NULL;
1380: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.applied_flag,p_old_header_adj_rec.applied_flag) THEN
1381: oe_debug_pub.add( 'l_rowtype_rec.automatic_flag: ' || l_rowtype_rec.automatic_flag );
1382: oe_debug_pub.add( 'l_rowtype_rec.applied_flag: ' || l_rowtype_rec.applied_flag );
1383:
1384: IF l_rowtype_rec.automatic_flag='Y' AND l_rowtype_rec.applied_flag='N' THEN

Line 1405: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.automatic_flag,p_old_header_adj_rec.automatic_flag) THEN

1401: -- Compare the new and old entity records and
1402: -- check constraints for all the changed attributes.
1403:
1404: IF p_header_adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN NULL;
1405: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.automatic_flag,p_old_header_adj_rec.automatic_flag) THEN
1406:
1407: l_result := AUTOMATIC
1408: (p_operation => l_operation
1409: ,p_record => l_rowtype_rec

Line 1421: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.discount_id,p_old_header_adj_rec.discount_id) THEN

1417:
1418: END IF;
1419:
1420: IF p_header_adj_rec.discount_id = FND_API.G_MISS_NUM THEN NULL;
1421: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.discount_id,p_old_header_adj_rec.discount_id) THEN
1422:
1423: l_result := DISCOUNT
1424: (p_operation => l_operation
1425: ,p_record => l_rowtype_rec

Line 1437: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.operand,p_old_header_adj_rec.operand) THEN

1433:
1434: END IF;
1435:
1436: IF p_header_adj_rec.operand = FND_API.G_MISS_NUM THEN NULL;
1437: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.operand,p_old_header_adj_rec.operand) THEN
1438:
1439: l_result := OPERAND
1440: (p_operation => l_operation
1441: ,p_record => l_rowtype_rec

Line 1453: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.discount_line_id,p_old_header_adj_rec.discount_line_id) THEN

1449:
1450: END IF;
1451:
1452: IF p_header_adj_rec.discount_line_id = FND_API.G_MISS_NUM THEN NULL;
1453: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.discount_line_id,p_old_header_adj_rec.discount_line_id) THEN
1454:
1455: l_result := DISCOUNT_LINE
1456: (p_operation => l_operation
1457: ,p_record => l_rowtype_rec

Line 1469: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.percent,p_old_header_adj_rec.percent) THEN

1465:
1466: END IF;
1467:
1468: IF p_header_adj_rec.percent = FND_API.G_MISS_NUM THEN NULL;
1469: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.percent,p_old_header_adj_rec.percent) THEN
1470:
1471: l_result := PERCENT
1472: (p_operation => l_operation
1473: ,p_record => l_rowtype_rec

Line 1485: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.request_id,p_old_header_adj_rec.request_id) THEN

1481:
1482: END IF;
1483:
1484: IF p_header_adj_rec.request_id = FND_API.G_MISS_NUM THEN NULL;
1485: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.request_id,p_old_header_adj_rec.request_id) THEN
1486:
1487: l_result := REQUEST
1488: (p_operation => l_operation
1489: ,p_record => l_rowtype_rec

Line 1518: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.context,p_old_header_adj_rec.context) THEN

1514: g_check_all_cols_constraint := 'N';
1515: END IF;
1516:
1517: IF p_header_adj_rec.context = FND_API.G_MISS_CHAR THEN NULL;
1518: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.context,p_old_header_adj_rec.context) THEN
1519:
1520: l_result := CONTEXT
1521: (p_operation => l_operation
1522: ,p_record => l_rowtype_rec

Line 1534: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute1,p_old_header_adj_rec.attribute1) THEN

1530:
1531: END IF;
1532:
1533: IF p_header_adj_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
1534: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute1,p_old_header_adj_rec.attribute1) THEN
1535:
1536: l_result := ATTRIBUTE1
1537: (p_operation => l_operation
1538: ,p_record => l_rowtype_rec

Line 1550: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute10,p_old_header_adj_rec.attribute10) THEN

1546:
1547: END IF;
1548:
1549: IF p_header_adj_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
1550: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute10,p_old_header_adj_rec.attribute10) THEN
1551:
1552: l_result := ATTRIBUTE10
1553: (p_operation => l_operation
1554: ,p_record => l_rowtype_rec

Line 1566: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute11,p_old_header_adj_rec.attribute11) THEN

1562:
1563: END IF;
1564:
1565: IF p_header_adj_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
1566: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute11,p_old_header_adj_rec.attribute11) THEN
1567:
1568: l_result := ATTRIBUTE11
1569: (p_operation => l_operation
1570: ,p_record => l_rowtype_rec

Line 1582: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute12,p_old_header_adj_rec.attribute12) THEN

1578:
1579: END IF;
1580:
1581: IF p_header_adj_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
1582: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute12,p_old_header_adj_rec.attribute12) THEN
1583:
1584: l_result := ATTRIBUTE12
1585: (p_operation => l_operation
1586: ,p_record => l_rowtype_rec

Line 1598: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute13,p_old_header_adj_rec.attribute13) THEN

1594:
1595: END IF;
1596:
1597: IF p_header_adj_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1598: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute13,p_old_header_adj_rec.attribute13) THEN
1599:
1600: l_result := ATTRIBUTE13
1601: (p_operation => l_operation
1602: ,p_record => l_rowtype_rec

Line 1614: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute14,p_old_header_adj_rec.attribute14) THEN

1610:
1611: END IF;
1612:
1613: IF p_header_adj_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1614: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute14,p_old_header_adj_rec.attribute14) THEN
1615:
1616: l_result := ATTRIBUTE14
1617: (p_operation => l_operation
1618: ,p_record => l_rowtype_rec

Line 1630: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute15,p_old_header_adj_rec.attribute15) THEN

1626:
1627: END IF;
1628:
1629: IF p_header_adj_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1630: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute15,p_old_header_adj_rec.attribute15) THEN
1631:
1632: l_result := ATTRIBUTE15
1633: (p_operation => l_operation
1634: ,p_record => l_rowtype_rec

Line 1646: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute2,p_old_header_adj_rec.attribute2) THEN

1642:
1643: END IF;
1644:
1645: IF p_header_adj_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1646: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute2,p_old_header_adj_rec.attribute2) THEN
1647:
1648: l_result := ATTRIBUTE2
1649: (p_operation => l_operation
1650: ,p_record => l_rowtype_rec

Line 1662: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute3,p_old_header_adj_rec.attribute3) THEN

1658:
1659: END IF;
1660:
1661: IF p_header_adj_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1662: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute3,p_old_header_adj_rec.attribute3) THEN
1663:
1664: l_result := ATTRIBUTE3
1665: (p_operation => l_operation
1666: ,p_record => l_rowtype_rec

Line 1678: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute4,p_old_header_adj_rec.attribute4) THEN

1674:
1675: END IF;
1676:
1677: IF p_header_adj_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1678: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute4,p_old_header_adj_rec.attribute4) THEN
1679:
1680: l_result := ATTRIBUTE4
1681: (p_operation => l_operation
1682: ,p_record => l_rowtype_rec

Line 1694: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute5,p_old_header_adj_rec.attribute5) THEN

1690:
1691: END IF;
1692:
1693: IF p_header_adj_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1694: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute5,p_old_header_adj_rec.attribute5) THEN
1695:
1696: l_result := ATTRIBUTE5
1697: (p_operation => l_operation
1698: ,p_record => l_rowtype_rec

Line 1710: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute6,p_old_header_adj_rec.attribute6) THEN

1706:
1707: END IF;
1708:
1709: IF p_header_adj_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1710: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute6,p_old_header_adj_rec.attribute6) THEN
1711:
1712: l_result := ATTRIBUTE6
1713: (p_operation => l_operation
1714: ,p_record => l_rowtype_rec

Line 1726: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute7,p_old_header_adj_rec.attribute7) THEN

1722:
1723: END IF;
1724:
1725: IF p_header_adj_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1726: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute7,p_old_header_adj_rec.attribute7) THEN
1727:
1728: l_result := ATTRIBUTE7
1729: (p_operation => l_operation
1730: ,p_record => l_rowtype_rec

Line 1742: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute8,p_old_header_adj_rec.attribute8) THEN

1738:
1739: END IF;
1740:
1741: IF p_header_adj_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1742: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute8,p_old_header_adj_rec.attribute8) THEN
1743:
1744: l_result := ATTRIBUTE8
1745: (p_operation => l_operation
1746: ,p_record => l_rowtype_rec

Line 1758: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute9,p_old_header_adj_rec.attribute9) THEN

1754:
1755: END IF;
1756:
1757: IF p_header_adj_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1758: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute9,p_old_header_adj_rec.attribute9) THEN
1759:
1760: l_result := ATTRIBUTE9
1761: (p_operation => l_operation
1762: ,p_record => l_rowtype_rec