eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPACIT dependencies on MTL_TXN_COST_DET_INTERFACE

Line 34: FROM MTL_TXN_COST_DET_INTERFACE

30: cost_det_validate_error EXCEPTION;
31:
32: cursor cost_elmt_ids is
33: SELECT COST_ELEMENT_ID
34: FROM MTL_TXN_COST_DET_INTERFACE
35: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
36:
37: begin
38: /*

Line 69: FROM MTL_TXN_COST_DET_INTERFACE

65:
66:
67: SELECT count(*)
68: INTO l_num_detail
69: FROM MTL_TXN_COST_DET_INTERFACE
70: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
71:
72: l_stmt_num := 10;
73:

Line 75: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE

71:
72: l_stmt_num := 10;
73:
74:
75: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE
76: * OR i_txn_interface_id is null.
77: * In this case, skip the validation of row in MTL_TXN_COST_DET_INTERFACE.
78: */
79:

Line 77: * In this case, skip the validation of row in MTL_TXN_COST_DET_INTERFACE.

73:
74:
75: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE
76: * OR i_txn_interface_id is null.
77: * In this case, skip the validation of row in MTL_TXN_COST_DET_INTERFACE.
78: */
79:
80:
81: if (l_num_detail = 0) then

Line 107: /* Matching row does exist in MTL_TXN_COST_DET_INTERFACE so

103:
104:
105:
106: elsif (l_num_detail > 0) then
107: /* Matching row does exist in MTL_TXN_COST_DET_INTERFACE so
108: * validate the values.
109: */
110:
111: l_stmt_num := 15;

Line 117: mtl_txn_cost_det_interface mtcdi

113: SELECT count(*)
114: INTO l_err_num
115: FROM mtl_parameters mp,
116: hr_all_organization_units_tl haout,
117: mtl_txn_cost_det_interface mtcdi
118: WHERE mp.organization_id = i_org_id
119: AND haout.organization_id = mp.organization_id
120: AND haout.LANGUAGE = userenv('LANG')
121: AND mtcdi.transaction_interface_id = i_txn_interface_id

Line 143: MTL_TXN_COST_DET_INTERFACE MTCDI

139:
140: SELECT count(*)
141: INTO l_err_num
142: FROM CST_COST_ELEMENTS CCE,
143: MTL_TXN_COST_DET_INTERFACE MTCDI
144: WHERE MTCDI.TRANSACTION_INTERFACE_ID = i_txn_interface_id
145: AND CCE.COST_ELEMENT_ID = NVL(MTCDI.COST_ELEMENT_ID, CCE.COST_ELEMENT_ID)
146: AND CCE.COST_ELEMENT = NVL(MTCDI.COST_ELEMENT, CCE.COST_ELEMENT)
147: AND (MTCDI.COST_ELEMENT_ID IS NOT NULL OR

Line 167: MTL_TXN_COST_DET_INTERFACE MTCDI

163:
164: SELECT count(*)
165: INTO l_err_num
166: FROM MFG_LOOKUPS ML,
167: MTL_TXN_COST_DET_INTERFACE MTCDI
168: WHERE MTCDI.TRANSACTION_INTERFACE_ID = i_txn_interface_id
169: AND ML.LOOKUP_TYPE = 'CST_LEVEL'
170: AND ML.LOOKUP_CODE = NVL(MTCDI.LEVEL_TYPE, ML.LOOKUP_CODE)
171: AND ML.MEANING = NVL(MTCDI.LEVEL_NAME, ML.MEANING)

Line 191: FROM MTL_TXN_COST_DET_INTERFACE

187: l_stmt_num := 40;
188:
189: SELECT count(*)
190: INTO l_err_num
191: FROM MTL_TXN_COST_DET_INTERFACE
192: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id
193: AND NOT ((NEW_AVERAGE_COST >= 0 AND -- Bug 4759820
194: (PERCENTAGE_CHANGE IS NULL AND VALUE_CHANGE IS NULL)) OR
195: (PERCENTAGE_CHANGE >= -100 AND

Line 215: UPDATE MTL_TXN_COST_DET_INTERFACE MTCDI

211:
212:
213: l_stmt_num := 50;
214:
215: UPDATE MTL_TXN_COST_DET_INTERFACE MTCDI
216: SET ORGANIZATION_ID = i_org_id
217: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id
218: AND ORGANIZATION_ID IS NULL;
219:

Line 221: UPDATE MTL_TXN_COST_DET_INTERFACE MTCDI

217: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id
218: AND ORGANIZATION_ID IS NULL;
219:
220:
221: UPDATE MTL_TXN_COST_DET_INTERFACE MTCDI
222: SET COST_ELEMENT_ID =
223: (SELECT CCE.COST_ELEMENT_ID
224: FROM CST_COST_ELEMENTS CCE
225: WHERE CCE.COST_ELEMENT = NVL(MTCDI.COST_ELEMENT, CCE.COST_ELEMENT))

Line 230: UPDATE MTL_TXN_COST_DET_INTERFACE MTCDI

226: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id
227: AND COST_ELEMENT_ID IS NULL;
228:
229:
230: UPDATE MTL_TXN_COST_DET_INTERFACE MTCDI
231: SET LEVEL_TYPE =
232: (SELECT ML.LOOKUP_CODE
233: FROM MFG_LOOKUPS ML
234: WHERE ML.LOOKUP_TYPE = 'CST_LEVEL'

Line 245: FROM MTL_TXN_COST_DET_INTERFACE

241: l_stmt_num := 60;
242:
243: SELECT count(*)
244: INTO l_err_num
245: FROM MTL_TXN_COST_DET_INTERFACE
246: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id
247: AND ORGANIZATION_ID = i_org_id;
248:
249: if (l_err_num = 0) then

Line 287: end if; -- END if for detail rows exist in MTL_TXN_COST_DET_INTERFACE

283:
284: end loop;
285:
286:
287: end if; -- END if for detail rows exist in MTL_TXN_COST_DET_INTERFACE
288:
289:
290: EXCEPTION
291: when cost_det_validate_error then

Line 353: FROM MTL_TXN_COST_DET_INTERFACE

349: o_err_msg := '';
350:
351: SELECT count(*)
352: INTO l_num_detail
353: FROM MTL_TXN_COST_DET_INTERFACE
354: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
355:
356: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE
357: * OR i_txn_interface_id is null.

Line 356: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE

352: INTO l_num_detail
353: FROM MTL_TXN_COST_DET_INTERFACE
354: WHERE TRANSACTION_INTERFACE_ID = i_txn_interface_id;
355:
356: /* l_num_detail = 0 : No corresponding rows in MTL_TXN_COST_DET_INTERFACE
357: * OR i_txn_interface_id is null.
358: * In this case, call cstpacit.cost_det_new_insert.
359: */
360:

Line 440: from MTL_TXN_COST_DET_INTERFACE mtcdi

436: (select
437: mtcdi.VALUE_CHANGE,
438: mtcdi.PERCENTAGE_CHANGE,
439: mtcdi.NEW_AVERAGE_COST
440: from MTL_TXN_COST_DET_INTERFACE mtcdi
441: where mtcdi.TRANSACTION_INTERFACE_ID = i_txn_interface_id
442: and mctcd.transaction_id = i_txn_id
443: and mtcdi.level_type = mctcd.level_type
444: and mtcdi.cost_element_id = mctcd.cost_element_id

Line 449: from MTL_TXN_COST_DET_INTERFACE mtcdi

445: )
446: where
447: mctcd.transaction_id = i_txn_id
448: and exists (select 1
449: from MTL_TXN_COST_DET_INTERFACE mtcdi
450: where mtcdi.TRANSACTION_INTERFACE_ID = i_txn_interface_id
451: and mtcdi.level_type = mctcd.level_type
452: and mtcdi.cost_element_id = mctcd.cost_element_id);
453: /*Added for Bug#2509196*/

Line 494: FROM MTL_TXN_COST_DET_INTERFACE MTCDI

490: i_request_id,
491: i_prog_appl_id,
492: i_prog_id,
493: sysdate
494: FROM MTL_TXN_COST_DET_INTERFACE MTCDI
495: WHERE mtcdi.TRANSACTION_INTERFACE_ID = i_txn_interface_id
496: and ( (MTCDI.cost_element_id, MTCDI.level_type) not in
497: (select mctcd1.cost_element_id,mctcd1.level_type
498: from mtl_cst_txn_cost_details mctcd1

Line 586: FROM MTL_TXN_COST_DET_INTERFACE MTCDI

582: i_request_id,
583: i_prog_appl_id,
584: i_prog_id,
585: sysdate
586: FROM MTL_TXN_COST_DET_INTERFACE MTCDI
587: WHERE mtcdi.TRANSACTION_INTERFACE_ID = i_txn_interface_id;
588:
589: end if; /* if layer exists */
590: