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_CREDIT_EXPOSURE_PVT dependencies on OE_CREDIT_EXPOSURE_PVT

Line 1: PACKAGE BODY OE_CREDIT_EXPOSURE_PVT AS

1: PACKAGE BODY OE_CREDIT_EXPOSURE_PVT AS
2: -- $Header: OEXVCRXB.pls 120.9.12010000.3 2009/01/08 13:05:36 msundara ship $
3:
4: --+=======================================================================+
5: --| Copyright (c) 1998 Oracle Corporation |

Line 13: --| Body of OE_CREDIT_EXPOSURE_PVT |

9: --| FILENAME |
10: --| OEXVCRXB.pls |
11: --| |
12: --| DESCRIPTION |
13: --| Body of OE_CREDIT_EXPOSURE_PVT |
14: --| |
15: --| HISTORY |
16: --| 06/05/2001 Rene Schaub Created |
17: --| 02/04/2002 Rajesh Krishnan ontdev => 115.10 2001/09/01 00:53:53 |

Line 45: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CREDIT_EXPOSURE_PVT';

41:
42: --===================
43: -- CONSTANTS
44: --===================
45: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CREDIT_EXPOSURE_PVT';
46: G_debug_flag VARCHAR2(1) :=
47: NVL(oe_credit_check_util.check_debug_flag , 'N' ) ;
48: --===================
49: -- GLOBAL VARIABLES

Line 1373: , x_binary_tbl OUT NOCOPY oe_credit_exposure_pvt.Binary_tbl_type

1369: PROCEDURE calculate_buckets
1370: ( p_date IN NUMBER
1371: , p_interval IN NUMBER
1372: , x_main_bucket OUT NOCOPY NUMBER
1373: , x_binary_tbl OUT NOCOPY oe_credit_exposure_pvt.Binary_tbl_type
1374: )
1375: IS
1376: l_date NUMBER;
1377: l_level NUMBER;

Line 1521: ( p_binary_tbl IN oe_credit_exposure_pvt.Binary_tbl_type

1517: -- as the exposure balance is governed by the
1518: -- balance types used
1519: --------------------------------------------------------------
1520: FUNCTION retrieve_exposure
1521: ( p_binary_tbl IN oe_credit_exposure_pvt.Binary_tbl_type
1522: , p_site_use_id IN NUMBER
1523: , p_customer_id IN NUMBER
1524: , p_party_id IN NUMBER
1525: , p_org_id IN NUMBER

Line 5454: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

5450: , order_party_id
5451: , m.order_org_id
5452: , m.order_transactional_curr_code
5453: , -2
5454: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
5455: , sysdate
5456: , l_created_by
5457: , SYSDATE
5458: , l_last_updated_by

Line 5518: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

5514: , order_party_id
5515: , m.order_org_id
5516: , m.order_transactional_curr_code
5517: , -2
5518: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
5519: , sysdate
5520: , l_created_by
5521: , sysdate
5522: , l_last_updated_by

Line 5734: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

5730: , line_party_id
5731: , m.order_org_id
5732: , m.order_transactional_curr_code
5733: , -2
5734: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
5735: , sysdate
5736: , l_created_by
5737: , sysdate
5738: , l_last_updated_by

Line 5798: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

5794: , line_party_id
5795: , m.order_org_id
5796: , m.order_transactional_curr_code
5797: , -2
5798: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
5799: , sysdate
5800: , l_created_by
5801: , sysdate
5802: , l_last_updated_by

Line 5952: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

5948: , line_party_id
5949: , m.order_org_id
5950: , m.order_transactional_curr_code
5951: , -2
5952: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
5953: , sysdate
5954: , l_created_by
5955: , sysdate
5956: , l_last_updated_by

Line 6117: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6113: , order_party_id
6114: , m.order_org_id
6115: , m.order_transactional_curr_code
6116: , -2
6117: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6118: , sysdate
6119: , l_created_by
6120: , sysdate
6121: , l_last_updated_by

Line 6360: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6356: , ca.party_id
6357: , h.org_id
6358: , h.transactional_curr_code
6359: , -2
6360: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6361: , sysdate
6362: , l_created_by
6363: , sysdate
6364: , l_last_updated_by

Line 6418: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6414: , ca.party_id
6415: , h.org_id
6416: , h.transactional_curr_code
6417: , -2
6418: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6419: , sysdate
6420: , l_created_by
6421: , sysdate
6422: , l_last_updated_by

Line 6699: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6695: , ca.party_id
6696: , h.org_id
6697: , h.transactional_curr_code
6698: , -2
6699: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6700: , sysdate
6701: , l_created_by
6702: , sysdate
6703: , l_last_updated_by

Line 6803: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6799: , order_party_id
6800: , m.order_org_id
6801: , m.order_transactional_curr_code
6802: , -2
6803: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6804: , sysdate
6805: , l_created_by
6806: , sysdate
6807: , l_last_updated_by

Line 7048: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7044: , line_party_id
7045: , m.order_org_id
7046: , m.order_transactional_curr_code
7047: , -2
7048: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7049: , sysdate
7050: , l_created_by
7051: , sysdate
7052: , l_last_updated_by

Line 7122: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7118: , line_party_id
7119: , m.order_org_id
7120: , m.order_transactional_curr_code
7121: , -2
7122: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7123: , sysdate
7124: , l_created_by
7125: , sysdate
7126: , l_last_updated_by

Line 7293: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7289: , line_party_id
7290: , m.order_org_id
7291: , m.order_transactional_curr_code
7292: , -2
7293: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7294: , sysdate
7295: , l_created_by
7296: , sysdate
7297: , l_last_updated_by

Line 7473: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7469: , order_party_id
7470: , m.order_org_id
7471: , m.order_transactional_curr_code
7472: , -2
7473: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7474: , sysdate
7475: , l_created_by
7476: , sysdate
7477: , l_last_updated_by

Line 7657: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7653: , ca.party_id
7654: , h.org_id
7655: , h.transactional_curr_code
7656: , -2
7657: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7658: , sysdate
7659: , l_created_by
7660: , sysdate
7661: , l_last_updated_by

Line 8252: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Init_Summary_Table ', 1 );

8248:
8249: IF G_debug_flag = 'Y'
8250: THEN
8251: oe_debug_pub.add( ' after COMMIT command');
8252: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Init_Summary_Table ', 1 );
8253: END IF;
8254:
8255: EXCEPTION
8256:

Line 8331: l_binary_tbl oe_credit_exposure_pvt.Binary_tbl_type;

8327: l_bucket_length NUMBER;
8328: l_main_bucket NUMBER;
8329: l_main_bucket_length NUMBER;
8330: l_level NUMBER;
8331: l_binary_tbl oe_credit_exposure_pvt.Binary_tbl_type;
8332: j NUMBER;
8333: l_ship NUMBER;
8334: l_both_exposure VARCHAR2(1) ;
8335:

Line 8356: oe_debug_pub.add( 'IN OEXVCRXB.OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );

8352:
8353:
8354: IF G_debug_flag = 'Y'
8355: THEN
8356: oe_debug_pub.add( 'IN OEXVCRXB.OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
8357: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++++++++++');
8358: oe_debug_pub.add( 'p_customer_id : ' || p_customer_id, 2 );
8359: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
8360: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);

Line 8754: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );

8750: oe_debug_pub.add(' ');
8751: oe_debug_pub.add(' Total FINAL exposure ==> '|| x_total_exposure,1 );
8752: oe_debug_pub.add(' ');
8753: oe_debug_pub.add('*************************************************');
8754: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
8755: END IF;
8756:
8757:
8758: l_total := 0;

Line 8785: END OE_CREDIT_EXPOSURE_PVT;

8781:
8782: END Get_Exposure;
8783:
8784:
8785: END OE_CREDIT_EXPOSURE_PVT;