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 1379: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.automatic_flag,p_old_header_adj_rec.automatic_flag) THEN

1375: -- Compare the new and old entity records and
1376: -- check constraints for all the changed attributes.
1377:
1378: IF p_header_adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN NULL;
1379: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.automatic_flag,p_old_header_adj_rec.automatic_flag) THEN
1380:
1381: l_result := AUTOMATIC
1382: (p_operation => l_operation
1383: ,p_record => l_rowtype_rec

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

1391:
1392: END IF;
1393:
1394: IF p_header_adj_rec.discount_id = FND_API.G_MISS_NUM THEN NULL;
1395: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.discount_id,p_old_header_adj_rec.discount_id) THEN
1396:
1397: l_result := DISCOUNT
1398: (p_operation => l_operation
1399: ,p_record => l_rowtype_rec

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

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

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

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

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

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

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

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

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

1488: g_check_all_cols_constraint := 'N';
1489: END IF;
1490:
1491: IF p_header_adj_rec.context = FND_API.G_MISS_CHAR THEN NULL;
1492: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.context,p_old_header_adj_rec.context) THEN
1493:
1494: l_result := CONTEXT
1495: (p_operation => l_operation
1496: ,p_record => l_rowtype_rec

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

1504:
1505: END IF;
1506:
1507: IF p_header_adj_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
1508: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute1,p_old_header_adj_rec.attribute1) THEN
1509:
1510: l_result := ATTRIBUTE1
1511: (p_operation => l_operation
1512: ,p_record => l_rowtype_rec

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

1520:
1521: END IF;
1522:
1523: IF p_header_adj_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
1524: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute10,p_old_header_adj_rec.attribute10) THEN
1525:
1526: l_result := ATTRIBUTE10
1527: (p_operation => l_operation
1528: ,p_record => l_rowtype_rec

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

1536:
1537: END IF;
1538:
1539: IF p_header_adj_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
1540: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute11,p_old_header_adj_rec.attribute11) THEN
1541:
1542: l_result := ATTRIBUTE11
1543: (p_operation => l_operation
1544: ,p_record => l_rowtype_rec

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

1552:
1553: END IF;
1554:
1555: IF p_header_adj_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
1556: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute12,p_old_header_adj_rec.attribute12) THEN
1557:
1558: l_result := ATTRIBUTE12
1559: (p_operation => l_operation
1560: ,p_record => l_rowtype_rec

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

1568:
1569: END IF;
1570:
1571: IF p_header_adj_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1572: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute13,p_old_header_adj_rec.attribute13) THEN
1573:
1574: l_result := ATTRIBUTE13
1575: (p_operation => l_operation
1576: ,p_record => l_rowtype_rec

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

1584:
1585: END IF;
1586:
1587: IF p_header_adj_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1588: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute14,p_old_header_adj_rec.attribute14) THEN
1589:
1590: l_result := ATTRIBUTE14
1591: (p_operation => l_operation
1592: ,p_record => l_rowtype_rec

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

1600:
1601: END IF;
1602:
1603: IF p_header_adj_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1604: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute15,p_old_header_adj_rec.attribute15) THEN
1605:
1606: l_result := ATTRIBUTE15
1607: (p_operation => l_operation
1608: ,p_record => l_rowtype_rec

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

1616:
1617: END IF;
1618:
1619: IF p_header_adj_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1620: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute2,p_old_header_adj_rec.attribute2) THEN
1621:
1622: l_result := ATTRIBUTE2
1623: (p_operation => l_operation
1624: ,p_record => l_rowtype_rec

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

1632:
1633: END IF;
1634:
1635: IF p_header_adj_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1636: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute3,p_old_header_adj_rec.attribute3) THEN
1637:
1638: l_result := ATTRIBUTE3
1639: (p_operation => l_operation
1640: ,p_record => l_rowtype_rec

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

1648:
1649: END IF;
1650:
1651: IF p_header_adj_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1652: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute4,p_old_header_adj_rec.attribute4) THEN
1653:
1654: l_result := ATTRIBUTE4
1655: (p_operation => l_operation
1656: ,p_record => l_rowtype_rec

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

1664:
1665: END IF;
1666:
1667: IF p_header_adj_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1668: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute5,p_old_header_adj_rec.attribute5) THEN
1669:
1670: l_result := ATTRIBUTE5
1671: (p_operation => l_operation
1672: ,p_record => l_rowtype_rec

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

1680:
1681: END IF;
1682:
1683: IF p_header_adj_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1684: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute6,p_old_header_adj_rec.attribute6) THEN
1685:
1686: l_result := ATTRIBUTE6
1687: (p_operation => l_operation
1688: ,p_record => l_rowtype_rec

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

1696:
1697: END IF;
1698:
1699: IF p_header_adj_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1700: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute7,p_old_header_adj_rec.attribute7) THEN
1701:
1702: l_result := ATTRIBUTE7
1703: (p_operation => l_operation
1704: ,p_record => l_rowtype_rec

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

1712:
1713: END IF;
1714:
1715: IF p_header_adj_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1716: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute8,p_old_header_adj_rec.attribute8) THEN
1717:
1718: l_result := ATTRIBUTE8
1719: (p_operation => l_operation
1720: ,p_record => l_rowtype_rec

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

1728:
1729: END IF;
1730:
1731: IF p_header_adj_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1732: ELSIF NOT OE_GLOBALS.EQUAL(p_header_adj_rec.attribute9,p_old_header_adj_rec.attribute9) THEN
1733:
1734: l_result := ATTRIBUTE9
1735: (p_operation => l_operation
1736: ,p_record => l_rowtype_rec