APPS.DPP_EXECUTIONDETAILS_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 115: UPDATE dpp_transaction_lines_all

111:
112: FOR i IN l_status_Update_tbl.FIRST..l_status_Update_tbl.LAST
113: LOOP
114: IF l_process_code = 'UPDTPO' THEN
115: UPDATE dpp_transaction_lines_all
116: SET UPDATE_PURCHASING_DOCS = l_status_Update_tbl(i).Update_Status
117: ,object_version_number = object_version_number + 1
118: ,last_update_date = sysdate
119: ,last_updated_by = l_exe_update_rec.Last_Updated_By

Line 124: UPDATE dpp_transaction_lines_all

120: WHERE transaction_header_id = l_EXE_UPDATE_rec.Transaction_Header_ID
121: AND transaction_line_id = l_status_Update_tbl(i).transaction_line_id;
122:
123: ELSIF l_process_code = 'NTFYPO' THEN
124: UPDATE dpp_transaction_lines_all
125: SET NOTIFY_PURCHASING_DOCS = l_status_Update_tbl(i).Update_Status
126: ,object_version_number = object_version_number + 1
127: ,last_update_date = sysdate
128: ,last_updated_by = l_exe_update_rec.Last_Updated_By

Line 133: UPDATE dpp_transaction_lines_all

129: WHERE transaction_header_id = l_EXE_UPDATE_rec.Transaction_Header_ID
130: AND transaction_line_id = l_status_Update_tbl(i).transaction_line_id;
131:
132: ELSIF l_process_code = 'INVC' THEN
133: UPDATE dpp_transaction_lines_all
134: SET UPDATE_INVENTORY_COSTING = l_status_Update_tbl(i).Update_Status
135: ,object_version_number = object_version_number + 1
136: ,last_update_date = sysdate
137: ,last_updated_by = l_exe_update_rec.Last_Updated_By

Line 142: UPDATE dpp_transaction_lines_all

138: WHERE transaction_header_id = l_EXE_UPDATE_rec.Transaction_Header_ID
139: AND transaction_line_id = l_status_Update_tbl(i).transaction_line_id;
140:
141: ELSIF l_process_code = 'UPDTLP' THEN
142: UPDATE dpp_transaction_lines_all
143: SET UPDATE_ITEM_LIST_PRICE = l_status_Update_tbl(i).Update_Status
144: ,object_version_number = object_version_number + 1
145: ,last_update_date = sysdate
146: ,last_updated_by = l_exe_update_rec.Last_Updated_By

Line 151: UPDATE dpp_transaction_lines_all

147: WHERE transaction_header_id = l_EXE_UPDATE_rec.Transaction_Header_ID
148: AND transaction_line_id = l_status_Update_tbl(i).transaction_line_id;
149:
150: ELSIF l_process_code = 'INPL' THEN
151: UPDATE dpp_transaction_lines_all
152: SET NOTIFY_INBOUND_PRICELIST = l_status_Update_tbl(i).Update_Status
153: ,object_version_number = object_version_number + 1
154: ,last_update_date = sysdate
155: ,last_updated_by = l_exe_update_rec.Last_Updated_By

Line 160: UPDATE dpp_transaction_lines_all

156: WHERE transaction_header_id = l_EXE_UPDATE_rec.Transaction_Header_ID
157: AND transaction_line_id = l_status_Update_tbl(i).transaction_line_id;
158:
159: ELSIF l_process_code = 'OUTPL' THEN
160: UPDATE dpp_transaction_lines_all
161: SET NOTIFY_OUTBOUND_PRICELIST = l_status_Update_tbl(i).Update_Status
162: ,object_version_number = object_version_number + 1
163: ,last_update_date = sysdate
164: ,last_updated_by = l_exe_update_rec.Last_Updated_By

Line 169: UPDATE dpp_transaction_lines_all

165: WHERE transaction_header_id = l_EXE_UPDATE_rec.Transaction_Header_ID
166: AND transaction_line_id = l_status_Update_tbl(i).transaction_line_id;
167:
168: ELSIF l_process_code = 'DSTRINVCL' THEN
169: UPDATE dpp_transaction_lines_all
170: SET supp_dist_claim_status = l_status_Update_tbl(i).Update_Status
171: ,object_version_number = object_version_number + 1
172: ,last_update_date = sysdate
173: ,last_updated_by = l_exe_update_rec.Last_Updated_By

Line 196: UPDATE dpp_transaction_lines_all

192: WHERE transaction_header_id = l_EXE_UPDATE_rec.Transaction_Header_ID
193: AND customer_inv_line_id = l_status_Update_tbl(i).transaction_line_id;
194:
195: ELSIF l_process_code = 'PROMO' THEN
196: UPDATE dpp_transaction_lines_all
197: SET NOTIFY_PROMOTIONS_PRICELIST = l_status_Update_tbl(i).Update_Status
198: ,object_version_number = object_version_number + 1
199: ,last_update_date = sysdate
200: ,last_updated_by = l_exe_update_rec.Last_Updated_By