APPS.OZF_REFRESH_SALES_PVT dependencies on OZF_SALES_TRANSACTIONS_ALL

Line 78: FROM ozf_sales_transactions_all

74: common_uom_code,
75: common_currency_code,
76: common_quantity,
77: common_amount
78: FROM ozf_sales_transactions_all
79: WHERE error_flag = 'Y'
80: AND SOURCE_CODE = 'OM';
81:
82: l_mesg VARCHAR2(2000);

Line 174: UPDATE ozf_sales_transactions_all

170: -- Process any error from the previous run
171:
172: ozf_utility_pvt.write_conc_log(' -- Updating errors from previous run., if any ');
173:
174: UPDATE ozf_sales_transactions_all
175: SET common_amount = gl_currency_api.convert_amount_sql(currency_code,
176: common_currency_code,
177: transaction_date,
178: l_curr_conv_type,

Line 211: INSERT INTO ozf_sales_transactions_all(

207:
208: ozf_utility_pvt.write_conc_log(' -- Inserting New transaction ');
209:
210: -- Insert
211: INSERT INTO ozf_sales_transactions_all(
212: SALES_TRANSACTION_ID ,
213: OBJECT_VERSION_NUMBER ,
214: LAST_UPDATE_DATE ,
215: LAST_UPDATED_BY ,

Line 249: SELECT ozf_sales_transactions_all_s.nextval,

245: TRANSFER_TYPE,
246: SOLD_TO_PARTY_ID,
247: SOLD_TO_PARTY_SITE_ID
248: )
249: SELECT ozf_sales_transactions_all_s.nextval,
250: 1,
251: SYSDATE,
252: FND_GLOBAL.user_id,
253: SYSDATE,

Line 343: FROM ozf_sales_transactions_all trx

339: /* Bug 5371613
340: Incremental load is not done by Funds Accrual Engine
341: This program will now be run only in full refresh mode for the first time
342: AND NOT EXISTS ( SELECT 1
343: FROM ozf_sales_transactions_all trx
344: WHERE trx.line_id = ln.line_id
345: AND source_code = 'OM' );
346: */
347:

Line 350: Get all records from ozf_sales_transactions_all with error_flag = 'Y'

346: */
347:
348: -- Log error messages here
349: /*
350: Get all records from ozf_sales_transactions_all with error_flag = 'Y'
351: converted_quantity = -9999 or converted_amount = -1
352: */
353:
354: ozf_utility_pvt.write_conc_log(' -- Currency and UOM conversion Errors -- ');

Line 465: DELETE FROM ozf_sales_transactions_all

461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462:
463: IF (NVL(p_increment_mode,'N') = 'N')
464: THEN
465: DELETE FROM ozf_sales_transactions_all
466: WHERE source_code = 'OM';
467: END IF;
468:
469: COMMIT;