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.AHL_UC_INSTANCE_PVT dependencies on FND_LOOKUP_VALUES

Line 391: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

387: l_transaction_type_id NUMBER;
388: l_return_value BOOLEAN;
389: l_root_uc_header_id NUMBER;
390: l_root_instance_id NUMBER;
391: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
392: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
393: l_root_uc_ovn NUMBER;
394: l_end_date DATE;
395: CURSOR check_uc_header IS

Line 392: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

388: l_return_value BOOLEAN;
389: l_root_uc_header_id NUMBER;
390: l_root_instance_id NUMBER;
391: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
392: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
393: l_root_uc_ovn NUMBER;
394: l_end_date DATE;
395: CURSOR check_uc_header IS
396: SELECT unit_config_header_id,

Line 721: l_position_necessity FND_LOOKUP_VALUES.lookup_code%TYPE;

717: l_object_id NUMBER;
718: l_csi_relationship_id NUMBER;
719: l_object_version_number NUMBER;
720: l_position_reference csi_ii_relationships.position_reference%TYPE;
721: l_position_necessity FND_LOOKUP_VALUES.lookup_code%TYPE;
722: l_transaction_type_id NUMBER;
723: l_return_value BOOLEAN;
724: l_dummy_num NUMBER;
725: l_sub_uc_header_id NUMBER;

Line 728: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

724: l_dummy_num NUMBER;
725: l_sub_uc_header_id NUMBER;
726: l_root_uc_header_id NUMBER;
727: l_root_instance_id NUMBER;
728: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
729: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
730: l_root_uc_ovn NUMBER;
731: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
732: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 729: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

725: l_sub_uc_header_id NUMBER;
726: l_root_uc_header_id NUMBER;
727: l_root_instance_id NUMBER;
728: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
729: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
730: l_root_uc_ovn NUMBER;
731: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
732: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
733: CURSOR check_uc_header IS

Line 731: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

727: l_root_instance_id NUMBER;
728: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
729: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
730: l_root_uc_ovn NUMBER;
731: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
732: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
733: CURSOR check_uc_header IS
734: SELECT unit_config_header_id,
735: object_version_number,

Line 732: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

728: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
729: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
730: l_root_uc_ovn NUMBER;
731: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
732: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
733: CURSOR check_uc_header IS
734: SELECT unit_config_header_id,
735: object_version_number,
736: unit_config_status_code,

Line 1304: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

1300: l_uc_status_code VARCHAR2(30);
1301: l_active_uc_status_code VARCHAR2(30);
1302: l_root_uc_header_id NUMBER;
1303: l_root_instance_id NUMBER;
1304: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1305: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1306: l_root_uc_ovn NUMBER;
1307: l_return_val BOOLEAN;
1308: l_attribute_value_id NUMBER;

Line 1305: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

1301: l_active_uc_status_code VARCHAR2(30);
1302: l_root_uc_header_id NUMBER;
1303: l_root_instance_id NUMBER;
1304: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1305: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
1306: l_root_uc_ovn NUMBER;
1307: l_return_val BOOLEAN;
1308: l_attribute_value_id NUMBER;
1309: l_attribute_value csi_iea_values.attribute_value%TYPE;

Line 2259: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

2255: l_position_id NUMBER := NULL;
2256: l_parent_relationship_id NUMBER;
2257: l_root_uc_header_id NUMBER;
2258: l_root_instance_id NUMBER;
2259: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
2260: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
2261: l_root_uc_ovn NUMBER;
2262: l_root_instance_ou NUMBER;
2263: l_new_instance_ou NUMBER;

Line 2260: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

2256: l_parent_relationship_id NUMBER;
2257: l_root_uc_header_id NUMBER;
2258: l_root_instance_id NUMBER;
2259: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
2260: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
2261: l_root_uc_ovn NUMBER;
2262: l_root_instance_ou NUMBER;
2263: l_new_instance_ou NUMBER;
2264: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 2264: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

2260: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
2261: l_root_uc_ovn NUMBER;
2262: l_root_instance_ou NUMBER;
2263: l_new_instance_ou NUMBER;
2264: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
2265: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
2266: l_dummy NUMBER;
2267: l_dummy_char VARCHAR2(1);
2268: i NUMBER := 0;

Line 2265: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

2261: l_root_uc_ovn NUMBER;
2262: l_root_instance_ou NUMBER;
2263: l_new_instance_ou NUMBER;
2264: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
2265: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
2266: l_dummy NUMBER;
2267: l_dummy_char VARCHAR2(1);
2268: i NUMBER := 0;
2269: l_transaction_type_id NUMBER;

Line 3345: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

3341: l_parent_uc_header_id NUMBER;
3342: l_parent_instance_id NUMBER;
3343: l_root_uc_header_id NUMBER;
3344: l_root_instance_id NUMBER;
3345: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3346: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3347: l_root_uc_ovn NUMBER;
3348: l_root_instance_ou NUMBER;
3349: l_instance_ou NUMBER;

Line 3346: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

3342: l_parent_instance_id NUMBER;
3343: l_root_uc_header_id NUMBER;
3344: l_root_instance_id NUMBER;
3345: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3346: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3347: l_root_uc_ovn NUMBER;
3348: l_root_instance_ou NUMBER;
3349: l_instance_ou NUMBER;
3350: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 3350: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

3346: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3347: l_root_uc_ovn NUMBER;
3348: l_root_instance_ou NUMBER;
3349: l_instance_ou NUMBER;
3350: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3351: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3352: l_position_ref_meaning fnd_lookups.meaning%TYPE;
3353: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3354: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;

Line 3351: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

3347: l_root_uc_ovn NUMBER;
3348: l_root_instance_ou NUMBER;
3349: l_instance_ou NUMBER;
3350: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3351: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3352: l_position_ref_meaning fnd_lookups.meaning%TYPE;
3353: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3354: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;
3355:

Line 5049: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,

5045: ) root_uc_header_id,
5046: U.csi_item_instance_id csi_instance_id,
5047: U.active_end_date active_end_date
5048: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,
5049: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,
5050: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC
5051: WHERE U.master_config_id = M.mc_header_id AND
5052: M.mc_header_id = R.mc_header_id AND
5053: R.parent_relationship_id IS NULL AND

Line 5050: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC

5046: U.csi_item_instance_id csi_instance_id,
5047: U.active_end_date active_end_date
5048: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,
5049: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,
5050: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC
5051: WHERE U.master_config_id = M.mc_header_id AND
5052: M.mc_header_id = R.mc_header_id AND
5053: R.parent_relationship_id IS NULL AND
5054: U.unit_config_status_code = UCSC.lookup_code AND

Line 5104: l_status fnd_lookup_values_vl.meaning%TYPE;

5100: j NUMBER;
5101: l_dummy_char VARCHAR2(1);
5102: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
5103: l_top_instance_id NUMBER;
5104: l_status fnd_lookup_values_vl.meaning%TYPE;
5105: l_msg_count NUMBER;
5106:
5107: BEGIN
5108:

Line 5311: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV

5307: FROM ahl_unit_config_headers_v
5308: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
5309: */
5310: SELECT FLV.meaning INTO l_status
5311: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV
5312: WHERE AUCH.unit_config_header_id = l_instance_details_rec.root_uc_header_id AND
5313: AUCH.unit_config_status_code = FLV.lookup_code AND
5314: FLV.lookup_type = 'AHL_CONFIG_STATUS' AND
5315: FLV.language = USERENV('LANG');

Line 5463: l_status fnd_lookup_values_vl.meaning%TYPE;

5459: j NUMBER;
5460: l_dummy_char VARCHAR2(1);
5461: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
5462: l_top_instance_id NUMBER;
5463: l_status fnd_lookup_values_vl.meaning%TYPE;
5464: l_ignore_quant_vald VARCHAR2(1);
5465:
5466: -- SATHAPLI Bug# 4912576 fix
5467: -- Code pertaining to Org check has been removed from here

Line 5784: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,

5780: ) root_uc_header_id,
5781: U.csi_item_instance_id csi_instance_id,
5782: U.active_end_date active_end_date
5783: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,
5784: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,
5785: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC
5786: WHERE U.master_config_id = M.mc_header_id AND
5787: M.mc_header_id = R.mc_header_id AND
5788: R.parent_relationship_id IS NULL AND

Line 5785: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC

5781: U.csi_item_instance_id csi_instance_id,
5782: U.active_end_date active_end_date
5783: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,
5784: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,
5785: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC
5786: WHERE U.master_config_id = M.mc_header_id AND
5787: M.mc_header_id = R.mc_header_id AND
5788: R.parent_relationship_id IS NULL AND
5789: U.unit_config_status_code = UCSC.lookup_code AND

Line 6100: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV

6096: FROM ahl_unit_config_headers_v
6097: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
6098: */
6099: SELECT FLV.meaning INTO l_status
6100: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV
6101: WHERE AUCH.unit_config_header_id = l_instance_details_rec.root_uc_header_id AND
6102: AUCH.unit_config_status_code = FLV.lookup_code AND
6103: FLV.lookup_type = 'AHL_CONFIG_STATUS' AND
6104: FLV.language = USERENV('LANG');