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.AHL_OSP_SHIPMENT_PUB dependencies on AHL_OSP_SHIPMENT_PUB

Line 1: PACKAGE BODY AHL_OSP_SHIPMENT_PUB AS

1: PACKAGE BODY AHL_OSP_SHIPMENT_PUB AS
2: /* $Header: AHLPOSHB.pls 120.31 2008/02/13 14:48:39 mpothuku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_OSP_Shipment_Pub';
5: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_OSP_Shipment_Pub';

1: PACKAGE BODY AHL_OSP_SHIPMENT_PUB AS
2: /* $Header: AHLPOSHB.pls 120.31 2008/02/13 14:48:39 mpothuku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_OSP_Shipment_Pub';
5: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
6: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_OSP_SHIPMENT_PUB';
7:
8: /** IB Transaction Related constants **/

Line 6: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_OSP_SHIPMENT_PUB';

2: /* $Header: AHLPOSHB.pls 120.31 2008/02/13 14:48:39 mpothuku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_OSP_Shipment_Pub';
5: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
6: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_OSP_SHIPMENT_PUB';
7:
8: /** IB Transaction Related constants **/
9: -- Ship-only transaction type
10: G_OM_ORDER CONSTANT VARCHAR2(30) := 'OM_SHIPMENT';

Line 53: p_header_rec IN AHL_OSP_SHIPMENT_PUB.SHIP_HEADER_REC_TYPE,

49: -- Declare Local Procedures --
50: ------------------------------
51:
52: PROCEDURE Convert_Header_Rec(
53: p_header_rec IN AHL_OSP_SHIPMENT_PUB.SHIP_HEADER_REC_TYPE,
54: p_module_type IN VARCHAR2 ,
55: x_header_rec OUT NOCOPY OE_ORDER_PUB.HEADER_REC_TYPE,
56: x_header_val_rec OUT NOCOPY OE_ORDER_PUB.HEADER_VAL_REC_TYPE);
57:

Line 59: p_line_tbl IN AHL_OSP_SHIPMENT_PUB.SHIP_LINE_TBL_TYPE,

55: x_header_rec OUT NOCOPY OE_ORDER_PUB.HEADER_REC_TYPE,
56: x_header_val_rec OUT NOCOPY OE_ORDER_PUB.HEADER_VAL_REC_TYPE);
57:
58: PROCEDURE Convert_Line_Tbl(
59: p_line_tbl IN AHL_OSP_SHIPMENT_PUB.SHIP_LINE_TBL_TYPE,
60: p_module_type IN VARCHAR2 ,
61: x_line_tbl OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE,
62: x_line_val_tbl OUT NOCOPY OE_ORDER_PUB.LINE_VAL_TBL_TYPE,
63: x_lot_serial_tbl OUT NOCOPY OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE,

Line 70: p_x_line_tbl IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.SHIP_LINE_TBL_TYPE );

66: PROCEDURE Process_Line_Tbl(
67: p_osp_order_id IN NUMBER,
68: p_operation_flag IN VARCHAR,
69: p_module_type IN VARCHAR2,
70: p_x_line_tbl IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.SHIP_LINE_TBL_TYPE );
71:
72: PROCEDURE Update_OSP_Order(
73: p_osp_order_id IN NUMBER,
74: p_oe_header_id IN NUMBER

Line 283: p_x_header_rec IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.Ship_Header_Rec_Type,

279: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: p_module_type IN VARCHAR2 := NULL,
283: p_x_header_rec IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.Ship_Header_Rec_Type,
284: p_x_lines_tbl IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.Ship_Line_Tbl_Type,
285: x_return_status OUT NOCOPY VARCHAR2,
286: x_msg_count OUT NOCOPY NUMBER,
287: x_msg_data OUT NOCOPY VARCHAR2)

Line 284: p_x_lines_tbl IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.Ship_Line_Tbl_Type,

280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: p_module_type IN VARCHAR2 := NULL,
283: p_x_header_rec IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.Ship_Header_Rec_Type,
284: p_x_lines_tbl IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.Ship_Line_Tbl_Type,
285: x_return_status OUT NOCOPY VARCHAR2,
286: x_msg_count OUT NOCOPY NUMBER,
287: x_msg_data OUT NOCOPY VARCHAR2)
288: IS

Line 1549: p_header_rec IN AHL_OSP_SHIPMENT_PUB.SHIP_HEADER_REC_TYPE,

1545: -- Define Local Procedures --
1546: ------------------------------
1547:
1548: PROCEDURE Convert_Header_rec(
1549: p_header_rec IN AHL_OSP_SHIPMENT_PUB.SHIP_HEADER_REC_TYPE,
1550: p_module_type IN VARCHAR2 ,
1551: x_header_rec OUT NOCOPY OE_ORDER_PUB.HEADER_REC_TYPE,
1552: x_header_val_rec OUT NOCOPY OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
1553: IS

Line 1972: p_x_line_tbl IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.SHIP_LINE_TBL_TYPE

1968: PROCEDURE Process_Line_Tbl(
1969: p_osp_order_id IN NUMBER,
1970: p_operation_flag IN VARCHAR,
1971: p_module_type IN VARCHAR2,
1972: p_x_line_tbl IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.SHIP_LINE_TBL_TYPE
1973: ) IS
1974: --
1975: --Commented by mpothuku on 06-Mar-06 to fix the Perf Bug 4919255 as the cursor below is not being used.
1976: /*

Line 3893: PROCEDURE Convert_Line_Tbl(p_line_tbl IN AHL_OSP_SHIPMENT_PUB.SHIP_LINE_TBL_TYPE,

3889: END IF;
3890: END Process_Line_Tbl;
3891:
3892:
3893: PROCEDURE Convert_Line_Tbl(p_line_tbl IN AHL_OSP_SHIPMENT_PUB.SHIP_LINE_TBL_TYPE,
3894: p_module_type IN VARCHAR2 ,
3895: x_line_tbl OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE,
3896: x_line_val_tbl OUT NOCOPY OE_ORDER_PUB.LINE_VAL_TBL_TYPE,
3897: x_lot_serial_tbl OUT NOCOPY OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE,

Line 7406: END AHL_OSP_SHIPMENT_PUB;

7402: p_encoded => fnd_api.g_false);
7403:
7404:
7405: END Process_Osp_SerialNum_Change;
7406: END AHL_OSP_SHIPMENT_PUB;