APPS.OKL_CONS_BILL dependencies on OKL_EXT_SELL_INVS_B

Line 142: UPDATE Okl_Ext_Sell_Invs_b

138: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Updating External Transaction Header');
139: END IF;
140: IF p_contract_number IS NULL THEN
141: FOR m in l_update_tbl.FIRST..l_update_tbl.LAST LOOP
142: UPDATE Okl_Ext_Sell_Invs_b
143: SET TRX_STATUS_CODE = 'WORKING',
144: XTRX_INVOICE_PULL_YN = 'Y',
145: last_update_date = sysdate,
146: last_updated_by = Fnd_Global.USER_ID,

Line 152: UPDATE Okl_Ext_Sell_Invs_b

148: WHERE id = l_update_tbl(m).xsi_id;
149: END LOOP;
150: ELSE
151: FOR m in l_update_tbl.FIRST..l_update_tbl.LAST LOOP
152: UPDATE Okl_Ext_Sell_Invs_b
153: SET TRX_STATUS_CODE = 'ENTERED',
154: XTRX_INVOICE_PULL_YN = 'Y',
155: last_update_date = sysdate,
156: last_updated_by = Fnd_Global.USER_ID,

Line 2981: UPDATE Okl_Ext_Sell_Invs_b

2977: -- -------------------------------------------
2978: l_xsiv_rec.TRX_STATUS_CODE := 'ENTERED';
2979: END IF;
2980:
2981: UPDATE Okl_Ext_Sell_Invs_b
2982: SET TRX_STATUS_CODE = l_xsiv_rec.TRX_STATUS_CODE,
2983: XTRX_INVOICE_PULL_YN = 'Y'
2984: WHERE id = cnr_update_tbl(cnr_tab_idx).xsi_id;
2985:

Line 3101: UPDATE okl_ext_sell_invs_b

3097: WHERE id = l_xlsv_rec.id;
3098:
3099: ELSE-- CNR entries not created
3100:
3101: UPDATE okl_ext_sell_invs_b
3102: SET trx_status_code = 'ERROR'
3103: WHERE id = cnr_update_tbl(cnr_tab_idx).xsi_id;
3104:
3105: END IF; -- CNR entries not created