APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_SUP_INSTANCE_VALUE

Line 5249: FROM aso_sup_instance_value

5245: CURSOR get_values (
5246: temp_instance_id NUMBER
5247: ) IS
5248: SELECT sect_comp_map_id, VALUE, value_type_qualifier, response_id
5249: FROM aso_sup_instance_value
5250: WHERE template_instance_id = temp_instance_id;
5251:
5252: l_old_template_instance_id NUMBER;
5253: l_new_template_instance_id NUMBER;

Line 5340: -- Create a new row in the ASO_SUP_INSTANCE_VALUE table

5336: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5337: aso_debug_pub.ADD ( 'Inserting a row into instance_value table' , 1 , 'N' );
5338: END IF;
5339:
5340: -- Create a new row in the ASO_SUP_INSTANCE_VALUE table
5341: ASO_SUP_INSTANCE_VALUE_PKG.INSERT_ROW (
5342: PX_ROWID => l_sup_instance_rowid
5343: , PX_INSTANCE_VALUE_ID => l_instance_value_id
5344: , P_SECT_COMP_MAP_ID => inst_val.sect_comp_map_id

Line 5341: ASO_SUP_INSTANCE_VALUE_PKG.INSERT_ROW (

5337: aso_debug_pub.ADD ( 'Inserting a row into instance_value table' , 1 , 'N' );
5338: END IF;
5339:
5340: -- Create a new row in the ASO_SUP_INSTANCE_VALUE table
5341: ASO_SUP_INSTANCE_VALUE_PKG.INSERT_ROW (
5342: PX_ROWID => l_sup_instance_rowid
5343: , PX_INSTANCE_VALUE_ID => l_instance_value_id
5344: , P_SECT_COMP_MAP_ID => inst_val.sect_comp_map_id
5345: , P_Template_Instance_ID => l_new_template_instance_id

Line 6789: FROM aso_sup_instance_value

6785: CURSOR get_values (
6786: temp_instance_id NUMBER
6787: ) IS
6788: SELECT sect_comp_map_id, VALUE, value_type_qualifier, response_id
6789: FROM aso_sup_instance_value
6790: WHERE template_instance_id = temp_instance_id;
6791:
6792: l_old_template_instance_id NUMBER;
6793: l_new_template_instance_id NUMBER;

Line 6882: -- Create a new row in the ASO_SUP_INSTANCE_VALUE table

6878: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6879: aso_debug_pub.ADD ( 'Inserting a row into instance_value table' , 1 , 'N' );
6880: END IF;
6881:
6882: -- Create a new row in the ASO_SUP_INSTANCE_VALUE table
6883: ASO_SUP_INSTANCE_VALUE_PKG.INSERT_ROW (
6884: PX_ROWID => l_sup_instance_rowid
6885: , PX_INSTANCE_VALUE_ID => l_instance_value_id
6886: , P_SECT_COMP_MAP_ID => inst_val.sect_comp_map_id

Line 6883: ASO_SUP_INSTANCE_VALUE_PKG.INSERT_ROW (

6879: aso_debug_pub.ADD ( 'Inserting a row into instance_value table' , 1 , 'N' );
6880: END IF;
6881:
6882: -- Create a new row in the ASO_SUP_INSTANCE_VALUE table
6883: ASO_SUP_INSTANCE_VALUE_PKG.INSERT_ROW (
6884: PX_ROWID => l_sup_instance_rowid
6885: , PX_INSTANCE_VALUE_ID => l_instance_value_id
6886: , P_SECT_COMP_MAP_ID => inst_val.sect_comp_map_id
6887: , P_Template_Instance_ID => l_new_template_instance_id