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.INV_TROLIN_UTIL dependencies on INV_MOVE_ORDER_PUB

Line 12: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type

8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE clear_dependent_attr(
11: p_attr_id IN NUMBER := fnd_api.g_miss_num
12: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type
13: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec
14: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
15: ) IS
16: l_index NUMBER := 0;

Line 13: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec

9:
10: PROCEDURE clear_dependent_attr(
11: p_attr_id IN NUMBER := fnd_api.g_miss_num
12: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type
13: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec
14: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
15: ) IS
16: l_index NUMBER := 0;
17: l_src_attr_tbl inv_globals.number_tbl_type;

Line 14: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type

10: PROCEDURE clear_dependent_attr(
11: p_attr_id IN NUMBER := fnd_api.g_miss_num
12: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type
13: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec
14: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
15: ) IS
16: l_index NUMBER := 0;
17: l_src_attr_tbl inv_globals.number_tbl_type;
18: l_dep_attr_tbl inv_globals.number_tbl_type;

Line 715: PROCEDURE apply_attribute_changes(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec, x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type) IS

711: END clear_dependent_attr;
712:
713: -- Procedure Apply_Attribute_Changes
714:
715: PROCEDURE apply_attribute_changes(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec, x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type) IS
716: BEGIN
717: -- Load out record
718:
719: x_trolin_rec := p_trolin_rec;

Line 1067: FUNCTION complete_record(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type)

1063: END apply_attribute_changes;
1064:
1065: -- Function Complete_Record
1066:
1067: FUNCTION complete_record(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1068: RETURN inv_move_order_pub.trolin_rec_type IS
1069: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1070: BEGIN
1071: IF l_trolin_rec.attribute1 = fnd_api.g_miss_char THEN

Line 1068: RETURN inv_move_order_pub.trolin_rec_type IS

1064:
1065: -- Function Complete_Record
1066:
1067: FUNCTION complete_record(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1068: RETURN inv_move_order_pub.trolin_rec_type IS
1069: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1070: BEGIN
1071: IF l_trolin_rec.attribute1 = fnd_api.g_miss_char THEN
1072: l_trolin_rec.attribute1 := p_old_trolin_rec.attribute1;

Line 1069: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;

1065: -- Function Complete_Record
1066:
1067: FUNCTION complete_record(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1068: RETURN inv_move_order_pub.trolin_rec_type IS
1069: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1070: BEGIN
1071: IF l_trolin_rec.attribute1 = fnd_api.g_miss_char THEN
1072: l_trolin_rec.attribute1 := p_old_trolin_rec.attribute1;
1073: END IF;

Line 1392: FUNCTION convert_miss_to_null(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)

1388: END complete_record;
1389:
1390: -- Function Convert_Miss_To_Null
1391:
1392: FUNCTION convert_miss_to_null(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1393: RETURN inv_move_order_pub.trolin_rec_type IS
1394: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1395: BEGIN
1396: /*inv_debug.message('in convert');*/

Line 1393: RETURN inv_move_order_pub.trolin_rec_type IS

1389:
1390: -- Function Convert_Miss_To_Null
1391:
1392: FUNCTION convert_miss_to_null(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1393: RETURN inv_move_order_pub.trolin_rec_type IS
1394: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1395: BEGIN
1396: /*inv_debug.message('in convert');*/
1397: IF l_trolin_rec.attribute1 = fnd_api.g_miss_char THEN

Line 1394: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;

1390: -- Function Convert_Miss_To_Null
1391:
1392: FUNCTION convert_miss_to_null(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1393: RETURN inv_move_order_pub.trolin_rec_type IS
1394: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1395: BEGIN
1396: /*inv_debug.message('in convert');*/
1397: IF l_trolin_rec.attribute1 = fnd_api.g_miss_char THEN
1398: l_trolin_rec.attribute1 := NULL;

Line 1692: FUNCTION convert_miss_to_null_parallel(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)

1688: END convert_miss_to_null;
1689:
1690: -- Function Convert_Miss_To_Null_Parallel /*For Parallel Pick-Release*/
1691:
1692: FUNCTION convert_miss_to_null_parallel(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1693: RETURN inv_move_order_pub.trolin_rec_type IS
1694: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1695:
1696: BEGIN

Line 1693: RETURN inv_move_order_pub.trolin_rec_type IS

1689:
1690: -- Function Convert_Miss_To_Null_Parallel /*For Parallel Pick-Release*/
1691:
1692: FUNCTION convert_miss_to_null_parallel(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1693: RETURN inv_move_order_pub.trolin_rec_type IS
1694: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1695:
1696: BEGIN
1697: l_trolin_rec := inv_trolin_util.convert_miss_to_null(p_trolin_rec => l_trolin_rec);

Line 1694: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;

1690: -- Function Convert_Miss_To_Null_Parallel /*For Parallel Pick-Release*/
1691:
1692: FUNCTION convert_miss_to_null_parallel(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)
1693: RETURN inv_move_order_pub.trolin_rec_type IS
1694: l_trolin_rec inv_move_order_pub.trolin_rec_type := p_trolin_rec;
1695:
1696: BEGIN
1697: l_trolin_rec := inv_trolin_util.convert_miss_to_null(p_trolin_rec => l_trolin_rec);
1698:

Line 1775: FUNCTION convert_miss_to_null (p_trolin_val_rec INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE)

1771:
1772: -- Bug#2536932: Function convert_miss_to_null
1773: -- Converts all Miss Number, Char and Date to NULL Values.
1774:
1775: FUNCTION convert_miss_to_null (p_trolin_val_rec INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE)
1776: RETURN INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE IS
1777: l_trolin_val_rec INV_MOVE_ORDER_PUB.trolin_val_rec_type := p_trolin_val_rec;
1778: BEGIN
1779: IF l_trolin_val_rec.from_locator = FND_API.G_MISS_CHAR THEN

Line 1776: RETURN INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE IS

1772: -- Bug#2536932: Function convert_miss_to_null
1773: -- Converts all Miss Number, Char and Date to NULL Values.
1774:
1775: FUNCTION convert_miss_to_null (p_trolin_val_rec INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE)
1776: RETURN INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE IS
1777: l_trolin_val_rec INV_MOVE_ORDER_PUB.trolin_val_rec_type := p_trolin_val_rec;
1778: BEGIN
1779: IF l_trolin_val_rec.from_locator = FND_API.G_MISS_CHAR THEN
1780: l_trolin_val_rec.from_locator := NULL;

Line 1777: l_trolin_val_rec INV_MOVE_ORDER_PUB.trolin_val_rec_type := p_trolin_val_rec;

1773: -- Converts all Miss Number, Char and Date to NULL Values.
1774:
1775: FUNCTION convert_miss_to_null (p_trolin_val_rec INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE)
1776: RETURN INV_MOVE_ORDER_PUB.TROLIN_VAL_REC_TYPE IS
1777: l_trolin_val_rec INV_MOVE_ORDER_PUB.trolin_val_rec_type := p_trolin_val_rec;
1778: BEGIN
1779: IF l_trolin_val_rec.from_locator = FND_API.G_MISS_CHAR THEN
1780: l_trolin_val_rec.from_locator := NULL;
1781: END IF;

Line 1856: PROCEDURE update_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS

1852: END convert_miss_to_null;
1853:
1854: -- Procedure Update_Row
1855:
1856: PROCEDURE update_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS
1857: l_tran_source_typ_id NUMBER := 0;
1858: l_batch_exists NUMBER := 0;
1859:
1860: BEGIN

Line 1996: l_trolin_rec inv_move_order_pub.trolin_rec_type;

1992:
1993: -- Procedure Update_Row_Status
1994:
1995: PROCEDURE update_row_status(p_line_id IN NUMBER, p_status IN NUMBER) IS
1996: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1997: BEGIN
1998: l_trolin_rec := inv_trolin_util.query_row(p_line_id);
1999: l_trolin_rec.line_status := p_status;
2000: l_trolin_rec.last_update_date := SYSDATE;

Line 2016: PROCEDURE insert_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS

2012: END update_row_status;
2013:
2014: -- Procedure Insert_Row
2015:
2016: PROCEDURE insert_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS
2017: BEGIN
2018: INSERT INTO mtl_txn_request_lines
2019: (
2020: attribute1

Line 2228: RETURN inv_move_order_pub.trolin_tbl_type IS

2224:
2225: -- Function Get_Lines
2226:
2227: FUNCTION get_lines(p_header_id IN NUMBER)
2228: RETURN inv_move_order_pub.trolin_tbl_type IS
2229: BEGIN
2230: RETURN query_rows(p_header_id => p_header_id);
2231: END get_lines;
2232:

Line 2236: RETURN inv_move_order_pub.trolin_rec_type IS

2232:
2233: -- Function Query_Row
2234:
2235: FUNCTION query_row(p_line_id IN NUMBER)
2236: RETURN inv_move_order_pub.trolin_rec_type IS
2237: BEGIN
2238: /* inv_debug.message('TRO: in query_row '||to_char(p_line_id)); */
2239: RETURN query_rows(p_line_id => p_line_id)(1);
2240: END query_row;

Line 2247: RETURN inv_move_order_pub.trolin_tbl_type IS

2243:
2244: --
2245:
2246: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num, p_header_id IN NUMBER := fnd_api.g_miss_num)
2247: RETURN inv_move_order_pub.trolin_tbl_type IS
2248: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2249: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2250:
2251: --bug 2569864 - create separate cursors on header_id and line_Id

Line 2248: l_trolin_rec inv_move_order_pub.trolin_rec_type;

2244: --
2245:
2246: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num, p_header_id IN NUMBER := fnd_api.g_miss_num)
2247: RETURN inv_move_order_pub.trolin_tbl_type IS
2248: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2249: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2250:
2251: --bug 2569864 - create separate cursors on header_id and line_Id
2252: CURSOR l_trolin_csr IS

Line 2249: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

2245:
2246: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num, p_header_id IN NUMBER := fnd_api.g_miss_num)
2247: RETURN inv_move_order_pub.trolin_tbl_type IS
2248: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2249: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2250:
2251: --bug 2569864 - create separate cursors on header_id and line_Id
2252: CURSOR l_trolin_csr IS
2253: SELECT attribute1

Line 2672: PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trolin_rec IN inv_move_order_pub.trolin_rec_type, x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type) IS

2668:
2669: -- Procedure lock_Row
2670: --
2671:
2672: PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trolin_rec IN inv_move_order_pub.trolin_rec_type, x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type) IS
2673: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2674: BEGIN
2675: SELECT attribute1
2676: , attribute10

Line 2673: l_trolin_rec inv_move_order_pub.trolin_rec_type;

2669: -- Procedure lock_Row
2670: --
2671:
2672: PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trolin_rec IN inv_move_order_pub.trolin_rec_type, x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type) IS
2673: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2674: BEGIN
2675: SELECT attribute1
2676: , attribute10
2677: , attribute11

Line 3234: FUNCTION get_values(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec)

3230: END lock_row;
3231:
3232: -- Function Get_Values
3233:
3234: FUNCTION get_values(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec)
3235: RETURN inv_move_order_pub.trolin_val_rec_type IS
3236: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
3237: BEGIN
3238: -- Line2147

Line 3235: RETURN inv_move_order_pub.trolin_val_rec_type IS

3231:
3232: -- Function Get_Values
3233:
3234: FUNCTION get_values(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec)
3235: RETURN inv_move_order_pub.trolin_val_rec_type IS
3236: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
3237: BEGIN
3238: -- Line2147
3239: IF p_trolin_rec.from_locator_id IS NOT NULL

Line 3236: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;

3232: -- Function Get_Values
3233:
3234: FUNCTION get_values(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec)
3235: RETURN inv_move_order_pub.trolin_val_rec_type IS
3236: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
3237: BEGIN
3238: -- Line2147
3239: IF p_trolin_rec.from_locator_id IS NOT NULL
3240: AND p_trolin_rec.from_locator_id <> fnd_api.g_miss_num

Line 3374: FUNCTION get_ids(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_trolin_val_rec IN inv_move_order_pub.trolin_val_rec_type)

3370: END get_values;
3371:
3372: -- Function Get_Ids
3373:
3374: FUNCTION get_ids(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_trolin_val_rec IN inv_move_order_pub.trolin_val_rec_type)
3375: RETURN inv_move_order_pub.trolin_rec_type IS
3376: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3377: BEGIN
3378: -- initialize return_status.

Line 3375: RETURN inv_move_order_pub.trolin_rec_type IS

3371:
3372: -- Function Get_Ids
3373:
3374: FUNCTION get_ids(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_trolin_val_rec IN inv_move_order_pub.trolin_val_rec_type)
3375: RETURN inv_move_order_pub.trolin_rec_type IS
3376: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3377: BEGIN
3378: -- initialize return_status.
3379:

Line 3376: l_trolin_rec inv_move_order_pub.trolin_rec_type;

3372: -- Function Get_Ids
3373:
3374: FUNCTION get_ids(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_trolin_val_rec IN inv_move_order_pub.trolin_val_rec_type)
3375: RETURN inv_move_order_pub.trolin_rec_type IS
3376: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3377: BEGIN
3378: -- initialize return_status.
3379:
3380: l_trolin_rec.return_status := fnd_api.g_ret_sts_success;

Line 3764: PROCEDURE insert_mo_lines_bulk(p_new_trolin_tbl IN inv_move_order_pub.trolin_new_tbl_type

3760: END get_ids;
3761:
3762: --Procedure Insert_Mo_Lines_Bulk /* For Parallel Pick-Release */
3763:
3764: PROCEDURE insert_mo_lines_bulk(p_new_trolin_tbl IN inv_move_order_pub.trolin_new_tbl_type
3765: ,x_return_status IN OUT NOCOPY VARCHAR2) IS
3766:
3767: BEGIN
3768: FORALL i IN 1 .. p_new_trolin_tbl.COUNT