APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_SALES_TRANSACTIONS

Line 925: FROM ozf_sales_transactions_all trx

921:
922: CURSOR sales_transation_csr(p_line_id IN NUMBER) IS
923: SELECT 1 FROM DUAL WHERE EXISTS
924: ( SELECT 1
925: FROM ozf_sales_transactions_all trx
926: WHERE trx.line_id = p_line_id
927: AND source_code = 'OM');
928:
929: CURSOR c_adjustment_exists (p_list_header_id IN NUMBER, p_order_line_id IN NUMBER) IS

Line 1072: l_sales_transaction_rec OZF_SALES_TRANSACTIONS_PVT.SALES_TRANSACTION_REC_TYPE;

1068: l_last_pos NUMBER := 0;
1069: l_value VARCHAR2(1024);
1070: l_cntr NUMBER := 0;
1071: l_num_chars VARCHAR2(1024);
1072: l_sales_transaction_rec OZF_SALES_TRANSACTIONS_PVT.SALES_TRANSACTION_REC_TYPE;
1073: l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
1074: l_sales_transaction_id NUMBER;
1075: l_gl_date DATE;
1076: l_shipment_date DATE;

Line 1374: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0

1370: l_sales_transaction_rec.qp_list_header_id := p_list_header_id;
1371:
1372: write_conc_log('calling Create_Transaction');
1373:
1374: OZF_SALES_TRANSACTIONS_PVT.Create_Transaction(p_api_version => 1.0
1375: ,p_init_msg_list => FND_API.G_FALSE
1376: ,p_commit => FND_API.G_FALSE
1377: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1378: ,p_transaction_rec => l_sales_transaction_rec

Line 3960: FROM ozf_sales_transactions

3956:
3957: -- julou bug 6348078. cursor to get transaction_date for IDSM line.
3958: CURSOR c_trx_date(p_line_id NUMBER) IS
3959: SELECT transaction_date
3960: FROM ozf_sales_transactions
3961: WHERE source_code = 'IS'
3962: AND line_id = p_line_id;
3963:
3964: --Added for bug 7030415