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_SCREDIT_UTIL dependencies on OE_ORDER_PUB

Line 55: ( p_HEADER_SCREDIT_rec IN OE_Order_PUB.HEADER_SCREDIT_Rec_Type

51:
52: END G_MISS_OE_AK_HSCREDIT_REC;
53:
54: PROCEDURE API_Rec_To_Rowtype_Rec
55: ( p_HEADER_SCREDIT_rec IN OE_Order_PUB.HEADER_SCREDIT_Rec_Type
56: , x_rowtype_rec IN OUT NOCOPY OE_AK_HEADER_SCREDITS_V%ROWTYPE
57: ) IS
58: --
59: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 101: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_SCREDIT_Rec_Type

97:
98:
99: PROCEDURE Rowtype_Rec_To_API_Rec
100: ( p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
101: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_SCREDIT_Rec_Type
102: ) IS
103: --
104: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
105: --

Line 505: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

501: END Clear_Dependent_Attr;
502:
503: PROCEDURE Clear_Dependent_Attr
504: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
505: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
506: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
507: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
508: )
509: IS

Line 506: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=

502:
503: PROCEDURE Clear_Dependent_Attr
504: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
505: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
506: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
507: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
508: )
509: IS
510: l_Header_Scredit_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;

Line 507: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC

503: PROCEDURE Clear_Dependent_Attr
504: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
505: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
506: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
507: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
508: )
509: IS
510: l_Header_Scredit_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;
511: l_old_Header_Scredit_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;

Line 533: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

529:
530: -- Procedure Apply_Attribute_Changes
531:
532: PROCEDURE Apply_Attribute_Changes
533: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
534: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
535: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
536: )
537: IS

Line 534: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=

530: -- Procedure Apply_Attribute_Changes
531:
532: PROCEDURE Apply_Attribute_Changes
533: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
534: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
535: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
536: )
537: IS
538: l_return_status Varchar2(10);

Line 535: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC

531:
532: PROCEDURE Apply_Attribute_Changes
533: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
534: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
535: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
536: )
537: IS
538: l_return_status Varchar2(10);
539: --SG{

Line 792: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

788:
789: -- Procedure Complete_Record
790:
791: PROCEDURE Complete_Record
792: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
793: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
794: )
795: IS
796: --

Line 793: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type

789: -- Procedure Complete_Record
790:
791: PROCEDURE Complete_Record
792: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
793: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
794: )
795: IS
796: --
797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 924: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

920:
921: -- Procedure Convert_Miss_To_Null
922:
923: PROCEDURE Convert_Miss_To_Null
924: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
925: )
926: IS
927:
928: --

Line 1056: ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

1052:
1053: -- Procedure Update_Row
1054:
1055: PROCEDURE Update_Row
1056: ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
1057: )
1058: IS
1059: l_lock_control NUMBER;
1060: --added for notification framework

Line 1170: ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

1166:
1167: -- Procedure Insert_Row
1168:
1169: PROCEDURE Insert_Row
1170: ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
1171: )
1172: IS
1173: l_lock_control NUMBER:= 1;
1174: l_index NUMBER;

Line 1332: l_new_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

1328: SELECT sales_credit_id
1329: FROM OE_SALES_CREDITS
1330: WHERE HEADER_ID = p_header_id;
1331: -- added for notification framework
1332: l_new_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1333: l_index NUMBER;
1334: --
1335: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1336: --

Line 1476: x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

1472:
1473: -- Procedure Query_Row
1474: PROCEDURE Query_Row
1475: ( p_sales_credit_id IN NUMBER,
1476: x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
1477: )
1478: IS
1479: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1480: --

Line 1479: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

1475: ( p_sales_credit_id IN NUMBER,
1476: x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
1477: )
1478: IS
1479: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1480: --
1481: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1482: --
1483: BEGIN

Line 1504: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type

1500: ( p_sales_credit_id IN NUMBER :=
1501: FND_API.G_MISS_NUM
1502: , p_header_id IN NUMBER :=
1503: FND_API.G_MISS_NUM
1504: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
1505: )
1506: IS
1507: l_count NUMBER;
1508:

Line 1722: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

1718: --
1719:
1720: PROCEDURE Lock_Row
1721: ( x_return_status OUT NOCOPY VARCHAR2
1722: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
1723: , p_sales_credit_id IN NUMBER
1724: := FND_API.G_MISS_NUM
1725: )
1726: IS

Line 1728: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

1724: := FND_API.G_MISS_NUM
1725: )
1726: IS
1727: l_sales_credit_id NUMBER;
1728: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1729: l_lock_control NUMBER;
1730: --
1731: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1732: --

Line 1861: , x_header_scredit_tbl OUT NOCOPY OE_Order_PUB.header_scredit_Tbl_Type

1857: ( p_sales_credit_id IN NUMBER :=
1858: FND_API.G_MISS_NUM
1859: , p_header_id IN NUMBER :=
1860: FND_API.G_MISS_NUM
1861: , x_header_scredit_tbl OUT NOCOPY OE_Order_PUB.header_scredit_Tbl_Type
1862: , x_return_status OUT NOCOPY VARCHAR2
1863: )
1864: IS
1865: CURSOR lock_hdr_scredits(p_header_id NUMBER) IS

Line 1991: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type

1987:
1988: -- Function Get_Values
1989:
1990: FUNCTION Get_Values
1991: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
1992: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
1993: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
1994: )RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type
1995: IS

Line 1992: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=

1988: -- Function Get_Values
1989:
1990: FUNCTION Get_Values
1991: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
1992: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
1993: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
1994: )RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type
1995: IS
1996: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;

Line 1993: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC

1989:
1990: FUNCTION Get_Values
1991: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
1992: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
1993: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
1994: )RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type
1995: IS
1996: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
1997: --

Line 1994: )RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type

1990: FUNCTION Get_Values
1991: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
1992: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
1993: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
1994: )RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type
1995: IS
1996: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
1997: --
1998: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1996: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;

1992: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
1993: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
1994: )RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type
1995: IS
1996: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
1997: --
1998: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1999: --
2000: --sg{

Line 2050: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

2046:
2047: -- Procedure Get_Ids
2048:
2049: PROCEDURE Get_Ids
2050: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
2051: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type
2052: )
2053: IS
2054:

Line 2051: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type

2047: -- Procedure Get_Ids
2048:
2049: PROCEDURE Get_Ids
2050: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
2051: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type
2052: )
2053: IS
2054:
2055: --

Line 2134: ( p_x_header_scredit_rec IN OUT NOCOPY OE_ORDER_PUB.header_scredit_rec_type,

2130: END Get_Ids;
2131:
2132: /* Start AuditTrail */
2133: PROCEDURE Pre_Write_Process
2134: ( p_x_header_scredit_rec IN OUT NOCOPY OE_ORDER_PUB.header_scredit_rec_type,
2135: p_old_header_scredit_rec IN OE_ORDER_PUB.header_scredit_rec_type := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC )
2136: IS
2137: l_return_status varchar2(30);
2138: --

Line 2135: p_old_header_scredit_rec IN OE_ORDER_PUB.header_scredit_rec_type := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC )

2131:
2132: /* Start AuditTrail */
2133: PROCEDURE Pre_Write_Process
2134: ( p_x_header_scredit_rec IN OUT NOCOPY OE_ORDER_PUB.header_scredit_rec_type,
2135: p_old_header_scredit_rec IN OE_ORDER_PUB.header_scredit_rec_type := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC )
2136: IS
2137: l_return_status varchar2(30);
2138: --
2139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2316: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2312: /* Changed the above cursor definition to fix the bug 1822931 */
2313:
2314:
2315: l_scredit_type_id number;
2316: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2317: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2320: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 2317: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2313:
2314:
2315: l_scredit_type_id number;
2316: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2317: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2320: l_control_rec OE_GLOBALS.Control_Rec_Type;
2321: l_return_status VARCHAR2(30);

Line 2318: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2314:
2315: l_scredit_type_id number;
2316: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2317: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2320: l_control_rec OE_GLOBALS.Control_Rec_Type;
2321: l_return_status VARCHAR2(30);
2322: x_msg_count NUMBER;

Line 2319: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2315: l_scredit_type_id number;
2316: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2317: l_old_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2320: l_control_rec OE_GLOBALS.Control_Rec_Type;
2321: l_return_status VARCHAR2(30);
2322: x_msg_count NUMBER;
2323: x_msg_data VARCHAR2(2000);

Line 2432: l_Header_Scredit_rec := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;

2428:
2429: l_control_rec.clear_api_cache := FALSE;
2430: l_control_rec.clear_api_requests := FALSE;
2431:
2432: l_Header_Scredit_rec := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
2433: l_Header_Scredit_rec.operation := OE_GLOBALS.G_OPR_CREATE;
2434: l_Header_Scredit_rec.Header_id := p_header_id;
2435: l_Header_Scredit_rec.SalesRep_Id := p_salesrep_id;
2436: l_Header_Scredit_rec.Sales_credit_type_id := l_scredit_type_id;

Line 2446: l_old_Header_Scredit_tbl(1) := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;

2442: l_Header_Scredit_rec.percent := 100;
2443: --End If;
2444:
2445: l_Header_Scredit_tbl(1) := l_Header_Scredit_rec;
2446: l_old_Header_Scredit_tbl(1) := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
2447:
2448: END IF;
2449: -- at this stage its either a insert or update
2450: -- Call OE_Order_PVT.Process_order