APPS.INV_COST_GROUP_PVT dependencies on MTL_INTERORG_PARAMETERS

Line 147: l_interorg_xfer_code mtl_interorg_parameters.matl_interorg_transfer_code%type;

143: , x_return_status OUT NOCOPY VARCHAR2
144: , x_msg_count OUT NOCOPY NUMBER
145: , x_msg_data OUT NOCOPY VARCHAR2
146: ) IS
147: l_interorg_xfer_code mtl_interorg_parameters.matl_interorg_transfer_code%type;
148: l_interorg_charge_prct mtl_interorg_parameters.interorg_trnsfr_charge_percent%type;
149: l_transfer_cost NUMBER ;
150: l_item_cost NUMBER := 0 ;
151: l_item_id NUMBER ;

Line 148: l_interorg_charge_prct mtl_interorg_parameters.interorg_trnsfr_charge_percent%type;

144: , x_msg_count OUT NOCOPY NUMBER
145: , x_msg_data OUT NOCOPY VARCHAR2
146: ) IS
147: l_interorg_xfer_code mtl_interorg_parameters.matl_interorg_transfer_code%type;
148: l_interorg_charge_prct mtl_interorg_parameters.interorg_trnsfr_charge_percent%type;
149: l_transfer_cost NUMBER ;
150: l_item_cost NUMBER := 0 ;
151: l_item_id NUMBER ;
152: l_org_id NUMBER ;

Line 197: FROM mtl_interorg_parameters

193: END IF;
194:
195: SELECT NVL(matl_interorg_transfer_code,1) , interorg_trnsfr_charge_percent
196: INTO l_interorg_xfer_code , l_interorg_charge_prct
197: FROM mtl_interorg_parameters
198: WHERE from_organization_id = l_org_id
199: AND to_organization_id = l_xfer_org_id ;
200:
201: IF (l_interorg_xfer_code NOT IN (4, 3 ) ) THEN

Line 275: l_fob_point mtl_interorg_parameters.fob_point%TYPE;

271: l_organization_id NUMBER;
272: l_cost_Group_id NUMBER;
273: l_transfer_cost_Group_id NUMBER;
274: l_process_txn VARCHAR2(1) := 'Y';
275: l_fob_point mtl_interorg_parameters.fob_point%TYPE;
276: l_to_project_id NUMBER := NULL;
277: l_comingling_occurs VARCHAR2(1) := 'N';
278: cursor trx_cursor is
279: select mmtt.*

Line 377: ,p_fob_point IN mtl_interorg_parameters.fob_point%TYPE DEFAULT NULL

373: ,x_msg_count OUT NOCOPY NUMBER
374: ,x_msg_data OUT NOCOPY VARCHAR2
375: ,p_organization_id IN NUMBER
376: ,p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE DEFAULT NULL
377: ,p_fob_point IN mtl_interorg_parameters.fob_point%TYPE DEFAULT NULL
378: ,p_line_id IN NUMBER
379: ,p_input_type IN VARCHAR2
380: ,x_cost_group_id OUT NOCOPY NUMBER
381: ,x_transfer_cost_group_id OUT NOCOPY NUMBER

Line 404: l_fob_point mtl_interorg_parameters.fob_point%TYPE := p_mmtt_rec.fob_point;

400: l_to_locator_id NUMBER := null;
401:
402: l_process_txn VARCHAR2(1) := 'Y';
403: l_comingling_occurs VARCHAR2(1) := 'N';
404: l_fob_point mtl_interorg_parameters.fob_point%TYPE := p_mmtt_rec.fob_point;
405: --assign mmttvalue to variable FOB_POINT Changes
406: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
407: BEGIN
408:

Line 506: FROM mtl_interorg_parameters

502:
503: BEGIN
504: SELECT fob_point
505: INTO l_fob_point
506: FROM mtl_interorg_parameters
507: WHERE from_organization_id =
508: Decode(p_mmtt_rec.transaction_action_id,
509: inv_globals.g_action_intransitreceipt,
510: p_mmtt_rec.transfer_organization,