APPS.GMIVDBL dependencies on IC_LOTS_MST

Line 848: FUNCTION ic_lots_mst_insert

844: RETURN FALSE;
845:
846: END ic_item_mst_select;
847:
848: FUNCTION ic_lots_mst_insert
849: (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE, x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)
850: RETURN BOOLEAN
851: IS
852: BEGIN

Line 849: (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE, x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)

845:
846: END ic_item_mst_select;
847:
848: FUNCTION ic_lots_mst_insert
849: (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE, x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)
850: RETURN BOOLEAN
851: IS
852: BEGIN
853:

Line 856: x_ic_lots_mst_row := p_ic_lots_mst_row;

852: BEGIN
853:
854: /* Copy input to output assuming success */
855:
856: x_ic_lots_mst_row := p_ic_lots_mst_row;
857:
858: IF x_ic_lots_mst_row.lot_id IS NULL
859: THEN
860: SELECT gem5_lot_id_s.nextval INTO x_ic_lots_mst_row.lot_id FROM dual;

Line 858: IF x_ic_lots_mst_row.lot_id IS NULL

854: /* Copy input to output assuming success */
855:
856: x_ic_lots_mst_row := p_ic_lots_mst_row;
857:
858: IF x_ic_lots_mst_row.lot_id IS NULL
859: THEN
860: SELECT gem5_lot_id_s.nextval INTO x_ic_lots_mst_row.lot_id FROM dual;
861: END IF;
862:

Line 860: SELECT gem5_lot_id_s.nextval INTO x_ic_lots_mst_row.lot_id FROM dual;

856: x_ic_lots_mst_row := p_ic_lots_mst_row;
857:
858: IF x_ic_lots_mst_row.lot_id IS NULL
859: THEN
860: SELECT gem5_lot_id_s.nextval INTO x_ic_lots_mst_row.lot_id FROM dual;
861: END IF;
862:
863: INSERT INTO ic_lots_mst
864: ( item_id

Line 863: INSERT INTO ic_lots_mst

859: THEN
860: SELECT gem5_lot_id_s.nextval INTO x_ic_lots_mst_row.lot_id FROM dual;
861: END IF;
862:
863: INSERT INTO ic_lots_mst
864: ( item_id
865: , lot_no
866: , sublot_no
867: , lot_id

Line 920: ( x_ic_lots_mst_row.item_id

916: , attribute30
917: , attribute_category
918: )
919: VALUES
920: ( x_ic_lots_mst_row.item_id
921: , x_ic_lots_mst_row.lot_no
922: , x_ic_lots_mst_row.sublot_no
923: , x_ic_lots_mst_row.lot_id
924: , x_ic_lots_mst_row.lot_desc

Line 921: , x_ic_lots_mst_row.lot_no

917: , attribute_category
918: )
919: VALUES
920: ( x_ic_lots_mst_row.item_id
921: , x_ic_lots_mst_row.lot_no
922: , x_ic_lots_mst_row.sublot_no
923: , x_ic_lots_mst_row.lot_id
924: , x_ic_lots_mst_row.lot_desc
925: , x_ic_lots_mst_row.qc_grade

Line 922: , x_ic_lots_mst_row.sublot_no

918: )
919: VALUES
920: ( x_ic_lots_mst_row.item_id
921: , x_ic_lots_mst_row.lot_no
922: , x_ic_lots_mst_row.sublot_no
923: , x_ic_lots_mst_row.lot_id
924: , x_ic_lots_mst_row.lot_desc
925: , x_ic_lots_mst_row.qc_grade
926: , x_ic_lots_mst_row.expaction_code

Line 923: , x_ic_lots_mst_row.lot_id

919: VALUES
920: ( x_ic_lots_mst_row.item_id
921: , x_ic_lots_mst_row.lot_no
922: , x_ic_lots_mst_row.sublot_no
923: , x_ic_lots_mst_row.lot_id
924: , x_ic_lots_mst_row.lot_desc
925: , x_ic_lots_mst_row.qc_grade
926: , x_ic_lots_mst_row.expaction_code
927: , x_ic_lots_mst_row.expaction_date

Line 924: , x_ic_lots_mst_row.lot_desc

920: ( x_ic_lots_mst_row.item_id
921: , x_ic_lots_mst_row.lot_no
922: , x_ic_lots_mst_row.sublot_no
923: , x_ic_lots_mst_row.lot_id
924: , x_ic_lots_mst_row.lot_desc
925: , x_ic_lots_mst_row.qc_grade
926: , x_ic_lots_mst_row.expaction_code
927: , x_ic_lots_mst_row.expaction_date
928: , x_ic_lots_mst_row.lot_created

Line 925: , x_ic_lots_mst_row.qc_grade

921: , x_ic_lots_mst_row.lot_no
922: , x_ic_lots_mst_row.sublot_no
923: , x_ic_lots_mst_row.lot_id
924: , x_ic_lots_mst_row.lot_desc
925: , x_ic_lots_mst_row.qc_grade
926: , x_ic_lots_mst_row.expaction_code
927: , x_ic_lots_mst_row.expaction_date
928: , x_ic_lots_mst_row.lot_created
929: , x_ic_lots_mst_row.expire_date

Line 926: , x_ic_lots_mst_row.expaction_code

922: , x_ic_lots_mst_row.sublot_no
923: , x_ic_lots_mst_row.lot_id
924: , x_ic_lots_mst_row.lot_desc
925: , x_ic_lots_mst_row.qc_grade
926: , x_ic_lots_mst_row.expaction_code
927: , x_ic_lots_mst_row.expaction_date
928: , x_ic_lots_mst_row.lot_created
929: , x_ic_lots_mst_row.expire_date
930: , x_ic_lots_mst_row.retest_date

Line 927: , x_ic_lots_mst_row.expaction_date

923: , x_ic_lots_mst_row.lot_id
924: , x_ic_lots_mst_row.lot_desc
925: , x_ic_lots_mst_row.qc_grade
926: , x_ic_lots_mst_row.expaction_code
927: , x_ic_lots_mst_row.expaction_date
928: , x_ic_lots_mst_row.lot_created
929: , x_ic_lots_mst_row.expire_date
930: , x_ic_lots_mst_row.retest_date
931: , x_ic_lots_mst_row.strength

Line 928: , x_ic_lots_mst_row.lot_created

924: , x_ic_lots_mst_row.lot_desc
925: , x_ic_lots_mst_row.qc_grade
926: , x_ic_lots_mst_row.expaction_code
927: , x_ic_lots_mst_row.expaction_date
928: , x_ic_lots_mst_row.lot_created
929: , x_ic_lots_mst_row.expire_date
930: , x_ic_lots_mst_row.retest_date
931: , x_ic_lots_mst_row.strength
932: , x_ic_lots_mst_row.inactive_ind

Line 929: , x_ic_lots_mst_row.expire_date

925: , x_ic_lots_mst_row.qc_grade
926: , x_ic_lots_mst_row.expaction_code
927: , x_ic_lots_mst_row.expaction_date
928: , x_ic_lots_mst_row.lot_created
929: , x_ic_lots_mst_row.expire_date
930: , x_ic_lots_mst_row.retest_date
931: , x_ic_lots_mst_row.strength
932: , x_ic_lots_mst_row.inactive_ind
933: , x_ic_lots_mst_row.origination_type

Line 930: , x_ic_lots_mst_row.retest_date

926: , x_ic_lots_mst_row.expaction_code
927: , x_ic_lots_mst_row.expaction_date
928: , x_ic_lots_mst_row.lot_created
929: , x_ic_lots_mst_row.expire_date
930: , x_ic_lots_mst_row.retest_date
931: , x_ic_lots_mst_row.strength
932: , x_ic_lots_mst_row.inactive_ind
933: , x_ic_lots_mst_row.origination_type
934: , x_ic_lots_mst_row.shipvend_id

Line 931: , x_ic_lots_mst_row.strength

927: , x_ic_lots_mst_row.expaction_date
928: , x_ic_lots_mst_row.lot_created
929: , x_ic_lots_mst_row.expire_date
930: , x_ic_lots_mst_row.retest_date
931: , x_ic_lots_mst_row.strength
932: , x_ic_lots_mst_row.inactive_ind
933: , x_ic_lots_mst_row.origination_type
934: , x_ic_lots_mst_row.shipvend_id
935: , x_ic_lots_mst_row.vendor_lot_no

Line 932: , x_ic_lots_mst_row.inactive_ind

928: , x_ic_lots_mst_row.lot_created
929: , x_ic_lots_mst_row.expire_date
930: , x_ic_lots_mst_row.retest_date
931: , x_ic_lots_mst_row.strength
932: , x_ic_lots_mst_row.inactive_ind
933: , x_ic_lots_mst_row.origination_type
934: , x_ic_lots_mst_row.shipvend_id
935: , x_ic_lots_mst_row.vendor_lot_no
936: , x_ic_lots_mst_row.creation_date

Line 933: , x_ic_lots_mst_row.origination_type

929: , x_ic_lots_mst_row.expire_date
930: , x_ic_lots_mst_row.retest_date
931: , x_ic_lots_mst_row.strength
932: , x_ic_lots_mst_row.inactive_ind
933: , x_ic_lots_mst_row.origination_type
934: , x_ic_lots_mst_row.shipvend_id
935: , x_ic_lots_mst_row.vendor_lot_no
936: , x_ic_lots_mst_row.creation_date
937: , x_ic_lots_mst_row.last_update_date

Line 934: , x_ic_lots_mst_row.shipvend_id

930: , x_ic_lots_mst_row.retest_date
931: , x_ic_lots_mst_row.strength
932: , x_ic_lots_mst_row.inactive_ind
933: , x_ic_lots_mst_row.origination_type
934: , x_ic_lots_mst_row.shipvend_id
935: , x_ic_lots_mst_row.vendor_lot_no
936: , x_ic_lots_mst_row.creation_date
937: , x_ic_lots_mst_row.last_update_date
938: , x_ic_lots_mst_row.created_by

Line 935: , x_ic_lots_mst_row.vendor_lot_no

931: , x_ic_lots_mst_row.strength
932: , x_ic_lots_mst_row.inactive_ind
933: , x_ic_lots_mst_row.origination_type
934: , x_ic_lots_mst_row.shipvend_id
935: , x_ic_lots_mst_row.vendor_lot_no
936: , x_ic_lots_mst_row.creation_date
937: , x_ic_lots_mst_row.last_update_date
938: , x_ic_lots_mst_row.created_by
939: , x_ic_lots_mst_row.last_updated_by

Line 936: , x_ic_lots_mst_row.creation_date

932: , x_ic_lots_mst_row.inactive_ind
933: , x_ic_lots_mst_row.origination_type
934: , x_ic_lots_mst_row.shipvend_id
935: , x_ic_lots_mst_row.vendor_lot_no
936: , x_ic_lots_mst_row.creation_date
937: , x_ic_lots_mst_row.last_update_date
938: , x_ic_lots_mst_row.created_by
939: , x_ic_lots_mst_row.last_updated_by
940: , x_ic_lots_mst_row.trans_cnt

Line 937: , x_ic_lots_mst_row.last_update_date

933: , x_ic_lots_mst_row.origination_type
934: , x_ic_lots_mst_row.shipvend_id
935: , x_ic_lots_mst_row.vendor_lot_no
936: , x_ic_lots_mst_row.creation_date
937: , x_ic_lots_mst_row.last_update_date
938: , x_ic_lots_mst_row.created_by
939: , x_ic_lots_mst_row.last_updated_by
940: , x_ic_lots_mst_row.trans_cnt
941: , x_ic_lots_mst_row.delete_mark

Line 938: , x_ic_lots_mst_row.created_by

934: , x_ic_lots_mst_row.shipvend_id
935: , x_ic_lots_mst_row.vendor_lot_no
936: , x_ic_lots_mst_row.creation_date
937: , x_ic_lots_mst_row.last_update_date
938: , x_ic_lots_mst_row.created_by
939: , x_ic_lots_mst_row.last_updated_by
940: , x_ic_lots_mst_row.trans_cnt
941: , x_ic_lots_mst_row.delete_mark
942: , x_ic_lots_mst_row.text_code

Line 939: , x_ic_lots_mst_row.last_updated_by

935: , x_ic_lots_mst_row.vendor_lot_no
936: , x_ic_lots_mst_row.creation_date
937: , x_ic_lots_mst_row.last_update_date
938: , x_ic_lots_mst_row.created_by
939: , x_ic_lots_mst_row.last_updated_by
940: , x_ic_lots_mst_row.trans_cnt
941: , x_ic_lots_mst_row.delete_mark
942: , x_ic_lots_mst_row.text_code
943: , x_ic_lots_mst_row.attribute1

Line 940: , x_ic_lots_mst_row.trans_cnt

936: , x_ic_lots_mst_row.creation_date
937: , x_ic_lots_mst_row.last_update_date
938: , x_ic_lots_mst_row.created_by
939: , x_ic_lots_mst_row.last_updated_by
940: , x_ic_lots_mst_row.trans_cnt
941: , x_ic_lots_mst_row.delete_mark
942: , x_ic_lots_mst_row.text_code
943: , x_ic_lots_mst_row.attribute1
944: , x_ic_lots_mst_row.attribute2

Line 941: , x_ic_lots_mst_row.delete_mark

937: , x_ic_lots_mst_row.last_update_date
938: , x_ic_lots_mst_row.created_by
939: , x_ic_lots_mst_row.last_updated_by
940: , x_ic_lots_mst_row.trans_cnt
941: , x_ic_lots_mst_row.delete_mark
942: , x_ic_lots_mst_row.text_code
943: , x_ic_lots_mst_row.attribute1
944: , x_ic_lots_mst_row.attribute2
945: , x_ic_lots_mst_row.attribute3

Line 942: , x_ic_lots_mst_row.text_code

938: , x_ic_lots_mst_row.created_by
939: , x_ic_lots_mst_row.last_updated_by
940: , x_ic_lots_mst_row.trans_cnt
941: , x_ic_lots_mst_row.delete_mark
942: , x_ic_lots_mst_row.text_code
943: , x_ic_lots_mst_row.attribute1
944: , x_ic_lots_mst_row.attribute2
945: , x_ic_lots_mst_row.attribute3
946: , x_ic_lots_mst_row.attribute4

Line 943: , x_ic_lots_mst_row.attribute1

939: , x_ic_lots_mst_row.last_updated_by
940: , x_ic_lots_mst_row.trans_cnt
941: , x_ic_lots_mst_row.delete_mark
942: , x_ic_lots_mst_row.text_code
943: , x_ic_lots_mst_row.attribute1
944: , x_ic_lots_mst_row.attribute2
945: , x_ic_lots_mst_row.attribute3
946: , x_ic_lots_mst_row.attribute4
947: , x_ic_lots_mst_row.attribute5

Line 944: , x_ic_lots_mst_row.attribute2

940: , x_ic_lots_mst_row.trans_cnt
941: , x_ic_lots_mst_row.delete_mark
942: , x_ic_lots_mst_row.text_code
943: , x_ic_lots_mst_row.attribute1
944: , x_ic_lots_mst_row.attribute2
945: , x_ic_lots_mst_row.attribute3
946: , x_ic_lots_mst_row.attribute4
947: , x_ic_lots_mst_row.attribute5
948: , x_ic_lots_mst_row.attribute6

Line 945: , x_ic_lots_mst_row.attribute3

941: , x_ic_lots_mst_row.delete_mark
942: , x_ic_lots_mst_row.text_code
943: , x_ic_lots_mst_row.attribute1
944: , x_ic_lots_mst_row.attribute2
945: , x_ic_lots_mst_row.attribute3
946: , x_ic_lots_mst_row.attribute4
947: , x_ic_lots_mst_row.attribute5
948: , x_ic_lots_mst_row.attribute6
949: , x_ic_lots_mst_row.attribute7

Line 946: , x_ic_lots_mst_row.attribute4

942: , x_ic_lots_mst_row.text_code
943: , x_ic_lots_mst_row.attribute1
944: , x_ic_lots_mst_row.attribute2
945: , x_ic_lots_mst_row.attribute3
946: , x_ic_lots_mst_row.attribute4
947: , x_ic_lots_mst_row.attribute5
948: , x_ic_lots_mst_row.attribute6
949: , x_ic_lots_mst_row.attribute7
950: , x_ic_lots_mst_row.attribute8

Line 947: , x_ic_lots_mst_row.attribute5

943: , x_ic_lots_mst_row.attribute1
944: , x_ic_lots_mst_row.attribute2
945: , x_ic_lots_mst_row.attribute3
946: , x_ic_lots_mst_row.attribute4
947: , x_ic_lots_mst_row.attribute5
948: , x_ic_lots_mst_row.attribute6
949: , x_ic_lots_mst_row.attribute7
950: , x_ic_lots_mst_row.attribute8
951: , x_ic_lots_mst_row.attribute9

Line 948: , x_ic_lots_mst_row.attribute6

944: , x_ic_lots_mst_row.attribute2
945: , x_ic_lots_mst_row.attribute3
946: , x_ic_lots_mst_row.attribute4
947: , x_ic_lots_mst_row.attribute5
948: , x_ic_lots_mst_row.attribute6
949: , x_ic_lots_mst_row.attribute7
950: , x_ic_lots_mst_row.attribute8
951: , x_ic_lots_mst_row.attribute9
952: , x_ic_lots_mst_row.attribute10

Line 949: , x_ic_lots_mst_row.attribute7

945: , x_ic_lots_mst_row.attribute3
946: , x_ic_lots_mst_row.attribute4
947: , x_ic_lots_mst_row.attribute5
948: , x_ic_lots_mst_row.attribute6
949: , x_ic_lots_mst_row.attribute7
950: , x_ic_lots_mst_row.attribute8
951: , x_ic_lots_mst_row.attribute9
952: , x_ic_lots_mst_row.attribute10
953: , x_ic_lots_mst_row.attribute11

Line 950: , x_ic_lots_mst_row.attribute8

946: , x_ic_lots_mst_row.attribute4
947: , x_ic_lots_mst_row.attribute5
948: , x_ic_lots_mst_row.attribute6
949: , x_ic_lots_mst_row.attribute7
950: , x_ic_lots_mst_row.attribute8
951: , x_ic_lots_mst_row.attribute9
952: , x_ic_lots_mst_row.attribute10
953: , x_ic_lots_mst_row.attribute11
954: , x_ic_lots_mst_row.attribute12

Line 951: , x_ic_lots_mst_row.attribute9

947: , x_ic_lots_mst_row.attribute5
948: , x_ic_lots_mst_row.attribute6
949: , x_ic_lots_mst_row.attribute7
950: , x_ic_lots_mst_row.attribute8
951: , x_ic_lots_mst_row.attribute9
952: , x_ic_lots_mst_row.attribute10
953: , x_ic_lots_mst_row.attribute11
954: , x_ic_lots_mst_row.attribute12
955: , x_ic_lots_mst_row.attribute13

Line 952: , x_ic_lots_mst_row.attribute10

948: , x_ic_lots_mst_row.attribute6
949: , x_ic_lots_mst_row.attribute7
950: , x_ic_lots_mst_row.attribute8
951: , x_ic_lots_mst_row.attribute9
952: , x_ic_lots_mst_row.attribute10
953: , x_ic_lots_mst_row.attribute11
954: , x_ic_lots_mst_row.attribute12
955: , x_ic_lots_mst_row.attribute13
956: , x_ic_lots_mst_row.attribute14

Line 953: , x_ic_lots_mst_row.attribute11

949: , x_ic_lots_mst_row.attribute7
950: , x_ic_lots_mst_row.attribute8
951: , x_ic_lots_mst_row.attribute9
952: , x_ic_lots_mst_row.attribute10
953: , x_ic_lots_mst_row.attribute11
954: , x_ic_lots_mst_row.attribute12
955: , x_ic_lots_mst_row.attribute13
956: , x_ic_lots_mst_row.attribute14
957: , x_ic_lots_mst_row.attribute15

Line 954: , x_ic_lots_mst_row.attribute12

950: , x_ic_lots_mst_row.attribute8
951: , x_ic_lots_mst_row.attribute9
952: , x_ic_lots_mst_row.attribute10
953: , x_ic_lots_mst_row.attribute11
954: , x_ic_lots_mst_row.attribute12
955: , x_ic_lots_mst_row.attribute13
956: , x_ic_lots_mst_row.attribute14
957: , x_ic_lots_mst_row.attribute15
958: , x_ic_lots_mst_row.attribute16

Line 955: , x_ic_lots_mst_row.attribute13

951: , x_ic_lots_mst_row.attribute9
952: , x_ic_lots_mst_row.attribute10
953: , x_ic_lots_mst_row.attribute11
954: , x_ic_lots_mst_row.attribute12
955: , x_ic_lots_mst_row.attribute13
956: , x_ic_lots_mst_row.attribute14
957: , x_ic_lots_mst_row.attribute15
958: , x_ic_lots_mst_row.attribute16
959: , x_ic_lots_mst_row.attribute17

Line 956: , x_ic_lots_mst_row.attribute14

952: , x_ic_lots_mst_row.attribute10
953: , x_ic_lots_mst_row.attribute11
954: , x_ic_lots_mst_row.attribute12
955: , x_ic_lots_mst_row.attribute13
956: , x_ic_lots_mst_row.attribute14
957: , x_ic_lots_mst_row.attribute15
958: , x_ic_lots_mst_row.attribute16
959: , x_ic_lots_mst_row.attribute17
960: , x_ic_lots_mst_row.attribute18

Line 957: , x_ic_lots_mst_row.attribute15

953: , x_ic_lots_mst_row.attribute11
954: , x_ic_lots_mst_row.attribute12
955: , x_ic_lots_mst_row.attribute13
956: , x_ic_lots_mst_row.attribute14
957: , x_ic_lots_mst_row.attribute15
958: , x_ic_lots_mst_row.attribute16
959: , x_ic_lots_mst_row.attribute17
960: , x_ic_lots_mst_row.attribute18
961: , x_ic_lots_mst_row.attribute19

Line 958: , x_ic_lots_mst_row.attribute16

954: , x_ic_lots_mst_row.attribute12
955: , x_ic_lots_mst_row.attribute13
956: , x_ic_lots_mst_row.attribute14
957: , x_ic_lots_mst_row.attribute15
958: , x_ic_lots_mst_row.attribute16
959: , x_ic_lots_mst_row.attribute17
960: , x_ic_lots_mst_row.attribute18
961: , x_ic_lots_mst_row.attribute19
962: , x_ic_lots_mst_row.attribute20

Line 959: , x_ic_lots_mst_row.attribute17

955: , x_ic_lots_mst_row.attribute13
956: , x_ic_lots_mst_row.attribute14
957: , x_ic_lots_mst_row.attribute15
958: , x_ic_lots_mst_row.attribute16
959: , x_ic_lots_mst_row.attribute17
960: , x_ic_lots_mst_row.attribute18
961: , x_ic_lots_mst_row.attribute19
962: , x_ic_lots_mst_row.attribute20
963: , x_ic_lots_mst_row.attribute21

Line 960: , x_ic_lots_mst_row.attribute18

956: , x_ic_lots_mst_row.attribute14
957: , x_ic_lots_mst_row.attribute15
958: , x_ic_lots_mst_row.attribute16
959: , x_ic_lots_mst_row.attribute17
960: , x_ic_lots_mst_row.attribute18
961: , x_ic_lots_mst_row.attribute19
962: , x_ic_lots_mst_row.attribute20
963: , x_ic_lots_mst_row.attribute21
964: , x_ic_lots_mst_row.attribute22

Line 961: , x_ic_lots_mst_row.attribute19

957: , x_ic_lots_mst_row.attribute15
958: , x_ic_lots_mst_row.attribute16
959: , x_ic_lots_mst_row.attribute17
960: , x_ic_lots_mst_row.attribute18
961: , x_ic_lots_mst_row.attribute19
962: , x_ic_lots_mst_row.attribute20
963: , x_ic_lots_mst_row.attribute21
964: , x_ic_lots_mst_row.attribute22
965: , x_ic_lots_mst_row.attribute23

Line 962: , x_ic_lots_mst_row.attribute20

958: , x_ic_lots_mst_row.attribute16
959: , x_ic_lots_mst_row.attribute17
960: , x_ic_lots_mst_row.attribute18
961: , x_ic_lots_mst_row.attribute19
962: , x_ic_lots_mst_row.attribute20
963: , x_ic_lots_mst_row.attribute21
964: , x_ic_lots_mst_row.attribute22
965: , x_ic_lots_mst_row.attribute23
966: , x_ic_lots_mst_row.attribute24

Line 963: , x_ic_lots_mst_row.attribute21

959: , x_ic_lots_mst_row.attribute17
960: , x_ic_lots_mst_row.attribute18
961: , x_ic_lots_mst_row.attribute19
962: , x_ic_lots_mst_row.attribute20
963: , x_ic_lots_mst_row.attribute21
964: , x_ic_lots_mst_row.attribute22
965: , x_ic_lots_mst_row.attribute23
966: , x_ic_lots_mst_row.attribute24
967: , x_ic_lots_mst_row.attribute25

Line 964: , x_ic_lots_mst_row.attribute22

960: , x_ic_lots_mst_row.attribute18
961: , x_ic_lots_mst_row.attribute19
962: , x_ic_lots_mst_row.attribute20
963: , x_ic_lots_mst_row.attribute21
964: , x_ic_lots_mst_row.attribute22
965: , x_ic_lots_mst_row.attribute23
966: , x_ic_lots_mst_row.attribute24
967: , x_ic_lots_mst_row.attribute25
968: , x_ic_lots_mst_row.attribute26

Line 965: , x_ic_lots_mst_row.attribute23

961: , x_ic_lots_mst_row.attribute19
962: , x_ic_lots_mst_row.attribute20
963: , x_ic_lots_mst_row.attribute21
964: , x_ic_lots_mst_row.attribute22
965: , x_ic_lots_mst_row.attribute23
966: , x_ic_lots_mst_row.attribute24
967: , x_ic_lots_mst_row.attribute25
968: , x_ic_lots_mst_row.attribute26
969: , x_ic_lots_mst_row.attribute27

Line 966: , x_ic_lots_mst_row.attribute24

962: , x_ic_lots_mst_row.attribute20
963: , x_ic_lots_mst_row.attribute21
964: , x_ic_lots_mst_row.attribute22
965: , x_ic_lots_mst_row.attribute23
966: , x_ic_lots_mst_row.attribute24
967: , x_ic_lots_mst_row.attribute25
968: , x_ic_lots_mst_row.attribute26
969: , x_ic_lots_mst_row.attribute27
970: , x_ic_lots_mst_row.attribute28

Line 967: , x_ic_lots_mst_row.attribute25

963: , x_ic_lots_mst_row.attribute21
964: , x_ic_lots_mst_row.attribute22
965: , x_ic_lots_mst_row.attribute23
966: , x_ic_lots_mst_row.attribute24
967: , x_ic_lots_mst_row.attribute25
968: , x_ic_lots_mst_row.attribute26
969: , x_ic_lots_mst_row.attribute27
970: , x_ic_lots_mst_row.attribute28
971: , x_ic_lots_mst_row.attribute29

Line 968: , x_ic_lots_mst_row.attribute26

964: , x_ic_lots_mst_row.attribute22
965: , x_ic_lots_mst_row.attribute23
966: , x_ic_lots_mst_row.attribute24
967: , x_ic_lots_mst_row.attribute25
968: , x_ic_lots_mst_row.attribute26
969: , x_ic_lots_mst_row.attribute27
970: , x_ic_lots_mst_row.attribute28
971: , x_ic_lots_mst_row.attribute29
972: , x_ic_lots_mst_row.attribute30

Line 969: , x_ic_lots_mst_row.attribute27

965: , x_ic_lots_mst_row.attribute23
966: , x_ic_lots_mst_row.attribute24
967: , x_ic_lots_mst_row.attribute25
968: , x_ic_lots_mst_row.attribute26
969: , x_ic_lots_mst_row.attribute27
970: , x_ic_lots_mst_row.attribute28
971: , x_ic_lots_mst_row.attribute29
972: , x_ic_lots_mst_row.attribute30
973: , x_ic_lots_mst_row.attribute_category

Line 970: , x_ic_lots_mst_row.attribute28

966: , x_ic_lots_mst_row.attribute24
967: , x_ic_lots_mst_row.attribute25
968: , x_ic_lots_mst_row.attribute26
969: , x_ic_lots_mst_row.attribute27
970: , x_ic_lots_mst_row.attribute28
971: , x_ic_lots_mst_row.attribute29
972: , x_ic_lots_mst_row.attribute30
973: , x_ic_lots_mst_row.attribute_category
974: );

Line 971: , x_ic_lots_mst_row.attribute29

967: , x_ic_lots_mst_row.attribute25
968: , x_ic_lots_mst_row.attribute26
969: , x_ic_lots_mst_row.attribute27
970: , x_ic_lots_mst_row.attribute28
971: , x_ic_lots_mst_row.attribute29
972: , x_ic_lots_mst_row.attribute30
973: , x_ic_lots_mst_row.attribute_category
974: );
975:

Line 972: , x_ic_lots_mst_row.attribute30

968: , x_ic_lots_mst_row.attribute26
969: , x_ic_lots_mst_row.attribute27
970: , x_ic_lots_mst_row.attribute28
971: , x_ic_lots_mst_row.attribute29
972: , x_ic_lots_mst_row.attribute30
973: , x_ic_lots_mst_row.attribute_category
974: );
975:
976: GMIGUTL.DB_ERRNUM := NULL;

Line 973: , x_ic_lots_mst_row.attribute_category

969: , x_ic_lots_mst_row.attribute27
970: , x_ic_lots_mst_row.attribute28
971: , x_ic_lots_mst_row.attribute29
972: , x_ic_lots_mst_row.attribute30
973: , x_ic_lots_mst_row.attribute_category
974: );
975:
976: GMIGUTL.DB_ERRNUM := NULL;
977: RETURN TRUE;

Line 990: END ic_lots_mst_insert;

986:
987: GMIGUTL.DB_ERRNUM := SQLCODE;
988: GMIGUTL.DB_ERRMSG:= SQLERRM;
989: RETURN FALSE;
990: END ic_lots_mst_insert;
991:
992: FUNCTION ic_lots_mst_select
993: (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE, x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)
994: RETURN BOOLEAN

Line 992: FUNCTION ic_lots_mst_select

988: GMIGUTL.DB_ERRMSG:= SQLERRM;
989: RETURN FALSE;
990: END ic_lots_mst_insert;
991:
992: FUNCTION ic_lots_mst_select
993: (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE, x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)
994: RETURN BOOLEAN
995: IS
996: BEGIN

Line 993: (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE, x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)

989: RETURN FALSE;
990: END ic_lots_mst_insert;
991:
992: FUNCTION ic_lots_mst_select
993: (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE, x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)
994: RETURN BOOLEAN
995: IS
996: BEGIN
997: SELECT * INTO x_ic_lots_mst_row FROM ic_lots_mst

Line 997: SELECT * INTO x_ic_lots_mst_row FROM ic_lots_mst

993: (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE, x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)
994: RETURN BOOLEAN
995: IS
996: BEGIN
997: SELECT * INTO x_ic_lots_mst_row FROM ic_lots_mst
998: WHERE item_id = p_ic_lots_mst_row.item_id AND
999: lot_no = p_ic_lots_mst_row.lot_no AND
1000: NVL(sublot_no,' ')=NVL(p_ic_lots_mst_row.sublot_no,' ');
1001: GMIGUTL.DB_ERRNUM := NULL;

Line 998: WHERE item_id = p_ic_lots_mst_row.item_id AND

994: RETURN BOOLEAN
995: IS
996: BEGIN
997: SELECT * INTO x_ic_lots_mst_row FROM ic_lots_mst
998: WHERE item_id = p_ic_lots_mst_row.item_id AND
999: lot_no = p_ic_lots_mst_row.lot_no AND
1000: NVL(sublot_no,' ')=NVL(p_ic_lots_mst_row.sublot_no,' ');
1001: GMIGUTL.DB_ERRNUM := NULL;
1002: RETURN TRUE;

Line 999: lot_no = p_ic_lots_mst_row.lot_no AND

995: IS
996: BEGIN
997: SELECT * INTO x_ic_lots_mst_row FROM ic_lots_mst
998: WHERE item_id = p_ic_lots_mst_row.item_id AND
999: lot_no = p_ic_lots_mst_row.lot_no AND
1000: NVL(sublot_no,' ')=NVL(p_ic_lots_mst_row.sublot_no,' ');
1001: GMIGUTL.DB_ERRNUM := NULL;
1002: RETURN TRUE;
1003:

Line 1000: NVL(sublot_no,' ')=NVL(p_ic_lots_mst_row.sublot_no,' ');

996: BEGIN
997: SELECT * INTO x_ic_lots_mst_row FROM ic_lots_mst
998: WHERE item_id = p_ic_lots_mst_row.item_id AND
999: lot_no = p_ic_lots_mst_row.lot_no AND
1000: NVL(sublot_no,' ')=NVL(p_ic_lots_mst_row.sublot_no,' ');
1001: GMIGUTL.DB_ERRNUM := NULL;
1002: RETURN TRUE;
1003:
1004: EXCEPTION

Line 1024: END ic_lots_mst_select;

1020:
1021: GMIGUTL.DB_ERRNUM := SQLCODE;
1022: GMIGUTL.DB_ERRMSG:= SQLERRM;
1023: RETURN FALSE;
1024: END ic_lots_mst_select;
1025:
1026: FUNCTION ic_item_cpg_insert
1027: (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE, x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)
1028: RETURN BOOLEAN