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

Line 56: ( p_LINE_SCREDIT_rec IN OE_Order_PUB.LINE_SCREDIT_Rec_Type

52:
53: END G_MISS_OE_AK_LINE_SCREDIT_REC;
54:
55: PROCEDURE API_Rec_To_Rowtype_Rec
56: ( p_LINE_SCREDIT_rec IN OE_Order_PUB.LINE_SCREDIT_Rec_Type
57: , x_rowtype_rec IN OUT NOCOPY OE_AK_LINE_SCREDITS_V%ROWTYPE
58: ) IS
59: --
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 102: , x_api_rec IN OUT NOCOPY OE_Order_PUB.LINE_SCREDIT_Rec_Type

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

Line 513: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

509: -- Procedure Clear_Dependent_Attr
510:
511: PROCEDURE Clear_Dependent_Attr
512: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
513: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
514: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
515: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
516: )
517: IS

Line 514: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=

510:
511: PROCEDURE Clear_Dependent_Attr
512: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
513: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
514: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
515: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
516: )
517: IS
518: l_Line_Scredit_rec OE_AK_LINE_SCREDITS_V%ROWTYPE;

Line 515: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC

511: PROCEDURE Clear_Dependent_Attr
512: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
513: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
514: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
515: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
516: )
517: IS
518: l_Line_Scredit_rec OE_AK_LINE_SCREDITS_V%ROWTYPE;
519: l_old_Line_Scredit_rec OE_AK_LINE_SCREDITS_V%ROWTYPE;

Line 542: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

538:
539: -- Procedure Apply_Attribute_Changes
540:
541: PROCEDURE Apply_Attribute_Changes
542: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
543: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
544: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
545: )
546: IS

Line 543: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=

539: -- Procedure Apply_Attribute_Changes
540:
541: PROCEDURE Apply_Attribute_Changes
542: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
543: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
544: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
545: )
546: IS
547: l_return_status Varchar2(10);

Line 544: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC

540:
541: PROCEDURE Apply_Attribute_Changes
542: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
543: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
544: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
545: )
546: IS
547: l_return_status Varchar2(10);
548: --SG{

Line 876: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

872:
873: -- Function Complete_Record
874:
875: PROCEDURE Complete_Record
876: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
877: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
878: )
879: IS
880: --

Line 877: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type

873: -- Function Complete_Record
874:
875: PROCEDURE Complete_Record
876: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
877: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
878: )
879: IS
880: --
881: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1014: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

1010:
1011: -- Function Convert_Miss_To_Null
1012:
1013: PROCEDURE Convert_Miss_To_Null
1014: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
1015: )
1016: IS
1017: --
1018: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1151: ( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

1147:
1148: -- Procedure Update_Row
1149:
1150: PROCEDURE Update_Row
1151: ( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
1152: )
1153: IS
1154: l_lock_control NUMBER;
1155: /* jolin start*/

Line 1157: l_Line_scredit_rec OE_Order_PUB.Line_scredit_Rec_Type;

1153: IS
1154: l_lock_control NUMBER;
1155: /* jolin start*/
1156: --added for notification framework
1157: l_Line_scredit_rec OE_Order_PUB.Line_scredit_Rec_Type;
1158: l_index NUMBER;
1159: l_return_status VARCHAR2(1);
1160: /* jolin end*/
1161:

Line 1298: ( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

1294:
1295: -- Procedure Insert_Row
1296:
1297: PROCEDURE Insert_Row
1298: ( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
1299: )
1300: IS
1301: l_lock_control NUMBER:= 1;
1302: /* jolin start*/

Line 1466: l_Line_scredit_rec OE_Order_PUB.Line_scredit_Rec_Type;

1462: IS
1463: l_return_status VARCHAR2(30);
1464: /* jolin start*/
1465: --added for notification framework
1466: l_Line_scredit_rec OE_Order_PUB.Line_scredit_Rec_Type;
1467: l_new_Line_scredit_rec OE_Order_PUB.Line_scredit_Rec_Type;
1468: l_index NUMBER;
1469: /* jolin end*/
1470:

Line 1467: l_new_Line_scredit_rec OE_Order_PUB.Line_scredit_Rec_Type;

1463: l_return_status VARCHAR2(30);
1464: /* jolin start*/
1465: --added for notification framework
1466: l_Line_scredit_rec OE_Order_PUB.Line_scredit_Rec_Type;
1467: l_new_Line_scredit_rec OE_Order_PUB.Line_scredit_Rec_Type;
1468: l_index NUMBER;
1469: /* jolin end*/
1470:
1471: CURSOR sales_credit IS

Line 1664: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

1660: -- PROCEDURE Query_Row
1661:
1662: PROCEDURE Query_Row
1663: ( p_sales_credit_id IN NUMBER
1664: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
1665: )
1666: IS
1667: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1668: --

Line 1667: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1663: ( p_sales_credit_id IN NUMBER
1664: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
1665: )
1666: IS
1667: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1668: --
1669: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1670: --
1671: BEGIN

Line 1696: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type

1692: , p_line_id IN NUMBER :=
1693: FND_API.G_MISS_NUM
1694: , p_header_id IN NUMBER :=
1695: FND_API.G_MISS_NUM
1696: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
1697: )
1698: IS
1699:
1700: CURSOR l_Line_Scredit_csr_s IS

Line 1966: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

1962:
1963: PROCEDURE Lock_Row
1964: ( x_return_status OUT NOCOPY VARCHAR2
1965:
1966: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
1967: , p_sales_credit_id IN NUMBER
1968: := FND_API.G_MISS_NUM
1969: )
1970: IS

Line 2103: , x_line_scredit_tbl OUT NOCOPY OE_Order_PUB.Line_scredit_Tbl_Type

2099: ( p_sales_credit_id IN NUMBER :=
2100: FND_API.G_MISS_NUM
2101: , p_line_id IN NUMBER :=
2102: FND_API.G_MISS_NUM
2103: , x_line_scredit_tbl OUT NOCOPY OE_Order_PUB.Line_scredit_Tbl_Type
2104: , x_return_status OUT NOCOPY VARCHAR2
2105:
2106: )
2107: IS

Line 2233: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type

2229:
2230: -- Function Get_Values
2231:
2232: FUNCTION Get_Values
2233: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
2234: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
2235: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
2236: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2237: IS

Line 2234: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=

2230: -- Function Get_Values
2231:
2232: FUNCTION Get_Values
2233: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
2234: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
2235: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
2236: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2237: IS
2238: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;

Line 2235: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC

2231:
2232: FUNCTION Get_Values
2233: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
2234: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
2235: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
2236: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2237: IS
2238: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
2239: --

Line 2236: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type

2232: FUNCTION Get_Values
2233: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
2234: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
2235: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
2236: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2237: IS
2238: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
2239: --
2240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2238: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;

2234: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
2235: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
2236: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2237: IS
2238: l_Line_Scredit_val_rec OE_Order_PUB.Line_Scredit_Val_Rec_Type;
2239: --
2240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2241: --
2242: BEGIN

Line 2284: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

2280:
2281: -- PROCEDURE Get_Ids
2282:
2283: PROCEDURE Get_Ids
2284: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
2285: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2286: )
2287: IS
2288: --

Line 2285: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type

2281: -- PROCEDURE Get_Ids
2282:
2283: PROCEDURE Get_Ids
2284: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
2285: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2286: )
2287: IS
2288: --
2289: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2355: Procedure Create_credit(p_line_rec IN oe_order_pub.line_rec_type,

2351:
2352: END Get_Ids;
2353:
2354:
2355: Procedure Create_credit(p_line_rec IN oe_order_pub.line_rec_type,
2356: p_old_line_rec IN oe_order_pub.line_rec_type)
2357: IS
2358: l_api_name CONSTANT VARCHAR2(30) := 'Create Credit';
2359: l_return_status VARCHAR2(30);

Line 2356: p_old_line_rec IN oe_order_pub.line_rec_type)

2352: END Get_Ids;
2353:
2354:
2355: Procedure Create_credit(p_line_rec IN oe_order_pub.line_rec_type,
2356: p_old_line_rec IN oe_order_pub.line_rec_type)
2357: IS
2358: l_api_name CONSTANT VARCHAR2(30) := 'Create Credit';
2359: l_return_status VARCHAR2(30);
2360: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 2361: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;

2357: IS
2358: l_api_name CONSTANT VARCHAR2(30) := 'Create Credit';
2359: l_return_status VARCHAR2(30);
2360: l_control_rec OE_GLOBALS.Control_Rec_Type;
2361: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;
2362: l_old_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;
2363: l_line_scredit_rec OE_ORDER_PUB.line_scredit_rec_type ;
2364: l_create_flag boolean := FALSE;
2365: l_update_flag boolean := FALSE;

Line 2362: l_old_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;

2358: l_api_name CONSTANT VARCHAR2(30) := 'Create Credit';
2359: l_return_status VARCHAR2(30);
2360: l_control_rec OE_GLOBALS.Control_Rec_Type;
2361: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;
2362: l_old_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;
2363: l_line_scredit_rec OE_ORDER_PUB.line_scredit_rec_type ;
2364: l_create_flag boolean := FALSE;
2365: l_update_flag boolean := FALSE;
2366: l_scredit_id number;

Line 2363: l_line_scredit_rec OE_ORDER_PUB.line_scredit_rec_type ;

2359: l_return_status VARCHAR2(30);
2360: l_control_rec OE_GLOBALS.Control_Rec_Type;
2361: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;
2362: l_old_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type ;
2363: l_line_scredit_rec OE_ORDER_PUB.line_scredit_rec_type ;
2364: l_create_flag boolean := FALSE;
2365: l_update_flag boolean := FALSE;
2366: l_scredit_id number;
2367: x_msg_count number;

Line 2545: l_line_scredit_tbl(1) := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;

2541: open C_SCRTYPE;
2542: fetch C_SCRTYPE into l_scredit_Type_id;
2543: close C_SCRTYPE;
2544:
2545: l_line_scredit_tbl(1) := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
2546: l_line_scredit_tbl(1).operation := oe_globals.g_opr_create;
2547: l_line_scredit_tbl(1).header_id := p_line_rec.header_id;
2548: l_line_scredit_tbl(1).line_id := p_line_rec.line_id;
2549: l_line_scredit_tbl(1).percent := 100;

Line 2668: (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,

2664: End Create_credit;
2665:
2666: /* Start AuditTrail */
2667: PROCEDURE Pre_Write_Process
2668: (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,
2669: p_old_line_scredit_rec IN OE_ORDER_PUB.line_scredit_rec_type :=
2670: OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC
2671: )IS
2672: /*local */

Line 2669: p_old_line_scredit_rec IN OE_ORDER_PUB.line_scredit_rec_type :=

2665:
2666: /* Start AuditTrail */
2667: PROCEDURE Pre_Write_Process
2668: (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,
2669: p_old_line_scredit_rec IN OE_ORDER_PUB.line_scredit_rec_type :=
2670: OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC
2671: )IS
2672: /*local */
2673: l_return_status varchar2(30);

Line 2670: OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC

2666: /* Start AuditTrail */
2667: PROCEDURE Pre_Write_Process
2668: (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,
2669: p_old_line_scredit_rec IN OE_ORDER_PUB.line_scredit_rec_type :=
2670: OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC
2671: )IS
2672: /*local */
2673: l_return_status varchar2(30);
2674: --