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.19.12020000.2 2012/11/14 19:38:01 cpati 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 1665: , x_binary_tbl OUT NOCOPY oe_credit_exposure_pvt.Binary_tbl_type

1661: PROCEDURE calculate_buckets
1662: ( p_date IN NUMBER
1663: , p_interval IN NUMBER
1664: , x_main_bucket OUT NOCOPY NUMBER
1665: , x_binary_tbl OUT NOCOPY oe_credit_exposure_pvt.Binary_tbl_type
1666: )
1667: IS
1668: l_date NUMBER;
1669: l_level NUMBER;

Line 1813: ( p_binary_tbl IN oe_credit_exposure_pvt.Binary_tbl_type

1809: -- as the exposure balance is governed by the
1810: -- balance types used
1811: --------------------------------------------------------------
1812: FUNCTION retrieve_exposure
1813: ( p_binary_tbl IN oe_credit_exposure_pvt.Binary_tbl_type
1814: , p_site_use_id IN NUMBER
1815: , p_customer_id IN NUMBER
1816: , p_party_id IN NUMBER
1817: , p_org_id IN NUMBER

Line 5856: DECODE(OE_CREDIT_EXPOSURE_PVT.Is_Equal(rl.interface_line_attribute6,l.line_id),'Y',-999,to_number(rl.interface_line_attribute6)) interface_line_attribute6 --TaxER

5852: s.cust_account_id order_cust_account_id,
5853: ca.party_id order_party_id,
5854: s_l.cust_account_id line_cust_account_id,
5855: ca_l.party_id line_party_id,
5856: DECODE(OE_CREDIT_EXPOSURE_PVT.Is_Equal(rl.interface_line_attribute6,l.line_id),'Y',-999,to_number(rl.interface_line_attribute6)) interface_line_attribute6 --TaxER
5857: from oe_order_lines_all l
5858: , oe_order_headers_all h
5859: , hz_cust_site_uses_all su
5860: , hz_cust_acct_sites_all s

Line 6121: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6117: , order_party_id
6118: , m.order_org_id
6119: , m.order_transactional_curr_code
6120: , -2
6121: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6122: , sysdate
6123: , l_created_by
6124: , SYSDATE
6125: , l_last_updated_by

Line 6188: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6184: , order_party_id
6185: , m.order_org_id
6186: , m.order_transactional_curr_code
6187: , -2
6188: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6189: , sysdate
6190: , l_created_by
6191: , sysdate
6192: , l_last_updated_by

Line 6409: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6405: , line_party_id
6406: , m.order_org_id
6407: , m.order_transactional_curr_code
6408: , -2
6409: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6410: , sysdate
6411: , l_created_by
6412: , sysdate
6413: , l_last_updated_by

Line 6476: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6472: , line_party_id
6473: , m.order_org_id
6474: , m.order_transactional_curr_code
6475: , -2
6476: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6477: , sysdate
6478: , l_created_by
6479: , sysdate
6480: , l_last_updated_by

Line 6716: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6712: , line_party_id
6713: , m.order_org_id
6714: , m.order_transactional_curr_code
6715: , -2
6716: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6717: , sysdate
6718: , l_created_by
6719: , sysdate
6720: , l_last_updated_by

Line 6786: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

6782: , line_party_id
6783: , m.order_org_id
6784: , m.order_transactional_curr_code
6785: , -2
6786: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
6787: , sysdate
6788: , l_created_by
6789: , sysdate
6790: , l_last_updated_by

Line 7042: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7038: , order_party_id
7039: , m.order_org_id
7040: , m.order_transactional_curr_code
7041: , -2
7042: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7043: , sysdate
7044: , l_created_by
7045: , sysdate
7046: , l_last_updated_by

Line 7110: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7106: , order_party_id
7107: , m.order_org_id
7108: , m.order_transactional_curr_code
7109: , -2
7110: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7111: , sysdate
7112: , l_created_by
7113: , sysdate
7114: , l_last_updated_by

Line 7527: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7523: , ca.party_id
7524: , h.org_id
7525: , h.transactional_curr_code
7526: , -2
7527: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7528: , sysdate
7529: , l_created_by
7530: , sysdate
7531: , l_last_updated_by

Line 7585: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7581: , ca.party_id
7582: , h.org_id
7583: , h.transactional_curr_code
7584: , -2
7585: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7586: , sysdate
7587: , l_created_by
7588: , sysdate
7589: , l_last_updated_by

Line 7678: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7674: , ca.party_id
7675: , h.org_id
7676: , h.transactional_curr_code
7677: , -2
7678: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7679: , sysdate
7680: , l_created_by
7681: , sysdate
7682: , l_last_updated_by

Line 7738: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

7734: , ca.party_id
7735: , h.org_id
7736: , h.transactional_curr_code
7737: , -2
7738: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
7739: , sysdate
7740: , l_created_by
7741: , sysdate
7742: , l_last_updated_by

Line 8029: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

8025: , ca.party_id
8026: , h.org_id
8027: , h.transactional_curr_code
8028: , -2
8029: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
8030: , sysdate
8031: , l_created_by
8032: , sysdate
8033: , l_last_updated_by

Line 8136: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

8132: , order_party_id
8133: , m.order_org_id
8134: , m.order_transactional_curr_code
8135: , -2
8136: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
8137: , sysdate
8138: , l_created_by
8139: , sysdate
8140: , l_last_updated_by

Line 8389: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

8385: , line_party_id
8386: , m.order_org_id
8387: , m.order_transactional_curr_code
8388: , -2
8389: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
8390: , sysdate
8391: , l_created_by
8392: , sysdate
8393: , l_last_updated_by

Line 8467: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

8463: , line_party_id
8464: , m.order_org_id
8465: , m.order_transactional_curr_code
8466: , -2
8467: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
8468: , sysdate
8469: , l_created_by
8470: , sysdate
8471: , l_last_updated_by

Line 8736: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

8732: , line_party_id
8733: , m.order_org_id
8734: , m.order_transactional_curr_code
8735: , -2
8736: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
8737: , sysdate
8738: , l_created_by
8739: , sysdate
8740: , l_last_updated_by

Line 8814: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

8810: , line_party_id
8811: , m.order_org_id
8812: , m.order_transactional_curr_code
8813: , -2
8814: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
8815: , sysdate
8816: , l_created_by
8817: , sysdate
8818: , l_last_updated_by

Line 9100: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

9096: , order_party_id
9097: , m.order_org_id
9098: , m.order_transactional_curr_code
9099: , -2
9100: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
9101: , sysdate
9102: , l_created_by
9103: , sysdate
9104: , l_last_updated_by

Line 9177: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

9173: , order_party_id
9174: , m.order_org_id
9175: , m.order_transactional_curr_code
9176: , -2
9177: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
9178: , sysdate
9179: , l_created_by
9180: , sysdate
9181: , l_last_updated_by

Line 9473: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

9469: , ca.party_id
9470: , h.org_id
9471: , h.transactional_curr_code
9472: , -2
9473: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
9474: , sysdate
9475: , l_created_by
9476: , sysdate
9477: , l_last_updated_by

Line 9567: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH

9563: , ca.party_id
9564: , h.org_id
9565: , h.transactional_curr_code
9566: , -2
9567: , OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH
9568: , sysdate
9569: , l_created_by
9570: , sysdate
9571: , l_last_updated_by

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

10274:
10275: IF G_debug_flag = 'Y'
10276: THEN
10277: oe_debug_pub.add( ' after COMMIT command');
10278: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Init_Summary_Table ', 1 );
10279: END IF;
10280:
10281: EXCEPTION
10282:

Line 10357: l_binary_tbl oe_credit_exposure_pvt.Binary_tbl_type;

10353: l_bucket_length NUMBER;
10354: l_main_bucket NUMBER;
10355: l_main_bucket_length NUMBER;
10356: l_level NUMBER;
10357: l_binary_tbl oe_credit_exposure_pvt.Binary_tbl_type;
10358: j NUMBER;
10359: l_ship NUMBER;
10360: l_both_exposure VARCHAR2(1) ;
10361:

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

10378:
10379:
10380: IF G_debug_flag = 'Y'
10381: THEN
10382: oe_debug_pub.add( 'IN OEXVCRXB.OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10383: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++++++++++');
10384: oe_debug_pub.add( 'p_customer_id : ' || p_customer_id, 2 );
10385: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
10386: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);

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

10776: oe_debug_pub.add(' ');
10777: oe_debug_pub.add(' Total FINAL exposure ==> '|| x_total_exposure,1 );
10778: oe_debug_pub.add(' ');
10779: oe_debug_pub.add('*************************************************');
10780: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10781: END IF;
10782:
10783:
10784: l_total := 0;

Line 10811: END OE_CREDIT_EXPOSURE_PVT;

10807:
10808: END Get_Exposure;
10809:
10810:
10811: END OE_CREDIT_EXPOSURE_PVT;