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;
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;
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;
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;
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
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;
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;
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
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;
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;
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
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;
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;
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
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
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;
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
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
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
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
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
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
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,
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.
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:
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;