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.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_T_TXN_LINE_DETAILS

Line 133: FROM csi_t_txn_line_details

129: BEGIN
130:
131: SELECT 'X'
132: INTO l_found
133: FROM csi_t_txn_line_details
134: WHERE txn_line_detail_id = p_txn_line_detail_id;
135:
136: x_return_status := fnd_api.g_ret_sts_success;
137:

Line 164: FROM csi_t_txn_line_details

160: processing_status,
161: config_inst_hdr_id,
162: config_inst_rev_num,
163: config_inst_item_id
164: FROM csi_t_txn_line_details
165: WHERE txn_line_detail_id = p_txn_line_dtl_id;
166:
167: l_txn_line_detail_rec txn_line_dtl_cur%rowtype;
168: BEGIN

Line 350: FROM csi_t_txn_line_details

346: l_processed_found BOOLEAN := FALSE;
347:
348: CURSOR proc_cur IS
349: SELECT 'X'
350: FROM csi_t_txn_line_details
351: WHERE transaction_line_id = p_transaction_line_id
352: AND (csi_transaction_id is not null
353: OR
354: processing_status = 'PROCESSED');

Line 384: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;

380: p_txn_line_dtl_id IN NUMBER,
381: x_return_status OUT NOCOPY VARCHAR2)
382: IS
383:
384: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
385: l_instance_id csi_t_txn_line_details.instance_id%TYPE;
386: l_inventory_item_id csi_t_txn_line_details.inventory_item_id%TYPE;
387: l_inv_organization_id csi_t_txn_line_details.inv_organization_id%TYPE;
388:

Line 385: l_instance_id csi_t_txn_line_details.instance_id%TYPE;

381: x_return_status OUT NOCOPY VARCHAR2)
382: IS
383:
384: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
385: l_instance_id csi_t_txn_line_details.instance_id%TYPE;
386: l_inventory_item_id csi_t_txn_line_details.inventory_item_id%TYPE;
387: l_inv_organization_id csi_t_txn_line_details.inv_organization_id%TYPE;
388:
389: l_subject_id NUMBER;

Line 386: l_inventory_item_id csi_t_txn_line_details.inventory_item_id%TYPE;

382: IS
383:
384: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
385: l_instance_id csi_t_txn_line_details.instance_id%TYPE;
386: l_inventory_item_id csi_t_txn_line_details.inventory_item_id%TYPE;
387: l_inv_organization_id csi_t_txn_line_details.inv_organization_id%TYPE;
388:
389: l_subject_id NUMBER;
390:

Line 387: l_inv_organization_id csi_t_txn_line_details.inv_organization_id%TYPE;

383:
384: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
385: l_instance_id csi_t_txn_line_details.instance_id%TYPE;
386: l_inventory_item_id csi_t_txn_line_details.inventory_item_id%TYPE;
387: l_inv_organization_id csi_t_txn_line_details.inv_organization_id%TYPE;
388:
389: l_subject_id NUMBER;
390:
391: BEGIN

Line 403: FROM csi_t_txn_line_details

399: INTO l_instance_exists_flag,
400: l_instance_id,
401: l_inventory_item_id,
402: l_inv_organization_id
403: FROM csi_t_txn_line_details
404: WHERE txn_line_detail_id = p_txn_line_dtl_id;
405:
406: IF l_instance_exists_flag = 'Y' THEN
407: l_subject_id := l_instance_id;

Line 568: l_dtl_item_id csi_t_txn_line_details.inventory_item_id%type;

564: l_inst_organization_id csi_item_instances.inv_organization_id%type;
565: l_inst_quantity csi_item_instances.quantity%type;
566: l_inst_uom_code csi_item_instances.unit_of_measure%type;
567:
568: l_dtl_item_id csi_t_txn_line_details.inventory_item_id%type;
569: l_dtl_organization_id csi_t_txn_line_details.inv_organization_id%type;
570: l_dtl_quantity csi_t_txn_line_details.quantity%type;
571: l_dtl_uom_code csi_t_txn_line_details.unit_of_measure%type;
572: l_dtl_primary_qty NUMBER;

Line 569: l_dtl_organization_id csi_t_txn_line_details.inv_organization_id%type;

565: l_inst_quantity csi_item_instances.quantity%type;
566: l_inst_uom_code csi_item_instances.unit_of_measure%type;
567:
568: l_dtl_item_id csi_t_txn_line_details.inventory_item_id%type;
569: l_dtl_organization_id csi_t_txn_line_details.inv_organization_id%type;
570: l_dtl_quantity csi_t_txn_line_details.quantity%type;
571: l_dtl_uom_code csi_t_txn_line_details.unit_of_measure%type;
572: l_dtl_primary_qty NUMBER;
573:

Line 570: l_dtl_quantity csi_t_txn_line_details.quantity%type;

566: l_inst_uom_code csi_item_instances.unit_of_measure%type;
567:
568: l_dtl_item_id csi_t_txn_line_details.inventory_item_id%type;
569: l_dtl_organization_id csi_t_txn_line_details.inv_organization_id%type;
570: l_dtl_quantity csi_t_txn_line_details.quantity%type;
571: l_dtl_uom_code csi_t_txn_line_details.unit_of_measure%type;
572: l_dtl_primary_qty NUMBER;
573:
574: l_src_param_rec csi_t_ui_pvt.txn_source_param_rec;

Line 571: l_dtl_uom_code csi_t_txn_line_details.unit_of_measure%type;

567:
568: l_dtl_item_id csi_t_txn_line_details.inventory_item_id%type;
569: l_dtl_organization_id csi_t_txn_line_details.inv_organization_id%type;
570: l_dtl_quantity csi_t_txn_line_details.quantity%type;
571: l_dtl_uom_code csi_t_txn_line_details.unit_of_measure%type;
572: l_dtl_primary_qty NUMBER;
573:
574: l_src_param_rec csi_t_ui_pvt.txn_source_param_rec;
575: l_src_rec csi_t_ui_pvt.txn_source_rec;

Line 1228: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;

1224: x_return_status OUT NOCOPY VARCHAR2)
1225: IS
1226:
1227: l_found VARCHAR2(1);
1228: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
1229: l_csi_instance_id csi_t_party_details.instance_party_id%TYPE;
1230:
1231: CURSOR csi_pty_cur(p_csi_instance_id IN NUMBER) IS
1232: SELECT instance_party_id

Line 1245: FROM csi_t_txn_line_details

1241: SELECT instance_exists_flag,
1242: instance_id
1243: INTO l_instance_exists_flag,
1244: l_csi_instance_id
1245: FROM csi_t_txn_line_details
1246: WHERE txn_line_detail_id = p_txn_line_detail_id;
1247:
1248: /* if an instance is referred, then look if the instance party is referred
1249: if the instance party is referred then skip the chk.

Line 1329: l_txn_line_dtl_id csi_t_txn_line_details.txn_line_detail_id%TYPE;

1325: x_processing_status OUT NOCOPY varchar2,
1326: x_return_status OUT NOCOPY varchar2)
1327: IS
1328:
1329: l_txn_line_dtl_id csi_t_txn_line_details.txn_line_detail_id%TYPE;
1330: l_transaction_line_id csi_t_transaction_lines.transaction_line_id%TYPE;
1331: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
1332:
1333: BEGIN

Line 1350: FROM csi_t_txn_line_details

1346: END IF;
1347:
1348: SELECT transaction_line_id
1349: INTO l_transaction_line_id
1350: FROM csi_t_txn_line_details
1351: WHERE txn_line_detail_id = l_txn_line_dtl_id;
1352:
1353: SELECT nvl(processing_status, '#NONE#')
1354: INTO l_processing_status

Line 1447: l_txn_line_dtl_id csi_t_txn_line_details.txn_line_detail_id%TYPE;

1443: x_instance_exists_flag OUT NOCOPY varchar2,
1444: x_return_status OUT NOCOPY varchar2)
1445: IS
1446:
1447: l_txn_line_dtl_id csi_t_txn_line_details.txn_line_detail_id%TYPE;
1448:
1449: BEGIN
1450:
1451: IF p_level in ('PARTY', 'II_RLTNS', 'EXT_ATTRIB', 'ORG_ASSGN') THEN

Line 1468: FROM csi_t_txn_line_details

1464: SELECT instance_id ,
1465: instance_exists_flag
1466: INTO x_instance_id,
1467: x_instance_exists_flag
1468: FROM csi_t_txn_line_details
1469: WHERE txn_line_detail_id = l_txn_line_dtl_id;
1470:
1471: x_return_status := fnd_api.g_ret_sts_success;
1472:

Line 1526: l_instance_id csi_t_txn_line_details.instance_id%TYPE;

1522: p_level_dtl_id IN number,
1523: p_level_inst_ref_id IN number,
1524: x_return_status OUT NOCOPY varchar2)
1525: IS
1526: l_instance_id csi_t_txn_line_details.instance_id%TYPE;
1527: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
1528: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1529:
1530: l_td_object_id number;

Line 1527: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;

1523: p_level_inst_ref_id IN number,
1524: x_return_status OUT NOCOPY varchar2)
1525: IS
1526: l_instance_id csi_t_txn_line_details.instance_id%TYPE;
1527: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
1528: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1529:
1530: l_td_object_id number;
1531: l_inst_object_id number;

Line 2382: FROM csi_t_txn_line_details

2378:
2379: CURSOR get_tld_id_cur
2380: IS
2381: SELECT txn_line_detail_id
2382: FROM csi_t_txn_line_details
2383: WHERE config_inst_hdr_id = p_config_inst_hdr_id
2384: AND config_inst_rev_num = p_config_inst_rev_num
2385: AND config_inst_item_id = p_config_inst_item_id ;
2386: