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_OE_TOTALS_SUMMARY dependencies on OE_OE_TOTALS_SUMMARY

Line 1: PACKAGE BODY oe_oe_totals_summary AS

1: PACKAGE BODY oe_oe_totals_summary AS
2: /* $Header: OEXVTOTB.pls 120.14.12020000.3 2013/02/05 05:51:01 sujithku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_TOTALS_SUMMARY';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_TOTALS_SUMMARY';

1: PACKAGE BODY oe_oe_totals_summary AS
2: /* $Header: OEXVTOTB.pls 120.14.12020000.3 2013/02/05 05:51:01 sujithku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_TOTALS_SUMMARY';
5:
6: --rc pviprana Global table to hold the recurring amounts of an order level modifier grouped by periodicity
7: G_RECURRING_AMOUNTS_TBL recurring_amounts_tbl_type;
8:

Line 500: OE_OE_TOTALS_SUMMARY.Global_Totals

496: --
497: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
498: --
499: BEGIN
500: OE_OE_TOTALS_SUMMARY.Global_Totals
501: (
502: p_header_id
503: );
504: p_subtotal:=OE_OE_TOTALS_SUMMARY.Order_Subtotals

Line 504: p_subtotal:=OE_OE_TOTALS_SUMMARY.Order_Subtotals

500: OE_OE_TOTALS_SUMMARY.Global_Totals
501: (
502: p_header_id
503: );
504: p_subtotal:=OE_OE_TOTALS_SUMMARY.Order_Subtotals
505: (
506: p_header_id
507: );
508:

Line 509: p_discount:=OE_OE_TOTALS_SUMMARY.Price_Adjustments

505: (
506: p_header_id
507: );
508:
509: p_discount:=OE_OE_TOTALS_SUMMARY.Price_Adjustments
510: (
511: p_header_id
512: );
513: p_charges:=OE_OE_TOTALS_SUMMARY.Charges

Line 513: p_charges:=OE_OE_TOTALS_SUMMARY.Charges

509: p_discount:=OE_OE_TOTALS_SUMMARY.Price_Adjustments
510: (
511: p_header_id
512: );
513: p_charges:=OE_OE_TOTALS_SUMMARY.Charges
514: (
515: p_header_id
516: );
517: p_tax:=OE_OE_TOTALS_SUMMARY.Taxes

Line 517: p_tax:=OE_OE_TOTALS_SUMMARY.Taxes

513: p_charges:=OE_OE_TOTALS_SUMMARY.Charges
514: (
515: p_header_id
516: );
517: p_tax:=OE_OE_TOTALS_SUMMARY.Taxes
518: (
519: p_header_id
520: );
521:

Line 545: OE_OE_TOTALS_SUMMARY.Global_Totals(p_header_id);

541: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
542: --
543: BEGIN
544:
545: OE_OE_TOTALS_SUMMARY.Global_Totals(p_header_id);
546:
547: l_subtotal:=OE_OE_TOTALS_SUMMARY.Order_Subtotals(p_header_id);
548:
549: -- performance bug 4060810: disabling this calculation as it is not used

Line 547: l_subtotal:=OE_OE_TOTALS_SUMMARY.Order_Subtotals(p_header_id);

543: BEGIN
544:
545: OE_OE_TOTALS_SUMMARY.Global_Totals(p_header_id);
546:
547: l_subtotal:=OE_OE_TOTALS_SUMMARY.Order_Subtotals(p_header_id);
548:
549: -- performance bug 4060810: disabling this calculation as it is not used
550: -- l_discount:=OE_OE_TOTALS_SUMMARY.Price_Adjustments(p_header_id);
551: l_charges:=OE_OE_TOTALS_SUMMARY.Charges(p_header_id);

Line 550: -- l_discount:=OE_OE_TOTALS_SUMMARY.Price_Adjustments(p_header_id);

546:
547: l_subtotal:=OE_OE_TOTALS_SUMMARY.Order_Subtotals(p_header_id);
548:
549: -- performance bug 4060810: disabling this calculation as it is not used
550: -- l_discount:=OE_OE_TOTALS_SUMMARY.Price_Adjustments(p_header_id);
551: l_charges:=OE_OE_TOTALS_SUMMARY.Charges(p_header_id);
552: l_tax:=OE_OE_TOTALS_SUMMARY.Taxes(p_header_id);
553:
554: RETURN (l_subtotal + l_charges + l_tax);

Line 551: l_charges:=OE_OE_TOTALS_SUMMARY.Charges(p_header_id);

547: l_subtotal:=OE_OE_TOTALS_SUMMARY.Order_Subtotals(p_header_id);
548:
549: -- performance bug 4060810: disabling this calculation as it is not used
550: -- l_discount:=OE_OE_TOTALS_SUMMARY.Price_Adjustments(p_header_id);
551: l_charges:=OE_OE_TOTALS_SUMMARY.Charges(p_header_id);
552: l_tax:=OE_OE_TOTALS_SUMMARY.Taxes(p_header_id);
553:
554: RETURN (l_subtotal + l_charges + l_tax);
555:

Line 552: l_tax:=OE_OE_TOTALS_SUMMARY.Taxes(p_header_id);

548:
549: -- performance bug 4060810: disabling this calculation as it is not used
550: -- l_discount:=OE_OE_TOTALS_SUMMARY.Price_Adjustments(p_header_id);
551: l_charges:=OE_OE_TOTALS_SUMMARY.Charges(p_header_id);
552: l_tax:=OE_OE_TOTALS_SUMMARY.Taxes(p_header_id);
553:
554: RETURN (l_subtotal + l_charges + l_tax);
555:
556: EXCEPTION

Line 848: oe_debug_pub.add( 'ENTERING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;

844: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
845: --
846: BEGIN
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( 'ENTERING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;
849: END IF;
850:
851: -- combining 2 SQLs into one for performance
852: SELECT SUM(DECODE(line_category_code, 'RETURN', 0, nvl(Ordered_Quantity,0)*(unit_list_price))),

Line 872: oe_debug_pub.add( 'LEAVING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;

868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add( ' ORDER AMOUNT:='||L_ORDER_AMOUNT ) ;
870: END IF;
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add( 'LEAVING OE_OE_TOTALS_SUMMARY.GET_ORDER_AMOUNT' ) ;
873: END IF;
874:
875: return l_order_amount;
876: EXCEPTION

Line 1126: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);

1122: --
1123: BEGIN
1124:
1125: IF l_debug_level > 0 THEN
1126: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1127: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1128: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1129: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1130: END IF;

Line 1132: OE_OE_TOTALS_SUMMARY.Global_Rec_Totals(p_header_id => p_header_id,

1128: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1129: OE_DEBUG_PUB.ADD('p_charge_periodicity_code :'||p_charge_periodicity_code,1);
1130: END IF;
1131:
1132: OE_OE_TOTALS_SUMMARY.Global_Rec_Totals(p_header_id => p_header_id,
1133: p_charge_periodicity_code => p_charge_periodicity_code);
1134:
1135: x_tax := g_rec_tax_value;
1136: x_subtotal := g_rec_total_extended_price;

Line 1138: x_discount:=OE_OE_TOTALS_SUMMARY.Rec_Price_Adjustments

1134:
1135: x_tax := g_rec_tax_value;
1136: x_subtotal := g_rec_total_extended_price;
1137:
1138: x_discount:=OE_OE_TOTALS_SUMMARY.Rec_Price_Adjustments
1139: (
1140: p_header_id,
1141: p_charge_periodicity_code
1142: );

Line 1144: x_charges:=OE_OE_TOTALS_SUMMARY.Rec_Charges

1140: p_header_id,
1141: p_charge_periodicity_code
1142: );
1143:
1144: x_charges:=OE_OE_TOTALS_SUMMARY.Rec_Charges
1145: (
1146: p_header_id,
1147: p_charge_periodicity_code
1148: );

Line 1153: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);

1149:
1150: x_total := x_tax + x_subtotal + x_charges;
1151:
1152: IF l_debug_level > 0 THEN
1153: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.REC_ORDER_TOTALS',1);
1154: END IF;
1155:
1156: END REC_ORDER_TOTALS;
1157:

Line 1162: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)

1158:
1159: PROCEDURE GET_RECURRING_TOTALS
1160: (
1161: p_header_id IN NUMBER,
1162: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)
1163: IS
1164: CURSOR C_rec_charge(g_header_id IN NUMBER) IS
1165: select distinct charge_periodicity_code
1166: from oe_order_lines_all

Line 1181: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);

1177:
1178: BEGIN
1179:
1180: IF l_debug_level > 0 THEN
1181: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1182: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1183: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1184: END IF;
1185:

Line 1200: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

1196: x_rec_charges_tbl(i).charge_periodicity_code := l_code;
1197: x_rec_charges_tbl(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);
1198:
1199:
1200: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1201: (
1202: p_header_id => p_header_id,
1203: p_charge_periodicity_code => l_code
1204: );

Line 1211: x_charges := OE_OE_TOTALS_SUMMARY.ReC_charges(p_header_id => p_header_id,

1207:
1208: x_rec_charges_tbl(i).rec_tax := x_tax;
1209: x_rec_charges_tbl(i).rec_subtotal := x_subtotal;
1210:
1211: x_charges := OE_OE_TOTALS_SUMMARY.ReC_charges(p_header_id => p_header_id,
1212: p_charge_periodicity_code => l_code);
1213: x_rec_charges_tbl(i).rec_charges := x_charges;
1214: x_rec_charges_tbl(i).rec_total := x_subtotal + x_tax + x_charges;
1215:

Line 1228: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');

1224: END LOOP;
1225: CLOSE C_rec_charge;
1226:
1227: IF l_debug_level > 0 THEN
1228: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');
1229: END IF;
1230:
1231: EXCEPTION
1232:

Line 1243: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)

1239:
1240: PROCEDURE GET_UI_RECURRING_TOTALS
1241: (
1242: p_header_id IN NUMBER,
1243: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type)
1244: IS
1245: CURSOR C_rec_charge(g_header_id IN NUMBER) IS
1246: select distinct nvl(charge_periodicity_code,'ONE')
1247: from oe_order_lines_all

Line 1262: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);

1258:
1259: BEGIN
1260:
1261: IF l_debug_level > 0 THEN
1262: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS',1);
1263: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1264: OE_DEBUG_PUB.ADD('p_header_id :'||p_header_id,1);
1265: END IF;
1266:

Line 1282: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

1278: IF (l_code <> 'ONE') THEN
1279: x_rec_charges_tbl(i).charge_periodicity_meaning := OE_ID_TO_VALUE.Charge_Periodicity(l_code);
1280: END IF;
1281:
1282: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1283: (
1284: p_header_id => p_header_id,
1285: p_charge_periodicity_code => l_code
1286: );

Line 1293: x_charges := OE_OE_TOTALS_SUMMARY.ReC_charges(p_header_id => p_header_id,

1289:
1290: x_rec_charges_tbl(i).rec_tax := x_tax;
1291: x_rec_charges_tbl(i).rec_subtotal := x_subtotal;
1292:
1293: x_charges := OE_OE_TOTALS_SUMMARY.ReC_charges(p_header_id => p_header_id,
1294: p_charge_periodicity_code => l_code);
1295: x_rec_charges_tbl(i).rec_charges := x_charges;
1296: x_rec_charges_tbl(i).rec_total := nvl(x_subtotal,0) + nvl(x_tax,0) + nvl(x_charges,0);
1297:

Line 1310: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');

1306: END LOOP;
1307: CLOSE C_rec_charge;
1308:
1309: IF l_debug_level > 0 THEN
1310: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_RECURRING_TOTALS');
1311: END IF;
1312:
1313: EXCEPTION
1314:

Line 1327: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type

1323: (
1324: p_header_id IN NUMBER,
1325: p_line_id IN NUMBER,
1326: p_line_number IN NUMBER,
1327: x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type
1328: )
1329: IS
1330:
1331: CURSOR C_rec_charge(g_header_id IN NUMBER,p_line_number IN NUMBER) IS

Line 1372: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);

1368:
1369: BEGIN
1370:
1371: IF l_debug_level > 0 THEN
1372: OE_DEBUG_PUB.ADD('ENTERING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1373: OE_DEBUG_PUB.ADD('INPUTS TO THE API',1);
1374: OE_DEBUG_PUB.ADD('p_heder_id :'||p_header_id,1);
1375: OE_DEBUG_PUB.ADD('p_line_id_ :'||p_line_id,1);
1376: OE_DEBUG_PUB.ADD('p_line_number :'||p_line_number,1);

Line 1472: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);

1468: END LOOP;
1469: CLOSE C_rec_charge;
1470:
1471: IF l_debug_level > 0 THEN
1472: OE_DEBUG_PUB.ADD('EXITING OE_OE_TOTALS_SUMMARY.GET_MODEL_RECURRING_TOTALS',1);
1473: END IF;
1474:
1475: END Get_Model_Recurring_Totals;
1476:

Line 1500: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');

1496:
1497: BEGIN
1498:
1499: IF l_debug_level > 0 THEN
1500: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');
1501: END IF;
1502: IF p_price_adjustment_id IS NULL THEN
1503: RETURN;
1504: ELSE

Line 1553: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');

1549: END LOOP;
1550: CLOSE c_charge_periodicity;
1551:
1552: IF l_debug_level > 0 THEN
1553: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.SET_ADJ_RECURRING_AMOUNTS');
1554: END IF;
1555:
1556: END SET_ADJ_RECURRING_AMOUNTS;
1557:

Line 1564: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');

1560: IS
1561: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1562: BEGIN
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTERING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');
1565: END IF;
1566:
1567: x_recurring_amounts_tbl := G_RECURRING_AMOUNTS_TBL;
1568:

Line 1570: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');

1566:
1567: x_recurring_amounts_tbl := G_RECURRING_AMOUNTS_TBL;
1568:
1569: IF l_debug_level > 0 THEN
1570: oe_debug_pub.add('EXITING OE_OE_TOTALS_SUMMARY.GET_ADJ_RECURRING_AMOUNTS');
1571: END IF;
1572: END;
1573:
1574: --rc pviprana end

Line 1593: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

1589: oe_debug_pub.add('Header_id = '||p_header_id );
1590: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1591: END IF;
1592:
1593: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1594: (
1595: p_header_id => p_header_id,
1596: p_charge_periodicity_code => p_charge_periodicity_code
1597: );

Line 1633: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

1629: oe_debug_pub.add('Header_id = '||p_header_id );
1630: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1631: END IF;
1632:
1633: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1634: (
1635: p_header_id => p_header_id,
1636: p_charge_periodicity_code => p_charge_periodicity_code
1637: );

Line 1677: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS

1673: oe_debug_pub.add('Header_id = '||p_header_id );
1674: oe_debug_pub.add('Charge periodicity code = '||p_charge_periodicity_code );
1675: END IF;
1676:
1677: OE_OE_TOTALS_SUMMARY.GLOBAL_Rec_TOTALS
1678: (
1679: p_header_id => p_header_id,
1680: p_charge_periodicity_code => p_charge_periodicity_code
1681: );

Line 1685: l_charges:= OE_OE_TOTALS_SUMMARY.ReC_charges(p_header_id => p_header_id,

1681: );
1682:
1683: l_taxes:= g_rec_tax_value;
1684: l_subtotals := G_REC_TOTAL_EXTENDED_PRICE;
1685: l_charges:= OE_OE_TOTALS_SUMMARY.ReC_charges(p_header_id => p_header_id,
1686: p_charge_periodicity_code => p_charge_periodicity_code );
1687:
1688: RETURN(l_taxes + l_subtotals + l_charges);
1689:

Line 1706: END OE_OE_TOTALS_SUMMARY;

1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703:
1704: END PRN_REC_TOTALS;
1705:
1706: END OE_OE_TOTALS_SUMMARY;