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: BEGIN
1858: UPDATE mtl_txn_request_lines
1859: SET attribute1 = p_trolin_rec.attribute1
1860: , attribute10 = p_trolin_rec.attribute10

Line 1961: l_trolin_rec inv_move_order_pub.trolin_rec_type;

1957:
1958: -- Procedure Update_Row_Status
1959:
1960: PROCEDURE update_row_status(p_line_id IN NUMBER, p_status IN NUMBER) IS
1961: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1962: BEGIN
1963: l_trolin_rec := inv_trolin_util.query_row(p_line_id);
1964: l_trolin_rec.line_status := p_status;
1965: l_trolin_rec.last_update_date := SYSDATE;

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

1977: END update_row_status;
1978:
1979: -- Procedure Insert_Row
1980:
1981: PROCEDURE insert_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS
1982: BEGIN
1983: INSERT INTO mtl_txn_request_lines
1984: (
1985: attribute1

Line 2193: RETURN inv_move_order_pub.trolin_tbl_type IS

2189:
2190: -- Function Get_Lines
2191:
2192: FUNCTION get_lines(p_header_id IN NUMBER)
2193: RETURN inv_move_order_pub.trolin_tbl_type IS
2194: BEGIN
2195: RETURN query_rows(p_header_id => p_header_id);
2196: END get_lines;
2197:

Line 2201: RETURN inv_move_order_pub.trolin_rec_type IS

2197:
2198: -- Function Query_Row
2199:
2200: FUNCTION query_row(p_line_id IN NUMBER)
2201: RETURN inv_move_order_pub.trolin_rec_type IS
2202: BEGIN
2203: /* inv_debug.message('TRO: in query_row '||to_char(p_line_id)); */
2204: RETURN query_rows(p_line_id => p_line_id)(1);
2205: END query_row;

Line 2212: RETURN inv_move_order_pub.trolin_tbl_type IS

2208:
2209: --
2210:
2211: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num, p_header_id IN NUMBER := fnd_api.g_miss_num)
2212: RETURN inv_move_order_pub.trolin_tbl_type IS
2213: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2214: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2215:
2216: --bug 2569864 - create separate cursors on header_id and line_Id

Line 2213: l_trolin_rec inv_move_order_pub.trolin_rec_type;

2209: --
2210:
2211: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num, p_header_id IN NUMBER := fnd_api.g_miss_num)
2212: RETURN inv_move_order_pub.trolin_tbl_type IS
2213: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2214: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2215:
2216: --bug 2569864 - create separate cursors on header_id and line_Id
2217: CURSOR l_trolin_csr IS

Line 2214: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

2210:
2211: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num, p_header_id IN NUMBER := fnd_api.g_miss_num)
2212: RETURN inv_move_order_pub.trolin_tbl_type IS
2213: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2214: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2215:
2216: --bug 2569864 - create separate cursors on header_id and line_Id
2217: CURSOR l_trolin_csr IS
2218: SELECT attribute1

Line 2637: 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

2633:
2634: -- Procedure lock_Row
2635: --
2636:
2637: 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
2638: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2639: BEGIN
2640: SELECT attribute1
2641: , attribute10

Line 2638: l_trolin_rec inv_move_order_pub.trolin_rec_type;

2634: -- Procedure lock_Row
2635: --
2636:
2637: 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
2638: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2639: BEGIN
2640: SELECT attribute1
2641: , attribute10
2642: , attribute11

Line 3199: 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)

3195: END lock_row;
3196:
3197: -- Function Get_Values
3198:
3199: 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)
3200: RETURN inv_move_order_pub.trolin_val_rec_type IS
3201: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
3202: BEGIN
3203: -- Line2147

Line 3200: RETURN inv_move_order_pub.trolin_val_rec_type IS

3196:
3197: -- Function Get_Values
3198:
3199: 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)
3200: RETURN inv_move_order_pub.trolin_val_rec_type IS
3201: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
3202: BEGIN
3203: -- Line2147
3204: IF p_trolin_rec.from_locator_id IS NOT NULL

Line 3201: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;

3197: -- Function Get_Values
3198:
3199: 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)
3200: RETURN inv_move_order_pub.trolin_val_rec_type IS
3201: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
3202: BEGIN
3203: -- Line2147
3204: IF p_trolin_rec.from_locator_id IS NOT NULL
3205: AND p_trolin_rec.from_locator_id <> fnd_api.g_miss_num

Line 3339: 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)

3335: END get_values;
3336:
3337: -- Function Get_Ids
3338:
3339: 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)
3340: RETURN inv_move_order_pub.trolin_rec_type IS
3341: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3342: BEGIN
3343: -- initialize return_status.

Line 3340: RETURN inv_move_order_pub.trolin_rec_type IS

3336:
3337: -- Function Get_Ids
3338:
3339: 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)
3340: RETURN inv_move_order_pub.trolin_rec_type IS
3341: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3342: BEGIN
3343: -- initialize return_status.
3344:

Line 3341: l_trolin_rec inv_move_order_pub.trolin_rec_type;

3337: -- Function Get_Ids
3338:
3339: 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)
3340: RETURN inv_move_order_pub.trolin_rec_type IS
3341: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3342: BEGIN
3343: -- initialize return_status.
3344:
3345: l_trolin_rec.return_status := fnd_api.g_ret_sts_success;

Line 3729: PROCEDURE insert_mo_lines_bulk(p_new_trolin_tbl IN inv_move_order_pub.trolin_new_tbl_type

3725: END get_ids;
3726:
3727: --Procedure Insert_Mo_Lines_Bulk /* For Parallel Pick-Release */
3728:
3729: PROCEDURE insert_mo_lines_bulk(p_new_trolin_tbl IN inv_move_order_pub.trolin_new_tbl_type
3730: ,x_return_status IN OUT NOCOPY VARCHAR2) IS
3731:
3732: BEGIN
3733: FORALL i IN 1 .. p_new_trolin_tbl.COUNT