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_TROHDR_UTIL dependencies on INV_MOVE_ORDER_PUB

Line 12: , p_trohdr_rec IN inv_move_order_pub.trohdr_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_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
13: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
14: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
15: ) IS
16: l_index NUMBER := 0;

Line 13: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec

9:
10: PROCEDURE clear_dependent_attr(
11: p_attr_id IN NUMBER := fnd_api.g_miss_num
12: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
13: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
14: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
15: ) IS
16: l_index NUMBER := 0;
17: l_src_attr_tbl inv_globals.number_tbl_type;

Line 14: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

10: PROCEDURE clear_dependent_attr(
11: p_attr_id IN NUMBER := fnd_api.g_miss_num
12: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
13: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
14: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_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 336: PROCEDURE apply_attribute_changes(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type) IS

332: END clear_dependent_attr;
333:
334: -- Procedure Apply_Attribute_Changes
335:
336: PROCEDURE apply_attribute_changes(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type) IS
337: BEGIN
338: -- Load out record
339:
340: x_trohdr_rec := p_trohdr_rec;

Line 497: FUNCTION complete_record(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)

493: END apply_attribute_changes;
494:
495: -- Function Complete_Record
496:
497: FUNCTION complete_record(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
498: RETURN inv_move_order_pub.trohdr_rec_type IS
499: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
500: BEGIN
501: IF l_trohdr_rec.attribute1 = fnd_api.g_miss_char THEN

Line 498: RETURN inv_move_order_pub.trohdr_rec_type IS

494:
495: -- Function Complete_Record
496:
497: FUNCTION complete_record(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
498: RETURN inv_move_order_pub.trohdr_rec_type IS
499: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
500: BEGIN
501: IF l_trohdr_rec.attribute1 = fnd_api.g_miss_char THEN
502: l_trohdr_rec.attribute1 := p_old_trohdr_rec.attribute1;

Line 499: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;

495: -- Function Complete_Record
496:
497: FUNCTION complete_record(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
498: RETURN inv_move_order_pub.trohdr_rec_type IS
499: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
500: BEGIN
501: IF l_trohdr_rec.attribute1 = fnd_api.g_miss_char THEN
502: l_trohdr_rec.attribute1 := p_old_trohdr_rec.attribute1;
503: END IF;

Line 658: FUNCTION convert_miss_to_null(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)

654: END complete_record;
655:
656: -- Function Convert_Miss_To_Null
657:
658: FUNCTION convert_miss_to_null(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
659: RETURN inv_move_order_pub.trohdr_rec_type IS
660: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
661: BEGIN
662: IF l_trohdr_rec.attribute1 = fnd_api.g_miss_char THEN

Line 659: RETURN inv_move_order_pub.trohdr_rec_type IS

655:
656: -- Function Convert_Miss_To_Null
657:
658: FUNCTION convert_miss_to_null(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
659: RETURN inv_move_order_pub.trohdr_rec_type IS
660: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
661: BEGIN
662: IF l_trohdr_rec.attribute1 = fnd_api.g_miss_char THEN
663: l_trohdr_rec.attribute1 := NULL;

Line 660: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;

656: -- Function Convert_Miss_To_Null
657:
658: FUNCTION convert_miss_to_null(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
659: RETURN inv_move_order_pub.trohdr_rec_type IS
660: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
661: BEGIN
662: IF l_trohdr_rec.attribute1 = fnd_api.g_miss_char THEN
663: l_trohdr_rec.attribute1 := NULL;
664: END IF;

Line 819: FUNCTION convert_miss_to_null(p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)

815: END convert_miss_to_null;
816:
817: -- Bug#2536932: Function convert_miss_to_null for TROHDR_VAL_REC_TYPE
818:
819: FUNCTION convert_miss_to_null(p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
820: RETURN inv_move_order_pub.trohdr_val_rec_type IS
821: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type := p_trohdr_val_rec;
822: BEGIN
823: IF l_trohdr_val_rec.from_subinventory = FND_API.g_miss_char THEN

Line 820: RETURN inv_move_order_pub.trohdr_val_rec_type IS

816:
817: -- Bug#2536932: Function convert_miss_to_null for TROHDR_VAL_REC_TYPE
818:
819: FUNCTION convert_miss_to_null(p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
820: RETURN inv_move_order_pub.trohdr_val_rec_type IS
821: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type := p_trohdr_val_rec;
822: BEGIN
823: IF l_trohdr_val_rec.from_subinventory = FND_API.g_miss_char THEN
824: l_trohdr_val_rec.from_subinventory := NULL;

Line 821: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type := p_trohdr_val_rec;

817: -- Bug#2536932: Function convert_miss_to_null for TROHDR_VAL_REC_TYPE
818:
819: FUNCTION convert_miss_to_null(p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
820: RETURN inv_move_order_pub.trohdr_val_rec_type IS
821: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type := p_trohdr_val_rec;
822: BEGIN
823: IF l_trohdr_val_rec.from_subinventory = FND_API.g_miss_char THEN
824: l_trohdr_val_rec.from_subinventory := NULL;
825: END IF;

Line 856: PROCEDURE update_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type) IS

852: END convert_miss_to_null;
853:
854: -- Procedure Update_Row
855:
856: PROCEDURE update_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type) IS
857: BEGIN
858: UPDATE mtl_txn_request_headers
859: SET attribute1 = p_trohdr_rec.attribute1
860: , attribute10 = p_trohdr_rec.attribute10

Line 909: PROCEDURE insert_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type) IS

905: END update_row;
906:
907: -- Procedure Insert_Row
908:
909: PROCEDURE insert_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type) IS
910: BEGIN
911: INSERT INTO mtl_txn_request_headers
912: (
913: attribute1

Line 1021: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

1017:
1018: -- Procedure Update_Row_Status
1019:
1020: PROCEDURE update_row_status(p_header_id IN NUMBER, p_status IN NUMBER) IS
1021: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1022: BEGIN
1023: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id);
1024: l_trohdr_rec.header_status := p_status;
1025: l_trohdr_rec.last_update_date := SYSDATE;

Line 1041: RETURN inv_move_order_pub.trohdr_rec_type IS

1037:
1038: -- Function Query_Row
1039:
1040: FUNCTION query_row(p_header_id IN NUMBER)
1041: RETURN inv_move_order_pub.trohdr_rec_type IS
1042: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1043: BEGIN
1044: SELECT attribute1
1045: , attribute10

Line 1042: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

1038: -- Function Query_Row
1039:
1040: FUNCTION query_row(p_header_id IN NUMBER)
1041: RETURN inv_move_order_pub.trohdr_rec_type IS
1042: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1043: BEGIN
1044: SELECT attribute1
1045: , attribute10
1046: , attribute11

Line 1138: PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type) IS

1134:
1135: -- Procedure lock_Row
1136: --
1137:
1138: PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type) IS
1139: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1140: BEGIN
1141: SELECT attribute1
1142: , attribute10

Line 1139: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

1135: -- Procedure lock_Row
1136: --
1137:
1138: PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type) IS
1139: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1140: BEGIN
1141: SELECT attribute1
1142: , attribute10
1143: , attribute11

Line 1310: FUNCTION get_values(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec)

1306: END lock_row;
1307:
1308: -- Function Get_Values
1309:
1310: FUNCTION get_values(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec)
1311: RETURN inv_move_order_pub.trohdr_val_rec_type IS
1312: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
1313: BEGIN
1314: -- IF p_trohdr_rec.from_subinventory_code IS NOT NULL AND

Line 1311: RETURN inv_move_order_pub.trohdr_val_rec_type IS

1307:
1308: -- Function Get_Values
1309:
1310: FUNCTION get_values(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec)
1311: RETURN inv_move_order_pub.trohdr_val_rec_type IS
1312: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
1313: BEGIN
1314: -- IF p_trohdr_rec.from_subinventory_code IS NOT NULL AND
1315: -- p_trohdr_rec.from_subinventory_code <> FND_API.G_MISS_CHAR AND

Line 1312: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

1308: -- Function Get_Values
1309:
1310: FUNCTION get_values(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec)
1311: RETURN inv_move_order_pub.trohdr_val_rec_type IS
1312: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
1313: BEGIN
1314: -- IF p_trohdr_rec.from_subinventory_code IS NOT NULL AND
1315: -- p_trohdr_rec.from_subinventory_code <> FND_API.G_MISS_CHAR AND
1316: -- NOT INV_GLOBALS.Equal(p_trohdr_rec.from_subinventory_code,

Line 1373: FUNCTION get_ids(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)

1369: END get_values;
1370:
1371: -- Function Get_Ids
1372:
1373: FUNCTION get_ids(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
1374: RETURN inv_move_order_pub.trohdr_rec_type IS
1375: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1376: BEGIN
1377: -- initialize return_status.

Line 1374: RETURN inv_move_order_pub.trohdr_rec_type IS

1370:
1371: -- Function Get_Ids
1372:
1373: FUNCTION get_ids(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
1374: RETURN inv_move_order_pub.trohdr_rec_type IS
1375: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1376: BEGIN
1377: -- initialize return_status.
1378:

Line 1375: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

1371: -- Function Get_Ids
1372:
1373: FUNCTION get_ids(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
1374: RETURN inv_move_order_pub.trohdr_rec_type IS
1375: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1376: BEGIN
1377: -- initialize return_status.
1378:
1379: l_trohdr_rec.return_status := fnd_api.g_ret_sts_success;