APPS.GML_GME_API_PVT dependencies on GML_BATCH_SO_ALLOC_HISTORY

Line 100: , gml_batch_so_alloc_history his

96:
97: Cursor get_trans_id (P_batch_trans_id IN NUMBER) IS
98: Select ic.trans_id
99: From ic_tran_pnd ic
100: , gml_batch_so_alloc_history his
101: Where his.batch_trans_id = p_batch_trans_id
102: and his.trans_id = ic.trans_id
103: and ic.line_id = his.line_id
104: and ic.staged_ind = 0

Line 112: , gml_batch_so_alloc_history his

108:
109: Cursor get_total_OMSO (p_gme_trans_id IN NUMBER) IS
110: Select abs(sum(trans_qty)),abs(sum(trans_qty2))
111: From ic_tran_pnd ic
112: , gml_batch_so_alloc_history his
113: Where his.batch_trans_id = p_gme_trans_id
114: and his.trans_id = ic.trans_id
115: and his.delete_mark = 0
116: and ic.delete_mark = 0

Line 122: From gml_batch_so_alloc_history

118: ;
119:
120: Cursor get_history_id (p_gme_trans_id in NUMBER) IS
121: Select alloc_rec_id
122: From gml_batch_so_alloc_history
123: Where batch_trans_id = p_gme_trans_id
124: and delete_mark = 0
125: ;
126:

Line 678: /* update gml_batch_so_alloc_history

674: /* the old trans is deleted and replaced by the new trans
675: * need to update the history table to keep the link alive
676: */
677: /* just do the update */
678: /* update gml_batch_so_alloc_history
679: Set batch_trans_id = l_new_gme_trans_row.trans_id
680: Where batch_trans_id = l_old_gme_trans_row.trans_id
681: and nvl(trans_id,0) <> 0
682: and delete_mark = 0

Line 689: update gml_batch_so_alloc_history

685: -- insert new record with new info
686: IF l_update_history = 1 THEN
687: for his_rec in get_history_id (l_old_gme_trans_row.trans_id) LOOP
688: /* delete the old history record */
689: update gml_batch_so_alloc_history
690: Set delete_mark = 1
691: Where alloc_rec_id = his_rec.alloc_rec_id
692: ;
693: GMI_RESERVATION_UTIL.println(' delete history.alloc_rec_id '||his_rec.alloc_rec_id);