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

Line 24: Procedure PerformLineCancellation(P_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,

20: --g_ord_lvl_can boolean := FALSE; Commented for bug# 2922468
21: g_par_ord_lvl_can boolean := FALSE; -- Introduced this variable to fix bug 2230777
22: g_ser_cascade boolean := FALSE;
23:
24: Procedure PerformLineCancellation(P_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
25: p_line_old_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
26: x_return_status OUT NOCOPY VARCHAR2);
27:
28:

Line 25: p_line_old_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,

21: g_par_ord_lvl_can boolean := FALSE; -- Introduced this variable to fix bug 2230777
22: g_ser_cascade boolean := FALSE;
23:
24: Procedure PerformLineCancellation(P_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
25: p_line_old_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE,
26: x_return_status OUT NOCOPY VARCHAR2);
27:
28:
29: Procedure UpdateLine

Line 42: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

38: ,x_msg_data out nocopy Varchar2)
39:
40: Is
41: l_api_name VARCHAR2(30) := 'UPDATELINE';
42: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
43: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
44: l_control_rec OE_GLOBALS.Control_Rec_Type;
45: l_return_status VARCHAR2(1);
46: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 43: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

39:
40: Is
41: l_api_name VARCHAR2(30) := 'UPDATELINE';
42: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
43: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
44: l_control_rec OE_GLOBALS.Control_Rec_Type;
45: l_return_status VARCHAR2(1);
46: l_line_rec OE_Order_PUB.Line_Rec_Type;
47:

Line 46: l_line_rec OE_Order_PUB.Line_Rec_Type;

42: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
43: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
44: l_control_rec OE_GLOBALS.Control_Rec_Type;
45: l_return_status VARCHAR2(1);
46: l_line_rec OE_Order_PUB.Line_Rec_Type;
47:
48: --
49: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
50: --

Line 191: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: END UpdateLine;
189:
190: PROCEDURE perform_line_change
191: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
192: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
193: , x_return_status OUT NOCOPY VARCHAR2
194:
195: )

Line 192: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC

188: END UpdateLine;
189:
190: PROCEDURE perform_line_change
191: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
192: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
193: , x_return_status OUT NOCOPY VARCHAR2
194:
195: )
196: IS

Line 702: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

698: -- Cancelled quantities need to be populated.
699: ---------------------------------------------------------------------------------
700:
701: PROCEDURE check_constraints
702: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
703: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
704: , x_return_status OUT NOCOPY varchar2
705:
706: )

Line 703: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC

699: ---------------------------------------------------------------------------------
700:
701: PROCEDURE check_constraints
702: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
703: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
704: , x_return_status OUT NOCOPY varchar2
705:
706: )
707: IS

Line 709: --l_line_Rec oe_order_pub.line_rec_type := p_line_Rec;

705:
706: )
707: IS
708: l_return_status VARCHAR2(30) :=FND_API.G_RET_STS_SUCCESS;
709: --l_line_Rec oe_order_pub.line_rec_type := p_line_Rec;
710: x_result NUMBER := 0 ;
711: x_msg_count NUMBER;
712: x_msg_data VARCHAR2(255);
713: l_api_name VARCHAR2(30):= 'Check_Constraints';

Line 974: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

970:
971: END check_constraints;
972:
973: PROCEDURE update_service
974: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
975: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
976: , x_return_status OUT NOCOPY VARCHAR2
977:
978: )

Line 975: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC

971: END check_constraints;
972:
973: PROCEDURE update_service
974: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
975: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC
976: , x_return_status OUT NOCOPY VARCHAR2
977:
978: )
979: IS

Line 1073: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: end update_service;
1071:
1072: FUNCTION Cal_Cancelled_Qty
1073: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
1074: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
1075: OE_Order_PUB.G_MISS_LINE_REC
1076: )Return Number
1077: IS

Line 1074: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

1070: end update_service;
1071:
1072: FUNCTION Cal_Cancelled_Qty
1073: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
1074: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
1075: OE_Order_PUB.G_MISS_LINE_REC
1076: )Return Number
1077: IS
1078: l_ordered_quantity number;

Line 1075: OE_Order_PUB.G_MISS_LINE_REC

1071:
1072: FUNCTION Cal_Cancelled_Qty
1073: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
1074: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
1075: OE_Order_PUB.G_MISS_LINE_REC
1076: )Return Number
1077: IS
1078: l_ordered_quantity number;
1079: l_old_ord_quantity number;

Line 1208: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

1204:
1205: end Cal_Cancelled_qty;
1206:
1207: PROCEDURE check_constraints
1208: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
1209: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
1210: OE_Order_PUB.G_MISS_header_REC
1211: , x_return_status OUT NOCOPY VARCHAR2
1212:

Line 1209: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=

1205: end Cal_Cancelled_qty;
1206:
1207: PROCEDURE check_constraints
1208: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
1209: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
1210: OE_Order_PUB.G_MISS_header_REC
1211: , x_return_status OUT NOCOPY VARCHAR2
1212:
1213: ) IS

Line 1210: OE_Order_PUB.G_MISS_header_REC

1206:
1207: PROCEDURE check_constraints
1208: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
1209: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
1210: OE_Order_PUB.G_MISS_header_REC
1211: , x_return_status OUT NOCOPY VARCHAR2
1212:
1213: ) IS
1214: l_api_name CONSTANT VARCHAR2(30) := 'Check_Constraints';

Line 1261: ( p_header_rec IN OE_Order_PUB.header_Rec_Type

1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: end check_constraints;
1259:
1260: PROCEDURE perform_cancel_order
1261: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
1262: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type := OE_Order_PUB.G_MISS_header_REC
1263: , x_return_status OUT NOCOPY VARCHAR2
1264:
1265: )IS

Line 1262: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type := OE_Order_PUB.G_MISS_header_REC

1258: end check_constraints;
1259:
1260: PROCEDURE perform_cancel_order
1261: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
1262: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type := OE_Order_PUB.G_MISS_header_REC
1263: , x_return_status OUT NOCOPY VARCHAR2
1264:
1265: )IS
1266: l_line_tbl OE_Order_PUB.line_tbl_type;

Line 1266: l_line_tbl OE_Order_PUB.line_tbl_type;

1262: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type := OE_Order_PUB.G_MISS_header_REC
1263: , x_return_status OUT NOCOPY VARCHAR2
1264:
1265: )IS
1266: l_line_tbl OE_Order_PUB.line_tbl_type;
1267: l_line_old_tbl OE_Order_PUB.line_tbl_type;
1268: l_line_rec OE_Order_PUB.line_rec_type;
1269: l_msg_count NUMBER;
1270: l_msg_data VARCHAR2(240);

Line 1267: l_line_old_tbl OE_Order_PUB.line_tbl_type;

1263: , x_return_status OUT NOCOPY VARCHAR2
1264:
1265: )IS
1266: l_line_tbl OE_Order_PUB.line_tbl_type;
1267: l_line_old_tbl OE_Order_PUB.line_tbl_type;
1268: l_line_rec OE_Order_PUB.line_rec_type;
1269: l_msg_count NUMBER;
1270: l_msg_data VARCHAR2(240);
1271: l_entity_id NUMBER;

Line 1268: l_line_rec OE_Order_PUB.line_rec_type;

1264:
1265: )IS
1266: l_line_tbl OE_Order_PUB.line_tbl_type;
1267: l_line_old_tbl OE_Order_PUB.line_tbl_type;
1268: l_line_rec OE_Order_PUB.line_rec_type;
1269: l_msg_count NUMBER;
1270: l_msg_data VARCHAR2(240);
1271: l_entity_id NUMBER;
1272: l_result VARCHAR2(30);

Line 1284: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;

1280: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;
1281: l_release_comment OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE;
1282:
1283: l_service_parent_exists VARCHAR2(1) := 'N';
1284: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;
1285: i NUMBER := 0;
1286: l_prg_line_count NUMBER;
1287:
1288: --

Line 1577: p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE

1573:
1574: End Perform_Cancel_order;
1575:
1576: Procedure PerformLineCancellation(
1577: p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE
1578: , p_line_old_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE
1579: , x_return_status OUT NOCOPY VARCHAR2)
1580:
1581: IS

Line 1578: , p_line_old_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE

1574: End Perform_Cancel_order;
1575:
1576: Procedure PerformLineCancellation(
1577: p_line_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE
1578: , p_line_old_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE
1579: , x_return_status OUT NOCOPY VARCHAR2)
1580:
1581: IS
1582: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1583: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1579: , x_return_status OUT NOCOPY VARCHAR2)
1580:
1581: IS
1582: l_control_rec OE_GLOBALS.Control_Rec_Type;
1583: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1584: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1585: l_api_name CONSTANT VARCHAR2(30) := 'PerformLineCancellation';
1586: x_msg_count NUMBER;
1587: x_msg_data VARCHAR2(30);

Line 1584: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1580:
1581: IS
1582: l_control_rec OE_GLOBALS.Control_Rec_Type;
1583: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1584: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1585: l_api_name CONSTANT VARCHAR2(30) := 'PerformLineCancellation';
1586: x_msg_count NUMBER;
1587: x_msg_data VARCHAR2(30);
1588:

Line 1680: ) RETURN OE_Order_PUB.Line_Tbl_Type

1676: ( p_line_id IN NUMBER :=
1677: FND_API.G_MISS_NUM
1678: , p_header_id IN NUMBER :=
1679: FND_API.G_MISS_NUM
1680: ) RETURN OE_Order_PUB.Line_Tbl_Type
1681: IS
1682: l_line_rec OE_Order_PUB.Line_Rec_Type;
1683: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1684:

Line 1682: l_line_rec OE_Order_PUB.Line_Rec_Type;

1678: , p_header_id IN NUMBER :=
1679: FND_API.G_MISS_NUM
1680: ) RETURN OE_Order_PUB.Line_Tbl_Type
1681: IS
1682: l_line_rec OE_Order_PUB.Line_Rec_Type;
1683: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1684:
1685: --
1686: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1683: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1679: FND_API.G_MISS_NUM
1680: ) RETURN OE_Order_PUB.Line_Tbl_Type
1681: IS
1682: l_line_rec OE_Order_PUB.Line_Rec_Type;
1683: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1684:
1685: --
1686: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1687: --

Line 1885: ( p_header_Rec IN OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC,

1881: END IF;
1882: END Call_Process_Fulfillment;
1883:
1884: PROCEDURE Cancel_Remaining_Order
1885: ( p_header_Rec IN OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC,
1886: p_header_id IN NUMBER := FND_API.G_MISS_NUM
1887: , x_return_status OUT NOCOPY VARCHAR2
1888:
1889: )

Line 1891: l_line_tbl OE_Order_PUB.line_tbl_type;

1887: , x_return_status OUT NOCOPY VARCHAR2
1888:
1889: )
1890: IS
1891: l_line_tbl OE_Order_PUB.line_tbl_type;
1892: l_line_old_tbl OE_Order_PUB.line_tbl_type;
1893: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;
1894: l_line_rec OE_Order_PUB.line_rec_type;
1895: l_header_rec OE_Order_PUB.header_rec_type;

Line 1892: l_line_old_tbl OE_Order_PUB.line_tbl_type;

1888:
1889: )
1890: IS
1891: l_line_tbl OE_Order_PUB.line_tbl_type;
1892: l_line_old_tbl OE_Order_PUB.line_tbl_type;
1893: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;
1894: l_line_rec OE_Order_PUB.line_rec_type;
1895: l_header_rec OE_Order_PUB.header_rec_type;
1896: l_msg_count NUMBER;

Line 1893: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;

1889: )
1890: IS
1891: l_line_tbl OE_Order_PUB.line_tbl_type;
1892: l_line_old_tbl OE_Order_PUB.line_tbl_type;
1893: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;
1894: l_line_rec OE_Order_PUB.line_rec_type;
1895: l_header_rec OE_Order_PUB.header_rec_type;
1896: l_msg_count NUMBER;
1897: l_msg_data VARCHAR2(240);

Line 1894: l_line_rec OE_Order_PUB.line_rec_type;

1890: IS
1891: l_line_tbl OE_Order_PUB.line_tbl_type;
1892: l_line_old_tbl OE_Order_PUB.line_tbl_type;
1893: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;
1894: l_line_rec OE_Order_PUB.line_rec_type;
1895: l_header_rec OE_Order_PUB.header_rec_type;
1896: l_msg_count NUMBER;
1897: l_msg_data VARCHAR2(240);
1898: l_entity_id NUMBER;

Line 1895: l_header_rec OE_Order_PUB.header_rec_type;

1891: l_line_tbl OE_Order_PUB.line_tbl_type;
1892: l_line_old_tbl OE_Order_PUB.line_tbl_type;
1893: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;
1894: l_line_rec OE_Order_PUB.line_rec_type;
1895: l_header_rec OE_Order_PUB.header_rec_type;
1896: l_msg_count NUMBER;
1897: l_msg_data VARCHAR2(240);
1898: l_entity_id NUMBER;
1899: l_result VARCHAR2(30);

Line 1924: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

1920: x_return_status := FND_API.G_RET_STS_SUCCESS;
1921:
1922: g_par_ord_lvl_can := TRUE; --Fix for bug 2230777
1923:
1924: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1925:
1926: IF (p_header_rec.header_id = FND_API.G_MISS_NUM OR
1927: p_header_rec.header_id = NULL) THEN
1928: l_header_id := p_header_id;

Line 2139: , x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type

2135:
2136: PROCEDURE Cancel_Wf
2137: (
2138: x_return_status OUT NOCOPY varchar2
2139: , x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type
2140: )
2141: IS
2142: l_Ordered_Quantity number ;
2143: Cursor C1 IS

Line 2242: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

2238:
2239:
2240: -- INVCONV OPM Inventory convergence
2241: FUNCTION Cal_Cancelled_Qty2
2242: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2243: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
2244: OE_Order_PUB.G_MISS_LINE_REC
2245: )Return Number
2246: IS

Line 2243: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

2239:
2240: -- INVCONV OPM Inventory convergence
2241: FUNCTION Cal_Cancelled_Qty2
2242: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2243: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
2244: OE_Order_PUB.G_MISS_LINE_REC
2245: )Return Number
2246: IS
2247: l_ordered_quantity2 number;

Line 2244: OE_Order_PUB.G_MISS_LINE_REC

2240: -- INVCONV OPM Inventory convergence
2241: FUNCTION Cal_Cancelled_Qty2
2242: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2243: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
2244: OE_Order_PUB.G_MISS_LINE_REC
2245: )Return Number
2246: IS
2247: l_ordered_quantity2 number;
2248: l_old_ord_quantity2 number;