44:
45: /* Function Complete_Record */
46:
47: FUNCTION Complete_Record
48: ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
49: , p_old_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
50: ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
51: IS
52: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;
45: /* Function Complete_Record */
46:
47: FUNCTION Complete_Record
48: ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
49: , p_old_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
50: ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
51: IS
52: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;
53: BEGIN
46:
47: FUNCTION Complete_Record
48: ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
49: , p_old_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
50: ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
51: IS
52: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;
53: BEGIN
54:
48: ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
49: , p_old_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
50: ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
51: IS
52: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;
53: BEGIN
54:
55: IF l_mo_hdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN
56: l_mo_hdr_rec.attribute1 := p_old_mo_hdr_rec.attribute1;
210:
211: /* Function Convert_Miss_To_Null */
212:
213: FUNCTION Convert_Miss_To_Null
214: ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
215: ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
216: IS
217: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;
218: BEGIN
211: /* Function Convert_Miss_To_Null */
212:
213: FUNCTION Convert_Miss_To_Null
214: ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
215: ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
216: IS
217: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;
218: BEGIN
219:
213: FUNCTION Convert_Miss_To_Null
214: ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
215: ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
216: IS
217: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;
218: BEGIN
219:
220: IF l_mo_hdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN
221: l_mo_hdr_rec.attribute1 := NULL;
375:
376: /* Procedure Update_Row */
377:
378: PROCEDURE Update_Row
379: ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
380: )
381: IS
382: BEGIN
383:
442:
443: /* Procedure Insert_Row */
444:
445: PROCEDURE Insert_Row
446: ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
447: )
448: IS
449: BEGIN
450:
592: ( p_header_id IN Number,
593: p_status IN Number
594: )
595: IS
596: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;
597: BEGIN
598:
599: /* l_mo_hdr_rec := INV_Trohdr_util.Query_Row( p_header_id ); */
600: l_mo_hdr_rec.header_Status := p_status;
624: /* Function Query_Row */
625:
626: FUNCTION Query_Row
627: ( p_header_id IN NUMBER
628: ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
629: IS
630: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;
631: BEGIN
632:
626: FUNCTION Query_Row
627: ( p_header_id IN NUMBER
628: ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
629: IS
630: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;
631: BEGIN
632:
633: SELECT ATTRIBUTE1
634: , ATTRIBUTE10
732: /* Procedure lock_Row */
733:
734: PROCEDURE Lock_Row
735: ( x_return_status OUT NOCOPY VARCHAR2
736: , p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
737: , x_mo_hdr_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
738: )
739: IS
740: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;
733:
734: PROCEDURE Lock_Row
735: ( x_return_status OUT NOCOPY VARCHAR2
736: , p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
737: , x_mo_hdr_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
738: )
739: IS
740: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;
741: BEGIN
736: , p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
737: , x_mo_hdr_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
738: )
739: IS
740: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;
741: BEGIN
742:
743: SELECT ATTRIBUTE1
744: , ATTRIBUTE10