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 3335: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

3331: l_parent_uc_header_id NUMBER;
3332: l_parent_instance_id NUMBER;
3333: l_root_uc_header_id NUMBER;
3334: l_root_instance_id NUMBER;
3335: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3336: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3337: l_root_uc_ovn NUMBER;
3338: l_root_instance_ou NUMBER;
3339: l_instance_ou NUMBER;

Line 3336: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

3332: l_parent_instance_id NUMBER;
3333: l_root_uc_header_id NUMBER;
3334: l_root_instance_id NUMBER;
3335: l_root_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3336: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3337: l_root_uc_ovn NUMBER;
3338: l_root_instance_ou NUMBER;
3339: l_instance_ou NUMBER;
3340: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 3340: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

3336: l_root_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3337: l_root_uc_ovn NUMBER;
3338: l_root_instance_ou NUMBER;
3339: l_instance_ou NUMBER;
3340: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3341: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3342: l_position_ref_meaning fnd_lookups.meaning%TYPE;
3343: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3344:

Line 3341: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;

3337: l_root_uc_ovn NUMBER;
3338: l_root_instance_ou NUMBER;
3339: l_instance_ou NUMBER;
3340: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3341: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3342: l_position_ref_meaning fnd_lookups.meaning%TYPE;
3343: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3344:
3345: --Variables needed for CSI API call

Line 5009: l_status fnd_lookup_values_vl.meaning%TYPE;

5005: j NUMBER;
5006: l_dummy_char VARCHAR2(1);
5007: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
5008: l_top_instance_id NUMBER;
5009: l_status fnd_lookup_values_vl.meaning%TYPE;
5010: l_msg_count NUMBER;
5011:
5012: BEGIN
5013:

Line 5358: l_status fnd_lookup_values_vl.meaning%TYPE;

5354: j NUMBER;
5355: l_dummy_char VARCHAR2(1);
5356: l_top_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
5357: l_top_instance_id NUMBER;
5358: l_status fnd_lookup_values_vl.meaning%TYPE;
5359: l_ignore_quant_vald VARCHAR2(1);
5360:
5361: -- SATHAPLI Bug# 4912576 fix
5362: -- Code pertaining to Org check has been removed from here

Line 5677: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,

5673: ) root_uc_header_id,
5674: U.csi_item_instance_id csi_instance_id,
5675: U.active_end_date active_end_date
5676: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,
5677: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,
5678: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC
5679: WHERE U.master_config_id = M.mc_header_id AND
5680: M.mc_header_id = R.mc_header_id AND
5681: R.parent_relationship_id IS NULL AND

Line 5678: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC

5674: U.csi_item_instance_id csi_instance_id,
5675: U.active_end_date active_end_date
5676: FROM AHL_UNIT_CONFIG_HEADERS U, AHL_MC_HEADERS_B M,
5677: AHL_MC_RELATIONSHIPS R, FND_LOOKUP_VALUES UCSC,
5678: FND_LOOKUP_VALUES MRSC, FND_LOOKUP_VALUES MCSC
5679: WHERE U.master_config_id = M.mc_header_id AND
5680: M.mc_header_id = R.mc_header_id AND
5681: R.parent_relationship_id IS NULL AND
5682: U.unit_config_status_code = UCSC.lookup_code AND

Line 5993: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV

5989: FROM ahl_unit_config_headers_v
5990: WHERE uc_header_id = l_instance_details_rec.root_uc_header_id;
5991: */
5992: SELECT FLV.meaning INTO l_status
5993: FROM AHL_UNIT_CONFIG_HEADERS AUCH, FND_LOOKUP_VALUES FLV
5994: WHERE AUCH.unit_config_header_id = l_instance_details_rec.root_uc_header_id AND
5995: AUCH.unit_config_status_code = FLV.lookup_code AND
5996: FLV.lookup_type = 'AHL_CONFIG_STATUS' AND
5997: FLV.language = USERENV('LANG');