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.automatic_flag,p_old_line_adj_rec.automatic_flag) THEN

1366: -- check constraints for all the changed attributes.
1367:
1368:
1369: IF p_line_adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN NULL;
1370: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.automatic_flag,p_old_line_adj_rec.automatic_flag) THEN
1371:
1372: l_result := AUTOMATIC
1373: (p_operation => l_operation
1374: ,p_record => l_rowtype_rec

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

1382:
1383: END IF;
1384:
1385: IF p_line_adj_rec.discount_id = FND_API.G_MISS_NUM THEN NULL;
1386: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_id,p_old_line_adj_rec.discount_id) THEN
1387:
1388: l_result := DISCOUNT
1389: (p_operation => l_operation
1390: ,p_record => l_rowtype_rec

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

1398:
1399: END IF;
1400:
1401: IF p_line_adj_rec.operand = FND_API.G_MISS_NUM THEN NULL;
1402: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.operand,p_old_line_adj_rec.operand) THEN
1403:
1404: l_result := OPERAND
1405: (p_operation => l_operation
1406: ,p_record => l_rowtype_rec

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

1414:
1415: END IF;
1416:
1417: IF p_line_adj_rec.discount_line_id = FND_API.G_MISS_NUM THEN NULL;
1418: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.discount_line_id,p_old_line_adj_rec.discount_line_id) THEN
1419:
1420: l_result := DISCOUNT_LINE
1421: (p_operation => l_operation
1422: ,p_record => l_rowtype_rec

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

1430:
1431: END IF;
1432:
1433: IF p_line_adj_rec.percent = FND_API.G_MISS_NUM THEN NULL;
1434: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.percent,p_old_line_adj_rec.percent) THEN
1435:
1436: l_result := PERCENT
1437: (p_operation => l_operation
1438: ,p_record => l_rowtype_rec

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

1446:
1447: END IF;
1448:
1449: IF p_line_adj_rec.request_id = FND_API.G_MISS_NUM THEN NULL;
1450: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.request_id,p_old_line_adj_rec.request_id) THEN
1451:
1452: l_result := REQUEST
1453: (p_operation => l_operation
1454: ,p_record => l_rowtype_rec

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

1478: g_check_all_cols_constraint := 'N';
1479: END IF;
1480:
1481: IF p_line_adj_rec.context = FND_API.G_MISS_CHAR THEN NULL;
1482: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.context,p_old_line_adj_rec.context) THEN
1483:
1484: l_result := CONTEXT
1485: (p_operation => l_operation
1486: ,p_record => l_rowtype_rec

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

1494:
1495: END IF;
1496:
1497: IF p_line_adj_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
1498: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute1,p_old_line_adj_rec.attribute1) THEN
1499:
1500: l_result := ATTRIBUTE1
1501: (p_operation => l_operation
1502: ,p_record => l_rowtype_rec

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

1510:
1511: END IF;
1512:
1513: IF p_line_adj_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
1514: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute10,p_old_line_adj_rec.attribute10) THEN
1515:
1516: l_result := ATTRIBUTE10
1517: (p_operation => l_operation
1518: ,p_record => l_rowtype_rec

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

1526:
1527: END IF;
1528:
1529: IF p_line_adj_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
1530: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute11,p_old_line_adj_rec.attribute11) THEN
1531:
1532: l_result := ATTRIBUTE11
1533: (p_operation => l_operation
1534: ,p_record => l_rowtype_rec

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

1542:
1543: END IF;
1544:
1545: IF p_line_adj_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
1546: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute12,p_old_line_adj_rec.attribute12) THEN
1547:
1548: l_result := ATTRIBUTE12
1549: (p_operation => l_operation
1550: ,p_record => l_rowtype_rec

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

1558:
1559: END IF;
1560:
1561: IF p_line_adj_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1562: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute13,p_old_line_adj_rec.attribute13) THEN
1563:
1564: l_result := ATTRIBUTE13
1565: (p_operation => l_operation
1566: ,p_record => l_rowtype_rec

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

1574:
1575: END IF;
1576:
1577: IF p_line_adj_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1578: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute14,p_old_line_adj_rec.attribute14) THEN
1579:
1580: l_result := ATTRIBUTE14
1581: (p_operation => l_operation
1582: ,p_record => l_rowtype_rec

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

1590:
1591: END IF;
1592:
1593: IF p_line_adj_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1594: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute15,p_old_line_adj_rec.attribute15) THEN
1595:
1596: l_result := ATTRIBUTE15
1597: (p_operation => l_operation
1598: ,p_record => l_rowtype_rec

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

1606:
1607: END IF;
1608:
1609: IF p_line_adj_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1610: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute2,p_old_line_adj_rec.attribute2) THEN
1611:
1612: l_result := ATTRIBUTE2
1613: (p_operation => l_operation
1614: ,p_record => l_rowtype_rec

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

1622:
1623: END IF;
1624:
1625: IF p_line_adj_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1626: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute3,p_old_line_adj_rec.attribute3) THEN
1627:
1628: l_result := ATTRIBUTE3
1629: (p_operation => l_operation
1630: ,p_record => l_rowtype_rec

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

1638:
1639: END IF;
1640:
1641: IF p_line_adj_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1642: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute4,p_old_line_adj_rec.attribute4) THEN
1643:
1644: l_result := ATTRIBUTE4
1645: (p_operation => l_operation
1646: ,p_record => l_rowtype_rec

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

1654:
1655: END IF;
1656:
1657: IF p_line_adj_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1658: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute5,p_old_line_adj_rec.attribute5) THEN
1659:
1660: l_result := ATTRIBUTE5
1661: (p_operation => l_operation
1662: ,p_record => l_rowtype_rec

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

1670:
1671: END IF;
1672:
1673: IF p_line_adj_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1674: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute6,p_old_line_adj_rec.attribute6) THEN
1675:
1676: l_result := ATTRIBUTE6
1677: (p_operation => l_operation
1678: ,p_record => l_rowtype_rec

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

1686:
1687: END IF;
1688:
1689: IF p_line_adj_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1690: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute7,p_old_line_adj_rec.attribute7) THEN
1691:
1692: l_result := ATTRIBUTE7
1693: (p_operation => l_operation
1694: ,p_record => l_rowtype_rec

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

1702:
1703: END IF;
1704:
1705: IF p_line_adj_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1706: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute8,p_old_line_adj_rec.attribute8) THEN
1707:
1708: l_result := ATTRIBUTE8
1709: (p_operation => l_operation
1710: ,p_record => l_rowtype_rec

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

1718:
1719: END IF;
1720:
1721: IF p_line_adj_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1722: ELSIF NOT OE_GLOBALS.EQUAL(p_line_adj_rec.attribute9,p_old_line_adj_rec.attribute9) THEN
1723:
1724: l_result := ATTRIBUTE9
1725: (p_operation => l_operation
1726: ,p_record => l_rowtype_rec